var serverURL    = "server.asp";
var strDelimiter = "~";

//
// Photo Gallery table
//
var numGalleryID      = new Array( 30 );
var strGalleryFILE    = new Array( 30 );
var numGalleryWIDTH   = new Array( 30 );
var numGalleryHEIGHT  = new Array( 30 );
var strGalleryCAPTION = new Array( 30 );

function retrieveGallery ( myArray, numFound )
{
   var x,
       y,
       numPictures = numFound / 5;

   for ( x = 1; x < 30; x++ )
      {
      numGalleryID      [x] = 0;
      strGalleryFILE    [x] = "";
      numGalleryWIDTH   [x] = 0;
      numGalleryHEIGHT  [x] = 0;
      strGalleryCAPTION [x] = "";
      }

   for ( x = 0, y = 1; y <= numPictures; x += 5, y++ )
      {
      numGalleryID      [y] = jsIntegerConvert( myArray [x + 0] );
      strGalleryFILE    [y] = jsStringConvert ( myArray [x + 1] );
      numGalleryWIDTH   [y] = jsIntegerConvert( myArray [x + 2] );
      numGalleryHEIGHT  [y] = jsIntegerConvert( myArray [x + 3] );
      strGalleryCAPTION [y] = jsStringConvert ( myArray [x + 4] );
      }

   return;
}

function Lookup_Gallery ( strCategory )
{
   var myVar,
       myArray,
       numFound;

   myVar      = RSExecute ( serverURL, "lookupGallery", strCategory );
   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      retrieveGallery ( myArray, numFound );

   return numFound / 5;
}

//
//  Events table
//
var numEventsID;
var datEventsSTART_DATE;
var datEventsEVENT_DATE;
var strEventsEVENT_NAME;
var strEventsEVENT_PICTURE;
var strEventsEVENT_DESCR;

function retrieveEvent ( myArray )
{
   numEventsID            = jsIntegerConvert ( myArray [ 0] );
   datEventsSTART_DATE    = jsDateConvert    ( myArray [ 1] );
   datEventsEVENT_DATE    = jsDateConvert    ( myArray [ 2] );
   strEventsEVENT_NAME    = jsStringConvert  ( myArray [ 3] );
   strEventsEVENT_PICTURE = jsStringConvert  ( myArray [ 4] );
   strEventsEVENT_DESCR   = jsStringConvert  ( myArray [ 5] );

   return true;
}

