public long UpdateCategory(Category category)
{
return (new CategoryDao(Connection, SchemaName)).Update(category);
}
public Product()
{
ProductId = 0;
Name = String.Empty;
Description = String.Empty;
Category = new Category();
Supplier = new Supplier();
UnitCost = 0;
RetailPrice = 0;
UnitsInStock = 0;
ReorderQuantity = 0;
LastOrderDate = DateTime.Today;
NextOrderDate = DateTime.Today;
}
private static Category GetProductCategory()
{
Category category = new Category();
category.CategoryId = DbHelper.GetRandomRowId(
TableName.CATEGORY.ToString(),
DbDefault.GetTableStructure(TableName.CATEGORY).PKColumns[0]);
return category;
}
public long AddCategory(Category category)
{
return (new CategoryDao(Connection, SchemaName)).Insert(category);
}
private static Category GetCategoryInfo(Category category)
{
category.Name = GetCategoryName();
category.Description = GetCategoryDescription();
return category;
}
private static Category CreateCategory()
{
Category category = new Category();
category.CategoryId = GetNewCategoryId();
return GetCategoryInfo(category);
}
private String BuildQuery(String statement, Category category)
{
return String.Format(statement,
GFXDDbi.Escape(category.Name),
GFXDDbi.Escape(category.Description));
}
public int Update(Category category)
{
String statement = QualifyTableName(DbDefault.GetUpdateStatement(
TableName.CATEGORY, new long[] { category.CategoryId }));
if (Connection != null)
return GFXDDbi.Update(Connection, BuildQuery(statement, category));
else
return GFXDDbi.Update(BuildQuery(statement, category));
}
public long Insert(Category category)
{
String statement = QualifyTableName(DbDefault.GetInsertStatement(
TableName.CATEGORY, new long[] { category.CategoryId }));
statement = BuildQuery(statement, category);
if (Connection != null)
return GFXDDbi.Insert(Connection, statement);
else
return GFXDDbi.Insert(statement);
}