Beispiel #1
0
        private void DeleteGroup2(string sGroupGuid)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API04_DELETE_GROUP;

            aParamData[0] = sGroupGuid;
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                InfoMessage = "";
            }
            else
            {
                ErrorMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
Beispiel #2
0
        private ChatDM GetSingleChatItem2(ChatDM chatItem)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            aParamData[0] = chatItem.ChatGUID;
            int iAPINumber = c.API06_GET_SINGLE_MESSAGE;

            sAPIInput = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return(chatItem);
            }
            ds1 = oAPI.DatasetReturned;

            if (!m.EmptyTable(ds1))
            {
                chatItem.DisplayLine     = m.GetFieldStr("Message", ds1);
                chatItem.IPAddress       = m.GetFieldStr("IPAddress", ds1);
                chatItem.DateTimeEntered = m.GetFieldDate("DateTimeEntered", ds1);
            }

            return(chatItem);
        }
Beispiel #3
0
        private void UpdateTTPlaye2(TeeTimeItem TT)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API03_UPDATE_TT_PLAYER;

            aParamData[0] = JsonSerializer.Serialize <TeeTimeItem>(TT);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                InfoMessage = "";
            }
            else
            {
                ErrorMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
Beispiel #4
0
        private void AddGroup2(GroupItemDM groupItem)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API04_ADD_GROUP;

            aParamData[0] = JsonSerializer.Serialize <GroupItemDM>(groupItem);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                InfoMessage = "";
            }
            else
            {
                groupItem.ValidationFailMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
        private void UpdateSettings2(SettingsDM setting)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API05_UPDATE_SETTINGS;

            aParamData[0] = JsonSerializer.Serialize <SettingsDM>(setting);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                InfoMessage = "Settings updated.";
            }
            else
            {
                ErrorMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
Beispiel #6
0
        private void GetSingleTeeTime2(TeeTimeItem ttItem)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API01_GET_SINGLE_TEETIME;

            aParamData[0] = ttItem.TTGUID;
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.EmptyTable(ds1))
            {
                ErrorMessage = "Error. TeeTime not found. (" + ttItem.TTGUID + ")";
                return;
            }

            ttItem.TTGUID         = m.GetFieldStr("TeeTimeGUID", ds1);
            ttItem.GroupGUID      = m.GetFieldStr("GroupGUID", ds1);
            ttItem.GroupName      = m.GetFieldStr("GroupName", ds1);
            ttItem.TTDate         = m.GetFieldDate("TeeTimeDate", ds1);
            ttItem.TTTime         = m.GetFieldDate("TeeTimeTime", ds1);
            ttItem.TTDateFormated = m.GetFieldDateF("TeeTimeDate", ds1, c.DATE_FORMAT20);
            ttItem.TTTimeFormated = m.GetFieldDateF("TeeTimeTime", ds1, c.DATE_FORMAT10);
            ttItem.DaysFromNow    = m.DaysFromNow(m.GetFieldDate("TeeTimeDate", ds1));
            ttItem.Owner          = m.GetFieldStr("TeeTimeOwner", ds1);
            ttItem.OwnerComment   = m.GetFieldStr("OwnerComment", ds1);
            ttItem.Location       = m.GetFieldStr("TeeTimeLocation", ds1);
            ttItem.Player1        = m.GetFieldStr("Player1", ds1);
            ttItem.Player2        = m.GetFieldStr("Player2", ds1);
            ttItem.Player3        = m.GetFieldStr("Player3", ds1);
            ttItem.Player4        = m.GetFieldStr("Player4", ds1);
            ttItem.Player1Comment = m.GetFieldStr("Player1", ds1);
            ttItem.Player2Comment = m.GetFieldStr("Player2", ds1);
            ttItem.Player3Comment = m.GetFieldStr("Player3", ds1);
            ttItem.Player4Comment = m.GetFieldStr("Player4", ds1);
            ttItem.WaitList1      = m.GetFieldStr("WaitList1", ds1);
            ttItem.WaitList2      = m.GetFieldStr("WaitList2", ds1);
            ttItem.WaitList3      = m.GetFieldStr("WaitList3", ds1);
            ttItem.IsDeleted      = m.GetFieldBol("IsDeleted", ds1);
            ttItem.LockPlayer1    = m.GetFieldBol("LockPlayer1", ds1);
            ttItem.LockPlayer2    = m.GetFieldBol("LockPlayer2", ds1);
            ttItem.LockPlayer3    = m.GetFieldBol("LockPlayer3", ds1);
            ttItem.LockPlayer4    = m.GetFieldBol("LockPlayer4", ds1);
            ttItem.HideMessages   = m.GetFieldBol("HideMessages", ds1);
            ttItem.LockMessages   = m.GetFieldBol("LockMessages", ds1);
        }
