/// <summary> /// Decrypt a string /// </summary> public static string Decrypt(string Text,string Key) { string result = Text; rc4encrypt crypt = new rc4encrypt(); crypt.password = Key; crypt.plaintext = Text; result = crypt.EnDeCrypt(); return(result); }
/// <summary> /// Decrypt a string /// </summary> public static string Decrypt(string Text, string Key) { string result = Text; rc4encrypt crypt = new rc4encrypt(); crypt.password = Key; crypt.plaintext = Text; result = crypt.EnDeCrypt(); return(result); }
protected void Page_Load(object sender, EventArgs e) { String load = Request["load"]; String mode = Request["mode"]; string connectionString = ""; string dbpath = Server.MapPath("/"); //dbpath=Mid(dbpath,1,Instrrev(dbpath,"\")-1) //checklast=Mid(dbpath,Instrrev(dbpath,"\")+1) //If checklast="admin" Then //dbpath=Mid(dbpath,1,Instrrev(dbpath,"\")-1) //checklast=Mid(dbpath,Instrrev(dbpath,"\")+1) //End if //If checklast="web" Or checklast="public_html" Or checklast="admin" Then dbpath=Mid(dbpath,1,Instrrev(dbpath,"\")-1) //'If checklast="web" Or checklast="public_html" Or checklast="progettiamo" Or checklast="admin" Then dbpath=Mid(dbpath,1,Instrrev(dbpath,"\")-1) dbpath = dbpath.Substring(0, dbpath.LastIndexOf("\\")); dbpath = dbpath.Substring(0, dbpath.LastIndexOf("\\")); dbpath = dbpath + "\\database\\"; string dbname = "dsm_progettiamo.v1.mdb"; main.rc4encrypt rc4 = new rc4encrypt(); rc4.Password = "******"; dbpath = dbpath + dbname; DataTable dt = null; String SQL = "SELECT * FROM p_projects WHERE ID=" + load; string filename = ""; int adm_area = Session["adm_area"] == null ? 0 : (int)Session["adm_area"]; if (adm_area > 0) { SQL = "SELECT * FROM p_projects WHERE ID=" + load + " AND CO_p_area=" + Session["adm_area"]; } try { connectionString = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;" + "Data Source='" + dbpath + "';"; using (OleDbConnection con = new OleDbConnection(connectionString)) { con.Open(); using (OleDbCommand command = new OleDbCommand(SQL, con)) using (OleDbDataReader reader = command.ExecuteReader()) { dt = new DataTable(); dt.Columns.Add("Ente/Società", typeof(String)); dt.Columns.Add("Cognome", typeof(String)); dt.Columns.Add("Nome", typeof(String)); dt.Columns.Add("Fr.", typeof(String)); dt.Columns.Add("Email", typeof(String)); dt.Columns.Add("Tel.", typeof(String)); dt.Columns.Add("Cap", typeof(String)); dt.Columns.Add("Luogo", typeof(String)); dt.Columns.Add("Indirizzo", typeof(String)); dt.Columns.Add("Data", typeof(String)); while (reader.Read()) { filename = reader["TA_nome"].ToString(); SQL = "SELECT DISTINCT ID FROM (SELECT ID FROM QU_projects_promises WHERE CO_p_projects=" + load + " ORDER BY DT_data)"; using (OleDbCommand com2 = new OleDbCommand(SQL, con)) { using (OleDbDataReader rec1 = com2.ExecuteReader()) { string refu = ""; while (rec1.Read()) { refu = rec1["ID"].ToString(); SQL = "SELECT SUM(IN_promessa) as promesso,MAX(DT_data) as lastdata FROM QU_projects_promises WHERE CO_p_projects=" + load + " AND ID=" + refu; using (OleDbCommand com3 = new OleDbCommand(SQL, con)) { using (OleDbDataReader rec2 = com3.ExecuteReader()) { while (rec2.Read()) { string promesso = rec2["promesso"].ToString(); string lastdata = rec2["lastdata"].ToString(); SQL = "SELECT * FROM registeredusers WHERE ID=" + refu; using (OleDbCommand com4 = new OleDbCommand(SQL, con)) using (OleDbDataReader rec3 = com4.ExecuteReader()) { while (rec3.Read()) { string email = rec3["TA_email"].ToString(); //EnDecrypt.CryptedText = email; //EnDecrypt.Decrypt(); //email = System.Web.HttpUtility.UrlDecode(email); //rc4.URLDecode(email); //throw new Exception(rc4.URLDecode(email)); if (!String.IsNullOrEmpty(email)) { rc4.PlainText = email; email = rc4.EnDeCrypt(2); } string telefono = rec3["TA_telefono"].ToString(); //EnDecrypt.CryptedText = telefono; //EnDecrypt.Decrypt(); if (!String.IsNullOrEmpty(telefono)) { rc4.PlainText = telefono; telefono = rc4.EnDeCrypt(2); } dt.Rows.Add(rec3["TA_ente"], DecodeFromUtf8((String)rec3["TA_cognome"]), DecodeFromUtf8((String)rec3["TA_nome"]), promesso, email, telefono, rec3["TA_cap"], rec3["TA_citta"], rec3["TA_indirizzo"], lastdata); } } } } } } } } } } } } catch (Exception ex) { Response.Write(dbpath + "<br/>" + ex.Message + "<br/>" + ex.StackTrace); Response.End(); return; } downloadExcel(filename, dt, mode); }