static void Add_Records()
{
DATA_RECORD[] data = new DATA_RECORD[4];
data[0] = new DATA_RECORD("1000", "92867", "CA", "1", "Bryan Williams", "2999 Regency", "Orange");
data[1] = new DATA_RECORD("1001", "61434", "CT", "1", "Michael Jordan", "13 Main", "Harford");
data[2] = new DATA_RECORD("1002", "73677", "GA", "1", "Joshua Brown", "4356 Cambridge", "Atlanta");
data[3] = new DATA_RECORD("1003", "10034", "MO", "1", "Keyon Dooling", "19771 Park Avenue", "Columbia");
int nRecords = data.Length;
Console.WriteLine("\tAdd records...");
try
{
for (int 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);
}
}
private void Add_CustomerMaster_Records()
{
DateTime dt = DateTime.Now;
string line = dt.ToString();
Log(line + "\tAdd Customer Master Records...");
DATA_RECORD[] data = new DATA_RECORD[4];
data[0] = new DATA_RECORD("1000", "92867", "CA", "1", "Bryan Williams", "2999 Regency", "Orange");
data[1] = new DATA_RECORD("1001", "61434", "CT", "1", "Michael Jordan", "13 Main", "Harford");
data[2] = new DATA_RECORD("1002", "73677", "GA", "1", "Joshua Brown", "4356 Cambridge", "Atlanta");
data[3] = new DATA_RECORD("1003", "10034", "MO", "1", "Keyon Dooling", "19771 Park Avenue", "Columbia");
SqlSpCommand insert_cmd = NewSqlSpCommand();
String insert_stmt = "INSERT INTO custmast VALUES (?,?,?,?,?,?,?) ";
insert_cmd.Prepare(insert_stmt);
foreach (DATA_RECORD record in data)
{
insert_cmd.Parameter[0].Value = record.number;
insert_cmd.Parameter[1].Value = record.zipcode;
insert_cmd.Parameter[2].Value = record.state;
insert_cmd.Parameter[3].Value = record.rating;
insert_cmd.Parameter[4].Value = record.name;
insert_cmd.Parameter[5].Value = record.address;
insert_cmd.Parameter[6].Value = record.city;
insert_cmd.Execute();
}
}
