示例#1
0
        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);
        }
示例#2
0
        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);
        }
示例#3
0
        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);
        }
示例#4
0
        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;
     }
 }
示例#6
0
 private void Cbdokumen_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     this.dokumenSelected = null;
     if (srdokumen.SelectedItem != null)
     {
         this.dokumenSelected = (Dokumen)srdokumen.SelectedItem;
     }
 }
示例#7
0
 private void dokumen_selectedchange(object sender, SelectionChangedEventArgs e)
 {
     this.dokumenSelected = null;
     if (srdocumentnumber.SelectedItem != null)
     {
         this.dokumenSelected = (Dokumen)srdocumentnumber.SelectedItem;
     }
 }
示例#8
0
 public void Create(Dokumen obj)
 {
     try
     {
         _db.Dokumen.Add(obj);
         _db.SaveChanges();
     }
     catch (DbUpdateException dbEx)
     {
         throw new Exception(dbEx.Message);
     }
 }
示例#9
0
 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        = "";
 }
示例#10
0
 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());
     }
 }
示例#11
0
        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));
        }
示例#12
0
        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 }));
        }
示例#13
0
 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);
     }
 }
示例#14
0
 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();
 }
示例#15
0
        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();
        }
示例#17
0
 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);
        }