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