private void updatePatientButton_Click(object sender, EventArgs e)
{
DBConnector dbC = new DBConnector();
dbC.connect();
PatientHandler patientHandler = new PatientHandler();
Patient oldPatientData = new Patient();
if (choosePatientIDUpdateComboBox.SelectedIndex == 0)
{
MessageBox.Show("Please select valid ID");
return;
}
if (nricUpdateTextBox.Enabled == false)
{
MessageBox.Show("Please press 'Enter' to generate data first");
return;
}
else
{
oldPatientData = patientHandler.getSpecificPatient(dbC.getConn(), int.Parse(choosePatientIDUpdateComboBox.SelectedItem.ToString()));
}
if ((oldPatientData.IdentityCard.ToString() != nricUpdateTextBox.Text) || (oldPatientData.FullName != fullNameUpdateTextBox.Text) || (oldPatientData.Email != emailUpdateTextBox.Text) || (oldPatientData.Gender != genderUpdatecomboBox.SelectedItem.ToString()) || (oldPatientData.Phone.ToString() != phoneUpdateTextBox.Text) || (oldPatientData.Address != addressUpdateTextBox.Text) || (oldPatientData.Age.ToString() != ageUpdateTextBox.Text) || (oldPatientData.BedsideId.ToString() != bedsideIdUpdateTextBox.Text))
{
Patient newPatientData = new Patient();
newPatientData.Id = int.Parse(choosePatientIDUpdateComboBox.SelectedItem.ToString());
newPatientData.IdentityCard = long.Parse(nricUpdateTextBox.Text);
newPatientData.FullName = fullNameUpdateTextBox.Text;
newPatientData.Email = emailUpdateTextBox.Text;
newPatientData.Gender = genderUpdatecomboBox.SelectedItem.ToString();
newPatientData.Phone = int.Parse(phoneUpdateTextBox.Text);
newPatientData.Address = addressUpdateTextBox.Text;
newPatientData.Age = int.Parse(ageUpdateTextBox.Text);
newPatientData.BedsideId = int.Parse(bedsideIdUpdateTextBox.Text);
int updateResult = patientHandler.updatePatientData(dbC.getConn(), newPatientData);
if (updateResult == 1)
{
MessageBox.Show("Update Successfully");
closeAllTextBox(fullNameUpdateTextBox, nricUpdateTextBox, emailUpdateTextBox, phoneTextBox, addressUpdateTextBox, ageUpdateTextBox, bedsideIdUpdateTextBox, choosePatientIDUpdateComboBox, genderUpdatecomboBox);
patientHandler.FetchId(choosePatientIDUpdateComboBox);
}
else
{
MessageBox.Show("Update Failed");
}
}
else
{
MessageBox.Show("Nothing is changes");
}
}
private void deletePatientRecordBtn_Click(object sender, EventArgs e)
{
DBConnector dbC = new DBConnector();
dbC.connect();
PatientHandler patientHandler = new PatientHandler();
Patient oldPatientData = new Patient();
if (choosePatientIDDeleteComboBox.SelectedIndex == 0)
{
MessageBox.Show("Please select valid ID");
return;
}
if (string.IsNullOrEmpty(nricDeleteTextBox.Text))
{
MessageBox.Show("Please press 'Enter' to generate data first");
return;
}
else
{
oldPatientData = patientHandler.getSpecificPatient(dbC.getConn(), int.Parse(choosePatientIDDeleteComboBox.SelectedItem.ToString()));
}
int deleteResult = patientHandler.deletePatientData(dbC.getConn(), oldPatientData.Id);
if (deleteResult == 1)
{
MessageBox.Show("Delete Record Successfully");
closeAllTextBox(fullNameDeleteTextBox, nricDeleteTextBox, emailDeleteTextBox, phoneDeleteTextBox, addressDeleteRichTextBox, ageDeleteTextBox, bedsideIdDeleteTextBox, choosePatientIDDeleteComboBox, genderDeleteComboBox);
patientHandler.FetchId(choosePatientIDDeleteComboBox);
}
else
{
MessageBox.Show("Delete Failed");
}
}