public ActionResult LoginValidation(User u) { using (var context = new ExamTeamManagementSystemEntities()) { var data = context.TechnicalIssues.SqlQuery("[dbo].[SelectAllTechIssues]").ToList(); Debug.WriteLine("Count Tech Issue" + data.Count()); } Debug.WriteLine("Username" + u.UserName); Debug.WriteLine("Password" + u.Password); Debug.WriteLine("Selected Role" + u.URoleList); var collist = from s in _db.Users where s.UserName == u.UserName && s.Password == u.Password && s.UserRole == u.URoleList.ToString() select s; Debug.WriteLine("ReturnedRows" + collist.Count()); if (collist.Count() > 0) { Session["Username"] = u.UserName; if (u.URoleList.ToString() == "ExamTeam") { return(RedirectToAction("ExamTeamHomePage")); } else if (u.URoleList.ToString() == "ITUnitTeam") { return(RedirectToAction("ITHomePage", "ITUnitTeam")); } else if (u.URoleList.ToString() == "LogisticsSupportTeam") { Debug.WriteLine("I am in LogisticsTeam"); return(RedirectToAction("LogisticsHomePage", "LogisticsSupportTeam")); } return(RedirectToAction("ExamTeamHomePage")); } else { return(RedirectToAction("LoginFailurePage")); } }
public ExamTeamController() { _db = new ExamTeamManagementSystemEntities(); }
public LogisticsSupportTeamController() { _db = new ExamTeamManagementSystemEntities(); }