using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

​

        var gName = GetTotalPoints();

​

        gName.Dump();

    }

    public static List<Feedback> GetCalculatedFeedback()

    {

           string input = "";

            { input = @"[   

    {

        ""Name"": ""Foo"",

        ""Date"": ""02.07.2019 00:00:00"",

        ""FeedbackType"": ""Very Negative"",

        ""Count"": 3

    },

    {

        ""Name"": ""Foo"",

        ""Date"": ""02.07.2019 00:00:00"",

        ""FeedbackType"": ""Negative"",

        ""Count"": 1

    },

    {

        ""Name"": ""Foo"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Positive"",

        ""Count"": 9

    },

    {

        ""Name"": ""Foo"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Very Positive"",

        ""Count"": 7

    },

​

    {

        ""Name"": ""Bar"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Very Negative"",

        ""Count"": 3

    },

    {

        ""Name"": ""Bar"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Negative"",

        ""Count"": 1

    },

    {

        ""Name"": ""Bar"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Positive"",

        ""Count"": 9

    },

    {

        ""Name"": ""Bar"",

        ""Date"": ""01.07.2019 00:00:00"",

        ""FeedbackType"": ""Very Positive"",

        ""Count"": 1

    }

]"; }

​

        return JsonConvert.DeserializeObject<List<Feedback>>(input);

    }

    public static List<FeedbackSummary> GetTotalPoints(){       

        var data = GetCalculatedFeedback();

        var feedbackValue = new string[] { "Very Negative", "Negative", "Positive", "Very Positive" };

​

​

        var gName = 

            data.GroupBy(x => new {x.Name, x.Date})

                .Select(gN => new FeedbackSummary // <- 1/. Type match the Funct return type

                        {

                            StationName = gN.Key.Name,

                            TotalScore = gN.Sum(x =>x.Count * Array.IndexOf(feedbackValue, x.FeedbackType)),

                            VotesCount = gN.Sum(x =>x.Count),

                            Date = gN.Key.Date

                        })

                .ToList(); // <- 2/. Force the result to be a list as expected.

        //Let's math the percent thing:

        // A/. If there is 10 different type of feed back, they will be store in an array (index going from 0 to 9).

        //     The last index will be the size of the array - 1. 

        foreach(var station in gName){

            var bestPossibleScore = station.VotesCount*(feedbackValue.Count()-1);

            station.PercentScore = (decimal)station.TotalScore / bestPossibleScore * 100;

        }

        return gName;

    }

    public class FeedbackSummary{

        public string StationName { get; set; }

        public int TotalScore { get; set; }

        public int VotesCount { get; set; }

        public decimal PercentScore { get; set; } 

        public DateTime Date {get;set;}

        // Using decimal to not loose information because of rounding,

        // you will round up or use  decimal to string format to display the correct value. 

    }

    public class Feedback

    {

        public string Name { get; set; }

        public DateTime Date { get; set; }

        public string FeedbackType { get; set; }

        public int Count { get; set; }

    }

}