public bool editProduct(Product product) { ProductContext db = new ProductContext(); if(product != null) { db.Entry(product).State = EntityState.Modified; //db.SaveChanges(); bool saveFailed; do { saveFailed = false; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { saveFailed = true; // Update the values of the entity that failed to save from the store ex.Entries.Single().Reload(); } } while (saveFailed); return true; } else { return false; } }
public bool editCategory(Category cat) { var db = new ProductContext(); if(cat != null) { db.Entry(cat).State = EntityState.Modified; db.SaveChanges(); return true; } return false; }
public bool addCategory(Category cat) { var db = new ProductContext(); if(cat != null) { db.Categories.Add(cat); db.SaveChanges(); return true; } return false; }
public bool addOrder(Order order) { var db = new ProductContext(); if(order != null) { db.Orders.Add(order); db.SaveChanges(); return true; } return false; }
public bool deleteCategory(int? id) { var db = new ProductContext(); Category cat = db.Categories.Find(id); if(cat != null) { db.Categories.Remove(cat); db.SaveChanges(); return true; } return false; }
public bool addProduct(Product product) { ProductContext db = new ProductContext(); if(product != null) { db.Products.Add(product); db.SaveChanges(); return true; } else { return false; } }
public bool deleteProduct(int? id) { ProductContext db = new ProductContext(); Product product = db.Products.Find(id); if(product != null) { db.Products.Remove(product); db.SaveChanges(); return true; } else { return false; } }
public IEnumerable<Category> getAllCategories() { var db = new ProductContext(); return db.Categories.ToList(); }
public bool dispose() { var db = new ProductContext(); db.Dispose(); return true; }
public Order getOrder(int? id) { var db = new ProductContext(); return db.Orders.Include("OrderDetails").Single(c => c.OrderId == id); }
public Category getProductsFromCategory(string category) { var db = new ProductContext(); var categoryModel = db.Categories.Include("Products").Single(c => c.Name == category); return categoryModel; }
public Product getProduct(int? id) { ProductContext db = new ProductContext(); Product product = db.Products.Find(id); return product; }
public bool validateUserPurchase(int id, string user) { var db = new ProductContext(); return db.Orders.Any(o => o.OrderId == id && o.Username == user); }
public bool save() { var db = new ProductContext(); db.SaveChanges(); return true; }
public IEnumerable<Order> getOrderHistory(string id) { var db = new ProductContext(); return db.Orders.Where(o => o.UserId == id).ToList(); }
public Category getCategory(int? id) { var db = new ProductContext(); Category cat = db.Categories.Find(id); return cat; }
public SelectList getCatList() { var db = new ProductContext(); var list = new SelectList(db.Categories, "CategoryId", "Name"); return list; }
public IEnumerable<Product> getAllProducts() { ProductContext db = new ProductContext(); var products = db.Products.Include(c => c.Category); return products.ToList(); }
public string getItemName(int id) { var db = new ProductContext(); return db.Carts.Single(item => item.RecordId == id).Product.Name; }
public Product getProd(int id) { ProductContext db = new ProductContext(); return db.Products.Single(product => product.ProductId == id); }