protected void btnAddToCart_Click(object sender, EventArgs e)
        {
            //make sure that there are enough units in stock
            if (vldQuantity.IsValid) //<stretch>Should also have server side validation in case of multiple users/connections</stretch>
            {
                NorwinDBTableAdapters.CartTableAdapter     cart     = new NorwinDBTableAdapters.CartTableAdapter();
                NorwinDBTableAdapters.ProductsTableAdapter products = new NorwinDBTableAdapters.ProductsTableAdapter();

                //get input
                int numberToOrder = int.Parse(cbxQuantity.SelectedValue);

                float unitPrice = (float)products.GetUnitPriceByProdID(Convert.ToInt32(Request.QueryString[0]));

                float subTotal = (float)numberToOrder * unitPrice;

                //add the selected quantity of the item to the cart table in the DB
                cart.InsertCartItem(prodName, numberToOrder, prodID, custID, Session.SessionID, unitPrice, subTotal);
                products.UpdateInStock((short)(unitsInStock - numberToOrder), prodID);

                lsvProdDetails.DataSource = products.GetDataByProdID(Convert.ToInt32(Request.QueryString[0]));
                lsvProdDetails.DataBind();

                lblItemAdded.Text = numberToOrder + " items added to order.";
            }
            else
            {
                lblItemAdded.Text = "...";
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            NorwinDBTableAdapters.ProductsTableAdapter products = new NorwinDBTableAdapters.ProductsTableAdapter();

            //get the product Id from the query string
            prodID = int.Parse(Request.QueryString[0]);

            //get the other needed info from various queries
            //TODO get this from the logged in account
            custID   = "GROSR";
            prodName = products.GetNameByProdID(prodID).ToString();


            //use the product id to call my scalar SQL statement to get the number of units in stock
            unitsInStock = Convert.ToInt32(products.GetInStockByProdID(prodID));

            if (unitsInStock > 0)
            {
                //set the max value of the validator to be the amount thats in stock
                vldQuantity.MaximumValue = unitsInStock.ToString();
            }
            else
            {
                vldQuantity.MinimumValue = "0";
                vldQuantity.MaximumValue = "0";
            }

            lsvProdDetails.DataSource = products.GetDataByProdID(Convert.ToInt32(Request.QueryString[0]));
            lsvProdDetails.DataBind();
        }