/// <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); }