protected void B_enviar_Click(object sender, EventArgs e)
{
FacturaMailUpdate = T_email.Text;
string queryInsert = "INSERT INTO Alta_Factura_Electronica (Br,CustNbr,CustName,DestinationType,Email1,Email2,Pending) VALUES ('" + ResellerID.Remove(0, 2) + "','" + ResellerID.Remove(2, 6) + "','" + BrCustName + "','3','" + T_email.Text + "','*****@*****.**','1')";
string queryUpdate = "UPDATE Alta_Factura_Electronica SET Email1='" + FacturaMailUpdate + "',Email2='*****@*****.**',Pending='1' where CustNbr='" + ResellerID.Remove(0, 2) + "'";
if ((Pending == "0") || (Pending == "1") || (Pending == "2")) //UPDATE DEL MAIL PERQUÈ JA ESTÀ A LA TAULA DE IMONLINE
{
try
{
MailSubject = "";
conn.Open();
SqlCommand selectPending = new SqlCommand(queryUpdate, conn);
selectPending.ExecuteNonQuery();
conn.Close();
SendMail(MailSubject, MailBody, "*****@*****.**", "*****@*****.**", "", "");
}
catch (Exception ex)
{
Response.Write(ex);
T_email.Visible = false;
B_enviar.Visible = false;
Label3.Text = "Error x001. Contacta con el siguiente correo para más información:<br/>[email protected] ";
MailBody = "Error x001 - Error al fer l'UPDATE al client " + ResellerID + " amb usuari web: " + WebUserID + "\n\nError: " + ex;
SendMail("Error Factura Electronica", MailBody, "*****@*****.**", "*****@*****.**", "", "");
}
}
else //INSERT DE TOTES LES DADES, PERQUÈ NO ESTÀ DONAT D'ALTA A LA FACTURA ELECTRONICA
{
try
{
conn.Open();
SqlCommand selectPending = new SqlCommand(queryInsert, conn);
selectPending.ExecuteNonQuery();
conn.Close();
MailTo = webUserMail + ";" + T_email.Text;
SendMail(MailSubject, MailBody, "*****@*****.**", MailTo, "", "");
}
catch (Exception ex)
{
Response.Write(ex);
T_email.Visible = false;
B_enviar.Visible = false;
Label3.Text = "Error x002. Contacta con el siguiente correo para más información:<br/>[email protected] ";
MailBody = "Error x002 - Error al fer l'INSERT al client " + ResellerID + " amb usuari web: " + WebUserID + "\n\nError: " + ex;
SendMail("Error Factura Electronica", MailBody, "*****@*****.**", "*****@*****.**", "", "");
}
}
Response.Redirect("HTMLPage1.htm");
}
protected void Page_Load(object sender, EventArgs e)
{
conn.ConnectionString = "Data Source=10.131.16.132; Initial Catalog=IMONLINE; User Id =user_ecomm_write;Password=2bR!S2rqXq";
if (IsPostBack == false)
{
try
{
a3 = Request.QueryString["a3"];
a4 = Request.QueryString["a4"];
a5 = Request.QueryString["a5"];
a6 = Request.QueryString["a6"];
a8 = Request.QueryString["a8"];
IM2 = Request.QueryString["IM2"];
}
catch
{
}
try
{
DecoderEndeavour.Class1 Decoder = new DecoderEndeavour.Class1();
WebUserID = Decoder.Decrypt(IM2);
ResellerID = Decoder.Decrypt(a3);
FirstName = Decoder.Decrypt(a4);
LastName = Decoder.Decrypt(a5);
webUserMail = Decoder.Decrypt(a6);
BrCustName = Decoder.Decrypt(a8);
//WebUserID = "{3193c4ac-e9b8-42bb-b8ca-428f44d69831}";
//ResellerID = "29107187";
//FirstName = "Jordi";
//LastName = "Carbó";
//webUserMail = "*****@*****.**";
//BrCustName = "INGRAM MICRO TEST CUSTOMER";
Page.Session["WebUserID"] = WebUserID;
Page.Session["ResellerID"] = ResellerID;
Page.Session["FirstName"] = FirstName;
Page.Session["LastName"] = LastName;
Page.Session["webUserMail"] = webUserMail;
Page.Session["BrCustName"] = BrCustName;
consulta_Estat_Client(ResellerID.Remove(0, 2));
consulta_Drets_Usuari(WebUserID, ResellerID);
Label1.Text = BrCustName;
Label2.Text = ResellerID;
}
catch
{
MailBody = "Error x003 - Error al decodificar els parametres:\na3: " + a3 + "\na4: " + a4 + "\na5: " + a5 + "\na6: " + a8 + "\na8: " + a8 + "\nIM2: " + IM2;
SendMail("Error Factura Electronica", MailBody, "*****@*****.**", "*****@*****.**", "", "");
}
}
else
{
WebUserID = Convert.ToString(Page.Session["WebUserID"]);
ResellerID = Convert.ToString(Page.Session["ResellerID"]);
FirstName = Convert.ToString(Page.Session["FirstName"]);
LastName = Convert.ToString(Page.Session["LastName"]);
webUserMail = Convert.ToString(Page.Session["webUserMail"]);
BrCustName = Convert.ToString(Page.Session["BrCustName"]);
FacturaMail = Convert.ToString(Page.Session["FacturaMail"]);
Pending = Convert.ToString(Page.Session["Pending"]);
}
}
