/// <summary>
/// Módosítás gomb eseménye
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void metroButtonOrderModify_Click(object sender, EventArgs e)
{
try
{
Order updateOrderData = new Order(Convert.ToInt32(metroTextBoxID.Text), metroTextBoxCustomerName.Text, metroTextBoxProductName.Text, metroTextBoxProductQuantity.Text, metroTextBoxProductPrice.Text);
int OrderId = Convert.ToInt32(metroTextBoxID.Text);
try
{
repo.updateOrderInList(OrderId, updateOrderData);
}
catch (Exception ex)
{
return;
}
RepositoryDatabaseTableOrder rdto = new RepositoryDatabaseTableOrder();
try
{
rdto.updateOrderInDatabase(OrderId, updateOrderData);
}
catch (Exception ex)
{
}
updateDataToDataGridView();
if (dataGridViewOrders.SelectedRows.Count == 1)
{
setOrderDataGridViewt();
}
}
catch (ModelOrderNotValidCustomerNameException moe)
{
}
catch (ModelOrderNotValidProductNameException mope)
{
}
catch (ModelOrderNotValidProductQuantityException mopqe)
{
}
catch (ModelOrderNotValidProductPriceException mope)
{
}
catch (RepositoryExceptionCantModified rem)
{
Debug.WriteLine("A módosítás nem sikerült, a rendelés nincs a listában!");
}
catch (Exception ex)
{
}
}
//Törlés gomb
private void metroButtonOrderDelete_Click(object sender, EventArgs e)
{
if ((dataGridViewOrders.Rows == null) ||
(dataGridViewOrders.Rows.Count == 0))
{
return;
}
//A felhasználó által kiválasztott sor a DataGridView-ban
int sor = dataGridViewOrders.SelectedRows[0].Index;
if (MessageBox.Show(
"Valóban törölni akarja a sort?",
"Törlés",
MessageBoxButtons.YesNo,
MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
//1. törölni kell a listából
int id = -1;
if (!int.TryParse(
dataGridViewOrders.SelectedRows[0].Cells[0].Value.ToString(),
out id))
{
return;
}
try
{
repo.deleteOrderFromList(id);
}
catch (RepositoryExceptionCantDelete recd)
{
kiirHibauzenetet(recd.Message);
Debug.WriteLine("A rendelés törlés nem sikerült, nincs a listába!");
}
//2. törölni kell az adatbázisból
RepositoryDatabaseTableOrder rdto = new RepositoryDatabaseTableOrder();
try
{
rdto.deleteOrderFromDatabase(id);
}
catch (Exception ex)
{
kiirHibauzenetet(ex.Message);
}
//3. frissíteni kell a DataGridView-t
updateDataToDataGridView();
if (dataGridViewOrders.SelectedRows.Count <= 0)
{
}
setOrderDataGridViewt();
}
}
private void betoltAdatbazisbolAdatokat()
{
//Adatbázisban pizza tábla kezelése
RepositoryDatabaseTablePizza rtp = new RepositoryDatabaseTablePizza();
RepositoryDatabaseTableCustomer rtc = new RepositoryDatabaseTableCustomer();
RepositoryDatabaseTableCourier rtcu = new RepositoryDatabaseTableCourier();
RepositoryDatabaseTableItem rti = new RepositoryDatabaseTableItem();
RepositoryDatabaseTableOrder rto = new RepositoryDatabaseTableOrder();
//A repo-ba lévő pizza listát feltölti az adatbázisból
repo.setPizzas(rtp.getPizzasFromDatabaseTable());
repo.setCustomer(rtc.getVevoFromDatabasePvevoTable());
repo.setCourier(rtcu.getFutarFromDatabaseTable());
repo.setItem(rti.getItemFromDatabaseTable());
repo.setOrder(rto.getOrderFromDatabaseTable());
}
private void metroButtonOrderAdd_Click(object sender, EventArgs e)
{
AddOrder ao = new AddOrder();
ao.Show();
newOrderDataInsert = true;
int newOrderID = repo.getNextOrderId();
metroTextBoxID.Text = newOrderID.ToString();
try
{
Order newOrder = new Order(Convert.ToInt32(metroTextBoxID.Text), metroTextBoxCustomerName.Text, metroTextBoxProductName.Text, metroTextBoxProductQuantity.Text, metroTextBoxProductPrice.Text);
int OrderId = Convert.ToInt32(metroTextBoxID.Text);
//Listához hozzáadás
try
{
repo.addOrderToList(newOrder);
}
catch (Exception ex)
{
return;
}
//Hozzáadni az adatbázishoz az adatokat
RepositoryDatabaseTableOrder rdto = new RepositoryDatabaseTableOrder();
try
{
rdto.insertOrderToDatabase(newOrder);
}
catch (Exception ex)
{
}
updateDataToDataGridView();
if (dataGridViewOrders.SelectedRows.Count == 1)
{
setOrderDataGridViewt();
}
}
catch (ModelOrderNotValidCustomerNameException moe)
{
}
catch (ModelOrderNotValidProductNameException mope)
{
}
catch (ModelOrderNotValidProductQuantityException mopqe)
{
}
catch (ModelOrderNotValidProductPriceException mope)
{
}
catch (Exception ex)
{
}
}
