public static Droits findAdmin(string Admin)
{
Droits droits = null;
OdbcCommand cmd = new OdbcCommand("select * from droits where admin=?", AccesBd.getConnection());
cmd.Parameters.Add("@numero", OdbcType.VarChar).Value = Admin;
OdbcDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
droits = new Droits {
Id = dr.GetInt32(0), admin = AdminDao.findByNumero(dr.GetString(1)), Table = dr.GetString(2), Consulter = dr.GetString(3), Ajouter = dr.GetString(4), Modifier = dr.GetString(5), Supprimer = dr.GetString(6)
};
}
cmd.Dispose();
return(droits);
}
public static Versement findByNumero(string numero)
{
Versement versement = null;
OdbcCommand cmd = new OdbcCommand("select * from versement where Numero=?", AccesBd.getConnection());
cmd.Parameters.Add("@numero", OdbcType.VarChar).Value = numero;
OdbcDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
versement = new Versement {
Id = dr.GetInt32(0), Numero = dr.GetString(1), Montant = dr.GetDouble(3), Description = dr.GetString(2), Date = dr.GetDateTime(4), carte = CarteDao.findByNumero(dr.GetString(5)), admin = AdminDao.findByNumero(dr.GetString(6))
};
}
cmd.Dispose();
return(versement);
}