C#

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

public void btn_GetNewTVShowData_Click(object sender, EventArgs e)
{
    GetTMDB GetData = new GetTMDB();
    GetData.GetTvShowData();
}

DataClasses\Common\GetTMDB.cs
namespace WinFormsApp1.DataClasses.Common
{
    internal class GetTMDB
    {
        public async Task<string> GetTvShowData()
        {

 
            HttpClient client = new HttpClient();

            var content = await client.GetStringAsync("https://api.themoviedb.org/3/tv/136311?api_key=XXXXXXX&language=en-US");


            TVShow myDeserializedClass = JsonConvert.DeserializeObject<TVShow>(content);


            return object myDeserializedClass;  <-- Not working, I know

        }

        public class TVShow
        {
            public string backdrop_path { get; set; } = default!;
            public List<CreatedBy> created_by { get; set; } = default!;
            public string name { get; set; } = default!;
        }
		
		 public class CreatedBy
        {
            public int id { get; set; } = default!;
            public string credit_id { get; set; } = default!;
            public string name { get; set; } = default!;
            public int gender { get; set; } = default!;
            public string profile_path { get; set; } = default!;
        }
    }
}

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

using System.IO;
using System.Threading.Tasks;

namespace WpfApp1
{
    internal class Sharepoint
    {
        public async Task DownloadFileAsync(string folderName, string downloadPath = null)
        {
            var url = _clientContext.Web.ServerRelativeUrl + "/Shared%20Documents/" + folderName;
            Folder targetFolder = _clientContext.Web.GetFolderByServerRelativeUrl(url);
            _clientContext.Load(targetFolder.Files);

            await _clientContext.ExecuteQueryAsync();

            foreach (var file in targetFolder.Files)
            {
                FileInformation sharepointFile = Microsoft.SharePoint.Client.File.OpenBinaryDirect(_clientContext, file.ServerRelativeUrl);
                await _clientContext.ExecuteQueryAsync();

                var path = string.IsNullOrEmpty(downloadPath) ? DEFAULT_DIRECTORY : downloadPath;
                path = path + @"\" + file.Name;
                using (FileStream filestream = new FileStream(path, FileMode.Create))
                {
                    sharepointFile.Stream.CopyTo(filestream);
                }
            }
        }
    }
}

using System.IO;
using System.Threading.Tasks;

namespace WpfApp1
{
    internal class Repository
    {
        string _appPath;
        Sharepoint _sharePoint;

        public Repository()
        {
            _sharePoint = new Sharepoint();
            _appPath = $"{Path.GetTempPath()}RDSPaymentProcessing";

        }

        public async Task<MyData> GETDataAsync()
        {
            var results = new MyData();

            // If the local file already exists, delete it
            var fileName = $"{Path.GetTempPath()}{LOCAL_APP_DATA_FOLDER}\sharepointdata.xml";
            if (File.Exists(fileName))
            {
                File.Delete(fileName);
            }

            // Download all files from the Settings folder into the local user's app path
            await _sharePoint.DownloadFile(SETINGS_FOLDER, _appPath);

            // If the file was downloaded...
            if (File.Exists(fileName))
            {
                // Deserialize it
                results = Serialization.DeSerializeObject<MyData>(fileName);
            }
            else
            {
                //TODO: Replace with custom exception
                throw new FileNotFoundException(fileName);
            }

            return results;
        }
    }
}

namespace WpfApp1
{
    internal class MainWindowViewModel
    {
        private MyEntity _data;

        /// <summary>
        /// Occurs when the window's Loaded event is callled
        /// </summary>
        public async void WindowLoadedExecuted()
        {
            await _repository.GETDataAsync();
        }
    }
}