public static DataTable CreateOrderDetailsTable() { DataTable orderDetails = new DataTable("OrderDetails"); DataColumn id = ColumnCreator.CreateIdColumn(); DataColumn employeeId = ColumnCreator.CreateEmployeeIdColumn(); DataColumn saleDate = ColumnCreator.CreateSaleDateColumn(); orderDetails.Columns.AddRange(new DataColumn[] { id, employeeId, saleDate }); orderDetails.PrimaryKey = new DataColumn[] { id }; return(orderDetails); }
public static DataTable CreateCustomersTable() { DataTable customers = new DataTable("Customers"); DataColumn id = ColumnCreator.CreateIdColumn(); DataColumn name = ColumnCreator.CreateNameColumn(); DataColumn surname = ColumnCreator.CreateSurnameColumn(); customers.Columns.AddRange(new DataColumn[] { id, name, surname }); customers.PrimaryKey = new DataColumn[] { id }; return(customers); }
public static DataTable CreateEmployeesTable() { DataTable employees = new DataTable("Employees"); DataColumn id = ColumnCreator.CreateIdColumn(); DataColumn name = ColumnCreator.CreateNameColumn(); DataColumn surname = ColumnCreator.CreateSurnameColumn(); employees.Columns.AddRange(new DataColumn[] { id, name, surname }); employees.PrimaryKey = new DataColumn[] { id }; return(employees); }
public static DataTable CreateOrdersTable() { DataTable orders = new DataTable("Orders"); DataColumn id = ColumnCreator.CreateIdColumn(); DataColumn productId = ColumnCreator.CreateProductIdColumn(); DataColumn customerId = ColumnCreator.CreateCustomerIdColumn(); DataColumn orderDetailId = ColumnCreator.CreateOrderDetailIdColumn(); orders.Columns.AddRange(new DataColumn[] { id, productId, customerId, orderDetailId }); orders.PrimaryKey = new DataColumn[] { id }; return(orders); }
public static DataTable CreateProductsTable() { DataTable products = new DataTable("Products"); DataColumn id = ColumnCreator.CreateIdColumn(); DataColumn name = ColumnCreator.CreateNameColumn(); DataColumn price = ColumnCreator.CreatePriceColumn(); DataColumn producedDate = ColumnCreator.CreateProducedDateColumn(); DataColumn expirationDate = ColumnCreator.CreateExpirationDateColumn(); products.Columns.AddRange(new DataColumn[] { id, name, price, producedDate, expirationDate }); products.PrimaryKey = new DataColumn[] { id }; return(products); }