public ActionResult Index() { int id = 0; string userPerson = ""; if (Session["userId"] != null) { userPerson = Session["userId"].ToString(); } id = int.Parse(userPerson); var userInfo = pocoDb.Fetch <tblUser>(" WHERE userID=@0", id).FirstOrDefault(); var UserName = userInfo.userName; var UserPassword = userInfo.userPassword; if (string.IsNullOrEmpty(UserName) || string.IsNullOrEmpty(UserPassword)) { return(RedirectToAction("Login", "Home")); } if (ModelState.IsValid) { var user = pocoDb.Fetch <tblUser>(" WHERE userName = @0 and userPassword=@1", UserName, UserPassword).FirstOrDefault(); if (user != null) { Session["username"] = UserName; Session["userId"] = user.userID; var solutions = pocoDb.Fetch <tblSolution>(" WHERE isActive=1"); var VM = new ClientPortal.ViewModels.LoginViewModel { Solutions = solutions }; return(View(VM)); } else { Session["LoginErrorMessage"] = "Invalid Username or password"; return(View("Login", Session["LoginErrorMessage"])); } } return(RedirectToAction("Login", "Home")); }
public ActionResult Search(string searchString) { if (string.IsNullOrEmpty(searchString)) { var tblSolutions = pocoDb.Fetch <tblSolution>("Where isActive=1").ToList(); var titleList = tblSolutions.Select(x => x.solutionTitle).ToList(); var Solution = new ClientPortal.ViewModels.LoginViewModel { Solutions = tblSolutions }; return(View(Solution)); } else { var selectedTitle = pocoDb.Fetch <tblSolution>("Where solutionTitle LIKE @0", "%" + searchString + "%").ToList(); var VMSolution = new ClientPortal.ViewModels.LoginViewModel { Solutions = selectedTitle }; return(PartialView(VMSolution)); } }