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