// Combo de Promociones
public List <Ent_BataClub_Promociones> get_ListaPromociones()
{
List <Ent_BataClub_Promociones> list = null;
string sqlquery = "USP_BATACLUB_PROMOCION_LISTA";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_BataClub_Promociones>();
Ent_BataClub_Promociones prom = new Ent_BataClub_Promociones();
while (dr.Read())
{
prom = new Ent_BataClub_Promociones();
prom.Codigo = dr["Codigo"].ToString();
prom.Descripcion = dr["Descripcion"].ToString();
prom.Porc_Dcto = Convert.ToDecimal(dr["Porc_Dcto"].ToString());
prom.MaxPares = Convert.ToInt32(dr["MaxPares"].ToString());
prom.FechaFin = Convert.ToDateTime(dr["FechaFin"]).ToString("dd-MM-yyyy");
prom.PromActiva = Convert.ToBoolean(dr["PromActiva"]);
prom.nroCupones = Convert.ToInt32(dr["Num_Cupon"]);
prom.Coupon_Code = Convert.ToString(dr["Coupon_Code"]);
list.Add(prom);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
// Combo de Promociones disponibles (Cupón)
public List <Ent_BataClub_Promociones> get_ListaPromo_Disp()
{
List <Ent_BataClub_Promociones> list = null;
string sqlquery = "USP_BATACLUB_GET_PROMO_DISPONIBLE";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_BataClub_Promociones>();
Ent_BataClub_Promociones combo = new Ent_BataClub_Promociones();
while (dr.Read())
{
combo = new Ent_BataClub_Promociones();
combo.Codigo = dr["Prom_ID"].ToString();
combo.Descripcion = dr["Prom_Des"].ToString();
combo.MaxPares = Convert.ToInt32(dr["Prom_Max_pares"].ToString());
combo.Porc_Dcto = Convert.ToDecimal(dr["Prom_Porc_Dcto"].ToString());
list.Add(combo);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
