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(); } } }