Пример #1
0
        /// <summary>
        /// TestDBI_T_user_T4 --
        /// </summary>
        static void TestDBI_T_user_T4()
        {
            Console.WriteLine("  --START: TestDBI_T_user_T4");

            //Construct a brand new myTable in RAM
            SQLServerDB.user_Table myTable = new SQLServerDB.user_Table();
#if rewrite
            //put demo records into myTable
            for (int i = 1; i < 10; i++)
            {
                SQLServerDB.user affItem = new SQLServerDB.user();
                affItem.userId           = i;
                affItem.userName         = "******" + i.ToString();
                affItem.userType         = "aff_Type_" + i.ToString();
                affItem.specificGoal     = "aff_specificGoal_" + i.ToString();
                affItem.specificPractice = "aff_specificPractice_" + i.ToString();
                affItem.genericGoal      = "aff_genericGoal_" + i.ToString();
                affItem.genericPractice  = "aff_genericPractice_" + i.ToString();
                affItem.processArea      = "aff_processArea_" + i.ToString();
                affItem.projectId        = i;

                myTable.itemList.Add(affItem);
            }

            //Count SQLServerDB user 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.user 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
            for (int i = 1; i < 10; i++)
            {
                SQLServerDB.user affItem = new SQLServerDB.user();
                affItem.userId           = i;
                affItem.userName         = "******" + i.ToString() + "_A";
                affItem.userType         = "aff_Type_" + i.ToString() + "_B";
                affItem.specificGoal     = "aff_specificGoal_" + i.ToString() + "_C";
                affItem.specificPractice = "aff_specificPractice_" + i.ToString() + "_D";
                affItem.genericGoal      = "aff_genericGoal_" + i.ToString() + "_E";
                affItem.genericPractice  = "aff_genericPractice_" + i.ToString() + "_F";
                affItem.processArea      = "aff_processArea_" + i.ToString() + "_G";
                affItem.projectId        = i + 100;

                myTable.itemList.Add(affItem);
            }

            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_userID(i);
            }
            Console.WriteLine("AFTER the table record deletions:  userI={4,5,6}");
            Util.pause();

            myTable.Clear_Database_Table_By_projectD(102);
            myTable.Clear_Database_Table_By_projectD(108);
            Console.WriteLine("AFTER the table record deletions:  ProjectID = {102, 108}");
            Util.pause();
#endif

            Console.WriteLine("  --DONE: TestDBI_T_user_T4");
        }
Пример #2
0
        static void TestDBI_T_user_T5()
        {
            Console.WriteLine("  --START: TestDBI_T_user_T5");
#if rewrite
            //Construct a brand new myTable in RAM
            SQLServerDB.user_Table myTable = new SQLServerDB.user_Table();

            int iRowsStart = 5;
            //put demo records into myTable
            for (int i = 1; i <= iRowsStart; i++)
            {
                SQLServerDB.user affItem = new SQLServerDB.user();
                affItem.userId           = i;
                affItem.userName         = "******" + i.ToString();
                affItem.userType         = "aff_Type_" + i.ToString();
                affItem.specificGoal     = "aff_specificGoal_" + i.ToString();
                affItem.specificPractice = "aff_specificPractice_" + i.ToString();
                affItem.genericGoal      = "aff_genericGoal_" + i.ToString();
                affItem.genericPractice  = "aff_genericPractice_" + i.ToString();
                affItem.processArea      = "aff_processArea_" + i.ToString();
                affItem.projectId        = 404; //setting each item to the same projectID to support find by projectID

                myTable.itemList.Add(affItem);
            }

            //Count SQLServerDB user table rows before clearing
            int iRows1 = myTable.CountRows();
            Console.WriteLine("myTable.CountRows = " + iRows1.ToString());

            myTable.Clear_Database_Table();
            int iRows2 = myTable.CountRows();
            if (iRows2 != 0)
            {
                Console.WriteLine("Error! iRows2=" + iRows2 + ".  After Clear_Database_Table should be zero");
            }

            myTable.WriteItemListToDatabase();

            int iRows3 = myTable.CountRows();
            if (iRows3 != iRowsStart)
            {
                Console.WriteLine("Error! iRows3=" + iRows3 + ".  After WriteItemListToDatabase should be " + iRowsStart);
            }
            else
            {
                Console.WriteLine("OK. CountRows=" + iRows3 + " After WriteItemListToDatabase");
            }

            Util.pause("examine table content with SSMS");

            Util.pause("before table query by projectID");
            int iProjectCount_404 = myTable.CountRows_By_projectId(404);
            if (iProjectCount_404 != iRowsStart)
            {
                Console.WriteLine("ERROR.  iProjectCount_404=" + iProjectCount_404 + ". Expected " + iRowsStart);
            }
            else
            {
                Console.WriteLine("OK. CountRows=" + iProjectCount_404 + " After WriteItemListToDatabase");
            }
            Util.pause();
#endif
            Console.WriteLine("  --DONE: TestDBI_T_user_T5");
        }
