private void FillAccounts() { try { database = new ShopContext(); var data1 = database.Account; dataGridView4.Rows.Clear(); foreach (var acc in data1) { dataGridView4.Rows.Add(acc.Id, acc.NazwaUzytkownika, acc.Haslo, acc.Uprawnienia); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView4.Sort(dataGridView4.Columns[1], ListSortDirection.Ascending); if (dataGridView4.RowCount > 0) { dataGridView4.Rows[0].Selected = true; } }
private void button1_Click(object sender, EventArgs e) { try { database = new ShopContext(); if (InsertNewCategory(textBox1.Text)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z dodawaniem kategorii"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void FillCategory() { try { database = new ShopContext(); var data1 = database.Category; dataGridView2.Rows.Clear(); dataGridView2.Rows.Add(0, "<wszystko>"); foreach (var cat in data1) { dataGridView2.Rows.Add(cat.Id, cat.Nazwa); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView2.Sort(dataGridView2.Columns[1], ListSortDirection.Ascending); if (dataGridView2.RowCount > 0) { dataGridView2.Rows[0].Selected = true; } }
private void FillDeliveries() { try { database = new ShopContext(); var data1 = database.Delivery.Join(database.Provider, del => del.DostawcaId, prov => prov.Id, (del, prov) => new { Id = del.Id, Dostawca = prov.Nazwa, Data = del.Data, DostawcaId = del.DostawcaId }); dataGridView7.Rows.Clear(); foreach (var del in data1) { dataGridView7.Rows.Add(del.Id, del.Dostawca, del.Data, del.DostawcaId); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView7.Sort(dataGridView7.Columns[2], ListSortDirection.Descending); if (dataGridView7.RowCount > 0) { dataGridView7.Rows[0].Selected = true; } }
private void FillDeliveryDetails(int _dostawaId) { try { database = new ShopContext(); var data1 = database.Product.Join(database.DeliveryDetail.Where(x => x.DostawaId == _dostawaId), pro => pro.Id, del => del.ProduktId, (pro, del) => new { Id = del.Id, Nazwa = pro.Nazwa, Netto = del.Netto, Vat = del.Vat, Sztuk = del.Sztuk, DostawaId = del.DostawaId, ProduktId = del.ProduktId }); dataGridView8.Rows.Clear(); foreach (var prod in data1) { dataGridView8.Rows.Add(prod.Id, prod.Nazwa, prod.Netto, prod.Vat, prod.Sztuk, prod.DostawaId, prod.ProduktId); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView8.Sort(dataGridView8.Columns[1], ListSortDirection.Ascending); if (dataGridView8.RowCount > 0) { dataGridView8.Rows[0].Selected = true; } }
private void FillCustomers() { try { database = new ShopContext(); var data1 = database.Customer.Join(database.Account, cus => cus.KontoId, acc => acc.Id, (cus, acc) => new { Id = cus.KontoId, Imie = cus.Imie, Nazwisko = cus.Nazwisko, Ulica = cus.Ulica, NrDomu = cus.NrDomu, Miasto = cus.Miasto, KodPocztowy = cus.KodPocztowy, Mail = cus.Mail, Telefon = cus.Telefon, Fax = cus.Fax, Login = acc.NazwaUzytkownika }); dataGridView6.Rows.Clear(); foreach (var cus in data1) { dataGridView6.Rows.Add(cus.Id, cus.Login, cus.Imie, cus.Nazwisko, cus.Ulica, cus.NrDomu, cus.Miasto, cus.KodPocztowy, cus.Mail, cus.Telefon, cus.Fax); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView6.Sort(dataGridView6.Columns[3], ListSortDirection.Ascending); if (dataGridView6.RowCount > 0) { dataGridView6.Rows[0].Selected = true; } }
private void FillProviders() { try { database = new ShopContext(); var data1 = database.Provider; dataGridView5.Rows.Clear(); foreach (var prov in data1) { dataGridView5.Rows.Add(prov.Id, prov.Nazwa, prov.Adres); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView5.Sort(dataGridView5.Columns[1], ListSortDirection.Ascending); if (dataGridView5.RowCount > 0) { dataGridView5.Rows[0].Selected = true; } }
private void FillProducts() { try { database = new ShopContext(); var data1 = database.Product. Join( database.Store, prodI => prodI.Id, strId => strId.ProduktId, (prodI, strId) => new { Id = prodI.Id, Nazwa = prodI.Nazwa, Ilosc = strId.IloscDostepnych }); dataGridView1.Rows.Clear(); foreach (var prod in data1) { dataGridView1.Rows.Add(prod.Id, prod.Nazwa, prod.Ilosc); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView1.Sort(dataGridView1.Columns[0], ListSortDirection.Ascending); if (dataGridView1.RowCount > 0) { dataGridView1.Rows[0].Selected = true; } }
private void FillCustomers() { try { database = new ShopContext(); var data1 = database.Customer; dataGridView2.Rows.Clear(); foreach (var cus in data1) { dataGridView2.Rows.Add(cus.KontoId, cus.Imie + " " + cus.Nazwisko, cus.Ulica, cus.KodPocztowy, cus.Miasto); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView2.Sort(dataGridView2.Columns[1], ListSortDirection.Ascending); if (dataGridView2.RowCount > 0) { dataGridView2.Rows[0].Selected = true; } }
private void button1_Click(object sender, EventArgs e) { try { database = new ShopContext(); if (EditCust((int)row.Cells[0].Value, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z edytowaniem kategorii"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int priv; try { priv = Convert.ToInt32(textBox2.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox2.Text + " nie jest poprawną liczbą z zakresu 0 do 3"); return; } if (priv > 3 || priv < 0) { MessageBox.Show(textBox2.Text + " nie jest liczbą z zakresu 0 do 3"); return; } try { database = new ShopContext(); if (!maskedTextBox1.Text.Equals(maskedTextBox2.Text)) { MessageBox.Show("Hasło niepoprawnie powtórzone"); return; } if (InsertNewAccount(textBox1.Text, maskedTextBox1.Text, priv)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z dodawaniem konta"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void FillProductCat(int idCat) { try { database = new ShopContext(); var data1 = database.Product.Join(database.Price.Where(x => x.Do == null), pro => pro.Id, pri => pri.ProduktId, (pro, pri) => new { Id = pro.Id, IdKategorii = pro.KategoriaId, Product = pro.Nazwa, Price = pri.Cena }) .Join(database.Category.Where(x => x.Id == idCat), pro => pro.IdKategorii, cat => cat.Id, (pro, cat) => new { Id = pro.Id, Product = pro.Product, Kategoria = cat.Nazwa, Price = pro.Price }) .Join(database.Vat.Where(z => z.Do == null), pro => pro.Id, v => v.ProduktId, (pro, v) => new { Id = pro.Id, Product = pro.Product, Kategoria = pro.Kategoria, Price = pro.Price, Vat = v.WartoscVat }) .Join(database.Store, pro => pro.Id, s => s.ProduktId, (pro, s) => new { Id = pro.Id, Product = pro.Product, Kategoria = pro.Kategoria, Price = pro.Price, Vat = pro.Vat, Dostępnych = s.IloscDostepnych, Zamówionych = s.IloscZamowionych }); dataGridView1.Rows.Clear(); foreach (var prod in data1) { dataGridView1.Rows.Add(prod.Id, prod.Product, prod.Kategoria, prod.Price, prod.Vat, prod.Dostępnych, prod.Zamówionych); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending); if (dataGridView1.RowCount > 0) { dataGridView1.Rows[0].Selected = true; } }
public bool DeleteProduct(int _Id) { try { database = new ShopContext(); var pro = database.Product.First(x => x.Id == _Id); database.Product.Remove(pro); database.SaveChanges(); return(true); } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); return(false); } finally { database.Dispose(); } }
public bool DeleteDetail(int _id) { try { database = new ShopContext(); var detail = database.DeliveryDetail.First(x => x.Id == _id); database.DeliveryDetail.Remove(detail); database.SaveChanges(); return(true); } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); return(false); } finally { database.Dispose(); } }
public bool DeleteOrder(int _id) { try { database = new ShopContext(); var ord = database.Order.First(x => x.ZamowienieId == _id); database.Order.Remove(ord); database.SaveChanges(); return(true); } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); return(false); } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int prov; try { prov = (int)dataGridView5.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawny dostawca"); return; } try { database = new ShopContext(); if (EditDelivery((int)row.Cells[0].Value, prov)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z dodawaniem dostawy"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void FillCategories() { try { database = new ShopContext(); var data1 = database.Category; dataGridView1.Rows.Clear(); foreach (var cat in data1) { dataGridView1.Rows.Add(cat.Id, cat.Nazwa); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int _id = Convert.ToInt32(textBox1.Text); try { database = new ShopContext(); Account acc = database.Account.First(x => x.Id == _id); // Customer cust = database.Customer.First(x => x.KontoId == _id); if (acc != null) //&& cust == null) { if (InsertNewCustomer(_id, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z dodawaniem konta"); } } else { MessageBox.Show("Podaj poprawne ID użytkownika"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void FillOrders() { try { database = new ShopContext(); var data1 = database.Order.Join(database.OrderDetail, ord => ord.ZamowienieId, det => det.ZamowienieId, (ord, det) => new { Id = ord.ZamowienieId, DataZamowienia = ord.DataZamowienia, DataZrealizowania = ord.DataZrealizowania, KlientId = ord.KlientId, ProduktId = det.ProduktId, Ilosc = det.Ilosc, MiastoDostawy = det.MiastoDostawy, KodPocztowyDostawy = det.KodPocztowyDostawy, AdresDostawy = det.AdresDostawy }) .Join(database.Customer, ord => ord.KlientId, cus => cus.KontoId, (ord, cus) => new { Id = ord.Id, DataZamowienia = ord.DataZamowienia, DataZrealizowania = ord.DataZrealizowania, KlientId = ord.KlientId, ProduktId = ord.ProduktId, Ilosc = ord.Ilosc, MiastoDostawy = ord.MiastoDostawy, KodPocztowyDostawy = ord.KodPocztowyDostawy, AdresDostawy = ord.AdresDostawy, Imie = cus.Imie, Nazwisko = cus.Nazwisko }) .Join(database.Product, ord => ord.ProduktId, pro => pro.Id, (ord, pro) => new { Id = ord.Id, DataZamowienia = ord.DataZamowienia, DataZrealizowania = ord.DataZrealizowania, KlientId = ord.KlientId, ProduktId = ord.ProduktId, Ilosc = ord.Ilosc, MiastoDostawy = ord.MiastoDostawy, KodPocztowyDostawy = ord.KodPocztowyDostawy, AdresDostawy = ord.AdresDostawy, Imie = ord.Imie, Nazwisko = ord.Nazwisko, NazwaProduktu = pro.Nazwa }); dataGridView3.Rows.Clear(); foreach (var ord in data1) { dataGridView3.Rows.Add(ord.Id, ord.NazwaProduktu, ord.Ilosc, ord.DataZamowienia, ord.DataZrealizowania, ord.Imie + " " + ord.Nazwisko, ord.AdresDostawy + ", " + ord.KodPocztowyDostawy + " " + ord.MiastoDostawy, ord.ProduktId, ord.KlientId, ord.MiastoDostawy, ord.AdresDostawy, ord.KodPocztowyDostawy); } } catch (Exception e) { System.Diagnostics.EventLog.WriteEntry(e.Source, e.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd uzyskiwania danych z bazy"); } finally { database.Dispose(); } dataGridView3.Sort(dataGridView3.Columns[0], ListSortDirection.Descending); if (dataGridView3.RowCount > 0) { dataGridView3.Rows[0].Selected = true; } }
private void button1_Click(object sender, EventArgs e) { int cat; double price; int vat; int availble; try { cat = (int)dataGridView1.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawna kategoria"); return; } try { price = Convert.ToDouble(textBox2.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox2.Text + " nie jest poprawną ceną"); return; } try { vat = Convert.ToInt32(textBox3.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox3.Text + " nie jest poprawną stawką vat"); return; } try { availble = Convert.ToInt32(textBox4.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox4.Text + " nie jest poprawną liczbą"); return; } if (availble < (int)row.Cells[6].Value) { MessageBox.Show(textBox4.Text + " to mniej niż w tym momencie jest zamówionych"); return; } try { database = new ShopContext(); if ( EditProduct((int)row.Cells[0].Value, cat, textBox1.Text) && EditPrice((int)row.Cells[8].Value, (int)row.Cells[0].Value, DateTime.Now, price) && EditVat((int)row.Cells[9].Value, (int)row.Cells[0].Value, DateTime.Now, vat) && EditAvail((int)row.Cells[0].Value, availble)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z edytowaniem produktu"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int cat; double price; int vat; int availble; try { cat = (int)dataGridView1.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawna kategoria"); return; } try { price = Convert.ToDouble(textBox2.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox2.Text + " nie jest poprawną ceną"); return; } try { vat = Convert.ToInt32(textBox3.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox3.Text + " nie jest poprawną stawką vat"); return; } try { availble = Convert.ToInt32(textBox4.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox4.Text + " nie jest poprawną liczbą"); return; } if (availble < 0) { MessageBox.Show(textBox4.Text + " nie jest poprawną wartością"); return; } if (price < 0) { MessageBox.Show("Cena powinna być dodatnia"); return; } try { database = new ShopContext(); int productId = InsertNewProduct(textBox1.Text, cat); if (productId > 0 && InsertNewPrice(productId, DateTime.Now, price) && InsertNewVat(productId, DateTime.Now, vat) && InsertNewStore(productId, availble, 0)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z dodawaniem produktu"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int prodId; int custId; int count; try { prodId = (int)dataGridView1.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawny produkt"); return; } try { custId = (int)dataGridView2.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawny klient"); return; } try { count = Convert.ToInt32(textBox1.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox1.Text + " nie jest poprawną liczbą"); return; } if (count < 0) { MessageBox.Show(textBox1.Text + " nie jest poprawną wartością"); return; } try { database = new ShopContext(); int ordId = InsertNewOrder(DateTime.Now, custId); if ((ordId > 0) && (InsertNewOrderDetail(ordId, prodId, count, textBox4.Text, textBox2.Text, textBox3.Text) == true)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); Store pr = database.Store.First(x => x.ProduktId == prodId); pr.IloscDostepnych -= count; pr.IloscZamowionych += count; database.SaveChanges(); } else { MessageBox.Show("Wystąpił problem z dodawaniem produktu\n" + custId + "\n" + ordId + "\n " + prodId + "\n " + count + "\n " + textBox4.Text + "\n " + textBox2.Text + "\n " + textBox3.Text); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }
private void button1_Click(object sender, EventArgs e) { int prodId; double price; int vat; int count; try { prodId = (int)dataGridView1.SelectedCells[0].Value; } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Niepoprawny produkt"); return; } try { price = Convert.ToDouble(textBox1.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox1.Text + " nie jest poprawną ceną"); return; } try { vat = Convert.ToInt32(textBox2.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox2.Text + " nie jest poprawną stawką vat"); return; } try { count = Convert.ToInt32(textBox3.Text); } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show(textBox3.Text + " nie jest poprawną liczbą"); return; } if (count < 0) { MessageBox.Show(textBox3.Text + " nie jest poprawną wartością"); return; } if (price < 0) { MessageBox.Show("Cena powinna być dodatnia"); return; } try { database = new ShopContext(); if (EditDetails((int)row.Cells[0].Value, delivId, prodId, price, vat, count)) { database.SaveChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("Wystąpił problem z edytowaniem produktu"); } } catch (Exception ex) { System.Diagnostics.EventLog.WriteEntry(ex.Source, ex.StackTrace, System.Diagnostics.EventLogEntryType.Warning); MessageBox.Show("Błąd zapisu do bazy"); return; } finally { database.Dispose(); } }