public void SendMail(vm_Grid viewModel) { LeaveManagementSystemContext dbLMS = new LeaveManagementSystemContext(); ActiveDirectoryWarehouseContext dbAD = new ActiveDirectoryWarehouseContext(); var loggedInUser = User.Identity.Name.Split(separator: new char[] { '\\' })[1]; var staffProfile = dbAD.UserProfiles .Where(w => w.PKUserName.Equals(loggedInUser)) .Select(s => new vm_UserProfile() { PK_UserName = s.PKUserName, UserFirstName = s.UserFirstName, UserSurname = s.UserSurname, UserEmail = s.UserEmail, UserTelephone = s.UserTelephone, UserMobileNumber = s.UserMobileNumber, UserJobTitle = s.UserJobTitle, Office = s.Office, Department = s.Department, Manager = s.Manager, Company = s.Company }).FirstOrDefault(); UserProfile managerProfile = dbAD.UserProfiles .Where(w => w.UserFullName.Equals(staffProfile.Manager)) .FirstOrDefault(); var request = dbLMS.UserManagements.Where(w => w.PK_ID.Equals(viewModel.PK_ID)).FirstOrDefault(); dbAD.Dispose(); dbLMS.Dispose(); var approvedBool = request.IsApproved; var approvedConvert = boolConversion(approvedBool); var entitlementBool = request.IsEntitlementOvertaken; var entitlementConvert = boolConversion(entitlementBool); vm_Email emailTemplate = new vm_Email(); emailTemplate.PK_ID = request.PK_ID; emailTemplate.Username = staffProfile.UserFullName; emailTemplate.UserEmail = staffProfile.UserEmail; emailTemplate.Manager = staffProfile.Manager; emailTemplate.ManagerEmail = managerProfile.UserEmail; emailTemplate.StartDate = request.StartDate; emailTemplate.EndDate = request.EndDate; emailTemplate.Reason = request.Reason; emailTemplate.Entitlement = request.Entitlement; emailTemplate.BreakDuration = request.BreakDuration; emailTemplate.RemainingDays = request.RemainingDays; emailTemplate.IsApproved = request.IsApproved; emailTemplate.Approved = approvedConvert; emailTemplate.IsEntitlementOvertaken = request.IsEntitlementOvertaken; emailTemplate.EntitlementOvertaken = entitlementConvert; var from = staffProfile.UserEmail; var to = managerProfile.UserEmail; var templatePath = System.IO.File.ReadAllText(Server.MapPath("~/Views/sendMail/sendMail.cshtml")); var template = Engine.Razor.RunCompile(templatePath, "key", typeof(vm_Email), emailTemplate); var templatePathConfirmation = System.IO.File.ReadAllText(Server.MapPath("~/Views/sendMail/sendMailConfirmation.cshtml")); var templateConfirmation = Engine.Razor.RunCompile(templatePathConfirmation, "confirmationkey", typeof(vm_Email), emailTemplate); //email to manager EmailHandler mail = new EmailHandler(); mail.SendEmailNotification(from, to, "Leave Request", template); //email to the user for confirmation EmailHandler confirmationEmail = new EmailHandler(); confirmationEmail.SendEmailNotification(from, from, "Leave request confirmation", templateConfirmation); }
public ActionResult LMS_Create([DataSourceRequest] DataSourceRequest request, vm_Grid viewModel) { var db = new LeaveManagementSystemContext(); ActiveDirectoryWarehouseContext dbAD = new ActiveDirectoryWarehouseContext(); var staffLoginID = User.Identity.Name.Split('\\')[1]; var staffProfile = dbAD.UserProfiles .Where(w => w.PKUserName.Equals(staffLoginID)) .FirstOrDefault(); dbAD.Dispose(); if (viewModel != null && ModelState.IsValid) { var model = new UserManagement(); model.PK_ID = viewModel.PK_ID; model.AuthName = staffProfile.PKUserName; model.StartDate = viewModel.StartDate; model.EndDate = viewModel.EndDate; model.Reason = viewModel.Reason; model.IsApproved = viewModel.IsApproved; model.Entitlement = viewModel.Entitlement; model.BreakDuration = viewModel.BreakDuration; model.RemainingDays = viewModel.RemainingDays; model.IsEntitlementOvertaken = viewModel.IsEntitlementOvertaken; db.Add(model); db.SaveChanges(); viewModel.PK_ID = model.PK_ID; SendMail(viewModel); db.Dispose(); } return(Json(new[] { viewModel }.ToDataSourceResult(request, ModelState))); }
public ActionResult LMS_Delete([DataSourceRequest] DataSourceRequest request, vm_Grid viewModel) { if (viewModel != null && ModelState.IsValid) { using (var db = new LeaveManagementSystemContext()) { UserManagement model = db.UserManagements.Where(w => w.PK_ID.Equals(viewModel.PK_ID)).FirstOrDefault(); db.Delete(model); db.SaveChanges(); } } return(Json(new[] { viewModel }.ToDataSourceResult(request, ModelState))); }