public void RegisterPendingOrdr(Busy_tables _Tables, List <Pending_Orders> _Orders) { using (var en = new DB_SystemFoodTrucksEntities()) { using (DbContextTransaction transaction = en.Database.BeginTransaction()) { try { en.Busy_tables.Add(_Tables); en.SaveChanges(); foreach (Pending_Orders itemOrder in _Orders) { en.Pending_Orders.Add(itemOrder); } en.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); } } } }
private void BtnInic_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { try { bool isBusyTable; MessageBoxResult boxResult; string ordenStr = SendToProduction(); int tableid = Convert.ToInt32(CboListBox.SelectedValue.ToString()); var itemProduct = new List <Pending_Orders>(); itemProduct = SaveOrdrTemp(); var setIdTable = new Busy_tables { Table_busy = tableid }; isBusyTable = OrderBL.GetInstance().VerifyTable(setIdTable); if (isBusyTable) { boxResult = MessageBoxRM.Show("Esta mesa está ocupada, desea agregar otro producto a esta mesa?", "Mesa ocupada", MessageBoxButtonRM.YesNo, MessageBoxIconRM.Question); if (boxResult == MessageBoxResult.OK) { OrderBL.GetInstance().RegisterPendingOrdr2(itemProduct); var card = new CardItemOrd(); card.Nombre = $"Mesa #{tableid}"; card.Orden = ordenStr; GetOrdens = card; sendOrder = true; if (NtfIcon.Visibility == Visibility.Hidden) { NtfIcon.Visibility = Visibility.Visible; } NtfIcon.Badge = OrderBL.GetInstance().NofPOrder(); DtGridOrden.Items.Clear(); CalculateTotal(); } } else { OrderBL.GetInstance().RegisterPendingOrdr(setIdTable, itemProduct); //MessageBoxRM.Show(ordenStr); var card = new CardItemOrd(); card.Nombre = $"Mesa #{tableid}"; card.Orden = ordenStr; GetOrdens = card; sendOrder = true; if (NtfIcon.Visibility == Visibility.Hidden) { NtfIcon.Visibility = Visibility.Visible; } NtfIcon.Badge = OrderBL.GetInstance().NofPOrder(); DtGridOrden.Items.Clear(); CalculateTotal(); } } catch (Exception ex) { MessageBoxRM.Show(ex.Message, "Error al iniciar orden", MessageBoxButtonRM.OK, MessageBoxIconRM.Error); } }
public bool VerifyTable(Busy_tables tables) { bool isBusy = false; using (var en = new DB_SystemFoodTrucksEntities()) { var query = en.Busy_tables.FirstOrDefault(t => t.Table_busy == tables.Table_busy); if (query != null) { isBusy = true; } return(isBusy); } }