public ActionResult Assignroles() { IStructuredetailRepository objstructureRepository = new StructuredetailRepository(); var rolelist = objstructureRepository.Getroles().ToList(); SelectList list = new SelectList(rolelist, "Id", "RoleName"); ViewBag.getrolelist = list; return(View()); }
public ActionResult Assignroles(EmployeeUserVM user, FormCollection form) { IStructuredetailRepository objstructureRepository = new StructuredetailRepository(); IUserRepository objuserRepository = new UserRepository(); var usercheck = objuserRepository.GetAll().Where(a => a.UserId == user.UserId).FirstOrDefault(); if (usercheck != null) { var chkadmin = form["getadmin"]; var adminId = Convert.ToInt32(chkadmin); objuserRepository.Update(user.RoleId, adminId, user.UserId); objuserRepository.Save(); if (chkadmin == null) { chkadmin = "0"; } TempData["SuccessMessage1"] = "Role Assigned"; var rolelist = objstructureRepository.Getroles().ToList(); SelectList list = new SelectList(rolelist, "Id", "RoleName"); ViewBag.getrolelist = list; } else { var rolelist = objstructureRepository.Getroles().ToList(); SelectList list = new SelectList(rolelist, "Id", "RoleName"); ViewBag.getrolelist = list; TempData["ErrorMessage1"] = "Select from User List"; } return(View()); }
public ActionResult Login(tblUser model) { using (var context = new SqlContext()) { IUserRepository objrepo = new UserRepository(); IDepartmentRepository objdep = new DepartmentRepository(); IStructuredetailRepository objstruct = new StructuredetailRepository(); IEmployeeRepository objemp = new EmployeeRepository(); var isActive = objrepo.GetAll().Where(x => x.IsActive == 1) .Where(a => a.UserName == model.UserName && a.Password == model.Password).FirstOrDefault(); if (isActive != null) { var user = (from u in objrepo.GetAll() join d in objdep.GetAll() on u.DepartmentId equals d.DepartmentId join a in objrepo.GetAdmin() on u.AdminId equals a.AdminId join r in objstruct.Getroles() on u.RoleId equals r.Id join e in objemp.GetAll() on u.EmployeeId equals e.EmployeeId join s in objstruct.GetAll() on e.Id equals s.Id where u.UserName == model.UserName && u.Password == model.Password select new { u.UserName, u.UserId, d.DepartmentName, a.desc, r.RoleName, e.CompanyCode, s.CompanyName, e.CityCode, s.CityName, e.EmployeeName, e.PositionId, d.DepartmentId, e.EmployeeId }).FirstOrDefault(); if (user != null) { Session["UserName"] = user.UserName; Session["UserId"] = user.UserId; Session["DepartmentName"] = user.DepartmentName; Session["RoleName"] = user.RoleName; Session["isAdmin"] = user.desc; Session["CompanyName"] = user.CompanyName; Session["CityName"] = user.CityName; Session["CompanyCode"] = user.CompanyCode; Session["CityCode"] = user.CityCode; Session["Employeename"] = user.EmployeeName; Session["PositionId"] = user.PositionId; Session["DepartmentId"] = user.DepartmentId; Session["EmployeeId"] = user.EmployeeId; TempData["SuccessMessage"] = "Login Successfull"; return(RedirectToAction("Index", "Home")); } else { TempData["ErrorMessage"] = "Invalid UserName or Password"; } } else { TempData["ErrorMessage"] = "User is not Active.Please Login Again."; } return(View()); } }