public void SendReceivedEmail(string ConnString, string EmailAddress,string itemail,string password, int ticketid)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlDataAdapter da = new SqlDataAdapter("spGetReceivedEmail", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
string Body = ds.Tables[0].Rows[0]["EmailBody"].ToString();
string Subject = ds.Tables[0].Rows[0]["EmailSubject"].ToString();
string subject = Subject.Replace("TICKETNUMBER", ticketid.ToString());
SendEmail se = new SendEmail();
se.ReceivedEmail(itemail,password,EmailAddress, Body, subject,ConnString);
}
public void SendOverDueEmail(string ConnString, string itemail, string password)
{
SqlConnection conn = new SqlConnection(ConnString);
SqlDataAdapter da = new SqlDataAdapter("spGetOverDueReceivedTickets", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i <= ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j <= ds.Tables[1].Rows.Count; j++)
{
string Subject = ds.Tables[2].Rows[0]["EmailSubject"].ToString();
string subject = Subject.Replace("(TICKETNUMBER)", ds.Tables[0].Rows[0]["TicketID"].ToString());
string Body = ds.Tables[2].Rows[0]["EmailBody"].ToString();
string body = Body.Replace("(TICKET)", ds.Tables[0].Rows[0]["TicketID"].ToString());
string EA = ds.Tables[1].Rows[j]["EmailAddress"].ToString();
int ticketid = Convert.ToInt32(ds.Tables[0].Rows[i]["TicketID"]);
SendEmail se = new SendEmail();
try
{
se.OverDueTickets(itemail, password, subject, EA, body, ticketid,ConnString);
}
catch
{
return;
}
}
SqlCommand comm = new SqlCommand("spUpdateTicketsSent", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@TicketID",ds.Tables[0].Rows[i]["TicketID"]);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
}
}
