public List <CouponUserInfo> GetCouponUserDetails(int offset, int?limit, GetCouponUserDetailInfo couponUserObj, 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>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair <string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidTo", couponUserObj.ValidTo)); 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 <CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter)); }
public static List <CouponUserInfo> GetCouponUserDetails(int offset, int?limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair <string, object>("@UserName", userName)); parameter.Add(new KeyValuePair <string, object>("@offset", offset)); parameter.Add(new KeyValuePair <string, object>("@limit", limit)); parameter.Add(new KeyValuePair <string, object>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair <string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair <string, object>("@ValidTo", couponUserObj.ValidTo)); SQLHandler sqlH = new SQLHandler(); List <CouponUserInfo> lstCoupUser = sqlH.ExecuteAsList <CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter); return(lstCoupUser); }
public List<CouponUserInfo> GetCouponUserDetails(int offset, int? limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { try { List<CouponUserInfo> lstCoupUser = AspxCouponManageController.GetCouponUserDetails(offset, limit, couponUserObj, aspxCommonObj, userName); return lstCoupUser; } catch (Exception ex) { throw ex; } }
public static List <CouponUserInfo> GetCouponUserDetails(int offset, int?limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { List <CouponUserInfo> lstCoupUser = AspxCouponManageProvider.GetCouponUserDetails(offset, limit, couponUserObj, aspxCommonObj, userName); return(lstCoupUser); }
public List<CouponUserInfo> GetCouponUserDetails(int offset, int? limit, GetCouponUserDetailInfo couponUserObj, 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>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair<string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair<string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair<string, object>("@ValidTo", couponUserObj.ValidTo)); 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<CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter); }
public static List<CouponUserInfo> GetCouponUserDetails(int offset, int? limit, GetCouponUserDetailInfo couponUserObj, AspxCommonInfo aspxCommonObj, string userName) { try { List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj); parameter.Add(new KeyValuePair<string, object>("@UserName", userName)); parameter.Add(new KeyValuePair<string, object>("@offset", offset)); parameter.Add(new KeyValuePair<string, object>("@limit", limit)); parameter.Add(new KeyValuePair<string, object>("@CouponCode", couponUserObj.CouponCode)); parameter.Add(new KeyValuePair<string, object>("@CouponStatusID", couponUserObj.CouponStatusID)); parameter.Add(new KeyValuePair<string, object>("@ValidFrom", couponUserObj.ValidFrom)); parameter.Add(new KeyValuePair<string, object>("@ValidTo", couponUserObj.ValidTo)); SQLHandler sqlH = new SQLHandler(); List<CouponUserInfo> lstCoupUser = sqlH.ExecuteAsList<CouponUserInfo>("usp_Aspx_CouponUserDetails", parameter); return lstCoupUser; } catch (Exception ex) { throw ex; } }