public static PosteTravail getOneById(int id, bool full)
{
PosteTravail bean = new PosteTravail();
NpgsqlConnection connect = new Connexion().Connection();
try
{
string query = "select * from yvs_grh_poste_employes where id =" + id + ";";
NpgsqlCommand Lcmd = new NpgsqlCommand(query, connect);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
bean = Return(lect, full);
}
}
return(bean);
}
catch (Exception ex)
{
Messages.Exception("PosteTravailDAO (getOneById) ", ex);
return(bean);
}
finally
{
Connexion.Close(connect);
}
}
private static PosteTravail Return(NpgsqlDataReader lect, bool full)
{
PosteTravail bean = new PosteTravail();
bean.Id = Convert.ToInt32(lect["id"].ToString());
bean.Poste = PosteDAO.getOneById(Convert.ToInt32(lect["poste"].ToString()));
bean.Poste = new Poste(Convert.ToInt32(lect["poste"].ToString()));
if (full)
{
bean.Poste = PosteDAO.getOneById(Convert.ToInt32(lect["poste"].ToString()));
}
return(bean);
}
