private void buttonFinFuncMod_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var functie = (from c in context.Functii where c.Denumire == functia_veche select c).First(); functie.Denumire = functie_noua; functie.Solda_functie = solda_functie_noua; var ang = (from c in context.Angajati where c.Id_Functie == functie.Id_Functie select c.Id_Salariu); foreach (var item in ang) { var result = (from c in context.Salarii where c.Id_Salariu == item select c.Solda_functie).First(); result = solda_functie_noua; } context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonPrMod_Click(object sender, EventArgs e) { try { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); datainceput = DateTime.Parse(textDataMod.Text, culture, System.Globalization.DateTimeStyles.AssumeLocal); datasfarsit = DateTime.Parse(textDataSfMod.Text, culture, System.Globalization.DateTimeStyles.AssumeLocal); if (datasfarsit <= datainceput) { MessageBox.Show("Data introdusa incorect"); panelPrMod.Visible = false; } var context = new HREntities1(); var result = (from c in context.Proiecte where c.Nume_Proiect == nume_proiect select c).First(); var id = (from c in context.Angajati where c.Nume_Angajat == responsabil select c.Id_Angajat).First(); result.Nume_Proiect = nume_proiect_mod; result.Id_Responsabil = id; result.Data_Inceput = datainceput; result.Data_Sfarsit = datasfarsit; context.SaveChanges(); panelPrMod.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//TRANZACTIE static void TrecereRezerva() { if (search(nume, prenume) == true) { using (var context = new HREntities1()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); date = DateTime.Parse(data, culture, System.Globalization.DateTimeStyles.AssumeLocal); DateTime data_plecare = date.Date; var angajat = (from c in context.Angajati where c.Nume_Angajat.Equals(nume) && c.Prenume_Angajat.Equals(prenume) select c).First(); angajat.Observatii = " Trecut in Rezerva"; angajat.Data_Plecare = data_plecare; context.SaveChanges(); DialogResult res = MessageBox.Show(nume + " " + prenume + " " + "a fost trecut in rezerva!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); dbContextTransaction.Commit(); } catch (Exception) { DialogResult res = MessageBox.Show("Nu exista numele cautat!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Information); dbContextTransaction.Rollback(); } } } } }
private void buttonFinalizare_Click(object sender, EventArgs e) { try { if (parola1 != parola2) { MessageBox.Show("Ati introdus noua parola gresit.Reincercati"); panelLogins.Visible = false; } else { var context = new HREntities1(); var result = (from c in context.Logins where c.Username == user select c).First(); result.Parola = Convert.ToBase64String(Encoding.Unicode.GetBytes(parola1)); context.SaveChanges(); panelLogins.Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonCV_Click(object sender, EventArgs e) { try { using (var fbd = new OpenFileDialog()) { DialogResult result = fbd.ShowDialog(); if (result == DialogResult.OK) { file = fbd.FileName; } var context = new HREntities1(); var newCV = new CVuri() { Id_Angajat = 1, Cale_fisier = file }; context.CVuri.Add(newCV); context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FinalizareDepDel_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var result = (from c in context.Departamente where c.Nume_Departament.Equals(nume_dep) select c).First(); var id_dep = (from c in context.Departamente where c.Nume_Departament.Equals(nume_dep) select c.Id_Departament).First(); var angajatiInDep = (from c in context.Angajati where c.Id_Departament == id_dep select c).FirstOrDefault(); if (angajatiInDep != null) { MessageBox.Show("Transferati angajatii la alt departament inainte de a-l sterge.Modificarea nu a fost efectuata!"); } else { context.Departamente.Remove(result); context.SaveChanges(); panelDepDelete.Visible = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonAdauga_Click(object sender, EventArgs e) { try { using (var context = new HREntities1()) { var newFisa = new Fise_Medicale() { Inaltime = Convert.ToDouble(inaltime), Greutate = Convert.ToInt32(greutate), Stare_Sanatate = stare, Observatii = observatii, Grupa_Sange = grupa }; context.Fise_Medicale.Add(newFisa); context.SaveChanges(); id_fisamed = newFisa.Id_FisaMed; this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//sterge functie private void buttonFuncDel_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var result = (from c in context.Functii where c.Denumire == functia_veche select c).First(); context.Functii.Remove(result); context.SaveChanges(); panelFuncDel.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnCh_Click_1(object sender, EventArgs e) { var context = new HREntities1(); if (search(numemdf, prenumemdf) == true) { var resutl = (from c in context.Adrese join a in context.Angajati on c.Id_Adresa equals a.Id_Adresa where a.Nume_Angajat.Contains(numemdf) && a.Prenume_Angajat.Contains(prenumemdf) select c).First(); resutl.Strada = strada; resutl.Nr_Strada = nr_strada; resutl.Bloc = bloc; resutl.Apartament = apartament; resutl.Oras = oras; resutl.Judet_Sector = judsector; context.SaveChanges(); } }
private void buttonFinAddFunc_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var newFunc = new Functii() { Denumire = functie_noua, Solda_functie = solda_functie_noua }; context.Functii.Add(newFunc); context.SaveChanges(); panelFuncAdd.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonFinalizareAdd_Click(object sender, EventArgs e) { try { nume_sef_nou = nume_sef_nou.Split(' ')[0]; var context = new HREntities1(); var result = (from c in context.Angajati where c.Nume_Angajat == nume_sef_nou select c.Id_Angajat).First(); var newDep = new Departamente() { Nume_Departament = nume_dep, Id_Sef_Departament = result }; context.Departamente.Add(newDep); context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonAdauga_Click(object sender, EventArgs e) { try { using (var context = new HREntities1()) { var newRuda = new Rude() { Grad_rudenie = grad_rudenie, Nume = nume, Prenume = prenume, CNP = cnp }; context.Rude.Add(newRuda); context.SaveChanges(); ClearTextBoxes(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//proiect delete private void buttonPrDel_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var result = (from c in context.Proiecte where c.Nume_Proiect == comboPrDel.Text select c).First(); var ang = from c in context.Angajati where c.Id_Proiect_Curent == result.Id_Proiect select c; foreach (var item in ang) { item.Id_Proiect_Curent = null; } context.Proiecte.Remove(result); context.SaveChanges(); panelPrDel.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void buttonPrAdd_Click(object sender, EventArgs e) { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); try { datainceput = DateTime.Parse(textDataAdd.Text, culture, System.Globalization.DateTimeStyles.AssumeLocal); datasfarsit = DateTime.Parse(textDataSfAdd.Text, culture, System.Globalization.DateTimeStyles.AssumeLocal); if (datasfarsit <= datainceput) { MessageBox.Show("Data introdusa incorect"); panelProiectAdd.Visible = false; } responsabil = responsabil.Split(' ')[0]; var context = new HREntities1(); var result = (from c in context.Angajati where c.Nume_Angajat == responsabil select c.Id_Angajat).First(); var newProiect = new Proiecte() { Nume_Proiect = nume_proiect, Id_Responsabil = result, Data_Inceput = datainceput, Data_Sfarsit = datasfarsit }; context.Proiecte.Add(newProiect); context.SaveChanges(); panelProiectAdd.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); panelProiectAdd.Visible = false; } }
private void buttonAddAngajat_Click(object sender, EventArgs e) { try { IFormatProvider culture = new System.Globalization.CultureInfo("fr-FR", true); data_nastere = DateTime.Parse(data_nasterestring, culture, System.Globalization.DateTimeStyles.AssumeLocal); using (var context = new HREntities1()) { var results_grad = (from c in context.Grade where c.Denumire == grad select new { c.Id_Grad }).First(); var results_functie = (from c in context.Functii where c.Denumire == functie select new { c.Id_Functie }).First(); var solda_functie = (from c in context.Functii where c.Denumire == functie select new { c.Solda_functie }).First(); var solda_grad = (from c in context.Grade where c.Denumire == grad select new { c.Solda_grad }).First(); var results_departament = (from c in context.Departamente where c.Nume_Departament == departament select new { c.Id_Departament }).First(); var results_proiect = (from c in context.Proiecte where c.Nume_Proiect == proiect select new { c.Id_Proiect }).First(); var newAdresa = new Adrese() { Strada = strada, Nr_Strada = Convert.ToInt32(nr_strada), Bloc = bloc, Apartament = Convert.ToInt32(apartament), Oras = localitate, Judet_Sector = jud_sector, }; context.Adrese.Add(newAdresa); context.SaveChanges(); var newSalariu = new Salarii() { Solda_functie = solda_functie.Solda_functie, Solda_grad = solda_grad.Solda_grad, Spor_conditii_de_munca = 500, Total = solda_functie.Solda_functie + solda_grad.Solda_grad + 100 }; context.Salarii.Add(newSalariu); context.SaveChanges(); var newAngajat = new Angajati() { Nume_Angajat = nume, Prenume_Angajat = prenume, Numar_Telefon = telefon, Email = email, Id_Grad = results_grad.Id_Grad, CNP = cnp, Data_Nastere = data_nastere, Id_Salariu = newSalariu.Id_Salariu, Id_Fisa_Med = id_fisamed, Id_Adresa = newAdresa.Id_Adresa, Id_Functie = results_functie.Id_Functie, Id_Departament = results_departament.Id_Departament, Id_Proiect_Curent = results_proiect.Id_Proiect, Data_Angajare = DateTime.Now }; context.Angajati.Add(newAngajat); context.SaveChanges(); var update_rude = from c in context.Rude where c.Id_Angajat == null select c; foreach (var item in update_rude) { item.Id_Angajat = newAngajat.Id_Angajat; } context.SaveChanges(); var update_CV = (from c in context.CVuri where c.Cale_fisier == file select c).First(); update_CV.Id_Angajat = newAngajat.Id_Angajat; context.SaveChanges(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnCreste_Click(object sender, EventArgs e) { string selected = comboGrad.Text; string selectfunctie = comboFunctie.Text; var context = new HREntities1(); if (selected != null) { if (grad != null) { double marire = 0; double newsolda; double.TryParse(grad, out marire); marire = marire / 100; var result = (from c in context.Grade where c.Denumire.Equals(selected) select c).First(); newsolda = Convert.ToDouble(result.Solda_grad + result.Solda_grad * marire); result.Solda_grad = (int)newsolda; context.SaveChanges(); var result1 = (from a in context.Angajati join g in context.Grade on a.Id_Grad equals g.Id_Grad where g.Denumire.Equals(selected) select a.Id_Salariu); foreach (var item in result1) { var salary = (from s in context.Salarii where s.Id_Salariu == (item) select s).First(); salary.Solda_grad = (int)newsolda; context.SaveChanges(); } } } if (selectfunctie != null) { if (functie != null) { double mariref = 0; double newsoldaf; double.TryParse(functie, out mariref); mariref = mariref / 100; var result = (from c in context.Functii where c.Denumire.Equals(selectfunctie) select c).First(); int aux = (int)result.Solda_functie; newsoldaf = aux + aux * mariref; result.Solda_functie = (int)newsoldaf; context.SaveChanges(); var result1 = (from a in context.Angajati join g in context.Functii on a.Id_Functie equals g.Id_Functie where g.Denumire.Equals(selectfunctie) select a.Id_Salariu); foreach (var item in result1) { var salary = (from s in context.Salarii where s.Id_Salariu == (item) select s).First(); salary.Solda_functie = (int)newsoldaf; context.SaveChanges(); } } } if (spor != null) { double marires = 0; double newsoldas; double.TryParse(spor, out marires); marires = marires / 100; var results = from s in context.Salarii select s.Spor_conditii_de_munca; foreach (var items in results) { var newspor = (from ns in context.Salarii where ns.Spor_conditii_de_munca == items select ns).First(); int changespor = (int)newspor.Spor_conditii_de_munca; newsoldas = changespor + changespor * marires; newspor.Spor_conditii_de_munca = (int)newsoldas; context.SaveChanges(); } } DialogResult res = MessageBox.Show("Marire Efectuata!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void btnModifica_Click(object sender, EventArgs e) { if (search(nume, prenume) == true) { var context = new HREntities1(); if (comboBox1.Text == "CNP") { var result = (from a in context.Angajati where a.Nume_Angajat.Contains(nume) && a.Prenume_Angajat.Contains(prenume) select a).First(); result.CNP = String.Copy(valIntrodusa); context.SaveChanges(); DialogResult res = MessageBox.Show("Modificare CNP reusita!", "Confirmation!", MessageBoxButtons.OK, MessageBoxIcon.Information); boxNume.Clear(); boxPrenume.Clear(); boxNewVal.Clear(); } if (comboBox1.Text.Contains("Numar_Telefon")) { var resultnr = (from n in context.Angajati where n.Nume_Angajat.Contains(nume) && n.Prenume_Angajat.Contains(prenume) select n ).First(); resultnr.Numar_Telefon = String.Copy(valIntrodusa); context.SaveChanges(); DialogResult res = MessageBox.Show("Modificare Numar Telefon reusita!", "Confirmation!", MessageBoxButtons.OK, MessageBoxIcon.Information); boxNume.Clear(); boxPrenume.Clear(); boxNewVal.Clear(); } if (comboBox1.Text.Contains("Email")) { var resultemail = (from em in context.Angajati where em.Nume_Angajat.Contains(nume) && em.Prenume_Angajat.Contains(prenume) select em).First(); resultemail.Email = String.Copy(valIntrodusa); context.SaveChanges(); DialogResult res = MessageBox.Show("Modificare Email reusita!", "Confirmation!", MessageBoxButtons.OK, MessageBoxIcon.Information); boxNume.Clear(); boxPrenume.Clear(); boxNewVal.Clear(); } if (comboBox1.Text.Contains("Observatii")) { var resultobs = (from obs in context.Angajati where obs.Nume_Angajat.Contains(nume) && obs.Prenume_Angajat.Contains(prenume) select obs).First(); resultobs.Observatii = valIntrodusa; context.SaveChanges(); DialogResult res = MessageBox.Show("Modificare Observatii reusita!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); boxNume.Clear(); boxPrenume.Clear(); boxNewVal.Clear(); } if (comboBox1.Text.Contains("Nume_Angajat")) { var resultobs = (from obs in context.Angajati where obs.Nume_Angajat.Contains(nume) && obs.Prenume_Angajat.Contains(prenume) select obs).First(); resultobs.Nume_Angajat = valIntrodusa; context.SaveChanges(); DialogResult res = MessageBox.Show("Modificare Nume reusita!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); boxNume.Clear(); boxPrenume.Clear(); boxNewVal.Clear(); } } }
private void btnModifica_Click(object sender, EventArgs e) { var context = new HREntities1(); if (search(nume, prenume) == true) { if (grad != null) { double marire = 0; double newsolda; double.TryParse(grad, out marire); marire = marire / 100; var result = (from c in context.Grade join t in context.Angajati on c.Id_Grad equals t.Id_Grad where t.Nume_Angajat.Equals(nume) && t.Prenume_Angajat.Equals(prenume) select c).First(); newsolda = Convert.ToDouble(result.Solda_grad + result.Solda_grad * marire); result.Solda_grad = (int)newsolda; context.SaveChanges(); var newsalariu = (from s in context.Angajati join a in context.Salarii on s.Id_Salariu equals a.Id_Salariu where s.Nume_Angajat.Equals(nume) && s.Prenume_Angajat.Equals(prenume) select a).First(); newsalariu.Solda_grad = (int)newsolda; newsalariu.Total = newsalariu.Spor_conditii_de_munca + newsalariu.Solda_grad + newsalariu.Solda_functie; context.SaveChanges(); } if (functie != null) { double mariref = 0; double change; int newsoldaf = 0; double.TryParse(functie, out mariref); // mariref = mariref / 100; var result1 = (from c in context.Functii join t in context.Angajati on c.Id_Functie equals t.Id_Functie where t.Nume_Angajat.Equals(nume) && t.Prenume_Angajat.Equals(prenume) select c).First(); change = (double)result1.Solda_functie; change = change + (change * (mariref / 100)); newsoldaf = (int)change; result1.Solda_functie = newsoldaf; context.SaveChanges(); var newsalariu = (from s1 in context.Angajati join a1 in context.Salarii on s1.Id_Salariu equals a1.Id_Salariu where s1.Nume_Angajat.Equals(nume) && s1.Prenume_Angajat.Equals(prenume) select a1).First(); newsalariu.Solda_functie = (int)newsoldaf; newsalariu.Total = newsalariu.Solda_functie + newsalariu.Solda_grad + newsalariu.Spor_conditii_de_munca; context.SaveChanges(); } if (spor != null) { double marires = 0; double changes; int newsoldas = 0; double.TryParse(spor, out marires); // mariref = mariref / 100; var result1 = (from c in context.Salarii join t in context.Angajati on c.Id_Salariu equals t.Id_Salariu where t.Nume_Angajat.Equals(nume) && t.Prenume_Angajat.Equals(prenume) select c).First(); changes = (double)result1.Spor_conditii_de_munca; changes = changes + (changes * (marires / 100)); newsoldas = (int)changes; result1.Spor_conditii_de_munca = newsoldas; context.SaveChanges(); var newsalariu = (from s2 in context.Angajati join a2 in context.Salarii on s2.Id_Salariu equals a2.Id_Salariu where s2.Nume_Angajat.Equals(nume) && s2.Prenume_Angajat.Equals(prenume) select a2).First(); newsalariu.Spor_conditii_de_munca = (int)newsoldas; newsalariu.Total = newsalariu.Spor_conditii_de_munca + newsalariu.Solda_grad + newsalariu.Solda_functie; context.SaveChanges(); } DialogResult res = MessageBox.Show("Marire Efectuata!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }