protected void btn_updateUni_Click(object sender, EventArgs e) { EditPlanDAO ep = new EditPlanDAO(); SqlConnection con = new DBManager().getConnection(); int count; string id = ep.getSchID(Session["uniName"].ToString()); string sql = "UPDATE dbo.PathPlan SET uniID=@uniID WHERE accountID=@accountID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@uniID", id); cmd.Parameters.AddWithValue("@accountID", Session["accountID"].ToString()); con.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); //update: count == 0 if (count == 0) { alert_placeholder.Visible = true; alert_placeholder.Attributes["class"] = "alert alert-success alert-dismissable"; alertText.Text = "Successfully updated! Redirecting to View Own Plan page..."; Response.AddHeader("REFRESH", "1;URL=ViewOwnPlan.aspx"); con.Close(); con.Dispose(); } else { con.Close(); con.Dispose(); Response.Redirect("Error.aspx"); } }
protected void btn_updateTertiary_Click(object sender, EventArgs e) { EditPlanDAO ep = new EditPlanDAO(); SqlConnection con = new DBManager().getConnection(); int count; if (radioSelectITEPolyJC.SelectedItem.Text == "Junior College") { string id = ep.getSchID(Session["JCName"].ToString()); string sql = "UPDATE dbo.PathPlan SET jcID=@jcID WHERE accountID=@accountID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@jcID", id); cmd.Parameters.AddWithValue("@accountID", Session["accountID"].ToString()); con.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); //update: count == 0 if (count == 0) { alert_placeholder.Visible = true; alert_placeholder.Attributes["class"] = "alert alert-success alert-dismissable"; alertText.Text = "Successfully updated! Redirecting to View Own Plan page..."; Response.AddHeader("REFRESH", "1;URL=ViewOwnPlan.aspx"); con.Close(); con.Dispose(); } else { con.Close(); con.Dispose(); Response.Redirect("Error.aspx"); } } else if (radioSelectITEPolyJC.SelectedItem.Text == "Polytechnic")//selected is poly { string id = ep.getSchID(Session["POLYName"].ToString()); string course = Session["PolyCourse"].ToString(); string sql = "UPDATE dbo.PathPlan SET polyID=@polyID, polyCourse=@polyCourse WHERE accountID=@accountID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@polyID", id); cmd.Parameters.AddWithValue("@polyCourse", course); cmd.Parameters.AddWithValue("@accountID", Session["accountID"].ToString()); con.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); //update: count == 0 if (count == 0) { alert_placeholder.Visible = true; alert_placeholder.Attributes["class"] = "alert alert-success alert-dismissable"; alertText.Text = "Successfully updated! Redirecting to View Own Plan page..."; Response.AddHeader("REFRESH", "1;URL=ViewOwnPlan.aspx"); con.Close(); con.Dispose(); } else { con.Close(); con.Dispose(); Response.Redirect("Error.aspx"); } } else //for ite { string id = ep.getSchID(Session["ITEName"].ToString()); string sql = "UPDATE dbo.PathPlan SET ITEID=@ITEID WHERE accountID=@accountID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@ITEID", id); cmd.Parameters.AddWithValue("@accountID", Session["accountID"].ToString()); con.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); //update: count == 0 if (count == 0) { alert_placeholder.Visible = true; alert_placeholder.Attributes["class"] = "alert alert-success alert-dismissable"; alertText.Text = "Successfully updated! Redirecting to View Own Plan page..."; Response.AddHeader("REFRESH", "1;URL=ViewOwnPlan.aspx"); con.Close(); con.Dispose(); } else { con.Close(); con.Dispose(); Response.Redirect("Error.aspx"); } } }