import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class XlsReader
{

	public static void main(String[] args)
	{
		try
		{
			BufferedReader br = new BufferedReader(new FileReader(new File("mondriaan.csv")));
			String line = br.readLine();
			while (line.split(",").length == 1)
			{
				line = br.readLine();
			}

			/* new Employee()
			number
			name
			fase
			end_date
			contract_num*/

			DateFormat df = new SimpleDateFormat("dd-MM-yyyy");

			while ((line = br.readLine()) != null)
			{
				String[] values = line.split(",");
				int employee_num = Integer.parseInt(values[0]);
				String name = values[1];
				char fase = values[2].charAt(5);
				Date end_date = df.parse(values[3]);
				int contract_num = Integer.parseInt(values[7]);
				Employee e;
				if ((e = Employee.finder.where().eq("number",employee_num).findUnique()) != null)
				{
					e.number = employee_num;
					e.name = name;
					e.fase = fase;
					e.end_date = end_date;
					e.contract_num = contract_num;
					e.update();
				}
				else
				{
					e = new Employee(employee_num,name,fase,end_date,contract_num);
					e.save();
				}
			}

			br.close();
		}
		catch (FileNotFoundException e)
		{
			System.out.println(e.getMessage());
		}
		catch (IOException e)
		{
			System.out.println(e.getMessage());
		}
		catch (ParseException e)
		{
			System.out.println(e.getMessage());
		}
		catch (NumberFormatException e) {}
	}
}