private void BtnCargar_Click(object sender, EventArgs e)
{
OpenFileDialog openFile = new OpenFileDialog();
openFile.ShowDialog();
var ruta = openFile.FileName;
MessageBox.Show(ruta);
LacteosService = new LacteosService(ConfigConection.Connection);
IList <Lacteos> LacteosMalos = new List <Lacteos>();
IList <Lacteos> LacteosBuenos = new List <Lacteos>();
foreach (var item in LacteosService.CargarArchivo(ruta))
{
if (item.CalcularPago() != item.TotalPago)
{
LacteosMalos.Add(item);
}
else
{
LacteosBuenos.Add(item);
}
}
MessageBox.Show(LacteosService.GuardarLacteos(LacteosBuenos, LacteosMalos.Count));
}
private void CmbSede1_SelectedIndexChanged(object sender, EventArgs e)
{
LacteosService = new LacteosService(ConfigConection.Connection);
decimal total = 0, salario = 0, bonificacion = 0, descuento = 0;
if (CmbSede1.Text.Equals("Valledupar"))
{
DtgConsulta.DataSource = null;
DtgConsulta.DataSource = LacteosService.FiltroSede(1);
total = LacteosService.FiltroSede(1).Sum(L => L.TotalPago);
salario = LacteosService.FiltroSede(1).Sum(L => L.Salario);
bonificacion = LacteosService.FiltroSede(1).Sum(L => L.Bonificaciones);
descuento = LacteosService.FiltroSede(1).Sum(L => L.Descuentos);
}
if (CmbSede1.Text.Equals("Barranquilla"))
{
DtgConsulta.DataSource = null;
DtgConsulta.DataSource = LacteosService.FiltroSede(2);
total = LacteosService.FiltroSede(2).Sum(L => L.TotalPago);
salario = LacteosService.FiltroSede(2).Sum(L => L.Salario);
bonificacion = LacteosService.FiltroSede(2).Sum(L => L.Bonificaciones);
descuento = LacteosService.FiltroSede(2).Sum(L => L.Descuentos);
}
if (CmbSede1.Text.Equals("Cartagena"))
{
DtgConsulta.DataSource = null;
DtgConsulta.DataSource = LacteosService.FiltroSede(3);
total = LacteosService.FiltroSede(3).Sum(L => L.TotalPago);
salario = LacteosService.FiltroSede(3).Sum(L => L.Salario);
bonificacion = LacteosService.FiltroSede(3).Sum(L => L.Bonificaciones);
descuento = LacteosService.FiltroSede(3).Sum(L => L.Descuentos);
}
TxtSalario.Text = salario.ToString();
TxtBonificaciones.Text = bonificacion.ToString();
TxtDescuento.Text = descuento.ToString();
TxtTotal.Text = total.ToString();
}
public Form1()
{
InitializeComponent();
LacteosService = new LacteosService(ConfigConection.Connection);
DtgConsulta.DataSource = LacteosService.ConsultasBD();
}