Beispiel #7
0
        protected override void OnStartup(StartupEventArgs e)
        {
            base.OnStartup(e);

            var apiRunner = new APIRunner();
            var apiThread = new Thread(new ThreadStart(apiRunner.Run));

            apiThread.Start();
        }
Beispiel #8
0
        public BaseAgent(Connection conn, string botType)
        {
            this.conn   = conn;
            this.runner = new APIRunner(conn);

            var id = Thread.CurrentThread.ManagedThreadId;

            uuid     = $"bot-{botType}-{id}";
            nickname = $"bot-{botType}-{id}";
        }
        private void ReadSettings2(SettingsDM setting)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API05_READ_SETTINGS;

            aParamData[0] = "";
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.EmptyTable(ds1))
            {
                ErrorMessage = "Settings table has no rows";
                return;
            }

            setting.SystemCustomCodes = m.GetFieldStr("SystemCustomCodes", ds1);
            setting.PinNumber1        = m.GetFieldStr("PinNumber1", ds1);
            setting.PinNumber2        = m.GetFieldStr("PinNumber2", ds1);
            setting.PinNumber3        = m.GetFieldStr("PinNumber3", ds1);
            setting.IncludeSecretInfoInErrMsgToUser = m.GetFieldBol("IncludeSecretInfoInErrMsgToUser", ds1);
            setting.CopywriteNotice = m.GetFieldStr("CopywriteNotice", ds1);
            setting.ProductName     = m.GetFieldStr("ProductName", ds1);
            setting.ContactUrl      = m.GetFieldStr("ContactUrl", ds1);
            setting.DisableSystem   = m.GetFieldBol("DisableSystem", ds1);
            setting.DisableMessage  = m.GetFieldStr("DisableMessage", ds1);
            setting.AboutLine1      = m.GetFieldStr("AboutLine1", ds1);
            setting.AboutLine2      = m.GetFieldStr("AboutLine2", ds1);
            setting.AboutLine3      = m.GetFieldStr("AboutLine3", ds1);
            setting.TextField1      = m.GetFieldStr("TextField1", ds1);
            setting.TextField2      = m.GetFieldStr("TextField2", ds1);
            setting.TextField3      = m.GetFieldStr("TextField3", ds1);
            setting.TextField4      = m.GetFieldStr("TextField4", ds1);
            setting.CheckBox1       = m.GetFieldBol("CheckBox1", ds1);
            setting.CheckBox2       = m.GetFieldBol("CheckBox2", ds1);
            setting.CheckBox3       = m.GetFieldBol("CheckBox3", ds1);
            setting.CheckBox4       = m.GetFieldBol("CheckBox4", ds1);
            setting.CheckBox5       = m.GetFieldBol("CheckBox5", ds1);
            setting.CheckBox6       = m.GetFieldBol("CheckBox6", ds1);
            setting.CheckBox7       = m.GetFieldBol("CheckBox7", ds1);
        }
Beispiel #10
0
        private List <GroupItemDM> GetGroups2(bool bAll)
        {
            List <GroupItemDM> GroupList = new List <GroupItemDM>();
            GroupItemDM        GroupItem;
            string             sAPIInput = "";
            APIRunner          oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API04_GET_GROUPS;

            if (bAll)
            {
                aParamData[0] = "1";
            }
            else
            {
                aParamData[0] = "0";
            }

            sAPIInput = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return(GroupList);
            }
            ds1 = oAPI.DatasetReturned;

            foreach (DataRow r in ds1.Tables[0].Rows)
            {
                GroupItem                    = new GroupItemDM();
                GroupItem.GroupGUID          = m.GetFieldStr("GroupGUID", r);
                GroupItem.GroupName          = m.GetFieldStr("GroupName", r);
                GroupItem.GroupDescription   = m.GetFieldStr("GroupDescription", r);
                GroupItem.GroupPin           = m.GetFieldStr("GroupPin", r);
                GroupItem.GroupPhone         = m.GetFieldStr("GroupPhone", r);
                GroupItem.GroupEmail         = m.GetFieldStr("GroupEmail", r);
                GroupItem.GroupActive        = m.GetFieldBol("GroupActive", r);
                GroupItem.GroupIsDefault     = m.GetFieldBol("GroupIsDefault", r);
                GroupItem.GroupShowAllGroups = m.GetFieldBol("GroupShowAllGroups", r);
                GroupItem.GroupColor         = m.GetFieldStr("GroupColor", r);
                GroupList.Add(GroupItem);
            }



            return(GroupList);
        }
