public void TestTDGFindCategoryById()
        {
            int orderId = 10693;

            OrderDetailTDG         orderDetailTDG  = new OrderDetailTDG();
            IList <OrderDetailDto> orderDetailDtos = orderDetailTDG.FindOrderDetailById(orderId).ToList();

            ProductTDG  productTDG   = new ProductTDG();
            CategoryTDG categoryTDG  = new CategoryTDG();
            int         productId0   = orderDetailDtos[0].ProductID;
            ProductDto  productDto0  = productTDG.FindProductById(productId0).SingleOrDefault();
            CategoryDto categoryDto0 = categoryTDG.FindCategoryById(productDto0.CategoryID).SingleOrDefault();

            Assert.AreEqual("Meat/Poultry", categoryDto0.CategoryName);

            Assert.AreEqual(6, productDto0.CategoryID);
            int         productId1   = orderDetailDtos[1].ProductID;
            ProductDto  productDto1  = productTDG.FindProductById(productId1).SingleOrDefault();
            CategoryDto categoryDto1 = categoryTDG.FindCategoryById(productDto1.CategoryID).SingleOrDefault();

            Assert.AreEqual("Meat/Poultry", categoryDto1.CategoryName);

            int         productId2   = orderDetailDtos[2].ProductID;
            ProductDto  productDto2  = productTDG.FindProductById(productId2).SingleOrDefault();
            CategoryDto categoryDto2 = categoryTDG.FindCategoryById(productDto2.CategoryID).SingleOrDefault();

            Assert.AreEqual("Dairy Products", categoryDto2.CategoryName);

            int         productId3   = orderDetailDtos[3].ProductID;
            ProductDto  productDto3  = productTDG.FindProductById(productId3).SingleOrDefault();
            CategoryDto categoryDto3 = categoryTDG.FindCategoryById(productDto3.CategoryID).SingleOrDefault();

            Assert.AreEqual("Seafood", categoryDto3.CategoryName);
        }
예제 #2
0
        public void LoadProductById(int productId)
        {
            ProductTDG        productTDG  = new ProductTDG();
            List <ProductDto> productDtos = productTDG.FindProductById(productId).ToList();

            DataTable producTable = new DataTable();

            producTable.TableName = "Product";

            Type producType = typeof(ProductDto);

            PropertyInfo[] propertyInfos = producType.GetProperties();
            foreach (PropertyInfo propertyInfo in propertyInfos)
            {
                DataColumn dataColumn = new DataColumn();
                dataColumn.ColumnName = propertyInfo.Name;
                dataColumn.DataType   = propertyInfo.PropertyType;
                producTable.Columns.Add(dataColumn);
            }

            foreach (ProductDto productDto in productDtos)
            {
                DataRow newRow = producTable.NewRow();

                foreach (PropertyInfo propertyInfo in propertyInfos)
                {
                    newRow[propertyInfo.Name] = propertyInfo.GetValue(productDto);
                }

                producTable.Rows.Add(newRow);
            }

            Holder.AddTable(producTable);
        }
        public void TestTDGFindProductById()
        {
            int orderId = 10693;

            OrderDetailTDG         orderDetailTDG  = new OrderDetailTDG();
            IList <OrderDetailDto> orderDetailDtos = orderDetailTDG.FindOrderDetailById(orderId).ToList();

            ProductTDG productTDG  = new ProductTDG();
            int        productId0  = orderDetailDtos[0].ProductID;
            ProductDto productDto0 = productTDG.FindProductById(productId0).SingleOrDefault();

            Assert.AreEqual(productId0, productDto0.ProductID);
            Assert.AreEqual("Mishi Kobe Niku", productDto0.ProductName);
            Assert.AreEqual(6, productDto0.CategoryID);

            int        productId1  = orderDetailDtos[1].ProductID;
            ProductDto productDto1 = productTDG.FindProductById(productId1).SingleOrDefault();

            Assert.AreEqual(productId1, productDto1.ProductID);
            Assert.AreEqual("Tourtière", productDto1.ProductName);
            Assert.AreEqual(6, productDto1.CategoryID);

            int        productId2  = orderDetailDtos[2].ProductID;
            ProductDto productDto2 = productTDG.FindProductById(productId2).SingleOrDefault();

            Assert.AreEqual(productId2, productDto2.ProductID);
            Assert.AreEqual("Gudbrandsdalsost", productDto2.ProductName);
            Assert.AreEqual(4, productDto2.CategoryID);

            int        productId3  = orderDetailDtos[3].ProductID;
            ProductDto productDto3 = productTDG.FindProductById(productId3).SingleOrDefault();

            Assert.AreEqual(productId3, productDto3.ProductID);
            Assert.AreEqual("Röd Kaviar", productDto3.ProductName);
            Assert.AreEqual(8, productDto3.CategoryID);
        }