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 }