private void PagarBtn_Click(object sender, EventArgs e)
{
ConnectionSQLServer connection = new ConnectionSQLServer();
connection.OpenConnection();
Pagar pagar = new Pagar();
pagar.Show();
DateTime date = Convert.ToDateTime(DatetimeReporte.Value = DateTime.Now);
pagar.VentaTotal(TotalVenta);
TotalVenta = 0;
int ventaT = pagar.Venta;
int feria = pagar.Feria;
int paga = pagar.Paga;
int idVenta = connection.SeleccionarIdVenta("SELECT MAX(IdVenta) FROM Venta GROUP BY IdVenta");
if (idVenta == 0)
{
idVenta = 1;
}
foreach (DataGridViewRow row in GridVentasReporte.Rows)
{
int ids = Convert.ToInt32(row.Cells["IdVenta"].Value);
if (idVenta == ids)
{
idVenta++;
}
}
connection.IngresarDatosReporte("insert into Venta (IdVenta,VentaTotal,Pago,Feria,Fecha) values (@IdVenta,@VentaTotal,@Pago,@Feria,@Fecha)", idVenta, ventaT, paga, feria, date);
GridVentasReporte.DataSource = connection.TablaVenta("select * from Venta");
connection.EliminarDatosVenta("delete from VentaProducto");
GridVentas.DataSource = connection.TablaVentaProducto("select * from VentaProducto");
idVenta += 1;
connection.CloseConnection();
}
