public static IEnumerable <Commandes> getCommandes()
{
IEnumerable <Commandes> commandes = new List <Commandes>();
DataTable dt;
Commandes commande;
Serreurs er = new Serreurs("Erreur sur lecture des commandes.", "CommandesList.getCommandes()");
try
{
string mysql = "SELECT c.NO_COMMAND, c.NO_VENDEUR, c.NO_CLIENT, c.DATE_CDE, ";
mysql += "c.FACTURE, count(d.NO_COMMAND) NB_ARTICLES ";
mysql += "FROM commandes c LEFT OUTER JOIN detail_cde d ";
mysql += "ON c.NO_COMMAND=d.NO_COMMAND GROUP BY c.NO_COMMAND ORDER BY c.NO_COMMAND";
dt = DBInterface.Lecture(mysql, er);
foreach (DataRow dataRow in dt.Rows)
{
commande = new Commandes();
commande.NoCommande = dataRow[0].ToString();
String noVendeur = dataRow[1].ToString();
commande.NoVendeur = Vendeur.getVendeurById(noVendeur);
String noClient = dataRow[2].ToString();
commande.NoClient = Clientel.getClientById(noClient);
Match match = Regex.Match(dataRow[3].ToString(), pattern);
String temp = match.Groups[3].Value + "-" + match.Groups[2].Value + "-" + match.Groups[1].Value;
commande.DateCde = temp;
commande.Facture = dataRow[4].ToString();
commande.NbArticle = dataRow[5].ToString();
((List <Commandes>)commandes).Add(commande);
}
return(commandes);
}
catch (MonException e)
{
throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message);
}
catch (MySqlException e)
{
throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message);
}
}
/// <summary>
/// Lire une commande sur son ID
/// </summary>
/// <param name="numCom">N° de la commande à lire</param>
public static Commandes getCommande(String numCom)
{
String mysql;
DataTable dt;
Serreurs er = new Serreurs("Erreur sur recherche d'une commande.", "Commandes.RechercheUneCommande()");
try
{
mysql = "SELECT c.NO_VENDEUR, c.NO_CLIENT, c.DATE_CDE, ";
mysql += "c.FACTURE, count(*) NB_ARTICLES ";
mysql += "FROM commandes c LEFT OUTER JOIN detail_cde d ON c.NO_COMMAND=d.NO_COMMAND ";
mysql += "WHERE c.NO_COMMAND='" + numCom + "' GROUP BY c.NO_COMMAND";
dt = DBInterface.Lecture(mysql, er);
System.Console.WriteLine(mysql);
if (dt.IsInitialized && dt.Rows.Count > 0)
{
Commandes commande = new Commandes();
DataRow dataRow = dt.Rows[0];
commande.NoCommande = numCom;
String noVendeur = dataRow[0].ToString();
commande.NoVendeur = Vendeur.getVendeurById(noVendeur);
String noClient = dataRow[1].ToString();
commande.NoClient = Clientel.getClientById(noClient);
Match match = Regex.Match(dataRow[2].ToString(), pattern);
String temp = match.Groups[3].Value + "-" + match.Groups[2].Value + "-" + match.Groups[1].Value;
commande.DateCde = temp;
commande.Facture = dataRow[3].ToString();
commande.NbArticle = dataRow[4].ToString();
return(commande);
}
else
{
return(null);
}
}
catch (MySqlException e)
{
throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message);
}
}