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