private void pagar()
{
var connection = DBConnection.getInstance().getConnection();
SqlCommand query = new SqlCommand("POSTRESQL.registrarPago", connection);
query.CommandType = CommandType.StoredProcedure;
MedioPago medioPago = (MedioPago)(this.comboMedioPago.SelectedItem);
query.Parameters.Add(new SqlParameter("@medio_pago", Convert.ToInt32(medioPago.code)));
query.Parameters.Add(new SqlParameter("@sucursal", sucursalCode));
query.Parameters.Add(new SqlParameter("@usuario", username));
AbmFactura.Cliente cliente = (AbmFactura.Cliente)(this.comboCliente.SelectedItem);
query.Parameters.Add(new SqlParameter("@cliente", Convert.ToInt32(cliente.code)));
query.Parameters.Add(new SqlParameter("@fecha", DateTime.Today));
query.Parameters.Add(new SqlParameter("@total", importeTotal));
connection.Open();
query.ExecuteNonQuery();
connection.Close();
//PONER FACTURA COMO PAGA
foreach (Decimal factura in facturas)
{
PagarFactura(factura);
}
}
public void PagarFactura(Decimal idFactura)
{
var connection = DBConnection.getInstance().getConnection();
SqlCommand query = new SqlCommand("POSTRESQL.pagar_factura", connection);
query.CommandType = CommandType.StoredProcedure;
query.Parameters.Add(new SqlParameter("@usuario", username));
query.Parameters.Add(new SqlParameter("@factura", idFactura));
query.Parameters.Add(new SqlParameter("@fecha", DateTime.Today));
AbmFactura.Cliente cliente = (AbmFactura.Cliente)(this.comboCliente.SelectedItem);
query.Parameters.Add(new SqlParameter("@cliente", Convert.ToInt32(cliente.code)));
query.Parameters.Add(new SqlParameter("@importe", importeTotal));
query.Parameters.Add(new SqlParameter("@sucursal", sucursalCode));
MedioPago medioPago = (MedioPago)(this.comboMedioPago.SelectedItem);
query.Parameters.Add(new SqlParameter("@medio", Convert.ToInt32(medioPago.code)));
connection.Open();
query.ExecuteNonQuery();
connection.Close();
}