public static Vernis Get(Int32 Identifiant) { Vernis vernis = new Vernis(); //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(); dataReader.Read(); vernis.Identifiant = dataReader.GetInt32(0); vernis.Reference = dataReader.GetString(1); vernis.Min = dataReader.GetInt32(2); vernis.Norme = dataReader.GetInt32(3); vernis.Max = dataReader.GetInt32(4); dataReader.Close(); } catch (Exception) { vernis = null; } finally { connection.Close(); } return vernis; }
public static Boolean Insert(Vernis vernis) { //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = @"INSERT INTO Vernis (" + champs + ") VALUES (@Reference,@Min,@Norme,@Max);"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("Reference", vernis.Reference); commande.Parameters.AddWithValue("Min", vernis.Min); commande.Parameters.AddWithValue("Norme", vernis.Norme); commande.Parameters.AddWithValue("Max", vernis.Max); //Execution try { connection.Open(); commande.ExecuteNonQuery(); return true; } catch (Exception) { return false; } finally { connection.Close(); } }
public static Boolean Update(Vernis vernis) { //Connection SqlConnection connection = DataBase.Connection(); //Requete String requete = @"UPDATE Vernis SET Reference=@Reference,Min=@Min,Norme=@Norme,Max=@Max WHERE Identifiant=@Identifiant ;"; //Commande SqlCommand commande = new SqlCommand(requete, connection); //Parametres commande.Parameters.AddWithValue("Identifiant", vernis.Identifiant); commande.Parameters.AddWithValue("Reference", vernis.Reference); commande.Parameters.AddWithValue("Min", vernis.Min); commande.Parameters.AddWithValue("Norme", vernis.Norme); commande.Parameters.AddWithValue("Max", vernis.Max); //Execution try { connection.Open(); commande.ExecuteNonQuery(); return true; } catch (Exception) { return false; } finally { connection.Close(); } }
public static List<Vernis> List() { List<Vernis> listeVernis = new List<Vernis>(); //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()) { Vernis vernis = new Vernis(); vernis.Identifiant = dataReader.GetInt32(0); vernis.Reference = dataReader.GetString(1); vernis.Min = dataReader.GetInt32(2); vernis.Norme = dataReader.GetInt32(3); vernis.Max = dataReader.GetInt32(4); listeVernis.Add(vernis); } dataReader.Close(); return listeVernis; } catch (Exception) { listeVernis = null; } finally { connection.Close(); } return listeVernis; }