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(Pengguna obj)
{
var result = 0;
try
{
var pengguna = GetByID(obj.nama_pengguna);
if (pengguna != null)
{
return(0); // nama pengguna sudah terdaftar
}
obj.pengguna_id = _context.GetGUID();
// password sudah dienkripsi dari aplikasi
_context.db.Insert <Pengguna>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Profil obj)
{
var result = 0;
try
{
var profil = GetProfil();
if (profil == null)
{
obj.profil_id = _context.GetGUID();
_context.db.Insert <Profil>(obj);
result = 1;
}
else
{
result = _context.db.Update <Profil>(obj) ? 1 : 0;
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Kasbon obj)
{
var result = 0;
try
{
if (obj.kasbon_id == null)
{
obj.kasbon_id = _context.GetGUID();
}
_context.db.Insert <Kasbon>(obj);
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Tambah data");
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 int Save(Customer obj)
{
var result = 0;
try
{
obj.customer_id = _context.GetGUID();
_context.db.Insert <Customer>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(SettingAplikasi obj)
{
var result = 0;
try
{
obj.setting_aplikasi_id = _context.GetGUID();
_context.db.Insert <SettingAplikasi>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(ItemMenu obj)
{
var result = 0;
try
{
obj.item_menu_id = _context.GetGUID();
_context.db.Insert <ItemMenu>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(MesinKasir obj)
{
var result = 0;
try
{
obj.mesin_id = _context.GetGUID();
_context.db.Insert <MesinKasir>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Golongan obj)
{
var result = 0;
try
{
obj.golongan_id = _context.GetGUID();
_context.db.Insert <Golongan>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(AlasanPenyesuaianStok obj)
{
var result = 0;
try
{
obj.alasan_penyesuaian_stok_id = _context.GetGUID();
_context.db.Insert <AlasanPenyesuaianStok>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(JenisPengeluaran obj)
{
var result = 0;
try
{
obj.jenis_pengeluaran_id = _context.GetGUID();
_context.db.Insert <JenisPengeluaran>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Kartu obj)
{
var result = 0;
try
{
obj.kartu_id = _context.GetGUID();
_context.db.Insert <Kartu>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Dropshipper obj)
{
var result = 0;
try
{
if (obj.dropshipper_id == null)
{
obj.dropshipper_id = _context.GetGUID();
}
_context.db.Insert <Dropshipper>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(PenyesuaianStok obj)
{
var result = 0;
try
{
if (obj.penyesuaian_stok_id == null)
{
obj.penyesuaian_stok_id = _context.GetGUID();
}
_context.db.Insert <PenyesuaianStok>(obj);
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Save(Jabatan obj)
{
var result = 0;
try
{
if (obj.jabatan_id == null)
{
obj.jabatan_id = _context.GetGUID();
}
_context.db.Insert <Jabatan>(obj);
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))
{
obj.produk_id = _context.GetGUID();
_context.db.Insert <Produk>(obj);
result = 1;
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}