/// <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); }