public Category Get(int ID) { using (_dbContext = new ProductsEntities()) { Category category = _dbContext.Categories.FirstOrDefault(p => p.ID == ID); return category; } }
public Product Get(int ID) { using (_dbContext = new ProductsEntities()) { Product product = _dbContext.Products.Include("Category").FirstOrDefault(p => p.ID == ID); return product; } }
public IEnumerable<Category> Get() { using (_dbContext = new ProductsEntities()) { IEnumerable<Category> categories = _dbContext.Categories.ToList(); return categories; } }
public IEnumerable<Product> Get() { using (_dbContext = new ProductsEntities()) { IEnumerable<Product> products = _dbContext.Products.Include("Category").ToList(); return products; } }
public int Create(Category category) { using (_dbContext = new ProductsEntities()) { _dbContext.Categories.Add(category); var result = _dbContext.SaveChanges(); return (result > 0) ? category.ID : -1; } }
public int Create(Product product) { using (_dbContext = new ProductsEntities()) { _dbContext.Products.Add(product); var result = _dbContext.SaveChanges(); return (result > 0) ? product.ID : -1; } }
public int Delete(int ID) { using (_dbContext = new ProductsEntities()) { var category = _dbContext.Categories.FirstOrDefault(p => p.ID == ID); _dbContext.Categories.Remove(category); var result = _dbContext.SaveChanges(); return result; } }
public int Update(Category category) { Category dbCategory; var result = -1; using (_dbContext = new ProductsEntities()) { dbCategory = _dbContext.Categories.FirstOrDefault(p => p.ID == category.ID); } if (dbCategory != null) { MapCategory(dbCategory, category); using (_dbContext = new ProductsEntities()) { _dbContext.Entry(category).State = System.Data.Entity.EntityState.Modified; result = _dbContext.SaveChanges(); } } return result; }
public int Update(Product product) { Product dbProduct; var result = -1; using (_dbContext = new ProductsEntities()) { dbProduct = _dbContext.Products.FirstOrDefault(p => p.ID == product.ID); } if (dbProduct != null) { MapProduct(dbProduct, product); using (_dbContext = new ProductsEntities()) { _dbContext.Entry(product).State = System.Data.Entity.EntityState.Modified; result = _dbContext.SaveChanges(); } } return result; }