public static List <CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", couponDetailObj.CouponTypeID));
parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponDetailObj.CouponCode));
parameter.Add(new KeyValuePair <string, object>("@ValidateFrom", couponDetailObj.ValidateFrom));
parameter.Add(new KeyValuePair <string, object>("@ValidateTo", couponDetailObj.ValidateTo));
SQLHandler sqlH = new SQLHandler();
List <CouponInfo> lstCoupon = sqlH.ExecuteAsList <CouponInfo>("usp_Aspx_GetCouponDetails", parameter);
return(lstCoupon);
}
public List<CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@offset", offset));
parameter.Add(new KeyValuePair<string, object>("@limit", limit));
parameter.Add(new KeyValuePair<string, object>("@CouponTypeID", couponDetailObj.CouponTypeID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponDetailObj.CouponCode));
parameter.Add(new KeyValuePair<string, object>("@ValidateFrom", couponDetailObj.ValidateFrom));
parameter.Add(new KeyValuePair<string, object>("@ValidateTo", couponDetailObj.ValidateTo));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteAsList<CouponInfo>("usp_Aspx_GetCouponDetails", parameter);
}
public List <CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@offset", offset));
parameter.Add(new KeyValuePair <string, object>("@limit", limit));
parameter.Add(new KeyValuePair <string, object>("@CouponTypeID", couponDetailObj.CouponTypeID));
parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponDetailObj.CouponCode));
parameter.Add(new KeyValuePair <string, object>("@ValidateFrom", couponDetailObj.ValidateFrom));
parameter.Add(new KeyValuePair <string, object>("@ValidateTo", couponDetailObj.ValidateTo));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
return(sqlH.ExecuteAsList <CouponInfo>("usp_Aspx_GetCouponDetails", parameter));
}
public static List<CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@offset", offset));
parameter.Add(new KeyValuePair<string, object>("@limit", limit));
parameter.Add(new KeyValuePair<string, object>("@CouponTypeID", couponDetailObj.CouponTypeID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponDetailObj.CouponCode));
parameter.Add(new KeyValuePair<string, object>("@ValidateFrom", couponDetailObj.ValidateFrom));
parameter.Add(new KeyValuePair<string, object>("@ValidateTo", couponDetailObj.ValidateTo));
SQLHandler sqlH = new SQLHandler();
List<CouponInfo> lstCoupon = sqlH.ExecuteAsList<CouponInfo>("usp_Aspx_GetCouponDetails", parameter);
return lstCoupon;
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponInfo> GetCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<CouponInfo> lstCoupon = AspxCouponManageController.BindAllCouponDetails(offset, limit, couponDetailObj, aspxCommonObj);
return lstCoupon;
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CouponInfo> BindAllCouponDetails(int offset, int limit, GetCouponDetailsInfo couponDetailObj, AspxCommonInfo aspxCommonObj)
{
List <CouponInfo> lstCoupon = AspxCouponManageProvider.BindAllCouponDetails(offset, limit, couponDetailObj, aspxCommonObj);
return(lstCoupon);
}