/// <summary>
/// Find an article with the reference
/// </summary>
/// <param name="Ref"></param>
/// <returns></returns>
public Article FindByRef(string Ref)
{
OpenConnection();
var Result = ExecuteSelect("SELECT * FROM " + TableName + " WHERE " + RefName + " = '" + Ref + "'");
Article Arti;
SousFamilleControl SFCont = new SousFamilleControl();
MarqueControl MCont = new MarqueControl();
if (Result.Read())
{
Arti = new Article(
Result.GetString(0),
Result.GetString(1),
Result.GetFloat(4),
Result.GetInt16(5),
MCont.FindByRef(Result.GetInt16(3)),
SFCont.FindByRef(Result.GetInt16(2)));
}
else
{
Arti = null;
}
CloseConnection();
return(Arti);
}
/// <summary>
/// Check Article param except Reference, return true if its ok
/// </summary>
/// <param name="Arti"></param>
/// <returns></returns>
public bool CheckParam(Article Arti)
{
if (Arti == null ||
Arti.SousFamille == null ||
Arti.PrixHT < 0 ||
Arti.Quantite < 0 ||
Arti.Marque == null)
{
return(false);
}
MarqueControl MCont = new MarqueControl();
SousFamilleControl SFCont = new SousFamilleControl();
if (MCont.FindByRef(Arti.Marque.RefMarque) == null ||
SFCont.FindByRef(Arti.SousFamille.RefSousFamille) == null)
{
return(false);
}
return(true);
}
/// <summary>
/// Get all existant article
/// </summary>
/// <returns></returns>
public override HashSet <Article> GetAll()
{
OpenConnection();
HashSet <Article> Liste = new HashSet <Article>();
var Result = ExecuteSelect("SELECT * FROM " + TableName);
SousFamilleControl SFCont = new SousFamilleControl();
MarqueControl MCont = new MarqueControl();
while (Result.Read())
{
Article Arti = new Article(
Result.GetString(0),
Result.GetString(1),
Result.GetFloat(4),
Result.GetInt16(5),
MCont.FindByRef(Result.GetInt16(3)),
SFCont.FindByRef(Result.GetInt16(2)));
Liste.Add(Arti);
}
CloseConnection();
return(Liste);
}
