private string CreateWhereCondition(string originalWhere) { var where = new WhereCondition(); where.Where(new WhereCondition(originalWhere) { WhereIsComplex = true }); // Add where conditions from filters where.Where(new WhereCondition(nameFilter.WhereCondition) { WhereIsComplex = true }); string objType = ValidationHelper.GetString(objTypeSelector.Value, ""); if (!String.IsNullOrEmpty(objType)) { #pragma warning disable BH2000 // Method 'WhereLike()' or 'WhereNotLike()' should not be used used. where.WhereLike("VersionObjectType", objType); #pragma warning restore BH2000 // Method 'WhereLike()' or 'WhereNotLike()' should not be used used. } int userId = ValidationHelper.GetInteger(userSelector.Value, 0); if (userId > 0) { where.WhereEquals("VersionDeletedByUserID", userId); } // Get older than value if (DisplayDateTimeFilter) { DateTime olderThan = DateTime.Now.Date.AddDays(1); int dateTimeValue = ValidationHelper.GetInteger(txtFilter.Text, 0); switch (drpFilter.SelectedIndex) { case 0: olderThan = olderThan.AddDays(-dateTimeValue); break; case 1: olderThan = olderThan.AddDays(-dateTimeValue * 7); break; case 2: olderThan = olderThan.AddMonths(-dateTimeValue); break; case 3: olderThan = olderThan.AddYears(-dateTimeValue); break; } where.WhereLessOrEquals("VersionDeletedWhen", olderThan); } return(where.ToString(true)); }
private string CreateWhereCondition(string originalWhere) { var where = new WhereCondition(); where.Where(new WhereCondition(originalWhere){ WhereIsComplex = true }); // Add where conditions from filters where.Where(new WhereCondition(nameFilter.WhereCondition) { WhereIsComplex = true }); string objType = ValidationHelper.GetString(objTypeSelector.Value, ""); if (!String.IsNullOrEmpty(objType)) { where.WhereLike("VersionObjectType", objType); } int userId = ValidationHelper.GetInteger(userSelector.Value, 0); if (userId > 0) { where.WhereEquals("VersionDeletedByUserID", userId); } // Get older than value if (DisplayDateTimeFilter) { DateTime olderThan = DateTime.Now.Date.AddDays(1); int dateTimeValue = ValidationHelper.GetInteger(txtFilter.Text, 0); switch (drpFilter.SelectedIndex) { case 0: olderThan = olderThan.AddDays(-dateTimeValue); break; case 1: olderThan = olderThan.AddDays(-dateTimeValue * 7); break; case 2: olderThan = olderThan.AddMonths(-dateTimeValue); break; case 3: olderThan = olderThan.AddYears(-dateTimeValue); break; } where.WhereLessOrEquals("VersionDeletedWhen", olderThan); } return where.ToString(true); }