public List <CancerCase> GetPatientCountForCancerType()
{
if (!IsConnectionAlive())
{
OpenConnection();
}
var result = new List <CancerCase>();
using (OracleDataAdapter adapter = new OracleDataAdapter(Queries.PatientCountByCancerType, connection))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
var cancerCase = new CancerCase
{
CancerType = dr["site_name"].ToString(),
TotalCases = long.Parse(dr["NoOfPatients"].ToString())
};
result.Add(cancerCase);
}
}
return(result);
}
public List <CancerCase> GetOriginByCancerType()
{
if (!IsConnectionAlive())
{
OpenConnection();
}
var result = new List <CancerCase>();
using (OracleDataAdapter adapter = new OracleDataAdapter(Queries.CommonOriginByCancerType, connection))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
var cancerCase = new CancerCase
{
CancerType = dr["CancerType"].ToString(),
Origin = dr["Origin"].ToString(),
TotalCases = long.Parse(dr["Count"].ToString())
};
result.Add(cancerCase);
}
}
return(result);
}
public List <CancerCase> GetSurvivalRateAfterSurgery()
{
if (!IsConnectionAlive())
{
OpenConnection();
}
var result = new List <CancerCase>();
using (OracleDataAdapter adapter = new OracleDataAdapter(Queries.SurvivalRateQuery, connection))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
var cancerCase = new CancerCase
{
CancerType = dr["CancerType1"].ToString(),
PercentOfPeopleAlive = dr["PercentageOfAlive"].ToString()
};
result.Add(cancerCase);
}
}
return(result);
}
public List <CancerCase> GetCancerDeaths()
{
if (!IsConnectionAlive())
{
OpenConnection();
}
var result = new List <CancerCase>();
using (OracleDataAdapter adapter = new OracleDataAdapter(Queries.CancerDeathsQuerie, connection))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
CancerCase cancerCase = new CancerCase
{
CancerType = dr["CancerType"].ToString(),
TotalDeaths = long.Parse(dr["TotalDeaths"].ToString())
};
result.Add(cancerCase);
}
}
long otherCount = 0;
for (var i = 4; i < result.Count; i++)
{
otherCount += result[i].TotalDeaths;
}
result.RemoveRange(4, result.Count - 4);
result.Add(new CancerCase {
CancerType = "Other", TotalDeaths = otherCount
});
return(result);
}
