public void Save(PatientDisease patientDisease)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "INSERT INTO PatientDiseaseTable (PatientId,DiseaseId) VALUES('" + patientDisease.PatientId + "','"+patientDisease.DiseaseId+"')";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
private void saveButton_Click(object sender, EventArgs e)
{
PatientManager patientManager=new PatientManager();
PatientDiseaseManager patientDiseaseManager=new PatientDiseaseManager();
Patient patient=new Patient();
patient.Id = patientId;
patient.Name = patientsNameTextBox.Text;
patient.DoctorId = int.Parse(doctorComboBox.SelectedValue.ToString());
if (mode == "Update" && patient.Name!="")
{
int row = patientManager.Update(patient);
if (row == 1)
{
PatientDiseaseManager aPatientDiseaseManager=new PatientDiseaseManager();
aPatientDiseaseManager.DeleteExisting(patient);
foreach (var index in diseaseCheckedListBox.CheckedItems)
{
Disease disease = (Disease)index;
PatientDisease patientDisease = new PatientDisease();
patientDisease.PatientId = patient.Id;
patientDisease.DiseaseId = disease.Id;
patientDiseaseManager.Save(patientDisease);
}
Close();
MessageBox.Show("Patient Successfully Updated");
}
}
else if(patient.Name!="")
{
int retrievedPatientId = patientManager.Save(patient);
if (retrievedPatientId > 0)
{
foreach (var index in diseaseCheckedListBox.CheckedItems)
{
Disease disease = (Disease) index;
PatientDisease patientDisease = new PatientDisease();
patientDisease.PatientId = retrievedPatientId;
patientDisease.DiseaseId = disease.Id;
patientDiseaseManager.Save(patientDisease);
}
Close();
MessageBox.Show("Patient Successfully Saved");
}
}
else
{
MessageBox.Show("Name cannot be empty");
}
}
public void Save(PatientDisease patientDisease)
{
patientDiseaseGateway.Save(patientDisease);
}
