public Product SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.PRODUCT, 1)), QueryTypes.DATAROW);
return(new Product(row));
}
public Address SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.ADDRESS, 1)), QueryTypes.DATAROW);
return(new Address(row));
}
public OrderDetail SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.ORDERDETAIL, 1)), QueryTypes.DATAROW);
return(new OrderDetail(row));
}
public Supplier SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.SUPPLIER, 1)), QueryTypes.DATAROW);
return(new Supplier(row));
}
public Customer SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.CUSTOMER, 1)), QueryTypes.DATAROW);
return(new Customer(row));
}
public Category SelectRandom()
{
DataRow row = (DataRow)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.CATEGORY, 1)), QueryTypes.DATAROW);
return(new Category(row));
}
public IList <Address> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.ADDRESS, numRecords)), QueryTypes.DATATABLE);
IList <Address> addresses = new List <Address>();
foreach (DataRow row in table.Rows)
{
addresses.Add(new Address(row));
}
return(addresses);
}
public IList <OrderDetail> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.ORDERDETAIL, numRecords)), QueryTypes.DATATABLE);
IList <OrderDetail> orderdetails = new List <OrderDetail>();
foreach (DataRow row in table.Rows)
{
orderdetails.Add(new OrderDetail(row));
}
return(orderdetails);
}
public IList <Supplier> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.SUPPLIER, numRecords)), QueryTypes.DATATABLE);
IList <Supplier> suppliers = new List <Supplier>();
foreach (DataRow row in table.Rows)
{
suppliers.Add(new Supplier(row));
}
return(suppliers);
}
public IList <Product> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.PRODUCT, numRecords)), QueryTypes.DATATABLE);
IList <Product> products = new List <Product>();
foreach (DataRow row in table.Rows)
{
products.Add(new Product(row));
}
return(products);
}
public IList <Customer> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.CUSTOMER, numRecords)), QueryTypes.DATATABLE);
IList <Customer> customers = new List <Customer>();
foreach (DataRow row in table.Rows)
{
customers.Add(new Customer(row));
}
return(customers);
}
public IList <Category> SelectRandom(int numRecords)
{
DataTable table = (DataTable)GFXDDbi.Select(QualifyTableName(
DbDefault.GetSelectRandomStatement(TableName.CATEGORY, numRecords)), QueryTypes.DATATABLE);
IList <Category> categories = new List <Category>();
foreach (DataRow row in table.Rows)
{
categories.Add(new Category(row));
}
return(categories);
}
