public List <Articles> GetAllArticles()
{
Query = "select * from Articles;";
SQLiteCommand Command = new SQLiteCommand(Query, Connection);
Command.ExecuteNonQuery();
var Reader = Command.ExecuteReader();
var Articles = new List <Articles>();
MarquesDao MarquesDao = new MarquesDao();
FamillesDao FamillesDao = new FamillesDao();
SousFamillesDao SousFamillesDao = new SousFamillesDao();
while (Reader.Read())
{
var RefArticle = Reader.GetString(0);
var Description = Reader.GetString(1);
var SousFamille = SousFamillesDao.FindSousFamilleByRefSousFamille(Reader.GetInt32(2));
var Marque = MarquesDao.FindMarqueByRefMarque(Reader.GetInt32(3));
var PrixHTs = Reader.GetString(4);
var PrixHT = double.Parse(PrixHTs);
var Quantite = Reader.GetInt32(5);
Articles.Add(new Articles(RefArticle, Description, FamillesDao.FindFamillesByRefSousFamille(SousFamille.RefSousFamille), SousFamille, Marque, PrixHT, Quantite));
}
Reader.Close();
return(Articles);
}
public Articles FindArticlesByRefArticle(string RefArticle)
{
Query = "SELECT * FROM Articles WHERE RefArticle = '" + RefArticle + "'";
SQLiteCommand Command = new SQLiteCommand(Query, Connection);
var Reader = Command.ExecuteReader();
if (Reader.Read())
{
var Description = Reader.GetString(1);
var RefSousFamille = Reader.GetInt32(2);
var RefMarque = Reader.GetInt32(3);
var PrixHTs = Reader.GetString(4);
var PrixHT = double.Parse(PrixHTs);
var Quantite = Reader.GetInt32(5);
FamillesDao FamillesDao = new FamillesDao();
SousFamillesDao SousFamillesDao = new SousFamillesDao();
MarquesDao MarquesDao = new MarquesDao();
Articles Article = new Articles(RefArticle, Description, FamillesDao.FindFamillesByRefSousFamille(RefSousFamille),
SousFamillesDao.FindSousFamilleByRefSousFamille(RefSousFamille),
MarquesDao.FindMarqueByRefMarque(RefMarque), PrixHT, Quantite);
Reader.Close();
return(Article);
}
else
{
return(null);
}
}
public List <Articles> FindArticlesBySousFamilleName(string SousFamilleName)
{
Query = "SELECT * FROM Articles WHERE RefSousFamille = (SELECT RefSousFamille FROM SousFamilles WHERE Nom = '" + SousFamilleName + "')";
SQLiteCommand Command = new SQLiteCommand(Query, Connection);
var Reader = Command.ExecuteReader();
List <Articles> Articles = new List <Articles>();
FamillesDao FamillesDao = new FamillesDao();
SousFamillesDao SousFamillesDao = new SousFamillesDao();
MarquesDao MarquesDao = new MarquesDao();
while (Reader.Read())
{
var RefArticle = Reader.GetString(0);
var Description = Reader.GetString(1);
var RefSousFamille = Reader.GetInt32(2);
var RefMarque = Reader.GetInt32(3);
var PrixHTs = Reader.GetString(4);
var PrixHT = double.Parse(PrixHTs);
var Quantite = Reader.GetInt32(5);
Articles Article = new Articles(RefArticle, Description, FamillesDao.FindFamillesByRefSousFamille(RefSousFamille),
SousFamillesDao.FindSousFamilleByRefSousFamille(RefSousFamille),
MarquesDao.FindMarqueByRefMarque(RefMarque), PrixHT, Quantite);
Articles.Add(Article);
}
Reader.Close();
return(Articles);
}
/// <summary>
/// The constructor of SousFamillesDao.
/// </summary>
public SousFamillesDao()
{
this.Connection = Util.GetConnection.ConnectionSQLite();
this.FamilleDao = new FamillesDao();
this.Query = null;
}