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 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);
}
