Manage

The manage step provides data management functionality for your application and/or process.

Below is the code for Manage():

//

// Manage()

//

// This function performs record adds and updates using locking

//

VOID Manage(VOID)

{

   printf("MANAGE\n");

   // populate the table with data

   Add_CustomerMaster_Records();

   // display contents of table

   Display_Records();

   // update a record under locking control

   Update_CustomerMaster_Record();

   // display again after update and effects of lock

   Display_Records();

}

//

// Add_CustomerMaster_Records()

//

// This function adds records to table CustomerMaster from an

// array of strings

//

VOID Add_CustomerMaster_Records(VOID)

{

   typedef struct {

      cpTEXT number, zipcode, state, rating, name, address, city;

   } DATA_RECORD;

   DATA_RECORD data[] = {

      "1000", "92867", "CA", "1", "Bryan Williams", "2999 Regency",      "Orange",

      "1001", "61434", "CT", "1", "Michael Jordan", "13 Main",           "Harford",

      "1002", "73677", "GA", "1", "Joshua Brown",   "4356 Cambridge",    "Atlanta",

      "1003", "10034", "MO", "1", "Keyon Dooling",  "19771 Park Avenue", "Columbia"

   };

   CTSIGNED nRecords = sizeof(data) / sizeof(DATA_RECORD);

   Delete_Records(MyRecord);

   printf("\tAdd records...\n");

   try

   {

      for (CTSIGNED i = 0; i < nRecords; i++)

      {

         MyRecord.Clear();

         // populate record buffer with data

         MyRecord.SetFieldAsString(0, data[i].number);

         MyRecord.SetFieldAsString(1, data[i].zipcode);

         MyRecord.SetFieldAsString(2, data[i].state);

         MyRecord.SetFieldAsString(3, data[i].rating);

         MyRecord.SetFieldAsString(4, data[i].name);

         MyRecord.SetFieldAsString(5, data[i].address);

         MyRecord.SetFieldAsString(6, data[i].city);

         // add record

         MyRecord.Write();

      }

   }

   catch(CTException E)

   {

      Handle_Exception(E);

   }

}

//

// Delete_Records()

//

// This function deletes all the records in the table

//

VOID Delete_Records(CTRecord& record)

{

   CTBOOL   found;

   printf("\tDelete records...\n");

   try

   {

      // enable session-wide lock flag

      MySession.Lock(CTLOCK_WRITE_BLOCK);

      // read first record

      found = record.First();

      while (found)  // while records are found

      {

         // delete record

         record.Delete();

         // read next record

         found = record.Next();

      }

   }

   catch(CTException E)

   {

      Handle_Exception(E);

   }

}

//

// Display_Records()

//

// This function displays the contents of a table. First() and Next()

// fetch the record. Then each field is parsed and displayed

//

VOID Display_Records(VOID)

{

   CTBOOL   found;

   TEXT     custnumb[4+1];

   TEXT     custname[47+1];

   printf("\tDisplay records...");

   try

   {

      // read first record

      found = MyRecord.First();

      while (found)

      {

         strcpy(custnumb, MyRecord.GetFieldAsString(0).c_str());

         strcpy(custname, MyRecord.GetFieldAsString(4).c_str());

         // display data

         printf("\n\t\t%-8s%10s\n",custnumb, custname);

         // read next record

         found = MyRecord.Next();

      }

   }

   catch(CTException E)

   {

      Handle_Exception(E);

   }

}

//

// Update_CustomerMaster_Records()

//

// Update one record under locking control to demonstrate the effects

// of locking

//

VOID Update_CustomerMaster_Record(VOID)

{

   printf("\tUpdate record...\n");

   try

   {

      // enable session-wide lock flag

      MySession.Lock(CTLOCK_WRITE_BLOCK);

      MyRecord.Clear();

      MyRecord.SetFieldAsString(0, "1003");

      // find record by customer number

      if (MyRecord.Find(CTFIND_EQ))

      {

         MyRecord.SetFieldAsString(4, "KEYON DOOLING");

         // rewrite record

         MyRecord.Write();

         printf("\tPress <ENTER> key to unlock\n");

         getchar();

      }

   }

   catch(CTException E)

   {

      Handle_Exception(E);

   }

   MySession.Unlock();

}