public bool EditDokumen(Dokumen oData) { methodName = "EditDokumen"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.Dokumen.Get(oData.Id); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.Dokumen.Update(oDBData); uow.Save(); traceID = 4; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
public int AddDokumen(Dokumen oData) { methodName = "AddDokumen"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Dokumen oNewDokumen = new Dokumen(); oNewDokumen.MapFrom(oData); oNewDokumen = uow.Dokumen.Add(oNewDokumen); uow.Save(); traceID = 3; oData.Id = oNewDokumen.Id; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.Id); }
public bool RemoveDokumen(int id) { methodName = "RemoveDokumen"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; Dokumen oDBDokumen = uow.Dokumen.SingleOrDefault(m => m.Id == id); if (oDBDokumen != null) { traceID = 3; uow.Dokumen.Remove(id); uow.Save(); } traceID = 5; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(true); }
private Dokumen GetData() { Dokumen oData = new Dokumen(); oData.NoReferensiDokumen = txtDocumentNo.Text; if (this.TypeDokumenSelected != null) { oData.IdTypeDokumen = this.TypeDokumenSelected.Id; oData.TypeDokumen = this.TypeDokumenSelected.Type; } if (!string.IsNullOrEmpty(Tanggal.Text)) { oData.TanggalDokumen = DateTime.Parse(Tanggal.Text); } oData.KeteranganDokumen = txtDescription.Text; if (this.KontakSelected != null) { oData.IdKontak = this.KontakSelected.Id; oData.PelangganDokumen = this.KontakSelected.NamaA; } if (this.Selectdepartment != null) { oData.IdDepartmen = this.Selectdepartment.Id; } if (this.Selectproyek != null) { oData.IdProyek = this.Selectproyek.Id; } oData.UploadFile1 = this.UploadFileA; oData.UploadFile2 = this.UploadFileB; oData.UploadFile3 = this.UploadFileC; oData.UploadFile4 = this.UploadFileD; return(oData); }
private void dokumen_selectionchange(object sender, SelectionChangedEventArgs e) { this.dokumenSelected = null; if (srnorefrensidokumen.SelectedItem != null) { dokumenSelected = (Dokumen)srnorefrensidokumen.SelectedItem; } }
private void Cbdokumen_SelectionChanged(object sender, SelectionChangedEventArgs e) { this.dokumenSelected = null; if (srdokumen.SelectedItem != null) { this.dokumenSelected = (Dokumen)srdokumen.SelectedItem; } }
private void dokumen_selectedchange(object sender, SelectionChangedEventArgs e) { this.dokumenSelected = null; if (srdocumentnumber.SelectedItem != null) { this.dokumenSelected = (Dokumen)srdocumentnumber.SelectedItem; } }
public void Create(Dokumen obj) { try { _db.Dokumen.Add(obj); _db.SaveChanges(); } catch (DbUpdateException dbEx) { throw new Exception(dbEx.Message); } }
private void ClearForm() { Tanggaljurnalumum.Text = DateTime.Now.ToShortDateString(); this.dokumenSelected = null; srnodokumen.Text = ""; nojurnal.Text = ""; this.dataMataUangselected = null; cbcurrency.SelectedIndex = -1; txtnote.Text = ""; txttotaldebit.Text = "0"; txttotalkredit.Text = "0"; txtbalance.Text = "0"; this.kontakSelected = null; srstaff.Text = ""; }
public ActionResult Edit(Dokumen dokumen) { try { _dokumen.Update(dokumen); TempData["Keterangan"] = $"<span class='alert alert-success'>Data klasifikasi {dokumen.NamaDokumen} sudah berhasil diedit !</span>"; return(RedirectToAction(nameof(Index))); } catch (Exception ex) { ViewBag.Error = $"<span class='alert alert-danger'>Kesalahan {ex.Message}</span>"; return(View()); } }
public ActionResult View(int id, string caller) { Context.Dokumen dbitem = RepoDokumen.FindByPK(id); Dokumen model = new Dokumen(dbitem); ViewBag.caller = caller; if (caller == "admin") { ViewBag.Title = "Dokumen Admin Surat Jalan"; } else { ViewBag.Title = "Dokumen Billing"; } return(View("View", model)); }
public ActionResult Edit(Dokumen model, string btnSubmit, string caller) { Context.Dokumen dbitem = RepoDokumen.FindByPK(model.Id); DokumenItem[] resDok = JsonConvert.DeserializeObject <DokumenItem[]>(model.strDokumen); string strQuery = ""; foreach (var item in resDok.Where(d => d.IsEdit)) { item.SetDb(dbitem.DokumenItem.Where(d => d.Id == item.Id).FirstOrDefault()); dbitem.DokumenItemHistory.Add(item.SetDbHistory(new Context.DokumenItemHistory())); strQuery += "INSERT INTO dbo.\"DokumenItemHistory\" (\"IdDok\", \"Nama\", \"Jml\", \"Warna\", \"Stempel\", \"Lengkap\", \"KeteranganAdmin\", \"KeteranganBilling\", \"ModifiedDate\") VALUES (" + dbitem.Id + ", " + item.Nama + ", " + item.Jml + ", " + item.Warna + ", " + item.Stempel + ", " + item.Lengkap + ", " + item.KeteranganAdmin + ", " + item.KeteranganBilling + ", " + dbitem.ModifiedDate + ");"; } if (btnSubmit == "Kirim") { dbitem.IsAdmin = false; } else if (btnSubmit == "Submit") { dbitem.IsAdmin = true; if (caller != "Admin") { dbitem.IsReturn = true; } } else if (btnSubmit == "Terima") { //create soship string sod_oid = Guid.NewGuid().ToString(); Context.SalesOrder dbso = dbitem.SalesOrder; string code = (dbso.SalesOrderOncallId.HasValue ? dbso.SalesOrderOncall.SONumber : dbso.SalesOrderProsesKonsolidasiId.HasValue ? dbso.SalesOrderProsesKonsolidasi.SONumber : dbso.SalesOrderPickupId.HasValue ? dbso.SalesOrderPickup.SONumber : dbso.SalesOrderKontrak.SONumber); string ship_guid = Guid.NewGuid().ToString(); string guid; string sod_guid; dbitem.IsComplete = true; SyncToERP(dbso, sod_oid); guid = Reposo_mstr.FindByPK(code).so_oid; sod_guid = Reposo_mstr.FindSoDet(code).so_oid; Reposo_mstr.saveSoShipMstr(dbso, UserPrincipal.username, guid, ship_guid); Reposo_mstr.saveSoShipDet(dbso, UserPrincipal.username, ship_guid, sod_oid); } RepoDokumen.save(dbitem, UserPrincipal.id, strQuery); return(RedirectToAction("Index", new { caller = caller })); }
public void Update(Dokumen obj) { try { var result = GetById(obj.DokumenID); result.KodeKlasifikasi = obj.KodeKlasifikasi; result.NamaDokumen = obj.NamaDokumen; result.Sumber = obj.Sumber; result.Keterangan = obj.Keterangan; result.TanggalDibuat = obj.TanggalDibuat; result.TanggalDiterima = obj.TanggalDiterima; _db.SaveChanges(); } catch (DbUpdateException dbEx) { throw new Exception(dbEx.Message); } }
public void save(Dokumen dbitem, int id, string strQuery = null) { if (dbitem.Id == 0) //create { context.Dokumen.Add(dbitem); } else //edit { context.Dokumen.Attach(dbitem); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; var query = "UPDATE dbo.\"Dokumen\" SET \"IsComplete\" = " + dbitem.IsComplete + " \"ModifiedDate\" = " + dbitem.ModifiedDate + "\"IsReturn\" = " + dbitem.IsReturn + " WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Dokumen", QueryDetail = query + (strQuery == null ? "" : strQuery), RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } context.SaveChanges(); }
public ActionResult Edit(int id, string caller) { Context.Dokumen dbitem = RepoDokumen.FindByPK(id); List <int> ListIdDokumen = dbitem.DokumenItem.Select(b => b.IdBilling).ToList(); string strQuery = ""; //cek apakah di billing customer ada penambahan data //jika ada maka update data jika data dokumen belum close if (!dbitem.IsComplete) { Context.Customer dbcust = dbitem.Customer; foreach (var itemBilling in dbitem.Customer.CustomerBilling.Where(i => !ListIdDokumen.Contains(i.Id)).ToList()) { dbitem.DokumenItem.Add(new Context.DokumenItem() { IdBilling = itemBilling.Id, CustomerId = itemBilling.CustomerId, ModifiedDate = DateTime.Now, }); strQuery += "INSERT INTO dbo.\"DokumenItem\" (\"IdBilling\", \"CustomerId\", \"ModifiedDate\") VALUES (" + itemBilling.Id + ", " + itemBilling.CustomerId + ", " + DateTime.Now + ");"; } RepoDokumen.save(dbitem, UserPrincipal.id, strQuery); } if (dbitem.SalesOrder.SalesOrderOncallId.HasValue) { ViewBag.TanggalPulang = dbitem.SalesOrder.SalesOrderOncall.TanggalMuat.Value.AddDays(RepoSalesOrder.FindRute(dbitem.SalesOrder.SalesOrderOncall.IdDaftarHargaItem.Value).WaktuKerja); } Dokumen model = new Dokumen(dbitem); ViewBag.caller = caller; if (caller == "admin") { ViewBag.Title = "Dokumen Admin Surat Jalan"; } else { ViewBag.Title = "Dokumen Billing"; } return(View("Form", model)); }
protected void dgDokumenLainnya_ItemCommand(object source, DataGridCommandEventArgs e) { List<Dokumen> coll = new List<Dokumen>(); if (ViewState["Dokumen"] != null) coll = ViewState["Dokumen"] as List<Dokumen>; if (e.CommandName == "add") { TextBox txtPenjelasanAdd = e.Item.FindControl("txtPenjelasanAdd") as TextBox; FileUpload fuAdd = e.Item.FindControl("fuAdd") as FileUpload; DropDownList ddlTipeDokumenAdd = e.Item.FindControl("ddlTipeDokumenAdd") as DropDownList; if (isExistInDokumenGrid(fuAdd.FileName, "lblAtttachmentHidden")) { Util.ShowMessage(Page, SR.DataIsExist(fuAdd.FileName)); return; } Dokumen o = new Dokumen(); 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.TipeDokumen = ddlTipeDokumenAdd.SelectedValue; o.NamaFile = fuAdd.FileName; o.Penjelasan = txtPenjelasanAdd.Text.Trim(); o.ID = 0; coll.Add(o); ViewState["Dokumen"] = coll; } if (e.CommandName == "save") { TextBox txtPenjelasanEdit = e.Item.FindControl("txtPenjelasanEdit") as TextBox; FileUpload fuEdit = e.Item.FindControl("fuEdit") as FileUpload; DropDownList ddlTipeDokumenEdit = e.Item.FindControl("ddlTipeDokumenEdit") as DropDownList; if (isExistInDokumenGrid(fuEdit.FileName, "lblAtttachmentHidden")) { Util.ShowMessage(Page, SR.DataIsExist(fuEdit.FileName)); return; } Dokumen o = coll[e.Item.ItemIndex]; 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.Penjelasan = txtPenjelasanEdit.Text.Trim(); o.TipeDokumen = ddlTipeDokumenEdit.SelectedValue; coll[e.Item.ItemIndex] = o; ViewState["Dokumen"] = coll; dgDokumenLainnya.EditItemIndex = -1; dgDokumenLainnya.ShowFooter = true; } if (e.CommandName == "edit") { dgDokumenLainnya.ShowFooter = false; dgDokumenLainnya.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dgDokumenLainnya.EditItemIndex = -1; dgDokumenLainnya.ShowFooter = true; } if (e.CommandName == "delete") { coll.RemoveAt(e.Item.ItemIndex); ViewState["Dokumen"] = coll; } BindDokumen(); }
public void Update(Dokumen obj) { throw new NotImplementedException(); }
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); }