using System;

using System.Collections.Generic;

using System.Linq;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

public class Program

{

    public static void Main()

    {

        int maxCountFromMapTable = 10;

        int boxScoreTotalCount = 0;

        List<BoxScores> boxScores = new List<BoxScores>();

        boxScores.Add(new BoxScores { GameID = "1", Points = 1 });

        boxScores.Add(new BoxScores { GameID = "2", Points = 2 });

        boxScores.Add(new BoxScores { GameID = "3", Points = 3 });

        boxScores.Add(new BoxScores { GameID = "4", Points = 4 });

        boxScores.Add(new BoxScores { GameID = "5", Points = 5 });

​

        //get only boxscores that are greater than maxCountFromMapTable

        var filteredBoxScores = boxScores.SkipWhile(b => (boxScoreTotalCount += Convert.ToInt32(b["PTS"])) <= maxCountFromMapTable);

        string[] gameIDs = filteredBoxScores.Select(f => f.GameID).ToArray();

        int startRunningCount = maxCountFromMapTable;

        // What should filterBoxScores.Count be at this point?

        foreach (var boxScore in filteredBoxScores)

        {

            Console.WriteLine("filterBoxScores.Count: " + filteredBoxScores.Count() + ", StartRunningCount:" + startRunningCount);

            startRunningCount += Convert.ToInt32(boxScore["PTS"]);

        }

    }

    [Table("Box_Scores")]

    public class BoxScores

    {

        [Column("Game_id")]

        public string GameID { get; set; }

​

        [Column("Person_id")]

        public int PersonID { get; set; }

​

        [Column("Team_id")]

        public int TeamID { get; set; }

​

        [Column("First_Name")]

        public string FirstName { get; set; }

​

        [Column("Last_Name")]

        public string LastName { get; set; }

​

        [Display(Name = "MIN")]

        [Column("minutes")]

        public short Minutes { get; set; }

​

        [Display(Name = "FGM")]

        [Column("Field_Goals")]

        public int? FieldGoals { get; set; }

​

        [Display(Name = "FGA")]

        [Column("Field_Goals_Attempted")]

        public int? FieldGoalsAttempted { get; set; }

​

        [Display(Name = "FG_PCT")]

        [Column("Field_Goal_Percentage")]

        public decimal? FieldGoalPercentage { get; set; }

​

        [Display(Name = "FG3M")]

        [Column("Three_Pointers")]

        public int? ThreePointers { get; set; }

​

        [Display(Name = "FG3A")]

        [Column("Three_Pointers_Attempted")]

        public int? ThreePointersAttempted { get; set; }

​

        [Column("Three_Point_Percentage")]

        public decimal? ThreePointPercentage { get; set; }

​

        [Display(Name = "FTM")]

        [Column("Free_Throws")]

        public int? FreeThrows { get; set; }

​

        [Display(Name = "FTA")]

        [Column("Free_Throws_Attempted")]

        public int? FreeThrowsAttempted { get; set; }

​

        [Display(Name = "FT_PCT")]

        [Column("Free_Throw_Percentage")]

        public decimal? FreeThrowPercentage { get; set; }

​

        [Display(Name = "OREB")]

        [Column("Offensive_Rebounds")]

        public int? OffensiveRebounds { get; set; }

​

        [Display(Name = "DREB")]

        [Column("Defensive_Rebounds")]

        public int? DefensiveRebounds { get; set; }

​

        [Display(Name = "AST")]

        [Column("Assists")]

        public int? Assists { get; set; }

​

        [Display(Name = "PF")]

        [Column("Personal_Fouls")]

        public int? PersonalFouls { get; set; }

​

        [Display(Name = "STL")]

        [Column("Steals")]

        public int? Steals { get; set; }

​

        [Display(Name = "TOV")]

        [Column("Turnovers")]

        public int? Turnovers { get; set; }

​

        [Display(Name = "BLK")]

        [Column("Blocked_Shots")]

        public int? BlockedShots { get; set; }

​

        [Display(Name = "PTS")]

        [Column("Points")]

        public int? Points { get; set; }

​

        [Column("date_est")]

        public DateTime? DateEst { get; set; }

​

        [Column("location")]

        public string Location { get; set; }

​

        [Column("grouping")]

        public string Grouping { get; set; }

​

        [Column("outcome")]

        public string Outcome { get; set; }

​

        [Column("season_id")]

        public string SeasonID { get; set; }

​

        [Column("vs_team_id")]

        public int VsTeamID { get; set; }

​

        [Column("league_id")]

        public string LeagueID { get; set; }

​

        [Column("Technical_Fouls")]

        public int? TechnicalFouls { get; set; }

​

        [Column("Flagrant_Fouls")]

        public int? Flagrant_Fouls { get; set; }

​

        [Column("Ejections")]

        public int? Ejections { get; set; }

​

        [Column("Points_In_Paint")]

        public int? Points_In_Paint { get; set; }

​

        [Column("Fast_Break_Points")]

        public int? Fast_Break_Points { get; set; }

​

        [Column("Triple_Doubles")]

        public int? Triple_Doubles { get; set; }

​

        [Column("Double_Doubles")]

        public int? Double_Doubles { get; set; }

​

        [Column("actual_minutes")]

        public int? actual_minutes { get; set; }

​

        [Column("actual_seconds")]

        public int? actual_seconds { get; set; }

​

        [Column("Plus_Minus")]

        public int? Plus_Minus { get; set; }

​

        [Column("Blocks_Against")]

        public int? Blocks_Against { get; set; }

​

        [Column("PTS_OFF_TO")]

        public short? PTS_OFF_TO { get; set; }

​

        [Column("Second_Chance_PTS")]

        public short? Second_Chance_PTS { get; set; }

​

        [Display(Name = "REB")]

        [Column("Total_Rebounds")]

        public int? Total_Rebounds { get; set; }

​

​

        /// <summary>

        /// Return property value by display name attribute via indexed property

        /// </summary>

        public object this[string displayName]

        {

            get

            {

                var propertiesWithDisplayAttribute = GetType().GetProperties().Where(x => x.GetCustomAttributes(typeof(DisplayAttribute), true).Any());

​

                foreach (var property in propertiesWithDisplayAttribute)

                {

                    var att = property.GetCustomAttributes(typeof(DisplayAttribute), true).FirstOrDefault() as DisplayAttribute;

                    if (att.Name == displayName)

                    {

                        return property.GetValue(this, null);

                    }

                }

​

                return null;

            }

        }

    }

}