public int AddJurnalUmum(OrderJurnalUmum oData) { methodName = "AddJurnalUmum"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; OrderJurnalUmum oNewumum = new OrderJurnalUmum(); oNewumum.MapFrom(oData); oNewumum = uow.OrderJurnalUmum.Add(oNewumum); uow.Save(); traceID = 3; oData.IdOrderJurnalUmum = oNewumum.IdOrderJurnalUmum; trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.IdOrderJurnalUmum); }
public bool EditJurnalUmum(OrderJurnalUmum oData, TransaksiJurnalUmum oDatas) { methodName = "EditJurnalUmum"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { traceID = 2; var oDBData = uow.OrderJurnalUmum.Get(oData.IdOrderJurnalUmum); if (oDBData != null) { using (var trans = uow.BeginTransaction()) { try { traceID = 3; oDBData.MapFrom(oData); uow.OrderJurnalUmum.Update(oDBData); if (oDBData.IdOrderJurnalUmum > 0) { traceID = 4; oData.IdOrderJurnalUmum = oDBData.IdOrderJurnalUmum; BukuBesar oNewTransjurnal = new BukuBesar(); oNewTransjurnal.MapFrom(oData); traceID = 5; oNewTransjurnal.IdRekeningPerkiraan = oData.IdRekeningPerkiraan; oNewTransjurnal.NoRekningPerkiraan = oData.NoRekeningPerkiraan; oNewTransjurnal.KodeTransaksi = "GJ"; oNewTransjurnal.IdKlasfikasi = oData.IdKlasifikasi; oNewTransjurnal.KlasifikasiAkun = oData.KlasifikasiRekeningPerkiraan; oNewTransjurnal.Deskripsi = oData.Keterangan; oNewTransjurnal.KursTukar = oData.Kurs; oNewTransjurnal.IdUserId = oData.IdUserId; oNewTransjurnal.IdPeriodeAkuntansi = oData.IdPeriodeAkuntasi; oNewTransjurnal.IdEmployee = oData.IdPetugas; oNewTransjurnal.RealRecordingTime = DateTime.Now; uow.BukuBesar.Add(oNewTransjurnal); } traceID = 6; uow.Save(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } } return(true); }
public OrderJurnalUmum GetData() { OrderJurnalUmum oData = new OrderJurnalUmum(); if (this.rekeningPerkiraanSelected != null) { oData.IdRekeningPerkiraan = this.rekeningPerkiraanSelected.Id; oData.NoRekeningPerkiraan = this.rekeningPerkiraanSelected.KodeRekening; oData.NamaRekeningPerkiraan = this.rekeningPerkiraanSelected.NamaRekeningPerkiraan; oData.IdKlasifikasi = this.rekeningPerkiraanSelected.IdKlasifikasiRekeningPerkiraan; oData.KlasifikasiRekeningPerkiraan = this.rekeningPerkiraanSelected.KlasifikasiRekeningPerkiraan; } oData.Debit = double.Parse(txtdebit.Text); oData.Kredit = double.Parse(txtkredit.Text); oData.Chkaktif = true; return(oData); }
public int AddTransaksiJurnalUmum(TransaksiJurnalUmum oData) { methodName = "AddTransaksiJurnalUmum"; traceID = 1; using (var uow = new UnitOfWork(AppConfig.Current.ContextName)) { using (var trans = uow.BeginTransaction()) { try { traceID = 2; TransaksiJurnalUmum oNewData = new TransaksiJurnalUmum(); oNewData.MapFrom(oData); oNewData = uow.TransaksiJurnalUmum.Add(oNewData); uow.Save(); oData.IdTransaksiJurnalUmum = oNewData.IdTransaksiJurnalUmum; OrderJurnalUmum oDBMataUang = uow.OrderJurnalUmum.SingleOrDefault(m => m.IdTransaksiJurnalUmum == oData.IdTransaksiJurnalUmum); if (oDBMataUang != null) { oDBMataUang.MapFrom(oData); oDBMataUang.IdTransaksiJurnalUmum = oData.IdTransaksiJurnalUmum; // oDBMataUang.TglKursMataUang = oData.Tanggal; uow.OrderJurnalUmum.Update(oDBMataUang); } uow.Save(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw new AppException(500, methodName, traceID, ex); } } } return(oData.IdTransaksiJurnalUmum); }
private void BtnSave_Click(object sender, RoutedEventArgs e) { if (Tanggaljurnalumum.Text == "" || nojurnal.Text == "" || cbcurrency.Text == "") { MessageBox.Show("please fill in the blank fields", ("Form Validation"), MessageBoxButton.OK, MessageBoxImage.Error); return; } TransaksiJurnalUmumBLL transaksiJurnalUmumBLL = new TransaksiJurnalUmumBLL(); TransaksiJurnalUmumBLL TransaksiJurnalUmumBLL = new TransaksiJurnalUmumBLL(); TransaksiJurnalUmum transaksiJurnal = new TransaksiJurnalUmum(); OrderJurnalUmum jurnalUmum = new OrderJurnalUmum(); BukuBesar bukubesar = new BukuBesar(); transaksiJurnal.TotalDebit = double.Parse(txttotaldebit.Text); transaksiJurnal.TotalKredit = double.Parse(txttotalkredit.Text); transaksiJurnal.Balance = double.Parse(txtbalance.Text); transaksiJurnal.NoTransaksiJurnalUmum = double.Parse(nojurnal.Text); transaksiJurnal.Keterangan = txtnote.Text; transaksiJurnal.Tanggal = DateTime.Parse(Tanggaljurnalumum.Text); transaksiJurnal.IdKodeTransaksi = 1; transaksiJurnal.IdReferalTransaksi = 1; transaksiJurnal.IdPeriodeAkuntasi = 1; if (this.dataMataUangselected != null) { transaksiJurnal.IdMataUang = this.dataMataUangselected.Id; transaksiJurnal.MataUang = this.dataMataUangselected.KodeMataUang; transaksiJurnal.Kurs = this.dataMataUangselected.KursTukar; } if (this.kontakSelected != null) { transaksiJurnal.IdPetugas = this.kontakSelected.Id; transaksiJurnal.NamaPetugas = this.kontakSelected.NamaA; } if (double.Parse(txtbalance.Text) != 0) { MessageBox.Show("Total Balance Must 0 !"); return; } if (this.dokumenSelected != null) { transaksiJurnal.IdNoRefensiDokumen = this.dokumenSelected.Id; transaksiJurnal.NoRefensiDokumen = this.dokumenSelected.NoReferensiDokumen; } transaksiJurnal.RealRecordingTime = DateTime.Now; if (TransaksiJurnalUmumBLL.AddTransaksiJurnalUmum(transaksiJurnal) > 0) { // this.ClearForm(); MessageBox.Show("General Journal successfully added !"); } else { MessageBox.Show("General Journal failed to add !"); } if (DGJurnal.Items.Count > 0) { foreach (var item in DGJurnal.Items) { if (item is OrderJurnalUmum) { OrderJurnalUmum oNewData1 = (OrderJurnalUmum)item; oNewData1.IdKodeTransaksi = 1; oNewData1.IdReferalTransaksi = 1; oNewData1.IdPeriodeAkuntasi = 1; oNewData1.Tanggal = DateTime.Parse(Tanggaljurnalumum.Text); oNewData1.NoTransaksiJurnalUmum = double.Parse(nojurnal.Text); oNewData1.Keterangan = txtnote.Text; if (this.dataMataUangselected != null) { oNewData1.IdMataUang = this.dataMataUangselected.Id; oNewData1.MataUang = this.dataMataUangselected.KodeMataUang; oNewData1.Kurs = this.dataMataUangselected.KursTukar; } if (this.kontakSelected != null) { oNewData1.IdPetugas = this.kontakSelected.Id; oNewData1.NamaPetugas = this.kontakSelected.NamaA; } oNewData1.IdTransaksiJurnalUmum = transaksiJurnal.IdTransaksiJurnalUmum; oNewData1.Chkaktif = false; if (transaksiJurnalUmumBLL.EditJurnalUmum(oNewData1, transaksiJurnal) == true) { } } } GeneralJournal v = new GeneralJournal(); Switcher.Switchnewjurnal(v); } }