public ActionResult Create(SEC_UserAddEditModel sEC_UserAddEditModel) { if (sEC_UserAddEditModel == null) { return(HttpNotFound()); } //if (ModelState.IsValid) if (sEC_UserAddEditModel != null) { if (sEC_UserAddEditModel.sEC_User != null) { sEC_UserAddEditModel.sEC_User.Created = DateTime.Now; sEC_UserAddEditModel.sEC_User.Modified = DateTime.Now; sEC_UserAddEditModel.sEC_User.EmployeeID = sEC_UserAddEditModel.sEC_User.EmployeeID; if (Session["UserID"] != null) { sEC_UserAddEditModel.sEC_User.CreatedByUserID = Convert.ToInt16(Session["UserID"].ToString()); } db.SEC_User.Add(sEC_UserAddEditModel.sEC_User); db.SaveChanges(); List <SEC_UserPrivileges> newList_SEC_UserPrivileges = new List <SEC_UserPrivileges>(); foreach (var item in sEC_UserAddEditModel.sYS_ModuleList) { SEC_UserPrivileges new_SEC_UserPrivileges = new SEC_UserPrivileges(); if (item.IsSelected == true) { new_SEC_UserPrivileges.ModuleID = item.ModuleID; new_SEC_UserPrivileges.UserID = sEC_UserAddEditModel.sEC_User.UserID; new_SEC_UserPrivileges.CreatedByUserID = Convert.ToInt16(Session["UserID"].ToString()); new_SEC_UserPrivileges.Created = DateTime.Now; new_SEC_UserPrivileges.Modified = DateTime.Now; newList_SEC_UserPrivileges.Add(new_SEC_UserPrivileges); } } if (newList_SEC_UserPrivileges.Count > 0) { db.SEC_UserPrivileges.AddRange(newList_SEC_UserPrivileges); db.SaveChanges(); } return(RedirectToAction("Index")); } else { return(HttpNotFound()); } } var Employees = db.EMP_Employee .Where(i => i.IsActive == true) .Select(s => new { EmployeeID = s.EmployeeID, EmployeeName = s.EMP_Department.DepartmentName + " - " + s.EMP_Designation.Designation + " - " + s.EmployeeName }) .ToList(); ViewBag.EmployeeID = new SelectList(Employees, "EmployeeID", "EmployeeName"); //ViewBag.EmployeeID = new SelectList(db.EMP_Employee, "EmployeeID", "EmployeeName", sEC_UserAddEditModel.sEC_User.EmployeeID); ViewBag.CreatedByUserID = new SelectList(db.SEC_User, "UserID", "UserName", sEC_UserAddEditModel.sEC_User.CreatedByUserID); return(View(sEC_UserAddEditModel)); }
public ActionResult Edit(SEC_UserAddEditModel sEC_UserAddEditModel) { if (sEC_UserAddEditModel == null) { //error handle } if (sEC_UserAddEditModel != null) { if (sEC_UserAddEditModel.sEC_User != null) { var get_SEC_User = db.SEC_User.Where(e => e.UserID == sEC_UserAddEditModel.sEC_User.UserID).FirstOrDefault(); //get_SEC_User.EmployeeID = sEC_UserAddEditModel.sEC_User.EmployeeID; get_SEC_User.UserName = sEC_UserAddEditModel.sEC_User.UserName; get_SEC_User.Password = sEC_UserAddEditModel.sEC_User.Password; get_SEC_User.IsAdmin = sEC_UserAddEditModel.sEC_User.IsAdmin; get_SEC_User.IsActive = sEC_UserAddEditModel.sEC_User.IsActive; get_SEC_User.Remarks = sEC_UserAddEditModel.sEC_User.Remarks; get_SEC_User.Modified = DateTime.Now; db.SaveChanges(); if (sEC_UserAddEditModel.sYS_ModuleList != null) { foreach (var moduleList in sEC_UserAddEditModel.sYS_ModuleList) { if (moduleList.IsSelected == true) { var checkExist = db.SEC_UserPrivileges.Any(usp => usp.UserID == get_SEC_User.UserID && usp.ModuleID == moduleList.ModuleID); int userid = get_SEC_User.UserID; if (checkExist == false) { var newModuleAdd = new SEC_UserPrivileges() { ModuleID = moduleList.ModuleID, UserID = userid, CreatedByUserID = Convert.ToInt16(Session["UserID"].ToString()), Created = DateTime.Now, Modified = DateTime.Now }; db.SEC_UserPrivileges.Add(newModuleAdd); db.SaveChanges(); } } } } List <int> getAllSelectedModuleList = sEC_UserAddEditModel.sYS_ModuleList.Where(e => e.IsSelected == true).Select(e => e.ModuleID).ToList(); List <SEC_UserPrivileges> removeRange = db.SEC_UserPrivileges.Where(t => t.UserID == sEC_UserAddEditModel.sEC_User.UserID && !getAllSelectedModuleList.Contains(t.ModuleID)).Select(t => t).ToList(); db.SEC_UserPrivileges.RemoveRange(removeRange); db.SaveChanges(); } } var Employees = db.EMP_Employee .Where(i => i.IsActive == true) .Select(s => new { EmployeeID = s.EmployeeID, EmployeeName = s.EMP_Department.DepartmentName + " - " + s.EMP_Designation.Designation + " - " + s.EmployeeName }) .ToList(); ViewBag.EmployeeID = new SelectList(Employees, "EmployeeID", "EmployeeName", sEC_UserAddEditModel.sEC_User.EmployeeID); //ViewBag.EmployeeID = new SelectList(db.EMP_Employee, "EmployeeID", "EmployeeName", sEC_UserAddEditModel.sEC_User.EmployeeID); ViewBag.CreatedByUserID = new SelectList(db.SEC_User, "UserID", "UserName", sEC_UserAddEditModel.sEC_User.CreatedByUserID); return(RedirectToAction("Index")); }