public List <ProductCategory> GetsByProductType(int nProductType, int nUserID)
        {
            Connection.Open();
            Command.CommandText = ProductCategoryDA.GetsByProductType(nProductType, nUserID);

            SqlDataReader          reader             = Command.ExecuteReader();
            ProductCategory        _oProductCategory  = new ProductCategory();
            List <ProductCategory> _oProductCategorys = new List <ProductCategory>();

            if (reader.HasRows)
            {
                _oProductCategorys = MakeObjects(reader);
            }
            reader.Close();
            Connection.Close();
            return(_oProductCategorys);
        }