public void AddEmailQue(tblEmailQue model) { using (LoanPriceEntities context = new LoanPriceEntities()) { tblEmailQue que = context.tblEmailQues.FirstOrDefault(c => EntityFunctions.TruncateTime(c.SendTime) == EntityFunctions.TruncateTime(model.SendTime)); if (que == null) { context.tblEmailQues.AddObject(model); context.SaveChanges(); } } }
public static void SendEmailToSelectedGroup(string body, string subject, string attachment = "") { SmtpClient client = new SmtpClient(); MailMessage msg = new MailMessage(); // Populate the SmtpClient and MailMessage with the setting in the Web.config GetMailSettings(client, msg); // get selected group emails EmailGroupsBL bl = new EmailGroupsBL(); foreach (var item in bl.GetEmailReceiver()) { msg.To.Add(new MailAddress(item.Name)); } msg.Subject = subject; msg.IsBodyHtml = true; msg.Body = body; if (!string.IsNullOrEmpty(attachment)) { msg.Attachments.Add(new Attachment(attachment)); } EmailQueBL queBl = new EmailQueBL(); tblEmailQue que = new tblEmailQue(); que.Name = subject; que.SendTime = DateTime.Now; que.IsSent = false; try { if (!queBl.IsTodayEmailSent()) { client.Send(msg); que.IsSent = true; } } catch (Exception ex) { //throw ex; } finally { queBl.AddEmailQue(que); } }
public bool IsTodayEmailSent() { using (LoanPriceEntities context = new LoanPriceEntities()) { DateTime date = DateTime.Now.Date; tblEmailQue que = context.tblEmailQues.FirstOrDefault(c => EntityFunctions.TruncateTime(c.SendTime) == date); if (que == null) { return(false); } else { return(que.IsSent); } } }