private void Add_New_Client() { var Adress = new adres(); var kontrahent = new kontrahent(); Boolean flag = false; using (zlecenieEntities db = new zlecenieEntities()) { try { kontrahent.Imie = textBox_Name.Text.ToString(); kontrahent.Nazwisko = textBox_Lastname.Text.ToString(); if (textBox_PESEL.Text == "") { kontrahent.Pesel = null; } else { kontrahent.Pesel = System.Convert.ToInt64(textBox_PESEL.Text); } if (textBox_NIP.Text == "") { kontrahent.NIP = null; } else { kontrahent.NIP = System.Convert.ToInt64(textBox_NIP.Text); } kontrahent.Nazwa_Firmy = textBox_Company_Name.Text.ToString(); Adress.Miasto = textBox_Adress_Town_Name.Text; Adress.Nazwa_ulicy = textBox_Street_Name.Text; Adress.Kod_pocztowy = textBox_Code_1.Text + textBox_Code_2.Text; Adress.Numer_budynku = textBox_Building_Number.Text; Adress.Numer_mieszkania = textBox_Home_Number.Text; Adress.Państwo = comboBox_Country_ID.Text; db.adres.AddOrUpdate(Adress); db.SaveChanges(); kontrahent.E_mail = textBox_Email_Adress.Text.ToString(); kontrahent.Telefon_1 = textBox_Phone_Number_1.Text.ToString(); kontrahent.Telefon_2 = textBox_Phone_Number_2.Text.ToString(); kontrahent.Adres = Adress.ID; flag = true; } catch (Exception) { MessageBox.Show("Podano nieprawidłowy numer NIP lub PESEL", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Warning); flag = false; } if (flag == true) { db.kontrahent.Add(kontrahent); db.SaveChanges(); MessageBox.Show("Kontrahent dodany", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void button_Add_New_Address_Click(object sender, EventArgs e) { var Adress = new adres(); var kontrahent = new kontrahent(); Boolean flag = false; using (zlecenieEntities db = new zlecenieEntities()) { try { kontrahent.Imie = textBox_imie.Text.ToString(); kontrahent.Nazwisko = textBox_nazwisko.Text.ToString(); if (textBox_pesel.Text == "") { kontrahent.Pesel = null; } else { kontrahent.Pesel = System.Convert.ToInt64(textBox_pesel.Text); } if (textBox_nip.Text == "") { kontrahent.NIP = null; } else { kontrahent.NIP = System.Convert.ToInt64(textBox_nip.Text); } kontrahent.Nazwa_Firmy = textBox_firma.Text.ToString(); Adress.Miasto = textBox_town.Text; Adress.Nazwa_ulicy = textBox_street.Text; Adress.Kod_pocztowy = textBox_kod_1.Text + textBox_kod_2.Text; Adress.Numer_budynku = textBox_building.Text; Adress.Numer_mieszkania = textBox_home.Text; Adress.Państwo = comboBox1.Text; db.adres.Add(Adress); db.SaveChanges(); kontrahent.E_mail = textBox_email.Text.ToString(); kontrahent.Telefon_1 = textBox_tel.Text.ToString(); kontrahent.Telefon_2 = textBox_tel2.Text.ToString(); kontrahent.Adres = Adress.ID; flag = true; } catch (Exception) { MessageBox.Show("Podano nieprawidłowy numer NIP lub PESEL", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Warning); flag = false; } if (flag == true) { db.kontrahent.Add(kontrahent); db.SaveChanges(); MessageBox.Show("Kontrahent dodany", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void Client_List_Update() { Cursor.Current = Cursors.WaitCursor; using (zlecenieEntities db = new zlecenieEntities()) { try { Client_list.Items.Clear(); List <kontrahent> list = db.kontrahent.ToList(); foreach (kontrahent C in list.Where(lvi => lvi.Nazwa_Firmy.ToLower().Contains(textBox4.Text.ToLower()) && lvi.Nazwisko.ToLower().Contains(textBox5.Text.ToLower()) && lvi.ID.ToString().ToLower().Contains(textBox6.Text.ToLower()))) { ListViewItem item = new ListViewItem(C.ID.ToString()); item.SubItems.Add(C.Imie); item.SubItems.Add(C.Nazwisko); item.SubItems.Add(C.Pesel.ToString()); item.SubItems.Add(C.NIP.ToString()); item.SubItems.Add(C.Nazwa_Firmy); if (C.Adres != 0) { adres Client_Adress = new adres(); Client_Adress = db.adres.Find(C.Adres); if (Client_Adress.Numer_mieszkania == null) { item.SubItems.Add(Client_Adress.Miasto.ToString() + " " + Client_Adress.Kod_pocztowy.ToString().Remove(2, 3) + "-" + Client_Adress.Kod_pocztowy.ToString().Remove(0, 2) + ", " + Client_Adress.Nazwa_ulicy.ToString() + " " + Client_Adress.Numer_budynku.ToString() + " " + Client_Adress.Państwo.ToString()); } else { item.SubItems.Add(Client_Adress.Miasto.ToString() + " " + Client_Adress.Kod_pocztowy.ToString().Remove(2, 3) + "-" + Client_Adress.Kod_pocztowy.ToString().Remove(0, 2) + ", " + Client_Adress.Nazwa_ulicy.ToString() + " " + Client_Adress.Numer_budynku.ToString() + "/" + Client_Adress.Numer_mieszkania.ToString() + " " + Client_Adress.Państwo.ToString()); } } item.SubItems.Add(C.E_mail); item.SubItems.Add(C.Telefon_1.ToString()); item.SubItems.Add(C.Telefon_2.ToString()); item.Font = new Font(item.Font, FontStyle.Regular); Client_list.Items.Add(item); } } catch (Exception e) { MessageBox.Show(e.Message); } } Cursor.Current = Cursors.Default; } // Add Clients information from DB to listView
} // Add Clients information from DB to listView private void textBox_client_company_search_TextChanged(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; using (zlecenieEntities db = new zlecenieEntities()) { try { Client_list.Items.Clear(); List <kontrahent> list = db.kontrahent.ToList(); foreach (kontrahent C in list.Where(lvi => lvi.Nazwa_Firmy.ToLower().Contains(textBox_client_company_search.Text.ToLower()) && lvi.Nazwisko.ToLower().Contains(textBox_client_name_search.Text.ToLower()) && lvi.ID.ToString().ToLower().Contains(textBox_client_id_search.Text.ToLower()))) { ListViewItem item = new ListViewItem(C.ID.ToString()); item.SubItems.Add(C.Imie); item.SubItems.Add(C.Nazwisko); item.SubItems.Add(C.Pesel.ToString()); item.SubItems.Add(C.NIP.ToString()); item.SubItems.Add(C.Nazwa_Firmy); if (C.Adres != 0) { adres Client_Adress = new adres(); Client_Adress = db.adres.Find(C.Adres); if (Client_Adress.Numer_mieszkania == null) { item.SubItems.Add(Client_Adress.Miasto.ToString() + " " + Client_Adress.Kod_pocztowy.ToString().Remove(2, 3) + "-" + Client_Adress.Kod_pocztowy.ToString().Remove(0, 2) + ", " + Client_Adress.Nazwa_ulicy.ToString() + " " + Client_Adress.Numer_budynku.ToString() + " " + Client_Adress.Państwo.ToString()); } else { item.SubItems.Add(Client_Adress.Miasto.ToString() + " " + Client_Adress.Kod_pocztowy.ToString().Remove(2, 3) + "-" + Client_Adress.Kod_pocztowy.ToString().Remove(0, 2) + ", " + Client_Adress.Nazwa_ulicy.ToString() + " " + Client_Adress.Numer_budynku.ToString() + "/" + Client_Adress.Numer_mieszkania.ToString() + " " + Client_Adress.Państwo.ToString()); } } item.SubItems.Add(C.E_mail); item.SubItems.Add(C.Telefon_1.ToString()); item.SubItems.Add(C.Telefon_2.ToString()); item.Font = new Font(item.Font, FontStyle.Regular); Client_list.Items.Add(item); } } catch (Exception) { } } Cursor.Current = Cursors.Default; } // Search and fill list by input
} // Update dataGrid net and gross price value after enter new quantity value private void Button_chose_Client_Click(object sender, EventArgs e) { try { using (zlecenieEntities db = new zlecenieEntities()) { kontrahent k = new kontrahent(); Window_Choice_Client_For_Offer window_Choice_Client = new Window_Choice_Client_For_Offer(k); window_Choice_Client.ShowDialog(); client_id = k.ID; k = db.kontrahent.Find(k.ID); adres a = new adres(); a = db.adres.Find(k.Adres); textBox_Offer_Name.Text = k.Imie.ToString(); textBox_Offer_LastName.Text = k.Nazwisko.ToString(); textBox_Offer_CompanyName.Text = k.Nazwa_Firmy.ToString(); } } catch { } } // Add information about Client to Offer Form
private void button_Add_New_Address_Click(object sender, EventArgs e) { var Address = new adres(); Boolean flag = false; using (zlecenieEntities db = new zlecenieEntities()) { try { Address.Miasto = textBox_town.Text; Address.Nazwa_ulicy = textBox_street.Text; if (textBox_kod_1.TextLength == 2 && textBox_kod_2.TextLength == 3) { Address.Kod_pocztowy = textBox_kod_1.Text + textBox_kod_2.Text; Address.Numer_budynku = textBox_building.Text; Address.Numer_mieszkania = textBox_home.Text; Address.Państwo = comboBox1.Text; flag = true; } else { MessageBox.Show("Błąd dla kodu pocztowego", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception) { MessageBox.Show("Wypełnij wszystkie dane", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Warning); flag = false; } if (flag == true) { db.adres.Add(Address); db.SaveChanges(); MessageBox.Show("Adres dodany", "OK", MessageBoxButtons.OK, MessageBoxIcon.Information); Address_List_Update(); } } }
void Add_Client_Information() { using (zlecenieEntities db = new zlecenieEntities()) { adres adres = new adres(); textBox_Name.Text = _k.Imie.ToString(); textBox_Lastname.Text = _k.Nazwisko.ToString(); textBox_PESEL.Text = _k.Pesel.ToString(); textBox_NIP.Text = _k.NIP.ToString(); adres = db.adres.Find(_k.Adres); textBox_Adress_Town_Name.Text = adres.Miasto.ToString(); textBox_Street_Name.Text = adres.Nazwa_ulicy.ToString(); textBox_Code_1.Text = adres.Kod_pocztowy.ToString().Remove(2, 3); textBox_Code_2.Text = adres.Kod_pocztowy.ToString().Remove(0, 2); textBox_Building_Number.Text = adres.Numer_budynku.ToString(); textBox_Home_Number.Text = adres.Numer_mieszkania.ToString(); comboBox_Country_ID.Text = adres.Państwo.ToString(); textBox_Company_Name.Text = _k.Nazwa_Firmy.ToString(); textBox_Email_Adress.Text = _k.E_mail.ToString(); textBox_Phone_Number_1.Text = _k.Telefon_1.ToString(); textBox_Phone_Number_2.Text = _k.Telefon_2.ToString(); } }
} // Update dataGrid net and gross price value after enter new quantity value private void Button_chose_Client_Click(object sender, EventArgs e) { using (zlecenieEntities db = new zlecenieEntities()) { kontrahent k = new kontrahent(); Window_Choice_Client_For_Offer window_Choice_Client = new Window_Choice_Client_For_Offer(k); window_Choice_Client.ShowDialog(); client_id = k.ID; k = db.kontrahent.Find(k.ID); adres a = new adres(); a = db.adres.Find(k.Adres); textBox_Offer_Name.Text = k.Imie.ToString(); textBox_Offer_LastName.Text = k.Nazwisko.ToString(); textBox_Offer_CompanyName.Text = k.Nazwa_Firmy.ToString(); textBox_Town_Name.Text = a.Miasto.ToString(); textBox_Post_Code_1.Text = a.Kod_pocztowy.ToString().Remove(2, 3); textBox_Post_Code_2.Text = a.Kod_pocztowy.ToString().Remove(0, 2); textBox_Street_Name.Text = a.Nazwa_ulicy.ToString(); textBox_Building_Number.Text = a.Numer_budynku.ToString(); textBox_Home_Number.Text = a.Numer_mieszkania.ToString(); textBox_Country_ID.Text = a.Państwo.ToString(); } } // Add information about Client to Offer Form
public Window_Choice_Adres_For_Order(adres a) { InitializeComponent(); Address_List_Update(); _a = a; }
void Choice_Address_For_Client(int button_number) { TextBox[] textBox = { textBox_Town, textBox_Kod_1, textBox_Kod_2, textBox_Street, textBox_Building_Number, textBox_Home_Number, textBox_Country }; switch (button_number) { case 1: { try { using (zlecenieEntities db = new zlecenieEntities()) { textBox_Town.Text = db.adres.Find(db.kontrahent.Find(client_id).Adres).Miasto; textBox_Kod_1.Text = (db.adres.Find(db.kontrahent.Find(client_id).Adres).Kod_pocztowy).Remove(2, 3); textBox_Kod_2.Text = (db.adres.Find(db.kontrahent.Find(client_id).Adres).Kod_pocztowy).Remove(0, 2); textBox_Street.Text = db.adres.Find(db.kontrahent.Find(client_id).Adres).Nazwa_ulicy; textBox_Building_Number.Text = db.adres.Find(db.kontrahent.Find(client_id).Adres).Numer_budynku; textBox_Home_Number.Text = db.adres.Find(db.kontrahent.Find(client_id).Adres).Numer_mieszkania; textBox_Country.Text = db.adres.Find(db.kontrahent.Find(client_id).Adres).Państwo; for (int i = 0; i < textBox.Length; i++) { textBox[i].Enabled = false; } } } catch { MessageBox.Show("Wybierz Kontrahenta", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error); } break; } case 2: { try { using (zlecenieEntities db = new zlecenieEntities()) { a = new adres(); Window_Choice_Adres_For_Order window_Choice_Adres = new Window_Choice_Adres_For_Order(a); window_Choice_Adres.ShowDialog(); a = db.adres.Find(a.ID); textBox_Town.Text = a.Miasto; textBox_Kod_1.Text = a.Kod_pocztowy.Remove(2, 3); textBox_Kod_2.Text = a.Kod_pocztowy.Remove(0, 2); textBox_Street.Text = a.Nazwa_ulicy; textBox_Building_Number.Text = a.Numer_budynku; textBox_Home_Number.Text = a.Numer_mieszkania; textBox_Country.Text = a.Państwo; for (int i = 0; i < textBox.Length; i++) { textBox[i].Enabled = false; } } } catch { } break; } } }