<%@ 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 Username = Request.QueryString("Username") Dim Mesi = Request.QueryString("Mesi") Dim Id = Request.QueryString("Id") Dim Codice = Request.QueryString("Codice") If Codice = "Attiva" Then Dim Data_Odierna as String = Datetime.Now Data_Odierna = Replace(Data_Odierna,".",":") Data_Odierna = Format_Date(Data_Odierna) Dim Premium_Data sqlConn.Open() sqlComm = New SqlCommand("SELECT Premium_Data FROM Utenti WHERE Username = '"& Username &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Premium_Data = r("Premium_Data") End While r.Close() sqlConn.Close() If Premium_Data < Datetime.Now Then Premium_Data = Datetime.Now End If Premium_Data = Format_Date(Premium_Data.AddDays(32*Mesi)) sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Data = '"& Premium_Data &"' WHERE Username = '" & Username & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Moduli_Premium SET Attivo = 'Si' WHERE ID = '" & Id & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Codice = "cancella" Then sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Moduli_Premium WHERE ID = '" & Id & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If Response.Write ("


") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Moduli_Premium WHERE Attivo <> 'Si' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Mesi") = "Un Mese - 2€" Then Mesi = 1 Else If r("Mesi") = "Due Mesi - 4€" Then Mesi = 2 Else If r("Mesi") = "Tre Mesi - 6€" Then Mesi = 3 Else If r("Mesi") = "Quattro Mesi - 8€" Then Mesi = 4 Else If r("Mesi") = "Cinque Mesi - 10€" Then Mesi = 5 Else If r("Mesi") = "Sei Mesi - 12€" Then Mesi = 6 End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") End While r.Close() sqlConn.Close() %>
UsernamePost. Off.Pay DatePay TypeMesiAttiv.Delete
 
"& r("Username") &""& r("Uff_Postale") &""& r("Data_Pagamento") &""& r("Pay_Type") &""& Mesi &"AttivaCancella