Beispiel #11
0
        private void MardTTasDeleted2(TeeTimeItem TT, bool bUndelete)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API03_MARK_TT_AS_DELETED;

            if (!m.IsPinCorrect(TT.PinNumberEntered, TT.GroupGUID))
            {
                TT.ValidationFailMessage = "Incorrect pin.";
                return;
            }

            aParamData[0] = JsonSerializer.Serialize <TeeTimeItem>(TT);
            aParamData[1] = m.BolToStr(bUndelete);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                if (bUndelete)
                {
                    InfoMessage = "";
                }
                else
                {
                    InfoMessage = "";
                }
            }
            else
            {
                ErrorMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
Beispiel #12
0
        private void AddChatItem2(ChatDM cc)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API06_ADD_MESSAGE;


            if (m.IsEmpty(cc.Message))
            {
                cc.ValidationFailMessage = "Message cannot be blank.";
                return;
            }

            if (m.IsEmpty(cc.Initials))
            {
                cc.ValidationFailMessage = "Initials cannot be blank.";
                return;
            }

            aParamData[0] = JsonSerializer.Serialize <ChatDM>(cc);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.GetFieldStr("ResultCode", ds1) == c.BATCH_RESULT_OK)
            {
                InfoMessage = "";
            }
            else
            {
                ErrorMessage = m.GetFieldStr("ResultMsg", ds1);
            }
        }
Beispiel #13
0
        private List <AuditLogDM> GetAuditLog2(string ttGUID)
        {
            List <AuditLogDM> ccList = new List <AuditLogDM>();
            AuditLogDM        ccItem;
            string            sAPIInput = "";
            APIRunner         oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            aParamData[0] = ttGUID;
            int iAPINumber = c.API07_GET_AUDITLOG;

            sAPIInput = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return(ccList);
            }
            ds1 = oAPI.DatasetReturned;

            foreach (DataRow r in ds1.Tables[0].Rows)
            {
                ccItem              = new AuditLogDM();
                ccItem.LogGUID      = m.GetFieldStr("LogGUID", r);
                ccItem.TTGUID       = m.GetFieldStr("TTGUID", r);
                ccItem.LogDateTime  = m.GetFieldDate("LogDateTime", r);
                ccItem.LogEvent     = m.GetFieldStr("LogEvent", r);
                ccItem.LogIPAddress = m.GetFieldStr("LogIPAddress", r);
                ccItem.DisplayLine1 = m.FormatDT(ccItem.LogDateTime, c.DATE_FORMAT21).ToLower();
                ccItem.DisplayLine2 = ccItem.LogEvent;
                ccList.Add(ccItem);
            }

            return(ccList);
        }
Beispiel #14
0
        private void GetSingleGroup2(GroupItemDM groupItem)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            int      iAPINumber = c.API04_GET_SINGLE_GROUP;

            aParamData[0] = groupItem.GroupGUID;
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return;
            }
            ds1 = oAPI.DatasetReturned;

            if (m.EmptyTable(ds1))
            {
                ErrorMessage = "Error. Group not found. (" + groupItem.GroupGUID + ")";
                return;
            }

            groupItem.GroupGUID          = m.GetFieldStr("GroupGUID", ds1);
            groupItem.GroupName          = m.GetFieldStr("GroupName", ds1);
            groupItem.GroupDescription   = m.GetFieldStr("GroupDescription", ds1);
            groupItem.GroupPin           = m.GetFieldStr("GroupPin", ds1);
            groupItem.GroupPhone         = m.GetFieldStr("GroupPhone", ds1);
            groupItem.GroupEmail         = m.GetFieldStr("GroupEmail", ds1);
            groupItem.GroupActive        = m.GetFieldBol("GroupActive", ds1);
            groupItem.GroupIsDefault     = m.GetFieldBol("GroupIsDefault", ds1);
            groupItem.GroupShowAllGroups = m.GetFieldBol("GroupShowAllGroups", ds1);
            groupItem.GroupColor         = m.GetFieldStr("GroupColor", ds1);
        }
Beispiel #15
0
        private List <ChatDM> GetChatList2(string sTTGUID)
        {
            List <ChatDM> ccList = new List <ChatDM>();
            ChatDM        ccItem;
            string        sAPIInput = "";
            APIRunner     oAPI      = new APIRunner(m);

            string[] aParamData = new string[10];
            aParamData[0] = sTTGUID;
            int iAPINumber = c.API06_GET_MESSAGES_LIST;

            sAPIInput = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return(ccList);
            }
            ds1 = oAPI.DatasetReturned;

            foreach (DataRow r in ds1.Tables[0].Rows)
            {
                ccItem                 = new ChatDM();
                ccItem.ChatGUID        = m.GetFieldStr("ChatGUID", r);
                ccItem.DateTimeEntered = m.GetFieldDate("DateTimeEntered", r);
                ccItem.Message         = m.GetFieldStr("Message", r);
                ccItem.IPAddress       = m.GetFieldStr("IPAddress", r);
                ccItem.DisplayLine     = m.GetPrettyDate(ccItem.DateTimeEntered) + " -- " + ccItem.Message;
                ccList.Add(ccItem);
            }

            return(ccList);
        }
