public void Test_GetRecsFromDB()
        {
            string strSQL = SQLQueryBuilder.GetSQLStatement_DWOrderAddressesNotInGLM();

            DAL.CDWOrderAddressRecord    objCDWQuery = new CDWOrderAddressRecord();
            List <CDWOrderAddressRecord> lstResults  = objCDWQuery.GetRecords(strSQL);

            Assert.IsTrue(lstResults.Count > 0);
        }
        public void Test_GetRecsFromDB_Changeset_DYNAMIC()
        {
            DateTime dteDateTimeCutoff = new DateTime(2018, 04, 01, 13, 59, 59);

            string strSQL = DynamicQueryBuilder.GetDynamicManagedServiceOrdersQuery(dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff);

            DAL.CDWOrderAddressRecord    objCDWChangesetQuery = new CDWOrderAddressRecord();
            List <CDWOrderAddressRecord> lstResults           = objCDWChangesetQuery.GetRecords(strSQL);

            Assert.IsTrue(lstResults.Count > 0);
        }
        public void Test_GetRecsFromDB_Changeset()
        {
            DateTime dteDateTimeCutoff = new DateTime(2018, 04, 01, 13, 59, 59);

            string strSQL = SQLQueryBuilder.GetSQLStatement_DWOrderAddressesChangeset(dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff);

            DAL.CDWOrderAddressRecord    objCDWChangesetQuery = new CDWOrderAddressRecord();
            List <CDWOrderAddressRecord> lstResults           = objCDWChangesetQuery.GetRecords(strSQL);

            Assert.IsTrue(lstResults.Count > 0);
        }