public void GetSpecialRequest(SpecialRequestsList list)
        {
            string q = "SELECT TOP 1";
            q += _selectColumnNames + "\n";
            q += "FROM SpecialRequests AS S\n";
            q += "WHERE DateResponded IS NULL\n";
            q += "ORDER BY DateRequested ASC";

            PopulateList(list, dataHelper.ExecuteQuery(dataHelper.CreateCommand(q)));
        }
Example #2
0
        private static bool GetSpecialRequest()
        {
            SpecialRequestsList specialRequestsList = new SpecialRequestsList();
            specialRequestsList.GetSpecialRequest();

            if (specialRequestsList.Count > 0)
            {
                bool olderMatchesToFind = true;
                do
                {
                    olderMatchesToFind = GetOlderMatchesPerPlayer(specialRequestsList[0].Player64);
                } while (olderMatchesToFind);
                return true;
            }
            else
            {
                return false;
            }
        }