//Updates the patient's vitals
public static void UpdatePatientVisitVitals(PatientVisitVitals vitals)
{
string updateStatement =
"UPDATE patient_visit_vitals SET " +
"pulse = @pulse, blood_pressure = @blood_pressure, temp = @temp, " +
"height = @height, weight = @weight " +
"WHERE visitID = @visitID AND vitalsID = @vitalsID";
try
{
using (SqlConnection connection = NorthwindDbConnection.GetConnection())
{
connection.Open();
using (SqlCommand updateCommand = new SqlCommand(updateStatement, connection))
{
//parameters
updateCommand.Parameters.AddWithValue("@visitID", vitals.VisitId);
updateCommand.Parameters.AddWithValue("@vitalsID", vitals.VitalsId);
updateCommand.Parameters.AddWithValue("@pulse", vitals.Pulse);
updateCommand.Parameters.AddWithValue("@blood_pressure", vitals.BloodPressure);
updateCommand.Parameters.AddWithValue("@temp", vitals.Temp);
updateCommand.Parameters.AddWithValue("@height", vitals.Height);
updateCommand.Parameters.AddWithValue("@weight", vitals.Weight);
updateCommand.ExecuteNonQuery();
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
//Adds a patient's vitals to a visit
public static int AddPatientVisitVitals(PatientVisitVitals vitals)
{
string insertStatement =
"INSERT patient_visit_vitals " +
"(visitID, blood_pressure, temp, pulse, height, weight) " +
"VALUES (@visitID, @blood_pressure, @temp, @pulse, @height, @weight)";
try
{
using (SqlConnection connection = NorthwindDbConnection.GetConnection())
{
connection.Open();
using (SqlCommand insertCommand = new SqlCommand(insertStatement, connection))
{
//parameters
insertCommand.Parameters.AddWithValue("@visitID", vitals.VisitId);
insertCommand.Parameters.AddWithValue("@blood_pressure", vitals.BloodPressure);
insertCommand.Parameters.AddWithValue("@temp", vitals.Temp);
insertCommand.Parameters.AddWithValue("@pulse", vitals.Pulse);
insertCommand.Parameters.AddWithValue("@height", vitals.Height);
insertCommand.Parameters.AddWithValue("@weight", vitals.Weight);
insertCommand.ExecuteNonQuery();
string selectStatement =
"SELECT IDENT_CURRENT('patient_visit_vitals') FROM patient_visit_vitals";
SqlCommand selectCommand =
new SqlCommand(selectStatement, connection);
int vitalsID = Convert.ToInt32(selectCommand.ExecuteScalar());
return vitalsID;
}
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
//Saves the vitals data to the database
private void saveButton2_Click(object sender, EventArgs e)
{
if (IsValidDataVitals())
{
vitals = new PatientVisitVitals();
this.PutPatientVisitVitalsData(vitals);
try
{
vitals.VitalsId = NorthwindController.AddPatientVisitVitals(vitals);
saveButton2.Visible = false;
editButton2.Visible = true;
editButton2.Enabled = false;
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
//Saves the vitals data
private void PutPatientVisitVitalsData(PatientVisitVitals vitals)
{
vitals.VisitId = patientVisit.VisitId;
vitals.BloodPressure = txtBoxBloodPressure.Text;
vitals.Temp = txtBoxTemperature.Text;
vitals.Pulse = txtBoxPulse.Text;
vitals.Height = int.Parse(txtBoxHeight.Text);
vitals.Weight = float.Parse(txtBoxWeight.Text);
}
//
private void editButton2_Click(object sender, EventArgs e)
{
if (IsValidDataVitals())
{
PatientVisitVitals updateVitals = new PatientVisitVitals();
this.PutPatientVisitVitalsData(updateVitals);
updateVitals.VitalsId = vitals.VitalsId;
try
{
NorthwindController.UpdatePatientVisitVitals(updateVitals);
editButton2.Enabled = false;
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
public static void UpdatePatientVisitVitals(PatientVisitVitals vitals)
{
PatientVisitVitalsDal.UpdatePatientVisitVitals(vitals);
}
public static int AddPatientVisitVitals(PatientVisitVitals vitals)
{
return PatientVisitVitalsDal.AddPatientVisitVitals(vitals);
}
