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