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