package app;

import kernel.Cell;
import kernel.Grid;
import kernel.exception.CellNotFoundException;
import kernel.exception.CreateCycleException;
import kernel.exception.InvalidIntervalLineColumnEception;
import kernel.function.Average;
import kernel.function.Sum;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.ObjectOutputStream;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;


public class Application implements Serializable{

	//private static final long serialVersionUID = 1L;

	public static void main(String[] args) throws IOException {

    	 File fichier =  new File("essai.ser") ;

    	  // ouverture d'un flux sur un fichier
    	 ObjectOutputStream oos =  new ObjectOutputStream(new FileOutputStream(fichier)) ;
        
    	 Grid grid = new Grid();

        // Création
        System.out.println("Création de quelques cases...");


        try {
            grid.createCell("AA", 1, 10.);
            grid.createCell("B", 1, 0.);
            grid.createCell("A", 2, 5.);
            List<Cell> sumList = new ArrayList<>();
            sumList.add(grid.getCell("A", 1));
            sumList.add(grid.getCell("A", 2));

            grid.createCell("A", 3, new Sum(sumList));

            List<Cell> averageList = new ArrayList<>();
            averageList.add(grid.getCell("A", 3));
            averageList.add(grid.getCell("B", 1));

            grid.createCell("B", 2, new Average(averageList));
        } catch (CellNotFoundException exception) {
            System.out.println(exception.getMessage());
        } catch (CreateCycleException exception) {
            System.out.println(exception.toString());
        }
    	 catch (InvalidIntervalLineColumnEception exception) {
    		 System.out.println(exception.toString());
    	}

        // Affichage
        List<Cell> cells = grid.getCells();

        System.out.println("Affichage des valeurs :");
        for (Cell cell : cells)
            System.out.println(cell.getId() + ": " + cell.getValue());

        System.out.println("Affichage des formules :");
        for (Cell cell : cells)
            System.out.println(cell.getId() + ": " + cell.toString());

        System.out.println("Affichage des formules développées :");
        for (Cell cell : cells)
            System.out.println(cell.getId() + ": " + cell.getDevelopedFormula());

        // Propagation
        try {
            grid.setValue("A", 1, 20.);
        } catch (CellNotFoundException exception) {
            System.out.println("exception");
        }

        System.out.println("Affichage des valeurs après modification :");
        for (Cell cell : cells)
            System.out.println(cell.getId() + ": " + cell.getValue());
        

        // sérialization de l'objet
          
        oos.writeObject(grid);
        oos.close();
    }
    









 
 
}