public List<Disease> GetAllDiseases() { List<Disease> diseaseList = new List<Disease>(); string query = "SELECT * FROM tbl_disease"; ASqlCommand = new SqlCommand(query, ASqlConnection); ASqlConnection.Open(); ASqlDataReader = ASqlCommand.ExecuteReader(); Disease aDisease; while (ASqlDataReader.Read()) { aDisease = new Disease(); aDisease.Id = (int)ASqlDataReader["id"]; aDisease.Name = ASqlDataReader["name"].ToString(); aDisease.Description = ASqlDataReader["description"].ToString(); aDisease.TreatmentProcedure = ASqlDataReader["treatment_procedure"].ToString(); aDisease.PreferredDrug = ASqlDataReader["preferred_drug"].ToString(); diseaseList.Add(aDisease); } ASqlDataReader.Close(); ASqlCommand.Dispose(); ASqlConnection.Close(); return diseaseList; }
public int Save(Disease aDisease) { string query = "INSERT INTO tbl_disease VALUES ('" + aDisease.Name + "','" + aDisease.Description + "','" + aDisease.TreatmentProcedure + "','" + aDisease.PreferredDrug + "')"; ASqlConnection.Open(); ASqlCommand = new SqlCommand(query, ASqlConnection); int rowAffected = ASqlCommand.ExecuteNonQuery(); ASqlConnection.Close(); return rowAffected; }
public int Save(Disease aDisease) { if (aDiseaseDbGateway.Find(aDisease.Name) == null) { return aDiseaseDbGateway.Save(aDisease); } else { return 0; } }
protected void saveButton_Click(object sender, EventArgs e) { Disease aDisease = new Disease(); aDisease.Name = nameTextBox.Text; aDisease.Description = descriptionTextBox.Text; aDisease.TreatmentProcedure = treatementProcedureTextBox.Text; aDisease.PreferredDrug = preferredDrugTextBox.Text; int rowAffected = aDiseaseManager.Save(aDisease); if (rowAffected > 0) { msgLabel.Text = "Disease Saved..."; } else { msgLabel.Text = "Error in saving or duplicate name of disease..."; } }
public Disease Find(string name) { string query = "SELECT * FROM tbl_disease WHERE name= '" + name + "' "; ASqlConnection.Open(); ASqlCommand = new SqlCommand(query, ASqlConnection); ASqlDataReader = ASqlCommand.ExecuteReader(); if (ASqlDataReader.HasRows) { ASqlDataReader.Read(); Disease aDisease = new Disease(); aDisease.Id = (int)ASqlDataReader["id"]; aDisease.Name = ASqlDataReader["name"].ToString(); ASqlDataReader.Close(); ASqlConnection.Close(); return aDisease; } else { ASqlDataReader.Close(); ASqlConnection.Close(); return null; } }