%@ Page Language="vb" Debug="true" %>
<% @Import NameSpace="System.Data" %>
<% @Import NameSpace="System.Data.SQLClient" %>
<% @Import NameSpace="System.Diagnostics.Debug" %>
<% @Import Namespace="System.Web.Mail" %>
<% @Import Namespace="System.Text.RegularExpressions" %>
<% @Import NameSpace="System.Data.OleDb" %>
<%@ Import namespace="System.IO" %>
<%@ Import namespace="System.Net" %>
<%
If Request.Form("Quantity_3") <> "" Then
Only_Num(Request.Form("Quantity_3"))
Dim Errore = 0
Dim Errore_Only_Num = 0
If Only_Num(Request.Form("Quantity_3")) <> 0 OR Only_Num(Request.Form("Quantity_4")) <> 0 OR Only_Num(Request.Form("Quantity_5")) <> 0 OR Only_Num(Request.Form("Quantity_6")) <> 0 Then
Errore_Only_Num = 1
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",684) &"
"
End If
If (Request.Form("Quantity_3")) = "" OR (Request.Form("Quantity_4")) = "" OR (Request.Form("Quantity_5")) = "" OR (Request.Form("Quantity_6")) = "" Then
Errore_Only_Num = 1
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",778) &"
"
End If
If Errore_Only_Num = 0 Then
sqlConn.Open()
sqlComm = New SqlCommand("SELECT C_Costr_2, C_Costr_3, C_Costr_4, C_Costr_5, C_Costr_6, P_Cittadini FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Pianeti.Id = '"& Id_Paese &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Cittadini_Tassabili = Int(r("P_Cittadini"))
If CInt(Request.Form("Quantity_3")) + CInt(Request.Form("Quantity_4")) + CInt(Request.Form("Quantity_5")) + CInt(Request.Form("Quantity_6")) > Var_Cittadini_Tassabili Then
Errore = 1
End If
If CInt(Request.Form("Quantity_3")) > r("C_Costr_3") * 50
Errore = 3
End If
If CInt(Request.Form("Quantity_4")) > r("C_Costr_4") * 50
Errore = 4
End If
If CInt(Request.Form("Quantity_5")) > r("C_Costr_5") * 50
Errore = 5
End If
If CInt(Request.Form("Quantity_6")) > r("C_Costr_6") * 50
Errore = 6
End If
If CInt(Request.Form("Quantity_3")) < 0 OR CInt(Request.Form("Quantity_4")) < 0 OR CInt(Request.Form("Quantity_5")) < 0 OR CInt(Request.Form("Quantity_6")) < 0 Then
Errore = 8
End If
End While
r.Close()
sqlConn.Close()
If Errore = 1 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",685) &""
End If
If Errore = 3 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",686) &""
End If
If Errore = 4 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",687) &""
End If
If Errore = 5 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",688) &""
End If
If Errore = 6 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",689) &""
End If
If Errore = 8 Then
Messaggio_Errore.Text = ""& Read_File("inc\Lang\Languages.aspx",690) &""
End If
Messaggio_Errore.Text = Messaggio_Errore.Text + "
"
If Errore = 0 Then
Messaggio_Errore.Text = ""
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET P_Costr_3 = "& CInt(Request.Form("Quantity_3")) &", P_Costr_4 = "& CInt(Request.Form("Quantity_4")) &", P_Costr_5 = "& CInt(Request.Form("Quantity_5")) &", P_Costr_6 = "& CInt(Request.Form("Quantity_6")) &" WHERE Pianeti.Id = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
End If
End If
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",790) &" " + CStr(Cint(r("C_Costr_1")*100)) Messaggio.Text = Messaggio.Text + " |
| "& Read_File("inc\Lang\Languages.aspx",691) &" " + CStr(Cint(r("C_Costr_2")*20)) Messaggio.Text = Messaggio.Text + " |
| "& Read_File("inc\Lang\Languages.aspx",692) &" "& Int(r("P_Cittadini")) Messaggio.Text = Messaggio.Text + " |
| "& Read_File("inc\Lang\Languages.aspx",693) &" " + CStr(Cint(Var_Cittadini_Liberi)) Messaggio.Text = Messaggio.Text + " |
| "& Read_File("inc\Lang\Languages.aspx",694) &" "& Citt_Arrivo Messaggio.Text = Messaggio.Text + " |
Gestione Cittadini
<%
Response.Write ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",772) &" "& Read_File("inc\Lang\Languages.aspx",695) &" "& Read_File("inc\Lang\Languages.aspx",696) &" ")
Response.Write ("
")
End While
r.Close()
sqlConn.Close()
If Troppi_Cittadini = 1 Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET P_Cittadini = "& Cittadini &" WHERE Pianeti.Id = '"& Id_Paese &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
%>