protected void btnSubmit_Click(object sender, EventArgs e)
{
AppointmentAppDbEntities dbcon = new AppointmentAppDbEntities();
dbcon.AppointmentTables.Load();
int hour = Convert.ToInt32(ddlHour.SelectedValue.ToString());
int minute = Convert.ToInt32(ddlMinute.SelectedValue.ToString());
if (validateAppointment(txtAdvisorName.Text, Convert.ToDateTime(lblDate.Text), new TimeSpan(hour, minute, 0)))
{
AppointmentTable myAppointment = new AppointmentTable();
myAppointment.AdvisorName = txtAdvisorName.Text;
myAppointment.Location = txtLocation.Text;
myAppointment.Date = Convert.ToDateTime(lblDate.Text);
myAppointment.Time = new TimeSpan(hour, minute, 0);
myAppointment.Reason = txtReason.Text;
dbcon.AppointmentTables.Add(myAppointment);
dbcon.SaveChanges();
gvBrowse.DataBind();
lstResult.Items.Clear();
lstResult.Items.Add("Student name: name, Advisor Name: " + txtAdvisorName.Text);
lstResult.Items.Add("Location: " + txtLocation.Text);
lstResult.Items.Add("Date: " + Convert.ToDateTime(lblDate.Text));
lstResult.Items.Add("Time: " + new TimeSpan(hour, minute, 0));
lstResult.Items.Add("Reason: " + txtReason.Text);
}
}
private bool validateAppointment(string advisorName, DateTime appDate, TimeSpan appTime)
{
AppointmentAppDbEntities dbcon = new AppointmentAppDbEntities();
dbcon.AppointmentTables.Load();
try
{
AppointmentTable existingApp =
(from x in dbcon.AppointmentTables.Local
where x.Date.Equals(appDate) && x.Time.Equals(appTime)
select x).First();
}
catch (Exception e)
{
return(advisorAvailable(advisorName, appDate, appTime));
}
lstResult.Items.Clear();
lstResult.Items.Add("You already have an existing appointment at that date and time.");
return(false);
}
