예제 #1
0
        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)
            {
            }
        }