public JsonResult FetchLocations(int id)
{
string username = DBHandler.GetTempUsername(this);
var locations = DBHandler.GetLocations().Select(l => new
{
ID = l.LocationId,
CI = DBHandler.GetCategories().FirstOrDefault(x => x.CategoryId.Equals(l.CategoryId)).Icon,
Titel = l.Title,
CategoryID = l.CategoryId,
Lock = l.Locked,
Favloc = DBHandler.GetFavourites().Exists(x => x.LocationId.Equals(l.LocationId) && x.Username.Equals(username))
}).Where(l => l.CategoryID.Equals(id));
return(Json(locations));
}
public int GetAmountOfFavourites(int locationId)
{
int favourites = DBHandler.GetFavourites().Count(x => x.LocationId.Equals(locationId));
return(favourites != 0 ? favourites : 0);
}
