}//TestDBI_T_interview_session_Write_to_DB
//-------------------------------------------------------------------------------------------
static void TestDBI_T_interview_session_Read_from_DB()
{
Console.WriteLine(" --START: TestDBI_T_interview_session_Read_from_DB");
interview_session_Table myTable = new interview_session_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_interview_session_Read_from_DB");
}//TestDBI_T_interview_session_Read_from_DB
/// <summary>
/// TestDBI_T_interview_session_AutoCheck_Update - Update Item List;
/// 1.1) Create test data: myTable1;
/// 1.2) Clear DBTable;
/// 1.3) Write myTable1 to DBTable;
/// 1.4) Get DBTable.CountRows, compare (myTable1.itemList.Count == DBTable.CountRows)
/// 1.5) Read myTable2 from DBTable
/// 1.6) Compare tables (myTable1 == myTable2)
/// 1.7) Create the update table (myTableUpdate)
/// 1.8) Update TableDB
/// 1.9) Read myTable3
/// 1.10) Compare tables.itemLists(myTableUpdate == myTable3)
/// </summary>
/// <returns></returns>
static int TestDBI_T_interview_session_AutoCheck_Update()
{
const int OK = 0;
int iResult = OK;
Console.WriteLine("START: TestDBI_T_interview_session_AutoCheck_Update()");
// 1.1) CreateTestData1: myTable1
interview_session_Table myTable1 = new interview_session_Table();
myTable1.itemList = new List <interview_session>()
{
// interview_session(int val_sessionId, int val_sessionIndex, String val_sessionName, int val_sessionDurationHours, int val_sessionDurationMinutes,
// String val_specificGoal, String val_specificPractice,
// String val_genericGoal, String val_genericPractice,
// String val_processArea)
new interview_session(1, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(2, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(3, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(4, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(5, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1")
};
int iRowsAtStart = myTable1.itemList.Count;
// 1.2) ClearDBTable
myTable1.Clear_Database_Table();
int iRowsAfterClear = myTable1.CountRows();
if (iRowsAfterClear != 0)
{
iResult = -1;
Console.WriteLine("Error: DBTable should be empty after Clear_Database_Table. iRowsAfterClear=" + iRowsAfterClear);
return(iResult);
}
// 1.3) Write myTable1 to DBTable
myTable1.WriteItemListToDatabase();
// 1.4) Get DBTable.CountRows, compare (myTable1.itemList.Count == DBTable.CountRows)
int iRowsAfterWriteItemListr = myTable1.CountRows();
if (iRowsAfterWriteItemListr != iRowsAtStart)
{
iResult = -1;
Console.WriteLine("Error: DBTable should be same as iRowsAtStart after WriteItemListToDatabase. iRowsAfterWriteItemListr=" + iRowsAfterWriteItemListr);
return(iResult);
}
/// 1.5) Read myTable2 from DBTable
interview_session_Table myTable2 = new interview_session_Table();
myTable2.ReadItemListFromDatabase();
/// 1.6) Compare tables (myTable1 == myTable2)
if (!TestDBI_T_interview_session_CompareLists(myTable1.itemList, myTable2.itemList))
{
iResult = -1;
Console.WriteLine("Error: DBTable should be same as test data");
return(iResult);
}
/// 1.7) Create the update table (myTableUpdate)
interview_session_Table myTableUpdate = new interview_session_Table();
myTableUpdate.itemList = new List <interview_session>()
{
// interview_session(int val_sessionId, int val_sessionIndex, String val_sessionName, int val_sessionDurationHours, int val_sessionDurationMinutes,
// String val_specificGoal, String val_specificPractice,
// String val_genericGoal, String val_genericPractice,
// String val_processArea)
new interview_session(1, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(2, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1-update"),
new interview_session(3, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1"),
new interview_session(4, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1-update"),
new interview_session(5, 1, "session_name_1", 1, 2, "sg_1", "sp_1", "gg_1", "gp_1", "pa_1")
};
//1.8) Update TableDB
myTableUpdate.UpdateItemListToDatabase();
//1.9) Read myTable3
interview_session_Table myTable3 = new interview_session_Table();
myTable3.ReadItemListFromDatabase();
//1.10) Compare tables.itemLists (myTableUpdate == myTable3)
if (!TestDBI_T_interview_session_CompareLists(myTableUpdate.itemList, myTable3.itemList))
{
iResult = -1;
Console.WriteLine("Error: DBTable should be same as the update table");
return(iResult);
}
Console.WriteLine("DONE: TestDBI_T_interview_session_AutoCheck_Update()");
return(iResult);
}
