internal static Dictionary<int, ItemStatistics> GetMarketplaceCategoryStats(int categoryID) { Dictionary<int, ItemStatistics> stats = new Dictionary<int, ItemStatistics>(); using (SqlConnection connection = new SqlConnection(GraffitiConnString)) { using (SqlCommand command = new SqlCommand("dbo.marketplace_ItemStats_Get_ByCat", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@categoryID", SqlDbType.Int)).Value = categoryID; connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { ItemStatistics s = new ItemStatistics(); s.DownloadCount = Convert.ToInt32(reader["DownloadCount"]); int postID = Convert.ToInt32(reader["PostId"]); stats.Add(postID, s); } reader.Close(); } } return stats; }
internal static Dictionary <int, ItemStatistics> GetMarketplaceCategoryStats(int categoryID) { Dictionary <int, ItemStatistics> stats = new Dictionary <int, ItemStatistics>(); using (SqlConnection connection = new SqlConnection(GraffitiConnString)) { using (SqlCommand command = new SqlCommand("dbo.marketplace_ItemStats_Get_ByCat", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@categoryID", SqlDbType.Int)).Value = categoryID; connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { ItemStatistics s = new ItemStatistics(); s.DownloadCount = Convert.ToInt32(reader["DownloadCount"]); int postID = Convert.ToInt32(reader["PostId"]); stats.Add(postID, s); } reader.Close(); } } return(stats); }
internal static ItemStatistics GetMarketplacePostStats(int postID) { ItemStatistics stats = new ItemStatistics(); using (SqlConnection connection = new SqlConnection(GraffitiConnString)) { using (SqlCommand command = new SqlCommand("dbo.marketplace_ItemStats_Get_ByPost", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@postId", SqlDbType.Int)).Value = postID; connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { stats.DownloadCount = Convert.ToInt32(reader["DownloadCount"]); } reader.Close(); } } return stats; }
internal static ItemStatistics GetMarketplacePostStats(int postID) { ItemStatistics stats = new ItemStatistics(); using (SqlConnection connection = new SqlConnection(GraffitiConnString)) { using (SqlCommand command = new SqlCommand("dbo.marketplace_ItemStats_Get_ByPost", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@postId", SqlDbType.Int)).Value = postID; connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { stats.DownloadCount = Convert.ToInt32(reader["DownloadCount"]); } reader.Close(); } } return(stats); }