package jpa;

import java.util.ArrayList;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.List;
import java.util.Scanner;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Query;
import javax.persistence.TypedQuery;
import static jpa.MainApp.sc1;
import static jpa.MainApp.students;
import jpa.entity.Group;
import jpa.entity.Language;
import jpa.entity.Student;

public class MainApp {

    private static final String PERSISTENCE_UNIT_NAME = "JavaExampleDBPU";
    private static EntityManagerFactory factory;
    public static Group gr = new Group();
    public static Group gr2 = new Group();
    public static EntityManager em;
    public static Student student1 = new Student("Ivanov", "Ivan", gr, Language.RUSSIAN,1);
    public static Student student2 = new Student("Petrova", "Anna", gr, Language.ESTONIAN,2);
    public static Student student3 = new Student("Larissa", "Joonas", gr2, Language.RUSSIAN,3);
    public static Student student4 = new Student("Winston", "Charles", gr2, Language.ENGLISH,4);
    public static List<Student> students = new ArrayList();
    public static List<Student> students2 = new ArrayList();
    public static List<Group> list = new ArrayList();
    public static List<Group> list2 = new ArrayList();
    public static Scanner sc=new Scanner(System.in);
    public static Scanner sc1=new Scanner(System.in);


    public static void main(String[] args) {
        factory = Persistence.createEntityManagerFactory(PERSISTENCE_UNIT_NAME);
        EntityManager em = factory.createEntityManager();

        System.out.println("Meie menuu");
        System.out.println("Valige menuust vastav soov mida tahate teha");
        System.out.println("1.Kogu listi printimine ekraanile");
        System.out.println("2.Info otsimine ID j2rgi");
        System.out.println("3.Uute andmete lisamine");
        System.out.println("4.Andmete muutmine");
        System.out.println("5.Andmete kustutamine");
        int menuu=0;
        menuu=sc.nextInt();
        switch(menuu){
            case 1:

        em.getTransaction().begin();
        gr = new Group();
        gr.setCode("RDIR");
        gr.setName("Applied Information Technology");
        em.persist(gr);
        student1 = new Student("Ivanov", "Ivan", gr, Language.RUSSIAN,1);
        em.persist(student1);
        student2 = new Student("Petrova", "Anna", gr, Language.ESTONIAN,2);
        em.persist(student2);
        //em.getTransaction().commit();

//        TypedQuery<Student> query2
//                = em.createQuery("SELECT st FROM Student st where st.id=1L", Student.class);
//        Student student=query2.getSingleResult();
//        System.out.printf("Student(#%d): %s %s\n",student.getId(),student.getLastname(),student.getFirstname());

        gr2.setCode("RDDR");
        gr2.setName("Masinaehitus");
        em.persist(gr2);
        student3 = new Student("Larissa", "Joonas", gr2, Language.RUSSIAN,3);
        em.persist(student3);
        student4 = new Student("Winston", "Charles", gr2, Language.ENGLISH,4);
        em.persist(student4);
        em.getTransaction().commit();

        Query query2 = em.createNativeQuery("SELECT * FROM GroupVK", Group.class);
        List<Group> list2 = query2.getResultList();
        for (Group a : list2) {
            System.out.println(a.getCode() + ": " + a.getName());

        Query query3 = em.createQuery("select st from Student st ");
        List<Student> students2 = query3.getResultList();
            for(Student student: students2)
            {
                if(a.getId()==student.getGroup().getId())
                System.out.println(student.getLastname() + " " + student.getFirstname()+ " " + student.getId()+ " " + student.getLang());
            }
        }

//        Query query3 = em.createQuery("select st from Student st ");
//        List<Student> students2 = query3.getResultList();
//        for (Student student : students2) {
//            System.out.println(student.getLastname() + " " + student.getFirstname());
//        }


        break;

            case 2: Otsimine(); break;
            case 3: Lisamine(); break;
            case 4: Muutmine(); break;
            case 5: Kustutamine(); break;



        }



       em.close();

    }

public static void Kustutamine(){
        System.out.println("Info kustutamine");
        //kustutamine
        Scanner sc3 = new Scanner(System.in);
        int id1 = sc3.nextInt();
        for (Student studenta : students)
        {
            if(studenta.getId()==id1)
            {
                students.remove(studenta);
                em.remove(student2);
                //em.getTransaction().commit();

                //System.out.println(studenta.getFirstname()+ " " + studenta.getLastname());
            }
        System.out.println(studenta.getFirstname()+ " " + studenta.getLastname());
        }

        for(Student stud : students)
        {
            System.out.println(stud.getFirstname() + " " +stud.getLastname()+" "+ stud.getLang() + " " + stud.getId());

        }
   }


public static void Muutmine(){

      System.out.println("Objektide muutmine");
      System.out.println("Sisestage opilase ID, kelle andmeid soovite vahetada");
      int teinearv=sc1.nextInt();
      System.out.println("Sisestage Uue opilase eesnimi");
      String firstname=sc.nextLine();
      System.out.println("Sisestage Uue opilase perekonnanimi");
      String lastname=sc.nextLine();
      System.out.println("Sisestage uue opilase keel(");
      int keeled=sc1.nextInt();
      System.out.println("Kui opilane vahetas gruppi, siis sisestage ka uus Grupp(1.RDIR, 2.RDDR)");
      int grupp=sc1.nextInt();
      for(Student opilane : students)
      {
          if(opilane.getId()==teinearv)
          {
              opilane.setFirstname(firstname);
              opilane.setLastname(lastname);
            if(grupp==1){
            switch (keeled) {
                case 1:
                    opilane.setLang(Language.RUSSIAN);
                    break;
                case 2:
                    opilane.setLang(Language.ENGLISH);
                    break;
                case 3:
                    opilane.setLang(Language.ESTONIAN);
                    break;
            }
        }
        if(grupp==2){
            switch (keeled) {
                case 1:
                    opilane.setLang(Language.RUSSIAN);
                    break;
                case 2:
                    opilane.setLang(Language.ENGLISH);
                    break;
                case 3:
                    opilane.setLang(Language.ESTONIAN);
                    break;
            }
        }
          }
      }
    }

public static void Otsimine(){

        em.getTransaction().begin();
        System.out.println("Isiku otsimine");
        int arv=sc1.nextInt();

          Query query2 = em.createNativeQuery("SELECT * FROM GroupVK", Group.class);
        List<Group> list2 = query2.getResultList();
        for (Group a : list2) {
            System.out.println(a.getCode() + ": " + a.getName());

        Query query3 = em.createQuery("select st from Student st ");
        List<Student> students2 = query3.getResultList();
            for(Student student: students2)
            {
                if(a.getId()==student.getGroup().getId())
                //
                    if(arv==student.getId())
                    {
                        System.out.println(student.getLastname().toString() + " " + student.getFirstname().toString()+ " " + student.getId()+ " " + student.getLang().toString());
                    }


            }
        }
        //em.close();
        }





//        for(Student sunta : students2)
//        {
//
//            if(sunta.getId()==sunta.getGroup().getId())
//            {
//
//            }
//        }




public static void Lisamine(){
        System.out.println("Info lisamine");
        System.out.println("Sisestage eesnimi");
        String firstname=sc.nextLine();
        System.out.println("Sisestage perenimi");
        String lname=sc.nextLine();
        System.out.println("Sisestage mis keel(1.Vene keel, 2.Inglise keel, 3.Eesti keel");
        int keeled=sc1.nextInt();
        System.out.println("Valige grupp, 1. RDIR, 2.RDDR");
        int group=sc1.nextInt();
        if(group==1){
            switch (keeled) {
                case 1:

                    //students.add(new Student(lname,firstname,gr,Language.RUSSIAN,students.size()+1));
                    em.persist(new Student(lname,firstname,gr,Language.RUSSIAN,students.size()+1));
                    break;
                case 2:
                    //students.add(new Student(lname,firstname,gr,Language.ENGLISH,students.size()+1));
                    em.persist(new Student(lname,firstname,gr,Language.ENGLISH,students.size()+1));
                    break;
                case 3:
                    //students.add(new Student(lname,firstname,gr,Language.ESTONIAN,students.size()+1));
                    em.persist(new Student(lname,firstname,gr,Language.ESTONIAN,students.size()+1));
                    break;
            }
        }
        if(group==2){
            switch (keeled) {
                case 1:
                    //students.add(new Student(lname,firstname,gr2,Language.RUSSIAN,students.size()+1));
                    em.persist(new Student(lname,firstname,gr2,Language.RUSSIAN,students.size()+1));
                    break;
                case 2:
                    //students.add(new Student(lname,firstname,gr2,Language.ENGLISH,students.size()+1));
                    em.persist(new Student(lname,firstname,gr2,Language.ENGLISH,students.size()+1));
                    break;
                case 3:
                    //students.add(new Student(lname,firstname,gr2,Language.ESTONIAN,students.size()+1));
                    em.persist(new Student(lname,firstname,gr2,Language.ESTONIAN,students.size()+1));
                    break;
            }
        }

    }
}