private void SetAppointmentFields()
{
oldApp = AppointmentController.GetAppointmentInfo(appointmentList[cbAppointments.SelectedIndex].AppointmentId);
tbNurse.Text = NurseController.GetNurseByID(oldApp.NurseId).UserName;
tbPatient.Text = PatientController.GetPatientByID(oldApp.PersonId).FullName;
tbSymptoms.Text = oldApp.Symptom;
tbDate.Value = oldApp.AppointmentDate;
}
public static Appointment GetAppointmentInfo(int appointmentID)
{
Appointment returnAppt = new Appointment();
try
{
returnAppt = AppointmentDB.GetAppointmentInfo(appointmentID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString(), MessageBoxButtons.OK);
}
return returnAppt;
}
public static bool UpdateAppointmentDiagnosis(Appointment oldAppointment, Appointment newAppointment)
{
Boolean success = false;
try
{
success = AppointmentDB.UpdateAppointmentDiagnosis(oldAppointment, newAppointment);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString(), MessageBoxButtons.OK);
}
return success;
}
/// <summary>
/// Adds an appointment to the db.
/// </summary>
/// <param name="newAppointment">The appointment to add</param>
/// <returns>The id of the new appointment</returns>
public static int AddAppointment(Appointment newAppointment)
{
int appointmentID = -1;
try
{
appointmentID = AppointmentDB.AddAppointment(newAppointment);
if (appointmentID == -1)
{
throw new Exception("Error adding the appointment to the Database");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString(), MessageBoxButtons.OK);
}
return appointmentID;
}
public static List<Appointment> GetAppointmentsWithoutDiagnosis()
{
List<Appointment> undiagnosedAppointmentList = new List<Appointment>();
string selectStatement = "SELECT * FROM Appointment WHERE diagnosis IS NULL";
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Appointment undiagnosedAppointment = new Appointment();
undiagnosedAppointment.AppointmentId = (int)reader["appointmentID"];
undiagnosedAppointmentList.Add(undiagnosedAppointment);
}
connection.Close();
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return undiagnosedAppointmentList;
}
/// <summary>
/// Adds a appointment record to the db.
/// </summary>
/// <param name="appointment">The appointment record to add</param>
/// <returns>The appointment ID</returns>
public static int AddAppointment(Appointment appointment)
{
int appointmentID = -1;
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
string insertStatement =
"INSERT Appointment " +
"(PersonId, NurseId, DoctorId, AppointmentDate, Symptom) " +
"VALUES (@PersonID, @NurseID, @DoctorId, @AppointmentDate, @Symptom)";
using (SqlCommand insertCommand = new SqlCommand(insertStatement, connection))
{
insertCommand.Parameters.AddWithValue("@PersonID", appointment.PersonId);
insertCommand.Parameters.AddWithValue("@NurseID", appointment.NurseId);
insertCommand.Parameters.AddWithValue("@DoctorID", appointment.DoctorId);
insertCommand.Parameters.AddWithValue("@AppointmentDate", appointment.AppointmentDate);
insertCommand.Parameters.AddWithValue("@Symptom", appointment.Symptom);
connection.Open();
insertCommand.ExecuteNonQuery();
string selectStatement =
"SELECT IDENT_CURRENT('Appointment') FROM Appointment";
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
appointmentID = Convert.ToInt32(selectCommand.ExecuteScalar());
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
return appointmentID;
}
private void addButton_Click(object sender, EventArgs e)
{
//Validates required fields.
if (Validator.AreAllPresent(controls))
{
newAppointment = new Appointment();
newAppointment.PersonId = Convert.ToInt32(comboBoxPatient.SelectedValue);
newAppointment.NurseId = GlobalVars.Instance.CurrentUser.UserID;
newAppointment.DoctorId = Convert.ToInt32(cbDoctor.SelectedValue);
newAppointment.AppointmentDate = dateTextBox.Value;
newAppointment.Symptom = symptomsTextBox.Text;
int appID = AppointmentController.AddAppointment(newAppointment);
if (appID > -1)
MessageBox.Show("Appointment scheduled.", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
MessageBox.Show("Appointment not scheduled.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
ClearAllControls();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
bool success = false;
try
{
newApp = oldApp;
if (Validator.IsPresent(tbDiagnosis))
{
newApp.Diagnosis = tbDiagnosis.Text;
success = AppointmentController.UpdateAppointmentDiagnosis(oldApp, newApp);
GetUndiagnosedAppointments();
}
if (success)
{
MessageBox.Show("Diagnosis has been successfully updated!", "Appointment Updated!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
MessageBox.Show("The appointment has not been updated.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List<Appointment> GetAllAppointments()
{
List<Appointment> apptList = new List<Appointment>();
string selectStatement = "SELECT appointmentID " +
"FROM Appointment GROUP BY appointmentID";
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
try
{
connection.Open();
}
catch (SqlException ex)
{
throw ex;
}
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Appointment aResult = new Appointment();
aResult.AppointmentId = (int)reader["AppointmentID"];
apptList.Add(aResult);
}
connection.Close();
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return apptList;
}
public static bool UpdateAppointmentDiagnosis(Appointment oldAppointment, Appointment newAppointment)
{
bool success = false;
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
string updateStatement =
"UPDATE Appointment SET " +
"diagnosis = @NewDiagnosis " +
"WHERE appointmentID = @OldAppointmentID " +
"AND personID = @OldPersonID " +
"AND nurseID = @OldNurseID " +
"AND doctorID = @OldDoctorID " +
"AND symptom = @OldSymptom";
connection.Open();
using (SqlCommand updateCommand = new SqlCommand(updateStatement, connection))
{
//updateCommand.Parameters.AddWithValue("@NewAppointmentID", newAppointment.AppointmentId);
//updateCommand.Parameters.AddWithValue("@NewPersonID", newAppointment.PersonId);
//updateCommand.Parameters.AddWithValue("@NewNurseID", newAppointment.NurseId);
updateCommand.Parameters.AddWithValue("@NewDiagnosis", newAppointment.Diagnosis);
//updateCommand.Parameters.AddWithValue("@NewSymptom", newAppointment.Symptom);
updateCommand.Parameters.AddWithValue("@OldAppointmentID", oldAppointment.AppointmentId);
updateCommand.Parameters.AddWithValue("@OldPersonID", oldAppointment.PersonId);
updateCommand.Parameters.AddWithValue("@OldNurseID", oldAppointment.NurseId);
updateCommand.Parameters.AddWithValue("@OldDoctorID", oldAppointment.DoctorId);
updateCommand.Parameters.AddWithValue("@OldSymptom", oldAppointment.Symptom);
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
success = true;
}
else
{
success = false;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return success;
}
public static List<Appointment> GetAppointmentsWithoutVitals()
{
List<Appointment> appointmentsWithoutVitals = new List<Appointment>();
string selectStatement = "SELECT * FROM Appointment WHERE Appointment.AppointmentId NOT IN (SELECT appointmentID FROM Vitals)";
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Appointment appt = new Appointment();
appt.AppointmentId = (int)reader["AppointmentID"];
appointmentsWithoutVitals.Add(appt);
}
connection.Close();
}
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return appointmentsWithoutVitals;
}
public static List<Appointment> GetUndiagnosedAppointmentListByAppointmentID(int appointmentID)
{
List<Appointment> openApptList = new List<Appointment>();
string selectStatement = "SELECT * " +
"FROM Appointment WHERE Appointment.Diagnosis IS NULL AND Appointment.AppointmentID = " + appointmentID;
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
try
{
connection.Open();
}
catch (SqlException ex)
{
throw ex;
}
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Appointment aResult = new Appointment();
aResult.AppointmentId = (int)reader["AppointmentID"];
aResult.AppointmentDate = (DateTime)reader["AppointmentDate"];
openApptList.Add(aResult);
}
connection.Close();
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return openApptList;
}
public static Appointment GetAppointmentInfo(int appointmentID)
{
Appointment appointment = new Appointment();
try
{
using (SqlConnection connection = HealthCareDBConnection.GetConnection())
{
string selectStatement = "SELECT * FROM Appointment WHERE appointmentID = @appointmentID";
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
selectCommand.Parameters.AddWithValue("@appointmentID", appointmentID);
connection.Open();
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Appointment anAppointment = new Appointment();
anAppointment.AppointmentId = (int)reader["appointmentID"];
anAppointment.PersonId = (int)reader["personID"];
anAppointment.NurseId = (int)reader["nurseID"];
anAppointment.DoctorId = (int)reader["doctorID"];
anAppointment.AppointmentDate = (DateTime)reader["appointmentDate"];
anAppointment.Symptom = (String)reader["symptom"];
anAppointment.Diagnosis = !DBNull.Value.Equals(reader["diagnosis"]) ? (String)reader["diagnosis"] : null;
appointment = anAppointment;
}
return appointment;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void SetAppointmentFields()
{
oldApp = AppointmentController.GetAppointmentInfo(allAppointments[cbAppId.SelectedIndex].AppointmentId);
tbNurse.Text = NurseController.GetNurseByID(oldApp.NurseId).UserName;
tbPatient.Text = PatientController.GetPatientByID(oldApp.PersonId).FullName;
tbSymptoms.Text = oldApp.Symptom;
tbDate.Value = oldApp.AppointmentDate;
tbDiagnosis.Text = oldApp.Diagnosis;
tbDoctor.Text = DoctorController.GetDoctorByID(oldApp.DoctorId).FullName;
}
