//Zmienna do blokowania wrzucania starego zamowienia do bazy public OrderInput(ContentControl contentControl) { _contentControl = contentControl; _order = new Order(); InitializeComponent(); _isOrderBeingRead = false; ClientNumberTextBox.Provider = new SuggestionProvider( x => Data.PhoneNumbers.Where(stringToCheck => stringToCheck.ToString().Contains(x))); StreetTextBox.Provider = new SuggestionProvider( x => Data.StreetList.Where(stringToCheck => stringToCheck.ToString().ToLower().Contains(x.ToLower()))); foreach (var pizza in Data.PizzasPrizeDictionary.Keys) AllPizzasList.Items.Add(pizza); foreach (var topping in Data.ToppingsDictionary.Values) AllToppingsList.Items.Add(topping); foreach (var topping in Data.SizePrizeDictionary.Keys) AllSizeList.Items.Add(topping); foreach (var topping in Data.DoughsDictionary.Values) AllDoughsList.Items.Add(topping); }
public static Order GetOrderFromDatabase(int index) { Order order = new Order(); DataSet pizzas = CustomCommend( "Select Orders.id,Id_Pizzy,fk_id_pizzy,fk_id_dough,fk_id_size from Orders join pizzavariant on Orders.id_pizzy = Pizzavariant.Id where Orders.id = " + (index)); DataSet client = CustomCommend("Select * from AllOrders where AllOrders.id = " + (index)); DataSet extratoppings = CustomCommend( "Select Orders.id, ExtraToppings.ID, ExtraToppings.FK_ID_TOPPING from Orders join extratoppings on Orders.id_pizzy = ExtraToppings.Id where Orders.id =" + (index)); DataSet deletedtoppings = CustomCommend( "Select Orders.id, MissingToppings.ID, MissingToppings.FK_ID_TOPPING from Orders join MissingToppings on Orders.id_pizzy = MissingToppings.Id where Orders.id =" + (index)); //Dodanie pizz do zamowienia korzystajac z mighty LINQ pizzas.Tables[0].AsEnumerable() .ToList() .ForEach(x => order.AddPizza(Data.PizzasDictionary2[x.Field<long>(2)], x.Field<long>(1), Data.SizeDictionary2[x.Field<long>(4)], Data.DoughsDictionary[x.Field<long>(3)])); //Uzupelnienie dodatkowych skladnikow w pizzach if (extratoppings.Tables[0].Rows.Count != 0) extratoppings.Tables[0].AsEnumerable() .ToList() .ForEach( x => order.OrderedPizzas.Where(y => y.Id.Equals(x.Field<long>(1))) .ToList() .ForEach(z => z.AddTopping(Data.ToppingsDictionary[x.Field<long>(2)]))); //Uzupelnienie usunietych skladnikow w pizzach if (deletedtoppings.Tables[0].Rows.Count != 0) deletedtoppings.Tables[0].AsEnumerable() .ToList() .ForEach( tableData => order.OrderedPizzas.Where(pizza => pizza.Id.Equals(tableData.Field<long>(1))) .ToList() .ForEach(pizza => pizza.RemoveTopping(Data.ToppingsDictionary[tableData.Field<long>(2)]))); //Dodanie klienta client.Tables[0].AsEnumerable() .ToList() .ForEach( x => order.Client = new Client(x.Field<long>(1), x.Field<string>(2), x.Field<string>(3), x.Field<string>(4), x.Field<string>(5))); order.Prize = Convert.ToDouble(client.Tables[0].Rows[0][6].ToString().Replace(".",",")); return order; }
public OrdersOverview(ContentControl contentControl) { _contentControl = contentControl; _order = new Order(); InitializeComponent(); DataGrid.ItemsSource = SqLiteClient.SelectFrom("*","ALLORDERS").Tables[0].DefaultView; DataGrid.CanUserSortColumns = false; DataGrid.CanUserAddRows = false; }
public OrderInput(Order order) { _order = order; InitializeComponent(); _isOrderBeingRead = true; ClientNumberTextBox.Provider = new SuggestionProvider( x => Data.PhoneNumbers.Where(stringToCheck => stringToCheck.ToString().Contains(x))); StreetTextBox.Provider = new SuggestionProvider( x => Data.StreetList.Where(stringToCheck => stringToCheck.ToString().ToLower().Contains(x.ToLower()))); foreach (var pizza in Data.PizzasPrizeDictionary.Keys) AllPizzasList.Items.Add(pizza); foreach (var topping in Data.ToppingsDictionary.Values) AllToppingsList.Items.Add(topping); foreach (var topping in Data.SizePrizeDictionary.Keys) AllSizeList.Items.Add(topping); foreach (var topping in Data.DoughsDictionary.Values) AllDoughsList.Items.Add(topping); //Wypelnienie danymi z zamowienia ClientNumberTextBox.Text = _order.Client.PhoneNumber.ToString(); ClientNameTextBox.Text = _order.Client.Name; StreetTextBox.Text = _order.Client.Adress; HomeNumberTextBox.Text = _order.Client.ApartamentNumber; ApartamentNumberTextBox.Text = _order.Client.HomeNumber; foreach (var pizza in _order.OrderedPizzas) { OrderedPizzasList.Items.Add(pizza.PizzaDescription()); } OrderValueTextBox.Text = _order.Prize.ToString(CultureInfo.CurrentCulture); }
private void DataGridClicked(object sender, System.Windows.Input.MouseButtonEventArgs e) { _order = SqLiteClient.GetOrderFromDatabase(GetIdValue()); _contentControl.Content = new OrderInput(_order); }