private void LoadQuery()
{
DateTime dteDateTimeCutoff = DateTime.Now;
string strSQL = DynamicQueryBuilder.GetDynamicManagedServiceOrdersQuery(dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff, dteDateTimeCutoff);
strSQL = strSQL.Replace(Environment.NewLine, "<br/>");
lblQuery.Text = strSQL;
}
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);
}