private void InitCombo()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
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" && branchCode != "9999")
{
dv.RowFilter = "branch_code=" + branchCode.ToString();
}
cbbCabang.DataSource = dv;
cbbCabang.ValueField = "branch_code";
cbbCabang.TextField = "branch_name";
cbbCabang.DataBind();
cbbCabang.SelectedIndex = 0;
}
protected void Page_Load(object sender, EventArgs e)
{
roleAuth();
if (!IsPostBack)
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var data = bll.GetDataDetail(Convert.ToInt32(branchCode), Request.QueryString["Proposal"].ToString());
if (data.Rows.Count > 0)
{
var detail = data.Rows[0];
deTglBayar.Date = DateTime.Today;
txtNoRef.Text = "--Generate by System--";
txtNoDebitur.Text = detail["mitraid"].ToString();
txtNama.Text = detail["requestor_name"].ToString();
try
{
deTglAktif.Date = DateTime.Parse(detail["TglRealisasi"].ToString());
}
catch
{
}
txtCatatan.Text = String.Format("Pembayaran atas nama {0} dengan nomor debitur {1}", detail["requestor_name"].ToString(), detail["mitraid"].ToString());
lblConfNama.Text = detail["requestor_name"].ToString();
lblConfNoMitra.Text = detail["mitraid"].ToString();
}
initCombo();
Panel.Visible = false;
}
GetData();
}
private void GetGrid()
{
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();
}
private void InitCombo()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
cbbNamaAkun.DataSource = (new BLL.Akuntansi.PenyaluranBLDetailBll()).GetDataSaldo(branchCode, 2);
cbbNamaAkun.TextField = "Display_COA";
cbbNamaAkun.ValueField = "COA";
cbbNamaAkun.DataBind();
var jenisBlBll = new MasterBLBll();
var binalingComboData = jenisBlBll.GetDataActive();
cbbJBL.TextField = "name";
cbbJBL.ValueField = "id";
cbbJBL.DataSource = binalingComboData;
cbbJBL.DataBind();
var citydata = new BLL.Administer.CityIndexBll().GetDataByBranch(branchCode);
cbbKota2.TextField = "city_appcode";
cbbKota2.ValueField = "city_appcode";
cbbKota2.DataSource = citydata;
cbbKota2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
roleAuth();
if (!IsPostBack)
{
txtDari.Date = new BLL.Administer.ClosingBll().GetLastClose().AddDays(1);
txtHingga.Date = DateTime.Today;
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
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" && branchCode != "9999")
{
dv.RowFilter = "branch_code=" + branchCode.ToString();
}
cbbCabang.DataSource = dv;
cbbCabang.ValueField = "branch_code";
cbbCabang.TextField = "branch_name";
cbbCabang.DataBind();
cbbCabang.SelectedIndex = 0;
}
}
private void GetData()
{
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();
var detail = bll.GetDataKartu(Request.QueryString["Proposal"].ToString());
if (detail != null)
{
int currAngsuran = 0;
foreach (DataRow item in detail.Rows)
{
if (Convert.ToInt32(item["AngsuranKe"]) == currAngsuran)
{
item["AngsuranKe"] = " ";
item["HutangPokok"] = "";
item["Bunga"] = " ";
item["Total"] = " ";
item["TglJatuhTempo"] = " ";
}
else
{
currAngsuran = Convert.ToInt32(item["AngsuranKe"]);
}
}
gvReport.DataSource = detail;
gvReport.DataBind();
}
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
gvPenyaluran.DataSource = bll.GetData(branchCode);
gvPenyaluran.DataBind();
}
public void getData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
gridKartuPiutang.DataSource = kpBll.getData(branchCode);
gridKartuPiutang.DataBind();
}
private void initCombo()
{
Penyaluran penyaluran = new Penyaluran();
penyaluran = (Penyaluran)Session["penyaluran"];
if (Session["userprofile"] == null)
{
FormsAuthentication.RedirectToLoginPage();
}
else
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
cbbNamaAkun.DataSource = bll.GetDataSaldo(branchCode, 2);
cbbNamaAkun.TextField = "Display_COA";
cbbNamaAkun.ValueField = "COA";
cbbNamaAkun.DataBind();
checkKoreksi.Checked = false;
checkAkanDiJurnal.Checked = true;
cbbLawanAkun.DataSource = bll.GetDataLawanAkunByBinalingID(penyaluran.IdPemohon);
cbbLawanAkun.TextField = "display_coa";
cbbLawanAkun.ValueField = "account_id";
cbbLawanAkun.DataBind();
}
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
object cari = DBNull.Value;
object tgla = DBNull.Value;
object tgle = DBNull.Value;
if (!string.IsNullOrEmpty(txtCari.Text.Trim()))
{
cari = txtCari.Text;
}
if (deStart.Value != null && deEnd.Value != null)
{
tgla = Convert.ToDateTime(deStart.Value).ToString("dd/MM/yyyy");
tgle = Convert.ToDateTime(deEnd.Value).ToString("dd/MM/yyyy");
}
Hashtable ht = new Hashtable();
ht.Add("@branch_code-int", branchCode);
ht.Add("@cari-varchar-1000", cari);
ht.Add("@tglStart-varchar-20", tgla);
ht.Add("@tglEnd-varchar-20", tgle);
var data = jurnalBll.GetJurnal(ht);
gvJurnal.DataSource = data;
gvJurnal.DataBind();
}
private void InitCombo()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var dt = new DataTable();
dt.Columns.Add("text");
dt.Columns.Add("value");
var newrow = dt.NewRow();
newrow["text"] = "Disetujui";
newrow["value"] = "A";
dt.Rows.Add(newrow);
newrow = dt.NewRow();
newrow["text"] = "Ditolak";
newrow["value"] = "N";
dt.Rows.Add(newrow);
cbbSetuju.DataSource = dt;
cbbSetuju.TextField = "text";
cbbSetuju.ValueField = "value";
cbbSetuju.DataBind();
//var penyalur = (new BLL.DdlBll()).getComboSupplier(new Hashtable());
var penyalur = (new BLL.DdlBll()).getComboSupplier(branchCode.ToString());
cbbPenyalur.TextField = "supplier_name";
cbbPenyalur.Value = "id";
cbbPenyalur.DataSource = penyalur;
cbbPenyalur.DataBind();
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var id = Convert.ToInt32(Session["proposalID"]);
var ret = bll.GetDetailPersetujuan(id);
if (ret.Rows.Count > 0)
{
var data = ret.Rows[0];
if (data["proposal_approved_at"] != DBNull.Value)
{
deTglPersetujuan.Value = Convert.ToDateTime(data["proposal_approved_at"]);
}
txtNama.Text = data["requestor_name"].ToString();
txtNoPenilaian.Text = data["NoForm"].ToString();
txtAlamat.Text = data["requestor_address"].ToString();
txtBunga.Text = data["SukuBUnga"].ToString();
txtJangkaWaktu.Text = data["JangkaWaktu"].ToString();
txtNilaiPengajuan.Text = data["requested_amount"].ToString();
txtNoSrtPermohonan.Text = data["proposal_number"].ToString();
txtKegunaan.Text = data["Kegunaan"].ToString();
txtMaksimalKredit.Text = data["NilaiSetuju"].ToString();
cbPinjamanModalKerja.Text = data["descr"].ToString();
cbPinjamanModalKerja.Checked = true;
}
else
{
Response.Redirect("PersetujuanSurvey.aspx");
}
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
gvPermohonan.DataSource = ((new PengajuanHibahBll()).GetData(branchCode)).DefaultView;
gvPermohonan.DataBind();
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var data = bll.GetData(Convert.ToInt32(branchCode));
gvDiskonJasa.DataSource = data;
gvDiskonJasa.DataBind();
}
protected void gvLihatPanjar_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs 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 = "Insert Panjar";
log.UserName = userName;
try
{
Hashtable ht = new Hashtable();
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
ht.Add("@tglPanjar-varchar-20", DateTime.Parse(e.NewValues["TglPanjar"].ToString()).ToString("dd/MM/yyyy"));
ht.Add("@nama-varchar-99", e.NewValues["Nama"].ToString());
ht.Add("@nip-varchar-30", e.NewValues["nip"].ToString());
ht.Add("@jabatan-varchar-30", e.NewValues["jabatan"].ToString());
ht.Add("@tujuan-varchar-1000", e.NewValues["Tujuan"].ToString());
ht.Add("@keperluan-varchar-1000", e.NewValues["Keperluan"].ToString());
ht.Add("@nilaiPanjar-float", float.Parse(e.NewValues["NilaiPanjar"].ToString()));
ht.Add("@program_id-int", Convert.ToInt32(e.NewValues["program_id"]));
ht.Add("@tglBerangkat-varchar-20", DateTime.Parse(e.NewValues["TglBerangkat"].ToString()).ToString("dd/MM/yyyy"));
ht.Add("@tglKembali-varchar-20", DateTime.Parse(e.NewValues["TglKembali"].ToString()).ToString("dd/MM/yyyy"));
ht.Add("@transportBerangkat-float", float.Parse(e.NewValues["TransportBerangkat"].ToString()));
ht.Add("@transportKembali-float", float.Parse(e.NewValues["TransportKembali"].ToString()));
ht.Add("@dibuatOleh-varchar-20", e.NewValues["DibuatOleh"].ToString());
ht.Add("@user-varchar-99", Session["user"].ToString());
ht.Add("@branch_code-int", Convert.ToInt32(branchCode));
bll.InsertData(ht);
log.Type = "S";
log.Description = log.Action + "Sukses oleh id" + ' ' + userName;
e.Cancel = true;
gvLihatPanjar.CancelEdit();
GetData();
}
catch (Exception ex)
{
log.Type = "E";
log.Description = "Insert Panjar Error : " + ex.Message;
}
finally
{
logBll.InsertActivity(log);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getData();
var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList;
btnUpload.Visible = RoleCheck.CheckRoleView(userRoles, "PK.Penerimaan.Edit");
}
}
private void GetData()
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var data = bll.GetDataPerwabPersetujuan(Convert.ToInt32(branchCode), Session["Nopanjar"].ToString());
txtNama.Text = data["Nama"].ToString();
txtNoRef.Text = "--Generated by System--";
txtNip.Text = data["nip"].ToString();
txtNilai.Text = data["NilaiPanjar"].ToString();
deTanggal.Date = DateTime.Today;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
deTglPersetujuan.Value = DateTime.Today;
InitCombo();
GetData();
var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList;
btnSimpan.Visible = RoleCheck.CheckRoleView(userRoles, "PK.Persetujuan.Edit");
}
}
private void roleAuth()
{
var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList;
bool insert = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.KartuPiutang.Add");
bool edit = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.KartuPiutang.Edit");
bool view = RoleCheck.CheckRoleView(userRoles, "AKUN.PK.KartuPiutang.View");
if (view == false)
{
Response.Redirect("~/Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["proposal"] != null)
{
var proposal = Request.QueryString["proposal"].ToString();
var detail = (new Pertamina.PKBL.BLL.Akuntansi.KartuPiutangDetailBll()).getPrintKartuPiutang(proposal);
DataRow data = (DataRow)detail["data"];
if (data != null)
{
lblKodeMitra2.Text = data["mitraid"].ToString();
lblNama2.Text = data["requestor_name"].ToString();
lblAlamat2.Text = data["requestor_address"].ToString();
lblJtuhTempo2.Text = String.Format("per {0} bulan ", data["jatuhtempo_bulan"]);
lblPinjaman2.Text = String.Format("{0:#,##}.00", Convert.ToInt32(data["NilaiSetuju"]));
lblTanggalRealisasi2.Text = DateTime.Parse(data["TglRealisasi"].ToString()).ToString("dd/MM/yyyy");
lblTglJatuhTempo2.Text = data["maturityDate"].ToString();
lblJangkaWaktu2.Text = String.Format("{0} Bulan", data["JangkaWaktu"]);
lblGracePeriod2.Text = String.Format("{0} Bulan", data["grace_period"]);
lblPersentaseJasa2.Text = String.Format("{0}%", data["SukuBUnga"]);
}
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
var res = (new Pertamina.PKBL.BLL.Kemitraan.JadwalPembayaranBll()).PrintJadwalAngsuranItems(proposal, branchCode);
var tabel = (DataTable)res["tabel"];
try
{
var footer = ((DataTable)res["footer"]).Rows[0];
gvDetailKartuPiutang.DataSource = tabel;
gvDetailKartuPiutang.DataBind();
var awal = Convert.ToDateTime(tabel.Rows[0]["TglJatuhTempo"]).ToString("dd MMMM yyyy");
var akhir = Convert.ToDateTime(tabel.Rows[tabel.Rows.Count - 1]["TglJatuhTempo"]).ToString("dd MMMM yyyy");
ViewState["awal"] = awal;
ViewState["akhir"] = akhir;
ViewState["branch_name"] = footer["branch_name"].ToString();
ViewState["alamat"] = footer["address1"].ToString();
ViewState["kota"] = footer["kota_lengkap"].ToString();
ViewState["now"] = DateTime.Today.ToString("dd MMMM yyyy");
ViewState["manager"] = footer["pic"].ToString();
}
catch
{
}
}
}
private void roleAuth()
{
var userRoles = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mRoleList;
bool view = RoleCheck.CheckRoleView(userRoles, "RPT.BinaLing.View");
//((GridViewCommandColumn)gvPermohonan.Columns["opr"]).ShowNewButton = insert;
if (view == false)
{
Response.Redirect("~/Default.aspx");
}
}
protected void gvDetailDiskonJasa_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs 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 = "Diskon Jasa";
log.UserName = userName;
try
{
var branchCode = ((wcf_auth.GeneralUserProfile)SessionCheck.Check(Response, Session["userprofile"])).mAuthObjectValueList.FirstOrDefault(t => t.mAuthObjectName == "REGION").Value1;
Hashtable ht = new Hashtable();
ht.Add("@proposal_number-varchar-40", Session["proposal_number"].ToString());
ht.Add("@nominal-float", float.Parse(e.NewValues["Bunga"].ToString()));
ht.Add("@angsuranKe-int", e.NewValues["AngsuranKe"].ToString());
ht.Add("@tglDiskon-varchar-20", Convert.ToDateTime(e.NewValues["Tanggal"]).ToString("dd/MM/yyyy"));
ht.Add("@branch_code-int", Convert.ToInt32(branchCode));
ht.Add("@user-varchar-50", Session["user"].ToString());
bll.InsertDiskon(ht);
gvDetailDiskonJasa.JSProperties["cpIsUpdated"] = true;
e.Cancel = true;
gvDetailDiskonJasa.CancelEdit();
log.Type = "S";
log.Description = log.Action + " " + e.NewValues["mitra_id"].ToString() + " Sukses oleh id " + userName;
GetData();
}
catch (Exception ex)
{
log.Type = "E";
log.Description = "Diskon Jasa error : " + ex.Message;
}
finally
{
logBll.InsertActivity(log);
}
}
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()
{
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 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 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 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");
}
}