public void registrarOrdenCompra(OrdenCompraModel ordenCompra)
{
dataBaseMySQL.OpenBD();
commandDatabase = new MySqlCommand();
commandDatabase.Connection = dataBaseMySQL.GetConnection();
commandDatabase.CommandType = CommandType.StoredProcedure;
commandDatabase.CommandText = "registrarOrdenCompra";
commandDatabase.Parameters.Add(new MySqlParameter("d1", ordenCompra.sRucCliente));
commandDatabase.Parameters.Add(new MySqlParameter("d2", ordenCompra.nPrecioTotal));
commandDatabase.Parameters.Add(new MySqlParameter("d3", ordenCompra.dFechaCompra));
commandDatabase.Parameters.Add(new MySqlParameter("d4", ordenCompra.sEstado));
commandDatabase.ExecuteNonQuery();
dataBaseMySQL.CloseBD();
ordenCompra.nCodigoOrden = retornarCodigoOrdenCompra();
registrarDetalleOrdenCompra(ordenCompra.lDetalleCompra, ordenCompra.nCodigoOrden);
}
public void actualizarStock(List <OrdenCompraDetalleModel> lDetalleCompra)
{
foreach (OrdenCompraDetalleModel auxiliar in lDetalleCompra)
{
dataBaseMySQL.OpenBD();
commandDatabase = new MySqlCommand();
commandDatabase.Connection = dataBaseMySQL.GetConnection();
commandDatabase.CommandType = CommandType.StoredProcedure;
commandDatabase.CommandText = "actualizarStock";
commandDatabase.Parameters.Add(new MySqlParameter("d1", auxiliar.nCodigoProducto));
commandDatabase.Parameters.Add(new MySqlParameter("d2", auxiliar.nCantidadProducto));
commandDatabase.ExecuteNonQuery();
dataBaseMySQL.CloseBD();
}
}