public JsonResult AddReqnpwp(string txtNoTlp, string txtAlamat)
{
cekSession();
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
Random random = new Random();
string unique = new string(Enumerable.Repeat(chars, 4).Select(s => s[random.Next(s.Length)]).ToArray());
string nama = sopace.personal_information.Where(e => e.NIP == nip).Select(e => e.nama_pegawai).FirstOrDefault();
if (nama != null)
{
request req = new request();
req.id_req = "NPWP-" + DateTime.Now.ToString("yyyy").ToString() + "-" + unique;
req.NIP = nip;
req.nama_pegawai = nama;
req.tanggal_request = DateTime.Now;
req.status = "requested";
sopace.requests.Add(req);
sopace.SaveChanges();
NPWP npwp = new NPWP();
npwp.id_req = req.id_req;
npwp.no_tlp = txtNoTlp;
npwp.alamat_kantor_pajak = txtAlamat;
sopace.NPWPs.Add(npwp);
sopace.SaveChanges();
return(Json("Insert Request Success", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Insert Request Failed", JsonRequestBehavior.AllowGet));
}
}
public JsonResult EditNPWP(string txtIDReq, string txtNoTlp, string txtAlamat)
{
NPWP npwp = sopace.NPWPs.Where(e => e.id_req == txtIDReq).First();
npwp.no_tlp = txtNoTlp;
npwp.alamat_kantor_pajak = txtAlamat;
sopace.Entry(npwp).State = EntityState.Modified;
sopace.SaveChanges();
return(Json("Update Data Request Success", JsonRequestBehavior.AllowGet));
}
protected void dgNPWPLainnya_ItemCommand(object source, DataGridCommandEventArgs e)
{
List<NPWP> coll = new List<NPWP>();
if (ViewState["NPWP"] != null)
coll = ViewState["NPWP"] as List<NPWP>;
if (e.CommandName == "add")
{
TextBox txtNPWPAdd = e.Item.FindControl("txtNPWPAdd") as TextBox;
TextBox txtKeteranganAdd = e.Item.FindControl("txtKeteranganAdd") as TextBox;
FileUpload fuAdd = e.Item.FindControl("fuAdd") as FileUpload;
if (isExistInNPWPGrid(txtNPWPAdd.Text, "lblNPWP"))
{
Util.ShowMessage(Page, SR.DataIsExist(txtNPWPAdd.Text.Trim()));
return;
}
if (isExistInNPWPGrid(fuAdd.FileName, "lblAtttachmentHidden"))
{
Util.ShowMessage(Page, SR.DataIsExist(fuAdd.FileName));
return;
}
NPWP o = new NPWP();
o.NoNPWP = txtNPWPAdd.Text.Trim();
Stream strm = fuAdd.PostedFile.InputStream;
byte[] bytes = new byte[Convert.ToInt32(fuAdd.PostedFile.ContentLength)];
strm.Read(bytes, 0, Convert.ToInt32(fuAdd.PostedFile.ContentLength));
strm.Close();
o.Attachment = bytes;
o.NamaFile = fuAdd.FileName;
o.Keterangan = txtKeteranganAdd.Text.Trim();
o.ID = 0;
coll.Add(o);
ViewState["NPWP"] = coll;
}
if (e.CommandName == "save")
{
TextBox txtNPWPEdit = e.Item.FindControl("txtNPWPEdit") as TextBox;
TextBox txtKeteranganEdit = e.Item.FindControl("txtKeteranganEdit") as TextBox;
FileUpload fuEdit = e.Item.FindControl("fuEdit") as FileUpload;
if (isExistInNPWPGrid(txtNPWPEdit.Text, "lblNPWP"))
{
Util.ShowMessage(Page, SR.DataIsExist(txtNPWPEdit.Text.Trim()));
return;
}
if (isExistInNPWPGrid(fuEdit.FileName, "lblAtttachmentHidden"))
{
Util.ShowMessage(Page, SR.DataIsExist(fuEdit.FileName));
return;
}
NPWP o = coll[e.Item.ItemIndex];
o.NoNPWP = txtNPWPEdit.Text.Trim();
if (fuEdit.PostedFile != null)
{
if (fuEdit.PostedFile.ContentLength > 0)
{
Stream strm = fuEdit.PostedFile.InputStream;
byte[] bytes = new byte[Convert.ToInt32(fuEdit.PostedFile.ContentLength)];
strm.Read(bytes, 0, Convert.ToInt32(fuEdit.PostedFile.ContentLength));
strm.Close();
o.Attachment = bytes;
o.NamaFile = fuEdit.FileName;
o.Url = string.Empty;
}
}
o.Keterangan = txtKeteranganEdit.Text.Trim();
coll[e.Item.ItemIndex] = o;
ViewState["NPWP"] = coll;
dgNPWPLainnya.EditItemIndex = -1;
dgNPWPLainnya.ShowFooter = true;
}
if (e.CommandName == "edit")
{
dgNPWPLainnya.ShowFooter = false;
dgNPWPLainnya.EditItemIndex = e.Item.ItemIndex;
}
if (e.CommandName == "cancel")
{
dgNPWPLainnya.EditItemIndex = -1;
dgNPWPLainnya.ShowFooter = true;
}
if (e.CommandName == "delete")
{
coll.RemoveAt(e.Item.ItemIndex);
ViewState["NPWP"] = coll;
}
BindNPWP();
}
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 GetNPWP(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 listNPWP = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "PerubahanNPWP"));
SPListItemCollection collSPPerubahanNPWP = listNPWP.GetItems(query);
List<NPWP> collDokumenNPWP = new List<NPWP>();
foreach (SPListItem i in collSPPerubahanNPWP)
{
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.Url = string.Format("<a href='/NPWPLainnya/{0}'>{0}</a>", i["Name"].ToString());
o.IsDeleted = false;
collDokumenNPWP.Add(o);
}
ViewState["NPWP"] = collDokumenNPWP;
}
