private void btnGuardar_Click(object sender, EventArgs e)
{
try
{
decimal Folio;
string tipo = string.Empty;
if (rbCES.Checked)
{
tipo = "CE";
}
if (rbLinea.Checked)
{
tipo = "LIN";
}
if (rbPPC.Checked)
{
tipo = "PPC";
}
toolStripStatus.Text = string.Empty;
toolStripStatus.BackColor = Color.FromName("Control");
toolStripStatus.ForeColor = Color.Black;
if (this.ValidaEncabezado())
{
if (this.ValidaDetalle())
{
if (tblDetalle.Rows.Count > 0)
{
string _mailVendeor = this.GetMailVendedor();
if (!string.IsNullOrEmpty(_mailVendeor))
{
using (SqlConnection connection = new SqlConnection(ClasesSGUV.Propiedades.conectionSGUV))
{
using (SqlCommand comm = new SqlCommand("PJ_SolicitudProducto", connection))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@TipoConsulta", 13);
comm.Parameters.AddWithValue("@Folio", string.Empty);
comm.Parameters.AddWithValue("@Solicitante", cbVendedor.SelectedValue);
comm.Parameters.AddWithValue("@Sucursal", cbUnidadVenta.SelectedValue);
comm.Parameters.AddWithValue("@TipoSolicitud", tipo);
comm.Parameters.AddWithValue("@FechaCompromiso", dtCompromiso.Value);
comm.Parameters.AddWithValue("@Cliente", txtCliente.Text);
comm.Parameters.AddWithValue("@Justificacion", txtJustificar.Text);
comm.Parameters.AddWithValue("@Vendedor", cbVendedor.Text);
comm.Parameters.AddWithValue("@Usuario", ClasesSGUV.Login.Id_Usuario);
connection.Open();
Folio = Convert.ToDecimal(comm.ExecuteScalar());
if (Folio > 0)
{
txtFolio.Text = Folio.ToString("00000000");
int line = 0;
foreach (DataRow item in tblDetalle.Rows)
{
using (SqlConnection connectionDetalle = new SqlConnection(ClasesSGUV.Propiedades.conectionSGUV))
{
using (SqlCommand commDetalle = new SqlCommand("PJ_SolicitudProducto", connection))
{
commDetalle.CommandType = CommandType.StoredProcedure;
commDetalle.Parameters.AddWithValue("@TipoConsulta", 14);
commDetalle.Parameters.AddWithValue("@Folio1", Folio);
commDetalle.Parameters.AddWithValue("@Line", line);
commDetalle.Parameters.AddWithValue("@Articulo", item.Field <string>("Articulo"));
commDetalle.Parameters.AddWithValue("@Descripcion", item.Field <string>("Descripcion"));
commDetalle.Parameters.AddWithValue("@Proveedor", item.Field <string>("CardCode"));
commDetalle.Parameters.AddWithValue("@Otro", item.Field <string>("Especifique Proveedor"));
commDetalle.Parameters.AddWithValue("@Linea", item.Field <int>("ItmsGrpCod"));
commDetalle.Parameters.AddWithValue("@Comprador", item.Field <string>("Comprador"));
commDetalle.Parameters.AddWithValue("@Cantidad", item.Field <decimal>("Cantidad"));
commDetalle.Parameters.AddWithValue("@Pronostico", item.Field <decimal>("Pronostico"));
connectionDetalle.Open();
commDetalle.ExecuteNonQuery();
}
}
line++;
}
if (this.CrearPDF(Folio, tipo))
{
// public bool Enviar(string _file, string _mailDestinatario, string _mailVendedor, string _vendedor, bool _solicitud)
Cobranza.SendMail mail = new Cobranza.SendMail();
string _mailComprador = this.GetMailCompradores(tipo);
mail.Enviar(Ruta, _mailComprador, _mailVendeor, cbVendedor.Text, true);
}
}
else
{
toolStripStatus.Text = "No se ha podido enviar la solicitud.";
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
toolStripStatus.Text = "Su solicitud ha sido enviada.";
toolStripStatus.BackColor = Color.Green;
toolStripStatus.ForeColor = Color.Black;
btnGuardar.Enabled = false;
}
}
else
{
toolStripStatus.Text = "El vendedor no tiene asignada una cuenta de correo";
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
else
{
toolStripStatus.Text = "No ha ingresado artÃculos.";
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
else
{
toolStripStatus.Text = "No se ha podido enviar la solicitud.";
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
else
{
toolStripStatus.Text = "No se ha podido enviar la solicitud.";
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
catch (Exception ex)
{
toolStripStatus.Text = ex.Message;
toolStripStatus.BackColor = Color.Red;
toolStripStatus.ForeColor = Color.White;
}
}
