protected void btnboleta_Click(object sender, EventArgs e)
{
int montopagado = int.Parse(txtmontopagado.Text);
int montototal = int.Parse(txtimporttot.Text);
if (ddl_TipoComprobante.SelectedValue == "0")
{
Utils.AddScriptClientUpdatePanel(updBotonEnviar, "showSuccessMessage12()");
return;
}
if (txtIdentificadorUsuario.Text == "")
{
Utils.AddScriptClientUpdatePanel(updBotonEnviar, "showSuccessMessage7()");
return;
}
if (montopagado < montototal)
{
Utils.AddScriptClientUpdatePanel(updBotonEnviar, "showSuccessMessage14()");
return;
}
try
{
objDtoSolicitud.DS_ImporteTotal = double.Parse(txtimporteigv.Text);
objCtrSolicitud.RegistrarSolicitud_LD2(objDtoSolicitud);
//# de solicitud
int ValorDevuelto = objDtoSolicitud.PK_IS_Cod;
_log.CustomWriteOnLog("Realizar venta 1", "ValorDevuelto = " + ValorDevuelto);
for (int i = 0; i < gv2.Rows.Count; i++)
{
string codigoMoldura = gv2.Rows[i].Cells[1].Text;
string subtotalMoldura = gv2.Rows[i].Cells[4].Text;
string cantidadMoldura = gv2.Rows[i].Cells[2].Text;
_log.CustomWriteOnLog("Realizar venta 1", " item moldura : " + i + "---------------------------------");
_log.CustomWriteOnLog("Realizar venta 1", " txtIdentificadorUsuario.Text = " + txtIdentificadorUsuario.Text);
_log.CustomWriteOnLog("Realizar venta 1", "codigoMoldura = " + codigoMoldura);
_log.CustomWriteOnLog("Realizar venta 1", "cantidadMoldura = " + cantidadMoldura);
_log.CustomWriteOnLog("Realizar venta 1", "subtotalMoldura = " + subtotalMoldura);
objDtoMoldura.PK_IM_Cod = int.Parse(codigoMoldura);
_log.CustomWriteOnLog("Realizar venta 1", "obj.PK_IM_Cod = " + objDtoMoldura.PK_IM_Cod.ToString());
int valorRetornadoStoc = objCtrMoldura.StockMoldura_(objDtoMoldura);
_log.CustomWriteOnLog("Realizar venta 1", "valorRetornadoStoc = " + valorRetornadoStoc);
int nuevostock = valorRetornadoStoc - int.Parse(cantidadMoldura);
objDtoMoldura.IM_Stock = nuevostock;
_log.CustomWriteOnLog("Realizar venta 1", "nuevostock = " + nuevostock);
objDtoMolduraxUsuario.FK_VU_Cod = txtIdentificadorUsuario.Text;
objDtoMolduraxUsuario.FK_IM_Cod = int.Parse(codigoMoldura);
objDtoMolduraxUsuario.IMU_Cantidad = int.Parse(cantidadMoldura);
objDtoMolduraxUsuario.DMU_Precio = double.Parse(subtotalMoldura);
objDtoMolduraxUsuario.FK_IS_Cod = ValorDevuelto;
objCtrMolduraxUsuario.registrarNuevaMoldura2(objDtoMolduraxUsuario);
objCtrMoldura.ActualizarStockxMoldura(objDtoMoldura);
//# de molduraxu
int ValorDevuelto2 = objDtoMolduraxUsuario.PK_IMU_Cod;
pedido = objDtoMolduraxUsuario.PK_IMU_Cod;
objCtrMolduraxUsuario.actualizarMXUSol(objDtoMolduraxUsuario);
//Enviar correo con boleta
//CTRusuario objctrusr
//dtousuario objuser
//objuser.PK_VU_Dni = txtIdentificadorUsuario.Text;
//objDtoMoldura.PK_IM_Cod = Convert.ToInt32(txtcodigop.Text);
//objctrusr.EnviarBoletaxCorreo(objDtoMoldura,dtoTipoMoldura);
string Select = "SELECT VU_Correo, VU_Contrasenia, VU_Nombre from T_Usuario where PK_VU_Dni ='"
+ objDtoMolduraxUsuario.FK_VU_Cod + "'";
SqlCommand unComando = new SqlCommand(Select, conexion);
conexion.Open();
SqlDataReader reader = unComando.ExecuteReader();
if (reader.Read())
{
string senderr = "*****@*****.**";
string senderrPass = "******";
string displayName = "DECORMOLDURAS & ROSETONES SAC";
var date = DateTime.Now.ToShortDateString();
var recipient = reader["VU_Correo"].ToString();
//var pass = reader["VU_Contrasenia"].ToString();
var nombre = reader["VU_Nombre"].ToString();
var nombreproducto = gvdetalle2.Rows[i].Cells[2].Text;
var sub = gv2.Rows[i].Cells[4].Text;;
var importetot = objDtoSolicitud.DS_ImporteTotal;
var cantidadproducto = gv2.Rows[i].Cells[2].Text;
var precioUnitario = gv2.Rows[i].Cells[3].Text;
string body =
"<div class=row>" +
"<div class=well col-xs-10 col-sm-10 col-md-6 col-xs-offset-1 col-sm-offset-1 col-md-offset-3>" +
"<div class=row>" +
"<div class=col-xs-6 col-sm-6 col-md-6>" +
"<address>" +
"<strong>Decormolduras & Rosetones</strong>" +
"<br>" +
//2135 Sunset Blvd
" <br>" +
"Lima Pe, CP 06" + /*direccion y codigopostal*/
"<br>" +
"<abbr title = Phone> Telefono :</abbr>" +
" (213) 484 - 6829" + /*telefono*/
"</address>" +
"</div>" +
"<div class=col-xs-6 col-sm-6 col-md-6 text-right>" +
"<p>" +
"Fecha: " + date + //"<em>Date: 1st November, 2013</em>" /*fecha*/
"</p>" +
"<p>" +
//<em>Receipt #: 34522677W</em> /*numero de pedido*/
"</p>" +
"</div>" +
" </div>" +
"<div class=row>" +
"<div class=text-center>" +
"<h1>Recibo</h1>" +
"</div>" +
"</span>" +
"<table class=table table-hover>" +
"<thead>" +
"<tr>" +
"<th>Producto</th>" +
"<th>#</th>" +
"<th class=text-center>Precio</th>" +
" <th class=text-center>Total</th>" +
"</tr>" +
"</thead>" +
"<tbody>" +
"<tr>" + /*nombre producto, cantidad producto, precio x unidad, subtotal del producto*/
"<td class=col-md-9><em>" + nombreproducto + "</em></h4></td>" +
"<td class=col-md-1 style=text-align: center>" + cantidadproducto + "</td>" +
"<td class=col-md-1 text-center>" + "S/." + precioUnitario + "</td>" +
"<td class=col-md-1 text-center>" + "S/." + sub + "</td>" +
"</tr>" +
"<tr>" +
"<td></td>" +
"<td></td>" +
"<td class=text-right>" +
"<p>" +
"<strong>Subtotal: </strong>" +
"</p>" +
"<p>" +
"<strong>IGV: </strong>" +
"</p>" +
"</td>" +
"<td class=text-center>" +
"<p>" +
"<strong>" + "S/." + importetot + "</strong>" + /*subtotal*/
"</p>" +
"<p>" +
" <strong>18%</strong>" +
"</p>" +
"</td>" +
"</tr>" +
"<tr>" +
"<td></td>" +
"<td></td>" +
"<td class=text-right>" +
"<h4><strong>Total: </strong></h4>" +
"</td>" +
"<td class=text-center text-danger>" +
"<h4><strong>" + "S/." + importetot + "</strong></h4>" +
"</td>" +
"</tr>" +
"</tbody>" +
"</table>" +
"</td>" +
"</div>" +
"</div>" +
"</div>" +
"</div>";
MailMessage mail = new MailMessage();
mail.Subject = "Confirmacion de compra - SCPEDR";
mail.From = new MailAddress(senderr.Trim(), displayName);
mail.Body = body;
mail.To.Add(recipient.Trim());
mail.IsBodyHtml = true;
//mail.Priority = MailPriority.Normal;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
//smtp.Credentials = new System.Net.NetworkCredential(senderr.Trim(), senderrPass.Trim());
NetworkCredential nc = new NetworkCredential(senderr, senderrPass);
smtp.Credentials = nc;
smtp.Send(mail);
}
_log.CustomWriteOnLog("Realizar venta 1", "Registro moldura : " + codigoMoldura + " para el usuario " + txtIdentificadorUsuario.Text);
Utils.AddScriptClientUpdatePanel(updBotonEnviar, "showSuccessMessage2()");
//Response.Redirect("RealizarVenta_Marcial.aspx");
}
}
catch (Exception ex)
{
_log.CustomWriteOnLog("Realizar venta 1", "btnboleta_Click error : " + ex.Message);
}
}
