aswi2021tri-musketyri-gitlab/Server/ServerApp/Parser/InputData/CsvDataLoader.cs @ 3729dcae

//
// Author: A. Konig
//

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>
    /// <author>A. Konig</author>
    class CsvDataLoader : IDataLoader
    {
        /// <summary> Culture info for parsing numbers </summary>
        static CultureInfo cultureInfo = new CultureInfo("de-DE");

        /// <summary>
        /// Load file into string
        /// </summary>
        /// <param name="path">Paht to file</param>
        /// <returns>Null if file does not exist, or file in string</returns>
        public string LoadPredictionFile(string path)
        {
            if (path == null || !File.Exists(path))
                return null;

            return File.ReadAllText(path);
        }

        /// <summary>
        /// Load csv file into array
        /// </summary>
        /// <param name="name">Path to file</param>
        /// <returns>Array with loaded data</returns>
        private string[] LoadCsv(string name)
        {
            if (!File.Exists(name))
                return null;

            string[] lines = File.ReadAllLines(name);
            return lines;
        }

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

            List<JisInstance> list = new List<JisInstance>();

            if (lines == null)
                return list;

            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');

                if (data.Length < 3)
                    continue;

                data[0] = data[0].Substring(1, data[0].Length - 2);
                data[1] = data[1].Substring(1, data[1].Length - 2);

                var dateTime = new DateTime();
                try
                {
                    dateTime = DateTime.ParseExact(data[1], "G", cultureInfo);
                }
                catch
                {
                    continue;
                }

                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 List<LogInInstance> LoadLoginFile(string pathToFile)
        {
            var lines = LoadCsv(pathToFile);
            if (lines == null)
                return null;

            List<LogInInstance> list = new List<LogInInstance>();

            if (lines == null)
                return list;

            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');

                if (data.Length < 9)
                    continue;

                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 = new DateTime();
                var startTime = new DateTime();
                var endTime = new DateTime();
                try
                {
                    dateTime = DateTime.ParseExact(data[0], "G", cultureInfo);
                    startTime = DateTime.ParseExact(data[3], "t", cultureInfo);
                    endTime = DateTime.ParseExact(data[4], "t", cultureInfo);
                }
                catch
                {
                    continue;
                }

                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 List<WeatherInstance> LoadWeatherFile(string pathToFile)
        {
            var lines = LoadCsv(pathToFile);
            if (lines == null)
                return null;

            List<WeatherInstance> list = new List<WeatherInstance>();

            if (lines == null)
                return list;

            for (int i = 0; i < lines.Length; i++)
            {
                var data = lines[i].Split(';');
                
                if (data.Length < 5)
                    continue;

                data[0] = data[0].Substring(1, data[0].Length - 2);

                var dateTime = new DateTime();
                try
                {
                    dateTime = DateTime.ParseExact(data[0], "G", cultureInfo);
                }
                catch
                {
                    continue;
                }
                
                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;
        }

    }
}