public IQueryable <Category> GetCategories() { var _db = new MusicWebsite.Models.MusicContext(); IQueryable <Category> query = _db.Categories; return(query); }
public IQueryable <Music> GetMusics([QueryString("id")] int?categoryId) { var _db = new MusicWebsite.Models.MusicContext(); IQueryable <Music> query = _db.Musics; if (categoryId.HasValue && categoryId > 0) { query = query.Where(p => p.CategoryID == categoryId); } return(query); }
public IQueryable <Music> GetMusic([QueryString("musicID")] int?musicId) { var _db = new MusicWebsite.Models.MusicContext(); IQueryable <Music> query = _db.Musics; if (musicId.HasValue && musicId > 0) { query = query.Where(p => p.MusicID == musicId); } else { query = null; } return(query); }