//Söka efter alla användare på deras namn. public ActionResult SearchBar(string search) { try { var MyId = ThisUser(); var ctx = new Gr8DbContext(); var lista = new SeachBarViewModel { User = ctx.Users.Where(x => x.FirstName.Contains(search) && x.Active == true && x.Id != MyId || search == null && x.Active == true && x.Id != MyId).OrderBy(i => i.FirstName).ToList() }; return(View(lista)); } catch (Exception e) { Console.WriteLine(e.Message); return(View("Error")); } }
//Söker igenom alla användare för att leta efter dem som har samma intressen, då är det en match. public ActionResult MatchSearch() { try { var MyId = ThisUser(); var ctx = new Gr8DbContext(); var viewmodel = new SeachBarViewModel { User = ctx.Database.SqlQuery <User>("Select * From Users Where Id in (Select UserId From UserInterests Where Interest in (Select Interest From UserInterests Where UserId =" + MyId + ")) And Id !=" + MyId + " order by FirstName").ToList() }; return(View(viewmodel)); } catch (Exception e) { Console.WriteLine(e.Message); return(View("Error")); } }