public Product GetProductById(int productId) { using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { return Db.Products.Where(x => x.ProductID == productId).FirstOrDefault(); } }
public IEnumerable<Product> GetAllProducts() { using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { return Db.Products.ToList(); } }
public void DeleteProduct(int productId) { using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { var prod = new Product() { ProductID = productId }; Db.Products.Attach(prod); Db.Products.Remove(prod); Db.SaveChanges(); } }
public void SetInventory(int productId, int quantity) { var prod = GetProductById(productId); using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { if (prod != null) { Db.Products.Attach(prod); prod.Inventory = quantity; Db.Entry(prod).Property("Inventory").IsModified = true; Db.SaveChanges(); } } }
public MySqlProductData(String connectionString) { if (connectionString == null) throw new ArgumentNullException("connectionString"); ConnectionString = connectionString; using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { if (!Db.Database.Exists() || !Db.Database.CompatibleWithModel(true)) { Db.Database.Delete(); Db.Database.Create(); } } }
public int StoreProduct(Product product) { using (MySqlProductsDb Db = new MySqlProductsDb(ConnectionString)) { Db.Products.Add(product); Db.SaveChanges(); } return product.ProductID; }