package collabsoft.backlog_reports.c4;



import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

//import collabsoft.backlog_reports.c4.Report;

public class Report {

private Connection con;

 public Report(){
  connectUsingJDBC();
 }
 public static void main(String args[]){
  Report dc = new Report();
  dc.reviewMeeting(6, 8, 10);
dc.createReport("dede",100);
//dc.viewReport(100);
// dc.custRent(3344,123,22,11-11-2009);
 }

 /**
  the following method is used to connect to the database
 **/


 public  void connectUsingJDBC() {
  // This is the name of the ODBC data source 
  String dataSourceName = "Simple_DB";
  try {
   // loading the driver in the memory
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   // This is the connection URL
   String dbURL = "jdbc:odbc:" + dataSourceName; 
   con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Collabsoft","root","");
   // This line is used to print the name of the driver and it would throw an exception if a problem occured
   System.out.println("User connected using driver: " + con.getMetaData().getDriverName());

   //Addcustomer(con,1111,"aaa","aaa","aa","aam","111","2222","111");
   //rentedMovies(con);
   //executePreparedStatement(con);
   //executeCallableStatement(con);
   //executeBatch(con);

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

 /** 
  *this code is to link the SQL code with the java for the task
  *as an admin I should be able to create a report of a review meeting including notes, tasks and users
  *i will take the task id and user id and note id that will be needed to be added in the review
  *meeting report and i will display the information related to these ida
  **/




   public  void reviewMeeting(int taskID, int userID, int noteID)// law el proc bt return table
 {
  try{
   CallableStatement callableStatement = con.prepareCall("{CALL report_review_meeting(?,?,?)}");

         callableStatement.setInt(1,taskID);
                        callableStatement.setInt(2,userID);
                        callableStatement.setInt(3,noteID);

   ResultSet resultSet = callableStatement.executeQuery(); // or executeupdate() or updateQuery
   ResultSetMetaData rsm = resultSet.getMetaData();  
   int numOfColumns = rsm.getColumnCount();
   System.out.println("lojayna");

   while (resultSet.next()) 
   {
    System.out.println("New Row:");
    for (int i = 1; i <= numOfColumns; i++)
     System.out.print(rsm.getColumnName(i) + ": " + resultSet.getObject(i) + " ");
    System.out.println();
   }
  }
  catch(Exception e)
  { 
   System.out.println("E");
  }  
 } 



   //////////////////////////////////
   /////////////////////////////////



   public  void allproject(int projID)// law el proc bt return table
   {
    try{
     CallableStatement callableStatement = con.prepareCall("{CALL all_project(?)}");

           callableStatement.setInt(1,projID);
                          //callableStatement.setInt(2,userID);
                          //callableStatement.setInt(3,noteID);

     ResultSet resultSet = callableStatement.executeQuery(); // or executeupdate() or updateQuery
     ResultSetMetaData rsm = resultSet.getMetaData();  
     int numOfColumns = rsm.getColumnCount();
     System.out.println("lojayna");

     while (resultSet.next()) 
     {
      System.out.println("New Row:");
      for (int i = 1; i <= numOfColumns; i++)
       System.out.print(rsm.getColumnName(i) + ": " + resultSet.getObject(i) + " ");
      System.out.println();
     }
    }
    catch(Exception e)
    { 
     System.out.println("E");
    }  
   } 














   ///////////////////////////////












   /**
    * here i take the event id and i take a string report and then
    *  i relate the report with the event

    **/




     public  void createReport(String report,int E_ID )// law el proc bt return table
   {
    try{





     Statement st = con.createStatement();

  st.executeUpdate("UPDATE e_vent SET e_vent.report=report WHERE e_vent.E_ID= E_ID;");

    /* CallableStatement callableStatement = con.prepareCall("{CALL Create_report(?,?)}");

           callableStatement.setString(1,report);
                          callableStatement.setInt(2,E_ID);


     ResultSet resultSet = callableStatement.executeQuery(); // or executeupdate() or updateQuery
     ResultSetMetaData rsm = resultSet.getMetaData();  
     int numOfColumns = rsm.getColumnCount();
     System.out.println("lojayna");

     while (resultSet.next()) 
     {
      System.out.println("New Row:");
      for (int i = 1; i <= numOfColumns; i++)
       System.out.print(rsm.getColumnName(i) + ": " + resultSet.getObject(i) + " ");
      System.out.println();
     }*/
    }
    catch(Exception e)
    { 
     System.out.println("E");
     System.out.println(e);
    }  
   }




 /** 
  *in the following method i view the report of the event having the ID  eventID 
  **/





   public  void viewReport(int eventID)// law el proc bt return table
 {
  try{
   CallableStatement callableStatement = con.prepareCall("{CALL view_report(?)}");

         callableStatement.setInt(1,eventID);



   ResultSet resultSet = callableStatement.executeQuery(); // or executeupdate() or updateQuery
   ResultSetMetaData rsm = resultSet.getMetaData();  
   int numOfColumns = rsm.getColumnCount();
   System.out.println("lojayna");

   while (resultSet.next()) 
   {
    System.out.println("New Row:");
    for (int i = 1; i <= numOfColumns; i++)
     System.out.print(rsm.getColumnName(i) + ": " + resultSet.getObject(i) + " ");
    System.out.println();
   }
  }
  catch(Exception e)
  { 
   System.out.println("E");
  }  
 } 





















}

// the result of these methods is being showed on the console , i am using WIcket and i want it 2 be showed on the web how is that done ?!