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