/// <summary>
/// Return LeaderBoard for all Users with Scores
/// </summary>
/// <returns></returns>
public async System.Threading.Tasks.Task <IHttpActionResult> GetLeaderBoardAsync()
{
try
{
LeaderBoardRS response = new LeaderBoardRS();
response = await leaderBoardRepository.GetLeaderBoard();
if (response == null)
{
response.TransactionStatus = TransactionStatusHelper.CreateTransaction(HttpStatusCode.BadRequest.ToString(), internalError, EndTransactionType.Error, ErrorType.ProgrammerError);
}
return(Ok(response));
}
catch (Exception e)
{
Console.WriteLine("Exception source: {0}", e.Source);
return(null);
}
}
public async Task <LeaderBoardRS> GetLeaderBoardAsync()
{
LeaderBoardRS response = new LeaderBoardRS();
DataSet dataSet = new DataSet();
DataTable table = new DataTable();
SqlCommand cmd = await ExecuteProcdureAsync(connection, "Leaderboard");
sqlDataAdapter.SelectCommand = cmd;
sqlDataAdapter.Fill(dataSet);
table = dataSet.Tables[0];
foreach (DataRow row in table.Rows)
{
LeaderBoardItem leaderBoardItem = new LeaderBoardItem()
{
UserName = row.ItemArray[0].ToString().Trim(),
Score = Convert.ToInt32(row.ItemArray[1].ToString().Trim())
};
response.leaderBoardItems.Add(leaderBoardItem);
}
return(response);
}
