public ActionResult Edit([Bind(Include = "UserID,UserName,Password,EmpID,DateCreated,Name,Status,Department,CanEdit,CanDelete,CanAdd,CanView,CompanyID,RoleID,MHR,MDevice,MLeave,MDesktop,MEditAtt,MUser,MOption,MRDailyAtt,MRLeave,MRMonthly,MRAudit,MRManualEditAtt,MREmployee,MRDetail,MRSummary,MRGraph,ViewPermanentStaff,ViewPermanentMgm,ViewContractual,ViewLocation,LocationID")] User user)
{
bool check = false;
user.RoleID = Convert.ToByte(Request.Form["RoleID"].ToString());
if (Request.Form["Status"].ToString() == "true")
user.Status = true;
else
user.Status = false;
if (Request.Form["CanEdit"].ToString() == "true")
user.CanEdit = true;
else
user.CanEdit = false;
if (Request.Form["CanDelete"].ToString() == "true")
user.CanDelete = true;
else
user.CanDelete = false;
if (Request.Form["CanAdd"].ToString() == "true")
user.CanAdd = true;
else
user.CanAdd = false;
if (Request.Form["CanView"].ToString() == "true")
user.CanView = true;
else
user.CanView = false;
if (Request.Form["MUser"].ToString() == "true")
user.MUser = true;
else
user.MUser = false;
if (Request.Form["MRoster"].ToString() == "true")
user.MRoster = true;
else
user.MRoster = false;
if (Request.Form["MHR"].ToString() == "true")
user.MHR = true;
else
user.MHR = false;
//if (Request.Form["MOption"].ToString() == "true")
// user.MOption = true;
//else
// user.MOption = false;
if (Request.Form["MDevice"].ToString() == "true")
user.MDevice = true;
else
user.MDevice = false;
if (Request.Form["MDesktop"].ToString() == "true")
user.MDesktop = true;
else
user.MDesktop = false;
if (Request.Form["MEditAtt"].ToString() == "true")
user.MEditAtt = true;
else
user.MEditAtt = false;
if (Request.Form["MLeave"].ToString() == "true")
user.MLeave = true;
else
user.MLeave = false;
if (Request.Form["MRLeave"].ToString() == "true")
user.MRLeave = true;
else
user.MRLeave = false;
if (Request.Form["MRDailyAtt"].ToString() == "true")
user.MRDailyAtt = true;
else
user.MRDailyAtt = false;
if (Request.Form["MRMonthly"].ToString() == "true")
user.MRMonthly = true;
else
user.MRMonthly = false;
if (Request.Form["MRAudit"].ToString() == "true")
user.MRAudit = true;
else
user.MRAudit = false;
if (Request.Form["MRManualEditAtt"].ToString() == "true")
user.MRManualEditAtt = true;
else
user.MRManualEditAtt = false;
if (Request.Form["MREmployee"].ToString() == "true")
user.MREmployee = true;
else
user.MREmployee = false;
if (Request.Form["MRDetail"].ToString() == "true")
user.MRDetail = true;
else
user.MRDetail = false;
if (Request.Form["MRSummary"].ToString() == "true")
user.MRSummary = true;
else
user.MRSummary = false;
if (Request.Form["MRGraph"].ToString() == "true")
user.MRGraph = true;
else
user.MRGraph = false;
if (check == false)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
int count = Convert.ToInt32(Request.Form["uLocationCount"]);
List<Location> locs = new List<Location>();
List<UserLocation> userLocs = db.UserLocations.Where(aa=>aa.UserID==user.UserID).ToList();
locs = db.Locations.ToList();
List<int> currentLocIDs = new List<int>();
foreach (var uloc in userLocs)
{
UserLocation ul = db.UserLocations.First(aa=>aa.UserLocID==uloc.UserLocID);
db.UserLocations.Remove(ul);
db.SaveChanges();
}
userLocs = new List<UserLocation>();
for (int i = 1; i <= count; i++)
{
string uLocID = "uLocation" + i;
string LocName = Request.Form[uLocID].ToString();
int locID = locs.Where(aa => aa.LocName == LocName).FirstOrDefault().LocID;
currentLocIDs.Add(locID);
if(userLocs.Where(aa=>aa.LocationID==locID).Count()>0)
{
}
else
{
UserLocation uloc = new UserLocation();
uloc.UserID = user.UserID;
uloc.LocationID = (short)locID;
db.UserLocations.Add(uloc);
userLocs.Add(uloc);
db.SaveChanges();
}
}
//foreach (var item in userLocs)
//{
// if (!currentLocIDs.Contains((int)item.LocationID))
// {
// }
//}
return RedirectToAction("Index");
}
ViewBag.CompanyID = new SelectList(db.Companies, "CompID", "CompName", user.CompanyID);
ViewBag.EmpID = new SelectList(db.Emps, "EmpID", "EmpNo", user.EmpID);
ViewBag.RoleID = new SelectList(db.UserRoles, "RoleID", "RoleName", user.RoleID);
ViewBag.LocationID = new SelectList(db.Locations, "LocID", "LocName", user.LocationID);
return View(user);
}
public ActionResult Create([Bind(Include = "UserID,UserName,Password,EmpID,DateCreated,Name,Status,Department,CanEdit,CanDelete,CanAdd,CanView,CompanyID,RoleID,MHR,MDevice,MLeave,MDesktop,MEditAtt,MUser,MOption,MRoster,MRDailyAtt,MRLeave,MRMonthly,MRAudit,MRManualEditAtt,MREmployee,MRDetail,MRSummary,MRGraph,ViewPermanentStaff,ViewPermanentMgm,ViewContractual,ViewLocation,LocationID")] User user)
{
int count = Convert.ToInt32(Request.Form["uLocationCount"]);
if (count > 0)
{
bool check = false;
string _EmpNo = Request.Form["EmpNo"].ToString();
List<Emp> _emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo).ToList();
if (_emp.Count == 0)
{
check = true;
}
if (user.UserName == null)
check = true;
if (Request.Form["Status"] == "1")
user.Status = true;
else
user.Status = false;
if (Request.Form["CanEdit"] == "1")
user.CanEdit = true;
else
user.CanEdit = false;
if (Request.Form["CanDelete"] == "1")
user.CanDelete = true;
else
user.CanDelete = false;
if (Request.Form["CanAdd"] == "1")
user.CanAdd = true;
else
user.CanAdd = false;
if (Request.Form["CanView"] == "1")
user.CanView = true;
else
user.CanView = false;
if (Request.Form["MUser"] == "1")
user.MUser = true;
else
user.MUser = false;
if (Request.Form["MHR"] == "1")
user.MHR = true;
else
user.MHR = false;
if (Request.Form["MOption"] == "1")
user.MOption = true;
else
user.MOption = false;
if (Request.Form["MDevice"] == "1")
user.MDevice = true;
else
user.MDevice = false;
if (Request.Form["MDesktop"] == "1")
user.MDesktop = true;
else
user.MDesktop = false;
if (Request.Form["MEditAtt"] == "1")
user.MEditAtt = true;
else
user.MEditAtt = false;
if (Request.Form["MLeave"] == "1")
user.MLeave = true;
else
user.MLeave = false;
if (Request.Form["MRoster"] == "1")
user.MRoster = true;
else
user.MRoster = false;
if (Request.Form["MRLeave"] == "1")
user.MRLeave = true;
else
user.MRLeave = false;
if (Request.Form["MRDailyAtt"] == "1")
user.MRDailyAtt = true;
else
user.MRDailyAtt = false;
if (Request.Form["MRMonthly"] == "1")
user.MRMonthly = true;
else
user.MRMonthly = false;
if (Request.Form["MRAudit"] == "1")
user.MRAudit = true;
else
user.MRAudit = false;
if (Request.Form["MRManualEditAtt"] == "1")
user.MRManualEditAtt = true;
else
user.MRManualEditAtt = false;
if (Request.Form["MREmployee"] == "1")
user.MREmployee = true;
else
user.MREmployee = false;
if (Request.Form["MRDetail"] == "1")
user.MRDetail = true;
else
user.MRDetail = false;
if (Request.Form["MRSummary"] == "1")
user.MRSummary = true;
else
user.MRSummary = false;
if (Request.Form["MRGraph"] == "1")
user.MRGraph = true;
else
user.MRGraph = false;
if (Request.Form["ViewPermanentStaff"] == "1")
user.ViewPermanentStaff = true;
else
user.ViewPermanentStaff = false;
if (Request.Form["ViewPermanentMgm"] == "1")
user.ViewPermanentMgm = true;
else
user.ViewPermanentMgm = false;
if (Request.Form["ViewContractual"] == "1")
user.ViewContractual = true;
else
user.ViewContractual = false;
if (Request.Form["ViewLocation"] == "1")
user.ViewLocation = true;
else
user.ViewLocation = false;
if (check == false)
{
string _dpName = FindADUser(user.UserName);
if (_dpName != "No")
{
user.Name = _dpName;
user.DateCreated = DateTime.Today;
user.EmpID = _emp.FirstOrDefault().EmpID;
db.Users.Add(user);
db.SaveChanges();
//Save UserLoc
List<Location> locs = new List<Location>();
locs = db.Locations.ToList();
for (int i = 1; i <= count; i++)
{
string uLocID = "uLocation" + i;
string LocName = Request.Form[uLocID].ToString();
int locID = locs.Where(aa => aa.LocName == LocName).FirstOrDefault().LocID;
UserLocation uloc = new UserLocation();
uloc.UserID = user.UserID;
uloc.LocationID = (short)locID;
db.UserLocations.Add(uloc);
db.SaveChanges();
}
return RedirectToAction("Index");
}
}
}
ViewBag.CompanyID = new SelectList(db.Companies, "CompID", "CompName", user.CompanyID);
ViewBag.EmpID = new SelectList(db.Emps, "EmpID", "EmpNo", user.EmpID);
ViewBag.RoleID = new SelectList(db.UserRoles, "RoleID", "RoleName", user.RoleID);
ViewBag.LocationID = new SelectList(db.Locations, "LocID", "LocName", user.LocationID);
return View(user);
}