public int Save(PembayaranHutangProduk obj, bool isSaveFromPembelian)
{
var result = 0;
try
{
IDbTransaction transaction = null;
if (!isSaveFromPembelian)
{
_context.BeginTransaction();
transaction = _context.transaction;
}
obj.pembayaran_hutang_produk_id = _context.GetGUID();
if (obj.nota == null || obj.nota.Length == 0)
{
obj.nota = this.GetLastNota();
}
// insert header
_context.db.Insert <PembayaranHutangProduk>(obj, transaction);
// insert detil
foreach (var item in obj.item_pembayaran_hutang.Where(f => f.BeliProduk != null))
{
if (item.beli_produk_id.Length > 0)
{
item.item_pembayaran_hutang_produk_id = _context.GetGUID();
item.pembayaran_hutang_produk_id = obj.pembayaran_hutang_produk_id;
_context.db.Insert <ItemPembayaranHutangProduk>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
if (!isSaveFromPembelian)
{
_context.Commit();
}
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(JualProduk obj)
{
var result = 0;
try
{
_context.BeginTransaction();
var transaction = _context.transaction;
obj.jual_id = _context.GetGUID();
obj.total_nota = GetTotalNota(obj);
// insert header
_context.db.Insert <JualProduk>(obj, transaction);
// insert detail
foreach (var item in obj.item_jual.Where(f => f.Produk != null))
{
if (item.produk_id.Length > 0)
{
item.item_jual_id = _context.GetGUID();
item.jual_id = obj.jual_id;
item.pengguna_id = obj.pengguna_id;
_context.db.Insert <ItemJualProduk>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
// jika pembelian tunai, langsung insert ke pembayaran hutang
if (obj.tanggal_tempo.IsNull())
{
result = SavePembayaranPiutang(obj);
if (result > 0)
{
obj.total_pelunasan = obj.grand_total;
}
}
_context.Commit();
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(GajiKaryawan obj)
{
var result = 0;
try
{
if (IsExist(obj.karyawan_id, obj.bulan, obj.tahun)) // data gaji karyawan sudah diinputkan
{
return(0);
}
_context.BeginTransaction();
var transaction = _context.transaction;
if (obj.gaji_karyawan_id == null)
{
obj.gaji_karyawan_id = _context.GetGUID();
}
// insert header
_context.db.Insert <GajiKaryawan>(obj, transaction);
// insert detail
foreach (var item in obj.item_pembayaran_kasbon.Where(f => f.Kasbon != null))
{
if (item.kasbon_id.Length > 0)
{
item.pembayaran_kasbon_id = _context.GetGUID();
item.pengguna_id = obj.pengguna_id;
item.gaji_karyawan_id = obj.gaji_karyawan_id;
item.tanggal = obj.tanggal;
item.nota = obj.nota;
_context.db.Insert <PembayaranKasbon>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
_context.Commit();
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(PengeluaranBiaya obj)
{
var result = 0;
try
{
_context.BeginTransaction();
var transaction = _context.transaction;
if (obj.pengeluaran_id == null)
{
obj.pengeluaran_id = _context.GetGUID();
}
obj.total = GetTotalNota(obj);
// insert header
_context.db.Insert <PengeluaranBiaya>(obj, transaction);
// insert detail
foreach (var item in obj.item_pengeluaran_biaya.Where(f => f.JenisPengeluaran != null))
{
if (item.jenis_pengeluaran_id.Length > 0)
{
if (item.item_pengeluaran_id == null)
{
item.item_pengeluaran_id = _context.GetGUID();
}
item.pengeluaran_id = obj.pengeluaran_id;
item.pengguna_id = obj.pengguna_id;
_context.db.Insert <ItemPengeluaranBiaya>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
_context.Commit();
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(PembayaranPiutangProduk obj, bool isSaveFromPenjualan)
{
var result = 0;
try
{
IDbTransaction transaction = null;
if (!isSaveFromPenjualan)
{
_context.BeginTransaction();
transaction = _context.transaction;
}
obj.pembayaran_piutang_id = _context.GetGUID();
if (obj.nota == null || obj.nota.Length == 0)
{
obj.nota = this.GetLastNota();
}
// insert header
_context.db.Insert <PembayaranPiutangProduk>(obj, transaction);
// insert detil
foreach (var item in obj.item_pembayaran_piutang.Where(f => f.JualProduk != null))
{
if (item.jual_id.Length > 0)
{
item.item_pembayaran_piutang_id = _context.GetGUID();
item.pembayaran_piutang_id = obj.pembayaran_piutang_id;
_context.db.Insert <ItemPembayaranPiutangProduk>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
if (!isSaveFromPenjualan)
{
_context.Commit();
}
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Produk obj)
{
var result = 0;
try
{
if (!IsExist(obj.kode_produk))
{
if (obj.produk_id == null)
{
obj.produk_id = _context.GetGUID();
}
_context.BeginTransaction();
var transaction = _context.transaction;
_context.db.Insert <Produk>(obj, transaction);
foreach (var item in obj.list_of_harga_grosir)
{
var hargaGrosir = GetHargaGrosir(obj.produk_id, item.harga_ke, transaction);
if (hargaGrosir == null)
{
if (item.harga_grosir_id == null)
{
item.harga_grosir_id = _context.GetGUID();
}
item.produk_id = obj.produk_id;
_context.db.Insert <HargaGrosir>(item, transaction);
}
}
_context.Commit();
result = 1;
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(ReturJualProduk obj)
{
var result = 0;
try
{
_context.BeginTransaction();
var transaction = _context.transaction;
obj.retur_jual_id = _context.GetGUID();
obj.total_nota = GetTotalNota(obj);
// insert header
_context.db.Insert <ReturJualProduk>(obj, transaction);
// insert detil
foreach (var item in obj.item_retur.Where(f => f.Produk != null))
{
if (item.produk_id.Length > 0)
{
item.item_retur_jual_id = _context.GetGUID();
item.retur_jual_id = obj.retur_jual_id;
item.pengguna_id = obj.pengguna_id;
_context.db.Insert <ItemReturJualProduk>(item, transaction);
// update entity state
item.entity_state = EntityState.Unchanged;
}
}
_context.Commit();
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public void TestTran()
{
try
{
dapperContext.BeginTransaction();
var user = userInfoRepository.Get(5);
var model = villageRepository.Get(new Guid("6D880321-DB17-4B32-9F0A-CE9F3F25AA01"));
model.VillageName = "ccccccccccccccc";
villageRepository.Update(model);
user.GmtModified = DateTime.Now;
user.UserName = "******";
var result = userInfoRepository.Update(user);
dapperContext.Commit();
}
catch (Exception ex)
{
dapperContext.RollBack();
}
}
public void TestTran()
{
dapperContext.BeginTransaction();
dapperContext.Commit();
}
public void Commit()
{
_context.Commit();
}