Beispiel #16
0
 public API01(cMain mIn, APIRunner aIn)
 {
     m = mIn;
     a = aIn;
 }
Beispiel #17
0
        private List <TeeTimeItem> GetListOfTeeTimes2(string GroupGUID, bool ShowAllTeeTimes)
        {
            string    sAPIInput = "";
            APIRunner oAPI      = new APIRunner(m);

            string[]           aParamData = new string[10];
            int                iAPINumber = c.API01_GET_TEETIMES;
            TeeTimeItem        ttItem;
            List <TeeTimeItem> TTList = new List <TeeTimeItem>();

            if (m.IsEmpty(GroupGUID))
            {
                GroupGUID = LookupDefaultGroupGUID();
            }

            aParamData[0] = GroupGUID;
            aParamData[1] = m.BolToStr(ShowAllTeeTimes);
            sAPIInput     = m.ArrayToString(aParamData);

            oAPI.ActionCode      = iAPINumber;
            oAPI.InputParameters = sAPIInput;
            oAPI.CallAPI(c.APIType.SENDDATA_RECEIVEDATA);
            if (oAPI.ErrorOccured)
            {
                ErrorMessage       = oAPI.APIErrorMessage;
                SecretErrorDetails = oAPI.APIErrorSecretInfo;
                return(TTList);
            }
            ds1 = oAPI.DatasetReturned;

            foreach (DataRow r in ds1.Tables[0].Rows)
            {
                ttItem = new TeeTimeItem();

                ttItem.TTGUID         = m.GetFieldStr("TeeTimeGUID", r);
                ttItem.GroupGUID      = m.GetFieldStr("GroupGUID", r);
                ttItem.GroupName      = m.GetFieldStr("GroupName", r);
                ttItem.TTDate         = m.GetFieldDate("TeeTimeDate", r);
                ttItem.TTTime         = m.GetFieldDate("TeeTimeTime", r);
                ttItem.TTDateFormated = m.GetFieldDateF("TeeTimeDate", r, c.DATE_FORMAT20);
                ttItem.TTTimeFormated = m.GetFieldDateF("TeeTimeTime", r, c.DATE_FORMAT10).ToLower();
                ttItem.DaysFromNow    = m.DaysFromNow(m.GetFieldDate("TeeTimeDate", r));
                ttItem.Owner          = m.GetFieldStr("TeeTimeOwner", r);
                ttItem.OwnerComment   = m.GetFieldStr("OwnerComment", r);
                ttItem.Location       = m.GetFieldStr("TeeTimeLocation", r);
                ttItem.Player1        = m.GetFieldStr("Player1", r);
                ttItem.Player2        = m.GetFieldStr("Player2", r);
                ttItem.Player3        = m.GetFieldStr("Player3", r);
                ttItem.Player4        = m.GetFieldStr("Player4", r);
                ttItem.Player1Comment = m.GetFieldStr("Player1Comment", r);
                ttItem.Player2Comment = m.GetFieldStr("Player2Comment", r);
                ttItem.Player3Comment = m.GetFieldStr("Player3Comment", r);
                ttItem.Player4Comment = m.GetFieldStr("Player4Comment", r);
                ttItem.WaitList1      = m.GetFieldStr("WaitList1", r);
                ttItem.WaitList2      = m.GetFieldStr("WaitList2", r);
                ttItem.WaitList3      = m.GetFieldStr("WaitList3", r);
                ttItem.IsDeleted      = m.GetFieldBol("IsDeleted", r);
                ttItem.LockPlayer1    = m.GetFieldBol("LockPlayer1", r);
                ttItem.LockPlayer2    = m.GetFieldBol("LockPlayer2", r);
                ttItem.LockPlayer3    = m.GetFieldBol("LockPlayer3", r);
                ttItem.LockPlayer4    = m.GetFieldBol("LockPlayer4", r);
                ttItem.HideMessages   = m.GetFieldBol("HideMessages", r);
                ttItem.LockMessages   = m.GetFieldBol("LockMessages", r);
                ttItem.SpotsAvailable = SpotsLeft(ttItem);
                AddChatToTTItem(ttItem);

                TTList.Add(ttItem);
            }
            return(TTList);
        }