/// <summary>
/// Retrieve all Famille
/// </summary>
/// <returns>List of Famille</returns>
public static List<Famille> GetAll()
{
List<Famille> listFamille = new List<Famille>();
using (SqlConnection db = DbConnexion.connect())
{
string sql = "SELECT NumFamille, LibelleFamille FROM Famille";
using (SqlCommand req = new SqlCommand(sql, db))
{
SqlDataReader row = req.ExecuteReader();
while (row.Read())
{
Famille famille = new Famille();
famille.Num = int.Parse(row.GetValue(0).ToString());
famille.Libelle = row.GetValue(1).ToString();
listFamille.Add(famille);
}
}
}
return listFamille;
}
/// <summary>
/// Retrieve all Categories of the Famille
/// </summary>
/// <param name="famille"></param>
/// <returns>List of Categorie</returns>
public static List<Categorie> GetByFamille(Famille famille)
{
List<Categorie> listTickets = new List<Categorie>();
using (SqlConnection db = DbConnexion.connect())
{
string sql = "SELECT NumCategorie, LibelleCategorie, NumFamille FROM Categorie c WHERE c.NumFamille = @NumFamille";
using (SqlCommand req = new SqlCommand(sql, db))
{
req.Parameters.Add(new SqlParameter("NumFamille", famille.Num));
SqlDataReader row = req.ExecuteReader();
while (row.Read())
{
Categorie categorie = new Categorie();
categorie.Num = int.Parse(row.GetValue(0).ToString());
categorie.Libelle = row.GetValue(1).ToString();
categorie.Famille = famille;
listTickets.Add(categorie);
}
}
}
return listTickets;
}
/// <summary>
/// Retrieve the Famille by its num
/// </summary>
/// <param name="numFamille"></param>
/// <returns>Famille</returns>
public static Famille Get(int numFamille)
{
Famille famille = new Famille();
using (SqlConnection db = DbConnexion.connect())
{
string sql = "SELECT NumFamille, LibelleFamille FROM Famille f WHERE f.numFamille = @NumFamille";
using (SqlCommand req = new SqlCommand(sql, db))
{
req.Parameters.Add(new SqlParameter("NumFamille", numFamille));
SqlDataReader row = req.ExecuteReader();
if (row.Read())
{
famille.Num = int.Parse(row.GetValue(0).ToString());
famille.Libelle = row.GetValue(1).ToString();
}
}
}
return famille;
}
public void Fill()
{
// Initialize the Family's List
List<Famille> listFamilles = FamilleDAO.GetAll();
Famille blankRow = new Famille();
blankRow.Libelle = "";
listFamilles.Insert(0, blankRow);
// Family ComboBox Data Source
_view.Familles = listFamilles;
// Articles Default Data Source
_view.Articles = source;
source.ResetBindings(false);
}
