//---------------------------------------------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;
}
}