Пример #3
0
        }//TestDBI_T_user_Read_from_DB

        /// <summary>
        /// TestDBI_T_user_T3 -  clear the SQLServer user table, write some demo data to SQLServer DB,
        /// query the affirmatin table by Project ID,
        /// </summary>
        static void TestDBI_T_user_T3()
        {
            Console.WriteLine("  --START: TestDBI_T_user_T3");

            //Construct myTable in RAM
            SQLServerDB.user_Table myTable = new SQLServerDB.user_Table();
#if rewrite
            //put demo records into myTable
            for (int i = 1; i < 10; i++)
            {
                SQLServerDB.user affItem = new SQLServerDB.user();
                affItem.userId           = i;
                affItem.userName         = "******" + i.ToString();
                affItem.userType         = "aff_Type_" + i.ToString();
                affItem.specificGoal     = "aff_specificGoal_" + i.ToString();
                affItem.specificPractice = "aff_specificPractice_" + i.ToString();
                affItem.genericGoal      = "aff_genericGoal_" + i.ToString();
                affItem.genericPractice  = "aff_genericPractice_" + i.ToString();
                affItem.processArea      = "aff_processArea_" + i.ToString();
                affItem.projectId        = i;

                myTable.itemList.Add(affItem);
            }


            //Count SQLServerDB user 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.user affSeek = myTable.itemList[0];

            Console.WriteLine("affSeek.userId =" + affSeek.userId);
            Console.WriteLine("affSeek.userName ="******"affSeek.userType =" + affSeek.userType);
            Console.WriteLine("affSeek.specificGoal =" + affSeek.specificGoal);
            Console.WriteLine("affSeek.specificPractice =" + affSeek.specificPractice);
            Console.WriteLine("affSeek.genericGoal =" + affSeek.genericGoal);
            Console.WriteLine("affSeek.genericPractice =" + affSeek.genericPractice);
            Console.WriteLine("affSeek.processArea =" + affSeek.processArea);
            Console.WriteLine("affSeek.projectId =" + affSeek.projectId);

            Util.pause();

            //set the search-by criteria
            String strSeek_processArea = "aff_processArea_4";


            myTable.ReadItemListFromDatabase_By_processArea(strSeek_processArea);
            Console.WriteLine("SEEK items by processArea found: myTable.itemList.Count =" + myTable.itemList.Count.ToString());

            SQLServerDB.user affSeek_processArea = myTable.itemList[0];

            Console.WriteLine("affSeek_processArea.userId =" + affSeek_processArea.userId);
            Console.WriteLine("affSeek_processArea.userName ="******"affSeek_processArea.userType =" + affSeek_processArea.userType);
            Console.WriteLine("affSeek_processArea.specificGoal =" + affSeek_processArea.specificGoal);
            Console.WriteLine("affSeek_processArea.specificPractice =" + affSeek_processArea.specificPractice);
            Console.WriteLine("affSeek_processArea.genericGoal =" + affSeek_processArea.genericGoal);
            Console.WriteLine("affSeek_processArea.genericPractice =" + affSeek_processArea.genericPractice);
            Console.WriteLine("affSeek_processArea.processArea =" + affSeek_processArea.processArea);
            Console.WriteLine("affSeek_processArea.projectId =" + affSeek_processArea.projectId);

            Util.pause();
#endif
            Console.WriteLine("  --DONE: TestDBI_T_user_T3");
        }