private String BuildQuery(String statement, Order order)
{
return(String.Format(statement,
GFXDDbi.Escape(order.OrderDate.ToShortDateString()),
GFXDDbi.Escape(order.ShipDate.ToShortDateString()),
order.Customer.CustomerId,
order.SubTotal));
}
private String BuildQuery(String statement, Supplier supplier)
{
return(String.Format(statement,
GFXDDbi.Escape(supplier.Name),
supplier.Address.AddressId,
GFXDDbi.Escape(supplier.Phone),
GFXDDbi.Escape(supplier.Email)));
}
private String BuildQuery(String statement, Customer customer)
{
return(String.Format(statement,
GFXDDbi.Escape(customer.FirstName),
GFXDDbi.Escape(customer.LastName),
customer.Address.AddressId,
GFXDDbi.Escape(customer.Phone),
GFXDDbi.Escape(customer.Email),
GFXDDbi.Escape(customer.LastOrderDate.ToShortDateString())));
}
private String BuildQuery(String statement, Address address)
{
return(String.Format(statement,
GFXDDbi.Escape(address.Address1),
GFXDDbi.Escape(address.Address2),
GFXDDbi.Escape(address.Address3),
GFXDDbi.Escape(address.City),
GFXDDbi.Escape(address.State.ToString()),
GFXDDbi.Escape(address.ZipCode.ToString()),
GFXDDbi.Escape(address.Province.ToString()),
(int)address.CountryCode));
}
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())));
}
private String BuildQuery(String statement, Category category)
{
return(String.Format(statement,
GFXDDbi.Escape(category.Name),
GFXDDbi.Escape(category.Description)));
}