package app;

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

import java.util.ArrayList;
import java.util.List;

public class Application {

    public static void main(String[] args) {
        Grid grid = new Grid();

        // Création
        System.out.println("Création de quelques cases...");
        grid.createCell("A", 1, 10.);
        grid.createCell("B", 1, 0.);
        grid.createCell("A", 2, 5.);

        try {
            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());
        }

        // 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());
    }
}