public string UserRecoveryAccount(byte[] ciphertoken, byte[] cipheraccuont,
byte[] Key, byte[] IV)
{
var rsa = new cryptography.SystemSupportRSA();
string userName;
string userMail;
string user;
string alias;
string pass;
string current_token;
//string request = "";
Database.Connect();
command = new OdbcCommand
{
Connection = Database.GetConn(),
CommandType = CommandType.StoredProcedure,
CommandText = "{call csg.User_RecoveryAccount(?)}"
};
command.Parameters.Add("Account", OdbcType.VarChar, 50).Value = rsa.DecryptStringFromBytes_Aes(cipheraccuont, Key, IV);
dataReader = command.ExecuteReader();
//Console.WriteLine("Read(): " + dataReader.Read() + " | HasRows: " + dataReader.HasRows);
if (dataReader.Read())
{
//Validamos que el token vigente coincida
if (rsa.DecryptStringFromBytes_Aes(ciphertoken, Key, IV).Equals(dataReader.GetString(3)))
{
userName = dataReader.GetString(0);
user = dataReader.GetString(1);
userMail = dataReader.GetString(2);
string code = dataReader.GetString(4);
Database.Disconnect();
//Creamos el nuevo token
string new_token = rsa.GetMd5Hash(user + DateTime.Now.Ticks.ToString());
//Actualizamos el token y pasamos el usetoken a SI
UpdateUserToken(new_token, code);
var mailservice = new mailservices.SystemSupportMail();
mailservice.SendRecoveryMail(username: userName, user: user, token: new_token,
subject: "Recuperación de cuenta Control de Servicios y Garantías", to: userMail);
return("s,Por favor revisa tu cuenta de correo " + userMail);
}
else
{
Database.Disconnect();
return("f,No coincide el token");
}
}
else
{
Database.Disconnect();
return("f,Lo sentimos, no existe una cuenta con ese nombre de usuario o" +
" correo electrónico");
}
}
private bool SendMail()
{
CultureInfo culture = new CultureInfo("en-US");
string to = txtClientEmail.Text;
string subject = "Cotización orden " + txtOrderNumber.Text;
string html = "<html>" +
"<head></head>" +
"<body style='color: #000;'>" +
"<center><h1>COTIZACIÓN</h1></center>" +
"<table style='width:100%;border: solid black 1px;'>" +
"<colgroup>" +
"<col style ='width:50%'/>" +
"<col style ='width:50%'/>" +
"</colgroup>" +
"<tr>" +
"<td><img src='https://www.evans.com.co/wp-content/uploads/2019/01/evans.png' title='logo_top'/><h2>Valsi de Colombia S.A</td></td>" +
"<td>" +
"<table style='width:auto;margin-right: 0px;margin-left: auto;'>" +
"<tr>" +
"<td>FECHA</td>" +
"<td>" + order.Order_reception_date.ToString("yyyy-MM-dd") + "</td>" +
"</tr>" +
"<tr>" +
"<td>COTIZACIÓN</td>" +
"<td>" + txtCotizationId.Text + "</td>" +
"</tr>" +
"<tr>" +
"<td>CC/NIT</td>" +
"<td>" + txtClientId.Text + "</td>" +
"</tr>" +
"<tr>" +
"<td>VÁLIDA POR</td>" +
"<td>30 días</td>" +
"</tr>" +
"</table>" +
"</td></tr>" +
"<tr>" +
"<td colspan='2'" +
"</table><br>" +
"<label>Cra. 27 No. 18 - 50</label><br>" +
"<label>Sucursal principal: Bogotá - Cundinamarca</label><br>" +
"<label>Teléfono: (57 1) 752 0573 -752 0538</label><br>" +
"<label>Fax: (0571) + 7520573 Ext.103.</label><br>" +
"<label>Sitio web: https://www.evans.com.co</label><br><br>" +
"<h3><b>CLIENTE</b></h3>" +
"<label>" + order.Client.Client_name + "</label><br>" +
"<label>" + order.Client.Client_address + "<br>" +
"<label>" + order.Client.Client_city + "</label><br>" +
"<label>" + order.Client.Client_tel1 + " - " + order.Client.Client_tel2 + "<br><br>" +
"<h3><b>DETALLE</b></h3><br>" +
"<table style='border-collapse: collapse;'>" +
"<colgroup>" +
"<col style ='width:10%'/>" +
"<col style ='width:60%'/>" +
"<col style ='width:10%'/>" +
"<col style ='width:10%'/>" +
"<col style ='width:10%'/>" +
"</colgroup>" +
"<tr><td><b>TIPO</b></td><td><b>DESCRIPCIÓN</b></td><td><b>CANTIDAD</b></td><td><b>P. UNITARIO</b></td><td><b>IMPORTE</b></td></tr>";
for (int i = 0; i < DgvSr.Rows.Count; i++)
{
html += "<tr style='border: solid;border-width: 1px 0;'>" +
"<td>" + DgvSr.Rows[i].Cells[0].Value.ToString() +
"</td><td>" + DgvSr.Rows[i].Cells[2].Value.ToString() +
"</td><td>" + DgvSr.Rows[i].Cells[3].Value.ToString() +
"</td><td>" + DgvSr.Rows[i].Cells[4].Value.ToString() +
"</td><td>" + DgvSr.Rows[i].Cells[5].Value.ToString() + "</td></tr>";
}
html += "<tr><td></td><td></td><td></td><td></td><td></td></tr>" +
"<tr><td colspan='3' rowspan='4'>" + txtComentarys.Text + "</td><td>SUBTOTAL</td><td>" + lblSubtotal.Text + "</td></tr>" +
"<tr><td>DESCUENTO</td><td>" + lblDiscount.Text + "</td></tr>" +
"<tr><td>IVA</td><td>" + lblIva.Text + "</td></tr>" +
"<tr><td>TOTAL</td><td>" + lblTotal.Text + "</td></tr></table><br><br>" +
"</td>" +
"</tr></table><br>" +
"<table style='width:auto;margin-right: auto;margin-left: 0px;'>" +
"<tr>" +
"<td rowspan='4'><img src='https://www.evans.com.co/wp-content/uploads/2019/01/evans.png' title='logo'/></td>" +
"<td>Control de Servicio y Garantías</td>" +
"</tr>" +
"<tr>" +
"<td>IT</td>" +
"</tr>" +
"<tr>" +
"<td>Evans ®</td>" +
"</tr>" +
"<tr>" +
"<td>(0571) + 7520573 Ext.103.</td>" +
"</tr>" +
"</table>" +
"</body>" +
"</html>";
try
{
var mailServe = new mailservices.SystemSupportMail();
if (mailServe.SendEmailCotization(to: to, subject: subject, html: html))
{
//Console.WriteLine("Paso validacion");
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show("Excepcioón en SendMail(): " + ex.Message);
return(false);
}
}
