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