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