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
}