public AppointmentForm(string operation)
{
InitializeComponent();
AppointmentDatabaseEntities = new AppointmentDatabaseEntities();
AppointmentDatabaseEntities.Appointments.Load();
appointments = new BindingList <AppointmentRegistration.Appointment>(AppointmentDatabaseEntities.Appointments.Local);
this.operation = operation;
listBox.DataSource = appointments;
if (operation == "create")
{
infoTextBox.Text = "Please enter appropriate entries into all fields. Results will be displayed as Date Time Room Number";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
addressExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
addressExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = false;
}
else if (operation == "read")
{
infoTextBox.Text = "Please enter the date you would like to search for in the search name box";
nameSearchLabel.Visible = true;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = true;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = true;
executeButton.Visible = false;
nameExecuteLabel.Visible = false;
addressExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
addressExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = false;
}
else if (operation == "update")
{
infoTextBox.Text = "Select the patient you would like to update, enter the new date, time, and room number, and click execute";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
addressExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
addressExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = true;
}
else if (operation == "delete")
{
infoTextBox.Text = "Select the appointment you would like to delete and hit execute";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = false;
addressExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
addressExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = true;
}
}
private void executeButton_Click(object sender, EventArgs e)
{
if (operation == "create")
{
if (emptyBoxes())
{
resultsTextBox.Text = "Failed to add Appointment, please enter all fields";
}
else
{
using (AppointmentDatabaseEntities entities = new AppointmentDatabaseEntities())
{
AppointmentRegistration.Appointment appointment = new AppointmentRegistration.Appointment
{
date = nameExecuteTextBox.Text,
time = addressExecuteTextBox.Text,
roomNumber = int.Parse(phoneNumberExecuteTextBox.Text)
};
entities.Appointments.Add(appointment);
entities.SaveChanges();
populate();
}
foreach (var x in AppointmentDatabaseEntities.Appointments)
{
if (x.date == nameExecuteTextBox.Text && x.time == addressExecuteTextBox.Text)
{
resultsTextBox.Text = x.resultsString;
}
}
nameExecuteTextBox.Text = String.Empty;
addressExecuteTextBox.Text = String.Empty;
phoneNumberExecuteTextBox.Text = String.Empty;
}
}
else if (operation == "update")
{
var selectedAppointment = listBox.SelectedItem as AppointmentRegistration.Appointment;
if (emptyBoxes())
{
resultsTextBox.Text = "Not all text boxes are filled";
}
else
{
selectedAppointment.date = nameExecuteTextBox.Text;
selectedAppointment.time = addressExecuteTextBox.Text;
selectedAppointment.roomNumber = int.Parse(phoneNumberExecuteTextBox.Text);
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Update Saved";
}
}
else if (operation == "delete")
{
var selectedAppointment = listBox.SelectedItem as AppointmentRegistration.Appointment;
AppointmentDatabaseEntities.Appointments.Remove(selectedAppointment);
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Appointment Deleted";
}
}
public ScheduleForm(string operation)
{
InitializeComponent();
AppointmentDatabaseEntities = new AppointmentDatabaseEntities();
AppointmentDatabaseEntities.Schedules.Load();
schedules = new BindingList <AppointmentRegistration.Schedule>(AppointmentDatabaseEntities.Schedules.Local);
AppointmentDatabaseEntities.Appointments.Load();
appointments = new BindingList <AppointmentRegistration.Appointment>(AppointmentDatabaseEntities.Appointments.Local);
AppointmentDatabaseEntities.Patients.Load();
patients = new BindingList <AppointmentRegistration.Patient>(AppointmentDatabaseEntities.Patients.Local);
AppointmentDatabaseEntities.Doctors.Load();
doctors = new BindingList <AppointmentRegistration.Doctor>(AppointmentDatabaseEntities.Doctors.Local);
AppointmentDatabaseEntities.Nurses.Load();
nurses = new BindingList <AppointmentRegistration.Nurse>(AppointmentDatabaseEntities.Nurses.Local);
this.operation = operation;
listBox.DataSource = schedules;
if (operation == "create")
{
infoTextBox.Text = "Please enter appropriate entries into all fields. Results will be displayed as Ids Appointment, Patient Doctor, Nurse";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
addressExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
addressExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = false;
newLabel.Visible = true;
newTextBox.Visible = true;
}
else if (operation == "read")
{
infoTextBox.Text = "Please enter the Appointment Id you would like to search for in the search name box";
nameSearchLabel.Visible = true;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = true;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = true;
executeButton.Visible = false;
nameExecuteLabel.Visible = false;
addressExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
addressExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = false;
newLabel.Visible = false;
newTextBox.Visible = false;
}
else if (operation == "update")
{
infoTextBox.Text = "Select the patient you would like to update, enter the new Ids Appointment, patient, doctor, and nurse, and click execute";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
addressExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
addressExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = true;
newLabel.Visible = true;
newTextBox.Visible = true;
}
else if (operation == "delete")
{
infoTextBox.Text = "Select the schedule you would like to delete and hit execute";
nameSearchLabel.Visible = false;
addressSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
addressSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = false;
addressExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
addressExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = true;
}
}
private void executeButton_Click(object sender, EventArgs e)
{
if (operation == "create")
{
if (emptyBoxes())
{
resultsTextBox.Text = "Failed to add Schedule, please enter all fields";
}
else
{
if (keyChecker())
{
using (AppointmentDatabaseEntities entities = new AppointmentDatabaseEntities())
{
AppointmentRegistration.Schedule schedule = new AppointmentRegistration.Schedule
{
appointmentId = int.Parse(nameExecuteTextBox.Text),
patientId = int.Parse(addressExecuteTextBox.Text),
doctorId = int.Parse(phoneNumberExecuteTextBox.Text),
nurseId = int.Parse(newTextBox.Text)
};
entities.Schedules.Add(schedule);
entities.SaveChanges();
populate();
}
foreach (var x in AppointmentDatabaseEntities.Schedules)
{
if (x.appointmentId == int.Parse(nameExecuteTextBox.Text) && x.patientId == int.Parse(addressExecuteTextBox.Text))
{
resultsTextBox.Text = x.resultsString;
}
}
nameExecuteTextBox.Text = String.Empty;
addressExecuteTextBox.Text = String.Empty;
phoneNumberExecuteTextBox.Text = String.Empty;
newTextBox.Text = String.Empty;
}
else
{
resultsTextBox.Text = "Invalid Foreign Keys";
}
}
}
else if (operation == "update")
{
var selectedSchedule = listBox.SelectedItem as AppointmentRegistration.Schedule;
if (emptyBoxes())
{
resultsTextBox.Text = "Not all text boxes are filled";
}
else
{
if (keyChecker())
{
selectedSchedule.appointmentId = int.Parse(nameExecuteTextBox.Text);
selectedSchedule.patientId = int.Parse(addressExecuteTextBox.Text);
selectedSchedule.doctorId = int.Parse(phoneNumberExecuteTextBox.Text);
selectedSchedule.nurseId = int.Parse(newTextBox.Text);
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Update Saved";
}
else
{
resultsTextBox.Text = "Invalid Foreign Keys";
}
}
}
else if (operation == "delete")
{
var selectedSchedule = listBox.SelectedItem as AppointmentRegistration.Schedule;
AppointmentDatabaseEntities.Schedules.Remove(selectedSchedule);
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Appointment Deleted";
}
}
public DoctorForm(string operation)
{
InitializeComponent();
AppointmentDatabaseEntities = new AppointmentDatabaseEntities();
AppointmentDatabaseEntities.Doctors.Load();
doctors = new BindingList <AppointmentRegistration.Doctor>(AppointmentDatabaseEntities.Doctors.Local);
this.operation = operation;
listBox.DataSource = doctors;
if (operation == "create")
{
infoTextBox.Text = "Please enter appropriate entries into all fields. Results will be displayed as Id Name PhoneNumber";
nameSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = false;
}
else if (operation == "read")
{
infoTextBox.Text = "Please enter the name you would like to search for in the search name box";
nameSearchLabel.Visible = true;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = true;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = true;
executeButton.Visible = false;
nameExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = false;
}
else if (operation == "update")
{
infoTextBox.Text = "Select the doctor you would like to update, enter the new name and phone number, and click execute";
nameSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = true;
phoneNumberExecuteLabel.Visible = true;
nameExecuteTextBox.Visible = true;
phoneNumberExecuteTextBox.Visible = true;
listBox.Visible = true;
}
else if (operation == "delete")
{
infoTextBox.Text = "Select the doctor you would like to delete and hit execute";
nameSearchLabel.Visible = false;
phoneNumberSearchLabel.Visible = false;
nameSearchTextBox.Visible = false;
phoneNumberSearchTextBox.Visible = false;
searchButton.Visible = false;
executeButton.Visible = true;
nameExecuteLabel.Visible = false;
phoneNumberExecuteLabel.Visible = false;
nameExecuteTextBox.Visible = false;
phoneNumberExecuteTextBox.Visible = false;
listBox.Visible = true;
}
}
private void executeButton_Click(object sender, EventArgs e)
{
if (operation == "create")
{
if (emptyBoxes())
{
resultsTextBox.Text = "Failed to add Doctor, please enter all fields";
}
else
{
using (AppointmentDatabaseEntities entities = new AppointmentDatabaseEntities())
{
AppointmentRegistration.Doctor doctor = new AppointmentRegistration.Doctor
{
name = nameExecuteTextBox.Text,
phoneNumber = phoneNumberExecuteTextBox.Text
};
entities.Doctors.Add(doctor);
entities.SaveChanges();
populate();
}
foreach (var x in AppointmentDatabaseEntities.Doctors)
{
if (x.name == nameExecuteTextBox.Text && x.phoneNumber == phoneNumberExecuteTextBox.Text)
{
resultsTextBox.Text = x.resultsString;
}
}
nameExecuteTextBox.Text = String.Empty;
phoneNumberExecuteTextBox.Text = String.Empty;
}
}
else if (operation == "update")
{
var selectedDoctor = listBox.SelectedItem as AppointmentRegistration.Doctor;
if (emptyBoxes())
{
resultsTextBox.Text = "Not all text boxes are filled";
}
else
{
selectedDoctor.name = nameExecuteTextBox.Text;
selectedDoctor.phoneNumber = phoneNumberExecuteTextBox.Text;
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Update Saved";
}
}
else if (operation == "delete")
{
var selectedDoctor = listBox.SelectedItem as AppointmentRegistration.Doctor;
if (selectedDoctor.Schedules.Count > 0)
{
resultsTextBox.Text = "You can't delete a doctor scheduled for an appointment";
}
else
{
AppointmentDatabaseEntities.Doctors.Remove(selectedDoctor);
AppointmentDatabaseEntities.SaveChanges();
populate();
resultsTextBox.Text = "Doctor Deleted";
}
}
}
