ASP.NET

eddieangel wrote:

I should have probably mentioned that I am using the MVC3 toolkit

Imports System.Web.Routing

Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
        RegisterRoutes(RouteTable.Routes)
End Sub


Sub RegisterRoutes(ByVal routes As RouteCollection)
        routes.Add("View Product", New Route("Products/{*ProductName}", New ProductRouteHandler()))
End Sub

Imports System.Data.SqlClient
Imports System.Web.Routing

Public Class ProductRouteHandler
    Implements IRouteHandler

#Region "Variables"
    Dim connectionString As String = ConfigurationManager.ConnectionStrings("SQLMembership").ConnectionString
    Dim myConnection As New SqlConnection(connectionString)
#End Region

Public Function GetHttpHandler(ByVal requestContext As System.Web.Routing.RequestContext) As System.Web.IHttpHandler Implements System.Web.Routing.IRouteHandler.GetHttpHandler
        Dim productName As String = requestContext.RouteData.Values("ProductName").ToString

        If String.IsNullOrEmpty(productName) Then
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/PageNotFound.aspx", GetType(Page)), Page)
        End If

        Dim selectSQL As String = "SELECT ProductID FROM Products WHERE ProductShortName='" & productName & "'"
        Dim selectCommand As SqlDataAdapter = New SqlDataAdapter(selectSQL, myConnection)
        Dim ds As New DataSet

        selectCommand.Fill(ds)

        If ds.Tables(0).Rows.Count > 0 Then
            HttpContext.Current.Items("ProductID") = ds.Tables(0).Rows(0).Item("ProductID").ToString
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/ProductDetails.aspx", GetType(Page)), Page)
        Else
            Return CType(System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath("~/Shopping/PageNotFound.aspx", GetType(Page)), Page)
        End If
    End Function
End Class

<asp:FormView ID="fvProduct" runat="server" DataKeyNames="ProductID" DataSourceID="ProductDataSource">
        <ItemTemplate>
            <div id="ContentHead" class="ContentHead" runat="server">
                <%#Eval("ProductName")%></div>
            <br />
            <table style="border: 0px;">
                <tr>
                    <td style="vertical-align: top;">
                        <section>
                            <div id="section_articleOneIdentifier">
                            </div>
                            <article id="article_one">
                                <div id="gallery">
                                    <asp:PlaceHolder ID="ImageLightBox" runat="server" />
                                </div>
                            </article>
                        </section>
                        <%-- <img src='../Product_Images/<%#Eval("ProductImageName") %>' width="100" height="75"
                            alt='<%#Eval("ProductName") %> Image' />--%>
                    </td>
                    <td style="vertical-align: top;">
                        <%#Eval("ProductLongDescription")%>
                        <br />
                    </td>
                </tr>
            </table>
            <div style="padding-left: 250px; text-align: right">
                Your Price:  <%#Eval("ProductPrice", "{0:c}")%>
                <br />
            </div>
            <div style="padding-left: 400px; text-align: right;">
                <input type="number" id="itemCount" value="1" min="1" max="999" required="true" onblur="checkItemCount();"
                    onchange="revertColors();" />
                    <br />
                <a style="border: 0 none white" onmouseover="setCursorPointer();" onmouseout="setCursorNormal();">
                    <img id="imgAddToCart" src="Images/AddToCart.png" runat="server" alt="Add To Cart"
                        style="border-width: 0" onclick="process();" /></a>
                        <div style="vertical-align:top;text-align:right;padding-right:10px;">
                <asp:Label ID="lblStock" runat="server" Font-Size="10px" Font-Bold="true" Text="" />
                </div>
                <br />
                <br />
            </div>
        </ItemTemplate>
    </asp:FormView>

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If String.IsNullOrEmpty(Request.QueryString("productID")) Then
            productID = CType(HttpContext.Current.Items("ProductID"), String)
        Else
            productID = Request.QueryString("productID")
        End If
        DetermineStock()
        CreateLightBox()
End Sub

Private Sub DetermineStock()
        Dim selectSQL As String = "SELECT TotalStock FROM Products WHERE ProductID='" & productID & "'"
        Dim selectCommand As SqlDataAdapter = New SqlDataAdapter(selectSQL, myConnection)
        Dim ds As New DataSet

        selectCommand.Fill(ds)

        Dim totalStock As Integer = CInt(ds.Tables(0).Rows(0).Item("TotalStock"))
        Dim StockLabel As Label = DirectCast(fvProduct.FindControl("lblStock"), Label)

        If totalStock > 0 Then
            StockLabel.Text = "In Stock"
            StockLabel.ForeColor = Drawing.Color.Green
        Else
            StockLabel.Text = "Backordered"
            StockLabel.ForeColor = Drawing.Color.Red
        End If
End Sub

<httpModules>

<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<add name="QueryStringModule" type="QueryStringModule"/>

<add name="UrlRoutingModul" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

</httpModules>

<system.webServer>
		<validation validateIntegratedModeConfiguration="false"/>
		<modules>
                         ...
			<add name="UrlRoutingModule" type="System.Web.Routing.UrlRoutingModule, System.Web.Routing, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
		</modules>
		<handlers>
			...
                        <add name="UrlRoutingHandler" preCondition="integratedMode" verb="*" path="UrlRouting.axd" type="System.Web.HttpForbiddenHandler, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
		</handlers>
</system.webServer>