private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool insert = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.Add"); bool edit = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.Edit"); bool view = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.View"); ((GridViewCommandColumn)gvDaftarJrnal.Columns["Opr."]).CustomButtons["btnKoreksi"].Visibility = (insert) ? GridViewCustomButtonVisibility.AllDataRows : GridViewCustomButtonVisibility.Invisible; ((GridViewCommandColumn)gvDaftarJrnal.Columns["Opr."]).CustomButtons["btnKoreksi"].Visibility = (edit) ? GridViewCustomButtonVisibility.AllDataRows : GridViewCustomButtonVisibility.Invisible; if (view == false) { Response.Redirect("~/Default.aspx"); } }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; DdlBll ddlBll = new DdlBll(); MasterSektorKemitraanBll mitraBll = new MasterSektorKemitraanBll(); MasterKantorCabangBll cabangBll = new MasterKantorCabangBll(); CityIndexBll cityBll = new CityIndexBll(); Hashtable param = new Hashtable(); var identitasComboData = ddlBll.GetComboItem("ddl_identity_type"); var sektorKemitraanComboData = mitraBll.GetData(new Hashtable()); var cityComboData = cityBll.GetDataByBranch(branchCode); var jenisKredit = ddlBll.getJenisKreditHibah(); var companyKind = ddlBll.getComboCompanyKind(param); var homeOwnership = ddlBll.getComboHomeOwner(param); var education = ddlBll.getComboEducation(param); var maritalStatus = ddlBll.getComboMarital(param); ((GridViewDataComboBoxColumn)gvPermohonan.Columns["identification_type"]).PropertiesComboBox.TextField = "ddl_item"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["identification_type"]).PropertiesComboBox.ValueField = "ddl_value"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["identification_type"]).PropertiesComboBox.DataSource = identitasComboData; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["requestor_city_id"]).PropertiesComboBox.TextField = "city_name"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["requestor_city_id"]).PropertiesComboBox.ValueField = "city_appcode"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["requestor_city_id"]).PropertiesComboBox.DataSource = cityComboData; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["sector_id"]).PropertiesComboBox.TextField = "sector_name"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["sector_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["sector_id"]).PropertiesComboBox.DataSource = sektorKemitraanComboData; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["company_kind_id"]).PropertiesComboBox.TextField = "description"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["company_kind_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["company_kind_id"]).PropertiesComboBox.DataSource = companyKind; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["credit_kind_id"]).PropertiesComboBox.TextField = "descr"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["credit_kind_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["credit_kind_id"]).PropertiesComboBox.DataSource = jenisKredit; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["education_lv_id"]).PropertiesComboBox.TextField = "description"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["education_lv_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["education_lv_id"]).PropertiesComboBox.DataSource = education; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["marital_status_id"]).PropertiesComboBox.TextField = "description"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["marital_status_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["marital_status_id"]).PropertiesComboBox.DataSource = maritalStatus; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["home_ownership_id"]).PropertiesComboBox.TextField = "description"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["home_ownership_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPermohonan.Columns["home_ownership_id"]).PropertiesComboBox.DataSource = homeOwnership; }
private void GetData() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; string tglMulai = DateTime.Parse(txtTanggalDari.Text).ToString("dd/MM/yyyy"); string tglSampai = DateTime.Parse(txtTanggalHingga.Text).ToString("dd/MM/yyyy"); int program_id = Convert.ToInt32(cbbJenisProgram.Value); string NoBukti = txtNoBkti.Text.Trim() ?? ""; var data = bll.GetDataJurnalKasBank(Convert.ToInt32(branchCode), tglMulai, tglSampai, program_id, NoBukti); gvDaftarJrnal.DataSource = data; gvDaftarJrnal.DataBind(); gvDaftarJrnal.GroupBy(gvDaftarJrnal.Columns["NoBukti"]); gvDaftarJrnal.ExpandAll(); }
private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool insert = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.Pencairan.Add"); bool edit = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.Pencairan.Add"); bool view = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.Pencairan.Add"); btnSimpan.Visible = insert; if (view == false) { Response.Redirect("~/Default.aspx"); } }
private void GetData() { Penyaluran penyaluran = new Penyaluran(); penyaluran = (Penyaluran)Session["penyaluran"]; hfId.Value = penyaluran.IdPemohon.ToString(); hfNama.Value = penyaluran.Nama; hfNil.Value = penyaluran.NilaiPengajuan.ToString(); hfNo.Value = penyaluran.No; var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; int idPermohonan = penyaluran.IdPemohon; var data = new VerifikasiBll().GetData(Convert.ToInt32(branchCode)); if (data.Rows.Count > 0) { txtPermintaanBayar.Text = data.Rows[0]["permintaan_bayar"].ToString(); txtVerifikasi.Text = data.Rows[0]["verifikasi"].ToString(); txtPenyetuju.Text = data.Rows[0]["penyetujuan"].ToString(); dateTglPenyaluran.Date = DateTime.Today; } txtUsulanBantuan.Text = String.Format(("{0:#,##}.00"), penyaluran.NilaiPengajuan); try { decimal sisa = bll.GetSisaPenyaluran(idPermohonan); if (sisa == 0) { lblsisaPEnyaluran.Text = "0.00"; } else { lblsisaPEnyaluran.Text = String.Format("{0:#,##}.00", sisa); } txtNilaiPenyaluran.Text = sisa.ToString(); } catch { } txtNamaPemohon.Text = penyaluran.Nama.ToString(); txtKepada.Text = penyaluran.Nama.ToString(); txtNoPemohon.Text = penyaluran.No.ToString(); }
private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool insert = RoleCheck.CheckRoleView(userRoles, "ADM.AKUN.MapBankCOAJBL.Add"); bool edit = RoleCheck.CheckRoleView(userRoles, "ADM.AKUN.MapBankCOAJBL.Edit"); bool view = RoleCheck.CheckRoleView(userRoles, "ADM.AKUN.MapBankCOAJBL.View"); //((GridViewCommandColumn)gvPermohonan.Columns["opr"]).ShowNewButton = insert; ((GridViewCommandColumn)gvCoaJenisBinaling.Columns["Opr."]).ShowEditButton = edit; if (view == false) { Response.Redirect("~/Default.aspx"); } btnSubmit.Visible = insert; }
protected void Page_Load(object sender, EventArgs e) { roleAuth(); if (!IsPostBack) { InitCombo(); deTglBayar.MinDate = new BLL.Administer.ClosingBll().GetLastClose().AddDays(1); deTglBayar.Date = DateTime.Today; cbbCoa.SelectedIndex = 0; var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; gvDetailPembayaran.DataSource = new Pertamina.PKBL.BLL.Akuntansi.PenyaluranBLDetailBll().GetDataSaldo(branchCode, 1); gvDetailPembayaran.DataBind(); } }
private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool view = RoleCheck.CheckRoleView(userRoles, "Menu.Akuntansi"); btnCancelConfirm.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.PK.Pembayaran.Add"); btnConfirmYes.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.PK.Pembayaran.Add"); btnSubmit.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.PK.Pembayaran.Add"); btnUpdate.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.PK.Pembayaran.Add"); if (view == false) { Response.Redirect("~/Default.aspx"); } }
private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool view = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.DiskonJasa.View"); //((GridViewCommandColumn)gvPermohonan.Columns["opr"]).ShowNewButton = insert; //((GridViewCommandColumn)gvBankCOA.Columns["Opr."]).ShowEditButton = edit; //((GridViewDataColumn)gvPenyaluran.Columns["Opr."]).ShowEditButton = edit; //btnSubmit.Visible = insert; if (view == false) { Response.Redirect("~/Default.aspx"); } //btnSubmit.Visible = insert; }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var akun = bll.GetAkun(Convert.ToInt32(branchCode)); var lawan = bll.GetLawanAkun(Convert.ToInt32(Session["program"])); cbbAkun.DataSource = akun; cbbAkun.TextField = "coa_display"; cbbAkun.ValueField = "account_id"; cbbAkun.DataBind(); cbbLawan.DataSource = lawan; cbbLawan.TextField = "coa_display"; cbbLawan.ValueField = "account_id"; cbbLawan.DataBind(); }
private void roleAuth() { var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList; bool insert = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.Add"); bool edit = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.Edit"); bool view = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.View"); bool delete = RoleCheck.CheckRoleView(userRoles, "AKUN.JURNAL.Adjusment.Delete");; btnTambah.Visible = insert; ((GridViewCommandColumn)gvDetailKas.Columns["opr"]).ShowEditButton = edit; ((GridViewCommandColumn)gvDetailKas.Columns["opr"]).ShowDeleteButton = delete; if (view == false) { Response.Redirect("~/Default.aspx"); } }
private void GetGrid() { Penyaluran penyaluran = new Penyaluran(); penyaluran = (Penyaluran)Session["penyaluran"]; var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; gvPenyaluranSaldo.DataSource = ((new PenyaluranBLDetailBll()).GetDataSaldo(branchCode, 2)); gvPenyaluranSaldo.DataBind(); int idPermohonan = penyaluran.IdPemohon; gvPenyaluran.DataSource = bll.GetDetailPenyaluran(idPermohonan); gvPenyaluran.DataBind(); }
private void GetData() { var mulai = Convert.ToDateTime(txtTanggal1.Value).ToString("dd/MM/yyyy"); var akhir = Convert.ToDateTime(txtTaggal2.Value).ToString("dd/MM/yyyy"); var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var data = bll.GetJurnal(mulai, akhir, branchCode); Session["tdbnk"] = data; gvDaftarTransfer.DataSource = data; gvDaftarTransfer.DataBind(); gvDaftarTransfer.GroupBy(gvDaftarTransfer.Columns["NoBukti"]); gvDaftarTransfer.ExpandAll(); }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; DdlBll ddlBll = new DdlBll(); var comboPersetujuan = ddlBll.GetComboItem("ddl_input_persetujuan"); var jenisKredit = ddlBll.getJenisKreditHibah(); ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["creditkind_id"]).PropertiesComboBox.TextField = "descr"; ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["creditkind_id"]).PropertiesComboBox.ValueField = "id"; ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["creditkind_id"]).PropertiesComboBox.DataSource = jenisKredit; ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["status"]).PropertiesComboBox.TextField = "ddl_item"; ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["status"]).PropertiesComboBox.ValueField = "ddl_value"; ((GridViewDataComboBoxColumn)gvPersetujuan.Columns["status"]).PropertiesComboBox.DataSource = comboPersetujuan; }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var ddl = new Pertamina.PKBL.BLL.DdlBll(); var kota = new Pertamina.PKBL.BLL.Administer.CityIndexBll().GetDataByBranch(branchCode); var penyalur = ddl.getComboSupplier(branchCode.ToString()); var sektor = new Pertamina.PKBL.BLL.Kemitraan.MasterSektorKemitraanBll().GetData(new Hashtable()); var bunga = ddl.getJenisBunga(); var pinjaman = ddl.getJenisKredit(); var yesno = ddl.GetComboItem("ddl_administrasi"); cbbKota.DataSource = kota; cbbKota.TextField = "city_name"; cbbKota.ValueField = "city_appcode"; cbbKota.DataBind(); cbbPenyalur.DataSource = penyalur; cbbPenyalur.TextField = "supplier_name"; cbbPenyalur.ValueField = "id"; cbbPenyalur.DataBind(); cbbSektorUSaha.DataSource = sektor; cbbSektorUSaha.TextField = "sector_name"; cbbSektorUSaha.ValueField = "id"; cbbSektorUSaha.DataBind(); cbbSistemBunga.DataSource = bunga; cbbSistemBunga.TextField = "descr"; cbbSistemBunga.ValueField = "id"; cbbSistemBunga.DataBind(); cbbJenisPinjaman.DataSource = pinjaman; cbbJenisPinjaman.TextField = "descr"; cbbJenisPinjaman.ValueField = "id"; cbbJenisPinjaman.DataBind(); cbbProdukUnggulan.DataSource = yesno; cbbProdukUnggulan.TextField = "ddl_item"; cbbProdukUnggulan.ValueField = "ddl_value"; cbbProdukUnggulan.DataBind(); cbbMitraTerpilih.DataSource = yesno; cbbMitraTerpilih.TextField = "ddl_item"; cbbMitraTerpilih.ValueField = "ddl_value"; cbbMitraTerpilih.DataBind(); }
private void initCombo() { var date = Convert.ToInt32(DateTime.Today.Year.ToString()); DataTable dt = new DataTable(); dt.Columns.Add("text", typeof(string)); dt.Columns.Add("value", typeof(string)); DataRow dr; for (int i = date; i >= 1990; i--) { dr = dt.NewRow(); dr["text"] = i.ToString(); dr["value"] = i; dt.Rows.Add(dr); } cbbTahun.DataSource = dt; cbbTahun.TextField = "text"; cbbTahun.ValueField = "value"; cbbTahun.DataBind(); cbbTahun.SelectedIndex = 0; var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; if (branchCode == "9900") { var cabang = new Pertamina.PKBL.BLL.Administer.MasterKantorCabangBll().GetData(new Hashtable()); cbbBranch.DataSource = cabang; cbbBranch.TextField = "branch_name"; cbbBranch.ValueField = "branch_code"; cbbBranch.DataBind(); cbbBranch.SelectedItem = cbbBranch.Items.FindByValue("9900"); } else { var pengirim = new Pertamina.PKBL.BLL.Akuntansi.TransferDanaBankBll().GetKantorCabang(Convert.ToInt32(branchCode)); cbbBranch.DataSource = pengirim; cbbBranch.TextField = "branch_name"; cbbBranch.ValueField = "branch_code"; cbbBranch.DataBind(); cbbBranch.SelectedIndex = 0; } }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var lawan = bll.GetLawanAkun(Request.QueryString["Proposal"].ToString()); var akun = bll.GetAkun(Convert.ToInt32(branchCode), Request.QueryString["Proposal"].ToString()); cbbNamaAkun.DataSource = akun; cbbNamaAkun.TextField = "display_coa"; cbbNamaAkun.ValueField = "account_id"; cbbNamaAkun.DataBind(); cbbNamaAkun.SelectedIndex = 0; cbbLawanAkun.DataSource = lawan; cbbLawanAkun.TextField = "coa_display"; cbbLawanAkun.ValueField = "account_id"; cbbLawanAkun.DataBind(); cbbLawanAkun.SelectedIndex = 0; }
protected void gvDetailDiskonJasa_CommandButtonInitialize(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCommandButtonEventArgs e) { int flag = Convert.ToInt32(gvDetailDiskonJasa.GetRowValues(e.VisibleIndex, "flag")); if (e.ButtonType == DevExpress.Web.ASPxGridView.ColumnCommandButtonType.Edit) { if (flag == 1) { e.Visible = true; } else { e.Visible = false; } e.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.PK.DiskonJasa.Add"); } }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var ddl = new Pertamina.PKBL.BLL.DdlBll(); var kota = new Pertamina.PKBL.BLL.Administer.CityIndexBll().GetDataByBranch(branchCode); var penyalur = ddl.getComboSupplier(branchCode.ToString()); var sektor = new Pertamina.PKBL.BLL.Kemitraan.MasterSektorKemitraanBll().GetData(new Hashtable()); cbbKota.DataSource = kota; cbbKota.TextField = "city_name"; cbbKota.ValueField = "city_appcode"; cbbKota.DataBind(); cbbPenyalur.DataSource = penyalur; cbbPenyalur.TextField = "supplier_name"; cbbPenyalur.ValueField = "id"; cbbPenyalur.DataBind(); cbbSektorUsaha.DataSource = sektor; cbbSektorUsaha.TextField = "sector_name"; cbbSektorUsaha.ValueField = "id"; cbbSektorUsaha.DataBind(); }
public void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; cbbStatus.Items.Insert(0, new ListEditItem("--ALL--", "0")); cbbStatus.Items.Insert(1, new ListEditItem("DALAM PROSES", "I")); cbbStatus.Items.Insert(2, new ListEditItem("DITERIMA", "P")); cbbStatus.Items.Insert(3, new ListEditItem("DITOLAK", "R")); cbbStatus.Items.Insert(4, new ListEditItem("DISETUJUI", "A")); cbbStatus.SelectedIndex = 0; BLL.Administer.MasterKantorCabangBll bll = new BLL.Administer.MasterKantorCabangBll(); var data = bll.GetData(new System.Collections.Hashtable()); var dr = data.NewRow(); dr["branch_name"] = "- All -"; dr["branch_code"] = 0; data.Rows.InsertAt(dr, 0); DataView dv = new DataView(data); if (branchCode != "9900") { dv.RowFilter = "branch_code=" + branchCode.ToString(); } cbbRegion.DataSource = dv; cbbRegion.ValueField = "branch_code"; cbbRegion.TextField = "branch_name"; cbbRegion.DataBind(); cbbRegion.SelectedIndex = 0; }
public void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; CityIndexBll city = new CityIndexBll(); DdlBll combo = new DdlBll(); var cityComboData = city.GetDataByBranch(branchCode); var lahanUsaha = combo.GetComboItem("ddl_workplace"); var pembukuan = combo.GetComboItem("ddl_pembukuan"); var pinjaman = combo.GetComboItem("ddl_pinjaman"); cbbKota.TextField = "city_name"; cbbKota.ValueField = "city_appcode"; cbbKota.DataSource = cityComboData; cbbKota.DataBind(); cbbLahanUsaha.TextField = "ddl_item"; cbbLahanUsaha.ValueField = "ddl_value"; cbbLahanUsaha.DataSource = lahanUsaha; cbbLahanUsaha.DataBind(); //pembukuan.Rows.Add(new object[] { "-", 0 }); cbbAdmPembukuan.TextField = "ddl_item"; cbbAdmPembukuan.ValueField = "ddl_value"; cbbAdmPembukuan.DataSource = pembukuan; cbbAdmPembukuan.DataBind(); cbbAdmPembukuan.SelectedItem = cbbAdmPembukuan.Items.FindByText("Tidak"); //pinjaman.Rows.Add(new object[] { "-", 0 }); cbbPinjaman.TextField = "ddl_item"; cbbPinjaman.ValueField = "ddl_value"; cbbPinjaman.DataSource = pinjaman; cbbPinjaman.DataBind(); cbbPinjaman.SelectedItem = cbbPinjaman.Items.FindByText("Tidak"); }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; var comboCabang = bll.GetData(new Hashtable()); var row = comboCabang.NewRow(); row["branch_name"] = "- All -"; row["branch_code"] = 0; comboCabang.Rows.InsertAt(row, 0); DataView dv = new DataView(comboCabang); if (branchCode != "9900") { dv.RowFilter = "branch_code=" + branchCode.ToString(); } cbbCabang.DataSource = dv;// comboCabang; cbbCabang.TextField = "branch_name"; cbbCabang.ValueField = "branch_code"; cbbCabang.DataBind(); cbbCabang.SelectedIndex = 0; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetData(); if (Session["bl"] != null) { if (Session["bl"].ToString() == "0") { txtKetBayar.Enabled = false; ((GridViewCommandColumn)gvDetailKas.Columns["opr"]).ShowEditButton = false; txtKepada.Enabled = false; deTglBukti.Enabled = false; Session["bl"] = null; } } } btnTambah.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.JURNAL.KasBank.Edit"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; DataTable dt = new DataTable(); DataRow detail; DataView view; dt.Columns.Add("id", typeof(int)); dt.Columns.Add("Category", typeof(string)); if (branchCode == "9900") { detail = dt.NewRow(); detail["id"] = 0; detail["Category"] = "--Select--"; dt.Rows.Add(detail); detail = dt.NewRow(); detail["id"] = 1; detail["Category"] = "Transfer Pusat ke Cabang - PK"; dt.Rows.Add(detail); detail = dt.NewRow(); detail["id"] = 2; detail["Category"] = "Transfer Pusat ke Cabang - BL"; dt.Rows.Add(detail); view = new DataView(dt); cbbDrop.DataSource = view; cbbDrop.ValueField = "id"; cbbDrop.TextField = "Category"; cbbDrop.DataBind(); cbbDrop.SelectedIndex = 0; } else { detail = dt.NewRow(); detail["id"] = 0; detail["Category"] = "--Select--"; dt.Rows.Add(detail); detail = dt.NewRow(); detail["id"] = 1; detail["Category"] = "Transfer Cabang Ke Pusat - PK"; dt.Rows.Add(detail); detail = dt.NewRow(); detail["id"] = 2; detail["Category"] = "Transfer Cabang Ke Pusat - BL"; dt.Rows.Add(detail); view = new DataView(dt); cbbDrop.DataSource = view; cbbDrop.ValueField = "id"; cbbDrop.TextField = "Category"; cbbDrop.DataBind(); cbbDrop.SelectedIndex = 0; } GetData(); } btnApprove.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.TransferDanaBank.Add"); btnCacel.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.TransferDanaBank.Add"); btnProses.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.TransferDanaBank.Add"); }
private void initCombo() { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; DataTable dt = new DataTable(); DataRow dr; DataView view; dt.Columns.Add("value", typeof(string)); dt.Columns.Add("text", typeof(string)); dr = dt.NewRow(); dr["value"] = "all"; dr["text"] = "--semua--"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["value"] = "KB"; dr["text"] = "Kas / Bank"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["value"] = "GL"; dr["text"] = "Umum"; dt.Rows.Add(dr); view = new DataView(dt); cbbJenis.DataSource = view; cbbJenis.TextField = "text"; cbbJenis.ValueField = "value"; cbbJenis.DataBind(); if (branchCode == "9900" || branchCode == "9999") { var data = new Pertamina.PKBL.BLL.Administer.MasterKantorCabangBll().GetData(new Hashtable()); var cabang = data.Clone(); cabang.Columns["branch_code"].DataType = typeof(string); foreach (DataRow item in data.Rows) { cabang.ImportRow(item); } dr = cabang.NewRow(); dr["branch_name"] = "--semua--"; dr["branch_code"] = "all"; cabang.Rows.InsertAt(dr, 0); cbbBranch.DataSource = cabang; cbbBranch.TextField = "branch_name"; cbbBranch.ValueField = "branch_code"; cbbBranch.DataBind(); cbbBranch.SelectedItem = cbbBranch.Items.FindByValue("all"); } else { var pengirim = new Pertamina.PKBL.BLL.Akuntansi.TransferDanaBankBll().GetKantorCabang(Convert.ToInt32(branchCode)); cbbBranch.DataSource = pengirim; cbbBranch.TextField = "branch_name"; cbbBranch.ValueField = "branch_code"; cbbBranch.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { rbConfirm.SelectedValue = "0"; InitCombo(); } btnSubmit.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "BL.Permohonan.Edit"); }
protected void btnSubmit_Click(object sender, EventArgs e) { ActivityLog log = new ActivityLog(); ActivityLogBll logBll = new ActivityLogBll(); string host = Request.UserHostName; string ipaddress = Request.UserHostAddress; string userName = Session["user"].ToString(); if (String.IsNullOrEmpty(ipaddress)) { ipaddress = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; } log.HostName = host; log.IPAddress = ipaddress; log.Action = "Penyaluran BL "; log.UserName = userName; try { Penyaluran penyaluran = new Penyaluran(); penyaluran = (Penyaluran)Session["penyaluran"]; decimal sisa = bll.GetSisaPenyaluran(Convert.ToInt32(hfId.Value)); var NilaiPenyaluran = Convert.ToDecimal(txtNilaiPenyaluran.Text); if (sisa <= 0) { lblInfo.Text = "Penyaluran Telah Lunas"; lblInfo.ForeColor = System.Drawing.Color.Red; log.Type = "F"; log.Description = log.Action + ' ' + "Gagal oleh id" + ' ' + userName; } else if (sisa - NilaiPenyaluran < 0) { lblInfo.Text = "Nominal melebihi batas Nilai yang Disetujui"; lblInfo.ForeColor = System.Drawing.Color.Red; log.Type = "F"; log.Description = log.Action + ' ' + "Gagal oleh id" + ' ' + userName; } else { var tglPenyaluran = Convert.ToDateTime(dateTglPenyaluran.Value).ToString("dd/MM/yyyy"); var usulanBantuan = txtUsulanBantuan.Text; var noPemohon = txtNoPemohon.Text; var NamaPemohon = txtNamaPemohon.Text; var Kepada = txtKepada.Text; var PermintaanBayar = txtPermintaanBayar.Text; var Verifikasi = txtVerifikasi.Text; var Penyetuju = txtPenyetuju.Text; var DeskripsiBantuan = txtDeskripsiBantuan.Text; var NamaAkun = cbbNamaAkun.Value.ToString(); var LawanAkun = cbbLawanAkun.Value.ToString(); bool isJurnal = checkAkanDiJurnal.Checked; bool isKoreksi = checkKoreksi.Checked; int idPermohonan = Convert.ToInt32(hfId.Value); string created_by = Session["user"].ToString(); var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; Hashtable ht = new Hashtable(); ht.Add("@TglPenyaluran-varchar-20", tglPenyaluran); ht.Add("@NoPemohon-nvarchar-max", noPemohon); ht.Add("@idPermohonan-int", idPermohonan); ht.Add("@Kepada-nvarchar-max", Kepada); ht.Add("@DeskripsiBantuan-nvarchar-max", DeskripsiBantuan); ht.Add("@NilaiPenyaluran-decimal", Convert.ToDecimal(txtNilaiPenyaluran.Text)); ht.Add("@IdNamaAkun-varchar-50", NamaAkun); ht.Add("@IdLawanAkun-varchar-50", LawanAkun); ht.Add("@IsJurnal-bit", isJurnal); ht.Add("@isKoreksi-bit", isKoreksi); ht.Add("@CreatedBy-varchar-50", created_by); ht.Add("@branch_code-int", branchCode); ht.Add("@permintaanbayar-varchar-100", PermintaanBayar); ht.Add("@verifikasi-varchar-100", Verifikasi); ht.Add("@penyetuju-varchar-100", Penyetuju); bll.InsertData(ht); log.Type = "S"; log.Description = log.Action + ' ' + "dengan No. Pemohon" + ' ' + noPemohon + ' ' + "Sukses oleh id" + ' ' + userName; lblInfo.Text = "Sukses"; lblInfo.ForeColor = System.Drawing.Color.Green; } GetData(); GetGrid(); } catch (Exception ex) { log.Type = "E"; log.Description = "Detail Pencairan Gagal : " + ex.Message; lblInfo.Text = "Mohon Isi Semua Field"; lblInfo.ForeColor = System.Drawing.Color.Red; } finally { logBll.InsertActivity(log); } }
protected void btnSave_Click(object sender, EventArgs e) { ActivityLog log = new ActivityLog(); ActivityLogBll logBll = new ActivityLogBll(); string host = Request.UserHostName; string ipaddress = Request.UserHostAddress; string userName = Session["user"].ToString(); if (String.IsNullOrEmpty(ipaddress)) { ipaddress = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; } log.HostName = host; log.IPAddress = ipaddress; log.Action = "Upload Penyaluran BL"; log.UserName = userName; try { DateTime lastclose = new BLL.Administer.ClosingBll().GetLastClose(); if (lastclose > deTglRealisasi.Date) { lblKeterangan.ForeColor = System.Drawing.Color.Red; lblKeterangan.Text = "Tanggal realisasi sudah di closing"; log.Type = "F"; log.Description = "Tanggal realisasi sudah di closing"; return; } var data = (DataTable)Session["bloktoupload"]; try { data.Columns.Remove("Message"); } catch (Exception) { } System.Collections.Hashtable parameters = new System.Collections.Hashtable(); parameters.Add("@coaBank-varchar-50", cbbNamaAkun.SelectedItem.Value); parameters.Add("@tglPenyaluran-varchar-30", deTglRealisasi.Date.ToString("dd/MM/yyyy")); parameters.Add("@user-varchar-200", Session["user"].ToString()); parameters.Add("@branch_code-int", ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1); bll.UploadData(parameters, data); ViewState["msg"] = "<script>alert('Upload " + data.Rows.Count.ToString() + " data penyaluran BL berhasil');</script>"; lblKeterangan.ForeColor = System.Drawing.Color.Green; lblKeterangan.Text = "Upload Data Berhasil"; btnSave.Visible = false; log.Type = "S"; log.Description = log.Action + ' ' + data.Rows.Count.ToString() + ' ' + "Row, Sukses oleh id" + ' ' + userName; } catch (Exception ex) { log.Type = "E"; log.Description = "Upload Penyaluran BL Error : " + ex.Message; } finally { logBll.InsertActivity(log); } }
protected bool RowCheck(DataRow item, DataColumnCollection cols, out DataRow dr) { var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1; bool isErrorExists = false; var decimalRegex = @"^\d*\.?\d*$"; var dateRegex = @"^([0]?[0-9]|[12][0-9]|[3][01])[./-]([0]?[1-9]|[1][0-2])[./-]([0-9]{4}|[0-9]{2})$"; var numberRegex = @"^[0-9]*$"; var textRegex = @"[0-9a-zA-Z;: ,.\/\\=-_+|~!@#$%\^&*()\[\]]"; var oneNumberRegex = @"^[0-9]$"; var fourNumberRegex = @"^[0-9]{4}$"; var allstring = ""; foreach (DataColumn col in cols) { allstring += item[col].ToString(); } if (!Regex.IsMatch(allstring, textRegex)) { item["Message"] = "Terdapat karakter ilegal;"; isErrorExists = true; dr = item; return(!isErrorExists); } try { decimal.Parse(item["NominalBayar"].ToString().Trim()); } catch (Exception) { isErrorExists = true; item["Message"] = item["Message"].ToString() + " Format NominalBayar tidak sesuai;"; } if (!Regex.IsMatch(item["NoMitra"].ToString(), numberRegex)) { item["Message"] = item["Message"].ToString() + " Format NoMitra tidak sesuai;"; isErrorExists = true; } if (item["isExists"].ToString() != "1") { item["Message"] = item["Message"].ToString() + " NoMitra tidak ada;"; isErrorExists = true; } if (item["branch_code"].ToString().Trim() != branchCode) { item["Message"] = item["Message"].ToString() + " Mitra tidak sesuai region;"; isErrorExists = true; } dr = item; return(!isErrorExists); }
protected void Page_Load(object sender, EventArgs e) { roleAuth(); if (!IsPostBack) { deTglBukti.Date = DateTime.Today; Session["Report"] = bll.DetailTable; } GetData(); btnSimpan.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.JURNAL.Adjusment.Add"); btnTambah.Visible = RoleCheck.CheckRoleView(((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList, "AKUN.JURNAL.Adjusment.Add"); }