public static List<GiftCardGrid> GetAllPaidGiftCard(int offset, int limit, AspxCommonInfo aspxCommonObj, GiftCardDataInfo giftCardDataObj)
 {
     try
     {
         List<GiftCardGrid> ii = AspxGiftCardProvider.GetAllPaidGiftCard(offset, limit, aspxCommonObj, giftCardDataObj);
         return ii;
     }
     catch (Exception e)
     {
         throw e;
     }
 }
Example #2
0
 public static List <GiftCardGrid> GetAllPaidGiftCard(int offset, int limit, AspxCommonInfo aspxCommonObj, GiftCardDataInfo giftCardDataObj)
 {
     try
     {
         List <GiftCardGrid> ii = AspxGiftCardProvider.GetAllPaidGiftCard(offset, limit, aspxCommonObj, giftCardDataObj);
         return(ii);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
 public static List <GiftCardGrid> GetAllPaidGiftCard(int offset, int limit, AspxCommonInfo aspxCommonObj, GiftCardDataInfo giftCardDataObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameter.Add(new KeyValuePair <string, object>("@offset", offset));
         parameter.Add(new KeyValuePair <string, object>("@limit", limit));
         parameter.Add(new KeyValuePair <string, object>("@OrderID", giftCardDataObj.OrderID));
         parameter.Add(new KeyValuePair <string, object>("@GiftCardCode", giftCardDataObj.GiftcardCode));
         parameter.Add(new KeyValuePair <string, object>("@Balance", giftCardDataObj.Balance));
         parameter.Add(new KeyValuePair <string, object>("@BalanceTo", giftCardDataObj.BalanceTo));
         parameter.Add(new KeyValuePair <string, object>("@StartDate", giftCardDataObj.StartDate));
         parameter.Add(new KeyValuePair <string, object>("@EndDate", giftCardDataObj.EndDate));
         parameter.Add(new KeyValuePair <string, object>("@Status", giftCardDataObj.Status));
         SQLHandler          sqlH = new SQLHandler();
         List <GiftCardGrid> ii   = sqlH.ExecuteAsList <GiftCardGrid>("[usp_Aspx_GetAllPaidGiftCard]", parameter);
         return(ii);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
        public static List<GiftCardGrid> GetAllPaidGiftCard(int offset, int limit, AspxCommonInfo aspxCommonObj, GiftCardDataInfo giftCardDataObj)
        {
            try
            {
                List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
                parameter.Add(new KeyValuePair<string, object>("@offset", offset));
                parameter.Add(new KeyValuePair<string, object>("@limit", limit));
                parameter.Add(new KeyValuePair<string, object>("@OrderID", giftCardDataObj.OrderID));
                parameter.Add(new KeyValuePair<string, object>("@GiftCardCode", giftCardDataObj.GiftcardCode));
                parameter.Add(new KeyValuePair<string, object>("@Balance", giftCardDataObj.Balance));
                parameter.Add(new KeyValuePair<string, object>("@BalanceTo", giftCardDataObj.BalanceTo));
                parameter.Add(new KeyValuePair<string, object>("@StartDate", giftCardDataObj.StartDate));
                parameter.Add(new KeyValuePair<string, object>("@EndDate", giftCardDataObj.EndDate));
                parameter.Add(new KeyValuePair<string, object>("@Status", giftCardDataObj.Status));
                SQLHandler sqlH = new SQLHandler();
                List<GiftCardGrid> ii = sqlH.ExecuteAsList<GiftCardGrid>("[usp_Aspx_GetAllPaidGiftCard]", parameter);
                return ii;

            }
            catch (Exception e)
            {
                throw e;
            }
        }