public void InsertEmailStatus(SendEmail objmodel) { int intResult = 0; try { SendEmail objTblUser = new SendEmail(); objTblUser.SenderEmailAddress = objmodel.SenderEmailAddress; objTblUser.RecipientEmailAddress = objmodel.RecipientEmailAddress; objTblUser.Subject = objmodel.Subject; objTblUser.Body = objmodel.Body; objTblUser.DeliveryMethod = objmodel.DeliveryMethod; objTblUser.DeliveryTime = objmodel.DeliveryTime; objTblUser.Status = objmodel.Status; objTblUser.SendDate = objmodel.SendDate; dbmeals.SendEmails.Add(objTblUser); intResult = dbmeals.SaveChanges(); } catch (Exception ex) { } }
public void SendBulkMail(List<SendEmail> Receivers, string EventType) { string sender = "*****@*****.**"; string subject = ""; string Body = ""; string receiver = ""; SendEmail SendEmail = new SendEmail(); if (EventType == "Insert") { subject = "Data Has Been Inserted...!!!!"; Body = "The Record has been inserted to the Data Base with selected Table to be watched"; } else if (EventType == "Update") { subject = "Data Has Been Update...!!!!"; Body = "The Record has been Updated to the Table with selected Table to be watched"; } SendEmail.SenderEmailAddress = sender; SendEmail.Status = "Success"; SendEmail.SendDate = DateTime.Now.Date; SendEmail.Subject = subject; SendEmail.Body = Body; SendEmail.DeliveryTime = DateTime.Now; try { MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com"); mail.From = new MailAddress(sender); for (int i = 0; i < Receivers.Count; i++) { // receiver = Convert.ToString(Receivers[i].ReceiverID); SendEmail.RecipientEmailAddress = receiver; SendEmail.DeliveryMethod = "Test"; mail.Bcc.Add(receiver); mail.Subject = subject; mail.Body = Body; SmtpServer.Port = 587; SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Debanjan71"); SmtpServer.EnableSsl = true; SmtpServer.Send(mail); InsertEmailStatus(SendEmail); } } catch (Exception ex) { } }