public bool RemoveTransaksiJurnalUmum(int id)
{
methodName = "RemoveTransaksiJurnalUmum";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
TransaksiJurnalUmum oDBTransaksiJurnalUmum = uow.TransaksiJurnalUmum.SingleOrDefault(m => m.IdTransaksiJurnalUmum == id);
if (oDBTransaksiJurnalUmum != null)
{
traceID = 3;
uow.TransaksiJurnalUmum.Remove(id);
uow.Save();
}
traceID = 5;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(true);
}
public bool EditTransaksiJurnalUmum(TransaksiJurnalUmum oData)
{
methodName = "EditTransaksiJurnalUmum";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.TransaksiJurnalUmum.Get(oData.IdTransaksiJurnalUmum);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.TransaksiJurnalUmum.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
private void DGjurnal_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.transaksiJurnalSelected = null;
if (DGGeneral.SelectedItem != null)
{
this.transaksiJurnalSelected = (TransaksiJurnalUmum)DGGeneral.SelectedItem;
}
}
private void nojurnal_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.transaksiJurnalSelected = null;
if (srnojurnal.SelectedItem != null)
{
this.transaksiJurnalSelected = (TransaksiJurnalUmum)srnojurnal.SelectedItem;
}
this.LoadtransJurnalUmum();
}
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);
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (this.transaksiJurnalSelected == null)
{
MessageBox.Show("Jurnal Umum belum dipilih !");
}
else
{
TransaksiJurnalUmumBLL TransaksiJurnalUmumBLL = new TransaksiJurnalUmumBLL();
if (TransaksiJurnalUmumBLL.RemoveTransaksiJurnalUmum(this.transaksiJurnalSelected.IdTransaksiJurnalUmum) == true)
{
MessageBox.Show("Jurnal Umum berhasil dihapus");
this.LoadJurnalUmum();
this.transaksiJurnalSelected = null;
}
}
}
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);
}
}
