//-------------------------------------------------------------------------------------------
static void TestDBI_T_improvement_opportunity_Write_to_DB()
{
Console.WriteLine(" --START: TestDBI_T_improvement_opportunity_Write_to_DB");
SQLServerDB.improvement_opportunity_Table myTable = new SQLServerDB.improvement_opportunity_Table();
//TBD
Console.WriteLine(" --DONE: TestDBI_T_improvement_opportunity_Write_to_DB");
}
//-------------------------------------------------------------------------------------------
static void TestDBI_T_improvement_opportunity_T3()
{
Console.WriteLine(" --START: TestDBI_T_improvement_opportunity_T3");
//Construct myTable in RAM
SQLServerDB.improvement_opportunity_Table myTable = new SQLServerDB.improvement_opportunity_Table();
//put demo records into myTable in RAM
myTable.itemList.Clear();
for (int i = 1; i < 10; i++)
{
SQLServerDB.improvement_opportunity improvement_opportunityItem = new SQLServerDB.improvement_opportunity();
improvement_opportunityItem.ID = i; //actually, a don't care; it will not be stored
improvement_opportunityItem.notes = "notes_" + i.ToString();
improvement_opportunityItem.specificGoal = "sg_" + i.ToString();
improvement_opportunityItem.specificPractice = "sp_" + i.ToString();
improvement_opportunityItem.genericGoal = "gg_" + i.ToString();
improvement_opportunityItem.genericPractice = "gp_" + i.ToString();
improvement_opportunityItem.projectId = i;
improvement_opportunityItem.processArea = "process_area_" + i.ToString();
myTable.itemList.Add(improvement_opportunityItem);
}
#if __COMMENT_
//Count SQLServerDB improvement_opportunity table rows before clearing
int iRows = myTable.CountRows();
Console.WriteLine("myTable.CountRows = " + iRows.ToString());
Console.WriteLine(" --before clear SQLServer database table");
pause();
#endif
myTable.Clear_Database_Table();
int iRows2 = myTable.CountRows();
if (iRows2 != 0)
{
Console.WriteLine("ERROR! myTable.CountRows = " + iRows2.ToString() + "; should be zero(0)");
}
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.improvement_opportunity improvement_opportunityItem = new SQLServerDB.improvement_opportunity();
improvement_opportunityItem.ID = i; //actually, a don't care; it will not be stored
improvement_opportunityItem.notes = "notes_" + i.ToString();
improvement_opportunityItem.specificGoal = "sg_" + i.ToString() + "_REV-A";
improvement_opportunityItem.specificPractice = "sp_" + i.ToString() + "_REV-A";
improvement_opportunityItem.genericGoal = "gg_" + i.ToString() + "_REV-A";
improvement_opportunityItem.genericPractice = "gp_" + i.ToString() + "_REV-A";
improvement_opportunityItem.projectId = i;
improvement_opportunityItem.processArea = "process_area_" + i.ToString() + "_REV-A";
myTable.itemList.Add(improvement_opportunityItem);
}
myTable.Show();
Util.pause("--BEFORE the update, showing the planned updates in myTable.itemList");
myTable.UpdateItemListToDatabase();
Util.pause("-- AFTER the update, examine the improvement_opportunity Table using SSMS");
Console.WriteLine(" --DONE: TestDBI_T_improvement_opportunity_T3");
}//TestDBI_T_improvement_opportunity_T3
