protected void btnSave_Click(object sender, EventArgs e)
        {
            SqlProduct.UpdateParameters["Price"].DefaultValue      = txtPrice.Text;
            SqlProduct.UpdateParameters["Product_Id"].DefaultValue = dropProductName.SelectedValue;

            SqlProduct.Update();
            GridViewProduct.DataBind();
            panelAddQuotation.Visible  = false;
            panelSaveQuotation.Visible = true;
            txtPrice.Text = string.Empty;
            dropProductName.SelectedIndex = 0;
        }
        protected void btnSaveFinishedProduct_Click(object sender, EventArgs e)
        {
            SqlFinishedProduct.InsertParameters["Product_ID"].DefaultValue         = strProductID;
            SqlFinishedProduct.InsertParameters["Manufactured_Date"].DefaultValue  = ManufacturedDateTextBox.Text.Trim();
            SqlFinishedProduct.InsertParameters["Quantity"].DefaultValue           = strQty;
            SqlFinishedProduct.InsertParameters["Available_Quantity"].DefaultValue = strQty;
            SqlFinishedProduct.Insert();
            gvFinishedProduct.DataBind();

            SqlProduct.UpdateParameters["WorkSchedule_ID"].DefaultValue            = dropaddProduct.SelectedValue;
            SqlProduct.UpdateParameters["Is_FinishedProduct_Updated"].DefaultValue = "true";
            SqlProduct.Update();
            PanelgvFinishedProduct.Visible = true;
            dropaddProduct.SelectedIndex   = -1;
            ManufacturedDateTextBox.Text   = String.Empty;
            QuantityTextBox.Text           = String.Empty;
        }