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