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