public void DeleteExisting(Patient patient)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "DELETE FROM PatientDiseaseTable WHERE PatientId='" + patient.Id + "'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
public Patient GetPatientById(int patientId)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "SELECT * FROM PatientTable WHERE Id='" + patientId + "'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
Patient patient = new Patient();
while (sqlDataReader.Read())
{
patient.Id = int.Parse(sqlDataReader["Id"].ToString());
patient.Name = sqlDataReader["Name"].ToString();
}
return patient;
}
public int Update(Patient patient)
{
return patientGateway.Update(patient);
}
public int Save(Patient patient)
{
return patientGateway.Save(patient);
}
public List<Patient> GetPatientsByDoctorId(int id)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "SELECT * FROM DoctorPatientView WHERE Id='"+id+"'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
List<Patient> patientList = new List<Patient>();
while (sqlDataReader.Read())
{
Patient patient = new Patient();
patient.Id = int.Parse(sqlDataReader["Id"].ToString());
patient.Name = sqlDataReader["PatientName"].ToString();
patientList.Add(patient);
}
return patientList;
}
public int Update(Patient patient)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "UPDATE PatientTable SET Name='" + patient.Name + "',DoctorId='" + patient.DoctorId + "'WHERE Id='"+patient.Id+"'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int row = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
if (row == 1)
{
return row;
}
else
{
return 0;
}
}
public int Save(Patient patient)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "INSERT INTO PatientTable (Name,DoctorId) OUTPUT INSERTED.ID VALUES('" + patient.Name + "','" + patient.DoctorId + "')";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int row = (int) sqlCommand.ExecuteScalar();
sqlConnection.Close();
if (row > 0)
{
return row;
}
else
{
return 0;
}
}
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 DeleteExisting(Patient patient)
{
patientDiseaseGateway.DeleteExisting(patient);
}
