protected void radioSelectITEPolyJC_SelectedIndexChanged(object sender, EventArgs e)
{
btnITEJCPOLYEast.Visible = true;
btnITEJCPOLYNone.Visible = true;
btnITEJCPOLYNorth.Visible = true;
btnITEJCPOLYSouth.Visible = true;
btnITEJCPOLYWest.Visible = true;
lblITEJCPOLYSchFilterByLoc.Visible = true;
if (radioSelectITEPolyJC.SelectedItem.Text == "Junior College")
{
PolyCoursesTable.Visible = false;
DataTable ViewITEJCSchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%JUNIOR COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEJCSchTable);
ITEJCPOLYTable.DataSource = ViewITEJCSchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "Polytechnic")
{
PolyCoursesTable.Visible = true;
btnITEJCPOLYCont.Visible = false;
btnITEJCPOLYSubmit.Visible = false;
DataTable ViewITEPolySchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%POLYTECHNIC%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEPolySchTable);
ITEJCPOLYTable.DataSource = ViewITEPolySchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "ITE")
{
PolyCoursesTable.Visible = false;
DataTable ViewITEPolySchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%ITE COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEPolySchTable);
ITEJCPOLYTable.DataSource = ViewITEPolySchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
}
protected void resetView()
{
if (radioSelectITEPolyJC.SelectedItem.Text == "ITE" || radioSelectITEPolyJC.SelectedItem.Text == "Junior College")
{
btn_updateTertiary1.Visible = false;
btn_updateTertiary2.Visible = false;
PolyCoursesTable.Visible = false;
}
if (radioSelectITEPolyJC.SelectedItem.Text == "Junior College")
{
DataTable ViewITEJCSchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%JUNIOR COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEJCSchTable);
ITEJCPOLYTable.DataSource = ViewITEJCSchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "Polytechnic")
{
DataTable ViewITEPolySchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%POLYTECHNIC%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEPolySchTable);
ITEJCPOLYTable.DataSource = ViewITEPolySchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "ITE")
{
DataTable ViewITEPolySchTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE school_name LIKE '%ITE COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEPolySchTable);
ITEJCPOLYTable.DataSource = ViewITEPolySchTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
}
protected void btnITEJCPOLYLocation(string area)
{
if (radioSelectITEPolyJC.SelectedItem.Text == "Junior College")
{
DataTable ViewJCPOLYTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE zone_code=@area AND school_name LIKE '%JUNIOR COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@area", area);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewJCPOLYTable);
ITEJCPOLYTable.DataSource = ViewJCPOLYTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "Polytechnic")
{
DataTable ViewITEJCPOLYTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE zone_code=@area AND school_name LIKE '%POLYTECHNIC%';";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@area", area);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEJCPOLYTable);
ITEJCPOLYTable.DataSource = ViewITEJCPOLYTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
else if (radioSelectITEPolyJC.SelectedItem.Text == "ITE")
{
DataTable ViewITEJCPOLYTable = new DataTable();
SqlConnection con = new DBManager().getConnection();
string sql = "SELECT school_name,zone_code, dgp_code,url_address FROM [CZ2006 - Life Planner].[dbo].[Schools] WHERE zone_code=@area AND school_name LIKE '%ITE COLLEGE%';";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@area", area);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ViewITEJCPOLYTable);
ITEJCPOLYTable.DataSource = ViewITEJCPOLYTable;
ITEJCPOLYTable.DataBind();
con.Close();
}
}
