using System;
using System.Text;
using CMS.Controls;
using CMS.GlobalHelper;
using CMS.SettingsProvider;
public partial class CMSModules_Messaging_Controls_ContactIgnoreSearchBox : CMSAbstractBaseFilterControl
{
#region "Properties"
///
/// Gets where condition.
///
public override string WhereCondition
{
get
{
base.WhereCondition = GenerateWhereCondition();
return base.WhereCondition;
}
set
{
base.WhereCondition = value;
}
}
///
/// Filter value.
///
public override object Value
{
get
{
return ValidationHelper.GetString(txtSearch.Text, string.Empty);
}
set
{
txtSearch.Text = ValidationHelper.GetString(value, string.Empty);
}
}
#endregion
#region "Page events"
///
/// OnLoad override - check wheter filter is set.
///
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
// Generate current where condition
WhereCondition = GenerateWhereCondition();
}
#endregion
#region "Other methods"
///
/// Generates where condition.
///
protected string GenerateWhereCondition()
{
StringBuilder whereBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(txtSearch.Text))
{
whereBuilder.Append("UserName LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%' OR ");
whereBuilder.Append("UserNickName LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%'");
}
return whereBuilder.ToString();
}
#endregion
}