protected void dgKomisaris_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "popup") { ViewState["Index"] = e.Item.ItemIndex; return; } if (e.CommandName == "komisaris") { int KomisarisID = 0; Label lblIDKomisaris = e.Item.FindControl("lblIDKomisaris") as Label; if (lblIDKomisaris != null) KomisarisID = Convert.ToInt32(lblIDKomisaris.Text); Label lblIDKomisarisAdd = e.Item.FindControl("lblIDKomisarisAdd") as Label; if (lblIDKomisarisAdd != null) KomisarisID = Convert.ToInt32(lblIDKomisarisAdd.Text); Label lblIDKomisarisEdit = e.Item.FindControl("lblIDKomisarisEdit") as Label; if (lblIDKomisarisEdit != null) KomisarisID = Convert.ToInt32(lblIDKomisarisEdit.Text); ucKomisarisInfo.IDProp = KomisarisID.ToString(); return; } DataGrid dg = source as DataGrid; List<KomisarisDireksi> coll = new List<KomisarisDireksi>(); if (ViewState["KomisarisDireksi"] != null) coll = ViewState["KomisarisDireksi"] as List<KomisarisDireksi>; if (e.CommandName == "add") { LinkButton lbNamaKomisarisAdd = e.Item.FindControl("lbNamaKomisarisAdd") as LinkButton; DropDownList ddlJabatanAdd = e.Item.FindControl("ddlJabatanAdd") as DropDownList; DateTimeControl dtTanggalMulaiMenjabatAdd = null; DateTimeControl dtTanggalAkhirMenjabatAdd = null; Label lblIDKomisarisAdd = e.Item.FindControl("lblIDKomisarisAdd") as Label; if (isExistInKomisarisDireksiGrid(lbNamaKomisarisAdd.Text)) { Util.ShowMessage(Page, SR.DataIsExist(lbNamaKomisarisAdd.Text.Trim())); return; } KomisarisDireksi o = new KomisarisDireksi(); o.Nama = lbNamaKomisarisAdd.Text.Trim(); o.IDJabatan = Convert.ToInt32(ddlJabatanAdd.SelectedValue); o.Jabatan = ddlJabatanAdd.SelectedItem.Text; o.IDKomisaris = Convert.ToInt32(lblIDKomisarisAdd.Text); if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == Roles.PIC_CORSEC + " Upload Akta") { 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["KomisarisDireksi"] = coll; } if (e.CommandName == "save") { LinkButton lbNamaKomisarisEdit = e.Item.FindControl("lbNamaKomisarisEdit") as LinkButton; DropDownList ddlJabatanEdit = e.Item.FindControl("ddlJabatanEdit") as DropDownList; DateTimeControl dtTanggalMulaiMenjabatEdit = null; DateTimeControl dtTanggalAkhirMenjabatEdit = null; Label lblIDKomisarisEdit = e.Item.FindControl("lblIDKomisarisEdit") as Label; if (isExistInKomisarisDireksiGrid(lbNamaKomisarisEdit.Text)) { Util.ShowMessage(Page, SR.DataIsExist(lbNamaKomisarisEdit.Text.Trim())); return; } KomisarisDireksi o = new KomisarisDireksi(); o.Nama = lbNamaKomisarisEdit.Text.Trim(); o.IDJabatan = Convert.ToInt32(ddlJabatanEdit.SelectedValue); o.Jabatan = ddlJabatanEdit.SelectedItem.Text; o.IDKomisaris = Convert.ToInt32(lblIDKomisarisEdit.Text); if (Convert.ToBoolean(ViewState["Admin"]) == true || ViewState["Status"].ToString() == Roles.PIC_CORSEC + " Upload Akta") { dtTanggalMulaiMenjabatEdit = e.Item.FindControl("dtTanggalMulaiMenjabatEdit") as DateTimeControl; dtTanggalAkhirMenjabatEdit = e.Item.FindControl("dtTanggalAkhirMenjabatEdit") as DateTimeControl; o.MulaiMenjabat = dtTanggalMulaiMenjabatEdit.SelectedDate; o.AkhirMenjabat = dtTanggalAkhirMenjabatEdit.SelectedDate; int i = DateTime.Compare(dtTanggalMulaiMenjabatEdit.SelectedDate, dtTanggalAkhirMenjabatEdit.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["KomisarisDireksi"] = 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["KomisarisDireksi"] = coll; } BindKomisarisDireksi(); }
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); }
private void GetKomisarisDireksiSemula(int idcompany) { 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>"; 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 = 0; o.Nama = i["Title"].ToString(); String[] split = i["Jabatan"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries); o.IDJabatan = Convert.ToInt32(split[0]); o.Jabatan = split[1]; o.NoKTP = i["NoKTP"].ToString(); o.NoNPWP = i["NoNPWP"].ToString(); if (i["TanggalMulaiMenjabat"] != null) o.MulaiMenjabat = Convert.ToDateTime(i["TanggalMulaiMenjabat"]); if (i["TanggalAkhirMenjabat"] != null) o.AkhirMenjabat = Convert.ToDateTime(i["TanggalAkhirMenjabat"]); collKomisarisDireksi.Add(o); } ViewState["KomisarisDireksiSemula"] = collKomisarisDireksi; }
protected void dgKomisaris_ItemCommand(object source, DataGridCommandEventArgs e) { List<KomisarisDireksi> coll = new List<KomisarisDireksi>(); if (ViewState["KomisarisDireksiMenjadi"] != null) coll = ViewState["KomisarisDireksiMenjadi"] as List<KomisarisDireksi>; if (e.CommandName == "add") { TextBox txtNamaAdd = e.Item.FindControl("txtNamaAdd") as TextBox; DropDownList ddlJabatanAdd = e.Item.FindControl("ddlJabatanAdd") as DropDownList; TextBox txtNoKTPAdd = e.Item.FindControl("txtNoKTPAdd") as TextBox; TextBox txtNoNPWPAdd = e.Item.FindControl("txtNoNPWPAdd") as TextBox; DateTimeControl dtTanggalMulaiMenjabatAdd = null; DateTimeControl dtTanggalAkhirMenjabatAdd = null; if (isExistInKomisarisDireksiGrid(txtNamaAdd.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaAdd.Text.Trim())); return; } KomisarisDireksi o = new KomisarisDireksi(); o.Nama = txtNamaAdd.Text.Trim(); o.IDJabatan = Convert.ToInt32(ddlJabatanAdd.SelectedValue); o.Jabatan = ddlJabatanAdd.SelectedItem.Text; o.NoKTP = txtNoKTPAdd.Text; o.NoNPWP = txtNoNPWPAdd.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["KomisarisDireksiMenjadi"] = coll; } if (e.CommandName == "save") { TextBox txtNamaEdit = e.Item.FindControl("txtNamaEdit") as TextBox; DropDownList ddlJabatanEdit = e.Item.FindControl("ddlJabatanEdit") as DropDownList; TextBox txtNoKTPEdit = e.Item.FindControl("txtNoKTPEdit") as TextBox; TextBox txtNoNPWPEdit = e.Item.FindControl("txtNoNPWPEdit") as TextBox; DateTimeControl dtTanggalMulaiMenjabatAdd = null; DateTimeControl dtTanggalAkhirMenjabatAdd = null; if (isExistInKomisarisDireksiGrid(txtNamaEdit.Text)) { Util.ShowMessage(Page, SR.DataIsExist(txtNamaEdit.Text.Trim())); return; } KomisarisDireksi o = new KomisarisDireksi(); o.Nama = txtNamaEdit.Text.Trim(); o.IDJabatan = Convert.ToInt32(ddlJabatanEdit.SelectedValue); o.Jabatan = ddlJabatanEdit.SelectedItem.Text; o.NoKTP = txtNoKTPEdit.Text; o.NoNPWP = txtNoNPWPEdit.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["KomisarisDireksiMenjadi"] = coll; dgKomisaris.EditItemIndex = -1; dgKomisaris.ShowFooter = true; } if (e.CommandName == "edit") { dgKomisaris.ShowFooter = false; dgKomisaris.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dgKomisaris.EditItemIndex = -1; dgKomisaris.ShowFooter = true; } if (e.CommandName == "delete") { KomisarisDireksi o = coll[e.Item.ItemIndex] as KomisarisDireksi; o.IsDeleted = true; coll[e.Item.ItemIndex] = o; ViewState["KomisarisDireksiMenjadi"] = coll; } BindKomisarisDireksiMenjadi(); }
private void GetKomisarisDireksiMenjadi(int id) { 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>"; SPList listKomisarisDireksi = web.GetList(Util.CreateSharePointListStrUrl(web.Url, "PerubahanKomisarisDireksi")); SPListItemCollection collSPKomisarisDireksi = listKomisarisDireksi.GetItems(query); List<KomisarisDireksi> collKomisarisDireksi = new List<KomisarisDireksi>(); foreach (SPListItem i in collSPKomisarisDireksi) { KomisarisDireksi o = new KomisarisDireksi(); o.ID = i.ID; o.Nama = (i["KomisarisDireksi"] != null ? new SPFieldLookupValue(i["KomisarisDireksi"].ToString()).LookupValue : string.Empty); String[] split = i["Jabatan"].ToString().Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries); o.IDJabatan = Convert.ToInt32(split[0]); o.Jabatan = split[1]; o.IsDeleted = false; collKomisarisDireksi.Add(o); } ViewState["KomisarisDireksiMenjadi"] = collKomisarisDireksi; }