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