public List <ComboArticulos_ArticulosPromo> GetArticulosPromocionados(int id_caja)
{
try
{
List <ComboArticulos_ArticulosPromo> listCombo = new List <ComboArticulos_ArticulosPromo>();
OpenConnection();
NpgsqlCommand cmdSel = new NpgsqlCommand("select c.id_producto,c.cant_producto_promocional,h.nombre,h.stock from caja_herramientas_promocion c " +
"inner join articulos h on h.id = c.id_producto" +
" where id_caja = @id", npgsqlConn);
cmdSel.Parameters.Add("@id", NpgsqlTypes.NpgsqlDbType.Integer).Value = id_caja;
NpgsqlDataReader drCombos = cmdSel.ExecuteReader();
while (drCombos.Read())
{
ComboArticulos_ArticulosPromo comb = new ComboArticulos_ArticulosPromo();
comb.Id_articulo = (string)drCombos["id_producto"];
comb.Nombre_articulo = (string)drCombos["nombre"];
comb.Cantidad_articulo = (int)drCombos["cant_producto_promocional"];
comb.Stock = (int)drCombos["stock"];
listCombo.Add(comb);
}
return(listCombo);
}
finally { CloseConnection(); }
}
public List <ComboArticulos_ArticulosPromo> GetArticulosPromoCombos()
{
try
{
List <ComboArticulos_ArticulosPromo> listCombo = new List <ComboArticulos_ArticulosPromo>();
OpenConnection();
NpgsqlCommand cmdSel = new NpgsqlCommand("select c.id_caja,c.cant_producto_promocional,c.id_producto " +
"from caja_herramientas_promocion c " +
"inner join caja_herramienta h on h.id_caja = c.id_caja" +
" where h.activa = true order by h.id_caja ", npgsqlConn);
NpgsqlDataReader drCombos = cmdSel.ExecuteReader();
while (drCombos.Read())
{
ComboArticulos_ArticulosPromo comb = new ComboArticulos_ArticulosPromo();
comb.Id_combo = (int)drCombos["id_caja"];
comb.Cantidad_articulo = (int)drCombos["cant_producto_promocional"];
comb.Id_articulo = (string)drCombos["id_producto"];
listCombo.Add(comb);
}
return(listCombo);
}
finally { CloseConnection(); }
}
