package kernel;

import kernel.exception.CannotDeleteCellException;
import kernel.exception.CellNotFoundException;
import kernel.exception.CreateCycleException;
import kernel.exception.InvalidIntervalException;

import java.io.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Grid implements Serializable {
	
	private static final long serialVersionUID = 1L;
	private static final int MAX_ROWS = 20;
	private static final String MAX_COLUMNS = "Z";
	private Map<String, Cell> cells = new HashMap<>();
	public static LanguageEnum language = LanguageEnum.FR;
	
	public void createCell(String column, int line, double value) throws InvalidIntervalException {
		if (!validateInterval(column, line))
			throw new InvalidIntervalException();
		
		String id = this.getCellId(column, line);
		Cell cell = new Cell(column, line, value);
		
		this.cells.put(id, cell);
	}
	
	public void createCell(String column, int line, Formula formula) throws CreateCycleException, InvalidIntervalException {
		if (!validateInterval(column, line))
			throw new InvalidIntervalException();
		
		String id = this.getCellId(column, line);
		Cell cell = new Cell(column, line, formula);
		
		this.cells.put(id, cell);
	}
	
	public void setValue(String column, int line, double value) throws CellNotFoundException {
		this.getCell(column, line).setValue(value);
	}
	
	public void setFormula(String column, int line, Formula formula) throws CellNotFoundException,
			CreateCycleException {
		this.getCell(column, line).setFormula(formula);
	}
	
	public Cell getCell(String column, int line) throws CellNotFoundException {
		String id = this.getCellId(column, line);
		Cell cell = this.cells.get(id);
		
		if (cell != null)
			return cell;
		else
			throw new CellNotFoundException("La cellule " + id + " n'existe pas.");
	}
	
	public Cell getCell(String id) {
		return this.cells.get(id);
	}
	
	public List<Cell> getCells() {
		return new ArrayList<>(this.cells.values());
	}
	
	public double getValue(String column, int line) throws CellNotFoundException {
		return this.getCell(column.toUpperCase(), line).getValue();
	}
	
	public String getFormulaAsString(String column, int line) throws CellNotFoundException {
		return this.getCell(column.toUpperCase(), line).toString();
	}
	
	public String getDevelopedFormula(String column, int line) throws CellNotFoundException {
		return this.getCell(column.toUpperCase(), line).getDevelopedFormula();
	}
	
	private String getCellId(String column, int line) {
		return column.toUpperCase() + line;
	}
	
	public int getTotalColumn() {
		return MAX_COLUMNS.charAt(0) - (int) 'A' + 1;
	}
	
	public int getTotalRow() {
		return MAX_ROWS;
	}
	
	private boolean validateInterval(String column, int line) {
		return line >= 1 && line <= MAX_ROWS && convertStringToInt(column) >= convertStringToInt("A") && convertStringToInt(column) <= convertStringToInt(MAX_COLUMNS);
	}
	
	public boolean cellExist(String key) {
		return this.cells.containsKey(key);
	}
	
	public void deleteCell(String column, int line) throws CannotDeleteCellException {
		String id = this.getCellId(column, line);
		
		if (this.cellExist(id)) {
			Cell cell = this.getCell(id);
			
			if (!cell.getUsedIn().isEmpty())
				throw new CannotDeleteCellException("La cellule " + id + " est utilisée dans une autre case.");
			
			cell.updateUsedIn();
			this.cells.remove(id);
		}
	}
	
	private int convertStringToInt(String str) {
		int ascii = 0;
		for (int i = 0; i < str.length(); i++) {   // while counting characters if less than the length add one
			char character = str.charAt(i); // start on the first character
			ascii = ascii + (int) character;
			
		}
		return ascii;
	}
	
	public void save(String fileName) throws IOException {
		File file = new File(fileName);
		
		ObjectOutputStream stream = new ObjectOutputStream(new FileOutputStream(file));
		stream.writeObject(this);
		stream.close();
	}
	
	public static Grid load(String fileName) throws IOException, ClassNotFoundException {
		File file = new File(fileName);
		
		ObjectInputStream stream = new ObjectInputStream(new FileInputStream(file));
		Grid grid = (Grid) stream.readObject();
		stream.close();
		
		return grid;
	}
}