private bool factura_es_valida(Int32 numero)
{
SqlDataReader reader;
var connection = DBConnection.getInstance().getConnection();
String command = "SELECT * from POSTRESQL.Factura where fact_numero=" + numero.ToString();
SqlCommand consulta = new SqlCommand(command, connection);
connection.Open();
reader = consulta.ExecuteReader();
if (!reader.HasRows)
{
return(false);
}
else
{
reader.Read();
AbmFactura.Cliente clienteSeleccionado = (AbmFactura.Cliente)(this.comboCliente.SelectedItem);
AbmFactura.Empresa empresaSeleccionado = (AbmFactura.Empresa)(this.comboEmpresa.SelectedItem);
Int32 cliente = Convert.ToInt32(reader["fact_cliente"].ToString());
Int32 empresa = Convert.ToInt32(reader["fact_empresa"].ToString());
return(clienteSeleccionado.code == cliente && empresaSeleccionado.code == empresa);
}
}
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();
}
