public List <OwnersDogsClassesHandlers> GetOwnersDogsClassesHandlers(Guid owner_ID)
        {
            List <OwnersDogsClassesHandlers> retVal = new List <OwnersDogsClassesHandlers>();

            try
            {
                OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL(_connString);
                tblOwnersDogsClassesHandlers = ownersDogsClassesHandlers.GetOwnersDogsClassesHandlers(owner_ID);

                if (tblOwnersDogsClassesHandlers != null && tblOwnersDogsClassesHandlers.Rows.Count > 0)
                {
                    foreach (DataRow row in tblOwnersDogsClassesHandlers.Rows)
                    {
                        OwnersDogsClassesHandlers oDCH = new OwnersDogsClassesHandlers(_connString);
                        oDCH.Dog_Class_ID = Utils.DBNullToGuid(row["Dog_Class_ID"]);
                        oDCH.Owner_ID     = Utils.DBNullToGuid(row["Owner_ID"]);
                        oDCH.Handler_ID   = Utils.DBNullToGuid(row["Handler_ID"]);
                        oDCH.Owner        = Utils.DBNullToString(row["Owner"]);
                        oDCH.Dog_KC_Name  = Utils.DBNullToString(row["Dog_KC_Name"]);
                        oDCH.Class        = Utils.DBNullToString(row["Class"]);
                        oDCH.Handler      = Utils.DBNullToString(row["Handler"]);
                        retVal.Add(oDCH);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
        public bool PopulateOwnersDogsClassesHandlers(Guid owner_ID)
        {
            bool retVal = false;

            try
            {
                OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL(_connString);
                retVal = ownersDogsClassesHandlers.PopulateOwnersDogsClassesHandlers(owner_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(retVal);
        }
        public List<OwnersDogsClassesHandlers> GetOwnersDogsClassesHandlers(Guid owner_ID)
        {
            List<OwnersDogsClassesHandlers> ownersDogsClassesHandlersList = new List<OwnersDogsClassesHandlers>();
            OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL();
            tblOwnersDogsClassesHandlers = ownersDogsClassesHandlers.GetOwnersDogsClassesHandlers(owner_ID);

            if (tblOwnersDogsClassesHandlers != null && tblOwnersDogsClassesHandlers.Count > 0)
            {
                foreach (sss.tblOwnersDogsClassesHandlersRow row in tblOwnersDogsClassesHandlers)
                {
                    OwnersDogsClassesHandlers oDCH = new OwnersDogsClassesHandlers();
                    oDCH.Dog_Class_ID = row.Dog_Class_ID;
                    oDCH.Owner_ID = row.Owner_ID;
                    oDCH.Handler_ID = row.Handler_ID;
                    oDCH.Owner = row.Owner;
                    oDCH.Dog_KC_Name = row.Dog_KC_Name;
                    oDCH.Class = row.Class;
                    oDCH.Handler = row.Handler;
                    ownersDogsClassesHandlersList.Add(oDCH);
                }
            }
            return ownersDogsClassesHandlersList;
        }
        public bool PopulateOwnersDogsClassesHandlers(Guid owner_ID)
        {
            bool success = false;

            OwnersDogsClassesHandlersBL ownersDogsClassesHandlers = new OwnersDogsClassesHandlersBL();
            success = ownersDogsClassesHandlers.PopulateOwnersDogsClassesHandlers(owner_ID);

            return success;
        }