/// <summary>
/// Lire les produits consideré comme commande en cours, status = 0, dans la table CommandeLines
/// </summary>
/// <returns>Retune la liste de tous les produits</returns>
public List <CommandeLines> ReadCommandes()
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT commandelines.id, commandelines.OrderDate,commandelines.ArrivalDate, products.name AS Produit, unities.Name AS Unitie, categories.name AS categorie, commandelines.status AS status, commandelines.Quantity, commandelines.Peremption FROM commandelines inner JOIN products ON commandelines.Products_id = products.id inner JOIN suppliers ON commandelines.Suppliers_id = suppliers.id INNER JOIN categories ON products.Categories_id = categories.id INNER JOIN unities ON commandelines.Unities_id = unities.id WHERE commandelines.Status = 0 OR commandelines.Status = 2 ORDER BY DATE(commandelines.OrderDate) desc;";
List <CommandeLines> list = new List <CommandeLines>();
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int id = (int)dataReader["id"];
string nameproduit = dataReader["Produit"].ToString();
string unities = dataReader["Unitie"].ToString();
int quantity = (int)dataReader["Quantity"];
string orderday = dataReader["OrderDate"].ToString();
int status = (int)dataReader["status"];
string datearrival = dataReader["ArrivalDate"].ToString();
//Transformer la date
string formatDateOrderDay = DateTime.Parse(orderday).ToString("yyyy/MM/dd");
//S'il le jour existe
if (datearrival != "")
{
//Transformer la date
datearrival = DateTime.Parse(datearrival).ToString("yyyy/MM/dd");
}
CommandeLines dataUnities = new CommandeLines(id, nameproduit, unities, quantity, formatDateOrderDay, status, datearrival);
list.Add(dataUnities);
}
return(list);
}
/// <summary>
/// Lire les produis consideré comme stock, status = 1, dans la table CommandeLines
/// </summary>
/// <returns>Retune la liste de tous les produits</returns>
public List <CommandeLines> ReadStock()
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT commandelines.id, products.name AS Produit, categories.name AS categorie, unities.Name AS Unitie, commandelines.Quantity, commandelines.Peremption FROM commandelines inner JOIN products ON commandelines.Products_id = products.id LEFT JOIN suppliers ON commandelines.Suppliers_id = suppliers.id INNER JOIN categories ON products.Categories_id = categories.id INNER JOIN unities ON commandelines.Unities_id = unities.id WHERE commandelines.Status = 1 OR 2";
List <CommandeLines> list = new List <CommandeLines>();
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int id = (int)dataReader["id"];
string nameproduit = dataReader["Produit"].ToString();
string namecategorie = dataReader["categorie"].ToString();
string unities = dataReader["Unitie"].ToString();
int quantity = (int)dataReader["Quantity"];
string Peremption = dataReader["Peremption"].ToString();
//S'il le jour existe
if (Peremption != "")
{
//Transformer la date
Peremption = DateTime.Parse(Peremption).ToString("yyyy/MM/dd");
}
CommandeLines dataUnities = new CommandeLines(id, nameproduit, namecategorie, quantity, unities, Peremption);
list.Add(dataUnities);
}
//string thisDay = System.DateTime.Now.ToString("yyyy/MM/dd");
return(list);
}
