protected void Button1_Click(object sender, EventArgs e) { dbcontext.Appointments.Load(); if (!IsPostBack) { //get doctor SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities(); int docIDT = Convert.ToInt32(doctorDropDownList.SelectedValue); SQL.Doctor doc = (from x in dbcon.Doctors where x.DoctorID == docIDT select x).First(); //Appointments are all a half hour long. Thanks Oksana! TimeSpan aptLength = new TimeSpan(0, 0, 30); DateTime aptDate = DateTime.Parse(startDateTextBox.Text); //Get all of doctors appointments on the day of the appointment List <SQL.Appointment> aptList = (from x in dbcon.Appointments where x.DoctorID == doc.DoctorID && x.AppointmentDate == aptDate select x).ToList(); TimeSpan aptTime = TimeSpan.Parse(appointmentsDropDownList.SelectedValue); //check to see if time is valid foreach (SQL.Appointment cur_Apt in aptList) { if (cur_Apt.AppointmentTime >= aptTime && cur_Apt.AppointmentTime <= aptTime.Add(aptLength)) { throw new Exception("Time is invalid!"); } } } }
protected void Button1_Click(object sender, EventArgs e) { using (SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities()) { //dbcon.Patients.Load(); //SQL.Patient myPatient = dbcon.Patients.Local.First(); dbcon.Messages.Load(); SQL.Message myMsg = new SQL.Message(); //Label1.Text = usrID; myMsg.MessageID = dbcon.Messages.Local.Count + 1; myMsg.FROM = User.Identity.Name; myMsg.TO = Convert.ToString(DropDownList1.SelectedItem.Value); myMsg.Message1 = TextBox1.Text; dbcon.Messages.Add(myMsg); dbcon.SaveChanges(); } GridView1.DataBind(); }
protected void aptGridView_SelectedIndexChanged(object sender, EventArgs e) { //if (!IsPostBack) //{ SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities(); dbcon.Appointments.Load(); SQL.Patient patient = (from x in dbcon.Patients where x.Email.Equals(User.Identity.Name) select x).First(); int something = Convert.ToInt32(aptGridView.SelectedDataKey[0]); SQL.Appointment apt = (from x in dbcon.Appointments where x.AppointmentID == something select x).First(); SQL.Doctor doc = (from x in dbcon.Doctors where x.DoctorID == apt.DoctorID select x).First(); var testShite = (from a in dbcon.Appointments select new { aptID = a.AppointmentID, aptPatient = a.PatientID, aptDoctor = a.DoctorID, aptDate = a.AppointmentDate, aptTime = a.AppointmentTime, aptLoc = a.AppointmentLocation, aptDept = a.DepartmentID, aptHospital = a.HospitalID, aptReason = a.Reason }).ToList(); string[] potentialKeys = { "AppointmentID" }; aptGridView.DataSource = testShite; aptGridView.DataKeyNames = potentialKeys; lblPName.Text = "Patient name: " + patient.LastName + "," + patient.FirstName; lblDName.Text = "Doctor name: " + doc.LastName + "," + doc.FirstName; lblLoc.Text = "Appointment location: " + apt.AppointmentLocation; lblDate.Text = "Appointment date: " + apt.AppointmentDate + "@" + apt.AppointmentTime; lblReason.Text = "Reason: " + apt.Reason; //} }
protected void Button1_Click(object sender, EventArgs e) { SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities(); if (dbcon != null) { dbcon.Dispose(); } dbcon = new SQL.HealthclinicEntities(); try { dbcon.Appointments.Load(); int notSomething = Convert.ToInt32(aptGridView.SelectedDataKey[0]); SQL.Appointment myAppointment = (from x in dbcon.Appointments where x.AppointmentID == notSomething select x).First(); dbcon.Appointments.Remove(myAppointment); dbcon.SaveChanges(); var testShite = (from a in dbcon.Appointments select new { aptID = a.AppointmentID, aptPatient = a.PatientID, aptDoctor = a.DoctorID, aptDate = a.AppointmentDate, aptTime = a.AppointmentTime, aptLoc = a.AppointmentLocation, aptDept = a.DepartmentID, aptHospital = a.HospitalID, aptReason = a.Reason }).ToList(); // aptGridView.DataSource = testShite; // aptGridView.DataBind(); } catch { throw; } }
protected void Page_Load(object sender, EventArgs e) { SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities(); dbcon.Appointments.Load(); try { SQL.Patient patient = (from x in dbcon.Patients where x.Email.Equals(User.Identity.Name) select x).First(); List <SQL.Appointment> apts = (from x in dbcon.Appointments where x.PatientID == patient.PatientID select x).ToList(); aptGridView.DataSource = apts; //aptGridView.DataKeyNames = "AppointmentID"; aptGridView.DataBind(); } catch (InvalidOperationException) { throw; } }