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();
}
}