//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"));
}
}
