private void btnGuardar_Click(object sender, EventArgs e)
{
int Cambios = 0;
string Mensaje = string.Empty;
string Mail = string.Empty;
Mensaje = @"<style type='text/css'>
table, th, td {
border: 1px solid black;
border-spacing: 50px 50px 50px 50px;
border-collapse: collapse;
}
</style>
<br><br>
<table cellpadding='6'>
<tr>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Articulo</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Nombre</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Linea<strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Almacen</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Fecha</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Cantidad<br>Solicitada</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Stock<br>actual</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Diferencia</strong></font></td>
<td bgcolor='#2A2627'><font size=2 face='Calibri' color='#FFFFFF'><strong>Usuario</strong></font></td>
</tr>";
foreach (DataRow item in tbl.Rows)
{
if (item.RowState == DataRowState.Added)
{
using (SqlConnection connection = new SqlConnection(ClasesSGUV.Propiedades.conectionSGUV))
{
using (SqlCommand command = new SqlCommand("sp_VentaPerdida", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
command.Parameters.AddWithValue("@TipoConsulta", 5);
command.Parameters.AddWithValue("@Articulo", item.Field <string>("Artículo"));
command.Parameters.AddWithValue("@Almacen", item.Field <string>("Almacen"));
command.Parameters.AddWithValue("@ItmsGrpCod", item.Field <Int16>("ItmsGrpCode"));
command.Parameters.AddWithValue("@Fecha", item.Field <DateTime>("Fecha"));
command.Parameters.AddWithValue("@Solicitado", item.Field <decimal>("Cantidad Solicitada"));
command.Parameters.AddWithValue("@Stock", item.Field <decimal>("Stock actual"));
command.Parameters.AddWithValue("@UserId", ClasesSGUV.Login.Id_Usuario);
connection.Open();
command.ExecuteNonQuery();
Cambios++;
Mail += item.Field <string>("Correo") + ";";
Mensaje += @"<tr>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <string>("Artículo") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <string>("Nombre") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <string>("Línea") + @"<strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <string>("Almacen") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <DateTime>("Fecha") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <decimal>("Cantidad solicitada").ToString("N0") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <decimal>("Stock actual").ToString("N0") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <decimal>("Diferencia").ToString("N0") + @"</strong></font></td>
<td><font size=2 face='Calibri' color='#000000'><strong>" + item.Field <string>("Solicitante") + @"</strong></font></td>
</tr>";
}
}
}
}
tbl.AcceptChanges();
MessageBox.Show("Registro exitoso", "HalcoNET", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (Cambios > 0)
{
Cobranza.SendMail mail = new Cobranza.SendMail();
mail.EnviarVentaPerdida(Mail, Mensaje + "</table><br><br>", "Venta pérdida", "*****@*****.**");
}
this.OnLoad(e);
}
