private void BindData()
        {
            Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter();

            Session["workflowDt"] = (PenjaminanDataset.m_workflowDataTable)ta.GetData();
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            //inisiasi u/ kebuutuhan tbl t_workflow

            var user = (PenjaminanDataset.UserProfileRow)Session["UserProfile"];

            tSquence = Convert.ToInt32(user.role);
            int    tModeule = eID;
            string Module   = "mitra";
            int    tMwf     = 0;
            int    tUrutan1 = 0;
            int    tUrutan2 = 0;

            //buat validasi
            if (tSquence != 1)
            {
                tUrutan1 = tSquence - 1;
                Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter taVal1 = new Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter();
                PenjaminanDataset.m_workflowDataTable dtVal1   = taVal1.GetDataTwf(tUrutan1, Module);
                PenjaminanDataset.m_workflowDataTable dtModule = taVal1.GetDataModule(Module);

                foreach (PenjaminanDataset.m_workflowRow drX in taVal1.GetDataModule(Module))
                {
                    var pembanding = drX.sequence - 1;

                    //get data buat validasi jancuk
                    if (pembanding == tUrutan1)
                    {
                        Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter taVal2 = new Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter();
                        PenjaminanDataset.t_workflowDataTable dtVal2 = taVal2.GetDataValidasi(1, drX.sequence - 1, eID);
                        if (dtVal2.Count > 0)
                        {
                            tMwf = dtVal1[0].idModule;

                            Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter();
                            PenjaminanDataset.t_workflowDataTable dtWF = ta.GetDataByforUpdateStatusMitra(tMwf, eID);

                            ta.Insert(tMwf, tModeule, drX.sequence, tSquence, "Y", textKeterangan.Value, user.id.ToString(), DateTime.Now, null, null, "0");

                            PenjaminanDataset.t_workflowDataTable dtWF2 = ta.GetDataByforUpdateStatusMitra(tMwf, eID);
                            string type = "aproove";
                            if (txtCalonMitra.Value == "")
                            {
                                throw new Exception("Field Calon Mitra is Mandatory");
                            }
                            //buat validasi apakah dia sudah terapprove semua atau tidak
                            if (dtModule.Count == dtWF2.Count)
                            {
                                m_mitra.UpdateStatus(eID, textKeterangan.Value, type);
                            }
                            Response.Redirect("/Penjaminan/ViewMitra.aspx");
                        }
                        else
                        {
                            string message = "Tidak Bisa Approve, karena level " + tUrutan1 + " Belum Approve!";
                            //ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('" + message + "');", true);
                            Response.Write("<script>alert('" + message + "');window.location = '/Penjaminan/ViewMitra.aspx';</script>");

                            //Response.Redirect("/Penjaminan/ViewMitra.aspx");
                        }
                    }
                }
            }
            else
            {
                Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter taVal1 = new Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter();
                PenjaminanDataset.m_workflowDataTable dtVal1 = taVal1.GetDataTwf(tSquence, Module);
                if (dtVal1.Count > 0)
                {
                    tMwf = dtVal1[0].id;

                    Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter();

                    ta.Insert(tMwf, tModeule, tSquence, tSquence, "Y", textKeterangan.Value, user.id.ToString(), DateTime.Now, null, null, "0");

                    string type = "aproove";
                    if (txtCalonMitra.Value == "")
                    {
                        throw new Exception("Field Calon Mitra is Mandatory");
                    }
                    m_mitra.UpdateStatus(eID, textKeterangan.Value, type);

                    Response.Redirect("/Penjaminan/ViewMitra.aspx");
                }
            }
            ////buat dapetin fk_m_workflow
            //Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter tax = new Models.PenjaminanDatasetTableAdapters.m_workflowTableAdapter();
            //PenjaminanDataset.m_workflowDataTable dtX = tax.GetDataTwf(tSquence, Module);
            //if(dtX.Count > 0)
            //{
            //    tMwf = dtX[0].id;
            //}


            //Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.t_workflowTableAdapter();

            //ta.Insert(tMwf, tModeule, tSquence, "Y", textKeterangan.Value, user.id.ToString(), DateTime.Now, null, "0");

            //////buat validasi
            ////PenjaminanDataset.t_workflowDataTable dt = ta.GetDataforAction(tMwf, eID);
            ////if(dt.Count > 0)
            ////{
            ////    ta.Insert(tMwf, tModeule, tSquence, "Y", textKeterangan.Value, user.id.ToString(), DateTime.Now,null,"0");
            ////}

            //string type = "aproove";
            //if (txtCalonMitra.Value == "")
            //{
            //    throw new Exception("Field Calon Mitra is Mandatory");
            //}
            //m_mitra.UpdateStatus(eID,textKeterangan.Value, type);
        }