using System; using CMS.SettingsProvider; using CMS.UIControls; using CMS.Controls; public partial class CMSModules_Friends_Controls_FriendsSearchBox : CMSAbstractBaseFilterControl { #region "Variables" private bool mFilterComment = true; private bool mFilterNickname = true; private bool mFilterUserName = true; private bool mFilterFullName = true; #endregion #region "Properties" /// /// Gets where condition. /// public override string WhereCondition { get { string where = null; if (!string.IsNullOrEmpty(txtSearch.Text)) { if (FilterUserName) { where = SqlHelperClass.AddWhereCondition(where, "UserName LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%'", "OR"); } if (FilterNickname) { where = SqlHelperClass.AddWhereCondition(where, "UserNickname LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%'", "OR"); } if (FilterFullName) { where = SqlHelperClass.AddWhereCondition(where, "FullName LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%'", "OR"); } if (FilterComment) { where = SqlHelperClass.AddWhereCondition(where, "FriendComment LIKE '%" + SqlHelperClass.GetSafeQueryString(txtSearch.Text, false) + "%'", "OR"); } } return where; } } /// /// Determines whether filter is set. /// public bool FilterIsSet { get { return !string.IsNullOrEmpty(txtSearch.Text); } } /// /// Determines whether to filter Comment column. /// public bool FilterComment { get { return mFilterComment; } set { mFilterComment = value; } } /// /// Determines whether to filter Nickname column. /// public bool FilterNickname { get { return mFilterNickname; } set { mFilterNickname = value; } } /// /// Determines whether to filter Username column. /// public bool FilterUserName { get { return mFilterUserName; } set { mFilterUserName = value; } } /// /// Determines whether to filter Fullname column. /// public bool FilterFullName { get { return mFilterFullName; } set { mFilterFullName = value; } } #endregion #region "Page events" protected override void OnInit(EventArgs e) { base.OnInit(e); // Initialize reset link button UniGrid grid = FilteredControl as UniGrid; if (grid != null && grid.RememberState) { btnReset.Text = GetString("general.reset"); btnReset.Click += btnReset_Click; } else { btnReset.Visible = false; } } #endregion #region "State management" /// /// Resets filter to the default state. /// public override void ResetFilter() { txtSearch.Text = String.Empty; } /// /// Resets the associated UniGrid control. /// protected void btnReset_Click(object sender, EventArgs e) { UniGrid grid = FilteredControl as UniGrid; if (grid != null) { grid.Reset(); } } /// /// Applies filter on associated UniGrid control. /// protected void btnShow_Click(object sender, EventArgs e) { UniGrid grid = FilteredControl as UniGrid; if (grid != null) { grid.ApplyFilter(sender, e); } } #endregion }