using System;

​

// dbo.ScoreDetail Table

​

// ScoreDetail      | Type              | Nullable

// -----------------------------------------------

// Id               | int (identity)    | not null

// Name             | varchar(100)      | not null

// Score            | smallint          | null

// LastModifiedDate | date              | not null

​

​

public class PlayerScore

{

    public Guid Id { get; set; }    

    public string Name { get; set; }

    public int Score { get; set; }

    public DateTime? LastModifiedDate { get; set; }

}

​

public class ScoreService

{

    private readonly MyDbContext _context; //assume that the dbcontext already been defined properly

​

    public ScoreService(MyDbContext context)

    {

        _context = context;

    }

    //Part 1

    public void Upsert (PlayerScore playerScore)

    {

        /*

        This Api will be available in public. we need to add the following

        1. If the PlayerScore is not in the dbo.ScoreDetail then insert a new record 

        2. If the PlayerScore exist in the dbo.ScoreDetail

            2.1 if Score is different in dbo.ScoreDetail update the record with the current date

            2.2 if Score is same in dbo.ScoreDetail don't update anything

        */      

        var scoreDetail = _context.PlayerScore.Single(o => o.Id == playerScore.Id);

        if (scoreDetail != null)

        {

            if(scoreDetail.Score != playerScore.Score)

            {

                playerScore.LastModifiedDate = DateTime.Now;

            }

        }

        else

        {

            _context.PlayerScore.Add(playerScore);  

        }

        _context.Save();

    }

    //Part 2

    public void Test()

    {

        // Assume playerScores list already been defined which may contains data like below:

        // Id   | Name      | Score |

        // --------------------------

        // 1    | Alex      | 80    |

        // 2    | Anna      | 75    |

        // 3    | Ricky     | 89    |

        // 4    | Raymond   | 95    |

​

        // Write the code which will get the high score of the player   

        // Write the code which will return the second highest score of the player

​

        // Insert 10 records with incrementing scores using loop inside this method

        var highScore = _context.PlayerScore.Max(o => o.Score);

        for(int i = 1; i <= 11; i++){

            _context.PlayerScore.Add(new PlayerScore{

                Name = "Name " + i,

                Score = i,

                LastModifiedDate = DateTime.Now

            });

        }

    }

}