/// <summary>
/// Get a family in database.
/// </summary>
/// <param name="Id"><b>Id</b>The Id of the SubFamily to find.</param>
public static List <SousFamillesModel> SelectByFamille(int RefFamille)
{
List <SousFamillesModel> SousFamilles = new List <SousFamillesModel>();
SQLiteConnection Connection = DaoContext.Connection;
Connection.Open();
using (SQLiteCommand Cmd = Connection.CreateCommand())
{
Cmd.CommandText = @"SELECT * FROM SousFamilles WHERE RefFamille = @RefFamille;";
Cmd.Parameters.AddWithValue("@RefFamille", RefFamille);
using (SQLiteDataReader reader = Cmd.ExecuteReader())
{
while (reader.Read())
{
SousFamilles.Add(new SousFamillesModel(int.Parse(reader["RefSousFamille"].ToString()),
FamillesDao.SelectByID(int.Parse(reader["RefFamille"].ToString())), reader["Nom"].ToString()));
}
reader.Close();
}
}
Connection.Close();
return(SousFamilles);
}
/// <summary>
/// Get a family in database.
/// </summary>
/// <param name="Id"><b>Id</b>The Id of the SubFamily to find.</param>
public static SousFamillesModel SelectByID(int Id)
{
bool IsOpenHere = false;
SousFamillesModel SousFamille = null;
SQLiteConnection Connection = DaoContext.Connection;
if (Connection.State == ConnectionState.Closed)
{
Connection.Open(); IsOpenHere = true;
}
using (SQLiteCommand Cmd = Connection.CreateCommand())
{
Cmd.CommandText = @"SELECT * FROM SousFamilles WHERE RefSousFamille = @RefSousFamille;";
Cmd.Parameters.AddWithValue("@RefSousFamille", Id);
SQLiteDataReader reader = Cmd.ExecuteReader();
while (reader.Read())
{
SousFamille = new SousFamillesModel(FamillesDao.SelectByID(int.Parse(reader["RefFamille"].ToString())), reader["Nom"].ToString());
}
reader.Close();
}
if (Connection.State == ConnectionState.Open && IsOpenHere)
{
Connection.Close();
}
return(SousFamille);
}
/// <summary>
/// Method used to select a list of subfamilies.
/// </summary>
public static List <SousFamillesModel> SelectAll()
{
bool IsOpenHere = false;
List <SousFamillesModel> AllTable = new List <SousFamillesModel>();
SousFamillesModel SousFamille = null;
SQLiteConnection Connection = DaoContext.Connection;
if (Connection.State == ConnectionState.Closed)
{
Connection.Open(); IsOpenHere = true;
}
using (SQLiteCommand Cmd = Connection.CreateCommand())
{
Cmd.CommandText = @"SELECT * FROM SousFamilles;";
SQLiteDataReader reader = Cmd.ExecuteReader();
while (reader.Read())
{
SousFamille = new SousFamillesModel(int.Parse(reader["RefSousFamille"].ToString()), FamillesDao.SelectByID(int.Parse(reader["RefFamille"].ToString())), reader["Nom"].ToString());
AllTable.Add(SousFamille);
}
reader.Close();
}
if (Connection.State == ConnectionState.Open && IsOpenHere)
{
Connection.Close();
}
return(AllTable);
}