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