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