public List <CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, 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>("@CouponID", bindCouponUserObj.CouponID));
parameter.Add(new KeyValuePair <string, object>("@CouponCode", bindCouponUserObj.CouponCode));
parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", bindCouponUserObj.CouponStatusID));
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 <CouponUserListInfo>("[usp_Aspx_GetCouponUserList]", parameter));
}
public static List <CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, 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>("@CouponID", bindCouponUserObj.CouponID));
parameter.Add(new KeyValuePair <string, object>("@CouponCode", bindCouponUserObj.CouponCode));
parameter.Add(new KeyValuePair <string, object>("@CouponStatusID", bindCouponUserObj.CouponStatusID));
SQLHandler sqlH = new SQLHandler();
List <CouponUserListInfo> lstCoupUser = sqlH.ExecuteAsList <CouponUserListInfo>("[usp_Aspx_GetCouponUserList]", parameter);
return(lstCoupUser);
}
public List<CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, AspxCommonInfo aspxCommonObj)
{
try
{
List<CouponUserListInfo> lstCoupUser = AspxCouponManageController.GetCouponUserList(offset, limit, bindCouponUserObj, aspxCommonObj);
return lstCoupUser;
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, AspxCommonInfo aspxCommonObj)
{
List <CouponUserListInfo> lstCoupUser = AspxCouponManageProvider.GetCouponUserList(offset, limit, bindCouponUserObj, aspxCommonObj);
return(lstCoupUser);
}
public List<CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, 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>("@CouponID", bindCouponUserObj.CouponID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", bindCouponUserObj.CouponCode));
parameter.Add(new KeyValuePair<string, object>("@CouponStatusID", bindCouponUserObj.CouponStatusID));
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<CouponUserListInfo>("[usp_Aspx_GetCouponUserList]", parameter);
}
public static List<CouponUserListInfo> GetCouponUserList(int offset, int limit, CouponCommonInfo bindCouponUserObj, 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>("@CouponID", bindCouponUserObj.CouponID));
parameter.Add(new KeyValuePair<string, object>("@CouponCode", bindCouponUserObj.CouponCode));
parameter.Add(new KeyValuePair<string, object>("@CouponStatusID", bindCouponUserObj.CouponStatusID));
SQLHandler sqlH = new SQLHandler();
List<CouponUserListInfo> lstCoupUser = sqlH.ExecuteAsList<CouponUserListInfo>("[usp_Aspx_GetCouponUserList]", parameter);
return lstCoupUser;
}
catch (Exception ex)
{
throw ex;
}
}