package beans;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.*;
import database.Db_Connection;
import java.util.logging.Level;
import java.util.logging.Logger;

public class demande

{
    private String user_name,user_email,user_job,equipement,centre_cout,localisation,destinataire,priorite,observation;

 int Id;
    private String date,dateSouhaite;

    public demande(){
    user_name="";
    user_email="";
    user_job="";
    equipement="";
    centre_cout="";
    localisation="";
    destinataire="";
    priorite="";
    observation="";
    Id=1;

    date=null;

    dateSouhaite=null;


    }


    public demande(String user_name, String user_email, String user_job, String equipement, String centre_cout, String localisation, String destinataire, String priorite, String observation, int Id, String date, String dateSouhaite) {
        this.user_name = user_name;
        this.user_email = user_email;
        this.user_job = user_job;
        this.equipement = equipement;
        this.centre_cout = centre_cout;
        this.localisation = localisation;
        this.destinataire = destinataire;
        this.priorite = priorite;
        this.observation = observation;
        this.Id = Id;
        this.date = date;
        this.dateSouhaite = dateSouhaite;
    }




    //----------------------------------//
   public String getDate() {
        return date;
    }

    public String getCentre_cout() {
        return centre_cout;
    }

    public String getDateSouhaite() {
        return dateSouhaite;
    }

    public String getDestinataire() {
        return destinataire;
    }

    public int getId() {
        return Id;
    }

    public void setId(int Id) {
        this.Id = Id;
    }



    public String getEquipement() {
        return equipement;
    }

    public String getLocalisation() {
        return localisation;
    }

    public String getObservation() {
        return observation;
    }

    public String getPriorite() {
        return priorite;
    }

    public String getUser_job() {
        return user_job;
    }

    public String getUser_email() {
        return user_email;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setCentre_cout(String centre_cout) {
        this.centre_cout = centre_cout;
    }

    public void setDate(String date) {
        this.date = date;
    }

    public void setDateSouhaite(String dateSouhaite) {
        this.dateSouhaite = dateSouhaite;
    }

    public void setDestinataire(String destinataire) {
        this.destinataire = destinataire;
    }

    public void setEquipement(String equipement) {
        this.equipement = equipement;
    }

    public void setLocalisation(String localisation) {
        this.localisation = localisation;
    }

    public void setObservation(String observation) {
        this.observation = observation;
    }



    public void setPriorite(String priorite) {
        this.priorite = priorite;
    }

    public void setUser_email(String user_email) {
        this.user_email = user_email;
    }

    public void setUser_job(String user_job) {
        this.user_job = user_job;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }

    //----------------------------------//

    public void RegisterDemande()
    {
        try
        {
            Db_Connection dbconn=new Db_Connection();
            Connection myconnection= dbconn.Connection();

            String sqlString="INSERT INTO demandes(user_name,user_email,user_job,equipement,centre_cout,localisation,destinataire,priorite,observation,date,dateSouhaite) VALUES ('"+user_name+","+user_email+","+user_job+","+equipement+","+centre_cout+","+localisation+","+destinataire+","+priorite+","+observation+","+date+","+dateSouhaite+"')";

            Statement myStatement = myconnection.createStatement();

            try
            {
                myStatement.executeUpdate(sqlString);
                myStatement.close();
                myconnection.close();
            } catch (SQLException ex) {Logger.getLogger(demande.class.getName()).log(Level.SEVERE, null, ex);}
        } catch (SQLException ex) {Logger.getLogger(demande.class.getName()).log(Level.SEVERE, null, ex);}
    }

    //----------------------------------//

  /*  public static boolean LoginUser(String user,String pwd)
    {
            boolean check =false;
            try
            {
                Db_Connection dbconn=new Db_Connection();
                Connection myconnection= dbconn.Connection();

                PreparedStatement ps1 =myconnection.prepareStatement("select * from users where username=? and password=?");

                ps1.setString(1, user);
                ps1.setString(2, pwd);
                ResultSet rs1 =ps1.executeQuery();
                check = rs1.next();

                myconnection.close();
            }catch(Exception e){e.printStackTrace();}

            return check;
    }
    */
    //----------------------------------//

    public void GetDemande()
    {
            try
            {
                Db_Connection dbconn=new Db_Connection();
                Connection myconnection= dbconn.Connection();

                String sqlString = "SELECT * FROM demandes WHERE Id = '"+Id+"'";
                Statement myStatement = myconnection.createStatement();
                ResultSet rs=myStatement.executeQuery(sqlString);

                while(rs.next())
                {

                    user_name=rs.getString("user_name");
                    user_email=rs.getString("user_email");
                    user_job=rs.getString("user_job");
                    equipement=rs.getString("equipement");
                    centre_cout=rs.getString("centre_cout");
                    localisation=rs.getString("localisation");
                    destinataire=rs.getString("destinataire");
                            priorite=rs.getString("priorite");
                    observation=rs.getString("observation");


                    date=rs.getString("date");

                         date =rs.getString("dateSouhaite");

                }

                myStatement.close();
                myconnection.close();

            } catch (SQLException ex) {Logger.getLogger(demande.class.getName()).log(Level.SEVERE, null, ex);}

    }

    //----------------------------------//

    public void parseInt(String parameter) {
        throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

}