internal int AddUpdateMassMail(MassMailAddInfo objMassMail, string username)
{
List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >();
Param.Add(new KeyValuePair <string, object>("@MassMailID", objMassMail.MassMailID));
Param.Add(new KeyValuePair <string, object>("@MessageMailTitle", objMassMail.MessageTitle));
Param.Add(new KeyValuePair <string, object>("@FilterTypeID", objMassMail.FilterTypeID));
Param.Add(new KeyValuePair <string, object>("@FilterValue", objMassMail.FilterValue));
Param.Add(new KeyValuePair <string, object>("@AdditionalUser", objMassMail.AdditionalUser));
Param.Add(new KeyValuePair <string, object>("@Subject", objMassMail.Subject));
Param.Add(new KeyValuePair <string, object>("@MessageBody", objMassMail.MessageBody));
Param.Add(new KeyValuePair <string, object>("@ScheduleType", objMassMail.ScheduleType));
Param.Add(new KeyValuePair <string, object>("@ScheduledOn", objMassMail.ScheduledOn));
Param.Add(new KeyValuePair <string, object>("@Username", username));
SQLHandler objHandler = new SQLHandler();
try
{
return(objHandler.ExecuteNonQuery("[dbo].[usp_SCAdmin_AddUpdateMassMail]", Param, "@output"));
}
catch (Exception ex)
{
return(-2);
//base.ProcessExcetion(ex);
}
}
public int AddUpdateMassMail(MassMailAddInfo objMassMail, string username)
{
MassMailProvider objProvider = new MassMailProvider();
if (objMassMail.ScheduleType == 1)
{
objMassMail.ScheduledOn = DateTime.UtcNow.ToLocalTime().ToString();
}
int status = objProvider.AddUpdateMassMail(objMassMail, username);
if (status > 0)
{
CallAPIForMail(objMassMail.ScheduledOn);
}
return(status);
}