//Load form
private void AddPatientUserForm_Load(object sender, EventArgs e)
{
switch (typeTag)
{
//Create new patient form
case "Add":
Text = "Add New Patient";
newUserRadio.Checked = true;
existingPatientRadio.Checked = false; break;
case "Update":
this.Text = "Update Patient Info";
//Fill form with existing patient data
existingPatientRadio.Checked = true; newUserRadio.Checked = false;
this.patientTableAdapter1.Fill(this._HealthyPeopleDB_TestDataSet.Patient);
this.patientUserTableTableAdapter1.Fill(_HealthyPeopleDB_TestDataSet.PatientUserTable);
patientRow = this._HealthyPeopleDB_TestDataSet.Patient.FindByPatientID(patientID);
userTableRow = this._HealthyPeopleDB_TestDataSet.PatientUserTable.FindByPatientUserID(patientRow.PatientUserID);
patientIDTextBox.Text = patientRow.PatientID.ToString();
patientUserIDTextBox1.Text = patientRow.PatientUserID;
patientPasswordTextBox.Text = userTableRow.PatientPassword;
patientNameTextBox.Text = patientRow.PatientName;
patientStateTextBox.Text = patientRow.PatientState;
patientCityTextBox.Text = patientRow.PatientCity;
emailAddressTextBox.Text = patientRow.EmailAddress;
patientAddressTextBox.Text = patientRow.PatientAddress;
doctorsTextBox.Text = "";
patientPhoneNumberTextBox.Text = patientRow.PatientPhoneNumber;
patientBirthDateDateTimePicker.Value = patientRow.PatientBirthDate;
patientZipTextBox.Text = patientRow.PatientZip;
break;
}
}
private void SubmitButton_Click(object sender, EventArgs e)
{
if (newUserRadio.Checked)
// Adds new patient and user data to database
//User Data
{
userTableRow = this._HealthyPeopleDB_TestDataSet.PatientUserTable.NewPatientUserTableRow();
patientRow = this._HealthyPeopleDB_TestDataSet.Patient.NewPatientRow();
patientRow.PatientName = patientNameTextBox.Text;
patientRow.PatientPhoneNumber = patientPhoneNumberTextBox.Text;
patientRow.PatientBirthDate = patientBirthDateDateTimePicker.Value;
patientRow.PatientZip = patientZipTextBox.Text;
patientRow.Doctors = doctorsTextBox.Text;
patientRow.PatientCity = patientCityTextBox.Text;
patientRow.EmailAddress = emailAddressTextBox.Text;
patientRow.PatientState = patientStateTextBox.Text; //state
patientRow.PatientAddress = patientAddressTextBox.Text; //address
patientRow.PatientUserID = patientUserIDTextBox1.Text; //userID
userTableRow.PatientUserID = patientUserIDTextBox1.Text;
userTableRow.PatientPassword = patientPasswordTextBox.Text;
//Update Tables with new patient records
try
{
//Add and Update Records
this._HealthyPeopleDB_TestDataSet.PatientUserTable.Rows.Add(userTableRow);
this.patientUserTableTableAdapter1.Update(this._HealthyPeopleDB_TestDataSet.PatientUserTable);
this._HealthyPeopleDB_TestDataSet.Patient.Rows.Add(patientRow);
this.patientTableAdapter1.Update(this._HealthyPeopleDB_TestDataSet.Patient);
MessageBox.Show("Data Saved");
this.DialogResult = DialogResult.OK;
}
//Catches an exception
catch (Exception ex)
{
MessageBox.Show("{0}", ex.Source);
MessageBox.Show("{0}", ex.StackTrace);
this.DialogResult = DialogResult.Cancel;
}
}
//Update Patient User Data In System
else if (existingPatientRadio.Checked)
{
//Update data in variable
try
{
patientRow.PatientName = patientNameTextBox.Text;
patientRow.PatientPhoneNumber = patientPhoneNumberTextBox.Text;
patientRow.PatientBirthDate = patientBirthDateDateTimePicker.Value;
patientRow.PatientZip = patientZipTextBox.Text;
patientRow.PatientCity = patientCityTextBox.Text;
patientRow.EmailAddress = emailAddressTextBox.Text;
patientRow.PatientState = patientStateTextBox.Text;
patientRow.PatientAddress = patientAddressTextBox.Text;
patientRow.PatientUserID = patientUserIDTextBox1.Text;
userTableRow.PatientUserID = patientUserIDTextBox1.Text;
patientRow.Doctors = doctorsTextBox.Text;
userTableRow.PatientPassword = patientPasswordTextBox.Text;
//Update tables with new data
this.patientUserTableTableAdapter1.Update(userTableRow);
this.patientTableAdapter1.Update(patientRow);
this.DialogResult = DialogResult.OK;
}
// In case of any errors
catch (Exception ex)
{
MessageBox.Show(ex.Source, ex.Message);
this.DialogResult = DialogResult.Cancel;
}
}
}
