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);
}
