Ejemplo n.º 1
0
        }//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
Ejemplo n.º 2
0
        }//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");
        }
Ejemplo n.º 3
0
        /// <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");
        }