public static void AjoutCritere(Critere unCritere, Associer uneAssociation, int unIdOffre) { using (var conn = new NpgsqlConnection(Connexion.Connecter())) { conn.Open(); // Insert some data using (var cmd = new NpgsqlCommand()) { cmd.Connection = conn; cmd.CommandText = "INSERT INTO critere (id_critere, libelle_critere) VALUES (DEFAULT, '" + unCritere.GetLibelle() + "')"; cmd.ExecuteNonQuery(); } int id = -1; using (var cmd2 = new NpgsqlCommand("SELECT id_critere FROM critere ORDER BY id_critere", conn)) using (var reader = cmd2.ExecuteReader()) while (reader.Read()) { id = reader.GetInt32(0); } using (var cmd3 = new NpgsqlCommand()) { cmd3.Connection = conn; cmd3.CommandText = "INSERT INTO associer (id_critere, id_offre, coefficient) VALUES (" + id + ", " + unIdOffre + "," + uneAssociation.GetCoeff() + ")"; cmd3.ExecuteNonQuery(); } conn.Close(); } }
public static List <Associer> GetLesAssociations() { List <Associer> listAssociation = new List <Associer>(); using (var conn = new NpgsqlConnection(Connexion.Connecter())) { conn.Open(); using (var cmd = new NpgsqlCommand("SELECT coefficient, id_critere, id_offre FROM associer ORDER BY id_critere", conn)) using (var reader = cmd.ExecuteReader()) while (reader.Read()) { Associer uneAssociation = new Associer(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2)); listAssociation.Add(uneAssociation); } conn.Close(); } return(listAssociation); }
private void buttonAjouter_Click(object sender, EventArgs e) { string libelle = txtNom.Text; string coeffText = txtCoeff.Text; int coeff; if (coeffText != "" && libelle != "") { coeff = int.Parse(coeffText); Critere unCritere = new Critere(libelle); Associer uneAssociation = new Associer(coeff); DAOCritere.AjoutCritere(unCritere, uneAssociation, idOffre); Valider.Visible = true; Valider.Text = "Envoyé !"; } else { MessageBox.Show("Vous devez completer tout les champs !"); } this.Close(); }