/// <summary>
/// Return all element in the table sousFamille
/// </summary>
/// <returns></returns>
public override HashSet <SousFamille> GetAll()
{
OpenConnection();
HashSet <SousFamille> Liste = new HashSet <SousFamille>();
var Result = ExecuteSelect("SELECT * FROM " + TableName + " ORDER BY Nom");
FamilleControl FCont = new FamilleControl();
while (Result.Read())
{
SousFamille ChildFamily = new SousFamille(Result.GetString(2), FCont.FindByRef(Result.GetInt32(1)), Result.GetInt16(0));
Liste.Add(ChildFamily);
}
CloseConnection();
return(Liste);
}
/// <summary>
/// Check If the famille exist, true if exist
/// </summary>
/// <param name="Family"></param>
/// <returns></returns>
public bool CheckFamille(Famille Family)
{
if (Family == null)
{
return(false);
}
FamilleControl FCont = new FamilleControl();
if (FCont.FindByRef(Family.RefFamille) == null)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// Return the sousfamille object from the database with his ref
/// </summary>
/// <param name="Ref"></param>
/// <returns></returns>
public override SousFamille FindByRef(int Ref)
{
OpenConnection();
var Result = ExecuteSelect("SELECT Nom,RefFamille,RefSousFamille FROM " + TableName + " WHERE " + RefName + " = " + Ref);
SousFamille ChildFamily = null;
FamilleControl FCont = new FamilleControl();
if (Result.Read())
{
ChildFamily = new SousFamille(Result.GetString(0), FCont.FindByRef(Result.GetInt32(1)), Result.GetInt16(2));
}
else
{
ChildFamily = null;
}
CloseConnection();
return(ChildFamily);
}
