C#

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="winners.aspx.cs" Inherits="FrontPanel.winners" %>

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">

    <div class="container">
        <h4 class="paddingtb-15">Winner List </h4>
 

    <table class="table table-striped table-bordered"><tr>
        <th>Product Details</th>
                 <th>Amount</th>  
         <th>User Details</th>
                                                      </tr>
        <asp:ListView ID="ListView1" runat="server">
            <ItemTemplate>
                <tr>
                   
                   
                    <td style="width:600px">
                        <asp:Image ID="Image1" runat="server"  ImageUrl='<%#Eval("productimage") %>' Width="30px" />
                        <%#Eval("productname") %>
                  </td>
                    <td><%#Eval("winamount") %></td>
                           <td>  <asp:Image ID="Image2" runat="server"  ImageUrl='<%#Eval("userimage") %>' Width="30px" Height="30px" CssClass="img-circle" /><%#Eval("username") %> </td>
          
                </tr>








            </ItemTemplate>

        </asp:ListView>


    </table>   </div>
</asp:Content>

Apologies but this is going to be a "How to" question rather than a technical question. I am very new to C# and using Json. I have a CSV file as follows:

Edit - I did manage to find some code here - https://qawithexperts.com/article/c-sharp/convert-csv-to-json-in-c/465 - not sure if this is suitable for my goal as it seems to be a simple convert.

    Time	         Control_Code	Metric	Organisation	Value	DateTime
 

    2018-10-21T00:08:03 JKX           3721      AD450          20   2018-10-21T00:08:00
    2018-10-21T00:08:03 BHY           1234      HG650          88   2018-10-21T00:08:00
I need to produce multiple JSON output files from that csv in the following format example:

    {
        "Time":"2018-10-21T00:08:03",
        "Control_Code": "JKX",
        "metrics": [
            {
                "Metric": 3721,
                "Organisation":"AD450",
                "Value": 20,
                "Datetime":"2018-10-21T00:08:00"
            },
            {
                "Metric": 1234,
                "Organisation":"HG650",
                "value": 88,
                "datetime":"2018-10-21T00:08:00"
            }
            
        ]
    }

Now the extra problematic part on top of this is that there is a requirement where only one Control_Code may be used per Json.
Each Json generated must contain a single Control_Code and all related metric values in the metrics array. So the csv will need to be scanned for each different Control_Code and then produce an output for that specific Control_Code and then do the same for any subsequent Control_Codes.

So for example a different Json would be produced with a different Control_Code (from the same csv file) - Example (notice different Control_Code other values will of course change as well, but just providing an example).

    {
        "Time":"2018-10-21T00:08:03",
        "Control_Code": "BHY",
        "metrics": [
            {
                "Metric": 3721,
                "Organisation":"AD450",
                "Value": 20,
                "Datetime":"2018-10-21T00:08:00"
            },
            {
                "Metric": 1234,
                "Organisation":"HG650",
                "value": 88,
                "datetime":"2018-10-21T00:08:00"
            }
            
        ]
    }

Thanks for any advice/information in advance.

Severity	Code	Description	Project	File	Line	Suppression State
Error	CS1661	Cannot convert anonymous method to type 'EventHandler<ItemPropertyChangedEventArgs<clsChild>>' because the parameter types do not match the delegate parameter types	C-Sharp-Tests	C:\Users\Jeff\Documents\GitHub\C-Sharp-Tests\C-Sharp-Tests\C-Sharp-Tests\clsParent.cs	21	Active

using Countdown;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace C_Sharp_Tests
{
    internal class clsParent : INotifyPropertyChanged
    {
        public event PropertyChangedEventHandler PropertyChanged;

        private ItemObservableCollection<clsChild> _MyChildren;

        public clsParent()
        {
            _MyChildren = new ItemObservableCollection<clsChild>();
            this._MyChildren.ItemPropertyChanged += delegate (object sender, PropertyChangedEventArgs e)
            {
                if (string.Equals("IsChanged", e.PropertyName, StringComparison.Ordinal))
                {
                    this.RaisePropertyChanged("IsChanged");
                }
            };
        }
    }
}

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace C_Sharp_Tests
{
    internal class clsChild : INotifyPropertyChanged
    {
        

        public event PropertyChangedEventHandler PropertyChanged;

        public string name { get; set; }


    }
}

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Countdown
{
    /// <summary>
    /// You can use it like this:
    ///     var orders = new ItemObservableCollection<OrderViewModel>();
    ///     orders.CollectionChanged   += OnOrdersChanged;
    ///     orders.ItemPropertyChanged += OnOrderChanged;
    /// </summary>
    /// <typeparam name="T">The type</typeparam>
    public sealed class ItemObservableCollection<T> : ObservableCollection<T>
        where T : INotifyPropertyChanged
    {
        public event EventHandler<ItemPropertyChangedEventArgs<T>> ItemPropertyChanged;

        protected override void InsertItem(int index, T item)
        {
            base.InsertItem(index, item);
            item.PropertyChanged += item_PropertyChanged;
        }

        protected override void RemoveItem(int index)
        {
            var item = this[index];
            base.RemoveItem(index);
            item.PropertyChanged -= item_PropertyChanged;
        }

        protected override void ClearItems()
        {
            foreach (var item in this)
            {
                item.PropertyChanged -= item_PropertyChanged;
            }

            base.ClearItems();
        }

        protected override void SetItem(int index, T item)
        {
            var oldItem = this[index];
            oldItem.PropertyChanged -= item_PropertyChanged;
            base.SetItem(index, item);
            item.PropertyChanged += item_PropertyChanged;
        }

        private void item_PropertyChanged(object sender, PropertyChangedEventArgs e)
        {
            OnItemPropertyChanged((T)sender, e.PropertyName);
        }

        private void OnItemPropertyChanged(T item, string propertyName)
        {
            var handler = this.ItemPropertyChanged;

            if (handler != null)
            {
                handler(this, new ItemPropertyChangedEventArgs<T>(item, propertyName));
            }
        }
    }

    public sealed class ItemPropertyChangedEventArgs<T> : EventArgs
    {
        private readonly T _item;
        private readonly string _propertyName;

        public ItemPropertyChangedEventArgs(T item, string propertyName)
        {
            _item = item;
            _propertyName = propertyName;
        }

        public T Item
        {
            get { return _item; }
        }

        public string PropertyName
        {
            get { return _propertyName; }
        }
    }
}