public List <RefereePivot> GetAllByRefereeId(Guid Id)
        {
            RefereePivotCommandBuilder homaCommandBuilder = new RefereePivotCommandBuilder();
            SqlCommand query = homaCommandBuilder.GetAllByRefereeId(Id);

            return(DBManager.GetCollection <RefereePivot>(ConnectionHandler, query));
        }
        public RefereePivot GetByPivotAndRefereeId(Guid?Id, Guid pivotId)
        {
            RefereePivotCommandBuilder homaCommandBuilder = new RefereePivotCommandBuilder();
            var query = homaCommandBuilder.GetByPivotAndRefereeId(Id, pivotId);

            return(DBManager.GetObject <RefereePivot>(ConnectionHandler, query));
        }