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); }