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!");
}
}