/// <summary>
/// Get one sub family by name or id
/// </summary>
/// <param name="Name"> The name of the sub family to get </param>
/// <param name="Id"> The id of the sub family to get </param>
/// <returns> The sub family searched </returns>
public SousFamilles GetSousFamille(string Name = "", int Id = -1)
{
SousFamilles SousFamille = new SousFamilles();
SQLiteCommand Sql;
if (Name.CompareTo("") != 0)
{
Sql = new SQLiteCommand("SELECT * FROM SousFamilles WHERE Nom = @name", Conn);
Sql.Parameters.AddWithValue("@name", Name);
}
else
{
Sql = new SQLiteCommand("SELECT * FROM SousFamilles WHERE RefSousFamille = @idSousFamille", Conn);
Sql.Parameters.AddWithValue("@idSousFamille", Id);
}
SQLiteDataReader Reader = Sql.ExecuteReader();
if (Reader.Read())
{
SousFamille.ConvertDataReaderToSousFamilles(Reader);
return(SousFamille);
}
else
{
return(null);
}
}
/// <summary>
/// Get all sub family
/// </summary>
/// <returns>A dictionnary of the sub family</returns>
public Dictionary <int, SousFamilles> GetAllSousFamilles()
{
Dictionary <int, SousFamilles> ListSousFamille = new Dictionary <int, SousFamilles>();
SQLiteCommand Sql = new SQLiteCommand("SELECT * FROM SousFamilles", Conn);
SQLiteDataReader Reader = Sql.ExecuteReader();
while (Reader.Read())
{
SousFamilles SousFamille = new SousFamilles();
SousFamille.ConvertDataReaderToSousFamilles(Reader);
ListSousFamille.Add(SousFamille.Id, SousFamille);
}
return(ListSousFamille);
}
/// <summary>
/// Get all sub families belonging to a family
/// </summary>
/// <param name="IdFamily"> The id of a family </param>
/// <returns> The list of sub family belonging to a family </returns>
public Dictionary <int, SousFamilles> GetAllSubFamiliesFromFamily(int IdFamily)
{
Dictionary <int, SousFamilles> ListSubFamily = new Dictionary <int, SousFamilles>();
SQLiteCommand Sql = new SQLiteCommand("SELECT * FROM SousFamilles WHERE RefFamille = @idFamily", Conn);
Sql.Parameters.AddWithValue("@idFamily", IdFamily);
SQLiteDataReader Reader = Sql.ExecuteReader();
while (Reader.Read())
{
SousFamilles SubFamily = new SousFamilles();
SubFamily.ConvertDataReaderToSousFamilles(Reader);
ListSubFamily.Add(SubFamily.Id, SubFamily);
}
return(ListSubFamily);
}
