public static List<GiftCardReport> GetGiftCardReport(int offset, int? limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<GiftCardReport> giftCardReports = AspxGiftCardProvider.GetGiftCardReport(offset, limit, objGiftcard, aspxCommonObj);
         return giftCardReports;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
示例#2
0
 public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <GiftCardReport> giftCardReports = AspxGiftCardProvider.GetGiftCardReport(offset, limit, objGiftcard, aspxCommonObj);
         return(giftCardReports);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List <GiftCardReport> GetGiftCardReport(int offset, int?limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         paramCol.Add(new KeyValuePair <string, object>("@offset", offset));
         paramCol.Add(new KeyValuePair <string, object>("@limit", limit));
         paramCol.Add(new KeyValuePair <string, object>("@FromDate", objGiftcard.FromDate));
         paramCol.Add(new KeyValuePair <string, object>("@ToDate", objGiftcard.ToDate));
         paramCol.Add(new KeyValuePair <string, object>("@SKU", objGiftcard.SKU));
         paramCol.Add(new KeyValuePair <string, object>("@ItemName", objGiftcard.ItemName));
         paramCol.Add(new KeyValuePair <string, object>("@GiftCardType", objGiftcard.GiftCardType));
         SQLHandler            sqlHl       = new SQLHandler();
         List <GiftCardReport> lstGiftCard =
             sqlHl.ExecuteAsList <GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]",
                                                  paramCol);
         return(lstGiftCard);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List<GiftCardReport> GetGiftCardReport(int offset, int? limit, GiftCardReport objGiftcard, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         paramCol.Add(new KeyValuePair<string, object>("@offset", offset));
         paramCol.Add(new KeyValuePair<string, object>("@limit", limit));
         paramCol.Add(new KeyValuePair<string, object>("@FromDate", objGiftcard.FromDate));
         paramCol.Add(new KeyValuePair<string, object>("@ToDate", objGiftcard.ToDate));
         paramCol.Add(new KeyValuePair<string, object>("@SKU", objGiftcard.SKU));
         paramCol.Add(new KeyValuePair<string, object>("@ItemName", objGiftcard.ItemName));
         paramCol.Add(new KeyValuePair<string, object>("@GiftCardType", objGiftcard.GiftCardType));               
         SQLHandler sqlHl = new SQLHandler();
         List<GiftCardReport> lstGiftCard =
             sqlHl.ExecuteAsList<GiftCardReport>("[dbo].[usp_Aspx_GetGiftCardReports]",
                                                 paramCol);
         return lstGiftCard;
     }
     catch (Exception e)
     {
         throw e;
     }
 }