public int Update(Product product)
{
String statement = QualifyTableName(DbDefault.GetUpdateStatement(
TableName.PRODUCT, new long[] { product.ProductId }));
if(Connection != null)
return GFXDDbi.Update(Connection, BuildQuery(statement, product));
else
return GFXDDbi.Update(BuildQuery(statement, product));
}
private String BuildQuery(String statement, Product product)
{
return String.Format(statement,
GFXDDbi.Escape(product.Name),
GFXDDbi.Escape(product.Description),
product.Category.CategoryId,
product.Supplier.SupplierId,
product.UnitCost,
product.RetailPrice,
product.UnitsInStock,
product.ReorderQuantity,
GFXDDbi.Escape(product.LastOrderDate.ToShortDateString()),
GFXDDbi.Escape(product.NextOrderDate.ToShortDateString()));
}
public long Insert(Product product)
{
String statement = QualifyTableName(DbDefault.GetInsertStatement(
TableName.PRODUCT, new long[] { product.ProductId }));
statement = BuildQuery(statement, product);
if(Connection != null)
return GFXDDbi.Insert(Connection, statement);
else
return GFXDDbi.Insert(statement);
}
public long UpdateProduct(Product product)
{
return (new ProductDao(Connection, SchemaName)).Update(product);
}
public long AddProduct(Product product)
{
return (new ProductDao(Connection, SchemaName)).Insert(product);
}
private static Product GetProductInfo(Product product)
{
product.Name = GetProductName();
product.Description = GetProductDescription();
product.Category = GetProductCategory();
product.Supplier = GetProductSupplier();
product.UnitCost = GetProductUnitCost();
product.RetailPrice = GetProductRetailPrice();
product.UnitsInStock = GetProductUnitsInStock();
product.ReorderQuantity = GetProductReorderQuantity();
product.LastOrderDate = GetProductLastOrderDate();
product.NextOrderDate = GetProductNextOrderDate();
return product;
}
private static Product CreateProduct()
{
Product product = new Product();
product.ProductId = GetNewProductId();
return GetProductInfo(product);
}
