public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@RewardPointSettingsID",
rewardPointsCommonObj.RewardPointSettingsID));
parameter.Add(new KeyValuePair <string, object>("@RewardRuleName", rewardPointsCommonObj.RewardRuleName));
parameter.Add(new KeyValuePair <string, object>("@RewardRuleID", rewardPointsCommonObj.RewardRuleID));
parameter.Add(new KeyValuePair <string, object>("@RewardRuleType", rewardPointsCommonObj.RewardRuleType));
parameter.Add(new KeyValuePair <string, object>("@RewardPoints", rewardPointsCommonObj.RewardPoints));
parameter.Add(new KeyValuePair <string, object>("@PurchaseAmount", rewardPointsCommonObj.PurchaseAmount));
parameter.Add(new KeyValuePair <string, object>("@IsActive", rewardPointsCommonObj.IsActive));
parameter.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveUpdateNewRule", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static List <RewardPointsSettingInfo> RewardPointsSettingGetAll(int offset, int limit,
AspxCommonInfo aspxCommonObj,
RewardPointsCommonInfo
rewardPointsCommonObj)
{
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>("@RewardRuleName",
rewardPointsCommonObj.RewardRuleName));
parameterCollection.Add(new KeyValuePair <string, object>("@IsActive", rewardPointsCommonObj.IsActive));
SQLHandler sqLH = new SQLHandler();
List <RewardPointsSettingInfo> lstRewardPointSet =
sqLH.ExecuteAsList <RewardPointsSettingInfo>("usp_Aspx_RewardPointsSettingGetAll",
parameterCollection);
return(lstRewardPointSet);
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
SQLHandler sqlH = new SQLHandler();
List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
parameter.Add(new KeyValuePair<string, object>("@RewardPointSettingsID",
rewardPointsCommonObj.RewardPointSettingsID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleName", rewardPointsCommonObj.RewardRuleName));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleID", rewardPointsCommonObj.RewardRuleID));
parameter.Add(new KeyValuePair<string, object>("@RewardRuleType", rewardPointsCommonObj.RewardRuleType));
parameter.Add(new KeyValuePair<string, object>("@RewardPoints", rewardPointsCommonObj.RewardPoints));
parameter.Add(new KeyValuePair<string, object>("@PurchaseAmount", rewardPointsCommonObj.PurchaseAmount));
parameter.Add(new KeyValuePair<string, object>("@IsActive", rewardPointsCommonObj.IsActive));
parameter.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair<string, object>("@CulturName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveUpdateNewRule", parameter);
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsRuleDelete(RewardPointsCommonInfo rewardPointCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsRuleDelete(rewardPointCommonObj, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsSaveUpdateNewRule(rewardPointsCommonObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsRuleDelete(RewardPointsCommonInfo rewardPointCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsRuleDelete(rewardPointCommonObj, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsSaveUpdateNewRule(RewardPointsCommonInfo rewardPointsCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsSaveUpdateNewRule(rewardPointsCommonObj, aspxCommonObj);
}
catch (Exception e)
{
throw e;
}
}
public static List <RewardPointsSettingInfo> RewardPointsSettingGetAll(int offset, int limit,
AspxCommonInfo aspxCommonObj,
RewardPointsCommonInfo
rewardPointsCommonObj)
{
try
{
List <RewardPointsSettingInfo> lstRewardPointSet = RewardPointsProvider.RewardPointsSettingGetAll(
offset, limit, aspxCommonObj, rewardPointsCommonObj);
return(lstRewardPointSet);
}
catch (Exception e)
{
throw e;
}
}
public static List<RewardPointsSettingInfo> RewardPointsSettingGetAll(int offset, int limit,
AspxCommonInfo aspxCommonObj,
RewardPointsCommonInfo
rewardPointsCommonObj)
{
try
{
List<RewardPointsSettingInfo> lstRewardPointSet = RewardPointsProvider.RewardPointsSettingGetAll(
offset, limit, aspxCommonObj, rewardPointsCommonObj);
return lstRewardPointSet;
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsRuleDelete(RewardPointsCommonInfo rewardPointCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@RewardPointSettingsID",
rewardPointCommonObj.RewardPointSettingsID));
parameterCollection.Add(new KeyValuePair <string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair <string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsRuleDelete", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
public static List<RewardPointsSettingInfo> RewardPointsSettingGetAll(int offset, int limit,
AspxCommonInfo aspxCommonObj,
RewardPointsCommonInfo
rewardPointsCommonObj)
{
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>("@RewardRuleName",
rewardPointsCommonObj.RewardRuleName));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", rewardPointsCommonObj.IsActive));
SQLHandler sqLH = new SQLHandler();
List<RewardPointsSettingInfo> lstRewardPointSet =
sqLH.ExecuteAsList<RewardPointsSettingInfo>("usp_Aspx_RewardPointsSettingGetAll",
parameterCollection);
return lstRewardPointSet;
}
catch (Exception e)
{
throw e;
}
}
public static void RewardPointsRuleDelete(RewardPointsCommonInfo rewardPointCommonObj,
AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@RewardPointSettingsID",
rewardPointCommonObj.RewardPointSettingsID));
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsRuleDelete", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}