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