All pastes #184201 Raw Edit

Untitled

public text v1 · immutable
#184201 ·published 2006-09-27 17:20 UTC
rendered paste body
using Community.Database.SqlControls;
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace Community.Components.Membership
{
    /// <summary>
    /// Summary description for BanUser
    /// </summary>
    public static class BanUser
    {
        static BanUser() { }

        public static bool IsBanned(string Cookie)
        {
            SqlCommand comm = SqlControls.CreateTextCommand("SELECT Banned FROM Users WHERE Username={0} AND Banned=1");
            SqlParameter param = comm.CreateParameter();
            param.ParameterName = "@Username";
            param.Value = Cookie;
            param.DbType = DbType.String;
            comm.Parameters.Add(param);

            DataTable table = SqlControls.ExecuteSelectCommand(comm);
            if (table.Rows.Count > 0)
                return true;
            else
                return false;
        }
    }
}