public int UpdateEmploye(EmployeDTO employeDTO,int id)
{
try
{
return employeDAO.Update(employeDTO,id);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
/// <inheritdoc />
public int AddEmploye(EmployeDTO employeDTO)
{
try
{
return employeDAO.Add(employeDTO);
}
catch (DAOException daoException)
{
throw new ServiceException(daoException.Message);
}
}
private void VerificationLogin()
{
EmployeService employe = new EmployeService();
EmployeDTO emp = new EmployeDTO();
int id = Int32.Parse(txtID.Text);
string motPasse = txtPassword.Text;
try
{
//connexion.Open();
emp = employe.ReadEmploye(id);
if (txtID.Equals(null))
{
IDRequis.Visible = true;
}else if(motPasse.Equals(null)){
passRequis.Visible = true;
}
else if (emp.IdEmploye != id || emp.MotPasse != motPasse)
{
IDRequis.Visible = false;
passRequis.Visible = false;
MessageBox.Show("Votre ID ou votre mot de passe est invalide!");
// INVALID PASS
}
else
{
// SUCCESSFUL LOGIN
Session["UserAuthentication"] = emp.IdEmploye;
Response.Redirect("Manage.aspx");
}
}
catch (MySqlException mySqlException)
{
throw new Exception(mySqlException.Message);
}
//finally
//{
// //connexion.Close();
//}
}
private void VerifierLogin()
{
EmployeService employe = new EmployeService();
EmployeDTO emp = new EmployeDTO();
UserId = Int32.Parse(txtID.Text);
string motPasse = txtPassword.Text;
try
{
emp = employe.ReadEmploye(UserId);
if (txtID.Text == string.Empty)
{
IDRequis.Show();
}
else if (txtPassword.Text == string.Empty)
{
passRequis.Show();
}
else if (emp.IdEmploye != UserId || emp.MotPasse != motPasse)
{
IDRequis.Hide();
passRequis.Hide();
MessageBox.Show("Votre ID ou votre mot de passe est invalide!");
}
else
{
this.Hide();
Form1 form1 = new Form1();
form1.Show();
}
}
catch (MySqlException mySqlException)
{
throw new Exception(mySqlException.Message);
}
}
public int Add(EmployeDTO employeDTO)
{
int n = 0;
try
{
connexion.Open();
command.CommandText = ADD_REQUEST;
command.Parameters.Add(new MySqlParameter("@nom", employeDTO.Nom));
command.Parameters.Add(new MySqlParameter("@poste", employeDTO.Poste));
command.Parameters.Add(new MySqlParameter("@matricule", employeDTO.Matricule));
command.Parameters.Add(new MySqlParameter("@motPasse", employeDTO.MotPasse));
n = command.ExecuteNonQuery();
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return n;
}
public EmployeDTO Read(int id)
{
EmployeDTO employeDTO = new EmployeDTO();
try
{
connexion.Open();
command.CommandText = READ_REQUEST;
command.Parameters.Add(new MySqlParameter("@idEmploye", id));
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
employeDTO.IdEmploye = dr.GetInt32(0);
employeDTO.Nom = dr.GetString(1);
employeDTO.Poste = dr.GetString(2);
employeDTO.Matricule = dr.GetInt32(3);
employeDTO.MotPasse = dr.GetString(4);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return employeDTO;
}
public List<EmployeDTO> GetAll()
{
List<EmployeDTO> employes = new List<EmployeDTO>();
try
{
EmployeDTO employeDTO = new EmployeDTO();
connexion.Open();
command.CommandText = GET_ALL_REQUEST;
MySqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
employeDTO.IdEmploye = dr.GetInt32(0);
employeDTO.Nom = dr.GetString(1);
employeDTO.Poste = dr.GetString(2);
employeDTO.Matricule = dr.GetInt32(3);
employeDTO.MotPasse = dr.GetString(4);
employes.Add(employeDTO);
}
}
catch (MySqlException mySqlException)
{
throw new DAOException(mySqlException.Message);
}
finally
{
connexion.Close();
}
return employes;
}