private void AddBIO_Click(object sender, RoutedEventArgs e) { Entities.OrderInTime order = new Entities.OrderInTime(); order.WaiterID = waiterid; order.TableID = 1; order = Requests.MethodsWaiter.InsertOrderInTime(context, order); //Context contextnew = new Context(); Entities.BludoInOrder bio = new Entities.BludoInOrder(); try { bio.BludoAmount = int.Parse(AmountB.Text); bio.BludoStatus = (Status.SelectedItem).ToString(); bio.OrderID = order.OrderID; var bludo = Requests.MethodsOrder.GetBludoByName(context, (ChooseB.SelectedItem).ToString()); bio.BludoID = bludo.BludoID; bio.OrderTime = DateTime.Now; } catch (Exception ex) { MessageBox.Show("Проверьте правильность ввода данных."); } Requests.MethodsWaiter.InsertBludoInOrder(context, bio); ChooseB.SelectedItem = null; Status.SelectedItem = null; AmountB.Text = ""; (App.Current.Windows[1]).IsEnabled = true; }
private void AddBIO_Click(object sender, RoutedEventArgs e) { Entities.OrderInTime order = new Entities.OrderInTime(); order.WaiterID = waiterid; order.TableID = 1; order = Requests.MethodsWaiter.InsertOrderInTime(context, order); //Context contextnew = new Context(); Entities.BludoInOrder bio = new Entities.BludoInOrder(); try { bio.BludoAmount = int.Parse(AmountB.Text); bio.BludoStatus = (Status.SelectedItem).ToString(); bio.OrderID = order.OrderID; var bludo = Requests.MethodsOrder.GetBludoByName(context, (ChooseB.SelectedItem).ToString()); bio.BludoID = bludo.BludoID; bio.OrderTime = DateTime.Now; } catch (Exception ex) { MessageBox.Show("Проверьте правильность ввода данных."); } Requests.MethodsWaiter.InsertBludoInOrder(context, bio); ChooseB.SelectedItem = null; Status.SelectedItem = null; AmountB.Text = ""; (App.Current.Windows[1]).IsEnabled=true; }
public List<Entities.OrderInTime> GetAllOrdersInTime() { List<Entities.OrderInTime> listOrdersIT = new List<Entities.OrderInTime>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var ordersIT = from r in entities.OrderInTime select r; foreach (OrderInTime singleOrderIT in ordersIT) { Entities.OrderInTime ot= new Entities.OrderInTime(); ot.OrderID = singleOrderIT.id; ot.TableID = int.Parse(singleOrderIT.id_Table.ToString()); ot.WaiterID = int.Parse(singleOrderIT.id_Waiter.ToString()); listOrdersIT.Add(ot); } } return listOrdersIT; }
public List <Entities.OrderInTime> GetAllOrdersInTime() { List <Entities.OrderInTime> listOrdersIT = new List <Entities.OrderInTime>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var ordersIT = from r in entities.OrderInTime select r; foreach (OrderInTime singleOrderIT in ordersIT) { Entities.OrderInTime ot = new Entities.OrderInTime(); ot.OrderID = singleOrderIT.id; ot.TableID = int.Parse(singleOrderIT.id_Table.ToString()); ot.WaiterID = int.Parse(singleOrderIT.id_Waiter.ToString()); listOrdersIT.Add(ot); } } return(listOrdersIT); }