public App_ErpOptions GetErpOptions()
        {
            App_ErpOptions erpOptions = null;

            lock (_locker)
            {
                JT_FieldServiceOptions fieldServiceOption  = GetFieldServiceOption();
                JT_TechnicianStatus    defaultArriveStatus = null;
                JT_TechnicianStatus    defaultDepartStatus = null;
                JT_MiscellaneousCodes  defaultServiceTicketArriveStatus = null;

                if (fieldServiceOption != null)
                {
                    if (fieldServiceOption.ArriveStatusCode != null)
                    {
                        defaultArriveStatus = GetTechnicianStatusFromDB(fieldServiceOption.ArriveStatusCode);
                    }
                    if (fieldServiceOption.DepartStatusCode != null)
                    {
                        defaultDepartStatus = GetTechnicianStatusFromDB(fieldServiceOption.DepartStatusCode);
                    }
                    if (fieldServiceOption.ServiceStartedStatusCode1 != null)
                    {
                        defaultServiceTicketArriveStatus = GetMiscellaneousCodeFromDB("ST", fieldServiceOption.ServiceStartedStatusCode1);
                    }

                    erpOptions = new App_ErpOptions(fieldServiceOption, defaultArriveStatus, defaultDepartStatus, defaultServiceTicketArriveStatus);
                }
            }

            return(erpOptions);
        }
        protected JT_FieldServiceOptions GetFieldServiceOption()
        {
            JT_FieldServiceOptions option = null;

            lock (_locker)
            {
                // there should only be one record
                option = _database.Table <JT_FieldServiceOptions>().FirstOrDefault();
            }

            return(option);
        }