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