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