//---------------------------------------------Send Email Function General------------------------------------------// public bool SendEmailGeneral(string name, string BreifD, int Id, TimeSpan Timespan, DateTime enddate, DateTime startdate) { List <string> Data = new List <string>(); using (RemindersEntities db2 = new RemindersEntities()) { var filter1 = db2.Reminders.Where(x => x.ID == Id).Select(x => x.ID).ToList(); var filter2 = db2.RemindersGroups.Where(x => filter1.Contains(x.ReminderID)).Select(x => x.GroupID).Distinct().ToList(); Data = db2.EmployeesGroups.Where(s => filter2.Contains(s.GroupID)).Select(s => s.Employee.Email).ToList(); } foreach (var item in Data) { ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010_SP1); service.UseDefaultCredentials = false; service.Credentials = new WebCredentials(SettingService.UserName(), SettingService.PasswordSender(), SettingService.smtpaddress()); service.Url = new Uri("https://mail.sssprocess.com/EWS/Exchange.asmx"); EmailMessage emailMessage = new EmailMessage(service); emailMessage.Subject = name; DateTime time = DateTime.Today.Add(Timespan); string displayTime = time.ToString("hh:mm tt"); emailMessage.Body = "Title : " + name + "<br>" + "Start date : " + startdate.Date.ToString("MM/dd/yyyy") + "<br>" + "End date : " + enddate.Date.ToString("MM/dd/yyyy") + "<br>" + "Description : " + BreifD + "<br>" + "Time : " + displayTime; emailMessage.ToRecipients.Add(item); emailMessage.SendAndSaveCopy(); } return(true); }
//---------------------------------------------Send Email Function Anniversary--------------------------------------// public bool SendEmailEmployeeStartDate(string name, string email, string ImagePath, int Id) { List <string> Data = new List <string>(); using (RemindersEntities db2 = new RemindersEntities()) { var filter1 = db2.Reminders.Where(x => x.ID == Id).Select(x => x.ID).ToList(); var filter2 = db2.RemindersGroups.Where(x => filter1.Contains(x.ReminderID)).Select(x => x.GroupID).Distinct().ToList(); Data = db2.EmployeesGroups.Where(s => filter2.Contains(s.GroupID)).Select(s => s.Employee.Email).ToList(); } ImagePath = "http://localhost//Appointment.Web//" + ImagePath.Replace("~", "."); string bod = "<html><body><img src='" + ImagePath + "'></body></html>"; foreach (var item in Data) { ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010_SP1); service.UseDefaultCredentials = false; service.Credentials = new WebCredentials(SettingService.UserName(), SettingService.PasswordSender(), SettingService.smtpaddress()); service.Url = new Uri("https://mail.sssprocess.com/EWS/Exchange.asmx"); EmailMessage emailMessage = new EmailMessage(service); emailMessage.Subject = name + " Happy Work Anniversary "; if (ImagePath == null) { emailMessage.Body = SettingService.AnniversaryEmailText(); } else { emailMessage.Body = SettingService.AnniversaryEmailText() + bod; } emailMessage.ToRecipients.Add(item); emailMessage.SendAndSaveCopy(); } return(true); }
//------------------------------Get EmployeesViewModel Data-------------------------------// public List <EmployeesViewModel> GetAll() { List <EmployeesViewModel> EmployeeViews = new List <EmployeesViewModel>(); try { using (RemindersEntities db = new RemindersEntities()) { var employees = db.Employees.ToList(); foreach (var item in employees) { EmployeeViews.Add(new EmployeesViewModel { ID = item.ID, Name = item.Name, Email = item.Email, BirthDate = item.BirthDate.HasValue ? item.BirthDate.Value: DateTime.Now, IsActive = item.IsActive.HasValue ? item.IsActive.Value : false, //CreatedOn = item.CreatedOn, ModifyBy = item.ModifyBy, ModifyOn = item.ModifyOn, CreatedBy = item.CreatedBy }); } } } catch (Exception ex) { } return(EmployeeViews); }
public static List <GroupsViewModel> GetAll() { List <GroupsViewModel> groupViews = new List <GroupsViewModel>(); try { using (RemindersEntities db = new RemindersEntities()) { var groups = db.Groups.ToList(); foreach (var item in groups) { groupViews.Add(new GroupsViewModel { ID = item.ID, Name = item.Name, EmployeesNumber = item.EmployeesGroups != null ? item.EmployeesGroups.Count() : 0 // CreatedOn = item.CreatedOn }); } } } catch (Exception ex) { throw ex; } return(groupViews); }
//------------------------------Get EmployeesGroupsViewModel Data-------------------------------// public List <EmployeesGroupsViewModel> GetAllEmployeeGroup() { List <EmployeesGroupsViewModel> employeesGroupsViews = new List <EmployeesGroupsViewModel>(); try { using (RemindersEntities db = new RemindersEntities()) { var employeesGroups = db.EmployeesGroups.ToList(); foreach (var item in employeesGroups) { employeesGroupsViews.Add(new EmployeesGroupsViewModel { ID = item.ID, EmployeeID = item.EmployeeID, GroupID = item.GroupID, CreatedOn = item.CreatedOn, ModifyBy = item.ModifyBy, ModifyOn = item.ModifyOn, CreatedBY = item.CreatedBY }); } } } catch (Exception ex) { } return(employeesGroupsViews); }
///////////////////////////////////////////////////////// public static void EditGroup(EmployeesGroupsViewModel EmpGroup) { try { RemindersEntities Entities = new RemindersEntities(); Group entity = Entities.Groups.Find(EmpGroup.ID); entity.Name = EmpGroup.Name; //entity.ModifyOn = EmpGroup.ModifyOn; //entity.CreatedOn = EmpGroup.CreatedOn; //entity.ModifyBy = EmpGroup.ModifyBy; //entity.CreatedBy = EmpGroup.CreatedBY; //;; Entities.Groups.Attach(entity); Entities.Entry(entity).State = EntityState.Modified; Entities.SaveChanges(); //;;;;; var list = entity.EmployeesGroups; Entities.EmployeesGroups.RemoveRange(list); Entities.SaveChanges(); foreach (var x in EmpGroup.SelectedEmployeesID) { Entities.EmployeesGroups.Add(new EmployeesGroup { EmployeeID = x, GroupID = entity.ID, CreatedOn = DateTime.Now, CreatedBY = 1, ModifyOn = DateTime.Now, ModifyBy = 1 }); Entities.SaveChanges(); } } catch (Exception ex) { throw ex; } }
//////////////////////////////////////// public static EmployeesGroupsViewModel EmployeeGroupsGetByID(int id) { using (RemindersEntities db = new RemindersEntities()) { Group groups = db.Groups.Where(x => x.ID == id).FirstOrDefault(); EmployeesGroupsViewModel EmployeegroupInfo = new EmployeesGroupsViewModel() { ID = groups.ID, GroupID = groups.ID, Name = groups.Name, SelectedEmployeesID = groups.EmployeesGroups.Select(x => x.EmployeeID).ToArray() }; EmployeegroupInfo.Employeelist = new List <EmployeesViewModel>(); foreach (var emp in groups.EmployeesGroups) { EmployeegroupInfo.Employeelist.Add(new EmployeesViewModel { Name = emp.Employee.Name }); } return(EmployeegroupInfo); } }
/// //////////////////////////////////////////////// public static void Create(EmployeesGroupsViewModel group) { try { RemindersEntities Entities = new RemindersEntities(); var entity = new Group(); //entity.ID = group.ID; entity.Name = group.Name; entity.ModifyOn = group.ModifyOn; entity.CreatedOn = group.CreatedOn; entity.ModifyBy = group.ModifyBy; entity.CreatedBy = group.CreatedBY; Entities.Groups.Add(entity); Entities.SaveChanges(); group.ID = entity.ID; foreach (var x in group.SelectedEmployeesID) { Entities.EmployeesGroups.Add(new EmployeesGroup { EmployeeID = x, GroupID = entity.ID, CreatedOn = DateTime.Now, CreatedBY = 1, ModifyOn = DateTime.Now, ModifyBy = 1 }); Entities.SaveChanges(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// method to edit the reminder of type general /// </summary> /// <param name="reminder">edited data of reminder</param> public static void GeneralReminderUpdate(GeneralRemindersViewModel reminder) { try { RemindersEntities Entities = new RemindersEntities(); Reminder entity = Entities.Reminders.Find(reminder.ID); entity.Name = reminder.Name; entity.IsActive = reminder.IsActive; entity.StartDate = reminder.StartDate.Value; entity.EndDate = reminder.EndDate; entity.BreifDescription = reminder.BreifDescription; entity.Time = reminder.Time; entity.ModifyBy = reminder.ModifyBy; entity.ModifyOn = reminder.ModifyOn; entity.TypeID = LookupService.GetLookupIdByCode((int)Lookups.general); var list = entity.RemindersGroups; Entities.RemindersGroups.RemoveRange(list); Entities.SaveChanges(); foreach (var x in reminder.SelectedGroupsID)//************?????? { Entities.RemindersGroups.Add(new RemindersGroup { GroupID = x, ReminderID = entity.ID, ModifyOn = DateTime.Now, ModifyBy = 1, CreatedOn = DateTime.Now, CreatedBy = 1 }); Entities.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static List <CalendarViewModel> DisplayCurrentReminders() { List <CalendarViewModel> reminderViews = new List <CalendarViewModel>(); try { using (RemindersEntities db = new RemindersEntities()) { var t = DateTime.Now.Date.AddDays(Convert.ToDouble(SettingService.UpComingReminder())); var ti = DateTime.Now.Date.AddDays(0); var reminders = db.Reminders.Where(x => x.IsActive == true).ToList(); foreach (var item in reminders) { //LookupService.GetLookupIdByCode((int)Lookups.employee); //int tId = ((int)Lookups.employee); int emploeeLookupID = db.Lookups.Where(x => x.Code == ((int)Lookups.employee).ToString()).FirstOrDefault().ID; if (item.TypeID == emploeeLookupID) /* "Employee"*/ { if (item.BirthDate.Value.Month <= t.Month && item.BirthDate.Value.Day <= t.Day && item.BirthDate.Value.Month >= ti.Month && item.BirthDate.Value.Day >= ti.Day) { reminderViews.Add(new CalendarViewModel { ID = item.ID, Name = item.Name + " Birthday ", TheDate = item.BirthDate.HasValue ? item.BirthDate.Value.ToString("MM/dd/yyyy") : "" }); } if (item.StartDate.Value.Month <= t.Month && item.StartDate.Value.Day <= t.Day && item.StartDate.Value.Month >= ti.Month && item.StartDate.Value.Day >= ti.Day) { reminderViews.Add(new CalendarViewModel { ID = item.ID, Name = item.Name + " Anniversary ", TheDate = item.StartDate.HasValue ? item.StartDate.Value.ToString("MM/dd/yyyy") : "" }); } } else { if (item.StartDate.Value.Date <= t.Date && item.StartDate.Value.Date >= ti.Date) { reminderViews.Add(new CalendarViewModel { ID = item.ID, Name = item.Name, TheDate = item.StartDate.HasValue ? item.StartDate.Value.ToString("MM/dd/yyyy") : "" }); } } } } } catch (Exception ex) { throw ex; } return(reminderViews); }
public static string GetCodeForTypeID(int id) { using (RemindersEntities db = new RemindersEntities()) { var Lookups = db.Lookups.Where(x => x.ID == id).FirstOrDefault(); return(Lookups.Code); } }
/// <summary> /// method to get the type of Reminder by id /// </summary> /// <param name="id">selected reminder id</param> /// <returns>int type</returns> public static int?GetType(int id) { RemindersEntities db = new RemindersEntities(); Reminder reminders = db.Reminders.Where(x => x.ID == id).FirstOrDefault(); var type = reminders.TypeID; return(type); }
public static string AnniversaryEmailText() { string AnniversaryEmailTextKey = SettingsKeys.AnniversaryEmailTextKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == AnniversaryEmailTextKey).FirstOrDefault(); return(setting.Description); } }
public static string UpComingReminderID() { string UpComingReminderKey = SettingsKeys.UpComingReminderKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == UpComingReminderKey).FirstOrDefault(); return(setting.Values); } }
public static string SendAnniversaryID() { string SendAnniversaryKey = SettingsKeys.SendAnniversaryKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == SendAnniversaryKey).FirstOrDefault(); return(setting.Values); } }
public static string portnumber() { string portnumberKey = SettingsKeys.portnumberKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == portnumberKey).FirstOrDefault(); return(setting.Description); } }
public static string smtpaddress() { string smtpaddressKey = SettingsKeys.smtpaddressKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == smtpaddressKey).FirstOrDefault(); return(setting.Values); } }
public static string PasswordSender() { string PasswordSenderKey = SettingsKeys.PasswordSenderKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == PasswordSenderKey).FirstOrDefault(); return(setting.Values); } }
public static string EmailAdmin() { string EmailAdminKey = SettingsKeys.EmailAdminKey(); using (RemindersEntities db = new RemindersEntities()) { var setting = db.Settings.Where(x => x.Key == EmailAdminKey).FirstOrDefault(); return(setting.Description); } }
public static string UpComingReminderEN() { string UpComingReminderKey = SettingsKeys.UpComingReminderKey(); using (RemindersEntities db = new RemindersEntities()) { var Settings = db.Settings.Where(x => x.Key == UpComingReminderKey).FirstOrDefault(); var value = Convert.ToInt32(Settings.Values); var Lookups = db.Lookups.Where(x => x.ID == value).FirstOrDefault(); return(Lookups.NameEn); } }
public static List <SelectListItem> GetTypeID() { using (RemindersEntities db = new RemindersEntities()) { var ReminderType = db.LookUpCategories.Where(x => x.Code == ((int)LookupCategories.ReminderType).ToString()).FirstOrDefault().ID; var list = db.Lookups.Where(m => m.CategoryID == ReminderType).Select(m => new SelectListItem { Value = m.ID.ToString(), Text = m.Description, }).ToList(); return(list); } }
public static List <SelectListItem> GetUpcoming() { using (RemindersEntities db = new RemindersEntities()) { var DurationToUpcomingLookupCategoriesID = db.LookUpCategories.Where(x => x.Code == ((int)LookupCategories.DurationToUpComing).ToString()).FirstOrDefault().ID; var list = db.Lookups.Where(m => m.CategoryID == DurationToUpcomingLookupCategoriesID).Select(m => new SelectListItem { Value = m.ID.ToString(), Text = m.NameEn, }).ToList(); return(list); } }
/// /////////////////////////////////////////////////////////// /// public static List <SelectListItem> GetAllEmployee() { using (RemindersEntities db = new RemindersEntities()) { List <SelectListItem> list = new List <SelectListItem>(); list = db.Employees.Select(m => new SelectListItem { Value = m.ID.ToString(), Text = m.Name, }).ToList(); return(list); } }
/// <summary> /// gets TypeId from DB by code /// </summary> /// <returns>list of TypeId</returns> public static int GetLookupIdByCode(int code) { try { using (RemindersEntities db = new RemindersEntities()) { var Id = db.Lookups.Where(x => x.Code == code.ToString()).FirstOrDefault().ID; return(Id); } } catch (Exception ex) { throw ex; } }
/// <summary> /// gets Email from DB then set it in dropdownlist /// </summary> /// <returns>list of Email</returns> //public static int GetEmailId(int Id) //{ // try // { // using (RemindersEntities db = new RemindersEntities()) // { // var emailId = db.Employees.Find(Id).ID; // return emailId; // } // } // catch (Exception ex) // { // throw ex; // } //} /// <summary> /// gets Email from DB then set it in dropdownlist /// </summary> /// <returns>list of Email</returns> public static bool CheckUsedEmployee(int Id, int?ReminderID) { try { using (RemindersEntities db = new RemindersEntities()) { var used = db.Reminders.Any(x => x.EmployeeID == Id && (ReminderID.HasValue ? (x.ID != ReminderID) : true)); return(used); } } catch (Exception ex) { throw ex; } }
/// <summary> /// gets Email from DB then set it in dropdownlist /// </summary> /// <returns>list of Email</returns> public static string GetEmail(int Id) { try { using (RemindersEntities db = new RemindersEntities()) { var emailId = db.Employees.Find(Id).ID; var email = db.Employees.Find(Id).Email; return(email); } } catch (Exception ex) { throw ex; } }
/// <summary> /// method that reads all reminder from DB /// </summary> /// <returns>list of remindersViewModel</returns> public static List <RemindersViewModel> GetAll() { List <RemindersViewModel> reminderViews = new List <RemindersViewModel>(); try { using (RemindersEntities db = new RemindersEntities()) { var reminders = db.Reminders.ToList(); var remTypes = db.Lookups.Where(z => z.IsDeleted == false && z.CategoryID == 1).ToList(); foreach (var item in reminders) { var remType = remTypes.Where(x => x.ID == item.TypeID).FirstOrDefault(); string TypeName = remType == null?item.TypeID.ToString() : remType.NameEn; reminderViews.Add(new RemindersViewModel { ID = item.ID, Name = item.Name, Email = item.Email, BirthDate = item.BirthDate, PositionID = item.PositionID, IsActive = item.IsActive, Image = item.Image, StartDate = item.StartDate, EndDate = item.EndDate, BreifDescription = item.BreifDescription, Time = item.Time, EmployeeID = item.EmployeeID, TypeName = TypeName, CreatedOn = item.CreatedOn, ModifyBy = item.ModifyBy, ModifyOn = item.ModifyOn, CreatedBy = item.CreatedBy, TypeID = item.TypeID }); } } } catch (Exception ex) { throw ex; } return(reminderViews); }
/// <summary> /// gets the general details of selected reminder by id /// </summary> /// <param name="id">selected reminder</param> /// <returns>selected item object</returns> public static GeneralRemindersViewModel generalRemindersGetByID(int id) { using (RemindersEntities db = new RemindersEntities()) { Reminder reminders = db.Reminders.Find(id); //var groups = db.Groups.ToList(); //var remGroups = db.RemindersGroups.Where(z => z.ReminderID == reminders.ID).FirstOrDefault(); GeneralRemindersViewModel GeneralReminder = new GeneralRemindersViewModel() { ID = reminders.ID, Name = reminders.Name, StartDate = reminders.StartDate, EndDate = reminders.EndDate, BreifDescription = reminders.BreifDescription, Time = reminders.Time, CreatedOn = reminders.CreatedOn, ModifyOn = reminders.ModifyOn, TypeID = reminders.TypeID, IsActive = reminders.IsActive.Value, /*Group = groupName */// reminders..HasValue ? reminders.Position.Name : "" }; List <int> selected = new List <int>(); foreach (var ReminderGroup in reminders.RemindersGroups) { selected.Add(ReminderGroup.GroupID); } GeneralReminder.SelectedGroupsID = selected.ToArray(); var reminderGroups = reminders.RemindersGroups; GeneralReminder.SelectedGroups = new List <string>(); if (reminderGroups != null) { foreach (var RMG in reminderGroups) { GeneralReminder.SelectedGroups.Add(RMG.Group == null ? "" : RMG.Group.Name); } } return(GeneralReminder); } }
/// <summary> /// creates a new reminder of type employee /// </summary> /// <param name="reminder">new reminders data</param> public static void Create(EmployeeRemindersViewModel reminder) { try { RemindersEntities Entities = new RemindersEntities(); //.Where(x => x.Email == reminder.Email) var items = Entities.Reminders.ToList(); //if (items.Count < 1) //{ Reminder entity = new Reminder(); entity.ID = reminder.ID; entity.Name = reminder.Name; entity.Email = reminder.Email; entity.BirthDate = reminder.BirthDate; entity.PositionID = reminder.PositionID; entity.IsActive = reminder.IsActive; entity.Image = null; entity.StartDate = reminder.StartDate.Value; entity.EmployeeID = reminder.EmployeeID; entity.CreatedBy = reminder.CreatedBy; entity.CreatedOn = DateTime.Now; entity.TypeID = LookupService.GetLookupIdByCode((int)Lookups.employee); Entities.Reminders.Add(entity); Entities.SaveChanges(); reminder.ID = entity.ID; foreach (var x in reminder.SelectedGroupsID) { Entities.RemindersGroups.Add(new RemindersGroup { GroupID = x, ReminderID = entity.ID, CreatedOn = DateTime.Now, CreatedBy = 1, ModifyOn = DateTime.Now, ModifyBy = 1 }); Entities.SaveChanges(); } //} //else //{ //} } catch (Exception ex) { throw ex; } }
///////////////////////////////////////////////////// public static void Delete(EmployeesGroupsViewModel group) { try { //DeleteEmployeesGroups(group); RemindersEntities Entities = new RemindersEntities(); Group entity = Entities.Groups.Find(group.ID); var list = entity.EmployeesGroups; Entities.EmployeesGroups.RemoveRange(list); Entities.SaveChanges(); Entities.Groups.Remove(entity); Entities.SaveChanges(); } catch (Exception ex) { throw ex; } }