private void saveButton_Click(object sender, EventArgs e)
{
DiseaseManager diseaseManager=new DiseaseManager();
Disease disease=new Disease();
disease.Name = diseaseNameTextBox.Text;
if (diseaseManager.Save(disease))
{
Close();
MessageBox.Show("Disease Successfully Added");
}
}
public bool Save(Disease disease)
{
if (disease.Name == "")
{
MessageBox.Show("Name cannot be empty");
return false;
}
else
{
DiseaseGateway diseaseGateway = new DiseaseGateway();
return diseaseGateway.Save(disease);
}
}
public bool Save(Disease disease)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "INSERT INTO DiseaseTable (Name) VALUES('" + disease.Name + "')";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
int row = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
if (row == 1)
{
return true;
}
else
{
return false;
}
}
public List<Disease> GetDiseasesBypatientId(int id)
{
string connectionString = ConfigurationManager.ConnectionStrings["HospitalConnectionString"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string query = "SELECT * FROM PatientDiseaseView WHERE Id='" + id + "'";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
List<Disease> diseaseList = new List<Disease>();
while (sqlDataReader.Read())
{
Disease disease = new Disease();
disease.Id = int.Parse(sqlDataReader["DiseaseId"].ToString());
disease.Name = sqlDataReader["DiseaseName"].ToString();
diseaseList.Add(disease);
}
return diseaseList;
}
