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; }