public IQueryable <Category> GetCategories() { var _db = new VideoOnline.Models.VideoContext(); IQueryable <Category> query = _db.Categories; return(query); }
public IQueryable <Video> GetVideos([QueryString("id")] int?categoryId) { var _db = new VideoOnline.Models.VideoContext(); IQueryable <Video> query = _db.Videos; if (categoryId.HasValue && categoryId > 0) { query = query.Where(p => p.CategoryID == categoryId); } return(query); }
public IQueryable <Video> GetVideo([QueryString("VideoID")] int?videoId) { var _db = new VideoOnline.Models.VideoContext(); IQueryable <Video> query = _db.Videos; if (videoId.HasValue && videoId > 0) { query = query.Where(p => p.VideoID == videoId); } else { query = null; } return(query); }