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;
}
}
