private void Display(string mode) { SPList list = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PendaftaranPMAPMDN")); SPListItem item = list.GetItemById(IDP); if (item["Status"] != null) ViewState["Status"] = item["Status"].ToString(); else { if (item["ApprovalStatus"] != null) ViewState["Status"] = item["ApprovalStatus"].ToString(); } if (item.Workflows.Count > 0 || ViewState["Status"].ToString() == "Approved") btnSaveUpdateRunWf.Visible = false; ltrRequestCode.Text = item["Title"].ToString(); ltrDate.Text = Convert.ToDateTime(item["Tanggal"].ToString()).ToString("dd-MMM-yyyy HH:mm"); txtTujuanPenggunaan.Text = item["TujuanPenggunaan"].ToString(); txtNamaPerusahaan.Text = item["NamaPerusahaan"].ToString(); if (item["TempatKedudukan"] != null) ddlTempatKedudukan.SelectedValue = item["TempatKedudukan"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]; txtBidangUsaha.Text = item["BidangUsaha"].ToString(); txtKlasifikasi.Text = item["KlasifikasiBidangUsaha"].ToString(); if (item["MataUang"] != null) { ddlMataUang.SelectedValue = item["MataUang"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]; ltrMataUangSelected.Text = ddlMataUang.SelectedItem.Text; } txtModalDasar.Text = Convert.ToDouble(item["ModalDasar"]).ToString("#,##0"); txtModalSetor.Text = Convert.ToDouble(item["ModalSetor"]).ToString("#,##0"); txtNominalSaham.Text = Convert.ToDouble(item["Nominal"]).ToString("#,##0"); txtNominalModalDasar.Text = (Convert.ToDouble(txtModalDasar.Text) * Convert.ToDouble(txtNominalSaham.Text)).ToString("#,##0"); txtNominalModalSetor.Text = (Convert.ToDouble(txtModalSetor.Text) * Convert.ToDouble(txtNominalSaham.Text)).ToString("#,##0"); txtKeterangan.Text = item["Keterangan"] == null ? string.Empty : item["Keterangan"].ToString(); if (item["StatusPerseroan"] != null) ddlStatusPerseroan.SelectedValue = item["StatusPerseroan"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]; txtNilaiInvestasi.Text = Convert.ToDouble(item["NilaiInvestasi"]).ToString("#,##0"); txtModalSendiri.Text = Convert.ToDouble(txtNominalModalSetor.Text).ToString("#,##0"); if (item["ModalDitanamKembali"] != null) txtModalDitanamKembali.Text = Convert.ToDouble(item["ModalDitanamKembali"]).ToString("#,##0"); txtModalPinjaman.Text = (Convert.ToDouble(txtNilaiInvestasi.Text) - Convert.ToDouble(txtModalSendiri.Text) - Convert.ToDouble(txtModalDitanamKembali.Text)).ToString("#,##0"); if (item["Pemohon"] != null) { int IDPemohon = Convert.ToInt32(item["Pemohon"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]); hfIDPemohon.Value = IDPemohon.ToString(); SPList listPemohon = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "Pemohon")); SPListItem itemPemohon = listPemohon.GetItemById(IDPemohon); txtNamaPemohon.Text = itemPemohon.Title; txtEmailPemohon.Text = itemPemohon["EmailPemohon"].ToString(); } txtNo.Text = item["No"] == null ? string.Empty : item["No"].ToString(); if (item["TanggalMulaiBerlaku"] != null) dtTanggalMulaiBerlaku.SelectedDate = Convert.ToDateTime(item["TanggalMulaiBerlaku"]); if (item["TanggalAkhirBerlaku"] != null) dtTanggalAkhirBerlaku.SelectedDate = Convert.ToDateTime(item["TanggalAkhirBerlaku"]); txtKeteranganPMAPMDN.Text = item["KeteranganPMAPMDN"] == null ? string.Empty : item["KeteranganPMAPMDN"].ToString(); ltrTujuanPenggunaan.Text = txtTujuanPenggunaan.Text; ltrNamaPerusahaaan.Text = txtNamaPerusahaan.Text; if (item["TempatKedudukan"] != null) ltrTempatKedudukan.Text = ddlTempatKedudukan.SelectedItem.Text; ltrBidangUsaha.Text = txtBidangUsaha.Text; ltrKlasifikasi.Text = txtKlasifikasi.Text; if (item["MataUang"] != null) { ltrMataUang.Text = ddlMataUang.SelectedItem.Text; ltrMataUangSelected.Text = ddlMataUang.SelectedItem.Text; } ltrModalDasar.Text = Convert.ToDouble(txtModalDasar.Text).ToString("#,##0"); ltrModalSetor.Text = Convert.ToDouble(txtModalSetor.Text).ToString("#,##0"); ltrNominalSaham.Text = Convert.ToDouble(txtNominalSaham.Text).ToString("#,##0"); ltrNominalModalDasar.Text = (Convert.ToDouble(ltrModalDasar.Text) * Convert.ToDouble(ltrNominalSaham.Text)).ToString("#,##0"); ltrNominalModalSetor.Text = (Convert.ToDouble(ltrModalSetor.Text) * Convert.ToDouble(ltrNominalSaham.Text)).ToString("#,##0"); ltrKeterangan.Text = txtKeterangan.Text; if (item["StatusPerseroan"] != null) ltrStatusPerseroan.Text = ddlStatusPerseroan.SelectedItem.Text; ltrNilaiInvestasi.Text = Convert.ToDouble(txtNilaiInvestasi.Text).ToString("#,##0"); ltrModalSendiri.Text = Convert.ToDouble(txtNominalModalSetor.Text).ToString("#,##0"); if (item["ModalDitanamKembali"] != null) ltrModalDitanamKembali.Text = Convert.ToDouble(txtModalDitanamKembali.Text).ToString("#,##0"); ltrModalPinjaman.Text = (Convert.ToDouble(ltrNilaiInvestasi.Text) - Convert.ToDouble(ltrModalSendiri.Text) - Convert.ToDouble(ltrModalDitanamKembali.Text)).ToString("#,##0"); ltrNamaPemohon.Text = txtNamaPemohon.Text; ltrEmailPemohon.Text = txtEmailPemohon.Text; ltrNo.Text = txtNo.Text; if (item["TanggalMulaiBerlaku"] != null) ltrTanggalMulaiBerlaku.Text = dtTanggalMulaiBerlaku.SelectedDate.ToString("dd-MMM-yyyy"); if (item["TanggalAkhirBerlaku"] != null) ltrTanggalAkhirBerlaku.Text = dtTanggalAkhirBerlaku.SelectedDate.ToString("dd-MMM-yyyy"); ltrKeteranganPMAPMDN.Text = txtKeteranganPMAPMDN.Text; if (mode == "edit") { btnSaveUpdate.Text = "Update"; btnSaveUpdateRunWf.Text = "Update & Run Workflow"; } else if (mode == "display") { btnSaveUpdate.Visible = false; btnSaveUpdateRunWf.Visible = false; } SPList listPemegangSaham = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PemegangSahamPMAPMDN")); SPQuery query = new SPQuery(); query.Query = "<Where>" + "<Eq>" + "<FieldRef Name='PendaftaranPMAPMDN' LookupId='True' />" + "<Value Type='Lookup'>" + IDP + "</Value>" + "</Eq>" + "</Where>" + "<OrderBy>" + "<FieldRef Name='Created' Ascending='False' />" + "</OrderBy>"; SPListItemCollection collSPPemegangSaham = listPemegangSaham.GetItems(query); List<PemegangSaham> collPemegangSaham = new List<PemegangSaham>(); foreach (SPListItem i in collSPPemegangSaham) { PemegangSaham o = new PemegangSaham(); o.ID = i.ID; o.Nama = i["Title"].ToString(); o.JumlahNominal = Convert.ToDouble(i["JumlahNominal"]); o.JumlahSaham = Convert.ToDouble(i["JumlahSaham"]); o.Partner = Convert.ToBoolean(i["Partner"]); o.Percentages = Convert.ToDouble(i["Percentages"]); collPemegangSaham.Add(o); } ViewState["PemegangSaham"] = collPemegangSaham; ViewState["PemegangSahamEdit"] = collPemegangSaham; BindPemegangSaham(); SPList document = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "PendaftaranPMAPMDNDokumen")); SPListItemCollection coll = document.GetItems(query); if (coll.Count > 0) { SPListItem documentItem = coll[0]; ltrfu.Text = string.Format("<a href='{0}/PendaftaranPMAPMDNDokumen/{1}'>{1}</a>", web.Url, documentItem["Name"].ToString()); if (documentItem["Original"] != null) { ltrOriginal.Text = Convert.ToBoolean(documentItem["Original"]) == true ? "Original" : "Copy"; chkOriginal.Checked = Convert.ToBoolean(documentItem["Original"]); } } if (item["Status"] != null) { if (item["Status"].ToString() == Roles.PIC_CORSEC) pnlOriginator.Visible = true; else { pnlOriginator.Visible = false; pnlAssign.Visible = false; btnSaveUpdate.Visible = false; } } if (item["ApprovalStatus"] != null) { if (item["ApprovalStatus"].ToString() == "Approved") { pnlOriginator.Visible = true; pnlAssign.Visible = true; ltrPICCorsec.Text = item["Created By"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[1]; ltrDivHead.Text = item["DivHead"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[1]; ltrChiefCS.Text = item["ChiefCorsec"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[1]; } } HiddenControls(mode, item["Status"] == null ? string.Empty : item["Status"].ToString()); }
protected void dgPemegangSaham_ItemCommand(object source, DataGridCommandEventArgs e) { if (txtNominalModalSetor.Text.Trim() == string.Empty || txtNominalSaham.Text.Trim() == string.Empty) { Util.ShowMessage(Page, SR.FieldCanNotEmpty("Nominal Modal Setor and Nominal Saham")); return; } decimal NominalModalSetor = Convert.ToDecimal(txtNominalModalSetor.Text); decimal NominalSaham = Convert.ToDecimal(txtNominalSaham.Text); List<PemegangSaham> coll = new List<PemegangSaham>(); if (ViewState["PemegangSaham"] != null) coll = ViewState["PemegangSaham"] as List<PemegangSaham>; if (e.CommandName == "add") { TextBox txtNamaPemegangSahamAdd = e.Item.FindControl("txtNamaPemegangSahamAdd") as TextBox; TextBox txtJumlahSahamAdd = e.Item.FindControl("txtJumlahSahamAdd") as TextBox; TextBox txtJumlahNominalAdd = e.Item.FindControl("txtJumlahNominalAdd") as TextBox; TextBox txtPercentagesAdd = e.Item.FindControl("txtPercentagesAdd") as TextBox; CheckBox cboPartnerAdd = e.Item.FindControl("cboPartnerAdd") as CheckBox; if (isExistInPemegangSahamGrid(txtNamaPemegangSahamAdd.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaPemegangSahamAdd.Text.Trim())); return; } string msg = Util.IsPemegangSahamOK(dgPemegangSaham, Convert.ToDecimal(txtJumlahSahamAdd.Text), Convert.ToDecimal(txtJumlahNominalAdd.Text), NominalModalSetor, NominalSaham); if (msg != string.Empty) { Util.ShowMessage(Page, msg); return; } PemegangSaham o = new PemegangSaham(); o.Nama = txtNamaPemegangSahamAdd.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalAdd.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamAdd.Text); o.Partner = cboPartnerAdd.Checked; o.Percentages = Convert.ToDouble(txtPercentagesAdd.Text); o.ID = 0; coll.Add(o); ViewState["PemegangSaham"] = coll; } if (e.CommandName == "save") { TextBox txtNamaPemegangSahamEdit = e.Item.FindControl("txtNamaPemegangSahamEdit") as TextBox; TextBox txtJumlahSahamEdit = e.Item.FindControl("txtJumlahSahamEdit") as TextBox; TextBox txtJumlahNominalEdit = e.Item.FindControl("txtJumlahNominalEdit") as TextBox; TextBox txtPercentagesEdit = e.Item.FindControl("txtPercentagesEdit") as TextBox; CheckBox cboPartnerEdit = e.Item.FindControl("cboPartnerEdit") as CheckBox; if (isExistInPemegangSahamGrid(txtNamaPemegangSahamEdit.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaPemegangSahamEdit.Text.Trim())); return; } string msg = Util.IsPemegangSahamOK(dgPemegangSaham, Convert.ToDecimal(txtJumlahSahamEdit.Text), Convert.ToDecimal(txtJumlahNominalEdit.Text), NominalModalSetor, NominalSaham); if (msg != string.Empty) { Util.ShowMessage(Page, msg); return; } PemegangSaham o = new PemegangSaham(); o.Nama = txtNamaPemegangSahamEdit.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalEdit.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamEdit.Text); o.Partner = cboPartnerEdit.Checked; o.Percentages = Convert.ToDouble(txtPercentagesEdit.Text); coll[e.Item.ItemIndex] = o; ViewState["PemegangSaham"] = coll; dgPemegangSaham.EditItemIndex = -1; dgPemegangSaham.ShowFooter = true; } if (e.CommandName == "edit") { dgPemegangSaham.ShowFooter = false; dgPemegangSaham.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dgPemegangSaham.EditItemIndex = -1; dgPemegangSaham.ShowFooter = true; } if (e.CommandName == "delete") { coll.RemoveAt(e.Item.ItemIndex); ViewState["PemegangSaham"] = coll; } BindPemegangSaham(); }
protected void dgPemegangSaham_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "popup") { ViewState["Index"] = e.Item.ItemIndex; return; } if (e.CommandName == "pemegangsaham") { int PemegangSahamID = 0; Label lblIDPemegangSaham = e.Item.FindControl("lblIDPemegangSaham") as Label; if (lblIDPemegangSaham != null) PemegangSahamID = Convert.ToInt32(lblIDPemegangSaham.Text); Label lblIDPemegangSahamAdd = e.Item.FindControl("lblIDPemegangSahamAdd") as Label; if (lblIDPemegangSahamAdd != null) PemegangSahamID = Convert.ToInt32(lblIDPemegangSahamAdd.Text); Label lblIDPemegangSahamEdit = e.Item.FindControl("lblIDPemegangSahamEdit") as Label; if (lblIDPemegangSahamEdit != null) PemegangSahamID = Convert.ToInt32(lblIDPemegangSahamEdit.Text); ucPemegangSahamInfo.IDProp = PemegangSahamID.ToString(); return; } if (txtNominalModalSetor.Text.Trim() == string.Empty || txtNominalSaham.Text.Trim() == string.Empty) { Util.ShowMessage(Page, SR.FieldCanNotEmpty("Nominal Modal Setor and Nominal Saham")); return; } DataGrid dg = source as DataGrid; List<PemegangSaham> coll = new List<PemegangSaham>(); if (ViewState["PemegangSaham"] != null) coll = ViewState["PemegangSaham"] as List<PemegangSaham>; decimal NominalModalSetor = 0; decimal NominalSaham = 0; NominalModalSetor = Convert.ToDecimal(txtNominalModalSetor.Text); NominalSaham = Convert.ToDecimal(txtNominalSaham.Text); if (e.CommandName == "add") { LinkButton lbNamaPemegangSahamAdd = e.Item.FindControl("lbNamaPemegangSahamAdd") as LinkButton; TextBox txtJumlahSahamAdd = e.Item.FindControl("txtJumlahSahamAdd") as TextBox; TextBox txtJumlahNominalAdd = e.Item.FindControl("txtJumlahNominalAdd") as TextBox; TextBox txtPercentagesAdd = e.Item.FindControl("txtPercentagesAdd") as TextBox; CheckBox cboPartnerAdd = e.Item.FindControl("cboPartnerAdd") as CheckBox; Label lblIDPemegangSahamAdd = e.Item.FindControl("lblIDPemegangSahamAdd") as Label; PemegangSaham o = new PemegangSaham(); if (isExistInPemegangSahamGrid(lbNamaPemegangSahamAdd.Text)) { Util.ShowMessage(Page, SR.DataIsExist(lbNamaPemegangSahamAdd.Text.Trim())); return; } string msg = Util.IsPemegangSahamOK(dg, Convert.ToDecimal(txtJumlahSahamAdd.Text), Convert.ToDecimal(txtJumlahNominalAdd.Text), NominalModalSetor, NominalSaham); if (msg != string.Empty) { Util.ShowMessage(Page, msg); return; } o.Nama = lbNamaPemegangSahamAdd.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalAdd.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamAdd.Text); o.Partner = cboPartnerAdd.Checked; o.Percentages = Convert.ToDouble(txtPercentagesAdd.Text); o.ID = 0; o.IDPemegangSaham = Convert.ToInt32(lblIDPemegangSahamAdd.Text); coll.Add(o); ViewState["PemegangSaham"] = coll; } if (e.CommandName == "save") { LinkButton lbNamaPemegangSahamEdit = e.Item.FindControl("lbNamaPemegangSahamEdit") as LinkButton; TextBox txtJumlahSahamEdit = e.Item.FindControl("txtJumlahSahamEdit") as TextBox; TextBox txtJumlahNominalEdit = e.Item.FindControl("txtJumlahNominalEdit") as TextBox; TextBox txtPercentagesEdit = e.Item.FindControl("txtPercentagesEdit") as TextBox; CheckBox cboPartnerEdit = e.Item.FindControl("cboPartnerEdit") as CheckBox; Label lblIDPemegangSahamEdit = e.Item.FindControl("lblIDPemegangSahamEdit") as Label; PemegangSaham o = new PemegangSaham(); if (isExistInPemegangSahamGrid(lbNamaPemegangSahamEdit.Text)) { Util.ShowMessage(Page, SR.DataIsExist(lbNamaPemegangSahamEdit.Text.Trim())); return; } string msg = Util.IsPemegangSahamOK(dg, Convert.ToDecimal(txtJumlahSahamEdit.Text), Convert.ToDecimal(txtJumlahNominalEdit.Text), NominalModalSetor, NominalSaham); if (msg != string.Empty) { Util.ShowMessage(Page, msg); return; } o.Nama = lbNamaPemegangSahamEdit.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalEdit.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamEdit.Text); o.Partner = cboPartnerEdit.Checked; o.Percentages = Convert.ToDouble(txtPercentagesEdit.Text); o.IDPemegangSaham = Convert.ToInt32(lblIDPemegangSahamEdit.Text); coll[e.Item.ItemIndex] = o; ViewState["PemegangSaham"] = coll; dg.EditItemIndex = -1; dg.ShowFooter = true; } if (e.CommandName == "edit") { dg.ShowFooter = false; dg.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dg.EditItemIndex = -1; dg.ShowFooter = true; } if (e.CommandName == "delete") { coll.RemoveAt(e.Item.ItemIndex); ViewState["PemegangSaham"] = coll; } BindPemegangSaham(); }
private void BindAllRelatedData(SPListItem item) { SPList listPemegangSaham = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PemegangSaham")); SPQuery query = new SPQuery(); query.Query = "<Where>" + "<Eq>" + "<FieldRef Name='PerusahaanBaru' LookupId='True' />" + "<Value Type='Lookup'>" + IDP + "</Value>" + "</Eq>" + "</Where>" + "<OrderBy>" + "<FieldRef Name='Created' Ascending='False' />" + "</OrderBy>"; SPListItemCollection collSPPemegangSaham = listPemegangSaham.GetItems(query); List<PemegangSaham> collPemegangSaham = new List<PemegangSaham>(); foreach (SPListItem i in collSPPemegangSaham) { PemegangSaham o = new PemegangSaham(); o.ID = i.ID; if (i["PemegangSaham"] != null) { string IDMasterData = i["PemegangSaham"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]; SPListItem itemPSKMaster = Util.GetPemegangSahamKomisarisMasterData(web, Convert.ToInt32(IDMasterData)); o.IDPemegangSaham = itemPSKMaster.ID; o.Nama = itemPSKMaster["Title"].ToString(); } o.JumlahNominal = Convert.ToDouble(i["JumlahNominal"]); o.JumlahSaham = Convert.ToDouble(i["JumlahSaham"]); o.Partner = Convert.ToBoolean(i["Partner"]); o.Percentages = Convert.ToDouble(i["Percentages"]); collPemegangSaham.Add(o); } ViewState["PemegangSaham"] = collPemegangSaham; ViewState["PemegangSahamEdit"] = collPemegangSaham; BindPemegangSaham(); SPList listWewenangDireksi = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "WewenangDireksi")); SPListItemCollection collSPWewenangDireksi = listWewenangDireksi.GetItems(query); List<WewenangDireksi> collWewenangDireksi = new List<WewenangDireksi>(); foreach (SPListItem i in collSPWewenangDireksi) { WewenangDireksi o = new WewenangDireksi(); o.ID = i.ID; o.Nama = i["Title"].ToString(); collWewenangDireksi.Add(o); } ViewState["WewenangDireksi"] = collWewenangDireksi; ViewState["WewenangDireksiEdit"] = collWewenangDireksi; BindWewenangDireksi(); SPList listKomisarisDireksi = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "KomisarisDireksi")); SPListItemCollection collSPKomisarisDireksi = listKomisarisDireksi.GetItems(query); List<KomisarisDireksi> collKomisarisDireksi = new List<KomisarisDireksi>(); foreach (SPListItem i in collSPKomisarisDireksi) { KomisarisDireksi o = new KomisarisDireksi(); o.ID = i.ID; if (i["KomisarisDireksi"] != null) { string IDMasterData = i["KomisarisDireksi"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[0]; SPListItem itemPSKMaster = Util.GetPemegangSahamKomisarisMasterData(web, Convert.ToInt32(IDMasterData)); o.IDKomisaris = itemPSKMaster.ID; o.Nama = itemPSKMaster["Title"].ToString(); } String[] split = i["Jabatan"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries); o.IDJabatan = Convert.ToInt32(split[0]); o.Jabatan = split[1]; if (i["TanggalMulaiMenjabat"] != null) o.MulaiMenjabat = Convert.ToDateTime(i["TanggalMulaiMenjabat"]); if (i["TanggalAkhirMenjabat"] != null) o.AkhirMenjabat = Convert.ToDateTime(i["TanggalAkhirMenjabat"]); collKomisarisDireksi.Add(o); } ViewState["KomisarisDireksi"] = collKomisarisDireksi; ViewState["KomisarisDireksiEdit"] = collKomisarisDireksi; BindKomisarisDireksi(); SPList listDokumen = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "DokumenLainnya")); SPListItemCollection collSPDokumen = listDokumen.GetItems(query); List<Dokumen> collDokumen = new List<Dokumen>(); foreach (SPListItem i in collSPDokumen) { Dokumen o = new Dokumen(); o.ID = i.ID; o.NamaFile = i["Name"].ToString(); if (i["Penjelasan"] != null) o.Penjelasan = i["Penjelasan"].ToString(); o.TipeDokumen = i["TipeDokumen"] == null ? string.Empty : i["TipeDokumen"].ToString(); o.Attachment = i.File.OpenBinary(); o.AttachmentOld = o.Attachment; o.Url = string.Format("<a href='{0}/DokumenLainnya/{1}'>{1}</a>", web.Url, i["Name"].ToString()); collDokumen.Add(o); } ViewState["Dokumen"] = collDokumen; ViewState["DokumenEdit"] = collDokumen; BindDokumen(); SPList listNPWP = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "NPWPLainnya")); SPListItemCollection collSPNPWP = listNPWP.GetItems(query); List<NPWP> collDokumenNPWP = new List<NPWP>(); foreach (SPListItem i in collSPNPWP) { NPWP o = new NPWP(); o.ID = i.ID; o.NamaFile = i["Name"].ToString(); o.NoNPWP = i["NoNPWP"].ToString(); if (i["Keterangan"] != null) o.Keterangan = i["Keterangan"].ToString(); o.Attachment = i.File.OpenBinary(); o.AttachmentOld = o.Attachment; o.Url = string.Format("<a href='{0}/NPWPLainnya/{1}'>{1}</a>", web.Url, i["Name"].ToString()); collDokumenNPWP.Add(o); } ViewState["NPWP"] = collDokumenNPWP; ViewState["NPWPEdit"] = collDokumenNPWP; BindNPWP(); SPList listPKP = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "PKPLainnya")); SPListItemCollection collSPPKP = listPKP.GetItems(query); List<PKP> collDokumenPKP = new List<PKP>(); foreach (SPListItem i in collSPPKP) { PKP o = new PKP(); o.ID = i.ID; o.NamaFile = i["Name"].ToString(); o.NoPKP = i["NoPKP"].ToString(); if (i["Keterangan"] != null) o.Keterangan = i["Keterangan"].ToString(); o.Attachment = i.File.OpenBinary(); o.AttachmentOld = o.Attachment; o.Url = string.Format("<a href='{0}/PKPLainnya/{1}'>{1}</a>", web.Url, i["Name"].ToString()); collDokumenPKP.Add(o); } ViewState["PKP"] = collDokumenPKP; ViewState["PKPEdit"] = collDokumenPKP; BindPKP(); DisplayDocument(ltrfuSKDP, item.Title, "SKDP", ltrOriginalSKDP, chkOriginalSKDP); DisplayDocument(ltrfuAkte, item.Title, "Akta", ltrOriginalAkte, chkOriginalAkte); DisplayDocument(ltrfuNPWP, item.Title, "NPWP", ltrOriginalNPWP, chkOriginalNPWP); DisplayDocument(ltrfuPKP, item.Title, "PKP", ltrOriginalPKP, chkOriginalPKP); DisplayDocument(ltrfuAPV, item.Title, "Journal Voucher", ltrOriginalAPV, chkOriginalAPV); DisplayDocument(ltrfuSetoranModal, item.Title, "Setoran Modal", ltrOriginalSetoranModal, chkOriginalSetoranModal); DisplayDocument(ltrfuAkte, item.Title, "Akta and SK Pengesahan Pendirian", ltrOriginalAkte, chkOriginalAkte); DisplayDocument(ltrfuBNRI, item.Title, "BNRI", ltrOriginalBNRI, chkOriginalBNRI); }
protected void dgPemegangSaham_ItemCommand(object source, DataGridCommandEventArgs e) { List<PemegangSaham> coll = new List<PemegangSaham>(); if (ViewState["PemegangSahamMenjadi"] != null) coll = ViewState["PemegangSahamMenjadi"] as List<PemegangSaham>; if (e.CommandName == "add") { TextBox txtNamaPemegangSahamAdd = e.Item.FindControl("txtNamaPemegangSahamAdd") as TextBox; TextBox txtJumlahSahamAdd = e.Item.FindControl("txtJumlahSahamAdd") as TextBox; TextBox txtJumlahNominalAdd = e.Item.FindControl("txtJumlahNominalAdd") as TextBox; TextBox txtPercentagesAdd = e.Item.FindControl("txtPercentagesAdd") as TextBox; CheckBox cboPartnerAdd = e.Item.FindControl("cboPartnerAdd") as CheckBox; DateTimeControl dtTanggalMulaiMenjabatAdd = null; DateTimeControl dtTanggalAkhirMenjabatAdd = null; if (isExistInPemegangSahamGrid(txtNamaPemegangSahamAdd.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaPemegangSahamAdd.Text.Trim())); return; } PemegangSaham o = new PemegangSaham(); o.Nama = txtNamaPemegangSahamAdd.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalAdd.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamAdd.Text); o.Partner = cboPartnerAdd.Checked; o.Percentages = Convert.ToDouble(txtPercentagesAdd.Text); dtTanggalMulaiMenjabatAdd = e.Item.FindControl("dtTanggalMulaiMenjabatAdd") as DateTimeControl; dtTanggalAkhirMenjabatAdd = e.Item.FindControl("dtTanggalAkhirMenjabatAdd") as DateTimeControl; o.MulaiMenjabat = dtTanggalMulaiMenjabatAdd.SelectedDate; o.AkhirMenjabat = dtTanggalAkhirMenjabatAdd.SelectedDate; int i = DateTime.Compare(dtTanggalMulaiMenjabatAdd.SelectedDate, dtTanggalAkhirMenjabatAdd.SelectedDate); if (i > 0) { Util.ShowMessage(Page, "Tanggal Akhir Menjabat must be greater or equal than Tanggal Mulai Menjabat"); return; } o.ID = 0; coll.Add(o); ViewState["PemegangSahamMenjadi"] = coll; } if (e.CommandName == "save") { TextBox txtNamaPemegangSahamEdit = e.Item.FindControl("txtNamaPemegangSahamEdit") as TextBox; TextBox txtJumlahSahamEdit = e.Item.FindControl("txtJumlahSahamEdit") as TextBox; TextBox txtJumlahNominalEdit = e.Item.FindControl("txtJumlahNominalEdit") as TextBox; TextBox txtPercentagesEdit = e.Item.FindControl("txtPercentagesEdit") as TextBox; CheckBox cboPartnerEdit = e.Item.FindControl("cboPartnerEdit") as CheckBox; DateTimeControl dtTanggalMulaiMenjabatAdd = null; DateTimeControl dtTanggalAkhirMenjabatAdd = null; if (isExistInPemegangSahamGrid(txtNamaPemegangSahamEdit.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaPemegangSahamEdit.Text.Trim())); return; } PemegangSaham o = new PemegangSaham(); o.Nama = txtNamaPemegangSahamEdit.Text.Trim(); o.JumlahNominal = Convert.ToDouble(txtJumlahNominalEdit.Text); o.JumlahSaham = Convert.ToDouble(txtJumlahSahamEdit.Text); o.Partner = cboPartnerEdit.Checked; o.Percentages = Convert.ToDouble(txtPercentagesEdit.Text); dtTanggalMulaiMenjabatAdd = e.Item.FindControl("dtTanggalMulaiMenjabatAdd") as DateTimeControl; dtTanggalAkhirMenjabatAdd = e.Item.FindControl("dtTanggalAkhirMenjabatAdd") as DateTimeControl; o.MulaiMenjabat = dtTanggalMulaiMenjabatAdd.SelectedDate; o.AkhirMenjabat = dtTanggalAkhirMenjabatAdd.SelectedDate; int i = DateTime.Compare(dtTanggalMulaiMenjabatAdd.SelectedDate, dtTanggalAkhirMenjabatAdd.SelectedDate); if (i > 0) { Util.ShowMessage(Page, "Tanggal Akhir Menjabat must be greater or equal than Tanggal Mulai Menjabat"); return; } coll[e.Item.ItemIndex] = o; ViewState["PemegangSahamMenjadi"] = coll; dgPemegangSaham.EditItemIndex = -1; dgPemegangSaham.ShowFooter = true; } if (e.CommandName == "edit") { dgPemegangSaham.ShowFooter = false; dgPemegangSaham.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dgPemegangSaham.EditItemIndex = -1; dgPemegangSaham.ShowFooter = true; } if (e.CommandName == "delete") { PemegangSaham o = coll[e.Item.ItemIndex] as PemegangSaham; o.IsDeleted = true; coll[e.Item.ItemIndex] = o; ViewState["PemegangSahamMenjadi"] = coll; } BindPemegangSahamMenjadi(); }
private void GetPemegangSahamSemula(int idcompany) { SPList listPemegangSaham = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PemegangSaham")); SPQuery query = new SPQuery(); query.Query = "<Where>" + "<Eq>" + "<FieldRef Name='PerusahaanBaru' LookupId='True' />" + "<Value Type='Lookup'>" + idcompany + "</Value>" + "</Eq>" + "</Where>" + "<OrderBy>" + "<FieldRef Name='Created' Ascending='False' />" + "</OrderBy>"; SPListItemCollection collSPPemegangSaham = listPemegangSaham.GetItems(query); List<PemegangSaham> collPemegangSaham = new List<PemegangSaham>(); foreach (SPListItem i in collSPPemegangSaham) { PemegangSaham o = new PemegangSaham(); o.ID = 0; o.Nama = i["Title"].ToString(); o.JumlahNominal = Convert.ToDouble(i["JumlahNominal"]); o.JumlahSaham = Convert.ToDouble(i["JumlahSaham"]); o.Partner = Convert.ToBoolean(i["Partner"]); o.Percentages = Convert.ToDouble(i["Percentages"]); if (i["TanggalMulaiMenjabat"] != null) o.MulaiMenjabat = Convert.ToDateTime(i["TanggalMulaiMenjabat"]); if (i["TanggalAkhirMenjabat"] != null) o.AkhirMenjabat = Convert.ToDateTime(i["TanggalAkhirMenjabat"]); o.IsDeleted = false; collPemegangSaham.Add(o); } ViewState["PemegangSahamSemula"] = collPemegangSaham; }
private void GetPemegangSahamMenjadi(int id) { SPList listPemegangSaham = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerubahanPemegangSaham")); SPQuery query = new SPQuery(); query.Query = "<Where>" + "<Eq>" + "<FieldRef Name='PerubahanAnggaranDasar' LookupId='True' />" + "<Value Type='Lookup'>" + id + "</Value>" + "</Eq>" + "</Where>" + "<OrderBy>" + "<FieldRef Name='Created' Ascending='False' />" + "</OrderBy>"; SPListItemCollection collSPPemegangSaham = listPemegangSaham.GetItems(query); List<PemegangSaham> collPemegangSaham = new List<PemegangSaham>(); foreach (SPListItem i in collSPPemegangSaham) { PemegangSaham o = new PemegangSaham(); o.ID = i.ID; o.Nama = i["Title"].ToString(); o.JumlahNominal = Convert.ToDouble(i["JumlahNominal"]); o.JumlahSaham = Convert.ToDouble(i["JumlahSaham"]); o.Partner = Convert.ToBoolean(i["Partner"]); o.Percentages = Convert.ToDouble(i["Percentages"]); o.IsDeleted = false; collPemegangSaham.Add(o); } ViewState["PemegangSahamMenjadi"] = collPemegangSaham; }