private void ErrorTableUpdate()
{
var list = CheckTable.GetNotMatchTableData();
foreach (string data in list)
{
WriteAnalizeTextBox($"{data} Table Can`t find");
}
}
private bool TableStructCheck()
{
List <string> list = CheckTable.CheckTablesStruct();
if (list.Count <= 0)
{
WriteAnalizeTextBox($"All Table Struct Matched");
return(true);
}
else
{
ErrorTableStructUpdate(list);
return(false);
}
}
private bool TableNameCheck()
{
bool isMatchTableNames = CheckTable.IsMatchTableData();
if (isMatchTableNames == true)
{
WriteAnalizeTextBox("Tables Name All Matched Data");
}
else
{
WriteAnalizeTextBox("Tables Name Not Matched");
ErrorTableUpdate();
return(false);
}
return(true);
}
//check update
private void updateCheckBtn_Click(object sender, RoutedEventArgs e)
{
CheckTable item = (checksGrid.SelectedItem as CheckTable);
checks item1 = _db.checks.First(c => c.id == item.id);
item1.count = item.count;
menu item4 = _db.menu.First(c => c.id == item1.menu_id);
item4.price = item.price;
item4.size = item.size;
item4.unit_of_measurement_id = _db.units_of_measurement.First(c => c.name == item.unit_measurement).id;
item4.dish_name = item.dishname;
orders item2 = _db.orders.First(c => c.id == item1.order_id);
item2.waiter_id = _db.waiters.First(c => c.name == item.waiter_name).id;
item2.table_id = _db.platens.First(c => c.number == item.id_table).id;
_db.SaveChanges();
checksGrid.ItemsSource = GetCheck();
MessageBox.Show("Зміни успішно збережено");
}
