}//TestDBI_T_mapping_Write_to_DB
//-------------------------------------------------------------------------------------------
/// <summary>
/// TestDBI_T_mapping_Read_from_DB -- read from DB
/// </summary>
static void TestDBI_T_mapping_Read_from_DB()
{
Console.WriteLine(" --START: TestDBI_T_mapping_Read_from_DB");
SQLServerDB.mapping_Table myTable = new SQLServerDB.mapping_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_mapping_Read_from_DB");
}//TestDBI_T_mapping_Read_from_DB
}//TestDBI_T_mapping_Read_from_DB
/// <summary>
/// TestDBI_T_mapping_T3 - clear the SQLServer mapping table, write some demo data to SQLServer DB,
/// query the affirmatin table by Project ID,
/// </summary>
static void TestDBI_T_mapping_T3()
{
Console.WriteLine(" --START: TestDBI_T_mapping_T3");
//Construct myTable in RAM
SQLServerDB.mapping_Table myTable = new SQLServerDB.mapping_Table();
myTable.itemList = make_mapping_list_3();
//Count SQLServerDB mapping 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();
int iSeek_ProjectID = 3;
Console.WriteLine("seek item: iSeek_ProjectID= " + iSeek_ProjectID);
myTable.ReadItemListFromDatabase_ByProjectID(iSeek_ProjectID);
Console.WriteLine("SEEK items found: myTable.itemList.Count =" + myTable.itemList.Count.ToString());
SQLServerDB.mapping affSeek = myTable.itemList[0];
affSeek.Show();
Util.pause();
Console.WriteLine(" --DONE: TestDBI_T_mapping_T3");
}
/// <summary>
/// TestDBI_T_mapping_T4 --
/// </summary>
static void TestDBI_T_mapping_T4()
{
Console.WriteLine(" --START: TestDBI_T_mapping_T4");
//Construct a brand new myTable in RAM
SQLServerDB.mapping_Table myTable = new SQLServerDB.mapping_Table();
myTable.itemList = make_mapping_list_4A();
//Count SQLServerDB mapping 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();
foreach (SQLServerDB.mapping r in myTable.itemList)
{
myTable.WriteItemToDatabase(r);
}
Console.WriteLine("after writing to SQLServerDB");
Util.pause();
int iRows3 = myTable.CountRows();
Console.WriteLine("myTable.CountRows = " + iRows3.ToString());
Util.pause();
Console.WriteLine("---update the table");
//revise the myTable contents
myTable.itemList.Clear();
//put demo records into myTable
myTable.itemList = make_mapping_list_4B();
Console.WriteLine("BEFORE the table update");
Util.pause();
myTable.UpdateItemListToDatabase();
Console.WriteLine("AFTER the table update");
Util.pause();
for (int i = 4; i <= 6; i++)
{
myTable.Clear_Database_Table_By_mappingId(i);
}
Console.WriteLine("AFTER the table record deletions: mappingI={4,5,6}");
Util.pause();
Console.WriteLine(" --DONE: TestDBI_T_mapping_T4");
}