protected void btnSave_Click(object sender, EventArgs e)
 {
     dsMaterialDTableAdapters.VIEW_QUARANTINE_DETAILTableAdapter q = new dsMaterialDTableAdapters.VIEW_QUARANTINE_DETAILTableAdapter();
     try
     {
         q.InsertQuery(Decimal.Parse(ddlMatItem.SelectedValue), decimal.Parse(txtQty.Text), decimal.Parse(ddlQuaranCat.SelectedValue),
                       txtRemarks.Text, decimal.Parse(Request.QueryString["id"].ToString()));
         RadGrid1.Rebind();
         Master.ShowMessage(ddlMatItem.SelectedItem.Text + " Added.");
     }
     catch (Exception ex)
     {
         Master.ShowError(ex.Message);
     }
     finally {
         q.Dispose();
     }
 }
 protected void btnSave_Click(object sender, EventArgs e)
 {
     dsMaterialDTableAdapters.VIEW_QUARANTINE_DETAILTableAdapter q = new dsMaterialDTableAdapters.VIEW_QUARANTINE_DETAILTableAdapter();
     try
     {
         q.InsertQuery(Decimal.Parse(ddlMatItem.SelectedValue), decimal.Parse(txtQty.Text), decimal.Parse(ddlQuaranCat.SelectedValue),
                       txtRemarks.Text, decimal.Parse(Request.QueryString["id"].ToString()), txtHeatno.Text, txtDrumno.Text, txtQritem.Text, decimal.Parse(ddlPO.SelectedValue));
         RadGrid1.Rebind();
         Master.ShowMessage(ddlMatItem.SelectedItem.Text + " Added.");
         //RadWindowManager1.RadAlert("Access denied.", 400, 150, "Warning", "");
         decimal qr_item = WebTools.DMax("QR_ITEM", "PIP_MAT_QUARANTINE", " WHERE QRNTINE_ID='" + Request.QueryString["id"] + "'");
         txtQritem.Text = (qr_item + 1).ToString();
     }
     catch (Exception ex)
     {
         Master.ShowError(ex.Message);
         //RadWindowManager1.RadAlert("Access denied.", 400, 150, "Warning", "");
     }
     finally {
         q.Dispose();
     }
 }