public static List <CouponPerSalesViewDetailInfo> GetCouponPerSalesDetailView(int offset, int?limit, CouponPerSalesGetInfo couponPerSaesObj, AspxCommonInfo aspxCommonObj) { try { List <KeyValuePair <string, object> > parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair <string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair <string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair <string, object>("@CouponCode", couponPerSaesObj.CouponCode)); parameterCollection.Add(new KeyValuePair <string, object>("@OrderId", couponPerSaesObj.OrderID)); parameterCollection.Add(new KeyValuePair <string, object>("@CouponAmountFrom", couponPerSaesObj.CouponAmountFrom)); parameterCollection.Add(new KeyValuePair <string, object>("@CouponAmountTo", couponPerSaesObj.CouponAmountTo)); parameterCollection.Add(new KeyValuePair <string, object>("@GrandTotalAmountFrom", couponPerSaesObj.GrandTotalAmountFrom)); parameterCollection.Add(new KeyValuePair <string, object>("@GrandTotalAmountTo", couponPerSaesObj.GrandTotalAmountTo)); SQLHandler sqlH = new SQLHandler(); List <CouponPerSalesViewDetailInfo> lstCoupPSVDetail = sqlH.ExecuteAsList <CouponPerSalesViewDetailInfo>("[dbo].[usp_Aspx_GetCouponPerSalesDetailView]", parameterCollection); return(lstCoupPSVDetail); } catch (Exception e) { throw e; } }
public static List <CouponPerSalesViewDetailInfo> GetCouponPerSalesDetailView(int offset, int?limit, CouponPerSalesGetInfo couponPerSaesObj, AspxCommonInfo aspxCommonObj) { try { List <CouponPerSalesViewDetailInfo> lstCoupPSVDetail = AspxCouponManageProvider.GetCouponPerSalesDetailView(offset, limit, couponPerSaesObj, aspxCommonObj); return(lstCoupPSVDetail); } catch (Exception e) { throw e; } }
public List<CouponPerSalesViewDetailInfo> GetCouponPerSalesDetailView(int offset, int? limit, CouponPerSalesGetInfo couponPerSaesObj, AspxCommonInfo aspxCommonObj) { try { List<CouponPerSalesViewDetailInfo> lstCoupPSVDetail = AspxCouponManageController.GetCouponPerSalesDetailView(offset, limit, couponPerSaesObj, aspxCommonObj); return lstCoupPSVDetail; } catch (Exception ex) { throw ex; } }
public static List<CouponPerSalesViewDetailInfo> GetCouponPerSalesDetailView(int offset, int? limit, CouponPerSalesGetInfo couponPerSaesObj, AspxCommonInfo aspxCommonObj) { try { List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj); parameterCollection.Add(new KeyValuePair<string, object>("@offset", offset)); parameterCollection.Add(new KeyValuePair<string, object>("@limit", limit)); parameterCollection.Add(new KeyValuePair<string, object>("@CouponCode", couponPerSaesObj.CouponCode)); parameterCollection.Add(new KeyValuePair<string, object>("@OrderId", couponPerSaesObj.OrderID)); parameterCollection.Add(new KeyValuePair<string, object>("@CouponAmountFrom", couponPerSaesObj.CouponAmountFrom)); parameterCollection.Add(new KeyValuePair<string, object>("@CouponAmountTo", couponPerSaesObj.CouponAmountTo)); parameterCollection.Add(new KeyValuePair<string, object>("@GrandTotalAmountFrom", couponPerSaesObj.GrandTotalAmountFrom)); parameterCollection.Add(new KeyValuePair<string, object>("@GrandTotalAmountTo", couponPerSaesObj.GrandTotalAmountTo)); SQLHandler sqlH = new SQLHandler(); List<CouponPerSalesViewDetailInfo> lstCoupPSVDetail = sqlH.ExecuteAsList<CouponPerSalesViewDetailInfo>("[dbo].[usp_Aspx_GetCouponPerSalesDetailView]", parameterCollection); return lstCoupPSVDetail; } catch (Exception e) { throw e; } }