protected void ShowSeasonInfo(seasondb db)
{
bool valid = true;
string season_id = Request.QueryString["seasonid"];
if (String.IsNullOrEmpty(season_id))
{
valid = false;
}
if (valid)
{
http_page season_record = db.FindPage(Int32.Parse(season_id));
s_title.InnerHtml += season_record.GetStitle();
s_body.InnerHtml += season_record.GetSbody();
}
else
{
valid = false;
}
if (!valid)
{
main_content.InnerHtml = "There was an error finding the season.";
}
}
protected void SeasonTitle(seasondb db)
{
seasontitle.InnerHtml = "";
string search_key = "";
string query = "select * from season";
if (search_key != "")
{
query += " WHERE seasonid LIKE '%" + search_key + "%'";
query += " OR seasontitle LIKE '%" + search_key + "%'";
query += " OR seasonbody LIKE '%" + search_key + "%'";
}
//var db = new seasondb();
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
seasontitle.InnerHtml += "";
string season_id = row["seasonid"];
string season_title = row["seasontitle"];
seasontitle.InnerHtml += "<a href=\"showpage.aspx?seasonid=" + season_id + "\">" + season_title + "</a> ";
}
}
protected void Page_Load(object sender, EventArgs e)
{
result_season.InnerHtml = "";
string search_key = "";
string query = "select * from season";
if (search_key != "")
{
query += " WHERE seasonid LIKE '%" + search_key + "%'";
query += " OR seasontitle LIKE '%" + search_key + "%'";
query += " OR seasonbody LIKE '%" + search_key + "%'";
}
var db = new seasondb();
List <Dictionary <String, String> > rs = db.List_Query(query);
foreach (Dictionary <String, String> row in rs)
{
result_season.InnerHtml += "<div class=\"result_season\">";
string season_id = row["seasonid"];
string season_title = row["seasontitle"];
result_season.InnerHtml += "<a href=\"showpage.aspx?seasonid=" + season_id + "\">" + season_title + ": </a>";
string season_body = row["seasonbody"];
result_season.InnerHtml += season_body;
result_season.InnerHtml += "";
}
}
protected void Update_Page(object sender, EventArgs e)
{
seasondb db = new seasondb();
bool valid = true;
string season_id = Request.QueryString["seasonid"];
if (String.IsNullOrEmpty(season_id))
{
valid = false;
}
if (valid)
{
http_page new_season = new http_page();
new_season.SetStitle(s_title.Text);
new_season.SetSbody(s_body.Text);
try
{
db.UpdatePage(Int32.Parse(season_id), new_season);
Response.Redirect("listpages.aspx?seasonid=" + season_id);
}
catch
{
valid = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
seasondb db = new seasondb();
ShowSeasonInfo(db);
}
}
protected void Add_Page(object sender, EventArgs e)
{
seasondb db = new seasondb();
http_page new_season = new http_page();
new_season.SetStitle(season_title.Text);
new_season.SetSbody(season_body.Text);
db.AddPage(new_season);
Response.Redirect("listpages.aspx");
}
protected void Delete_Season(object sender, EventArgs e)
{
bool valid = true;
string season_id = Request.QueryString["seasonid"];
if (String.IsNullOrEmpty(season_id))
{
valid = false;
}
seasondb db = new seasondb();
if (valid)
{
db.DeletePage(Int32.Parse(season_id));
Response.Redirect("listpages.aspx");
}
else
{
valid = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
seasondb db = new seasondb();
SeasonTitle(db);
}