public static void RewardPointsDeleteNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsDeleteNewsLetter(rewardPointsInfo, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsDeleteNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
List <KeyValuePair <string, object> > parameterCollection = new List <KeyValuePair <string, object> >();
parameterCollection.Add(new KeyValuePair <string, object>("@RewardRuleID", rewardPointsInfo.RewardRuleID));
parameterCollection.Add(new KeyValuePair <string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameterCollection.Add(new KeyValuePair <string, object>("@UserName", aspxCommonObj.UserName));
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_RewardPointsDeleteNewsLetter", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsSaveNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
OracleHandler sqlH = new OracleHandler();
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("RewardRuleID", rewardPointsInfo.RewardRuleID));
parameter.Add(new KeyValuePair <string, object>("StoreID", aspxCommonObj.StoreID));
parameter.Add(new KeyValuePair <string, object>("PortalID", aspxCommonObj.PortalID));
parameter.Add(new KeyValuePair <string, object>("CultureName", aspxCommonObj.CultureName));
parameter.Add(new KeyValuePair <string, object>("CustomerID", aspxCommonObj.CustomerID));
parameter.Add(new KeyValuePair <string, object>("UserName", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("Email", rewardPointsInfo.Email));
sqlH.ExecuteNonQuery("usp_Aspx_RewardPointsSaveNewsLetter", parameter);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsDeleteNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
RewardPointsProvider.RewardPointsDeleteNewsLetter(rewardPointsInfo, aspxCommonObj);
}
catch (Exception ex)
{
throw ex;
}
}
public static void RewardPointsDeleteNewsLetter(RewardPointsNLCommonInfo rewardPointsInfo,
AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@RewardRuleID", rewardPointsInfo.RewardRuleID));
parameterCollection.Add(new KeyValuePair<string, object>("@CustomerID", aspxCommonObj.CustomerID));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
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_RewardPointsDeleteNewsLetter", parameterCollection);
}
catch (Exception ex)
{
throw ex;
}
}