public static List <MyRewardPointsInfo> GetMyRewardPointsHistory(int offset, int limit,
                                                                  AspxCommonInfo aspxCommonObj,
                                                                  RewardPointsHistoryCommonInfo
                                                                  RewardPointsHistoryCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
         parameterCollection.Add(new KeyValuePair <string, object>("@Offset", offset));
         parameterCollection.Add(new KeyValuePair <string, object>("@Limit", limit));
         parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair <string, object>("@CultureName", aspxCommonObj.CultureName));
         parameterCollection.Add(new KeyValuePair <string, object>("@CustomerID",
                                                                   RewardPointsHistoryCommonObj.CustomerID));
         parameterCollection.Add(new KeyValuePair <string, object>("@DateFrom",
                                                                   RewardPointsHistoryCommonObj.DateFrom));
         //parameterCollection.Add(new KeyValuePair<string, object>("@DateTo",
         //                                                        RewardPointsHistoryCommonObj.DateTo));
         SQLHandler sqLH = new SQLHandler();
         return(sqLH.ExecuteAsList <MyRewardPointsInfo>("usp_Aspx_RewardPointsHistoryCustomer",
                                                        parameterCollection));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List <RewardPointsHistryInfo> RewardPointsHistoryGetAll(int offset, int limit,
                                                                       AspxCommonInfo aspxCommonObj,
                                                                       RewardPointsHistoryCommonInfo
                                                                       RewardPointsHistoryCommonObj)
 {
     try
     {
         List <RewardPointsHistryInfo> histryInfos = RewardPointsProvider.RewardPointsHistoryGetAll(offset, limit,
                                                                                                    aspxCommonObj,
                                                                                                    RewardPointsHistoryCommonObj);
         return(histryInfos);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List <MyRewardPointsInfo> GetMyRewardPointsHistory(int offset, int limit,
                                                                  AspxCommonInfo aspxCommonObj,
                                                                  RewardPointsHistoryCommonInfo
                                                                  RewardPointsHistoryCommonObj)
 {
     try
     {
         List <MyRewardPointsInfo> history = RewardPointsProvider.GetMyRewardPointsHistory(offset, limit,
                                                                                           aspxCommonObj,
                                                                                           RewardPointsHistoryCommonObj);
         ;
         return(history);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Beispiel #4
0
 public static List <RewardPointsHistryInfo> RewardPointsHistoryGetAll(int offset, int limit,
                                                                       AspxCommonInfo aspxCommonObj,
                                                                       RewardPointsHistoryCommonInfo
                                                                       RewardPointsHistoryCommonObj)
 {
     try
     {
         List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
         parameterCollection.Add(new KeyValuePair <string, object>("Offset", offset));
         parameterCollection.Add(new KeyValuePair <string, object>("Limit", limit));
         parameterCollection.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
         parameterCollection.Add(new KeyValuePair <string, object>("CustomerName",
                                                                   RewardPointsHistoryCommonObj.CustomerName));
         parameterCollection.Add(new KeyValuePair <string, object>("Email", RewardPointsHistoryCommonObj.Email));
         OracleHandler sqLH = new OracleHandler();
         return(sqLH.ExecuteAsList <RewardPointsHistryInfo>("usp_Aspx_RewardPointsHistory", parameterCollection));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List<RewardPointsHistryInfo> RewardPointsHistoryGetAll(int offset, int limit,
                                                                      AspxCommonInfo aspxCommonObj,
                                                                      RewardPointsHistoryCommonInfo
                                                                          RewardPointsHistoryCommonObj)
 {
     try
     {
         List<RewardPointsHistryInfo> histryInfos = RewardPointsProvider.RewardPointsHistoryGetAll(offset, limit,
                                                                                                   aspxCommonObj,
                                                                                                   RewardPointsHistoryCommonObj);
         return histryInfos;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List<MyRewardPointsInfo> GetMyRewardPointsHistory(int offset, int limit,
                                                                 AspxCommonInfo aspxCommonObj,
                                                                 RewardPointsHistoryCommonInfo
                                                                     RewardPointsHistoryCommonObj)
 {
     try
     {
         List<MyRewardPointsInfo> history = RewardPointsProvider.GetMyRewardPointsHistory(offset, limit,
                                                                                          aspxCommonObj,
                                                                                          RewardPointsHistoryCommonObj);
         ;
         return history;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public static List<RewardPointsHistryInfo> RewardPointsHistoryGetAll(int offset, int limit,
                                                                      AspxCommonInfo aspxCommonObj,
                                                                      RewardPointsHistoryCommonInfo
                                                                          RewardPointsHistoryCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
         parameterCollection.Add(new KeyValuePair<string, object>("@Offset", offset));
         parameterCollection.Add(new KeyValuePair<string, object>("@Limit", limit));
         parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
         parameterCollection.Add(new KeyValuePair<string, object>("@CustomerName",
                                                                  RewardPointsHistoryCommonObj.CustomerName));
         parameterCollection.Add(new KeyValuePair<string, object>("@Email", RewardPointsHistoryCommonObj.Email));
         SQLHandler sqLH = new SQLHandler();
         return sqLH.ExecuteAsList<RewardPointsHistryInfo>("usp_Aspx_RewardPointsHistory", parameterCollection);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }