RudolphTable.cs

using System.Globalization;
using System.Text.RegularExpressions;
 
namespace Vereinsmeisterschaften.Core.Models
{
    public class RudolphTable
    {
        #region Constants
 
        public const string FEMALE_MARKER = "weiblich";
        public const string MALE_MARKER = "männlich";
        public const string AGE_MARKER = "Jahre";
        public const string AGE_MARKER_ALTERNATIVE = "Altersklasse";
        public const string OPEN_AGE_MARKER = "offen";
        public const string END_PAGE_MARKER = "Klaus Rudolph";
        public const string TIME_FORMAT_REGEX = @"\d{2}:\d{2},\d{2}";
        public const string TIME_FORMAT_STRING = @"mm\:ss\,ff";
        public const int NUMBER_TIME_COLUMNS_RUDOLPH_TABLE = 17;
        public static readonly List<SwimmingStyles> SWIMMINGSTYLES_PER_TIME_COLUMN = new List<SwimmingStyles>()
        {
            SwimmingStyles.Freestyle,
            SwimmingStyles.Freestyle,
            SwimmingStyles.Freestyle,
            SwimmingStyles.Freestyle,
            SwimmingStyles.Freestyle,
            SwimmingStyles.Freestyle,
            SwimmingStyles.Breaststroke,
            SwimmingStyles.Breaststroke,
            SwimmingStyles.Breaststroke,
            SwimmingStyles.Butterfly,
            SwimmingStyles.Butterfly,
            SwimmingStyles.Butterfly,
            SwimmingStyles.Backstroke,
            SwimmingStyles.Backstroke,
            SwimmingStyles.Backstroke,
            SwimmingStyles.Medley,
            SwimmingStyles.Medley
        };
        public static readonly List<ushort> DISTANCES_PER_TIME_COLUMN = new List<ushort>()
        {
            50,
            100,
            200,
            400,
            800,
            1500,
            50,
            100,
            200,
            50,
            100,
            200,
            50,
            100,
            200,
            200,
            400
        };
 
        #endregion
 
        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
        #region Properties

        public List<RudolphTableEntry> Entries { get; private set; }
 
        #endregion
 
        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 
        #region Constructors

        public RudolphTable()
        {
        }

        public RudolphTable(string csvFile)
        {
            ParseFromCsv(csvFile);
        }
 
        #endregion
 
        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

