package Menu;


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

import Menu.DataAccess;


public class Login {

    //Loader dataAccess klasse
    DataAccess da = new DataAccess();

    //Scanner klasse initeres
    Scanner sc = new Scanner(System.in);


    //Metode login
    public void login() {

        // Check brugernavn og adgangskode og position
        System.out.print("Enter your 4 digit userpin: ");
        String number = 20 + sc.next();
        System.out.print("Enter Password: ");
        String password = sc.next();

        // Create SQL Query
        String SQL = "SELECT * FROM brugerlogin WHERE brugernummer ='" + number + "' OR adgangskode COLLATE utf8_bin ='" + password + "'";


        Object[][] x;

        try {
            x = da.executeQuery(SQL);
            if(x != null) {

            System.out.println("======================================");

                for (Object[] o : x)
                {
                    if(number.equals(o[0]) && password.equals(o[1])) {
                        System.out.println("Login Succes");
                    }

                    else
                    {
                        System.out.println("Login failed");
                    }

                    //Check permission


                }

            }
            else {
                System.out.println("Dine informationer er forkerte");
            }

            } catch (SQLException e) {

            e.printStackTrace();

        }


    }

}