public List<Disease> LoadAllDiseasesName()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_Disease_Entry";
SqlCommand command = new SqlCommand(query, connection);
List<Disease> diseaseEntryList = new List<Disease>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
int serial = 1;
while (reader.Read())
{
Disease aDisease=new Disease();
aDisease.id = serial;
aDisease.diseaseName = reader["DiseaseName"].ToString();
aDisease.diseaseDescription = reader["DiseaseDescription"].ToString();
aDisease.diseaseTreatment = reader["DiseaseTreatment"].ToString();
aDisease.diseaseProcedure = reader["DiseaseProcedure"].ToString();
diseaseEntryList.Add(aDisease);
serial++;
}
reader.Close();
connection.Close();
return diseaseEntryList;
}
public int saveDiseaseEntry(Disease aDisease)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "insert into tbl_Disease_Entry values('" + aDisease.diseaseName + "','"+aDisease.diseaseDescription+"','"+aDisease.diseaseTreatment+"','"+aDisease.diseaseProcedure+"')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return rowAffected;
}
public string SavediseaseEntry(Disease aDisease)
{
if (aDiseaseEntryGateway.IsDiseaseNameExists(aDisease))
{
return "Disease Name Already Exists";
}
else if (aDiseaseEntryGateway.saveDiseaseEntry(aDisease) > 0)
{
return "Disease Name Saved Successfully";
}
else
{
return "Disease name Not Saved Correctly";
}
}
public bool IsDiseaseNameExists(Disease aDisease)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_Disease_Entry WHERE DiseaseName='" + aDisease.diseaseName + "'";
SqlCommand command = new SqlCommand(query, connection);
bool isDiseaseNameExists = false;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
isDiseaseNameExists = true;
}
reader.Close();
connection.Close();
return isDiseaseNameExists;
}
public List<Disease> LoaDiseases()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "select * from tbl_Disease_Entry";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
List<Disease> diseaseList = new List<Disease>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Disease aDisease = new Disease();
aDisease.id = int.Parse(reader["ID"].ToString());
aDisease.diseaseName = reader["DiseaseName"].ToString();
diseaseList.Add(aDisease);
}
reader.Close();
connection.Close();
return diseaseList;
}
