/*
 * SaveAnswer.java
 *
 * Created on 21. toukokuuta 2003, 11:38
 */

package kottarainenbeans;

import java.beans.*;
import kotkabeans.*;
import java.util.*;
/** Purpose is to get questionfields(and their results) with fieldindexes 
 * from db and to save answers
 *
 * @author  tylonen and tmpoyhon
 */
public class SaveAnswer extends Question implements java.io.Serializable {
    
    /** Holds value of property fieldIndexs. */
    private String[] fieldIndexes = new String[0];
    
    /** Holds value of property questions. */
    private String[] questions = new String[0];
    
    /** Indexed getter for property fieldIndexs.
     * @param index Index of the property.
     * @return Value of the property at <CODE>index</CODE>.
     *
     */
    public int getFieldIndexes(int index) {
        int i=0;
        try {
            i = Integer.parseInt(this.fieldIndexes[index]);
        } catch (NumberFormatException nfe) {
        }
        return i;
    }
    
    /** Getter for property fieldIndexs.
     * @return Value of property fieldIndexs.
     *
     */
    public String[] getFieldIndexes() {
        return this.fieldIndexes;
    }
    
    /** Indexed setter for property fieldIndexs.
     * @param index Index of the property.
     * @param fieldIndexs New value of the property at <CODE>index</CODE>.
     *
     */
    public void setFieldIndexes(int index, String fieldIndexes) {
        this.fieldIndexes[index] = fieldIndexes;
    }
    
    /** Setter for property fieldIndexs.
     * @param fieldIndexs New value of property fieldIndexs.
     *
     */
    public void setFieldIndexes(String[] fieldIndexes) {
        this.fieldIndexes = fieldIndexes;
    }
    
    public void getFieldsAndResults(Properties commonVars) {
       int howmanyFields=fieldIndexes.length;
       int i=0;
       DB db=new DB("Haetaan fieldit ja resultit vastausten tallettamiseksi");
       try{
         db.connect();
         while(i<howmanyFields){
            addSubElements(1);
            //state must be set here in order to get the questionresults
            ((Questionfield)getSubElements().lastElement()).setState(""+
              "answering");  
            ((Questionfield)getSubElements().lastElement()).update(commonVars);
            try{
               ((Questionfield)getSubElements().lastElement()).getValuesFromDb(
                 getFieldIndexes(i),db);
            } catch (Exception e) { }
            i++;
         }
         getRadioAndOptionAnswers(commonVars,db);
         for(i=0;i<questions.length;i++){
            //setting values for selectlists and radiogroups
            commonVars.setProperty(commonVars.getProperty(
              String.valueOf(getQuestions(i))),"on"); 
         }
         subElementsUpdate(commonVars);
         saveResults(db);
       } catch(Exception e){
       } finally {
          db.disconnect();
       }

    }
    /** Method removes previous answers from radiogroups and options and sets 
     * the new answer.
     */
    public void getRadioAndOptionAnswers(Properties commonVars,DB db){
       int howmany=questions.length;
       int i=0;
       while(i<howmany){
          addSubElements(1);
           // state must be set here in order to get the questionresults
          ((Questionfield)getSubElements().lastElement()).setState("answering"); 
          int id=getQuestions(i);
          deletePreviousAnswers(db,id,getPersonid());
          ((Questionfield)getSubElements().lastElement()).update(commonVars);
          try{
            ((Questionfield)getSubElements().lastElement()).getValuesFromDb(
              Integer.parseInt(commonVars.getProperty(String.valueOf(id))),db);
          } catch (Exception e) { }
          i++;
       }
    }
    
    /** Shoud be optimated to use upper method...*/
    private void deletePreviousAnswers(DB db,int questionid, int personid){
        String logInfo="Get questions and fields";
        Properties macroTable = new Properties();
        macroTable.setProperty("questionId", String.valueOf(questionid));
        String SQLsentence = 
          super.TH.CompleteTemplate("get_fields_with_personid",macroTable);
        RS2 rs;
        try {       
           rs = DBhandler.bringFromDatabase(db,"QuestionsFrDb",
             SQLsentence,"getFieldnumbersForQuestion");
        } catch (Exception e){ return; }
        try {
            while(rs.next()){
                macroTable.setProperty("questionfieldId",
                  String.valueOf(rs.getInt("questionfieldid")));
                macroTable.setProperty("personId",String.valueOf(personid));
                 //later here should be using real markerid!
                macroTable.setProperty("markerId",String.valueOf(personid)); 
                SQLsentence="DELETE FROM questionresult WHERE personid="+
                  personid+ " AND markerid="+ personid +" AND questionfieldid="+
                  rs.getInt("questionfieldid")+" ;";
                DBhandler.insertIntoDatabase(db,"DeleteAnswers",
                  SQLsentence,"Delete earlier answers"); //uses real DELETE 
            }
        } catch(Exception e){
        }
    }
    
    public void saveResults(DB db) {
        saveSubElementsTodb(db);
    }
    
    /** Indexed getter for property questions.
     * @param index Index of the property.
     * @return Value of the property at <CODE>index</CODE>.
     *
     */
    public int getQuestions(int index) {
        int i=0;
        try {
            i = Integer.parseInt(this.questions[index]);
        } catch (NumberFormatException nfe) {}
        return i;
    }
    
    /** Getter for property questions.
     * @return Value of property questions.
     *
     */
    public String[] getQuestions() {
        return this.questions;
    }
    
    /** Indexed setter for property questions.
     * @param index Index of the property.
     * @param questions New value of the property at <CODE>index</CODE>.
     *
     */
    public void setQuestions(int index, String questions) {
        this.questions[index] = questions;
    }
    
    /** Setter for property questions.
     * @param questions New value of property questions.
     *
     */
    public void setQuestions(String[] questions) {
        this.questions = questions;
    }
    
}