function Lookup_Event ( Event_Number )
{
   var myVar,
       myArray,
       numFound;

   numEventsID            = 0;
   datEventsSTART_DATE    = "";
   datEventsEVENT_DATE    = "";
   strEventsEVENT_NAME    = "";
   strEventsEVENT_PICTURE = "";
   strEventsEVENT_DESCR   = "";

   myVar      = RSExecute ( serverURL, "lookupEvent", Event_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      {
      retrieveEvent ( myArray );
      }

   return ( numFound );
}

//
//  Services table
//
var numServicesID;
var strServicesTOPIC;
var strServicesDESCRIPTION;

function retrieveServices ( myArray )
{
   numServicesID          = jsIntegerConvert ( myArray [ 0] );
   strServicesTOPIC       = jsStringConvert  ( myArray [ 1] );
   strServicesDESCRIPTION = jsStringConvert  ( myArray [ 2] );

   return true;
}

function Lookup_Services ( Services_Number )
{
   var myVar,
       myArray,
       numFound;

   numServicesID          = 0;
   strServicesTOPIC       = "";
   strServicesDESCRIPTION = "";

   myVar      = RSExecute ( serverURL, "lookupServices", Services_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      retrieveServices ( myArray );

   return ( numFound );
}

//
//  Contribute table
//
var numContributeID;
var strContributeTOPIC;
var strContributeDESCRIPTION;

function retrieveContribute ( myArray )
{
   numContributeID          = jsIntegerConvert ( myArray [ 0] );
   strContributeTOPIC       = jsStringConvert  ( myArray [ 1] );
   strContributeDESCRIPTION = jsStringConvert  ( myArray [ 2] );

   return true;
}

function Lookup_Contribute ( Contribute_Number )
{
   var myVar,
       myArray,
       numFound;

   numContributeID          = 0;
   strContributeTOPIC       = "";
   strContributeDESCRIPTION = "";

   myVar      = RSExecute ( serverURL, "lookupContribute", Contribute_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      retrieveContribute ( myArray );

   return ( numFound );
}

//
//  Involved table
//
var numInvolvedID;
var strInvolvedTOPIC;
var strInvolvedDESCRIPTION;

function retrieveInvolved ( myArray )
{
   numInvolvedID          = jsIntegerConvert ( myArray [ 0] );
   strInvolvedTOPIC       = jsStringConvert  ( myArray [ 1] );
   strInvolvedDESCRIPTION = jsStringConvert  ( myArray [ 2] );

   return true;
}

function Lookup_Involved ( Involved_Number )
{
   var myVar,
       myArray,
       numFound;

   numInvolvedID          = 0;
   strInvolvedTOPIC       = "";
   strInvolvedDESCRIPTION = "";

   myVar      = RSExecute ( serverURL, "lookupInvolved", Involved_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      retrieveInvolved ( myArray );

   return ( numFound );
}

//
//  Pamphlets table
//
var numPamphletsID;
var strPamphletsPROMPT;
var strPamphletsPAMPHLET;
var strPamphletsDESCRIPTION;

function retrievePamphlet ( myArray )
{
   numPamphletsID          = jsIntegerConvert ( myArray [ 0] );
   strPamphletsPROMPT      = jsStringConvert  ( myArray [ 1] );
   strPamphletsPAMPHLET    = jsStringConvert  ( myArray [ 2] );
   strPamphletsDESCRIPTION = jsStringConvert  ( myArray [ 3] );

   return true;
}

function Lookup_Pamphlet ( Pamphlet_Number )
{
   var myVar,
       myArray,
       numFound;

   numPamphletsID          = 0;
   strPamphletsPROMPT      = "";
   strPamphletsPAMPHLET    = "";
   strPamphletsDESCRIPTION = "";

   myVar      = RSExecute ( serverURL, "lookupPamphlet", Pamphlet_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      {
      retrievePamphlet ( myArray );
      }

   return ( numFound );
}

function Lookup_FOL_eMail ( strEmail_Address )
{
   var myVar,
       myArray,
       numFound;

   myVar      = RSExecute ( serverURL, "lookupFOL_eMail", strEmail_Address );
   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   return ( numFound );
}

//
//  Books table
//
var numBooksID;
var numBooksCATEGORY_ID;
var numBooksPUBLISHER_ID;
var strBooksPUBLISHER_SKU;
var strBooksBOOK_NAME;
var strBooksBOOK_AUTHOR;
var strBooksBOOK_PICTURE;
var strBooksBOOK_DESCR;
var numBooksBOOK_COST;
var numBooksBOOK_PRICE;
var numBooksONHAND;
var numBooksTOTORDERS;
var datBooksLASTORDER_DATE;

function retrieveBook ( myArray )
{
   numBooksID             = jsIntegerConvert ( myArray [ 0] );
   numBooksCATEGORY_ID    = jsIntegerConvert ( myArray [ 1] );
   numBooksPUBLISHER_ID   = jsIntegerConvert ( myArray [ 2] );
   strBooksPUBLISHER_SKU  = jsStringConvert  ( myArray [ 3] );
   strBooksBOOK_NAME      = jsStringConvert  ( myArray [ 4] );
   strBooksBOOK_AUTHOR    = jsStringConvert  ( myArray [ 5] );
   strBooksBOOK_PICTURE   = jsStringConvert  ( myArray [ 6] );
   strBooksBOOK_DESCR     = jsStringConvert  ( myArray [ 7] );
   numBooksBOOK_COST      = jsFloatConvert   ( myArray [ 8] );
   numBooksBOOK_PRICE     = jsFloatConvert   ( myArray [ 9] );
   numBooksONHAND         = jsIntegerConvert ( myArray [10] );
   numBooksTOTORDERS      = jsIntegerConvert ( myArray [11] );
   datBooksLASTORDER_DATE = jsDateConvert    ( myArray [12] );

   return true;
}

function Lookup_Book ( Book_Number )
{
   var myVar,
       myArray,
       numFound;

   numBooksID             = 0;
   numBooksCATEGORY_ID    = 0;
   numBooksPUBLISHER_ID   = 0;
   strBooksPUBLISHER_SKU  = "";
   strBooksBOOK_NAME      = "";
   strBooksBOOK_AUTHOR    = "";
   strBooksBOOK_PICTURE   = "";
   strBooksBOOK_DESCR     = "";
   numBooksBOOK_COST      = 0;
   numBooksBOOK_PRICE     = 0;
   numBooksONHAND         = 0;
   numBooksTOTORDERS      = 0;
   datBooksLASTORDER_DATE = "";

   myVar      = RSExecute ( serverURL, "lookupBook", Book_Number );

   myArray    = myVar.return_value.split( strDelimiter );
   numFound   = myArray.length-1;

   if ( numFound > 0 )
      retrieveBook ( myArray );

   return ( numFound );
}

//
//  Users table
//

var numUsersID;
var strUsersUSER_ID;
var strUsersPASSWORD;
var strUsersNAME;
var numUsersLOGINATTEMPTS;
var numUsersLOGINS = 35;

function jsSplitString ( strUsersCOUNCIL_NUMBER, strDelimiter )
{
   arrEdit_Councils = strUsersCOUNCIL_NUMBER.split ( strDelimiter );

   return 1;
}

function retrieveUser ( myArray )
{
   var x;

   numUsersID            = jsIntegerConvert ( myArray [ 0] );
   strUsersUSER_ID       = jsStringConvert  ( myArray [ 1] );
   strUsersPASSWORD      = jsStringConvert  ( myArray [ 2] );
   strUsersNAME          = jsStringConvert  ( myArray [ 3] );
   numUsersLOGINATTEMPTS = jsIntegerConvert ( myArray [ 4] );
   numUsersLOGINS        = jsIntegerConvert ( myArray [ 5] );

   return true;
}

function Lookup_User ( UserName, PassWord )
{
   var myVar,
       userArray,
       stateArray,
       councilArray,
       numFound,
       numFoundUser;

   var dtmVar    = new Date(),
       numHour,
       strIntro  = "Hello . . . ";

   numHour = dtmVar.getHours();

   if ( numHour >= 5 && numHour < 12 )
      strIntro = "Good Morning";

   if ( numHour >= 12 && numHour < 18 )
      strIntro = "Good Afternoon";

   if ( numHour >= 18 && numHour < 24 )
      strIntro = "Good Evening";

   myVar              = RSExecute ( serverURL, "lookupUser", UserName, PassWord );

   userArray          = myVar.return_value.split( strDelimiter );
   numFoundUser       = userArray.length-1;

   if ( numFoundUser > 0 )
      {
      retrieveUser  ( userArray );

      strCouncilOfficePrompt = strIntro + " " + strUsersNAME;
      }

   return ( numFoundUser );
}

function Test_User ( UserName, PassWord )
{
   var myVar,
       userArray,
       numFoundUser;

   myVar        = RSExecute ( serverURL, "testUser", UserName, PassWord );

   userArray    = myVar.return_value.split( strDelimiter );
   numFoundUser = userArray.length-1;

   return ( numFoundUser );
}

function Lookup_Name ( strName )
{
   var myVar,
       userArray,
       numFoundUser;

   myVar        = RSExecute ( serverURL, "lookupName", strName );

   userArray    = myVar.return_value.split( strDelimiter );
   numFoundUser = userArray.length-1;

   return ( numFoundUser );
}

function Add_New_Order ( strToday, strName, strAddress, strCity, strState, strZip, strPhone, strEmail, strShipName, strShipAddress, strShipCity, strShipState, strShipZip, numTot_Price, numTotShip, numTotTax, numTotal )
{
   var myVar,
       userArray,
       NewOrderNumber;

   myVar          = RSExecute ( serverURL, "addOrder", strToday, strName, strAddress, strCity, strState, strZip, strPhone, strEmail, strShipName, strShipAddress, strShipCity, strShipState, strShipZip, numTot_Price, numTotShip, numTotTax, numTotal );

   userArray      = myVar.return_value.split( strDelimiter );

   NewOrderNumber = jsIntegerConvert ( userArray [0] );

   return ( NewOrderNumber );
}

function Add_New_OrdItem ( strToday, numOrderNumber, numBookID, numQuantity, numPrice, numShipping, numTax )
{
   var myVar,
       userArray,
       NewOrdItem;

   //
   // Note that the strToday variable is for the updating of the books record..
   //
   myVar          = RSExecute ( serverURL, "addOrdItem", strToday, numOrderNumber, numBookID, numQuantity, numPrice, numShipping, numTax );

   userArray      = myVar.return_value.split( strDelimiter );

   NewOrdItem = jsIntegerConvert ( userArray [0] );

   return ( NewOrdItem );

}