void sendmail() { try { string strMsg = string.Empty; string strMa_Cbnv, strTen_Cbnv, strEmail, strSubject; DataTable dtBirthDayEmployee; string strHost = EmailConfig.strHost; string strCredentials = EmailConfig.strCredentials; string strPassclient = EmailConfig.strPassclient; string strFrom = EmailConfig.strFrom; string strCC = EmailConfig.strCC; string strContentEmail = EmailConfig.strContentEmail; #region Format mail string strBodyMail = EmailConfig.strEmailBobyBirthDay; #endregion //Xem kết quả Hashtable ht = new Hashtable(); ht["LANGUAGE_TYPE"] = (char)Element.sysLanguage; ht["MA_DVCS"] = Element.sysMa_DvCs; ht["STT"] = 1; dtBirthDayEmployee = SQLExec.ExecuteReturnDt("sp_ViewReminder", ht, CommandType.StoredProcedure); foreach (DataRow drP in dtBirthDayEmployee.Rows) { if ((Boolean)drP["Sent_Mail"]) { continue; } strMa_Cbnv = drP["Ma_Cbnv"].ToString(); strTen_Cbnv = drP["Ten_Cbnv"].ToString(); strEmail = drP["Email"].ToString(); //if (strEmail == string.Empty) // continue; int Numrd = new Random().Next(0, 3); EmailConfig.EMAIL_CONTENT = "EMAIL_CONTENT" + Numrd.ToString(); EmailConfig.SendMailBirthday(strBodyMail, drP); System.Threading.Thread.Sleep(20000); // Lưu lại thông tin gửi mail //EmailConfig.SaveInfoSendMail(strMa_Cbnv, (DateTime)drP["Ngay_Sinh"]); } } catch (Exception ex) { } }