private void btnDeleteSelectItem_Click(object sender, EventArgs e) { if (fpnlCatTable.Controls.Count == 0) { f = false; return; } ApplicationDbContext context = new ApplicationDbContext(); ByTables b = c.ByTables.FirstOrDefault(x => x.ID == table.ID); foreach (DataGridViewRow row in this.dataTableOrderView.SelectedRows) { int i = int.Parse(row.Cells[0].Value.ToString()); olst.Remove(table.Orderlsts.SingleOrDefault(a => a.ID == i)); // var del = context.orderlst.SingleOrDefault(a=>a.ID==i ); // context.orderlst.Remove(del); } if (dataTableOrderView.Rows.Count == 0) { b.check = 0; } else { b.check = 1; } b.Orderlsts.Clear(); b.Orderlsts = olst; foreach (var item in b.Orderlsts.ToList()) { item.ByTables = null; } c.SaveChanges(); RefreshdataOrderView(); }
public TableOrder(int tableNUMber) { InitializeComponent(); getallTableItem(); table = c.ByTables.FirstOrDefault(x => x.TableID == tableNUMber); if ((c.orderlst.Where(e => e.TableID == table.TableID).ToList() != null) && f) { olst = table.Orderlsts.ToList(); RefreshdataOrderView(); } }
private void btnPrintMTB5_Click(object sender, EventArgs e) { if (dataTableOrderView.Rows.Count == 0) { MessageBox.Show(" لا يوجد اصناف لطباعة الاوردر", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ByTables b = c.ByTables.FirstOrDefault(x => x.TableID == table.ID); b.check = 1; b.Orderlsts = olst; olst = null; c.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); }
private void btnFinalPrint_Click(object sender, EventArgs e) { //ByTables b = c.ByTables.FirstOrDefault(x => x.TableID == table.ID); //b.ID = table.ID; //b.TableID = table.TableID; // b.OrderItems = null; //Adding to Database var x = table.Orderlsts; if (x == null || x.Count() == 0) { MessageBox.Show(" لا يوجد اصناف لطباعة الاوردر", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } ByTables db = c.ByTables.FirstOrDefault(h => h.TableID == table.TableID); db.check = 0; check = 0; table.Orderlsts = null; var xx = order.OrderItems; var del = (from o in c.orderlst where o.TableID == table.ID select o).ToList(); foreach (var item in del) { c.orderlst.Remove(item); } c.SaveChanges(); order.OrderItems = null; order.DateTime = DateTime.Now; order.Ordertype = "TABLES"; c.Orders.Add(order); c.SaveChanges(); #region add to DB from OrderItems list foreach (var item in x) { c.OrderItems.Add(new OrderItems() { OrderID = order.OrderID, ItemID = (int)item.ItemID, Quantity = (int)item.Quantity, Size = item.Size, TPrice_for_Item = (decimal)item.TPrice_for_Item, Price_Item = (decimal)item.Price_Item, DateTime = (DateTime)item.DateTime //AddeddateTimePicker.Value }); } #endregion c.SaveChanges(); order = new GetOrder(); table = new ByTables(); RefreshdataOrderView(); this.DialogResult = DialogResult.OK; this.Close(); }