private static void sendEmailSchedule()
{
using (SendMailEntities db = new SendMailEntities())
{
List<TempScheduleSendEmail> list_temp = new List<TempScheduleSendEmail>();
List<LogSendEmail> lst_logEndEmail = new List<LogSendEmail>();
TempScheduleSendEmail latest = db.TempScheduleSendEmails.Where(x => x.IDUser == mGlobal.UserID).ToList().OrderBy(m => m.TimeSchedule).FirstOrDefault();
list_temp = db.TempScheduleSendEmails.Where(x => x.TimeSchedule == latest.TimeSchedule && x.IDUser == mGlobal.UserID).ToList();
Int64 idEmailOwn = Int64.Parse(list_temp[0].IDEmailOwn.ToString());
EmailOwn emailOwn = db.EmailOwns.FirstOrDefault(x => x.ID == idEmailOwn);
foreach (var item in list_temp)
{
//get contact
Contact contact = db.Contacts.FirstOrDefault(x => x.Email == item.Email);
//save log send email
LogSendEmail log = new LogSendEmail();
if (item.IDCampaign != null)
{
log.CampaignID = item.IDCampaign;
}
log.ContactID = contact.ContactID;
log.StatusSend = true;
log.IDEmailOwn = emailOwn.ID;
log.TypeServiceUsed = "STPM";
log.UserID = mGlobal.UserID;
log.Subject = item.Subject;
log.Body = item.ContentEmail;
log.TimeSend = (DateTime)item.TimeSchedule;
lst_logEndEmail.Add(log);
STPMService.SendMail(emailOwn.Email
, Cryption.Decrypt(emailOwn.Password)
, item.Email
, item.Subject
, item.ContentEmail);
}
//db.EmailContents.AddRange(lst_emailContent);
db.LogSendEmails.AddRange(lst_logEndEmail);
db.TempScheduleSendEmails.RemoveRange(list_temp);
db.SaveChanges();
}
}
protected void btnSendListMail_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
//List<EmailContent> lst_emailContent = new List<EmailContent>();
List <LogSendEmail> lst_logEndEmail = new List <LogSendEmail>();
List <TempSendEmail> lst_TempSendEmail = new List <TempSendEmail>();
ListEditItem cmbEmailOwnselectedItem = cmbEmailOwn.SelectedItem;
ListEditItem cmbcmbCampaignselectedItem = cmbCampaign.SelectedItem;
Int64 IdEmailOwn = Int64.Parse(cmbEmailOwnselectedItem.GetValue("ID").ToString());
EmailOwn emailOwn = db.EmailOwns.FirstOrDefault(x => x.ID == IdEmailOwn);
lst_TempSendEmail = db.TempSendEmails.Where(x => x.IDUser == mGlobal.UserID).ToList();
//email.fromEmail = cmbEmailOwn.Text;
//email.passWordSendMail = Cryption.Decrypt(selectedItem.GetValue("Password").ToString());
if (radio_service_google.Checked)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Hiện chưa hỗ trợ service này!" + "');", true);
}
else if (radio_service_stpm.Checked)
{
foreach (TempSendEmail item in lst_TempSendEmail)
{
//get contact
Contact contact = db.Contacts.FirstOrDefault(x => x.Email == item.Email);
//save log send email
LogSendEmail log = new LogSendEmail();
log.CampaignID = Int64.Parse(cmbcmbCampaignselectedItem.GetValue("CampaignID").ToString());
log.ContactID = contact.ContactID;
log.Subject = item.Subject;
log.Body = item.ContentEmail;
//log.EmailID = emailContent.EmailID;
log.StatusSend = true;
log.IDEmailOwn = IdEmailOwn;
log.TypeServiceUsed = mGlobal.STPM;
log.UserID = mGlobal.UserID;
log.TimeSend = DateTime.Now;
lst_logEndEmail.Add(log);
STPMService.SendMail(emailOwn.Email
, Cryption.Decrypt(emailOwn.Password)
, item.Email
, item.Subject
, item.ContentEmail);
}
//db.EmailContents.AddRange(lst_emailContent);
db.LogSendEmails.AddRange(lst_logEndEmail);
db.SaveChanges();
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Gửi thành công!" + "');", true);
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
// Debugger.Log(1, "Send Mail", "Failed: " + v_e);
}
}
