public IHttpActionResult PutProduct(int id, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != product.ProductID)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutSupplier(int id, Supplier supplier)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != supplier.SupplierID)
{
return(BadRequest());
}
db.Entry(supplier).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SupplierExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutCategory(int id, Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != category.CategoryID)
{
return(BadRequest());
}
db.Entry(category).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "SupplierID,SupplierName,SupplierPhone,SupplierWebPage")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Create([Bind(Include = "CategoryID,CategoryName")] Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public bool Register(User user)
{
if (_db.Users.FirstOrDefault(u => u.Name == user.Name) != null ||
user.Password == "")
{
return(false);
}
_db.Users.Add(user);
_db.SaveChanges();
return(true);
}
public ActionResult Create([Bind(Include = "Item,Quantity")] Stocks stocks)
{
if (ModelState.IsValid)
{
stocks.Id = Guid.NewGuid();
db.Stocks.Add(stocks);
db.SaveChanges();
return(RedirectToAction("Stocks"));
}
return(View(stocks));
}
public ActionResult Create([Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,UnitPrice")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", product.CategoryID);
ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "SupplierName", product.SupplierID);
return(View(product));
}
public Stock AddStock(Stock stock, int ownerId)
{
if (stock != null)
{
_db.Stocks.Add(stock);
_db.SaveChanges();
_db.UsersStocks.Add(new UserStock {
StockId = stock.Id, UserId = ownerId
});
_db.SaveChanges();
stock.UsersStocks = null;
stock.ItemsStocksHistory = null;
return(stock);
}
return(null);
}
public Item AddItem(Item item, int stockId, int ownerId)
{
if (item != null && _db.UsersStocks.FirstOrDefault(us => us.StockId == stockId && us.UserId == ownerId) != null)
{
_db.Items.Add(item);
_db.SaveChanges();
_db.ItemsStocksHistory.Add(new ItemStockHistory {
ItemId = item.Id, StockId = stockId, ArrivalDate = DateTime.Now
});
_db.SaveChanges();
item.ItemsStocksHistory = null;
return(item);
}
return(null);
}
public ActionResult PlaceOrder(Orders order)
{
order.Id = Guid.NewGuid();
order.DateOrdered = DateTime.UtcNow;
ordersDb.Orders.Add(order);
ordersDb.SaveChanges();
bool success = true;
string message = "Order Success! Enjoy your coffee.";
try
{
var drink = drinksDb.Drinks.Find(order.DrinkOrderedGuid);
var recipe = recipeDb.Recipes.Where(x => x.DrinkId.Equals(drink.Id));
foreach (var ingredient in recipe)
{
var updateStock = stocksDb.Stocks.Find(ingredient.StockId);
int requiredStocks = ingredient.Quantity * order.Quantity;
if (updateStock.Quantity < requiredStocks)
{
success = false;
message = "Sorry we have insufficient stocks. Try ordering less?";
break;
}
else
{
updateStock.Quantity -= requiredStocks;
stocksDb.Entry(updateStock).State = EntityState.Modified;
stocksDb.SaveChanges();
}
}
}
catch (Exception ex)
{
success = false;
message = "Error encountered" + ex.Message;
}
return(Json(new { message = message, success = success }, JsonRequestBehavior.AllowGet));
}
