public PieChartMissingIssueRatio GetPieChartData(int publisherId)
{
PieChartMissingIssueRatio ratios = new PieChartMissingIssueRatio();
ratios.MissingIssueRatioList.Add(new KeyValuePair<string, int>("Collected", 2));
ratios.MissingIssueRatioList.Add(new KeyValuePair<string, int>("Missing", 4));
return ratios;
}
public PieChartMissingIssueRatio GetPieChartData(int publisherId)
{
PieChartMissingIssueRatio pieChartData = new PieChartMissingIssueRatio();
using (SqlConnection con = new SqlConnection(constring))
{
int issueCount = 0;
int missingIssueCount = 0;
SqlCommand command = new SqlCommand("select count(i.id) as count from issue i join volume v on i.volume_id = v.id join publisher p on p.id = v.publisher_id where p.id = @id and v.collectable = 1 and i.collected = 1", con);
command.Parameters.Add("@id", SqlDbType.Int).Value = publisherId;
SqlDataAdapter ad = new SqlDataAdapter(command);
DataSet ds = new DataSet("issueCount");
ad.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
string strIssueCount = ds.Tables[0].Rows[0]["count"].ToString();
issueCount = 0;
Int32.TryParse(strIssueCount, out issueCount);
}
SqlCommand missingCommand = new SqlCommand("select count(i.id) as count from issue i join volume v on i.volume_id = v.id join publisher p on p.id = v.publisher_id where p.id = @id and v.collectable = 1 and i.collected = 0", con);
missingCommand.Parameters.Add("@id", SqlDbType.Int).Value = publisherId;
SqlDataAdapter missingad = new SqlDataAdapter(missingCommand);
DataSet missingds = new DataSet("issueMissingCount");
missingad.Fill(missingds);
if (missingds.Tables[0].Rows.Count != 0)
{
string strMissingIssueCount = missingds.Tables[0].Rows[0]["count"].ToString();
missingIssueCount = 0;
Int32.TryParse(strMissingIssueCount, out missingIssueCount);
}
pieChartData.MissingIssueRatioList.Add(new KeyValuePair<string, int>("Collected", issueCount));
pieChartData.MissingIssueRatioList.Add(new KeyValuePair<string, int>("Missing", missingIssueCount));
}
return pieChartData;
//TODO Test GetPieChartData
}
