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