public string GetProviderColor(Appointmentm ap)
        {
            string HexColor = "#FFFFFF";

            try {
                Providerm pv;
                if (ap.AptStatus == ApptStatus.Complete)
                {
                    return("#808080");                    //gray
                }
                if (ap.IsHygiene)
                {
                    if (ap.ProvHyg == 0)                    //no hygenist
                    {
                        return(HexColor);
                    }
                    pv = Providerms.GetOne(CustomerNum, ap.ProvHyg);
                }
                else
                {
                    pv = Providerms.GetOne(CustomerNum, ap.ProvNum);
                }
                if (pv != null)
                {
                    HexColor = ColorTranslator.ToHtml(pv.ProvColor);
                }
                return(HexColor);
            }
            catch (Exception ex) {
                Logger.LogError("CustomerNum=" + CustomerNum + " ap.ProvNum=" + ap.ProvNum, ex);
                return(HexColor);
            }
        }