public AuthorizationCollection GetAuthorizations()
        {
            AuthorizationCollection authorizations = new AuthorizationCollection();

            IDataReader dr = new AuthorizationDataAdapter().GetAuthorizations();
            while (dr.Read())
            {
                authorizations.Add(PopulateReader(dr));
            }
            return authorizations;
        }
        public Authorization GetAuthorization(int id)
        {
            Authorization authorization = new Authorization();

            IDataReader dr = new AuthorizationDataAdapter().GetAuthorizationById(id);
            if (dr.Read())
            {
                authorization = PopulateReader(dr);
            }
            return authorization;
        }