protected void btnSaveOrder_Click(object sender, EventArgs e)
        {
            InventoryBL bl    = new InventoryBL();
            tbl_Orders  order = new tbl_Orders()
            {
                Order_Id         = 0,
                Product_Id       = Convert.ToInt32(ddlProducts.SelectedItem.Value),
                Items_Count      = Convert.ToInt32(ddlNumberOfItems.SelectedItem.Value),
                Product_Cost     = Convert.ToInt32(txtCost.Text),
                Amount           = Convert.ToInt32(txtAmount.Text),
                Customer_Name    = txtCustName.Text,
                Customer_Address = txtAddress.Text,
                Customer_Phone   = txtCustPhone.Text,
                Gross_Amount     = Convert.ToInt32(txtGrossAmount.Text),
                Service_Charge   = Convert.ToInt32(txtServiceCharge.Text),
                Vat_Charge       = Convert.ToInt32(txtVat.Text),
                NetAmount        = Convert.ToInt32(txtNetAmount.Text)
            };

            //if (!bl.ValidateProduct(product))
            //{
            bool result = bl.SaveOrder(order);

            if (result == true)
            {
                ScriptManager.RegisterStartupScript(this, GetType(), "product error", "alert('Order placed successfully!');", true);
                Response.Redirect("Orders.aspx");
            }
        }