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;
}
