public BarChartMissingIssueCount GetBarChartData(List<int> publisherId)
{
BarChartMissingIssueCount barratios = new BarChartMissingIssueCount();
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("Marvel", 5638));
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("Atlas", 2235));
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("Timely", 1244));
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("Icon", 1508));
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("Amalgam", 1007));
barratios.MissingIssueCountList.Add(new KeyValuePair<string, int>("MAX", 500));
return barratios;
}
public BarChartMissingIssueCount GetBarChartData(List<int> publisherId)
{
BarChartMissingIssueCount barChartMissingIssueCount = new BarChartMissingIssueCount();
using (SqlConnection con = new SqlConnection(constring))
{
foreach (int id in publisherId)
{
try
{
SqlCommand missingCommand = new SqlCommand("select count(i.id) as count, p.name as publisher 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 i.collected = 0 group by p.name", con);
missingCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;
SqlDataAdapter missingad = new SqlDataAdapter(missingCommand);
DataSet missingds = new DataSet("issueMissingCount");
missingad.Fill(missingds);
if (missingds.Tables[0].Rows.Count != 0)
{
int iMissingIssueCount = 0;
Int32.TryParse(missingds.Tables[0].Rows[0]["count"].ToString(), out iMissingIssueCount);
string strPublisher = missingds.Tables[0].Rows[0]["publisher"].ToString();
barChartMissingIssueCount.MissingIssueCountList.Add(new KeyValuePair<string, int>(strPublisher, iMissingIssueCount));
}
}
catch (Exception ex)
{
string message = ex.Message;
}
}
}
return barChartMissingIssueCount;
}
