/*
 * SubjectData.java
 *
 * Created on March 18, 2002, 2:31 PM
 */

package subjectData;

/**
 *
 * @author  Joset A. Etzel
 */
import java.sql.*; import java.awt.*; import java.util.*; import java.lang.*;
import javax.swing.*; import java.awt.event.*; import subjectData.*; 

import java.awt.Toolkit; import javax.swing.ImageIcon;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import javax.swing.UIManager;

public class SubjectData extends javax.swing.JFrame {
  private static String strDBtoConnect = "";
  private static String strDBPassword = ""; private static String strDBUserID = "";
	private static String strSavePlace = "";
	
	private static ArrayList jcDBNames = new ArrayList();
    
    /** Creates new form SubjectData */
  public SubjectData() {
    initComponents();
    setIconImage(Toolkit.getDefaultToolkit().getImage("ParasolSmall.gif"));

	readConfigurationFile();  //get the database names from the config file
	mnuConnectToDatabase.doClick();  //and show the form
    
    desktopPane.setSize(new java.awt.Dimension(700, 600));
  }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
  private void initComponents() {//GEN-BEGIN:initComponents
    desktopPane = new javax.swing.JDesktopPane();
    menuBar = new javax.swing.JMenuBar();
    fileMenu = new javax.swing.JMenu();
    mnuComboBoxes = new javax.swing.JMenuItem();
    mnuConnectToDatabase = new javax.swing.JMenuItem();
    jSeparator1 = new javax.swing.JSeparator();
    exitMenuItem = new javax.swing.JMenuItem();
    editMenu = new javax.swing.JMenu();
    mnuAddSubject = new javax.swing.JMenuItem();
    mnuNewSession = new javax.swing.JMenuItem();
    viewMenu = new javax.swing.JMenu();
    mnuQuery = new javax.swing.JMenuItem();
    mnuDBKey = new javax.swing.JMenuItem();

    setTitle("SubDB");
    addWindowListener(new java.awt.event.WindowAdapter() {
      public void windowClosing(java.awt.event.WindowEvent evt) {
        exitForm(evt);
      }
    });

    desktopPane.setMinimumSize(new java.awt.Dimension(800, 800));
    getContentPane().add(desktopPane, java.awt.BorderLayout.CENTER);

    fileMenu.setMnemonic('F');
    fileMenu.setText("File");
    mnuComboBoxes.setText("Change Combobox Choices");
    mnuComboBoxes.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuComboBoxesActionPerformed(evt);
      }
    });

    fileMenu.add(mnuComboBoxes);

    mnuConnectToDatabase.setText("Connect to a database");
    mnuConnectToDatabase.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuConnectToDatabaseActionPerformed(evt);
      }
    });

    fileMenu.add(mnuConnectToDatabase);

    fileMenu.add(jSeparator1);

    exitMenuItem.setText("Exit");
    exitMenuItem.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        exitMenuItemActionPerformed(evt);
      }
    });

    fileMenu.add(exitMenuItem);

    menuBar.add(fileMenu);

    editMenu.setMnemonic('A');
    editMenu.setText("Alter Database");
    mnuAddSubject.setText("Work With Subjects");
    mnuAddSubject.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuAddSubjectActionPerformed(evt);
      }
    });

    editMenu.add(mnuAddSubject);

    mnuNewSession.setText("Work With Sessions");
    mnuNewSession.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuNewSessionActionPerformed(evt);
      }
    });

    editMenu.add(mnuNewSession);

    menuBar.add(editMenu);

    viewMenu.setMnemonic('V');
    viewMenu.setText("View");
    mnuQuery.setText("Query Database");
    mnuQuery.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuQueryActionPerformed(evt);
      }
    });

    viewMenu.add(mnuQuery);

    mnuDBKey.setText("Database Key");
    mnuDBKey.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        mnuDBKeyActionPerformed(evt);
      }
    });

    viewMenu.add(mnuDBKey);

    menuBar.add(viewMenu);

    setJMenuBar(menuBar);

    java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
    setBounds((screenSize.width-780)/2, (screenSize.height-600)/2, 780, 600);
  }//GEN-END:initComponents

  private void mnuNewSessionActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuNewSessionActionPerformed
    //show frmConnectToDatabase	
	
	frmSessionData frmSessionData1 = new frmSessionData();
    desktopPane.add(frmSessionData1, javax.swing.JLayeredPane.DEFAULT_LAYER);
    frmSessionData1.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
    frmSessionData1.setBounds(20, 20, 656, 445);
    frmSessionData1.show();
  }//GEN-LAST:event_mnuNewSessionActionPerformed

  private void mnuConnectToDatabaseActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuConnectToDatabaseActionPerformed
	//show frmConnectToDatabase	
	
	frmConnectToDatabase frmConnectToDatabase1 = new frmConnectToDatabase();
    desktopPane.add(frmConnectToDatabase1, javax.swing.JLayeredPane.DEFAULT_LAYER);
    frmConnectToDatabase1.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
    frmConnectToDatabase1.setBounds(50, 40, 400, 300);
    frmConnectToDatabase1.show();
  }//GEN-LAST:event_mnuConnectToDatabaseActionPerformed

	public static String AddEscapeChars(String strSQL) {
		//adds another \ in front of all \, ', and " so everything saved ok
    int intC = 0;
        
    StringBuffer strbNew = new StringBuffer(strSQL);
			for (intC = 0; intC < strSQL.length(); intC++) {   //parse string, looking for dangerous characters
				if (strbNew.charAt(intC) == '\\' | strbNew.charAt(intC) == '\"' | strbNew.charAt(intC) == '\'') {
					strbNew.insert(intC,'\\'); intC++; 
				}   //insert escape char, increment counter to pass \
      }
      String strNew = new String(strbNew);  //convert character array back to string
     return strNew; 
    }
	
	   public static boolean CheckTime(String strTemp, String strBox) {
      //returns true if string strTemp is in format hh:mm, military time.  
      String strTime = ""; String strMinute = ""; String strHour = ""; 
      int intHour = 0; int intMinute = 0;
      
      //check if zeros included, ok if they are
      if (strTemp.length() == 8 && strTemp.substring(5).equals(":00") == true) { strTime = strTemp.substring(0, 5); }
      else { strTime = strTemp; }
      
      if (strTime.equals("") == true) { JOptionPane.showMessageDialog(null, "A time must be entered in " + strBox + ".\nPlease enter the time the clips started exactly as hh:mm in " + strBox + ".\nThe hours should be in military time, 01 to 24 hours.", "Data Error", JOptionPane.ERROR_MESSAGE); return false; }        
      if (strTime.indexOf(":") != 2 | strTime.length() != 5) { JOptionPane.showMessageDialog(null, "Please enter the time the clips started exactly as hh:mm in " + strBox + ".\nThe hours should be in military time, 01 to 24 hours.", "Data Error", JOptionPane.ERROR_MESSAGE); return false; }        
      
      strHour = strTime.substring(0,2); strMinute = strTime.substring(3);  //parse out the string parts
      intMinute = Integer.parseInt(strMinute); intHour = Integer.parseInt(strHour);  //convert to int
      
      if (intMinute < 0 | intMinute > 60) { JOptionPane.showMessageDialog(null, "The minutes must be between 00 and 60.\nPlease enter the time the clips started exactly as hh:mm in " + strBox + ".\nThe hours should be in military time, 01 to 24 hours.", "Data Error", JOptionPane.ERROR_MESSAGE); return false; }        
      if (intHour < 0 | intHour > 24) { JOptionPane.showMessageDialog(null, "The hours must be between 00 and 24.\nPlease enter the time the clips started exactly as hh:mm in " + strBox + ".\nThe hours should be in military time, 01 to 24 hours.", "Data Error", JOptionPane.ERROR_MESSAGE); return false; }        

      return true;  //haven't exited, so string is ok
    }
		 
	 public static boolean CheckDate(String strTemp, String strBox) {
        //function checks if the date passed (strDate) is in a valid format returns true if so, false if not
        String strMonth = ""; String strDay = ""; String strYear = ""; boolean bolReturn = true;
        int intYear = 0; int intMonth = 0; int intDay = 0;
        
        if (strTemp.equals("0000-00-00") == true | strTemp.equals("") == true) { return true; }  //zero string is ok
        if (strTemp.indexOf("-") == -1) { JOptionPane.showMessageDialog(null, "The date in in " + strBox + " must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        strYear = strTemp.substring(0, strTemp.indexOf("-"));
        intYear = strTemp.indexOf("-") + 1;
        strTemp = strTemp.substring(intYear);
        if (strTemp.indexOf("-") == -1) { JOptionPane.showMessageDialog(null, "The date in in " + strBox + " must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        strMonth = strTemp.substring(0, strTemp.indexOf("-"));  //now can parse out the next part - the month
        intYear = strTemp.indexOf("-") + 1;
        strDay = strTemp.substring(intYear);  //take out the month, leaves day
        
        intYear = Integer.parseInt(strYear); intMonth = Integer.parseInt(strMonth); intDay = Integer.parseInt(strDay);
        if (strYear.length() != 4) { JOptionPane.showMessageDialog(null, "Please use four digits for the year in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        if (strMonth.length() != 2) { JOptionPane.showMessageDialog(null, "Please use two digits for the month (01 to 12) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        if (strDay.length() != 2) { JOptionPane.showMessageDialog(null, "Please use two digits for the day (01 to 31) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        if (intYear < 1800 | intYear > 2200) { JOptionPane.showMessageDialog(null, "Please use four digits for the year in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        if (intMonth < 1 | intMonth > 12) { JOptionPane.showMessageDialog(null, "Please use two digits for the month (01 to 12) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        if (intDay < 1 | intDay > 31) { JOptionPane.showMessageDialog(null, "Please use two digits for the day (01 to 31) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
        
        return true;  //if haven't exited yet, date is ok so return true
    }
		 
		 
	private void mnuConnectEricaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuConnectEricaActionPerformed
	}//GEN-LAST:event_mnuConnectEricaActionPerformed

	private void mnuConnectEduardoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuConnectEduardoActionPerformed
	}//GEN-LAST:event_mnuConnectEduardoActionPerformed

  private static void readConfigurationFile() {
    //open subjectDataConfig.txt and read the database names contained in it, filling up jcDBNames.
	//tell the user if there is a problem with the file.
	BufferedReader config = null; String strLine = null; File fileConfig; String strPath = "";

	//check if the configuration file exists at the expected location, exit if it can not be read
	fileConfig = new File("subjectDataConfig.txt");  
	if (fileConfig.exists() == false) {
	  JOptionPane.showMessageDialog(null, "The configuration file, subjectDataConfig.txt, does not exist.", "Startup Error", JOptionPane.ERROR_MESSAGE);
	  System.exit(1); 
	}
	if (fileConfig.canRead() == false) {
	  JOptionPane.showMessageDialog(null, "The configuration file, subjectDataConfig.txt, can not be read.", "Startup Error", JOptionPane.ERROR_MESSAGE);
	  System.exit(1); 
	}
	 if (fileConfig.isFile() == false) {
	  JOptionPane.showMessageDialog(null, "The configuration file, subjectDataConfig.txt, file is not valid.", "Startup Error", JOptionPane.ERROR_MESSAGE);
	  System.exit(1); 
	} 

	//read in the configuration file
	try {
	  config = new BufferedReader(new FileReader("subjectDataConfig.txt"));
	  while ((strLine = config.readLine()) != null) {
		if (strLine.startsWith("dbname")) {
		  strPath = strLine.substring(strLine.indexOf("=")+1);
		  if (strPath.equals("")) {
			JOptionPane.showMessageDialog(null, "The subjectDataConfig.txt file must contain a valid dbname entry.", "Startup Error", JOptionPane.ERROR_MESSAGE);
			System.exit(1);
		  }
		  jcDBNames.add(strPath);
		}
		else if (strLine.startsWith("savePlace")) {
			strPath = strLine.substring(strLine.indexOf("=")+1);
		  if (!strPath.equals("")) { strSavePlace = strPath; }
		}
	}
		
	} catch (java.io.FileNotFoundException e) {
	  System.out.println("couldn't find subjectDataConfig.txt");
	  System.exit(1);
	} catch (java.io.IOException e) {
	  System.out.println("IOException: " + e.getMessage());
	  e.printStackTrace();
	  System.exit(1);
	}
  }
	
  
  public static ArrayList getDBNames() { return jcDBNames; }
	
	public static String getSavePlace() { return strSavePlace; }
  
  public static void setDBName(String strDBName) { strDBtoConnect = strDBName; }
    
  public static void setDBUserID(String strDBUserID1) { strDBUserID = strDBUserID1; }

  public static void setDBPassword(String strDBPassword1) { strDBPassword = strDBPassword1; }
  
  
    private void mnuDBKeyActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuDBKeyActionPerformed
      //loads the class ViewDatabaseKey and shows it in the DeskTopPane (a JInternalFrame)
			
      ViewDatabaseKey frmKey = new ViewDatabaseKey();
      desktopPane.add(frmKey, javax.swing.JLayeredPane.DEFAULT_LAYER);
      frmKey.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
			frmKey.setBounds(50, 40, 650, 400);
        frmKey.show();
    }//GEN-LAST:event_mnuDBKeyActionPerformed

    private void mnuQueryActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuQueryActionPerformed
      //loads the class TableTest and shows it in the DeskTopPane (a JInternalFrame)
      TableTest frmTable = new TableTest();
      desktopPane.add(frmTable, javax.swing.JLayeredPane.DEFAULT_LAYER);
      frmTable.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
      frmTable.setBounds(50, 40, 650, 450);
      frmTable.show();
    }//GEN-LAST:event_mnuQueryActionPerformed

    private void mnuComboBoxesActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuComboBoxesActionPerformed
      //loads the class AlterCombos and shows it in the DeskTopPane (a JInternalFrame)
      AlterCombos frmCombos = new AlterCombos();
      desktopPane.add(frmCombos, javax.swing.JLayeredPane.DEFAULT_LAYER);
      frmCombos.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
      frmCombos.setBounds(50, 40, 600, 200);
      frmCombos.show();
    }//GEN-LAST:event_mnuComboBoxesActionPerformed
        
    private void mnuAddSubjectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_mnuAddSubjectActionPerformed
        //loads the class SubjectInfo and shows it in the DeskTopPane (a JInternalFrame)
        SubjectInfo frmSubject = new SubjectInfo();
        desktopPane.add(frmSubject, javax.swing.JLayeredPane.DEFAULT_LAYER);
        frmSubject.setFrameIcon(new ImageIcon("ParasolSmall.gif"));
        frmSubject.setBounds(10, 10, 750, 300);
        frmSubject.show();        
    }//GEN-LAST:event_mnuAddSubjectActionPerformed
        
    private void exitMenuItemActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_exitMenuItemActionPerformed
        System.exit(0); 
    }//GEN-LAST:event_exitMenuItemActionPerformed
    
    /** Exit the Application */
    private void exitForm(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_exitForm
        System.exit(0);
    }//GEN-LAST:event_exitForm
    	

	public static Connection getDatabaseConnection() {
	  //return a Connection to the database named in strDBtoConnect
	  
	  try {
        Class.forName("org.gjt.mm.mysql.Driver");
		Connection conData = DriverManager.getConnection("jdbc:mysql://localhost/" + strDBtoConnect, strDBUserID, strDBPassword);
		return conData;
	  } 
	  catch (Exception e) { e.printStackTrace(); return null; }
	}
		
	
    /**
     * @param args the command line arguments
     */
  public static void main(String args[]) {
	try {
	  UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
	} catch (Exception e) {
	  System.out.println("Couldn't use the native look and feel "); e.printStackTrace();
	}
	
    new SubjectData().show();
  }
    
  // Variables declaration - do not modify//GEN-BEGIN:variables
  private javax.swing.JDesktopPane desktopPane;
  private javax.swing.JMenu editMenu;
  private javax.swing.JMenuItem exitMenuItem;
  private javax.swing.JMenu fileMenu;
  private javax.swing.JSeparator jSeparator1;
  private javax.swing.JMenuBar menuBar;
  private javax.swing.JMenuItem mnuAddSubject;
  private javax.swing.JMenuItem mnuComboBoxes;
  private javax.swing.JMenuItem mnuConnectToDatabase;
  private javax.swing.JMenuItem mnuDBKey;
  private javax.swing.JMenuItem mnuNewSession;
  private javax.swing.JMenuItem mnuQuery;
  private javax.swing.JMenu viewMenu;
  // End of variables declaration//GEN-END:variables
    
}