//public DataTable uploadSystemUser()
//{
// Console.WriteLine("Database path: " + this.connectionString);
// DataTable systemUserTable = new DataTable();
// string queryTable = "SELECT * FROM SystemUsers";
// using (connection = new SqlConnection(connectionString))
// using (adapter = new SqlDataAdapter(queryTable, connection))
// {
// adapter.Fill(systemUserTable);
// //userList = systemUserTable;
// }
// return systemUserTable;
//}
///// <summary>
///// check if user with that name exists
///// </summary>
///// <param name="name"></param>
///// <returns>true if the user with that name exists</returns>
//public bool isUserExist(string name)
//{
// SqlConnection connection = new SqlConnection(connectionString);
// SqlCommand cmd = new SqlCommand();
// SqlDataReader reader;
// cmd.CommandText = "SELECT Id FROM SystemUsers WHERE UserName = @name LIMIT 1";
// cmd.CommandType = CommandType.Text;
// cmd.Connection = connection;
// cmd.Parameters.AddWithValue("@name", name);
// connection.Open();
// reader = cmd.ExecuteReader();
// bool ans = reader.HasRows;
// connection.Close();
// return ans;
//}
public List <object> getLeaderboardsByParam(string param)
{
IList <Database.Domain.SystemUser> list = systemUserRepository.GetByRestrictions(new Dictionary <string, string>(), param, false, 20);
var leaderBoardInfo = new List <object>();
foreach (Database.Domain.SystemUser user in list)
{
var newRow = new
{
highestCash = user.HighestCashInGame,
playerName = user.UserName,
totalGrossProfit = user.TotalGrossProfit,
gamesPlayed = user.GamesPlayed
};
leaderBoardInfo.Add(newRow);
}
return(leaderBoardInfo);
//SqlConnection connection = new SqlConnection(connectionString);
//SqlCommand cmd = new SqlCommand();
//SqlDataReader reader;
//cmd.CommandText = "SELECT highetsCashInAGame, userName, gamesPlayed, totalGrossProfit " +
// "FROM SystemUsers order by @param desc limit 20";
//cmd.CommandType = CommandType.Text;
//cmd.Connection = connection;
//cmd.Parameters.AddWithValue("@param", param);
//connection.Open();
//reader = cmd.ExecuteReader();
//var leaderBoardInfo = new List<object> ();
//while (reader.Read())
//{
// var newRow = new
// {
// highestCash = (int)reader["highetsCashInAGame"],
// playerName = (string)reader["userName"],
// totalGrossProfit = (int)reader["totalGrossProfit"],
// gamesPlayed = (int)reader["gamesPlayed"]
// };
// leaderBoardInfo.Add(newRow);
//}
//connection.Close();
//return leaderBoardInfo;
}
