public ActionResult UserSignedIn(int lsid)
        {
            var userssignedin = db.GetUsers();

            ViewBag.LSID     = lsid;
            ViewBag.LSIDName = db.GetUserByUserid(lsid).Username;
            ViewBag.LSIDLoc  = db.GetLocationByLocationid(lsid).City;
            foreach (var usersignedin in userssignedin)
            {
                u          = new Models.User();
                u.Userid   = usersignedin.Userid;
                u.Username = usersignedin.Username;
                u.Password = usersignedin.Password;
                u.Numu++;
                u.Firstname   = usersignedin.Firstname;
                u.Lastname    = usersignedin.Lastname;
                u.Ulocationid = usersignedin.Ulocationid;
                UserList.Add(u);
                //ViewData["Location"] = db.GetLocationByLocationid(usersignedin.Ulocationid).City;
            }
            return(View(UserList));
        }
        public IActionResult Index(string username, string password)
        {
            //var query = _repository.GetIdByUserName(username);

            foreach (var user in _repository.GetUsers().ToList())
            {
                if (user.Username == username && user.Pass == password)
                {
                    ViewBag.success  = "Login successful";
                    TempData["user"] = _repository.GetIdByUserName(username);

                    return(Redirect("~/"));
                }
            }
            ViewBag.fail = "Login failed, try again";
            return(View());
        }