<%@ Page Language="vb" Debug="true" ValidateRequest="false" %> <% @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" %>


Moduli di richiesta per i Servizi Premium:


 
<% Dim Username = Request.QueryString("Username") Dim Id = Request.QueryString("Id") Dim Codice = Request.QueryString("Codice") If Id <> "" Then Dim Data_Odierna as String = Datetime.Now Data_Odierna = Replace(Data_Odierna,".",":") Data_Odierna = Format_Date(Data_Odierna) sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Check = 'X', Premium_Data = '"& Data_Odierna &"' 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 %><% sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Moduli_Premium ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Attivo") <> "Si" Then %> <% %><% End If End While r.Close() sqlConn.Close() %>
<%=r("Username")%> <%=r("Uff_Postale")%> <%=r("Data_Pagamento")%> <%=r("Pay_Type")%> &ID=<%=r("ID")%>">Attiva ">Cancella