}//TestDBI_T_strength_Write_to_DB //------------------------------------------------------------------------------------------- /// <summary> /// TestDBI_T_strength_Read_from_DB -- read from DB /// </summary> static void TestDBI_T_strength_Read_from_DB() { Console.WriteLine(" --START: TestDBI_T_strength_Read_from_DB"); SQLServerDB.strength_Table myTable = new SQLServerDB.strength_Table(); int iRows = myTable.CountRows(); Console.WriteLine("myTable.CountRows = " + iRows.ToString()); Console.WriteLine("Fill the table in RAM from the SQLServer Database table"); myTable.ReadItemListFromDatabase(); myTable.Show(); if (myTable.itemList.Count != iRows) { Console.WriteLine("Error. myTable.itemList.Count != myTable.CountRows." + " should be the same ReadItemListFromDatabase ()"); } else { Console.WriteLine("OK. After ReadItemListFromDatabase()"); } Util.pause(); Console.WriteLine(" --DONE: TestDBI_T_strength_Read_from_DB"); }//TestDBI_T_strength_Read_from_DB
/// <summary> /// TestDBI_T_strength_T4 -- /// </summary> static void TestDBI_T_strength_T4() { Console.WriteLine(" --START: TestDBI_T_strength_T4"); //Construct a brand new myTable in RAM SQLServerDB.strength_Table myTable = new SQLServerDB.strength_Table(); myTable.itemList = new List <strength>() { //strength(String val_notes, String val_processArea, String val_specificGoal, String val_specificPractice, String val_genericGoal, String val_genericPractice, int val_projectId) new strength("notes_1", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 1), new strength("notes_2", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 2), new strength("notes_3", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 3), new strength("notes_4", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 4), new strength("notes_5", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 5) }; int iRowsStart = myTable.itemList.Count; myTable.Clear_Database_Table(); int iRows1 = myTable.CountRows(); if (iRows1 != iRowsStart) { Console.WriteLine("ERR: iRows should be zero after Clear_Database_Table"); } Util.pause(); myTable.WriteItemListToDatabase(); int iRows2 = myTable.CountRows(); if (iRows2 != iRowsStart) { Console.WriteLine("ERR: iRows2 should equal iRowsStart! iRows2=" + iRows2); } else { Console.WriteLine("OK"); } //Construct a brand new myTable in RAM SQLServerDB.strength_Table myTable2 = new SQLServerDB.strength_Table(); myTable2.itemList = new List <strength>() { //strength(String val_notes, String val_processArea, String val_specificGoal, String val_specificPractice, String val_genericGoal, String val_genericPractice, int val_projectId) new strength("notes_1A", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 1), new strength("notes_2B", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 2), new strength("notes_3", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 3), new strength("notes_4D", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 4), new strength("notes_5E", "pa_1", "sg_1", "sp_1", "gg_1", "gp_1", 5) }; Console.WriteLine("---update the table"); Console.WriteLine("BEFORE the table update"); myTable2.Show(); Util.pause("ready to update"); myTable.UpdateItemListToDatabase(); Console.WriteLine("AFTER the table update"); myTable2.Show(); Util.pause(); Console.WriteLine(" --DONE: TestDBI_T_strength_T4"); }