protected void btnSubmit_Click(object sender, EventArgs e)
    {
        PIP_MAT_TRANSFTableAdapter issue = new PIP_MAT_TRANSFTableAdapter();

        try
        {
            string cat_id   = ddlTransType.SelectedValue;
            string doc_name = string.Empty;
            if (ddlTransDocName.Visible)
            {
                doc_name = ddlTransDocName.SelectedItem.Text;
            }
            issue.InsertQuery(
                decimal.Parse(Session["PROJECT_ID"].ToString()),
                txtTransfNo.Text, txtCreateDate.SelectedDate,
                txtCreateBy.Text,
                Decimal.Parse(ddFrom.SelectedValue.ToString()),
                Decimal.Parse(ddTo.SelectedValue.ToString()),
                txtRemarks.Text,
                ddScope.SelectedValue.ToString(), decimal.Parse(cat_id), doc_name);

            Master.ShowMessage("Material transfer created.");
        }
        catch (Exception ex)
        {
            Master.ShowWarn(ex.Message);
        }
        finally
        {
            issue.Dispose();
        }
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        PIP_MAT_TRANSFTableAdapter issue = new PIP_MAT_TRANSFTableAdapter();

        try
        {
            if (decimal.Parse(Session["PROJECT_ID"].ToString()) == -1)
            {
                Response.Redirect(Request.RawUrl);
                return;
            }

            if (txtTransfNo.Text == "")
            {
                Master.ShowError("Select Valid Request Number");
                return;
            }

            issue.InsertQuery(
                decimal.Parse(Session["PROJECT_ID"].ToString()),
                txtTransfNo.Text, txtCreateDate.SelectedDate,
                txtCreateBy.Text,
                Decimal.Parse(ddFrom.SelectedValue.ToString()),
                Decimal.Parse(ddTo.SelectedValue.ToString()),
                txtRemarks.Text,
                Decimal.Parse(ddlReqNo.SelectedValue.ToString()));

            Master.ShowMessage(txtTransfNo.Text + " : Material transfer created.");
        }
        catch (Exception ex)
        {
            Master.ShowWarn(ex.Message);
        }
        finally
        {
            issue.Dispose();
        }
    }