protected void addSchedBtn_Click(object sender, EventArgs e)
        {
            ScheduleManager sM = new ScheduleManager();
            PreferenceManager pM = new PreferenceManager();
            String availability = "";

            try
            {
                if (availabilityCheckBox.Items.Cast<ListItem>().Any(item => item.Selected))
                {
                    foreach (ListItem listDay in availabilityCheckBox.Items)
                        if (listDay.Selected)
                            availability += listDay.Value + "-";

                    availability = availability.Remove(availability.Length - 1);

                    if (pM.addPreference(Session["account"].ToString(), categoryDropDownList.SelectedItem.Value.ToString(), subjectTxtBox.Text, descTxtBox.Text, targetTxtBox.Text, priceTxtBox.Text))
                        if (sM.addSchedule(availability, startingTimeTxtBox1.Text + ":" + startingTimeTxtBox2.Text + "-" + EndTimeTxtBox1.Text + ":" + EndTimeTxtBox2.Text))
                           Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Schedule added!');</script>");
                }
                else
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please select an available day');</script>");
            }
            catch
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Error adding schedule');</script>");
            }
        }
        public bool addSchedule(String day, String time)
        {
            try
            {
                PreferenceManager pm = new PreferenceManager();
                string insertQuery;
                int id = pm.getTopPrefID();

                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                conn.Open();

                insertQuery = "insert into [T.P.SCHEDULE] (pref_id, day, time) values (@PrefID, @Day, @Time);";
                SqlCommand com = new SqlCommand(insertQuery, conn);
                com.Parameters.AddWithValue("@PrefID", id);
                com.Parameters.AddWithValue("@Day", day);
                com.Parameters.AddWithValue("@Time", time);
                com.ExecuteNonQuery();

                conn.Close();

                return true;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Schedule");
                return false;
            }
        }
        protected void addSchedBtn_Click(object sender, EventArgs e)
        {
            ScheduleManager sM = new ScheduleManager();
            PreferenceManager pM = new PreferenceManager();

            try
            {
                if (pM.addPreference(Session["account"].ToString(), categoryTxtBox.Text, subjectTxtBox.Text, descTxtBox.Text, targetTxtBox.Text, priceTxtBox.Text) && sM.addSchedule(dayTxtBox.Text, timeTxtBox.Text))
                    MessageBox.Show("Schedule Added!");
            }
            catch
            {
                MessageBox.Show("Error Adding Schedule!");
            }
                
        }