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