protected override void OnLoad(EventArgs e)
{
Text = (DescriptionText == null) ? String.Empty : (DescriptionText + "<br />");
using (SqlCommand cmd = DatabaseManager.Current.CreateCommand("SELECT * FROM Clubs WHERE Weekday=@weekday AND status=1 ORDER BY Name ASC"))
{
if (ShowAll)
{
for (int i = 0; i < 7; i++)
{
if (cmd.Parameters.Contains("@weekday"))
cmd.Parameters.RemoveAt("@weekday");
cmd.Parameters.AddWithValue("@weekday", i);
using (SqlDataReader r = cmd.ExecuteReader())
{
if (r.HasRows)
{
Text += "<h2>" + dayNames[i] + "</h2><ul>";
while (r.Read())
{
Club c = new Club(DatabaseManager.Current, r);
Text += "<li><a href=\"ClubInfo.aspx?id=" + c.Id + "\">" + c.Name + " - " + c.Location + ((c.AfterSchool) ? " (After school)" : "") + "</a></li>";
}
Text += "</ul>";
}
}
}
}
else
{
cmd.Parameters.AddWithValue("@weekday", DateTime.Today.DayOfWeek);
Text += "<ul>";
using (SqlDataReader r = cmd.ExecuteReader())
{
if (r.HasRows)
{
while (r.Read())
{
Club c = new Club(DatabaseManager.Current, r);
Text += "<li><a href=\"ClubInfo.aspx?id=" + c.Id + "\">" + c.Name + " - " + c.Location + ((c.AfterSchool) ? " (After school)" : "") + "</a></li>";
}
}
else
{
Text += "<li><em>No clubs are running today</em></li>";
}
}
Text += "</ul><a href=\"ClubList.aspx\">See all clubs</a>";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["id"] == null)
{
Response.Redirect("Default.aspx", true);
}
else
{
int id;
try
{
id = Int32.Parse(Request.Params["id"]);
}
catch (FormatException)
{
Response.Redirect("Default.aspx", true);
return;
}
using (SqlCommand cmd = DatabaseManager.Current.CreateCommand("SELECT * FROM Clubs WHERE Id=@id AND Status=1"))
{
cmd.Parameters.AddWithValue("@id", id);
Club c = null;
using (SqlDataReader r = cmd.ExecuteReader())
{
if (r.HasRows)
{
r.Read();
c = new Club(DatabaseManager.Current, r);
}
}
if (c != null)
{
ClubBox.Club = c;
}
else
{
Response.Redirect("Default.aspx", true);
}
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (Request.Params["id"] != null)
{
try
{
info = Club.FromDatabase(DatabaseManager.Current, Int32.Parse(Request.Params["id"]));
if (info == null)
Response.Redirect("ClubList.aspx", true);
}
catch (FormatException)
{
Response.Redirect("ClubList.aspx", true);
}
}
else
{
info = new Club(DatabaseManager.Current);
}
if (!CurrentUser.SecurityAccess["CanAccessBackend"])
{
Response.Redirect("403.aspx", true);
}
if (info.Id > 0 && info.CreatorId != CurrentUser.Profile.Id && !CurrentUser.SecurityAccess["CanViewAllClub"])
Response.Redirect("ClubList.aspx", true);
}