public static void convertPcna(XMLFile infoFile, XMLFile pricesFile, XMLFile imagesFile) { List <ProduitDB> produits = XMLFile.readPcnaXML(infoFile, pricesFile, imagesFile); Excel excelFinal = Excel.createAndUseFile(pricesFile.getPath().Replace(".xml", ".xlsx")); ProduitDB.writeDBHeader(excelFinal); Console.WriteLine("Finished creating items"); for (int i = 0; i < produits.Count; i++) { ProduitDB produit = (ProduitDB)produits[i]; ProduitDB.writeDBItem(excelFinal, i + 1, produit); } excelFinal.save(); //XMLFile.writeFile(imagesFile); }
private void button2_Click(object sender, EventArgs e) { if (comboBox2.Text.Equals("Nettoyage")) { if (comboBox1.Text.Equals("Sanmar")) { } else { Excel productExcel = new Excel(textBox1.Text, 1); Excel disabledExcel = Excel.createAndUseFile(productExcel.getPath()); int maxRow = 1; disabledExcel.writeBoldCell(0, 0, "Code"); disabledExcel.writeBoldCell(0, 1, "Status"); for (int i = 1; i < productExcel.getRowCount(); i++) { if (productExcel.readCell(i, 0).EndsWith("_")) { disabledExcel.writeCell(maxRow, 0, productExcel.readCell(i, 0)); disabledExcel.writeCell(maxRow, 1, "Disable"); maxRow++; } } disabledExcel.save(); MessageBox.Show("Nettoyage complété!"); } } else if (comboBox1.Text.Equals("Bankers")) { Excel bankersExcel = new Excel(textBox1.Text, 1); if (comboBox2.Text.Equals("Conversion")) { Excel bankersExcelEn = new Excel(textBox2.Text, 1); BankersConversion.convertBankers(bankersExcel, bankersExcelEn); MessageBox.Show("Conversion terminée avec succès!"); } else if (comboBox2.Text.Equals("Ajouter images")) { BankersConversion.uploadPictures(bankersExcel); MessageBox.Show("Les images ont été ajoutées avec succès!"); } else if (comboBox2.Text.Equals("Categories")) { CatConversionList catConversionList = new CatConversionList(); String directory = "C:\\Users\\Caroline\\Documents\\Database\\Bankers\\debug\\"; FTP.checkIfFilesExist(directory, "CatManquantes.txt"); StreamWriter file = new StreamWriter(directory + "CatManquantes.txt", true); ArrayList categoriesList = new ArrayList(); int maxRows = bankersExcel.getRowCount(); for (int i = 1; i < maxRows; i++) { String[] categories = bankersExcel.readCell(i, 6).Split('|'); for (int j = 0; j < categories.Length; j++) { catConversionList.debugCategories(categories[j], file, categoriesList); } } file.Close(); MessageBox.Show("Vérification terminée!"); } else if (comboBox2.Text.Equals("Couleurs")) { Excel attributeExcel = new Excel(textBox3.Text, 1); DebcoConversion.addColors(bankersExcel, attributeExcel); MessageBox.Show("Les couleurs ont été ajoutées avec succès!"); } else if (comboBox2.Text.Equals("Merge")) { } } else if (comboBox1.Text.Equals("Debco")) { Excel debcoExcel = new Excel(textBox1.Text, 1); if (comboBox2.Text.Equals("Categories")) { String directory = "C:\\Users\\Caroline\\Documents\\Database\\Debco\\debug\\"; CatConversionList catConversionList = new CatConversionList(); FTP.checkIfFilesExist(directory, "CatManquantes.txt"); StreamWriter file = new StreamWriter(directory + "CatManquantes.txt", true); ArrayList categoriesList = new ArrayList(); int maxRows = debcoExcel.getRowCount(); for (int i = 1; i < maxRows; i++) { String categorie = debcoExcel.readCell(i, 104); catConversionList.debugCategories(categorie, file, categoriesList); } file.Close(); MessageBox.Show("Vérification terminée!"); } else if (comboBox2.Text.Equals("Conversion")) { DebcoConversion.convertDebco(debcoExcel); MessageBox.Show("Conversion terminée avec succès!"); } else if (comboBox2.Text.Equals("Ajouter images")) { DebcoConversion.uploadPictures(debcoExcel); MessageBox.Show("Les images ont été ajoutées avec succès!"); } else if (comboBox2.Text.Equals("Couleurs")) { Excel attributeExcel = new Excel(textBox2.Text, 1); DebcoConversion.addColors(debcoExcel, attributeExcel); MessageBox.Show("Les couleurs ont été ajoutées avec succès!"); } } else if (comboBox1.Text.Equals("Leeds et Bullet")) { if (comboBox2.Text.Equals("Conversion")) { Console.WriteLine("Creating file"); XMLFile infoFile = new XMLFile(textBox1.Text); XMLFile pricesFile = new XMLFile(textBox2.Text); XMLFile imagesFiles = new XMLFile(textBox3.Text); Console.WriteLine("Done"); PcnaConversion.convertPcna(infoFile, pricesFile, imagesFiles); MessageBox.Show("Conversion complétée"); } else if (comboBox2.Text.Equals("Ajouter images")) { Excel sheet = new Excel(textBox1.Text, 1); FTP.uploadFromConvertedExcel(sheet); MessageBox.Show("Images mises en ligne!"); } else if (comboBox2.Text.Equals("Couleurs")) { Excel convertedSheet = new Excel(textBox1.Text, 1); Excel attributesSheet = new Excel(textBox2.Text, 1); TasksWithConvertedExcel.ajouterCouleurs(convertedSheet, attributesSheet); MessageBox.Show("Couleurs ajoutées!"); } } else if (comboBox1.Text.Equals("Sanmar")) { if (comboBox2.Text.Equals("Conversion")) { Excel sanmarExcel = new Excel(textBox1.Text, 1); Excel sanmarExcelFr = new Excel(textBox2.Text, 1); SanmarConversion.convertSanmar(sanmarExcel, sanmarExcelFr, textBox3.Text); MessageBox.Show("Conversion terminée"); } else if (comboBox2.Text.Equals("Items manquants")) { String itemFile = textBox1.Text; String descFile = textBox2.Text; SanmarConversion.checkItemsReallyThere(itemFile, descFile); MessageBox.Show("Vérification terminée"); } else if (comboBox2.Text.Equals("Ajouter images")) { Excel sheet = new Excel(textBox1.Text, 1); FTP.uploadFromConvertedExcel(sheet); MessageBox.Show("Images mises en ligne!"); } else if (comboBox2.Text.Equals("Couleurs")) { Excel convertedSheet = new Excel(textBox1.Text, 1); Excel attributesSheet = new Excel(textBox2.Text, 1); TasksWithConvertedExcel.ajouterCouleurs(convertedSheet, attributesSheet); MessageBox.Show("Couleurs ajoutées!"); } } }
public static List <ProduitDB> readPcnaXML(XMLFile infoFile, XMLFile pricesFile, XMLFile imagesFile) { double USDtoCAD = 1.35; ArrayList produits = new ArrayList(); CatConversionList catConversionList = new CatConversionList(); XElement xmlImage = imagesFile.file.Element(imagesFile.ns + "MediaContents"); XElement xmlPrice = pricesFile.file.Element(pricesFile.ns + "ItemPrices"); XElement xmlInfo = infoFile.file.Element(infoFile.ns + "Items"); var items = from el in xmlInfo.Elements(infoFile.ns + "Item") select new { name = (String)el.Element(infoFile.ns + "Description"), division = (String)el.Element(infoFile.ns + "Division"), apparel = (Boolean)el.Element(infoFile.ns + "Flags").Element(infoFile.ns + "Apparel"), colors = from prop in el.Element(infoFile.ns + "VariantProperties").Elements(infoFile.ns + "VariantProperty") where (String)prop.Attribute("Type") == "AvailableColors" select(String) prop.Attribute("Value"), description = (String)el.Element(infoFile.ns + "MarketingDescription"), code = (String)el.Element(infoFile.ns + "Style"), skus = from codes in el.Element(infoFile.ns + "Skus").Elements(infoFile.ns + "Sku") select new { sku = (String)codes.Attribute("Number"), color = (String)codes.Element(infoFile.ns + "Color").Attribute("MarketColor"), size = (String)codes.Element(infoFile.ns + "Size"), CANprices = (from item in xmlPrice.Elements(pricesFile.ns + "ItemPrice") where (String)item.Element(pricesFile.ns + "SKU") == (String)codes.Attribute("Number") select new { pricesQty = from price in item.Element(pricesFile.ns + "Prices").Elements(pricesFile.ns + "Price") where (String)price.Element(pricesFile.ns + "PriceType") == "Canadian" select new { price = (double)price.Element(pricesFile.ns + "PriceValue"), qty = (int)price.Element(pricesFile.ns + "FromQty") } }), USprices = (from item in xmlPrice.Elements(pricesFile.ns + "ItemPrice") where (String)item.Element(pricesFile.ns + "SKU") == (String)codes.Attribute("Number") select new { pricesQty = from price in item.Element(pricesFile.ns + "Prices").Elements(pricesFile.ns + "Price") where (String)price.Element(pricesFile.ns + "PriceType") == "Canadian" select new { price = (double)price.Element(pricesFile.ns + "PriceValue"), qty = (int)price.Element(pricesFile.ns + "FromQty") } }), imageURL = (from image in xmlImage.Elements(imagesFile.ns + "MediaContent") where (String)image.Element(imagesFile.ns + "Sku") == (String)codes.Attribute("Number") select new { sku = image.Element(imagesFile.ns + "Sku").Value, url = (from img in image.Element(imagesFile.ns + "Media").Elements(imagesFile.ns + "Medium") where img.Element(imagesFile.ns + "MediumSize").Value == "Large" select new { size = img.Element(imagesFile.ns + "MediumSize").Value, img = (String)img.Element(imagesFile.ns + "Url").Value }) }) }, category = (String)el.Element(infoFile.ns + "Category"), giftSet = (Boolean)el.Element(infoFile.ns + "Flags").Element(infoFile.ns + "GiftSet"), sizes = (from sku in el.Element(infoFile.ns + "Skus").Elements(infoFile.ns + "Sku") select sku.Element(infoFile.ns + "Size")).Distinct() }; List <OutsideItem> pcnaItems = new List <OutsideItem>(); foreach (var item in items) { Boolean added = false; PcnaItem pcnaItem = new PcnaItem(); pcnaItem.code = item.code; List <String> codeStrings = item.skus.Cast <String>().ToList(); pcnaItem.codes = codeStrings.ToArray <String>(); pcnaItem.division = item.division; pcnaItem.description = item.description; pcnaItem.name = item.name; pcnaItem.category = item.category; pcnaItem.apparel = item.apparel; pcnaItem.giftSet = item.giftSet; pcnaItem.colors = item.colors.Cast <String>().ToList(); pcnaItem.sizes = item.sizes.Cast <String>().ToList(); pcnaItems.Add(pcnaItem); } Console.WriteLine("Fini d'écrire les objets"); return(ConversionUtils.getProducts(pcnaItems)); }
public static void writeFile(XMLFile file) { StreamWriter fs = new StreamWriter(file.path); fs.WriteLine(file.file); }