public void Save(EmailAlertEntity item)
{
string threshold;
if (item.Threshold == 0)
{
threshold = null;
}
else
{
threshold = item.Threshold.ToString();
}
using (var context = new DataAccessFramework.DBConnection.DBConnectionContext(DatabaseName.CuMaster))
{
SqlParameter[] sparams = new SqlParameter[6];
sparams[0] = new SqlParameter("Email", item.Email);
sparams[1] = new SqlParameter("CurrencyFrom", item.CurrencyFrom);
sparams[2] = new SqlParameter("CurrencyTo", item.CurrencyTo);
if (item.TimeToSend.Value.TotalMinutes == 0)
{
sparams[3] = new SqlParameter("Threshold", threshold);
}
else
{
sparams[3] = new SqlParameter("TimetoSend", item.TimeToSend);
}
sparams[4] = new SqlParameter("SessionID", item.SessionID);
sparams[5] = new SqlParameter("AlertID", item.AlertID);
context.ExecuteNonResultSproc("usp_SaveEmailAlert", sparams);
}
}
public void Delete(EmailAlertEntity item)
{
this.Delete(item.AlertID);
}
