Blog: Posts from July, 2012

The Hyperlink Format String property allows formatting fields as hyperlinks that can use the field values as parameters.

Start SQL Server Management Studio. Right-click on Databases node, and select New Database.

Assign the database the name of FormatString, and press OK to create the server.

Right-click on Databases / FormatString / Tables node, and select Add New Table.

Add the following columns:

Right-click on ProductID column and select Set Primary Key.

Highlight ProductID column. Under Column Properties, specify the column as an identity.

Save the table as “Products”.

Switch to the web application generator. Create a new Web Site Factory project from the FormatString database. When the project configuration is complete, activate the Project Designer.

In the Project Explorer, double-click on Products / container1 / view1 / grid1 / Price data field node.

Change the Hyperlink Format String:

Press OK to save the data field. Double-click on Products / container1 / view1 / grid1 / PictureUrl data field node.

Mark the data field as hidden:

Press OK to save. On the toolbar, press Browse button.

When the web application is loaded, create three new records on the Products page with the following values:

The value of Price field in the grid view is rendered as a clickable link.

When you click on the link in the Price column, you will navigate to the PictureUrl.

The state of real world business objects modeled in the application database is frequently determined by the values of multiple object attributes.

For example, an order status may depend on the Order Date and Shipped Date. It would take some time for an end user to analyze the values to understand the status of an order. It would be beneficial for an application to provide a graphical representation of the order status.

Let’s implement a graphical representation of the internal object state using the Orders table of the Northwind sample. Most records have Shipped Date before Required Date. Some records do not have a value in the Shipped Date column. Other records have a Shipped Date past the Required Date.

It would be reasonable to assume that records without a Shipped Date have not been shipped yet, records that have a Shipped Date past the Required Date have been shipped late, and that the order is on time when the Shipped Date is before Required Date.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on Orders / Fields node, and select New Field option.

Give this field the following settings:

case
    when ShippedDate is null
        then 'Waiting To Ship'
    when ShippedDate < RequiredDate
        then 'Shipped'
    when ShippedDate > RequiredDate
        then 'Shipped Late'
end

Press OK to save the field. Right-click on Orders / Views / editForm1 / c1 – Orders node, and select New Data Field.

Give this data field the following settings:

Double-click on Orders controller node.

Change the Status Bar property:

Press OK to save the controller. On the toolbar, press Browse.

Navigate to the Orders page. Select an order in which the Shipped Date is before the Required Date. A status bar above the form provides a quick status update on the status of the order.

Select an order where Shipped Date is after Required Date. The status bar shows that the order has been delayed.

Finally, select an order without a value in Shipped Date field. The status bar will show that the order has not yet been shipped.

Status can be figured with complex calculations. For example, we configured the following SQL Formula for a new Status field in Products controller:

case
    when Discontinued = 1
        then 'Discontinued'
    when UnitsInStock + UnitsOnOrder < ReorderLevel
        then 'Low On Stock'
    when UnitsOnOrder > 0
        then 'On Order'
    when UnitsOnOrder = 0
        then 'In Stock'
end

The Status Bar configuration for Products controller looks like this:

Products.Status: Discontinued
Flagged for Review > [ The production of the product has been discontinued] >
 
Products.Status: Low On Stock
High Demand > [The product will be out of stock soon] > Place an order >
 
Products.Status: On Order
Product stock low > [An order has been placed] > Restocking >
 
Products.Status: In Stock
Recently restocked > [Plenty of stock] >

A product that has a large amount of Units In Stock will display the following status bar.

When there are a large amount of Units On Order, the status bar will notify that there is sufficient items ordered.

Discontinued products will be displayed like the picture below.

When the stock is low, the status bar will warn the user.