protected void btnAddNewMenuItem_Click(object sender, EventArgs e)
{
Product Newprod = new Product();
Newprod.Product_Name = tbMenuItemNameNew.Text;
Newprod.Price = decimal.Parse(tbNewMenuPrice.Text);
dde.Products.Add(Newprod);
dde.SaveChanges();
List <Inventory> listofItems = new List <Inventory>();
foreach (ListViewDataItem item in lvNewInventory.Items)
{
CheckBox cbProductInvItem = (CheckBox)item.FindControl("cbProductInvItem");
if (cbProductInvItem.Checked)
{
Label lblItemID = (Label)item.FindControl("lblItemID");
int id2 = int.Parse(lblItemID.Text);
Inventory invItem = dde.Inventories.Find(id2);
if (invItem != null)
{
listofItems.Add(invItem);
}
}
}
foreach (Inventory inv in listofItems)
{
Product_Inventory NewprodInv = new Product_Inventory();
NewprodInv.Item_ID = inv.Item_ID;
NewprodInv.Product_ID = Newprod.Product_ID;
dde.Product_Inventory.Add(NewprodInv);
dde.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
Product_Inventory product_Inventory = db.Product_Inventory.Find(id);
db.Product_Inventory.Remove(product_Inventory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: ProductInventory/Create
public ActionResult Create(int?productID)
{
var inventory = new Product_Inventory()
{
product_id = Convert.ToInt32(productID), Product = db.Products.Find(productID)
};
ViewBag.ActionTitle = "Create ";
return(View(inventory));
}
public ActionResult Edit([Bind(Include = "Id,product_id,unit_quantity,unit_per_package,per_package_cost,packaging_cost,per_package_price")] Product_Inventory product_Inventory)
{
if (ModelState.IsValid)
{
product_Inventory.CalculatePackage();
db.Entry(product_Inventory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.product_id = new SelectList(db.Products, "Id", "product_name", product_Inventory.product_id);
ViewBag.ActionTitle = "Edit ";
return(View(product_Inventory));
}
public ActionResult Create([Bind(Include = "Id,product_id,unit_quantity,unit_per_package,packaging_cost")] Product_Inventory product_Inventory)
{
if (ModelState.IsValid)
{
product_Inventory.CalculatePackage();
db.Product_Inventory.Add(product_Inventory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.product_id = new SelectList(db.Products, "Id", "product_name", product_Inventory.product_id);
ViewBag.ActionTitle = "Create ";
return(View(product_Inventory));
}
// GET: ProductInventory/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Product_Inventory product_Inventory = db.Product_Inventory.Find(id);
if (product_Inventory == null)
{
return(HttpNotFound());
}
ViewBag.ActionTitle = "Detailed ";
return(View(product_Inventory));
}
// GET: ProductInventory/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Product_Inventory product_Inventory = db.Product_Inventory.Find(id);
if (product_Inventory == null)
{
return(HttpNotFound());
}
ViewBag.product_id = new SelectList(db.Products, "Id", "product_name", product_Inventory.product_id);
ViewBag.ActionTitle = "Edit ";
return(View(product_Inventory));
}
protected void lvInventoryItems_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item is ListViewDataItem)
{
ListViewDataItem item = (ListViewDataItem)e.Item;
Inventory inv = (Inventory)item.DataItem;
if (prod != null)
{
Product_Inventory prodInv = dde.Product_Inventory.Where(t => t.Item_ID == inv.Item_ID && t.Product_ID == prod.Product_ID).ToList().FirstOrDefault();
if (prodInv != null)
{
CheckBox cbProductInvItem = (CheckBox)item.FindControl("cbProductInvItem");
cbProductInvItem.Checked = true;
}
}
}
}
protected void btnUpdateMenuItem_Click(object sender, EventArgs e)
{
long id = long.Parse(ddlMenuItemProducts.SelectedValue);
prod = dde.Products.Find(id);
prod.Price = decimal.Parse(txtMenuItemPrice.Text);
dde.SaveChanges();
List <Inventory> listofItems = new List <Inventory>();
foreach (ListViewDataItem item in lvInventoryItems.Items)
{
CheckBox cbProductInvItem = (CheckBox)item.FindControl("cbProductInvItem");
if (cbProductInvItem.Checked)
{
Label lblItemID = (Label)item.FindControl("lblItemID");
int id2 = int.Parse(lblItemID.Text);
Inventory invItem = dde.Inventories.Find(id2);
if (invItem != null)
{
listofItems.Add(invItem);
}
}
}
foreach (Inventory inv in listofItems)
{
Product_Inventory prodInv = dde.Product_Inventory.Where(t => t.Item_ID == inv.Item_ID && prod.Product_ID == t.Product_ID).ToList().FirstOrDefault();
if (prodInv == null)
{
Product_Inventory NewprodInv = new Product_Inventory();
NewprodInv.Item_ID = inv.Item_ID;
NewprodInv.Product_ID = prod.Product_ID;
dde.Product_Inventory.Add(NewprodInv);
dde.SaveChanges();
}
}
foreach (Product_Inventory prodInv in prod.Product_Inventory.ToList())
{
if (!listofItems.Contains(prodInv.Inventory))
{
Product_Inventory prodInv2 = dde.Product_Inventory.Find(prodInv.Prod_Inv_ID);
dde.Product_Inventory.Remove(prodInv2);
dde.SaveChanges();
}
}
prod = new Product();
}
