protected void saveDiseasesButton_Click(object sender, EventArgs e) { Diseases aDiseases = new Diseases(); aDiseases.Name = diseasesNameTextBox.Text; aDiseases.Discription = discriptionTextBox.Text; aDiseases.TreatmentProcedure = treatmentProcedureTextBox.Text; int message = diseasesManager.SaveDiseases(aDiseases); if (message > 0) { messageLabel.Text = "Successfully Saved"; messageLabel.ForeColor = Color.Green; LoadAllDiseases(); } else if (message == 0) { messageLabel.Text = "This Diseases name alresdy saved"; messageLabel.ForeColor = Color.Red; } else { messageLabel.Text = "Saved Failed"; messageLabel.ForeColor = Color.Red; } }
public bool SaveDiseases(Diseases aDiseases) { string saveMedicine = "INSERT INTO tbl_diseases (DiseasesName,Description,TreatmentProc) VALUES(@name,@discription,@treatmentProc)"; sqlConnection.Open(); sqlCommand.CommandText = saveMedicine; sqlCommand.Parameters.AddWithValue("@name", aDiseases.Name); sqlCommand.Parameters.AddWithValue("@discription", aDiseases.Discription); sqlCommand.Parameters.AddWithValue("@treatmentProc", aDiseases.TreatmentProcedure); int rowAffected = sqlCommand.ExecuteNonQuery(); sqlConnection.Close(); if (rowAffected > 0) { return true; } return false; }
public int SaveDiseases(Diseases aDiseases) { if (diseasesGateway.IsThisDiseasesNameExists(aDiseases.Name)) { return 0; } else { if (diseasesGateway.SaveDiseases(aDiseases)) { return 1; } else { return 2; } } }
public List<Diseases> GetAllDiseases() { string searchMedicine = "SELECT * FROM tbl_diseases ORDER BY DiseasesName ASC"; sqlConnection.Open(); sqlCommand.CommandText = searchMedicine; SqlDataReader reader = sqlCommand.ExecuteReader(); List<Diseases> diseasesList = new List<Diseases>(); while (reader.Read()) { Diseases aDiseases = new Diseases(); aDiseases.Id = (int) reader["id"]; aDiseases.Name = reader["DiseasesName"].ToString(); aDiseases.Discription = reader["Description"].ToString(); aDiseases.TreatmentProcedure = reader["TreatmentProc"].ToString(); diseasesList.Add(aDiseases); } reader.Close(); sqlConnection.Close(); return diseasesList; }