        public void ParseFromCsv(string csvFile)
        {
            Entries = new List<RudolphTableEntry>();
 
            using(StreamReader reader = new StreamReader(csvFile))
            {
                // Read the .csv content and split it to lines. Remove empty lines. Also remove " from the line entries.
                string csvContent = reader.ReadToEnd();
                List<string> csvLines = csvContent.Split("\n").Select(line => line.Replace("\"", "").Trim()).Where(line => !string.IsNullOrEmpty(line)).ToList();
 
                RudolphTableEntry baseEntry = new RudolphTableEntry();
                bool wasGenderOrAgeFound = false;
                bool collectRudolphScoreLines = false;
                string currentRudolphScoreTimesStr = "";
 
                foreach (string line in csvLines)
                {
                    // This is the line that contains the gender
                    if(line.Contains(FEMALE_MARKER) || line.Contains(MALE_MARKER))
                    {
                        baseEntry.Gender = line.Contains(FEMALE_MARKER) ? Genders.Female : Genders.Male;
                        wasGenderOrAgeFound = true;
                    }
                    // This is the line that contains the age
                    else if (line.Contains(AGE_MARKER) || line.Contains(AGE_MARKER_ALTERNATIVE))
                    {
                        string ageStr = "";
                        byte age = 0;
                        Match match = Regex.Match(line, $"(.*) {AGE_MARKER}");
                        Match matchAlternative = Regex.Match(line, $"{AGE_MARKER_ALTERNATIVE} (.*)");
                        if ((match.Success && match.Groups.Count >= 2) || (matchAlternative.Success && matchAlternative.Groups.Count >= 2))
                        {
                            ageStr = match.Success ? match.Groups[1].Value : matchAlternative.Groups[1].Value;
                            if(byte.TryParse(ageStr, out age))
                            {
                                baseEntry.Age = age;
                                wasGenderOrAgeFound = true;
                            }
                        }
                    }
                    // This is the line that contains the open age marker
                    else if (line.Contains(OPEN_AGE_MARKER))
                    {
                        baseEntry.Age = 0;
                        baseEntry.IsOpenAge = true;
                        wasGenderOrAgeFound = true;
                    }
                    // This is a line that contains the end page marker
                    else if(line.Contains(END_PAGE_MARKER))
                    {
                        baseEntry = new RudolphTableEntry() { Gender = baseEntry.Gender, RudolphScore = 0 };      // reuse last gender (if it's not contained on the page)
                        wasGenderOrAgeFound = false;
                    }
                    // This is a line that contains a rudolph score (only a single number between 1 and 20)
                    else if(line.Trim().Length <= 2 && wasGenderOrAgeFound)
                    {
                        byte score = 0;
                        if (byte.TryParse(line.Trim(), out score))
                        {
                            if(baseEntry.RudolphScore != score)
                            {
                                // start of block reached. Start collecting the time strings.
                                collectRudolphScoreLines = true;
                                baseEntry.RudolphScore = score;
                            }
                            else
                            {
                                // end of block reached. Parse the times.
                                collectRudolphScoreLines = false;
                                Entries.AddRange(parseEntriesFromRudolphScoreTimesStr(currentRudolphScoreTimesStr, baseEntry));
                                currentRudolphScoreTimesStr = "";
                            }
                        }
                    }
                    // This is a line that contains times for the current rudolph score
                    else if(collectRudolphScoreLines && wasGenderOrAgeFound)
                    {
                        currentRudolphScoreTimesStr += " " + line;
                    }
                }
            }
        }
 
        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

        private static List<RudolphTableEntry> parseEntriesFromRudolphScoreTimesStr(string rudolphScoreTimesStr, RudolphTableEntry baseEntry)
        {
            List<RudolphTableEntry> rudolphScoreEntries = new List<RudolphTableEntry>();
 
            MatchCollection timeMatches = Regex.Matches(rudolphScoreTimesStr, TIME_FORMAT_REGEX);
            if (timeMatches.Count != NUMBER_TIME_COLUMNS_RUDOLPH_TABLE)
            {
                throw new Exception("Error while parsing rudolph table: line encountered that contains a wrong number of times.");
            }
            int timeColumnIndex = 0;
            foreach (Match match in timeMatches)
            {
                RudolphTableEntry singleEntry = (RudolphTableEntry)baseEntry.Clone();
                TimeSpan time;
                if (TimeSpan.TryParseExact(match.Value, TIME_FORMAT_STRING, CultureInfo.InvariantCulture, out time))
                {
                    singleEntry.Time = time;
                    singleEntry.SwimmingStyle = SWIMMINGSTYLES_PER_TIME_COLUMN[timeColumnIndex];
                    singleEntry.Distance = DISTANCES_PER_TIME_COLUMN[timeColumnIndex];
                    rudolphScoreEntries.Add(singleEntry);
                }
                timeColumnIndex++;
            }
 
            return rudolphScoreEntries;
        }
 
        // ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

        public RudolphTableEntry GetEntryByParameters(Genders gender, byte age, SwimmingStyles swimmingStyle, ushort distance, byte rudolphScore)
        {
            List<RudolphTableEntry> entries = Entries.Where(e => e.Gender == gender && e.SwimmingStyle == swimmingStyle && e.Distance == distance && e.RudolphScore == rudolphScore).ToList();
            if(entries == null || entries.Count == 0) { return null; }
 
            byte maxAgeEntries = entries.Max(e => e.Age);
            if (age > maxAgeEntries)
            {
                return entries.FirstOrDefault(e => e.IsOpenAge);
            }
            else
            {
                return entries.FirstOrDefault(e => e.Age == age);
            }
        }
    }
}