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