public ActionResult TryLogin(User user) { using (var lContext = new Models.TreeHouses()) #region { var lCurrentUsers = lContext.Users .AsNoTracking() .Where(lUser => lUser.UserName == user.UserName && lUser.Password == user.Password) .Select(x => new { user = x, roles = x.Roles.Where(role => role.IsDeleted == null || role.IsDeleted == false), permissions = x.AdditionalPermission.Where(permission => permission.IsDeleted == null || permission.IsDeleted == false), }) .Take(2) .Select(x => x.user); if (lCurrentUsers.Count() > 1) { return(RedirectToAction("Login")); } this.HttpContext.User = lCurrentUsers.FirstOrDefault(); }//end using #endregion // return(RedirectToAction("Index", "Home")); }
public ActionResult Index() { using (var lContext = new Models.TreeHouses()) return(View(lContext.ComicBooks.ToList())); }