|
|
|
Manage() provides data management functionality for your application and/or process.
Below is the code for Manage():
//
// Manage()
//
// This function performs simple record functions of add, delete and gets
//
VOID Manage(VOID)
{
printf("MANAGE\n");
// delete any existing records
Delete_Records();
// populate the table with data
Add_Records();
// display contents of table
Display_Records();
}
//
// Delete_Records()
//
// This function deletes all the records in the table
//
VOID Delete_Records(VOID)
{
CTBOOL found;
printf("\tDelete records...\n");
try
{
// read first record
found = MyRecord.First();
while (found) // while records are found
{
// delete record
MyRecord.Delete();
// read next record
found = MyRecord.Next();
}
}
catch(CTException E)
{
Handle_Exception(E);
}
}
//
// Add_Records()
//
// This function adds records to a table in the database from an
// array of strings
//
VOID Add_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);
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);
}
}
//
// 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[47+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());
printf("\n\t\t%-8s%-20s\n",custnumb, custname);
// read next record
found = MyRecord.Next();
}
}
catch(CTException E)
{
Handle_Exception(E);
}
}
