public ActionResult LMS_Update([DataSourceRequest] DataSourceRequest request, vm_Grid viewModel) { using (var db = new LeaveManagementSystemContext()) { if (viewModel != null && ModelState.IsValid) { ActiveDirectoryWarehouseContext dbAD = new ActiveDirectoryWarehouseContext(); var staffLoginID = User.Identity.Name.Split('\\')[1]; var staffProfile = dbAD.UserProfiles .Where(w => w.PKUserName.Equals(staffLoginID)) .FirstOrDefault(); UserManagement model = db.UserManagements.Where(w => w.PK_ID.Equals(viewModel.PK_ID)).FirstOrDefault(); 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.FlushChanges(); db.SaveChanges(); dbAD.Dispose(); viewModel.PK_ID = model.PK_ID; SendMail(viewModel); } 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))); }