/// <summary> /// No restrictions apart from avoid null hubs /// </summary> /// <returns></returns> public List<IRestrictClause> CreateRestrictions() { var restrictions = new List<IRestrictClause>(); var notNullClause = new NotNullClause(setup.FieldMappings[EASTING]); restrictions.Add(notNullClause); return restrictions; }
public List<IRestrictClause> CreateRestrictions() { var restrictions = new List<IRestrictClause>(); var dateClause = new BetweenDatesClause(setup.FieldMappings[DATE]) { fromDate = this.setup.FromDate.ToString(US_DATE_FORMAT), toDate = this.setup.ToDate.ToString(US_DATE_FORMAT) }; var localityClause = new StandardClause(setup.FieldMappings[LOCALITY]) { Operator = SQLOperator.Equals, Value = "'" + locality + "'" }; var notNullClause = new NotNullClause(setup.FieldMappings[EASTING]); restrictions.Add(dateClause); restrictions.Add(localityClause); restrictions.Add(notNullClause); return restrictions; }