<%@ 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" %> <% Dim x Dim Page = Request.QueryString("Page") If Page = "" Then Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Dim i = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Items.Id, Items.Item_Name, Items.Cost, Items.Level, Items.Valore, Items.Item_Type FROM Items JOIN Soldiers ON (Soldiers.Class = Items.Soldier_Type OR Items.Soldier_Type = 'ALL') AND Not Soldiers.Level < Items.Level AND Item_Type <> 'OBJ' AND Mercato = 1 WHERE Soldiers.Id = '"& Id_This_Soldier &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() i = i + 1 Dim Stat = "" If r("Item_Type") = "WEA" Then Stat = "STR" End If If r("Item_Type") = "ARM" OR r("Item_Type") = "SHI" Then Stat = "ARM" End If If r("Item_Type") = "MAG" Then Stat = "INT" End If Response.Write ("") dim Id_Item = r("Id") Response.Write ("") End While r.Close() sqlConn.Close() Response.Write ("

NomePrezzoQt.Compra

"& r("Item_Name") &""& r("Cost") &"") Response.Write ("
") Response.Write ("") Response.Write ("
") Response.Write ("

Passando il mouse sull'immagine dell'oggetto si otterranno delle informazioni. Il numero tra le parentesi quadre indica il livello minimo con il quale il soldato puņ utilizzare l'arma, mentre il Bonus indica che valore aggiunge e a quale Caratteristica.

") End If If Page = "lab" Then Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Dim i = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Items.Id, Items.Item_Name, Items.Cost, Items.Level, Items.Valore, Items.Item_Type, Items.Descrizione FROM Items JOIN Soldiers ON (Soldiers.Class = Items.Soldier_Type OR Items.Soldier_Type = 'ALL') AND Not Soldiers.Level < Items.Level AND Item_Type = 'OBJ' WHERE Soldiers.Id = '"& Id_This_Soldier &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() i = i + 1 Dim Stat = "" If r("Item_Type") = "WEA" Then Stat = "STR" End If If r("Item_Type") = "ARM" OR r("Item_Type") = "SHI" Then Stat = "ARM" End If If r("Item_Type") = "MAG" Then Stat = "INT" End If Response.Write ("") dim Id_Item = r("Id") Response.Write ("") End While r.Close() sqlConn.Close() Response.Write ("

NomePrezzoQt.Compra

"& r("Item_Name") &""& r("Cost") &"") Response.Write ("
") Response.Write ("") Response.Write ("
") Response.Write ("

Passando il mouse sull'immagine dell'oggetto si otterranno delle informazioni. Il numero tra le parentesi quadre indica il livello minimo con il quale il soldato puņ utilizzare l'arma, mentre il Bonus indica che valore aggiunge e a quale Caratteristica.

") End If If page = "compra" Then Dim codice = Request.QueryString("Codice") Dim Quantity = Request.Form("Quantity") response.write (Codice) response.write ("
") response.write (Quantity) response.write ("
") response.write (Id_This_User) Dim Item_Name Dim Item_Cost Dim Mercato DIm Item_Type sqlConn.Open() sqlComm = New SqlCommand("SELECT Item_Name, Item_Type, Cost, Mercato FROM Items WHERE Id = '"& codice &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Mercato = r("Mercato") Item_Name = r("Item_Name") Item_Cost = r("Cost") Item_Type = r("Item_Type") End While r.Close() sqlConn.Close() If Quantity = "" Then Quantity = -1 End If If Quantity < 0 Then Response.Redirect ("mercato.aspx") End If If Item_Cost*Quantity > Money_This_User Then Response.Write ("Non hai abbastanza denaro!!!") End If If Mercato = "0" Then Response.Write ("Questo articolo non č in vendita!!!") End If If Not Item_Cost*Quantity > Money_This_User AND Mercato = "1" Then Dim Item_Exist as Char = "0" sqlConn.Open() sqlComm = New SqlCommand("SELECT Inventario.Id FROM Inventario WHERE Id_Utente = "& Id_This_User &" AND Id_Item = "& codice &" ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Item_Exist = "1" End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Money = Money - "& Item_Cost*Quantity &" WHERE Id = "& Id_This_User &" ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() If Item_Exist = "1" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity + "& Quantity &" WHERE Inventario.Id_Utente = "& Id_This_User &" AND Inventario.Id_Item = "& codice &" ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Item_Exist = "0" Then m_sql = "INSERT INTO Inventario (Id_Utente, Id_Item, Quantity) VALUES (@Id_Utente, @Id_Item, @Quantity)" Try m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Utente", sqldbtype.varchar).Value = Id_This_User m_cmd.Parameters.Add("@Id_Item", sqldbtype.varchar).Value = Codice m_cmd.Parameters.Add("@Quantity", sqldbtype.varchar).Value = Quantity m_conn.Open m_cmd.ExecuteNonQuery Finally m_conn.Close End Try End If m_sql = "INSERT INTO Messaggi (Id_Utente, Type_Message, Messaggio, Data_Messaggio) VALUES (@Id_Utente, @Type_Message, @Messaggio, @Data_Messaggio)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Mercato" m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai comprato "& Quantity &" "& Item_Name &" al costo di "& Item_Cost*Quantity &"." m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close If Item_Type <> "OBJ" Then Response.Redirect ("mercato.aspx?id_This_Soldier="& Id_This_Soldier &"") End If If Item_Type = "OBJ" Then Response.Redirect ("mercato.aspx?id_This_Soldier="& Id_This_Soldier &"&Page=lab") End If End If End If %>