public void ConvertBase(string inPath, string outIngredientsPath, string outCategoriesPath) { FileInfo existingFile = new FileInfo(inPath); ListeCategories categories = new ListeCategories(); ListeIngredients ingredients = new ListeIngredients(); int indexCategorie = 1, indexIngredient = 1; Categorie currentCat = null; using (StreamWriter databaseFileXML = new StreamWriter(outIngredientsPath)) { using (ExcelPackage package = new ExcelPackage(existingFile)) { for (int worksheetIndex = 1; worksheetIndex <= 8; worksheetIndex++) { ExcelWorksheet worksheet = package.Workbook.Worksheets[worksheetIndex]; Scan(worksheet, 1, databaseFileXML, ref currentCat, ingredients, categories, ref indexCategorie, ref indexIngredient); Scan(worksheet, 3, databaseFileXML, ref currentCat, ingredients, categories, ref indexCategorie, ref indexIngredient); } } } XMLPersistIngredients IngredientsXMLPersister = new XMLPersistIngredients(); IngredientsXMLPersister.Save(ingredients, outIngredientsPath); XMLPersistCategories categoriesXMLPersister = new XMLPersistCategories(); categoriesXMLPersister.Save(categories, outCategoriesPath); }
public void ChargerBase(string inIngredientsPath) { ListeIngredients ingredients = new ListeIngredients(); XMLPersistIngredients IngredientsXMLPersister = new XMLPersistIngredients(); IngredientsBase = IngredientsXMLPersister.Load(ingredients, inIngredientsPath).Ingredients.OrderBy(x => x.Nom).ToList(); IngredientsBaseFiltre = IngredientsBase; }