// Return list of players for admin operations
internal static List <ClsScoreList> GetPalyerListForAdmin()
{
DataSet dataset = ClsConnectDbGetData.ExecuteProcedure("GetPlayerListForAdmin()", null);
if (dataset == null)
{
return(null);
}
List <ClsScoreList> scoreList = new List <ClsScoreList>();
DataRowCollection rowCollection = dataset.Tables[0].Rows;
if (rowCollection.Count == 0)
{
return(scoreList);
}
foreach (DataRow dataRow in rowCollection)
{
ClsScoreList scoreEntry = new ClsScoreList();
scoreEntry.Username = dataRow.ItemArray[0].ToString();
scoreEntry.HighScore = Convert.ToInt32(dataRow.ItemArray[1].ToString());
scoreEntry.AccountStatus = dataRow.ItemArray[2].ToString();
scoreList.Add(scoreEntry);
}
return(scoreList);
}
// Returns the score list of live game
internal static List <ClsScoreList> GetGameRoomScoreList(int gameId)
{
List <ClsScoreList> scoreList = new List <ClsScoreList>();
List <MySqlParameter> parameterList = new List <MySqlParameter>();
MySqlParameter gameIdParam = new MySqlParameter("@gameId", MySqlDbType.Int32);
gameIdParam.Value = gameId;
parameterList.Add(gameIdParam);
DataSet dataset = ClsConnectDbGetData.ExecuteProcedure("GetGameRoomScoreList(@gameId)", parameterList);
if (dataset == null)
{
return(scoreList);
}
DataRowCollection rowCollection = dataset.Tables[0].Rows;
if (rowCollection.Count == 0)
{
return(scoreList);
}
foreach (DataRow dataRow in rowCollection)
{
ClsScoreList scoreEntry = new ClsScoreList();
scoreEntry.Username = dataRow.ItemArray[0].ToString();
scoreEntry.HighScore = Convert.ToInt32(dataRow.ItemArray[1].ToString());
scoreEntry.UserTurn = dataRow.ItemArray[2].ToString();
scoreList.Add(scoreEntry);
}
return(scoreList);
}