private void Button_Click(object sender, RoutedEventArgs e)
{
if (фИОTextBox.Text != "" || улицаTextBox.Text != "" || городTextBox.Text != "" || _Дом_квартираTextBox.Text != "" || номер_телефонаTextBox.Text != "")
{
WpfApp1.Food_Orders_DBDataSet food_Orders_DBDataSet = ((WpfApp1.Food_Orders_DBDataSet)(this.FindResource("food_Orders_DBDataSet")));
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetZakazchikTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
food_Orders_DBDataSetZakazchikTableAdapter.InsertZakazchik1(фИОTextBox.Text, номер_телефонаTextBox.Text, городTextBox.Text, улицаTextBox.Text, _Дом_квартираTextBox.Text);
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetNumTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
Random rnd = new Random();
int vod = rnd.Next(1, (int)food_Orders_DBDataSetNumTableAdapter.CountKurierF());
food_Orders_DBDataSetNumTableAdapter.InsertZakazy1(DateTime.Now, vod, фИОTextBox.Text, номер_телефонаTextBox.Text);
ZakazInMenu.IsEnabled = true;
фИОTextBox.IsEnabled = false;
городTextBox.IsEnabled = false;
улицаTextBox.IsEnabled = false;
_Дом_квартираTextBox.IsEnabled = false;
номер_телефонаTextBox.IsEnabled = false;
}
else
{
MessageBox.Show("Заполните все поля");
}
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetNumTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
food_Orders_DBDataSetNumTableAdapter.DeleteZakazIzMenu(фИОTextBox.Text, номер_телефонаTextBox.Text, NaimDel.Text, DateTime.Now);
NaimDel.Text = "";
KolDel.Text = "";
}
private void showIngredients()
{
DataGridCell cell = GetCell(elemFromGroupsDataGrid.SelectedIndex, 0, elemFromGroupsDataGrid);
TextBlock tb1 = cell.Content as TextBlock;
наименованиеTextBox.Text = tb1.Text;
WpfApp1.Food_Orders_DBDataSet food_Orders_DBDataSet = ((WpfApp1.Food_Orders_DBDataSet)(this.FindResource("food_Orders_DBDataSet")));
WpfApp1.Food_Orders_DBDataSetTableAdapters.IngredientsTableAdapter food_Orders_DBDataSetIngredientsTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.IngredientsTableAdapter();
System.Windows.Data.CollectionViewSource ingredientsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("ingredientsViewSource")));
food_Orders_DBDataSetIngredientsTableAdapter.GetData(tb1.Text);
food_Orders_DBDataSetIngredientsTableAdapter.Fill(food_Orders_DBDataSet.Ingredients, tb1.Text);
ingredientsViewSource.View.MoveCurrentToFirst();
//WpfApp1.Food_Orders_DBDataSet food_Orders_DBDataSet = ((WpfApp1.Food_Orders_DBDataSet)(this.FindResource("food_Orders_DBDataSet")));
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetCountTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
суммаTextBox.Text = food_Orders_DBDataSetCountTableAdapter.CountSummF(Convert.ToInt32(KolichTBX.Text), наименованиеTextBox.Text).ToString();
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
// TODO: Добавить сюда код, чтобы загрузить данные в таблицу ShowZakaz.
// Не удалось создать этот код, поскольку метод food_Orders_DBDataSetShowZakazTableAdapter.Fill отсутствует или имеет неизвестные параметры.
try{
WpfApp1.Food_Orders_DBDataSet food_Orders_DBDataSet = ((WpfApp1.Food_Orders_DBDataSet)(this.FindResource("food_Orders_DBDataSet")));
WpfApp1.Food_Orders_DBDataSetTableAdapters.ShowZakazTableAdapter food_Orders_DBDataSetShowZakazTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.ShowZakazTableAdapter();
System.Windows.Data.CollectionViewSource showZakazViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("showZakazViewSource")));
showZakazViewSource.View.MoveCurrentToFirst();
food_Orders_DBDataSetShowZakazTableAdapter.GetData(фИОTextBox.Text, номер_телефонаTextBox.Text);
food_Orders_DBDataSetShowZakazTableAdapter.Fill(food_Orders_DBDataSet.ShowZakaz, фИОTextBox.Text, номер_телефонаTextBox.Text);
showZakazViewSource.View.MoveCurrentToFirst();
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetNumTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
ResSummTBX.Text = food_Orders_DBDataSetNumTableAdapter.CommPrice(фИОTextBox.Text, номер_телефонаTextBox.Text).ToString();
food_Orders_DBDataSetNumTableAdapter.UpdateForSumm1(фИОTextBox.Text, номер_телефонаTextBox.Text);
}
catch (Exception)
{
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter food_Orders_DBDataSetNumTableAdapter = new WpfApp1.Food_Orders_DBDataSetTableAdapters.QueriesTableAdapter();
food_Orders_DBDataSetNumTableAdapter.ZakazIzMenu(фИОTextBox.Text, номер_телефонаTextBox.Text, наименованиеTextBox.Text, Convert.ToInt32(KolichTBX.Text), DateTime.Now);
ZakazInMenu.IsEnabled = true;
}
