public Ent_BataClub_Orce_Promotion ORCE_CUPONES_BATACLUB_REFRESH(string prefx, ref string _error)
{
string sqlquery = "ORCE_CUPONES_BATACLUB_REFRESH";
Ent_BataClub_Orce_Promotion orceProm = null;
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;
cmd.Parameters.AddWithValue("@COUPON_CODE", prefx);
cmd.Parameters.Add("@NRO_CUPONES", SqlDbType.Decimal).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@MENSAJE", SqlDbType.VarChar, -1).Direction = ParameterDirection.Output;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
decimal nroCupones = 0;
string _mensaje = "";
da.Fill(dt);
nroCupones = Convert.ToDecimal(cmd.Parameters["@NRO_CUPONES"].Value);
_mensaje = Convert.ToString(cmd.Parameters["@MENSAJE"].Value);
_error = _mensaje;
if (_mensaje == "")
{
if (dt != null)
{
if (dt.Rows.Count > 0)
{
orceProm = new Ent_BataClub_Orce_Promotion();
orceProm.PROMOTION_ID = Convert.ToInt32(dt.Rows[0]["PROMOTION_ID"]);
orceProm.DEAL_ID = Convert.ToInt32(dt.Rows[0]["DEAL_ID"]);
orceProm.CAMPAIGN_ID = Convert.ToInt32(dt.Rows[0]["CAMPAIGN_ID"]);
orceProm.COUPON_GEN_COUNT = Convert.ToInt32(dt.Rows[0]["COUPON_GEN_COUNT"]);
orceProm.PROMOTION_NAME = Convert.ToString(dt.Rows[0]["PROMOTION_NAME"]);
orceProm.ORCE_COD_PROM = Convert.ToString(dt.Rows[0]["COUPON_CODE"]);
}
}
}
}
}
}
catch (Exception ex)
{
orceProm = null;
_error = ex.ToString();
}
return(orceProm);
}
public List <Ent_BataClub_Orce_Promotion> GET_ORCE_PROMOTION(int op = 0, string cod = "")
{
List <Ent_BataClub_Orce_Promotion> list = null;
string sqlquery = "[USP_GET_ORCE_PROMOTION]";
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;
cmd.Parameters.AddWithValue("@OP", op);
cmd.Parameters.AddWithValue("@Coupon_Code", cod);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_BataClub_Orce_Promotion>();
while (dr.Read())
{
Ent_BataClub_Orce_Promotion det_tdas = new Ent_BataClub_Orce_Promotion();
det_tdas.ORCE_COD_PROM = dr["ORCE_COD_PROM"].ToString();
det_tdas.ORCE_DES_PROM = dr["ORCE_DES_PROM"].ToString();
list.Add(det_tdas);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
public ActionResult GenerarCuponesOrce(string prefx)
{
string _mensaje = "";
Ent_BataClub_Orce_Promotion res = new Ent_BataClub_Orce_Promotion();
try
{
res = datOE.ORCE_CUPONES_BATACLUB_REFRESH(prefx, ref _mensaje);
if (_mensaje != "")
{
return(Json(new { estado = false, mensaje = _mensaje }));
}
else
{
return(Json(new { estado = true, orceProm = res, mensaje = _mensaje }));
}
}
catch (Exception ex)
{
return(Json(new { estado = false, mensaje = ex.Message }));
}
}
