package kernel;

  import kernel.exception.CellNotFoundException;

  import kernel.exception.CreateCycleException;

  import kernel.exception.InvalidIntervalException;

  import java.io.Serializable;

  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_LIGNES = 20;
  	private static final String MAX_COLONNES = "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 {

  		column = column.toUpperCase();
  
  		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 {

  		column = column.toUpperCase();
  
  		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 {
  		Cell cell = this.cells.get(this.getCellId(column, line));
  		
  		if (cell != null)
  			return cell;
  		else
  			throw new CellNotFoundException();
  	}
  	
  	public List<Cell> getCells() {
  		return new ArrayList<>(this.cells.values());
  	}
  	
  	public List<String> getCellsId() {
  		return new ArrayList<>(this.cells.keySet());
  	}
  	
  	public double getValue(String column, int line) throws CellNotFoundException {
  		return this.getCell(column, line).getValue();
  	}
  	
  	public String getFormulaAsString(String column, int line) throws CellNotFoundException {
  		return this.getCell(column, line).toString();
  	}
  	
  	public String getDevelopedFormula(String column, int line) throws CellNotFoundException {
  		return this.getCell(column, line).getDevelopedFormula();
  	}
  	
  	private String getCellId(String column, int line) {
  		return column + line;
  	}
  	

  	
  	public int getTotalColumn() {
  		return MAX_COLONNES.charAt(0) - (int) 'A' + 1;
  		//return convertStringToInt(MAX_COLONNES);
  	}
  	
  	public int getTotalLine() {
  		return MAX_LIGNES;

  	}
  	

  	private boolean validateInterval(String column, int line) {
  		return line >= 1 && line <= MAX_LIGNES && convertStringToInt(column)>=convertStringToInt("A") && convertStringToInt(column)<=convertStringToInt(MAX_COLONNES);

  	}
  	

  	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;

  	}

  }