//----------------------------------------------------Job Execute----------------------------------------------------// public void Execute(IJobExecutionContext context) { try { RemindersEntities db = new RemindersEntities(); int emploeeLookupID = db.Lookups.Where(x => x.Code == ((int)Lookups.employee).ToString()).FirstOrDefault().ID; int generalLookupID = db.Lookups.Where(x => x.Code == ((int)Lookups.general).ToString()).FirstOrDefault().ID; List <RemindersViewModel> BirthDate = new List <RemindersViewModel>(); BirthDate = db.Reminders.Where(x => x.TypeID == emploeeLookupID).Select(x => new RemindersViewModel { Name = x.Employee.Name, BirthDate = x.BirthDate, Email = x.Employee.Email, Image = x.Image }).ToList(); // //Anniversary List <RemindersViewModel> EmployeeStartDate = new List <RemindersViewModel>(); EmployeeStartDate = db.Reminders.Where(x => x.TypeID == emploeeLookupID).Select(x => new RemindersViewModel { Name = x.Employee.Name, StartDate = x.StartDate, Email = x.Employee.Email, ImagePath = x.ImagePath, ID = x.ID }).ToList(); //general List <RemindersViewModel> startDate = new List <RemindersViewModel>(); startDate = db.Reminders.Where(x => x.TypeID == generalLookupID).Select(x => new RemindersViewModel { StartDate = x.StartDate, Name = x.Name, BreifDescription = x.BreifDescription, ID = x.ID, Time = x.Time, EndDate = x.EndDate }).ToList(); //For Send Email foreach (var item in BirthDate) { var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.SendBirthday())); if (item.BirthDate.HasValue == true) { if (t.Day == item.BirthDate.Value.Day && t.Month == item.BirthDate.Value.Month) { bool res = SendEmailBirthday(item.Name, item.Email);// } } } foreach (var item in EmployeeStartDate) { RemindersEntities dbESD = new RemindersEntities(); var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.SendAnniversary())); if (item.StartDate.HasValue == true) { if (t.Day == item.StartDate.Value.Day && t.Month == item.StartDate.Value.Month) { bool res = SendEmailEmployeeStartDate(item.Name, item.Email, item.ImagePath, item.ID); } } } foreach (var item in startDate) { RemindersEntities dbSD = new RemindersEntities(); var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.SendEvent())); if (item.StartDate.HasValue == true) { if (t.Day == item.StartDate.Value.Day && t.Month == item.StartDate.Value.Month) { bool res = SendEmailGeneral(item.Name, item.BreifDescription, item.ID, item.Time.Value, item.EndDate.Value, item.StartDate.Value); } } } //For Send Reminder foreach (var item in BirthDate) { var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.BirthdayReminder())); if (item.BirthDate.HasValue == true) { if (t.Day == item.BirthDate.Value.Day && t.Month == item.BirthDate.Value.Month) { bool res = RemindEmailBirthday(item.Name, item.BirthDate.Value); } } } foreach (var item in EmployeeStartDate) { RemindersEntities dbESD = new RemindersEntities(); var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.SendAnniversary())); if (item.StartDate.HasValue == true) { if (t.Day == item.StartDate.Value.Day && t.Month == item.StartDate.Value.Month) { bool res = RemindEmailEmployeeStartDate(item.Name, item.StartDate.Value); } } } foreach (var item in startDate) { RemindersEntities dbSD = new RemindersEntities(); var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.EventReminder())); if (item.StartDate.HasValue == true) { if (t.Day == item.StartDate.Value.Day && t.Month == item.StartDate.Value.Month) { bool res = RemindEmailGeneral(item.Name, item.BreifDescription, item.StartDate.Value, item.Time.Value); } } } } catch (Exception ex) { throw ex; } }