}//TestDBI_T_appraisal_write_to_DB
//-------------------------------------------------------------------------------------------
static void TestDBI_T_appraisal_read_from_DB()
{
Console.WriteLine(" --START: TestDBI_T_appraisal_read_from_DB");
SQLServerDB.appraisal_Table myTable = new SQLServerDB.appraisal_Table();
Console.WriteLine(" --DONE: TestDBI_T_appraisal_read_from_DB");
}//TestDBI_T_appraisal_read_from_DB
}//TestDBI_T_appraisal_read_from_DB
//-------------------------------------------------------------------------------------------
static void TestDBI_T_appraisal_T3()
{
Console.WriteLine(" --START: TestDBI_T_appraisal_T3");
//Construct myTable in RAM
SQLServerDB.appraisal_Table myTable = new SQLServerDB.appraisal_Table();
//put demo records into myTable in RAM
myTable.itemList.Clear();
for (int i = 1; i < 10; i++)
{
SQLServerDB.appraisal iqlItem = new SQLServerDB.appraisal();
iqlItem.ID = i; //actually, a don't care; it will not be stored
iqlItem.AppraisalName = "Name_" + i.ToString();
iqlItem.Creator = "Creator_" + i.ToString();
iqlItem.MaturityLevel = i; //A valid maturity level is not really needed. Test only demonstrates storing/retreiving integers.
iqlItem.Projects = "Projects_" + i.ToString();
iqlItem.SAMSelected = Convert.ToBoolean(i % 2); // Alternate between true/false
iqlItem.SSDSelected = Convert.ToBoolean(i % 2); // Alternate between true/false
myTable.itemList.Add(iqlItem);
}
//Count SQLServerDB appraisal table rows before clearing
int iRows = myTable.CountRows();
Console.WriteLine("myTable.CountRows = " + iRows.ToString());
Console.WriteLine(" --before clear SQLServer database table");
Util.pause();
myTable.Clear_Database_Table();
int iRows2 = myTable.CountRows();
Console.WriteLine("myTable.CountRows = " + iRows2.ToString());
Util.pause();
myTable.WriteItemListToDatabase();
Console.WriteLine("after writing to SQLServerDB");
Util.pause();
int iRows3 = myTable.CountRows();
Console.WriteLine("myTable.CountRows = " + iRows3.ToString());
Util.pause();
//put demo records into myTable in RAM
myTable.itemList.Clear();
for (int i = 1; i < 10; i++)
{
SQLServerDB.appraisal appraisalItem = new SQLServerDB.appraisal();
appraisalItem.ID = i; //actually, a don't care; it will not be stored
appraisalItem.AppraisalName = "Name_" + i.ToString();
appraisalItem.Creator = "Creator_" + i.ToString() + "_REV-A"; //modify the text!
appraisalItem.MaturityLevel = i + 100; //A valid maturity level is not really needed. Test only demonstrates storing/retreiving integers.
appraisalItem.Projects = "Projects_" + i.ToString() + "_REV-A"; //modify the text!
appraisalItem.SAMSelected = Convert.ToBoolean(1 + (i % 2)); // Alternate between true/false
appraisalItem.SSDSelected = Convert.ToBoolean(1 + (i % 2)); // Alternate between true/false
myTable.itemList.Add(appraisalItem);
}
myTable.Show();
Util.pause("--BEFORE the update, showing the planned updates in myTable.itemList");
SQLServerDB.appraisal appRef1 = myTable.itemList[0];
appRef1.MaturityLevel = appRef1.MaturityLevel + 200;
appRef1.Projects = appRef1.Projects + ",P99";
SQLServerDB.appraisal appRef2 = myTable.itemList[3];
appRef2.MaturityLevel = appRef2.MaturityLevel + 300;
appRef2.Projects = appRef2.Projects + ",P99";
myTable.UpdateItemListToDatabase();
Util.pause("-- AFTER the update, examine the appraisal Table using SSMS");
Console.WriteLine(" --DONE: TestDBI_T_appraisal_T3");
}//TestDBI_T_appraisal_T3