protected void btnChangePass_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
User user = db.Users.FirstOrDefault(x => x.AccountName == Context.User.Identity.Name);
if (Cryption.Decrypt(user.Password) == txt_pass_old.Value)
{
if (txt_pass_new.Value == txt_pass_new_repeat.Value)
{
user.Password = Cryption.Encrypt(txt_pass_new.Value);
db.SaveChanges();
lbl_failure.Text = "";
string message = "Bạn đã thay đổi mật khẩu thành công";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + message + "');", true);
}
else
{
lbl_failure.Text = "Mật khẩu nhập lại không đúng!";
}
}
else
{
lbl_failure.Text = "Mật khẩu cũ của bạn không đúng!";
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
}
}
protected void btnCreateCampaign_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
Campaign campaing = new Campaign();
}
catch (Exception)
{
throw;
}
}
public static bool checkContactIsExist(string email)
{
using (SendMailEntities db = new SendMailEntities())
{
Contact contact = db.Contacts.FirstOrDefault(x => x.Email == email);
if (contact == null)
{
return(false);
}
else
{
return(true);
}
}
}
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();
}
}
private void saveTempScheduleSendEmail()
{
ListEditItem cmbEmailOwnselectedItem = cmbEmailOwn.SelectedItem;
ListEditItem cmbcmbCampaignselectedItem = cmbCampaign.SelectedItem;
CampaignName = cmbcmbCampaignselectedItem.GetValue("CampaignName").ToString();
mdtSchedule = DateTime.Parse(Request.Form[txt_date_schedule.UniqueID]);
string jobName = "Job" + mGlobal.AccountName + CampaignName + mdtSchedule;
string groupJobName = "GroupJob" + mGlobal.AccountName;
string triggerName = "Trigger" + jobName;
string triggerGroup = "TriggerGroup" + groupJobName;
for (int i = 0; i < gridView.VisibleRowCount; i++)
{
if (gridView.GetRowLevel(i) == gridView.GroupCount)
{
object keyValue = gridView.GetRowValues(i, new string[] { DataField.STT, DataField.Email, DataField.Subject, DataField.Content });
if (keyValue != null)
{
using (SendMailEntities db = new SendMailEntities())
{
Array arr = (Array)keyValue;
TempScheduleSendEmail temp = new TempScheduleSendEmail();
temp.STT = Int64.Parse(arr.GetValue(0).ToString());
temp.Email = arr.GetValue(1).ToString();
temp.Subject = arr.GetValue(2).ToString();
temp.ContentEmail = arr.GetValue(3).ToString();
temp.IDEmailOwn = Int64.Parse(cmbEmailOwnselectedItem.GetValue("ID").ToString());
temp.IDCampaign = Int64.Parse(cmbcmbCampaignselectedItem.GetValue("CampaignID").ToString());
temp.TimeSchedule = mdtSchedule;
temp.IDUser = mGlobal.UserID;
temp.JobName = jobName;
temp.JobGroup = groupJobName;
db.TempScheduleSendEmails.Add(temp);
db.SaveChanges();
}
}
}
}
//call service schedule email
SendMailService proxy = new SendMailService();
proxy.SendEmailSchedule(jobName, groupJobName, triggerName, triggerGroup, mdtSchedule);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
Campaign campaign = new Campaign();
campaign.CampaignName = txt_campaign_name.Value.ToString();
campaign.Description = txt_desciption.Value.ToString();
campaign.isActive = true;
db.Campaigns.Add(campaign);
db.SaveChanges();
gridCampaign.DataBind();
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
}
}
protected void gridView_RowInserted(object sender, DevExpress.Web.Data.ASPxDataInsertedEventArgs e)
{
try
{
using (SendMailEntities db = new SendMailEntities())
{
if (ContactBusiness.checkContactIsExist(e.NewValues["Email"].ToString().Trim()))
{
Contact contact = new Contact();
contact.Email = e.NewValues["Email"].ToString().Trim();
db.Contacts.Add(contact);
db.SaveChanges();
}
}
}
catch (Exception)
{
throw;
}
}
protected void btnImportList_Click(object sender, EventArgs e)
{
try
{
List <Contact> lst_contact = new List <Contact>();
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
string FileName = txtNameFileUpload.Text;
string Extension = Path.GetExtension(FileName);
string FilePath = Server.MapPath(FolderPath + FileName);
DataTable dt = ImportExcel.ImportExcel2DataTable(FilePath, Extension);
checkBoxListEmail.DataSource = dt;
checkBoxListEmail.DataMember = "Email";
checkBoxListEmail.TextField = "Email";
checkBoxListEmail.DataBind();
checkBoxListEmail.SelectAll();
//check save contact new
SelectedValueCollection listEmail = checkBoxListEmail.SelectedValues;
foreach (String email in listEmail)
{
if (!ContactBusiness.checkContactIsExist(email) && email != "")
{
Contact contact = new Contact();
contact.Email = email;
lst_contact.Add(contact);
}
}
using (SendMailEntities db = new SendMailEntities())
{
db.Contacts.AddRange(lst_contact);
db.SaveChanges();
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
}
}
protected void btnSendMail_Click(object sender, EventArgs e)
{
try
{
using (SendMailEntities db = new SendMailEntities())
{
ListEditItem cmbEmailOwnselectedItem = cmbEmailOwn.SelectedItem;
ListEditItem cmbcmbContactselectedItem = cmbContact.SelectedItem;
ListEditItem cmbcmbCampaignselectedItem = cmbCampaign.SelectedItem;
string toEmail = cmbcmbContactselectedItem.GetValue("Email").ToString();
string fromEmail = cmbEmailOwnselectedItem.GetValue("Email").ToString();
string password = Cryption.Decrypt(cmbEmailOwnselectedItem.GetValue("Password").ToString());
Int64 IdEmailOwn = Int64.Parse(cmbEmailOwnselectedItem.GetValue("ID").ToString());
//EmailOwn emailOwn = db.EmailOwns.FirstOrDefault(x => x.ID == IdEmailOwn);
LogSendEmail email = new LogSendEmail();
email.Subject = ip_txt_subject.Value;
email.Body = txt_content_mail.Value;
email.ContactID = Int64.Parse(cmbcmbContactselectedItem.GetValue("ContactID").ToString());
email.UserID = mGlobal.UserID;
email.IDEmailOwn = IdEmailOwn;
email.CampaignID = Int64.Parse(cmbcmbCampaignselectedItem.GetValue("CampaignID").ToString());
if (radio_service_google.Checked)
{
email.TypeServiceUsed = mGlobal.GOOGLE;
try
{
GoogleMailService.sendMail("*****@*****.**", createEmail.createMessage(email.Subject
, email.Body
, fromEmail
, toEmail));
email.StatusSend = true;
}
catch (Exception)
{
email.StatusSend = false;
}
}
else if (radio_service_stpm.Checked)
{
email.TypeServiceUsed = mGlobal.STPM;
try
{
STPMService.SendMail(fromEmail
, password
, toEmail
, email.Subject
, email.Body);
email.StatusSend = true;
}
catch (Exception)
{
email.StatusSend = false;
}
}
email.TimeSend = DateTime.Now;
db.LogSendEmails.Add(email);
db.SaveChanges();
string message = "Gửi email thành công";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + message + "');", true);
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
}
}
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);
}
}
protected void btnImportList_Click(object sender, EventArgs e)
{
try
{
//ListEditItem cmbEmailOwnselectedItem = cmbEmailOwn.SelectedItem;
//ListEditItem cmbcmbCampaignselectedItem = cmbCampaign.SelectedItem;
SendMailEntities db = new SendMailEntities();
List <TempSendEmail> listTemp = new List <TempSendEmail>();
List <Contact> lst_contact = new List <Contact>();
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
string FileName = txtNameFileUpload.Text;
string Extension = Path.GetExtension(FileName);
string FilePath = Server.MapPath(FolderPath + FileName);
if (FileName != "")
{
//delete data in table temporary
db.Database.ExecuteSqlCommand("Delete from TempSendEmails where IDUser = "******"STT"].ToString());
temp.Subject = dr["Subject"].ToString();
temp.ContentEmail = dr["Content"].ToString();
temp.Email = dr["Email"].ToString();
temp.IDUser = mGlobal.UserID;
temp.TimeSend = DateTime.Now;
//temp.IDEmailOwn = Int64.Parse(cmbEmailOwnselectedItem.GetValue("ID").ToString());
//if (cmbCampaign.SelectedIndex > 0)
//{
// temp.IDCampaign = Int64.Parse(cmbcmbCampaignselectedItem.GetValue("CampaignID").ToString());
// }
listTemp.Add(temp);
//check contact, if is not exist then save to db
if (!ContactBusiness.checkContactIsExist(temp.Email))
{
Contact contact = new Contact();
contact.Email = temp.Email;
lst_contact.Add(contact);
}
}
db.TempSendEmails.AddRange(listTemp);
if (lst_contact.Count > 0)
{
db.Contacts.AddRange(lst_contact);
}
db.SaveChanges();
gridView.DataBind();
}
else
{
String message = "Bạn chưa chọn file hoặc file này đang được mở!";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + message + "');", true);
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + v_e + "');", true);
//Debugger.Log(1, "Send Mail", "Failed: " + v_e);
}
}
protected void btnImportList_Click(object sender, EventArgs e)
{
try
{
SendMailEntities db = new SendMailEntities();
List <Contact> listContact = new List <Contact>();
string FolderPath = ConfigurationManager.AppSettings["FolderPath"];
string FileName = txtNameFileUpload.Text;
string Extension = Path.GetExtension(FileName);
string FilePath = Server.MapPath(FolderPath + FileName);
if (FileName != "")
{
DataTable dt = ImportExcel.ImportExcel2DataTable(FilePath, Extension);
foreach (DataRow dr in dt.Rows)
{
Contact contact;
if (!ContactBusiness.checkContactIsExist(dr["Email"].ToString().Trim()))
{
contact = new Contact();
contact.Email = dr["Email"].ToString().Trim();
contact.FirstName = dr["FirstName"].ToString();
contact.LastName = dr["LastName"].ToString();
contact.FullName = dr["FullName"].ToString();
contact.Phone = dr["Phone"].ToString();
contact.Adress = dr["Address"].ToString();
if (dr["Gender"].ToString().Trim().ToUpper().Equals("NỮ"))
{
contact.Gender = 0;
}
else
{
contact.Gender = 1;
}
contact.Birthday = DateTime.Parse(dr["Birthday"].ToString());
listContact.Add(contact);
}
else
{
contact = db.Contacts.FirstOrDefault(x => x.Email == dr["Email"].ToString().Trim());
contact.Email = dr["Email"].ToString().Trim();
contact.FirstName = dr["FirstName"].ToString();
contact.LastName = dr["LastName"].ToString();
contact.FullName = dr["FullName"].ToString();
contact.Phone = dr["Phone"].ToString();
contact.Adress = dr["Address"].ToString();
if (dr["Gender"].ToString().Trim().ToUpper().Equals("NỮ"))
{
contact.Gender = 0;
}
else
{
contact.Gender = 1;
}
contact.Birthday = DateTime.Parse(dr["Birthday"].ToString());
}
}
if (listContact.Count > 0)
{
db.Contacts.AddRange(listContact);
}
db.SaveChanges();
gridView.DataBind();
}
else
{
String message = "Bạn chưa chọn file hoặc file này đang được mở!";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + message + "');", true);
}
}
catch (Exception v_e)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + HandleException.SqlExcforContact(v_e) + "');", true);
Debugger.Log(1, "Send Mail", "Failed: " + v_e);
}
}
