public List <UploadedImage> GetBySubcategory(int subcategoryId) { using (var context = new ImagesDataContext(_connectionString)) { return(context.UploadedImages.Where(i => i.SubcategoryId == subcategoryId).ToList()); } }
public void AddSubcategory(Subcategory subcategory) { using (var context = new ImagesDataContext(_connectionString)) { context.Subcategories.Add(subcategory); context.SaveChanges(); } }
public void AddImage(UploadedImage image) { using (var context = new ImagesDataContext(_connectionString)) { context.UploadedImages.Add(image); context.SaveChanges(); } }
public List <UploadedImage> GetByCategory(int categoryId) { using (var context = new ImagesDataContext(_connectionString)) { return(context.UploadedImages .Include(u => u.Subcategory) .Where(i => i.Subcategory.Category.Id == categoryId) .ToList()); } }
public List <Category> GetCategories(bool includeSubcategories) { using (var context = new ImagesDataContext(_connectionString)) { IQueryable <Category> query = context.Categories; if (includeSubcategories) { query = query.Include(c => c.Subcategories); } return(query.ToList()); } }