//change session's status
protected void btn_status_Click(object sender, EventArgs e)
{
//check if a session has been selected before proceeding
if (Session["selectedRow"] == null)
{
HttpContext.Current.Response.Write("<script>alert('Please select a session to be modyfied first!')</script>"); //error message
}
else
{
//get the current status of a selected session from the database
string currentStatus = DBconnection.getStatus(Session["selectedRow"].ToString(), DropDownList1.SelectedValue);
string updatedStatus = "something went wrong";
//set status to the opposite [Active = Cancelled/Cancelled = Active]
if (currentStatus.Equals("Active"))
{
updatedStatus = "Cancelled";
}
else if (currentStatus.Equals("Cancelled"))
{
updatedStatus = "Active";
}
else
{
return;
}
//update status in the database
DBconnection.changeStatus(DropDownList1.SelectedValue, updatedStatus, Session["selectedRow"].ToString());
//clear gridview selection and reset data
GridView1.SelectedIndex = -1;
Session["selectedRow"] = null;
refreshTable();
HttpContext.Current.Response.Write("<script>alert('Session has been set to " + updatedStatus + ".')</script>"); //conrimation message
}
}
