public List <EmailData> GetPMReminderData()
{
List <EmailData> emails = new List <EmailData>();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand myCommand = new SqlCommand("Mfg_PMReminder", conn))
{
myCommand.CommandType = CommandType.StoredProcedure;
using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
EmailData ed = new EmailData();
ed.ID = Convert.ToInt64(dr["RequestedID"]);
ed.Email = dr["Email"].ToString();
ed.Issue = dr["Body"].ToString();
ed.Subject = dr["Subject"].ToString();
ed.StartDate = Convert.ToDateTime(dr["StartDate"].ToString());
ed.EndDate = Convert.ToDateTime(dr["EndDate"].ToString());
emails.Add(ed);
}
}
}
}
return(emails);
}
public int AddHistory(EmailData ed)
{
decimal parameterErrorCode = 0;
using (var conn = new SqlConnection(ConnectionString))
{
conn.Open();
string strSQL = "INSERT INTO Mfg_EmailPMReminderHistory(TicketID, Subject, Body, ScheduleStart, ScheduleEnd, SentDate, AssignTo) values (@TicketID, @Subject, @Body, @ScheduleStart, @ScheduleEnd, @SentDate, @AssignTo)";
using (SqlCommand cmd = new SqlCommand(strSQL, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@TicketID", ed.ID));
cmd.Parameters.Add(new SqlParameter("@Subject", ed.Subject));
cmd.Parameters.Add(new SqlParameter("@Body", ed.Issue));
cmd.Parameters.Add(new SqlParameter("@ScheduleStart", ed.StartDate));
cmd.Parameters.Add(new SqlParameter("@ScheduleEnd", ed.EndDate));
cmd.Parameters.Add(new SqlParameter("@SentDate", pm_currentDate));
cmd.Parameters.Add(new SqlParameter("@AssignTo", ed.Email));
try
{
parameterErrorCode = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
parameterErrorCode = -1;
}
}
}
return(Convert.ToInt32(parameterErrorCode));
}
public bool Send(EmailData ed)
{
bool FunctionValue = false;
List <String> to = new List <string>();
to.Add(ed.Email);
Hashtable templateVars = new Hashtable();
templateVars.Add("Today", pm_currentDate.ToString("MM/dd/yyyy HH:mm:ss"));
templateVars.Add("ID", ed.ID.ToString());
templateVars.Add("Issue", ed.Issue);
templateVars.Add("Scheduled", ed.StartDate.ToString("MM/dd/yyyy hh:mm") + " to " + ed.EndDate.ToString("MM/dd/yyyy hh:mm"));
SellarsEmail.TemplateEmail te = new SellarsEmail.TemplateEmail();
te.From = emailFromAddress;
te.To = to;
te.Subject = ed.Subject;
te.TemplateVariables = templateVars;
te.TemplateName = emailTemplate;
te.Send();
FunctionValue = true;
return(FunctionValue);
}
