private void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { Menu_Item item = new Menu_Item(); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = new Menu_Item_Price(); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; db.Menu_Item.Add(item); db.SaveChanges(); MessageBox.Show("Menu item added successfully"); this.Close(); } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void button7_Click(object sender, EventArgs e) { if (numericUpDown1.Text != "0") { int id = Globals.OrderMenuItem; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Price price = db.Menu_Item_Price.FirstOrDefault(c => c.Menu_Price_ID == id); if ((item != null) && (price != null)) { string itemDesc = "ID: " + Convert.ToString(item.Menu_Item_ID) + " Name: " + item.Menu_Item_Name + " Description: " + item.Menu_Item_Description + " Quantity: " + numericUpDown1.Text; listBox1.Items.Add(itemDesc); Globals menu = new Globals(); menu.OrderItemId = id; menu.OrderItemName = item.Menu_Item_Name; menu.OrderItemDescription = item.Menu_Item_Description; menu.OrderItemPrice = price.Menu_Price; menu.OrderQuantity = Convert.ToInt32(numericUpDown1.Text); itemsA.Add(menu); } } else { MessageBox.Show("Error:Quantity can't be zero"); } }
private void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { int id = Globals.MenuCombopassing; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = db.Menu_Item_Price.FirstOrDefault(c => c.Menu_Price_ID == id); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); // db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; //item.fileName =fileName = ConvertImageToBinary(pictureBox1.Image); // db.Menu_Item.Add(item); //item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_Name == txtMenuItemName.Text); ItemsPicture itempic = db.ItemsPictures.FirstOrDefault(c => c.Menu_Item_ID == id); { if ((Globals.browse == true) && (itempic != null)) { itempic.ItemName = Globals.fileName; itempic.imageVar = Globals.ConvertImageToBinary(pictureBox1.Image); // itempic.ImageID = item.Combo_ID; // Globals.browse = false; } } //itempic.ImageID = item.Menu_Item_ID; // itempic.Menu_Item_ID = item.Menu_Item_ID; //db.ItemsPictures.Add(itempic); db.SaveChanges(); Globals.refresher = true; MessageBox.Show("Menu item updated successfully"); this.Close(); } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void frmMaintainMenuItem_Load(object sender, EventArgs e) { int id = Globals.MenuCombopassing; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Type_ID == item.Menu_Price_ID); txtMenuItemName.Text = item.Menu_Item_Name; txtMenuPrice.Text = Convert.ToString(item.Menu_Item_Price); richDescription.Text = item.Menu_Item_Description; // cmbMenuItemType.Text = type.Menu_Item_Description; }
private /*async*/ void button7_Click(object sender, EventArgs e) { string phrase = txtMenuPrice.Text; int number; bool isNumeric = int.TryParse(phrase, out number); if (isNumeric == true) { Menu_Item item = new Menu_Item(); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Description == cmbMenuItemType.Text); Menu_Item_Price price = new Menu_Item_Price(); price.Menu_Price = Convert.ToDouble(txtMenuPrice.Text); db.Menu_Item_Price.Add(price); item.Menu_Item_Name = txtMenuItemName.Text; item.Menu_Item_Description = richDescription.Text; item.Menu_Item_Type_ID = type.Menu_Item_Type_ID; item.Menu_Item_Price = price.Menu_Price; item.Menu_Price_ID = price.Menu_Price_ID; //item.fileName =fileName = ConvertImageToBinary(pictureBox1.Image); db.Menu_Item.Add(item); //item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_Name == txtMenuItemName.Text); ItemsPicture itempic = new ItemsPicture(); { itempic.ItemName = item.Menu_Item_Name; itempic.imageVar = Globals.ConvertImageToBinary(pictureBox1.Image); itempic.ImageID = item.Menu_Item_ID; itempic.Menu_Item_ID = item.Menu_Item_ID; db.ItemsPictures.Add(itempic); //db.SaveChanges(); } db.SaveChanges(); Globals.refresher = true; MessageBox.Show("Menu item added successfully"); txtMenuItemName.Text = ""; txtMenuPrice.Text = ""; richDescription.Text = ""; pictureBox1.Image = null; } else { MessageBox.Show("Error: Values entered is not in correct format(not numeric)"); } }
private void frmMaintain_Menu_Item_Load(object sender, EventArgs e) { cmbMenuItemType.ValueMember = "Menu_Item_Type_ID"; cmbMenuItemType.DisplayMember = "Menu_Item_Description"; cmbMenuItemType.DataSource = db.Menu_Item_Type.ToList(); int id = Globals.MenuCombopassing; ItemsPicture pic = db.ItemsPictures.FirstOrDefault(c => c.Menu_Item_ID == id); // Image n = (Bitmap)((new ImageConverter()).ConvertFrom(pic.imageVar)); Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); Menu_Item_Price price = db.Menu_Item_Price.FirstOrDefault(c => c.Menu_Price_ID == id); Menu_Item_Type type = db.Menu_Item_Type.FirstOrDefault(c => c.Menu_Item_Type_ID == item.Menu_Item_Type_ID); pictureBox1.Image = Globals.converBinToImage(pic.imageVar); txtMenuItemName.Text = item.Menu_Item_Name; txtMenuPrice.Text = Convert.ToString(price.Menu_Price); cmbMenuItemType.Text = type.Menu_Item_Description; richDescription.Text = item.Menu_Item_Description; Globals.browse = false; }
private void dgvAuditList_CellClick(object sender, DataGridViewCellEventArgs e) { dgvAuditDetails.DataSource = null; dgvAuditDetails.Rows.Clear(); int rowindex = dgvAuditList.CurrentCell.RowIndex; dynamic value = dgvAuditList.Rows[rowindex].Cells[0].Value; if (value != null) { int v = value; Audit t = db.Audits.FirstOrDefault(c => c.Audit_ID == v); if (t.Audit_Description == "Order Processing") { var Menus = from obj in db.Customer_Order_Line join obj2 in db.Customer_Order on obj.Customer_Order_ID equals obj2.Order_ID where (obj.Menu_Item_ID != null && obj2.Order_ID == t.transactionNumber) select new { Id = obj.Menu_Item_ID, Quantity1 = obj.Menu_Item_Quantity }; var Combos = from obj in db.Customer_Order_Line join obj2 in db.Customer_Order on obj.Customer_Order_ID equals obj2.Order_ID where (obj.Combo_ID != null && obj2.Order_ID == t.transactionNumber) select new { Id = obj.Combo_ID, Quantity1 = obj.Combo_Quantity }; var Stocks = from obj in db.Customer_Order_Line join obj2 in db.Customer_Order on obj.Customer_Order_ID equals obj2.Order_ID where (obj.Stock_ID != null && obj2.Order_ID == t.transactionNumber) select new { Id = obj.Stock_ID, Quantity1 = obj.Stock_Item_Quantity }; foreach (var i in Menus) { Menu_Item m = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Menu_Item_Name, i.Quantity1); } foreach (var i in Combos) { Combo m = db.Comboes.FirstOrDefault(c => c.Combo_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Combo_Name, i.Quantity1); } foreach (var i in Stocks) { Stock_Item m = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Stock_Item_Name, i.Quantity1); } } else if (t.Audit_Description == "Order Saving") { var Menus = from obj in db.DeliveryLines join obj2 in db.DeliveryTables on obj.orderId equals obj2.OrderId where (obj.menuItemId != null && obj2.OrderId == t.transactionNumber) select new { Id = obj.menuItemId, Quantity1 = obj.menuItemQuantity }; var Combos = from obj in db.DeliveryLines join obj2 in db.DeliveryTables on obj.orderId equals obj2.OrderId where (obj.comboItemId != null && obj2.OrderId == t.transactionNumber) select new { Id = obj.comboItemId, Quantity1 = obj.comboItemQuantity }; var Stocks = from obj in db.DeliveryLines join obj2 in db.DeliveryTables on obj.orderId equals obj2.OrderId where (obj.stockItemId != null && obj2.OrderId == t.transactionNumber) select new { Id = obj.stockItemId, Quantity1 = obj.stockItemQuantity }; foreach (var i in Menus) { Menu_Item m = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Menu_Item_Name, i.Quantity1); } foreach (var i in Combos) { Combo m = db.Comboes.FirstOrDefault(c => c.Combo_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Combo_Name, i.Quantity1); } foreach (var i in Stocks) { Stock_Item m = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == i.Id); this.dgvAuditDetails.Rows.Add(m.Stock_Item_Name, i.Quantity1); } } else if (t.Audit_Description == "Stock_Item_Write_Off") { Stock_WriteOff_Line w = db.Stock_WriteOff_Line.FirstOrDefault(c => c.Stock_WriteOff_LineID == t.transactionNumber); Stock_Item s = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == w.Stock_ID); this.dgvAuditDetails.Rows.Add(s.Stock_Item_Name, w.Quantity); } else if (t.Audit_Description == "Item_CheckIn") { Check_In_Line w = db.Check_In_Line.FirstOrDefault(c => c.Check_In_Line_ID == t.transactionNumber); Stock_Item s = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == w.Stock_ID); this.dgvAuditDetails.Rows.Add(s.Stock_Item_Name, w.Quantity); } else if (t.Audit_Description == "Item_CheckOut") { Check_Out_Line w = db.Check_Out_Line.FirstOrDefault(c => c.Check_Out_ID == t.transactionNumber); Stock_Item s = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == w.Stock_ID); this.dgvAuditDetails.Rows.Add(s.Stock_Item_Name, w.Quaantity); } } }
private void dgvOrders_CellClick(object sender, DataGridViewCellEventArgs e) { int rowindex = dgvOrders.CurrentCell.RowIndex; Globals.Salespassing = dgvOrders.Rows[rowindex].Cells[0].Value; int orderNo = Globals.Salespassing; Customer_Order ordeR = db.Customer_Order.FirstOrDefault(c => c.Order_ID == orderNo); txtDate.Enabled = false; txtOrderTotal.Enabled = false; txtOrdNum.Enabled = false; txtStatus.Enabled = false; txtVat.Enabled = false; rbxNotes.Enabled = false; txtDate.Text = ordeR.Order_Date.ToString(); txtOrderTotal.Text = ordeR.OrderTotal.ToString(); txtOrdNum.Text = ordeR.Order_ID.ToString(); txtStatus.Text = ordeR.Order_Status.ToString(); txtVat.Text = ordeR.Sale_Vat_Amount.ToString(); rbxNotes.Text = ordeR.OrderNotes.ToString(); var combos = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Combo_ID != null) select new { itemId = obj.Combo_ID, itemQuantity = obj.Combo_Quantity }; foreach (var item in combos) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Combo comb = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); it.OrderItemName = comb.Combo_Name; it.OrderQuantity = num2; it.OrderItemPrice = comb.Combo_Price; list.Add(it); } var menus = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Menu_Item_ID != null) select new { itemId = obj.Menu_Item_ID, itemQuantity = obj.Menu_Item_Quantity }; foreach (var item in menus) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Menu_Item comb = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); it.OrderItemName = comb.Menu_Item_Name; it.OrderQuantity = num2; it.OrderItemPrice = comb.Menu_Item_Price; list.Add(it); } var stocks = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Stock_ID != null) select new { itemId = obj.Stock_ID, itemQuantity = obj.Stock_Item_Quantity }; foreach (var item in stocks) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Stock_Item comb = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); it.OrderItemName = comb.Stock_Item_Name; it.OrderQuantity = num2; dynamic num3 = comb.Stock_ID; int id5 = num3; Stock_Price pric = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id5); it.OrderItemPrice = pric.Stock_Price1; list.Add(it); } var products = from obj in list select new { ItemName = obj.OrderItemName, ItemQuantity = obj.OrderQuantity, ItemPrice = obj.OrderItemPrice }; dataGridView1.DataSource = products.ToList(); list.Clear(); }
private void frmViewOrder_Load(object sender, EventArgs e) { int orderNo = Globals.Salespassing; Customer_Order ordeR = db.Customer_Order.FirstOrDefault(c => c.Order_ID == orderNo); if (ordeR != null) { txtDate.Enabled = false; txtOrderTotal.Enabled = false; txtOrdNum.Enabled = false; txtStatus.Enabled = false; txtVat.Enabled = false; rbxNotes.Enabled = false; txtDate.Text = ordeR.Order_Date.ToString(); txtOrderTotal.Text = ordeR.OrderTotal.ToString(); txtOrdNum.Text = ordeR.Order_ID.ToString(); txtStatus.Text = ordeR.Order_Status.ToString(); txtVat.Text = ordeR.Sale_Vat_Amount.ToString(); rbxNotes.Text = ordeR.OrderNotes.ToString(); var combos = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Combo_ID != null) select new { itemId = obj.Combo_ID, itemQuantity = obj.Combo_Quantity }; foreach (var item in combos) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Combo comb = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); it.OrderItemName = comb.Combo_Name; it.OrderQuantity = num2; it.OrderItemPrice = comb.Combo_Price; list.Add(it); } var menus = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Menu_Item_ID != null) select new { itemId = obj.Menu_Item_ID, itemQuantity = obj.Menu_Item_Quantity }; foreach (var item in menus) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Menu_Item comb = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); it.OrderItemName = comb.Menu_Item_Name; it.OrderQuantity = num2; it.OrderItemPrice = comb.Menu_Item_Price; list.Add(it); } var stocks = from obj in db.Customer_Order_Line where (obj.Customer_Order_ID == orderNo) && (obj.Stock_ID != null) select new { itemId = obj.Stock_ID, itemQuantity = obj.Stock_Item_Quantity }; foreach (var item in stocks) { Globals it = new Globals(); dynamic num = item.itemId; int id = num; dynamic num2 = item.itemQuantity; int quant = num2; Stock_Item comb = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); it.OrderItemName = comb.Stock_Item_Name; it.OrderQuantity = num2; dynamic num3 = comb.Stock_ID; int id5 = num3; Stock_Price pric = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == id5); it.OrderItemPrice = pric.Stock_Price1; list.Add(it); } var products = from obj in list select new { ItemName = obj.OrderItemName, ItemQuantity = obj.OrderQuantity, ItemPrice = obj.OrderItemPrice }; dgvOrders.DataSource = products.ToList(); } else { this.Close(); MessageBox.Show("No Order selected,Select order to view"); } }
void myMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e) { if (navButton == btnMenu) { if (e.ClickedItem.Name.ToString() == "Deleted") { Globals.menu.Hide(); if (dgvSupplier.Rows.Count != 0) { int id = Globals.MenuCombopassing; Menu_Item deieteItem = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); if (deieteItem != null) { db.Menu_Item.Remove(deieteItem); db.SaveChanges(); MessageBox.Show("Stock item(" + deieteItem.Menu_Item_Name + ") deleted successfully"); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } else if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.MenuCombopassing; Menu_Item item = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == id); if (item != null) { frmMaintainMenuItem form = new frmMaintainMenuItem(); form.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } //Suppliers Right Cick Event handlers if (navButton == btnEmployees) { if (e.ClickedItem.Name.ToString() == "Deleted") { Globals.menu.Hide(); if (dgvSupplier.Rows.Count != 0) { int id = Globals.Employeepassing; Employee deieteItem = db.Employees.FirstOrDefault(c => c.Employee_ID == id); if (deieteItem != null) { db.Employees.Remove(deieteItem); db.SaveChanges(); MessageBox.Show("Stock item(" + deieteItem.Employee_Name + ") deleted successfully"); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } else if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.Employeepassing; Employee item = db.Employees.FirstOrDefault(c => c.Employee_ID == id); if (item != null) { Maintain_Employee form = new Maintain_Employee(); form.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } //Suppliers Right click Handlers if (navButton == btnSuppliers11) { if (e.ClickedItem.Name.ToString() == "Deleted") { Globals.menu.Hide(); if (dgvSupplier.Rows.Count != 0) { int id = Globals.Supplierpassing; Supplier deieteItem = db.Suppliers.FirstOrDefault(c => c.Supllier_ID == id); if (deieteItem != null) { db.Suppliers.Remove(deieteItem); db.SaveChanges(); MessageBox.Show("Stock item(" + deieteItem.Supplier_Name + ") deleted successfully"); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } else if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.Supplierpassing; Supplier item = db.Suppliers.FirstOrDefault(c => c.Supllier_ID == id); if (item != null) { SupplierForm form = new SupplierForm(); form.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } if (navButton == btnCombo) { if (e.ClickedItem.Name.ToString() == "Deleted") { Globals.menu.Hide(); if (dgvSupplier.Rows.Count != 0) { int id = Globals.Combopassing; Combo deieteItem = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); if (deieteItem != null) { db.Comboes.Remove(deieteItem); db.SaveChanges(); MessageBox.Show("Stock item(" + deieteItem.Combo_Description + ") deleted successfully"); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } else if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.Combopassing; Combo item = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); if (item != null) { frmMaintainCombo form = new frmMaintainCombo(); form.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } if (navButton == btnCombo) { if (e.ClickedItem.Name.ToString() == "Deleted") { Globals.menu.Hide(); if (dgvSupplier.Rows.Count != 0) { int id = Globals.Combopassing; Combo deieteItem = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); if (deieteItem != null) { db.Comboes.Remove(deieteItem); db.SaveChanges(); MessageBox.Show("Stock item(" + deieteItem.Combo_Description + ") deleted successfully"); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } else if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.Combopassing; Combo item = db.Comboes.FirstOrDefault(c => c.Combo_ID == id); if (item != null) { frmMaintainCombo form = new frmMaintainCombo(); form.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } } //Stock Management Click Event Handlers // //-----------------------------------------------------------------------------------------------------// if (e.ClickedItem.Name.ToString() == "View") { Globals.menu.Hide(); int id = Globals.MStockpassing; Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); if (itemEdited != null) { Maintain_Stock_Item myform = new Maintain_Stock_Item(); myform.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } else if (e.ClickedItem.Name.ToString() == "Check In") { Globals.menu.Hide(); int id = Globals.MStockpassing; Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); if (itemEdited.Stock_Type_ID == 1) { if (itemEdited != null) { Check_In_Stock_Item myform = new Check_In_Stock_Item(); myform.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } else { MessageBox.Show("Action not allowed in such stock item"); } } else if (e.ClickedItem.Name.ToString() == "Check Out") { Globals.menu.Hide(); int id = Globals.MStockpassing; Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); if (itemEdited.Stock_Type_ID == 1) { if (itemEdited != null) { Check_Out_Stock_Item myform = new Check_Out_Stock_Item(); myform.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } else { MessageBox.Show("Action not allowed in such stock item"); } } else if (e.ClickedItem.Name.ToString() == "Take") { Globals.menu.Hide(); int id = Globals.MStockpassing; Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); if (itemEdited != null) { Take_Stock_Item myform = new Take_Stock_Item(); myform.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } else if (e.ClickedItem.Name.ToString() == "Write Off") { Globals.menu.Hide(); int id = Globals.MStockpassing; Stock_Item itemEdited = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == id); if (itemEdited != null) { Write_Off_stock_Item myform = new Write_Off_stock_Item(); myform.ShowDialog(); } else { MessageBox.Show("Error:Stock item does not exist/No stock item selected,select a stock item"); } } }
private void btnRetrieve_Click(object sender, EventArgs e) { string phrase = txtOrderNo.Text; double number; bool isNumeric = double.TryParse(phrase, out number); if ((phrase.Length < 9) && (isNumeric == true)) { if (Convert.ToInt32(txtOrderNo.Text) > -1) { listBox1.Items.Clear(); int orderNo = Convert.ToInt32(txtOrderNo.Text); Company_Information inf = db.Company_Information.FirstOrDefault(c => c.Company_Info_ID == 1); var combos = from obj in db.DeliveryLines where (obj.orderId == orderNo) && (obj.comboItemId != null) select new { itemId = obj.comboItemId, itemQuantity = obj.comboItemQuantity }; foreach (var item in combos) { var comboId = item.itemId; Combo comb = db.Comboes.FirstOrDefault(c => c.Combo_ID == comboId); string itemAdd = "ItemName:: " + comb.Combo_Name + " Price: " + comb.Combo_Price + " Quantity: " + Convert.ToString(item.itemQuantity); Globals.vatAmountDelivery = Globals.vatAmountDelivery + comb.Combo_Price * inf.VAT_Percentage; listBox1.Items.Add(itemAdd); } var menus = from obj in db.DeliveryLines where (obj.orderId == orderNo) && (obj.menuItemId != null) select new { itemId = obj.menuItemId, itemQuantity = obj.menuItemQuantity }; foreach (var item in menus) { var Menu_Item_ID = item.itemId; Menu_Item comb = db.Menu_Item.FirstOrDefault(c => c.Menu_Item_ID == Menu_Item_ID); string itemAdd = "ItemName:: " + comb.Menu_Item_Name + " Price:: " + comb.Menu_Item_Price + " Quantity: " + Convert.ToString(item.itemQuantity); Globals.vatAmountDelivery = Globals.vatAmountDelivery + comb.Menu_Item_Price * inf.VAT_Percentage; listBox1.Items.Add(itemAdd); } var stocks = from obj in db.DeliveryLines where (obj.orderId == orderNo) && (obj.stockItemId != null) select new { itemId = obj.stockItemId, itemQuantity = obj.stockItemQuantity }; foreach (var item in stocks) { var Stock_ID = item.itemId; Stock_Item comb = db.Stock_Item.FirstOrDefault(c => c.Stock_ID == Stock_ID); string itemAdd = "ItemName:: " + comb.Stock_Item_Name + " Price: " + comb.Stock_Price + " Quantity: " + Convert.ToString(item.itemQuantity); Stock_Price pric = db.Stock_Price.FirstOrDefault(c => c.Stock_Price_ID == Stock_ID); Globals.vatAmountDelivery = Globals.vatAmountDelivery + pric.Stock_Price1 * inf.VAT_Percentage; listBox1.Items.Add(itemAdd); } if (listBox1.Items.Count != 0) { btnPay.Visible = true; } } else { MessageBox.Show("Error: Item 'ID' can't be less than one"); } } else { MessageBox.Show("Error: Item 'ID' not numeric,please anter a numeric value(integer)"); } }