protected void ddlProducts_SelectedIndexChanged(object sender, EventArgs e)
 {
     ProductService productContext = new ProductService(new BizCustomerOrder());
     object unitPrice = productContext.GetProductPriceByProductID(int.Parse(ddlProducts.SelectedValue));
     if(unitPrice!=null)
     {
         labUnitPrice.Text = unitPrice.ToString();
     }
 }
 private void CreateList()
 {
     ProductService productContext = new ProductService(new BizCustomerOrder());
     IEnumerable<Products> productList = productContext.GetProducts();
     ddlProducts.DataSource = productList;
     ddlProducts.DataTextField = "ProductName";
     ddlProducts.DataValueField = "ProductID";
     ddlProducts.DataBind();
     labUnitPrice.Text = productList.FirstOrDefault().UnitPrice.ToString();
     //ddlProducts.Items.Insert(0, new ListItem("(請選擇)", "0"));
     ShipperService shipperrContext = new ShipperService(new BizCustomerOrder());
     ddlShippers.DataSource = shipperrContext.GetShippers();
     ddlShippers.DataTextField = "CompanyName";
     ddlShippers.DataValueField = "ShipperID";
     ddlShippers.DataBind();
     EmployeeService empContext = new EmployeeService(new BizCustomerOrder());
     ddlEmployee.DataSource = empContext.GetEmployees();
     ddlEmployee.DataTextField = "FirstName";
     ddlEmployee.DataValueField = "EmployeeID";
     ddlEmployee.DataBind();
 }