package DB3;

import java.util.Scanner;
import java.sql.*;

public class Employee {

    private String username;
    public Scanner scanner;
    public ResultSet myRs;
    Connection myConn;
    Statement myStmt;


    public Employee(String username, Scanner scanner, ResultSet myRs, Connection myConn, Statement myStmt) {
        this.username = username;
        this.scanner = scanner;
        this.myRs = myRs;
        this.myConn = myConn;
        this.myStmt = myStmt;
    }


    public void run() {
        while (true) {
            welcome();
            int taskNumber = scanner.nextInt();
            if (taskNumber == -1) {
                break;
            }
            executeTask(taskNumber);
        }
        System.out.print("CalendarProgram exited.");
    }

    public void executeTask(int taskNumber) {
        switch (taskNumber) {
        case 1:         getNextAppointment();
        break;
        case 2:         getNextSevenAppointments();
        break;
        case 3:         getAllAppointments();
        break;
        case 4:         addNewUser();
        break;
        case 5:         makeNewAppointment();
        break;
        case 6:         deleteUser();
        break;
        case 7:         getAppointmentsWithAnotherUser();
        break;
        case 8:         getCommonAppointmentsWithAnotherUser();
        break;
        case 9:         addUserToAppointment();
        break;
        case 10:        editAppointment();
        break;
        default:        break;
        }
    }

    public void getNextAppointment() {
        return;
    }


    public void getNextSevenAppointments() {
        return;
    }

    public void getAllAppointments() {
        return;
    }

    public void addNewUser() {
        return;
    }

    public void makeNewAppointment() {

        System.out.println("Når starter avtalen? (HH:MM)");
        String avtaleStart = scanner.next();
        System.out.println("Når slutter avtalen? (HH:MM)");
        String avtaleSlutt = scanner.next();
        System.out.println("Hvilken dato er avtalen? (DD/MM/YY)");
        String avtaleDato = scanner.next();
        System.out.println("Gi en kort beskrivelse av avtalen (Sted, osv.)");
        String beskrivelse = scanner.next();
        System.out.println("Vil du legge til andre brukere til avtalen? (Ja/Nei)");
        String svar = scanner.next();
        while (svar.equalsIgnoreCase("ja") || svar.equalsIgnoreCase("j")) {
            System.out.println("Skriv inn brukernavn til brukeren du vil legge til:");
            String addBruker = scanner.next();
        }

        return;
    }

    public void deleteUser() {
        try {
            System.out.println( "===========" );
            System.out.println( "Delete user" );
            System.out.println( "===========" );
            System.out.println( "Please enter the username of the user you want to delete: " );
            String toBeDeleted = scanner.next();
            String query = "DELETE FROM ansatt WHERE brukernavn = '" + toBeDeleted + "';";
            ResultSet rs = myStmt.executeQuery(query);
            System.out.println( "User " + rs.getString("brukernavn") +  " successfully deleted.");
        }
        catch (Exception e) {

        }
    }

    public void getAppointmentsWithAnotherUser() {
        return;
    }

    public void getCommonAppointmentsWithAnotherUser() {
        return;
    }

    public void addUserToAppointment() {
        return;
    }

    public void editAppointment() {
        return;
    }

    public void welcome() {
        System.out.println("\nHi " + username + "! Here is the menu:");
        System.out.println("1 - My next appointment");
        System.out.println("2 - My appointments the next 7 days");
        System.out.println("3 - List all my appointments");
        System.out.println("4 - Add new user");
        System.out.println("5 - Make new appointment");
        System.out.println("6 - Delete user");
        System.out.println("7 - Find participants in appointment");
        System.out.println("8 - Common appointments with another user");
        System.out.println("9 - Add user to appointment");
        System.out.println("10 - Edit appointment");
        System.out.println("-1 - Exit CalendarProgram");
    }

    public String getUsername() {
        return username;
    }

}