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