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