package YodaFitness;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;

public class OpretMedlem {

    public static void main(String[] args) {
        try {
            System.out.println("Vi vil nu oprette en ny Instuktor : ");
            BufferedReader inLine = new BufferedReader(new InputStreamReader(System.in));

            System.out.print("Indtast ID: ");
            int id = Integer.parseInt(inLine.readLine());

            System.out.println("Indtast Navn: ");
            String navn = inLine.readLine();

            System.out.println("Indtast Adresse: ");
            String adresse = inLine.readLine();

            System.out.println("Indtast telefon nummer: ");
            int mobil = Integer.parseInt(inLine.readLine());

            System.out.println("Indtast dato: ");
            DateFormat foramtter = new SimpleDateFormat("yyyy-MM-DD hh:mm");
            Date dato = (Date) foramtter.parse(inLine.readLine());

            Connection minConnection;
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            minConnection = DriverManager.getConnection(
                    "jdbc:sqlserver://DESKTOP-FV69J7M\\MINSQLSERVER;databaseName=DAOS_2;user=sa;password=1234;");
            String sql = "insert into Medlem values (?,?,?,?,?)";
            PreparedStatement prestmt = minConnection.prepareStatement(sql);
            prestmt.clearParameters();
            prestmt.setInt(1, id);
            prestmt.setString(2, navn);
            prestmt.setString(3, adresse);
            prestmt.setInt(4, mobil);
            prestmt.setDate(5, dato);

            prestmt.execute();
            System.out.println("Person er nu registreret");
            if (prestmt != null) {
                prestmt.close();
            }
            if (minConnection != null) {
                minConnection.close();
            }

        } catch (SQLException e) {
            switch (e.getErrorCode()) {
            case 547: {
                if (e.getMessage().indexOf("") != -1) {
                    System.out.println("");
                }
                break;
            }
            case 2627: {
                System.out.println("den pågældende person er allerede oprettet");
                break;
            }
            default:
                System.out.println("fejlSQL:  " + e.getMessage());
            }
            ;
        } catch (Exception e) {
            System.out.println("fejl:  " + e.getMessage());
        }
    }

}