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); } }
private bool resultcontains(int x) { using (var context = new HREntities1()) { var ids = from c in context.Departamente select new { c.Id_Sef_Departament }; //var results = from c in context.Angajati // select new // { // c.Id_Angajat, // c.Nume_Angajat, // c.Prenume_Angajat // }; foreach (var item in ids) { if (item.Id_Sef_Departament == x) { return(true); } } return(false); } }
//modificare dep private void FinalizareDepMod_Click(object sender, EventArgs e) { var context = new HREntities1(); context.ModifyDepartamente1(nume_dep, nume_nou_dep, nume_sef_nou); panelModDep.Visible = false; }
//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 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 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 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); } }
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 buttonConectare_Click(object sender, EventArgs e) { try { var context = new HREntities1(); var result = (from c in context.Logins where c.Username == username select c.Username).FirstOrDefault(); if (result == null) { MessageBox.Show("Username incorect"); this.Close(); } else { var result1 = (from c in context.Logins where c.Username == username select c.Parola).FirstOrDefault(); if (password != Encoding.Unicode.GetString(Convert.FromBase64String(result1))) { MessageBox.Show("Parola incorecta"); this.Close(); } else { if (username == "hr") { FormMenu f2 = new FormMenu(); this.Hide(); f2.ShowDialog(); this.Close(); } if (username == "admin") { FormMenuAdmin f3 = new FormMenuAdmin(); this.Hide(); f3.ShowDialog(); this.Close(); } if (username == "guest") { FormInformatii formInfo = new FormInformatii(); formInfo.ShowDialog(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void populate_Users(ComboBox comboparam) { using (var context = new HREntities1()) { var results = from c in context.Logins select new { c.Username }; foreach (var item in results) { comboparam.Items.Add(item.Username); } } }
private void populate_Functii(ComboBox comboparam) { using (var context = new HREntities1()) { var results = from c in context.Functii select new { c.Denumire }; foreach (var item in results) { comboparam.Items.Add(item.Denumire); } } }
private void populate_Proiecte() { using (var context = new HREntities1()) { var results = from c in context.Proiecte select new { c.Nume_Proiect }; foreach (var item in results) { comboBoxProiect.Items.Add(item.Nume_Proiect); } } }
private void populate_Grade() { using (var context = new HREntities1()) { var results = from c in context.Grade select new { c.Denumire }; foreach (var item in results) { comboBoxGrade.Items.Add(item.Denumire); } } }
//populari---------------------------------------------------- private void populate_Departamente(ComboBox comboparam) { using (var context = new HREntities1()) { var results = from c in context.Departamente select new { c.Nume_Departament }; foreach (var item in results) { comboparam.Items.Add(item.Nume_Departament); } } }
private void search(string nume) { using (var context = new HREntities1()) { var results = (from c in context.Angajati where c.Nume_Angajat == nume select new { c.Nume_Angajat }).FirstOrDefault(); if (results == null) { MessageBox.Show("Numele introdus nu se afla in baza de date"); } } }
private void populate_Angajati(ComboBox comboparam) { using (var context = new HREntities1()) { var results = from c in context.Angajati select new { c.Nume_Angajat, c.Prenume_Angajat }; foreach (var item in results) { comboparam.Items.Add(item.Nume_Angajat.ToString() + " " + item.Prenume_Angajat.ToString()); } } }
//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 btnAfisare_Click(object sender, EventArgs e) { using (var context = new HREntities1()) { var res = from c in context.Angajati where c.Observatii.Contains("Trecut in Rezerva") select new { Nume = c.Nume_Angajat, Prenume = c.Prenume_Angajat, CNP = c.CNP, DataAngajare = c.Data_Angajare, DataPlecare = c.Data_Plecare, Email = c.Email, Status = c.Observatii, }; dataGrid.DataSource = res.ToList(); } }
private bool search(string nume, string prenume) { using (var context = new HREntities1()) { var results = (from c in context.Angajati where c.Nume_Angajat == nume && c.Prenume_Angajat == prenume select new { c.Nume_Angajat }).FirstOrDefault(); if (results == null) { MessageBox.Show("Numele introdus nu se afla in baza de date"); return(false); } else { return(true); } } }
private void buttonFinish_Click(object sender, EventArgs e) { try { var context = new HREntities1(); search(nume); if (func == true) { context.MoveFunctie1(nume, prenume, functie); } if (dep == true) { context.MoveDepartament1(nume, prenume, departament); } this.Close(); } 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); } }
private void comboBoxDep_SelectedIndexChanged(object sender, EventArgs e) { try { nume_dep = comboBoxDep.Text; 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_Sef_Departament).First(); var angajatiInDep = (from c in context.Angajati where c.Id_Departament == id_dep select c).FirstOrDefault(); nume_sef_curent = angajatiInDep.ToString(); } 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 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(); } } }