protected void remplirDetailsCommandes(XNamespace ss, XElement worksheet)
{
PPDetailsCommandes detailsCommandes = new PPDetailsCommandes();
foreach (XElement row in worksheet.Descendants(ss + "Row"))
{
List <String> arrayStr = new List <string>();
foreach (XElement cell in row.Descendants(ss + "Data"))
{
arrayStr.Add(cell.Value);
}
if (arrayStr.Count() == 5)
{
detailsCommandes.Add(new DetailsCommandes(null)
{
NoDetailCommandes = Convert.ToInt64(arrayStr[0]),
NoCommande = Convert.ToInt64(arrayStr[1]),
NoProduit = Convert.ToInt32(arrayStr[2]),
PrixVente = Convert.ToDecimal(arrayStr[3]),
Quantité = Convert.ToInt16(arrayStr[4])
});
}
}
}
