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

class InputSeeker{
    private Scanner sc = new Scanner(System.in);
    private int userId=0;
    private String name=null;
    private String mobileNumber=null;
    private float amountSpent=0;
    private int groupId;

    // Name seeker
    public void nameSeeker(){
        System.out.print("Enter the Name: ");
        name = sc.next();
    }
    public String getName() {
        return name;
    }
    // id seeker
    public void idSeeker() {
        System.out.print("Assign the Participant an id : ");
        userId= sc.nextInt();
    }
    public int getId() {
        return userId;
    }
    //number seeker
    public void amountSpentSeeker() {
        System.out.println("Enter the amount: ");
        amountSpent= sc.nextFloat();
    }
    public float getAmountSeeker() {
        return amountSpent;
    }
    //mobile number
    public void mobileNumberSeeker() {
        System.out.println("Enter the mobile number: ");
        mobileNumber=sc.next();
    }
    public String getMobileNumber() {
        return mobileNumber;
    }
    //group id
    public void groupIdSeeker() {
        System.out.println("Assign the Group an id: ");
        groupId= sc.nextInt();
    }
    public int getGroupId() {
        return groupId;
    }
}

class Uservar{
    int userId;
    String userName;
    float amountSpent;
    String mobileNumber;
    int groupId;
    float finalDebt;
}

class UserDAO{
    Connection con =null;
    public void connect(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            // while in developers mode use verify Server certificate = false && useSSL=true
            con= DriverManager.getConnection("jdbc:mysql://localhost:3306/markone?verifyServerCertificate=false&useSSL=true","root","nishant97");
        } catch (Exception ex) {
            System.out.println(ex);
        }
            }

    public void addUser_catalogue(Uservar u) {
    String query ="insert into user_catalogue value(?,?,?,?)";

        try {

            PreparedStatement pst = con.prepareStatement(query);
            pst.setInt(1,u.userId);
            pst.setString(2,u.userName);
            pst.setInt(3,u.groupId);
            pst.setInt(4, 0);
            pst.executeUpdate();

        } catch (Exception ex) {
            System.out.println(ex);
        }
    }

    public void addUser_contact(Uservar u) {
        String query ="insert into user_contact value(?,?)";
        try {
            PreparedStatement pst1= con.prepareStatement(query);
            pst1.setString(1,u.userName);
            pst1.setString(2,u.mobileNumber);
            pst1.executeUpdate();

        }catch(Exception ex){
            System.out.println(ex);
        }
    }

    public void addUser_expenditure(Uservar u) {
        String query ="insert into user_expenditure value(?,?)";
        try {
            PreparedStatement pst2= con.prepareStatement(query);
            pst2.setString(1,u.mobileNumber);
            pst2.setFloat(2,u.amountSpent);
            pst2.executeUpdate();

        }catch(Exception ex){
            System.out.println(ex);
        }
    }


    public Uservar getUservar(String name) {
        try {
        String query="select * from user_catalogue User_name='"+name+"'";
        Uservar u= new Uservar();
        u.userName=name;
        Statement st = con.createStatement();
        ResultSet rs = st.executeQuery(query);
        rs.next();
        int id= rs.getInt(1);
        String nname = rs.getString(2);
        int groupiid= rs.getInt(3);
        float debt= rs.getFloat(4);

        //String mobileno =rs.getString(1);
        //float amountSpent =rs.getFloat(2);

        u.userId=id;
        u.userName= nname;
        u.groupId=groupiid;
        u.finalDebt=debt;
        //u.mobileNumber=mobileno;
        //u.amountSpent=amountSpent;

        return u;
        }

        catch(Exception ex) {
            System.out.println(ex);
        }
            return null;
    }



}
class EntryShowDelete {

    public void addUser() {
        UserDAO dao = new UserDAO();
        Uservar uvar= new Uservar();
        InputSeeker is1 = new InputSeeker();

        is1.nameSeeker();
        is1.groupIdSeeker();
        is1.idSeeker();
        is1.mobileNumberSeeker();
        is1.amountSpentSeeker();
        dao.connect();

        uvar.userId=is1.getId();
        uvar.userName=is1.getName();
        uvar.groupId=is1.getGroupId();
        uvar.mobileNumber=is1.getMobileNumber();
        uvar.amountSpent=is1.getAmountSeeker();

        dao.addUser_catalogue(uvar);
        dao.addUser_contact(uvar);
        dao.addUser_expenditure(uvar);
    }

    public void showSeacrhedUser() {
        UserDAO dao1= new UserDAO();
        dao1.connect();
        InputSeeker isvar1 = new InputSeeker();
        isvar1.nameSeeker();
        Uservar uvar2 = dao1.getUservar(isvar1.getName());
        System.out.print("User_id: "+uvar2.userId+" User_Name: "+uvar2.userName+" Group_id: "+uvar2.groupId+" Final_debt: "+uvar2.finalDebt);
    }

}

public class User{


    public static void main(String[] args){

    // EXPECTED MENU FORMAT
        Scanner fcc = new Scanner(System.in);
        System.out.println("Enter one of the following commands:");
        System.out.println("1 - DataEntry");
        System.out.println("2 - Search For Entery(by name): ");
        System.out.println("3 - exit");
         System.out.println("Select something: ");
         int choiceentry = fcc.nextInt();
         do {
         switch (choiceentry){
         case 1: EntryShowDelete esd1 = new EntryShowDelete();
                esd1.addUser();
                break;
         case 2: EntryShowDelete esd2 = new EntryShowDelete();
                 esd2.showSeacrhedUser();
                 break;
         case 3:  System.exit(0);
            }
         System.out.println("Select something: ");
         choiceentry = fcc.nextInt();
         }
         while (choiceentry!=3);
    }
}