public static bool estDRH(string nomRH) { bool drh = false; int id_dep = 0; using (var conn = new NpgsqlConnection(Connexion.ConnectOdoo())) { conn.Open(); using (var cmd = new NpgsqlCommand("SELECT department_id FROM hr_employee WHERE name = '" + nomRH + "'", conn)) using (var reader = cmd.ExecuteReader()) while (reader.Read()) { id_dep = reader.GetInt32(0); } conn.Close(); conn.Open(); string nom_dep = ""; using (var cmd = new NpgsqlCommand("SELECT name FROM hr_department WHERE id = " + id_dep, conn)) using (var reader = cmd.ExecuteReader()) while (reader.Read()) { nom_dep = reader.GetString(0); } if (nom_dep == "DRH") { drh = true; } conn.Close(); } return(drh); }
public Authentification() { InitializeComponent(); Connexion.ConnectOdoo(); foreach (string nom in DAOConnectOdoo.GetNomRH()) { listeRH.Items.Add(nom); } }
public static List <string> GetNomRH() { List <string> lesNoms = new List <string>(); using (var conn = new NpgsqlConnection(Connexion.ConnectOdoo())) { conn.Open(); using (var cmd = new NpgsqlCommand("SELECT hr_employee.name FROM hr_employee INNER JOIN hr_department ON hr_employee.department_id = hr_department.id", conn)) using (var reader = cmd.ExecuteReader()) while (reader.Read()) { lesNoms.Add(reader.GetString(0)); } conn.Close(); } return(lesNoms); }