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();
}
