public static void updateAngajat(Angajati angj)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Conexiunea la baza de date nu s-a realizat.");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "UPDATE Angajati SET email=@email,parola=@parola,nume=@nume,prenume=@prenume,acces=@acces WHERE id=@id ";
cmd.Parameters.AddWithValue("@email", angj.Email);
cmd.Parameters.AddWithValue("@parola", angj.Parola);
cmd.Parameters.AddWithValue("@nume", angj.Nume);
cmd.Parameters.AddWithValue("@prenume", angj.Prenume);
cmd.Parameters.AddWithValue("@acces", angj.Acces);
cmd.Parameters.AddWithValue("@id", angj.Id);
try
{
if (cmd.ExecuteNonQuery() != 1)
{
throw new Exception("Modificarea nu a avut loc!");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
con.Close();
}
public static void logare(Angajati angj)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Conexiunea la baza de date nu s-a realizat.");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select acces from angajati where email=@email AND parola=@parola";
cmd.Parameters.AddWithValue("@email", angj.Email);
cmd.Parameters.AddWithValue("@parola", angj.Parola);
MySqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
if ((string)data["acces"] == Vam.rolAdmin)
{
MessageBox.Show("Logarea a avut loc cu succes", "Event", MessageBoxButtons.OK, MessageBoxIcon.Information);
Vam.loginAdmin = true;
}
else if ((string)data["acces"] == Vam.rolAngajat)
{
MessageBox.Show("Logarea a avut loc cu succes", "Event", MessageBoxButtons.OK, MessageBoxIcon.Information);
Vam.loginAngajat = true;
}
}
else
{
MessageBox.Show("Logarea nu a avut loc", "Event", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
con.Close();
}
private void VerifyInput(Angajati newAngajat, string password)
{
if (newAngajat.Nume == "")
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Numele nu poate fi lasat necompletat!");
}
if (newAngajat.Nume.Length > 30)
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Numele nu poate contine mai mult de 30 de caractere!");
}
if (newAngajat.CodFunctie.ToString() == "")
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Codul functiei nu poate fi lasat necompletat!");
}
if (newAngajat.Telefon.Length > 10)
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Telefonul contine mai mult de 10 de cifre!");
}
if (password == "")
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Parola nu poate fi lasata necompletata!");
}
if (password.Length > 40)
{
throw new System.Data.Entity.Infrastructure.DbUpdateException("Parola client contine mai mult de 40 de caractere!");
}
}
public Angajati GetAngajatByIndex(int index)
{
try
{
int contor = 0;
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
while ((line = sr.ReadLine()) != null)
{
if (line == "")
{
continue;
}
Angajati a = new Angajati(line);
if (contor == index)
{
return(a);
}
contor++;
}
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
return(null);
}
private int GetId()
{
int IdAngajat = ID_PRIMUL_ANGAJAT;
try
{
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
while ((line = sr.ReadLine()) != null)
{
Angajati a = new Angajati(line);
IdAngajat = a.IdAngajat + INCREMENT;
}
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
return(IdAngajat);
}
public List <Angajati> GetAngajati()
{
List <Angajati> angajati = new List <Angajati>();
try
{
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
while ((line = sr.ReadLine()) != null)
{
if (line != "")
{
Angajati a = new Angajati(line);
angajati.Add(a);
}
}
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
return(angajati);
}
public Angajati GetAngajat(string CNP)
{
try
{
using (StreamReader sr = new StreamReader(NumeFisier))
{
string line;
while ((line = sr.ReadLine()) != null)
{
Angajati a = new Angajati(line);
if (a.Cnp == CNP)
{
return(a);
}
}
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
return(null);
}
public static void stergeAngajat(Angajati angj)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Conexiunea la baza de date nu s-a realizat.");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM angajati WHERE email=@email AND parola=@parola AND nume=@nume AND prenume=@prenume AND acces=@acces ";
cmd.Parameters.AddWithValue("@email", angj.Email);
cmd.Parameters.AddWithValue("@parola", angj.Parola);
cmd.Parameters.AddWithValue("@nume", angj.Nume);
cmd.Parameters.AddWithValue("@prenume", angj.Prenume);
cmd.Parameters.AddWithValue("@acces", angj.Acces);
MySqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
MessageBox.Show("Stergerea nu a avut loc", "Event", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("Stergerea a avut loc cu succes", "Event", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
con.Close();
}
public bool UpdateAngajat(Angajati AngajatActualizat)
{
List <Angajati> angajati = GetAngajati();
bool actualizareCuSucces = false;
try
{
using (StreamWriter swFisierText = new StreamWriter(NumeFisier, false))
{
foreach (Angajati a in angajati)
{
if (a.IdAngajat != AngajatActualizat.IdAngajat)
{
swFisierText.WriteLine(a.ConversieLaSir(DELIMITER));
}
else
{
swFisierText.WriteLine(AngajatActualizat.ConversieLaSir(DELIMITER));
}
}
actualizareCuSucces = true;
}
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
return(actualizareCuSucces);
}
public CrediteWindow(Angajati employee)
{
InitializeComponent();
MyAng = new Angajati(employee);
initializeCollectionView();
initializeBoxes();
}
public async Task <Angajati> UpdateUserActivity(string id, Angajati userToUpdate)
{
UriBuilder builder = new UriBuilder(ApiConstants.BaseApiUrl)
{
Path = $"{ApiConstants.UpdateUserEndpoint}/{id}"
};
return(await _genericRepository.PutAsync(builder.ToString(), userToUpdate));
}
private void CommandBinding_Executed(object sender, ExecutedRoutedEventArgs e)
{
try
{
Angajati newAngajat = new Angajati
{
Nume = txtNume.Text,
CodFunctie = Int32.Parse(txtFunctie.Text),
CodSucursala = Int32.Parse(txtSucursala.Text),
CodSalariu = Int32.Parse(txtSalariu.Text),
Telefon = txtTelefon.Text,
DataAngajarii = dataAngajarePicker.SelectedDate.GetValueOrDefault()
};
VerifyInput(newAngajat, txtPassword.Password);
string pass = txtPassword.Password;
byte[] array = Encoding.ASCII.GetBytes(pass);
HashAlgorithm sha = SHA256.Create();
byte[] HashedPassword = sha.ComputeHash(array);
var context = new BancaEntities();
context.Angajatis.Add(newAngajat);
context.SaveChanges();
//vad ce IdAngajat are cel nou creat
var idNewAngajat = (context.Angajatis.Where(s => s.Nume.ToString() == txtNume.Text).SingleOrDefault()).CodAngajat;
//ii pun in UtilizatoriAngajati, Id-ul si parola asociata
var NewUser = new UtilizatoriAngajati()
{
// password = HashedPassword,
angajatID = idNewAngajat,
createdOn = dataAngajarePicker.SelectedDate.GetValueOrDefault()
};
context.UtilizatoriAngajatis.Add(NewUser);
context.SaveChanges();
MessageBox.Show("Ati fost adaugat cu succes\nAveti codul unic: ", idNewAngajat.ToString());
MyWindow = new HomeWindow(newAngajat);
Hide();
MyWindow.Show();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException sqlEx)
{
MessageBox.Show(GetCorrectError(sqlEx), "Error!");
OnReload?.Invoke();
}
}
public HomeWindow(Angajati employee)
{
InitializeComponent();
// MyAng = new Angajati(employee);
initializeSalariu();
initializeFunctie();
}
private void dgvAfisare_SelectionChanged(object sender, EventArgs e)
{
if (dgvAfisare.SelectedRows.Count == 1)
{
int selectedrowindex = dgvAfisare.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvAfisare.Rows[selectedrowindex];
string cnp = Convert.ToString(selectedRow.Cells["cnp"].Value);
Angajati a = adminAngajati.GetAngajat(cnp);
FileToFormData(a);
}
}
private void FileToFormData(Angajati a)
{
// Set employee data to all imput fields
txtCnp.Enabled = false;
txtNume.Text = a.Nume;
txtPrenume.Text = a.Prenume;
txtAdresa.Text = a.Adresa;
txtCnp.Text = a.Cnp;
txtNrTel.Text = a.NumarTelefon;
cmbFunctie.SelectedItem = a.Functie;
dtpAngajare.Value = a.DataAngajare;
}
private void butonStergeAngajat_Click(object sender, EventArgs e)
{
Angajati angj = new Angajati();
angj.Email = emailBox.Text;
angj.Parola = parolaBox.Text;
angj.Nume = numeBox.Text;
angj.Prenume = prenumeBox.Text;
angj.Acces = comboBoxGradAcces.GetItemText(comboBoxGradAcces.SelectedItem);
MagazinDAO.stergeAngajat(angj);
emailBox.Text = "";
parolaBox.Text = "";
numeBox.Text = "";
prenumeBox.Text = "";
arataAngajati();
}
static void Main(string[] args)
{
int x;
Meniu meniu = new Meniu();
List <Pacient> listaPacienti = new List <Pacient>();
listaPacienti.Add(new Pacient("2950622350067", "Popescu", "Ion", new Modele.Generic.Adresa("Timis", "Timisoara", "Salciei", 3), "preinfarct", new Modele.Generic.Data(6, 12, 2017)));
listaPacienti.Add(new Pacient("2953475350067", "Ionescu", "Andreea", new Modele.Generic.Adresa("Timis", "Timisoara", "Plopi", 9), "ulcer", new Modele.Generic.Data(6, 8, 2017)));
listaPacienti.Add(new Pacient("2950622763467", "Anghel", "Maria", new Modele.Generic.Adresa("Timis", "Timisoara", "Madrid", 10), "gripa", new Modele.Generic.Data(6, 7, 2017)));
Pacienti lista = new Pacienti(listaPacienti);
List <Ambulanta> listaAmbulante = new List <Ambulanta>();
listaAmbulante.Add(new Ambulanta("VW", 2005, new Modele.Generic.NumarMasina("TM02WOW")));
listaAmbulante.Add(new Ambulanta("Mercedes", 2000, new Modele.Generic.NumarMasina("TM02FXR")));
listaAmbulante.Add(new Ambulanta("BMW", 2010, new Modele.Generic.NumarMasina("TM05PLS")));
Ambulante listaAmb = new Ambulante(listaAmbulante);
List <Angajat> listaAngajati = new List <Angajat>();
listaAngajati.Add(new Angajat("29567342688", "Pop", "Ionel", new Modele.Generic.Adresa("Timis", "Timisoara", "Plop", 3), "manager", "Ionescu Maria"));
listaAngajati.Add(new Angajat("29556742688", "Popovici", "Arthur", new Modele.Generic.Adresa("Timis", "Timisoara", "Sever Bocu", 20), "doctor", "Pop Ionel"));
listaAngajati.Add(new Angajat("29567342688", "Meda", "Ana", new Modele.Generic.Adresa("Timis", "Timisoara", "Linitei", 3), "asistent", "Popovici Arthur"));
Angajati listaAng = new Angajati(listaAngajati);
List <Medicament> listaMedicamente = new List <Medicament>();
listaMedicamente.Add(new Medicament(new Modele.Medicament.Furnizor("SC MED", new Modele.Generic.Adresa("Timis", "Timisoara", "Lazar", 2)), "Algocalmin", 200));
listaMedicamente.Add(new Medicament(new Modele.Medicament.Furnizor("SC OSM", new Modele.Generic.Adresa("Timis", "Timisoara", "Maur", 23)), "Diazepam", 240));
Medicamente listaMed = new Medicamente(listaMedicamente);
List <Investigatie> investigatii = new List <Investigatie>();
investigatii.Add(new Investigatie("2950622350067", new Analize(200, 100, 50)));
investigatii.Add(new Investigatie("2953475350067", new Analize(300, 50, 20)));
do
{
meniu.afisareMeniu();
x = int.Parse(Console.ReadLine());
meniu.selectareOptiune(x, lista, listaAmb, listaAng, listaMed, investigatii);
} while (x != 0);
Console.ReadLine();
}
public void AddAngajat(Angajati a)
{
a.IdAngajat = GetId();
try
{
using (StreamWriter swFisierText = new StreamWriter(NumeFisier, true))
swFisierText.WriteLine(a.ConversieLaSir(DELIMITER));
}
catch (IOException eIO)
{
throw new Exception("Eroare la deschiderea fisierului. Mesaj: " + eIO.Message);
}
catch (Exception eGen)
{
throw new Exception("Eroare generica. Mesaj: " + eGen.Message);
}
}
private void butonModificaAngajat_Click(object sender, EventArgs e)
{
Angajati angj = new Angajati();
angj.Id = Vam.valIdAngajat;
angj.Email = emailBox.Text;
angj.Parola = Vam.Encode(parolaBox.Text);
angj.Nume = numeBox.Text;
angj.Prenume = prenumeBox.Text;
angj.Acces = comboBoxGradAcces.GetItemText(comboBoxGradAcces.SelectedItem);
MagazinDAO.updateAngajat(angj);
emailBox.Text = "";
parolaBox.Text = "";
numeBox.Text = "";
prenumeBox.Text = "";
angj.Email = "";
arataAngajati();
}
public static DataTable afisareAngajati(Angajati angj)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Conexiunea la baza de date nu s-a realizat.");
}
string instructiune = "select *from angajati";
MySqlDataAdapter adpt = new MySqlDataAdapter(instructiune, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
return(dt);
con.Close();
}
private void butonLogin_Click(object sender, EventArgs e)
{
Angajati angj = new Angajati();
angj.Email = usernameBox.Text;
angj.Parola = Vam.Encode(parolaLogare.Text);
MagazinDAO.logare(angj);
if (Vam.loginAdmin == true || Vam.loginAngajat == true)
{
HomeCenter.Instance.PnlContainer.Controls.Clear();
HomeCenter.Instance.afisareMeniu();
}
usernameBox.Text = "";
parolaLogare.Text = "";
}
private void btnCauta_Click(object sender, EventArgs e)
{
// Search for a employee
lblInfo.Visible = false;
Angajati a = adminAngajati.GetAngajat(txtCnp.Text);
if (a == null)
{
lblInfo.Text = "Nu exista nici un angajat cu acest CNP";
lblInfo.Visible = true;
}
else
{
// Set employee data to all imput fields
FileToFormData(a);
lblInfo.Text = "Angajatul a fost gasit";
lblInfo.Visible = true;
}
}
private void btnAdauga_Click(object sender, EventArgs e)
{
lblInfo.Visible = false;
// Set default BackColor for all labels
SetLblColor();
if (validare())
{
// Add a new employee if the data is valid
Angajati angajat = new Angajati();
angajat.Nume = txtNume.Text;
angajat.Prenume = txtPrenume.Text;
angajat.NumarTelefon = txtNrTel.Text;
angajat.Adresa = txtAdresa.Text;
angajat.Cnp = txtCnp.Text;
angajat.Functie = Utils.FunctieConvert(cmbFunctie.Text);
angajat.DataAngajare = dtpAngajare.Value;
// Add a new employee in the file
adminAngajati.AddAngajat(angajat);
lblInfo.Text = "Angajatul a fost adaugat";
lblInfo.Visible = true;
// Reset all input text
ResetareControale();
}
}
private void btnModifica_Click(object sender, EventArgs e)
{
// Update employee data
lblInfo.Visible = false;
if (txtCnp.Text.Length == 0)
{
lblInfo.Text = "Introdu CNP-ul clinetului cautat";
lblInfo.Visible = true;
return;
}
Angajati angajat = adminAngajati.GetAngajat(txtCnp.Text);
if (angajat == null)
{
lblInfo.Text = "Nu exista nici un angajat cu acest CNP";
lblInfo.Visible = true;
}
else
{
SetLblColor();
if (validare())
{
angajat.Nume = txtNume.Text;
angajat.Prenume = txtPrenume.Text;
angajat.NumarTelefon = txtNrTel.Text;
angajat.Adresa = txtAdresa.Text;
angajat.Cnp = txtCnp.Text;
angajat.Functie = Utils.FunctieConvert(cmbFunctie.Text);
angajat.DataAngajare = dtpAngajare.Value;
adminAngajati.UpdateAngajat(angajat);
lblInfo.Text = "Datele angajatului au fost modificate";
lblInfo.Visible = true;
ResetareControale();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string nume = textBox1.Text.ToString();
string functie = textBox2.Text.ToString();
string sal = textBox3.Text.ToString();
float sal1 = 0;
bool salariu = float.TryParse(sal, out sal1);
if (nume == "" || functie == "" || sal == "")
{
MessageBox.Show("Campuri incomplete !", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var context = new Parc_AutoDataContext();
var angajat = new Angajati
{
Nume = nume,
Functie = functie,
Salariu_baza = sal1
};
context.Angajatis.InsertOnSubmit(angajat);
context.SubmitChanges();
MessageBox.Show("Ati adaugat cu succes !", "Confirmare", MessageBoxButtons.OK);
this.Close();
return;
}
}
public static void insertAngajati(Angajati angj)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Conexiunea la baza de date nu s-a realizat.");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO angajati(email,parola,nume,prenume,acces) VALUES(@email,@parola,@nume,@prenume,@acces)";
cmd.Parameters.AddWithValue("@email", angj.Email);
cmd.Parameters.AddWithValue("@parola", angj.Parola);
cmd.Parameters.AddWithValue("@nume", angj.Nume);
cmd.Parameters.AddWithValue("@prenume", angj.Prenume);
cmd.Parameters.AddWithValue("@acces", angj.Acces);
if (cmd.ExecuteNonQuery() != 1)
{
throw new Exception("Modificarea nu s-a putut face");
}
con.Close();
}
private void ManageAngajati_Load(object sender, EventArgs e)
{
Angajati angj = new Angajati();
tabelAngajati.DataSource = MagazinDAO.afisareAngajati(angj);
}
public void AddAngajat(Angajati a)
{
throw new Exception("Optiunea AddAngajat este implementata");
}
public bool UpdateAngajat(Angajati AngajatActualizat)
{
throw new Exception("Optiunea UpdateAngajati nu este implementata");
}
public void arataAngajati()
{
Angajati angj = new Angajati();
tabelAngajati.DataSource = MagazinDAO.afisareAngajati(angj);
}
