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");
}
