#include "hgupstoreoptmed.h"
#define SQLCA_STORAGE_CLASS extern
#define ORACA_STORAGE_CLASS extern
#include <oraca.h>
#include <sqlca.h>

#define MAXOPTPAR 50

// ************************************************************************
// ----------------------  storeObj  --------------------------------------
// ************************************************************************

long HGupStoreOptMed::storeObj() {

  // stores a new object in OPTIC_CHERENKOV

  if (mediumName.length() <= 0) {
    cerr << "error in HGupStoreMatlist::storeObj: materialName empty string"
         << endl;
    return -1;
  };

  EXEC SQL BEGIN DECLARE SECTION;
    char Medium_Name[MAXOPTPAR][20];
    float Ppckov[MAXOPTPAR];
    float Absco[MAXOPTPAR];
    float Effic[MAXOPTPAR];
    float Rindex[MAXOPTPAR];
    int Vers_Index[MAXOPTPAR];
    int RowsToInsert;
  EXEC SQL END DECLARE SECTION;

  nOptParam=ppckov.length();
  RowsToInsert=nOptParam;
  if (nOptParam>MAXOPTPAR) {
    cerr << "number of optical parameters for media= " << nOptParam 
         << " too large" << endl;
    return -1;
  }
  for (int i=0;i<nOptParam;i++) {
    strcpy(Medium_Name[i],mediumName);
    Ppckov[i]=ppckov[i];
    Absco[i]=absco[i];
    Effic[i]=effic[i];
    Rindex[i]=rindex[i];
    Vers_Index[i]=versIndex;
  }

  EXEC SQL WHENEVER SQLERROR DO
    sqlHandleError("sql error in HGupStoreOptMed::storeObj");

  EXEC SQL FOR : RowsToInsert INSERT INTO HADES_OPER.OPTIC_CHERENKOV
    (MEDIUM_NAME, PPCKOV, ABSCO, EFFIC, RINDEX, VERS_INDEX)
    VALUES
    (:Medium_Name, :Ppckov, :Absco, :Effic, :Rindex, :Vers_Index);

  return sqlca.sqlcode;
}


// ************************************************************************
// ----------------------  printInput  ------------------------------------
// ************************************************************************

void HGupStoreOptMed::printInput() {

  HString bl="  ";
  cout << "Insert in table OPTIC_CHERENKOV" << '\n';
  cout << "MEDIUM_NAME:  " << mediumName << '\n';
  cout << "VERS_INDEX:   " << versIndex << '\n';
  cout << "PPCKOV, ABSCO, EFFIC, RINDEX" << '\n';
  for (int i=0;i<nOptParam;i++) {
    cout << ppckov[i] << bl << absco[i] << bl << effic[i] << bl
         << rindex[i] << '\n';
  }
  cout << "-------------------------------------------------------"<< '\n';
  return;
}


// ************************************************************************
// ----------------------  writeInput  ------------------------------------
// ************************************************************************

void HGupStoreOptMed::writeInput(ofstream & fout) {
  // writes input to logfile

  HString bl="  ";
  fout << "Insert in table OPTIC_CHERENKOV" << '\n';
  fout << "MEDIUM_NAME:  " << mediumName << '\n';
  fout << "VERS_INDEX:   " << versIndex << '\n';
  fout << "PPCKOV, ABSCO, EFFIC, RINDEX" << '\n';
  for (int i=0;i<nOptParam;i++) {
    fout << ppckov[i] << bl << absco[i] << bl << effic[i] << bl
         << rindex[i] << '\n';
  }
  fout << "-------------------------------------------------------"<< '\n';
  return;
}