public override ClubMemberCollection GetTopClubManagers(int clubID, int top)
{
using (SqlQuery db = new SqlQuery())
{
db.CommandText = "SELECT TOP (@Top) * FROM bx_ClubMembers WHERE ClubID = @ClubID AND Status IN (4, 5)";
db.CreateTopParameter("@Top", top);
db.CreateParameter <int>("@ClubID", clubID, SqlDbType.Int);
using (XSqlDataReader reader = db.ExecuteReader())
{
ClubMemberCollection result = new ClubMemberCollection(reader);
return(result);
}
}
}
public override ClubMemberCollection GetClubMembers(int clubID, int pageSize, int pageNumber, ClubMemberStatus?status)
{
using (SqlQuery db = new SqlQuery())
{
db.Pager.TableName = "bx_ClubMembers";
db.Pager.SortField = "SortOrder";
db.Pager.PageSize = pageSize;
db.Pager.PageNumber = pageNumber;
db.Pager.Condition = "ClubID = @ClubID";
db.Pager.SelectCount = true;
if (status != null)
{
db.Pager.Condition += " AND Status = @Status";
db.CreateParameter <ClubMemberStatus>("@Status", status.Value, SqlDbType.TinyInt);
}
else
{
db.Pager.Condition += " AND Status <> 1 AND Status <> 2";
}
db.CreateParameter <int>("@ClubID", clubID, SqlDbType.Int);
using (XSqlDataReader reader = db.ExecuteReader())
{
ClubMemberCollection result = new ClubMemberCollection(reader);
reader.NextResult();
reader.Read();
result.TotalRecords = reader.Get <int>(0);
return(result);
}
}
}
public override ClubMemberCollection GetClubMembers(int clubID, int pageSize, int pageNumber, ClubMemberStatus? status)
{
using (SqlQuery db = new SqlQuery())
{
db.Pager.TableName = "bx_ClubMembers";
db.Pager.SortField = "SortOrder";
db.Pager.PageSize = pageSize;
db.Pager.PageNumber = pageNumber;
db.Pager.Condition = "ClubID = @ClubID";
db.Pager.SelectCount = true;
if (status != null)
{
db.Pager.Condition += " AND Status = @Status";
db.CreateParameter<ClubMemberStatus>("@Status", status.Value, SqlDbType.TinyInt);
}
else
{
db.Pager.Condition += " AND Status <> 1 AND Status <> 2";
}
db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);
using (XSqlDataReader reader = db.ExecuteReader())
{
ClubMemberCollection result = new ClubMemberCollection(reader);
reader.NextResult();
reader.Read();
result.TotalRecords = reader.Get<int>(0);
return result;
}
}
}
public override ClubMemberCollection GetTopClubManagers(int clubID, int top)
{
using (SqlQuery db = new SqlQuery())
{
db.CommandText = "SELECT TOP (@Top) * FROM bx_ClubMembers WHERE ClubID = @ClubID AND Status IN (4, 5)";
db.CreateTopParameter("@Top", top);
db.CreateParameter<int>("@ClubID", clubID, SqlDbType.Int);
using (XSqlDataReader reader = db.ExecuteReader())
{
ClubMemberCollection result = new ClubMemberCollection(reader);
return result;
}
}
}
