private void buttonAjouter_Click(object sender, EventArgs e) { Categorie C = new Categorie(); C.Nom = this.TBnom.Text; CategorieDB.Insert(C); this.Close(); }
public static Categorie Get(Int32 Identifiant) { Categorie categorie = new Categorie(); //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = select+" WHERE Identifiant = @Identifiant;"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("Identifiant", Identifiant); //Execution try { connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); while (dataReader.Read()) { categorie.Identifiant = dataReader.GetInt32(0); categorie.Nom = dataReader.GetString(1); } dataReader.Close(); } catch (Exception) { categorie = null; } finally { connection.Close(); } return categorie; }
public static Boolean Insert(Categorie categorie) { //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = @"INSERT INTO Categorie ("+champs+") VALUES (@Nom);"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("Nom", categorie.Nom); //Execution try { connection.Open(); commande.ExecuteNonQuery(); return true; } catch (Exception) { return false; } finally { connection.Close(); } }
public static Boolean Update(Categorie categorie) { //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = @"UPDATE Categorie SET Nom=@Nom WHERE Identifiant=@Identifiant ;"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("Identifiant",categorie.Identifiant); commande.Parameters.AddWithValue("Nom",categorie.Nom ); //Execution try { connection.Open(); commande.ExecuteNonQuery(); return true; } catch (Exception) { return false; } finally { connection.Close(); } }
public static List<Categorie> List() { List<Categorie> listeCategorie = new List<Categorie>(); //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = select+";"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres //Execution try { connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); while (dataReader.Read()) { Categorie categorie = new Categorie(); categorie.Identifiant = dataReader.GetInt32(0); categorie.Nom = dataReader.GetString(1); listeCategorie.Add(categorie); } dataReader.Close(); } catch (Exception) { listeCategorie = null; } finally { connection.Close(); } return listeCategorie; }