public static SousCat Get(Int32 Identifiant)
{
SousCat sousCat = new SousCat();
//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();
sousCat.Identifiant = dataReader.GetInt32(0);
sousCat.Nom= dataReader.GetString(1);
sousCat.ID_Categorie = dataReader.GetInt32(2);
dataReader.Close();
}
catch (Exception)
{
sousCat = null;
}
finally
{
connection.Close();
}
return sousCat;
}
public static Boolean Insert(SousCat sousCat)
{
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = @"INSERT INTO SousCat (" + champs + ") VALUES (@Nom,@ID_Categorie);";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("Nom", sousCat.Nom);
commande.Parameters.AddWithValue("ID_Categorie", sousCat.ID_Categorie);
//Execution
try
{
connection.Open();
commande.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
finally
{
connection.Close();
}
}
public static Boolean Update(SousCat sousCat)
{
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = @"UPDATE SousCat
SET Nom=@Nom,ID_Categorie=@ID_Categorie
WHERE Identifiant=@Identifiant ;";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("Identifiant",sousCat.Identifiant);
commande.Parameters.AddWithValue("Nom",sousCat.Nom );
commande.Parameters.AddWithValue("ID_Categorie", sousCat.ID_Categorie);
//Execution
try
{
connection.Open();
commande.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
finally
{
connection.Close();
}
}
public static List<SousCat> List(Int32 ID_Categorie)
{
List<SousCat> listeSousCat = new List<SousCat>();
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = select + " WHERE ID_Categorie=@ID_Categorie;";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("ID_Categorie", ID_Categorie);
//Execution
try
{
connection.Open();
SqlDataReader dataReader = commande.ExecuteReader();
while (dataReader.Read())
{
SousCat sousCat = new SousCat();
sousCat.Identifiant = dataReader.GetInt32(0);
sousCat.Nom = dataReader.GetString(1);
sousCat.ID_Categorie = dataReader.GetInt32(2);
listeSousCat.Add(sousCat);
}
dataReader.Close();
}
catch (Exception)
{
listeSousCat = null;
}
finally
{
connection.Close();
}
return listeSousCat;
}