private void SendEmail(int reqID) { RequestsDB requestDB = new RequestsDB(); DataTable mContact = requestDB.GetRequest(reqID); String contact = mContact.Rows[0]["Email"].ToString(); String part = mContact.Rows[0]["PartNumber"].ToString(); String requestor = mContact.Rows[0]["Requestor"].ToString(); if (contact != "none") { SmtpClient smtpClient = new SmtpClient("hiomail.w2k.feico.com"); smtpClient.UseDefaultCredentials = false; smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network; smtpClient.EnableSsl = false; MailMessage mail = new MailMessage(); //Setting From , To, Subject, and Body mail.From = new MailAddress("*****@*****.**"); mail.To.Add(new MailAddress(contact)); mail.Subject = "Cleaning Job Finished"; mail.Body = "Part - " + part + ", requested by " + requestor + " has finished cleaning, and is ready to be picked up." + "\n\nPlease pick up " + part + " from cleaning." + "\n\nThank You"; smtpClient.Send(mail); } }
private void bGWDetails_DoWork(object sender, DoWorkEventArgs e) { int requestId = (int)e.Argument; RequestsDB reqDB = new RequestsDB(); DataTable reqTable = reqDB.GetRequest(requestID); DataTable gunTable = reqDB.GetGunTable(); List<DataTable> tables = new List<DataTable>(); tables.Add(reqTable); tables.Add(gunTable); e.Result = tables; }