<%@ 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 Id_Where = Request.QueryString("Id") Dim Id_Item = 0 Dim There_Is = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Left_Arm, Right_Arm, Armor, Magic_Item FROM Soldiers WHERE Soldiers.Id = '"& Id_This_Soldier &"' AND Soldiers.Id_Utente = '"& Id_This_User &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is = 1 If Id_Where = 1 Then Id_Item = r("Right_Arm") End If If Id_Where = 2 Then Id_Item = r("Left_Arm") End If If Id_Where = 3 Then Id_Item = r("Armor") End If If Id_Where = 4 Then Id_Item = r("Magic_Item") End If End While r.Close() sqlConn.Close() If There_Is <> 0 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Inventario SET Quantity = Quantity + 1 WHERE Id_Utente = "& Id_This_User &" AND Id_Item = "& Id_Item &" ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() If Id_Where = 1 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Right_Arm = 0 WHERE Id = '"& Id_This_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Where = 2 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Left_Arm = 0 WHERE Id = '"& Id_This_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Where = 3 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Armor = 0 WHERE Id = '"& Id_This_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Id_Where = 4 Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldiers SET Magic_Item = 0 WHERE Id = '"& Id_This_Soldier &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If Response.Redirect ("Soldiers.aspx?Id_This_Soldier="& Id_This_Soldier &"") %>