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