public async Task <ActionResult> DeleteConfirmed(int id)
{
In_warehouse in_warehouse = await db.In_warehouse.FindAsync(id);
db.In_warehouse.Remove(in_warehouse);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: In_warehouse/Delete/5
public async Task <ActionResult> Delete(int?id, int?wh_id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
In_warehouse in_warehouse = await db.In_warehouse.Where(i => i.Product_id == id && i.Warehouse_id == wh_id).FirstOrDefaultAsync();
if (in_warehouse == null)
{
return(HttpNotFound());
}
return(View(in_warehouse));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Price_base,Price,Category_id,Currency_id,Barcode,Quantity,Warehouse_id")] Product product)
{
if (ModelState.IsValid)
{
In_warehouse in_Warehouse = db.In_warehouse.Where(i => i.Warehouse_id == product.Warehouse_id && i.Product_id == product.Id).FirstOrDefault();
in_Warehouse.Quantity = product.Quantity;
Currency currency = await db.Currency.Where(i => i.Id == product.Currency_id).FirstOrDefaultAsync();
product.Price_base = Math.Round(product.Price * currency.Rate, 3);
db.Entry(product).State = EntityState.Modified;
db.Entry(in_Warehouse).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Details", new { id = product.Warehouse_id }));
}
ViewBag.Category_id = new SelectList(db.Category, "Id", "Name", product.Category_id);
ViewBag.Currency_id = new SelectList(db.Currency, "Id", "Name", product.Currency_id);
return(View(product));
}
public async Task <ActionResult> Create([Bind(Include = "Quantity,Warehouse_id,Product_id")] In_warehouse in_Warehouse)
{
if (ModelState.IsValid)
{
In_warehouse warehouse = await db.In_warehouse.Where(i => i.Warehouse_id == in_Warehouse.Warehouse_id && i.Product_id == in_Warehouse.Product_id).FirstOrDefaultAsync();
if (warehouse == null)
{
db.In_warehouse.Add(in_Warehouse);
}
else
{
warehouse.Quantity += in_Warehouse.Quantity;
db.Entry(warehouse).State = EntityState.Modified;
}
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//ViewBag.Category_id = new SelectList(db.Category, "Id", "Name", product.Category_id);
//ViewBag.Currency_id = new SelectList(db.Currency, "Id", "Name", product.Currency_id);
return(View());
}
