aswi2021tri-musketyri-gitlab/Server/ServerApp/Parser/InputData/CsvDataLoader.cs @ 1db865ce

using System;
using System.Collections.Generic;
using System.Globalization;
using System.IO;

namespace ServerApp.Parser.InputData
{
    /// <summary>
    /// Class responsible for loading data from file
    /// </summary>
    static class CsvDataLoader
    {
        /// <summary> Culture info for parsing numbers </summary>
        static CultureInfo cultureInfo = new CultureInfo("de-DE");

        /// <summary>
        /// Load csv file into array
        /// </summary>
        /// <param name="name">Path to file</param>
        /// <returns>Array with loaded data</returns>
        static string[] LoadCsv(string name)
        {
            string[] lines = File.ReadAllLines(name);
            return lines;
        }

        /// <summary>
        /// Load jis data from file
        /// </summary>
        /// <param name="pathToFile">Path to file</param>
        /// <returns></returns>
        public static List<JisInstance> LoadJisFile(string pathToFile)
        {
            var lines = LoadCsv(pathToFile);
            List<JisInstance> list = new List<JisInstance>();

            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');
                data[0] = data[0].Substring(1, data[0].Length - 2);
                data[1] = data[1].Substring(1, data[1].Length - 2);
                
                var dateTime = DateTime.ParseExact(data[1], "G", cultureInfo);

                int amount = 0;
                int.TryParse(data[2], out amount);

                JisInstance inst = new JisInstance(data[0], dateTime, amount);
                list.Add(inst);
            }

            return list;
        }

        /// <summary>
        /// Load login data from file
        /// </summary>
        /// <param name="pathToFile">Path to file</param>
        /// <returns></returns>
        public static List<LogInInstance> LoadLoginFile(string pathToFile)
        {
            var lines = LoadCsv(pathToFile);
            List<LogInInstance> list = new List<LogInInstance>();

            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');
                data[0] = data[0].Substring(1, data[0].Length - 2);
                data[3] = data[3].Substring(1, data[3].Length - 2);
                data[4] = data[4].Substring(1, data[4].Length - 2);
                data[5] = data[5].Substring(1, data[5].Length - 2);
                data[6] = data[6].Substring(1, data[6].Length - 2);
                data[7] = data[7].Substring(1, data[7].Length - 2);
                data[8] = data[8].Substring(1, data[8].Length - 2);

                var dateTime = DateTime.ParseExact(data[0], "G", cultureInfo);
                var startTime = DateTime.ParseExact(data[3], "t", cultureInfo);
                var endTime = DateTime.ParseExact(data[4], "t", cultureInfo);

                int count = 0;
                int.TryParse(data[1], out count);

                int lesson = 0;
                int.TryParse(data[2], out lesson);

                LogInInstance inst = new LogInInstance(dateTime, count, lesson, startTime, endTime, data[5], data[6], data[7], data[8]);
                list.Add(inst);
            }

            return list;
        }

        /// <summary>
        /// Load weather data from file
        /// </summary>
        /// <param name="pathToFile">Path to file</param>
        /// <returns></returns>
        public static List<WeatherInstance> LoadWeatherFile(string pathToFile)
        {
            var lines = LoadCsv(pathToFile);
            
            List<WeatherInstance> list = new List<WeatherInstance>();
            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');
                data[0] = data[0].Substring(1, data[0].Length - 2);
                
                var dateTime = DateTime.ParseExact(data[0], "G", cultureInfo);
                
                double temp = 0;
                double.TryParse(data[1], out temp);
                
                double wind = 0;
                double.TryParse(data[2], out wind);
                
                int rain = 0;
                int.TryParse(data[3], out rain);
                
                double lum = 0;
                double.TryParse(data[4], out lum);

                WeatherInstance inst = new WeatherInstance(dateTime, temp, wind, rain, lum);
                list.Add(inst);
            }

            return list;
        }

    }
}