public void LoadCategoryById(int categoryId)
{
CategoryTDG categoryTDG = new CategoryTDG();
List <CategoryDto> categoryDtos = categoryTDG.FindCategoryById(categoryId).ToList();
DataTable categoryTable = new DataTable();
categoryTable.TableName = "Category";
Type categoryType = typeof(CategoryDto);
PropertyInfo[] propertyInfos = categoryType.GetProperties();
foreach (PropertyInfo propertyInfo in propertyInfos)
{
DataColumn dataColumn = new DataColumn();
dataColumn.ColumnName = propertyInfo.Name;
dataColumn.DataType = propertyInfo.PropertyType;
categoryTable.Columns.Add(dataColumn);
}
foreach (CategoryDto categoryDto in categoryDtos)
{
DataRow newRow = categoryTable.NewRow();
foreach (PropertyInfo propertyInfo in propertyInfos)
{
newRow[propertyInfo.Name] = propertyInfo.GetValue(categoryDto);
}
categoryTable.Rows.Add(newRow);
}
Holder.AddTable(categoryTable);
}
public void LoadOrderDetailById(int orderId)
{
OrderDetailTDG orderDetailTDG = new OrderDetailTDG();
IList <OrderDetailDto> orderDetailDtos = orderDetailTDG.FindOrderDetailById(orderId).ToList();
DataTable orderDetailTable = new DataTable();
orderDetailTable.TableName = "OrderDetail";
Type orderDetailType = typeof(OrderDetailDto);
PropertyInfo[] propertyInfos = orderDetailType.GetProperties();
foreach (PropertyInfo propertyInfo in propertyInfos)
{
DataColumn dataColumn = new DataColumn();
dataColumn.ColumnName = propertyInfo.Name;
dataColumn.DataType = propertyInfo.PropertyType;
orderDetailTable.Columns.Add(dataColumn);
}
foreach (OrderDetailDto orderDetailDto in orderDetailDtos)
{
DataRow newRow = orderDetailTable.NewRow();
foreach (PropertyInfo propertyInfo in propertyInfos)
{
newRow[propertyInfo.Name] = propertyInfo.GetValue(orderDetailDto);
}
orderDetailTable.Rows.Add(newRow);
}
Holder.AddTable(orderDetailTable);
}
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);
}