public async Task <bool> AddIcItem(IcItemView produk)
{
string test = produk.ItemCode.ToUpper();
var cekFirst = _context.IcItems.Where(x => x.ItemCode == test).ToList();
if (cekFirst.Count == 0)
{
IcItem Produk = new IcItem()
{
ItemCode = produk.ItemCode.ToUpper(),
NamaItem = produk.NamaItem,
Satuan = produk.Satuan,
Divisi = produk.Divisi,
JnsBrng = produk.JnsBrng,
CostMethod = produk.CostMethod,
AcctSet = produk.AcctSet,
Category = produk.Category,
NamaLengkap = produk.NamaLengkap
};
_context.IcItems.Add(Produk);
await _context.SaveChangesAsync();
return(true);
}
else
{
return(false);
}
}
public async Task <bool> EditTransH(IcTransHView trans)
{
var ExistingTrans = _context.IcTransHs.Where(x => x.IcTransHId == trans.IcTransHId).FirstOrDefault();
/* transaksi lama dikurangi */
if (ExistingTrans != null)
{
foreach (var item in ExistingTrans.IcTransDs)
{
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem itemlokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == item.Lokasi).FirstOrDefault();
if (itemlokasi1 != null)
{
itemlokasi1.Qty += item.QtyShp;
_context.IcAltItems.Update(itemlokasi1);
}
IcAltItem itemlokasi2 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == item.Lokasi2).FirstOrDefault();
if (itemlokasi2 != null)
{
itemlokasi2.Qty -= item.QtyShp;
_context.IcAltItems.Update(itemlokasi2);
}
}
_context.IcTransHs.Remove(ExistingTrans);
}
}
/* transaksi update */
IcTransH transH = new IcTransH
{
NoFaktur = ExistingTrans.NoFaktur,
Tanggal = trans.Tanggal,
Keterangan = trans.Keterangan,
Lokasi = trans.Lokasi,
Lokasi2 = trans.Lokasi2,
Kode = "90",
IcTransDs = new List <IcTransD>()
};
foreach (var item in trans.IcTransDs)
{
transH.IcTransDs.Add(new IcTransD()
{
ItemCode = item.ItemCode,
NamaItem = item.NamaItem,
QtyShp = item.QtyShp,
Kode = "90",
Lokasi = transH.Lokasi,
Lokasi2 = transH.Lokasi2,
NoFaktur = transH.NoFaktur,
Tanggal = trans.Tanggal
});
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == transH.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = transH.Lokasi,
Qty = -1 * item.QtyShp
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty -= item.QtyShp;
_context.IcAltItems.Update(cekLokasi1);
}
/** lokasi 2 **/
IcAltItem cekLokasi2 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == transH.Lokasi2).FirstOrDefault();
if (cekLokasi2 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = transH.Lokasi2,
Qty = item.QtyShp
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi2.Qty += item.QtyShp;
_context.IcAltItems.Update(cekLokasi2);
}
}
}
_context.IcTransHs.Add(transH);
await _context.SaveChangesAsync();
return(true);
}
public async Task <bool> AddTransH(IcTransHView trans)
{
//string test = codeview.SrcCode.ToUpper();
//var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList();
IcTransH transH = new IcTransH
{
NoFaktur = GetNumber(),
Tanggal = trans.Tanggal,
Keterangan = trans.Keterangan,
Lokasi = trans.Lokasi,
Lokasi2 = trans.Lokasi2,
Kode = "90",
IcTransDs = new List <IcTransD>()
};
foreach (var item in trans.IcTransDs)
{
transH.IcTransDs.Add(new IcTransD()
{
ItemCode = item.ItemCode,
NamaItem = item.NamaItem,
QtyShp = item.QtyShp,
Kode = "90",
Lokasi = item.Lokasi,
Lokasi2 = item.Lokasi2,
NoFaktur = transH.NoFaktur,
Tanggal = trans.Tanggal
});
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == item.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = item.Lokasi,
Qty = -1 * item.QtyShp
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty -= item.QtyShp;
_context.IcAltItems.Update(cekLokasi1);
}
/** lokasi 2 **/
IcAltItem cekLokasi2 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == item.Lokasi2).FirstOrDefault();
if (cekLokasi2 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = item.Lokasi2,
Qty = item.QtyShp
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi2.Qty += item.QtyShp;
_context.IcAltItems.Update(cekLokasi2);
}
}
}
_context.IcTransHs.Add(transH);
await _context.SaveChangesAsync();
return(true);
}
public async Task <bool> AddTransH(OeTransHView trans)
{
//string test = codeview.SrcCode.ToUpper();
//var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList();
decimal mQty5 = 0;
OeTransH transH = new OeTransH
{
NoLpb = trans.Status == "Tax" ? GetNumberTax() : GetNumber(),
Customer = trans.Customer.ToUpper(),
NamaCust = trans.NamaCust,
Lokasi = trans.Lokasi.ToUpper(),
Tanggal = trans.Tanggal,
Keterangan = trans.Keterangan,
Jumlah = trans.Jumlah,
Ongkos = trans.Ongkos,
Ppn = trans.Ppn,
PpnPersen = trans.PpnPersen,
TtlJumlah = trans.TtlJumlah,
DPayment = trans.DPayment,
Tagihan = trans.Tagihan,
TotalQty = trans.TotalQty,
Status = trans.Status,
Kode = "94",
Cek = "1",
OeTransDs = new List <OeTransD>()
};
foreach (var item in trans.OeTransDs)
{
if (item.Qty != 0)
{
if (transH.TotalQty != 0)
{
mQty5 = (item.Jumlah - item.Discount) - (item.Qty / transH.TotalQty * transH.Ppn) + (item.Qty / transH.TotalQty * transH.Ongkos);
}
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == trans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = trans.Lokasi,
Qty = -1 * item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty -= item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
cekItem.HrgJual = item.Harga;
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty -= item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost -= item.Cost;
}
transH.OeTransDs.Add(new OeTransD()
{
ItemCode = item.ItemCode.ToUpper(),
NamaItem = item.NamaItem,
Satuan = item.Satuan,
Lokasi = transH.Lokasi,
Harga = item.Harga,
Qty = item.Qty,
Persen = item.Persen,
Discount = item.Discount,
Jumlah = item.Jumlah,
Kode = "94",
NoLpb = transH.NoLpb,
Tanggal = trans.Tanggal,
HrgCost = item.HrgCost,
Cost = item.Cost,
JumDpp = mQty5
});
_context.IcItems.Update(cekItem);
}
}
_context.OeTransHs.Add(transH);
}
var customer = GetCustomerId(transH.Customer);
ArPiutng piutang = new ArPiutng
{
Kode = "OE",
Dokumen = transH.NoLpb,
Tanggal = transH.Tanggal,
DueDate = transH.Tanggal.AddDays(customer.Termin),
Customer = transH.Customer,
Keterangan = transH.Keterangan,
Jumlah = transH.Jumlah,
Sisa = transH.Jumlah,
SldSisa = transH.Jumlah,
KodeTran = transH.Kode
};
_context.ArPiutngs.Add(piutang);
customer.Piutang += transH.Jumlah;
_context.ArCusts.Update(customer);
await _context.SaveChangesAsync();
return(true);
}
public async Task <bool> DelTransH(int id)
{
try
{
var ExistingTrans = _context.OeTransHs.Where(x => x.OeTransHId == id).FirstOrDefault();
if (ExistingTrans != null)
{
foreach (var item in ExistingTrans.OeTransDs)
{
if (item.Qty != 0)
{
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == ExistingTrans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = ExistingTrans.Lokasi,
Qty = item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty += item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty += item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost += item.Cost;
}
_context.IcItems.Update(cekItem);
}
}
}
var customer = GetCustomerId(ExistingTrans.Customer);
var piutang = GetPiutang(ExistingTrans.NoLpb);
customer.Piutang -= ExistingTrans.Jumlah;
_context.ArCusts.Update(customer);
_context.ArPiutngs.Remove(piutang);
_context.OeTransHs.Remove(ExistingTrans);
await _context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
public async Task <bool> AddTransH(IrTransHView trans)
{
//string test = codeview.SrcCode.ToUpper();
//var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList();
decimal mQty5 = 0;
IrTransH transH = new IrTransH
{
NoLpb = GetNumber(),
Supplier = trans.Supplier.ToUpper(),
NamaSup = trans.NamaSup,
Lokasi = trans.Lokasi.ToUpper(),
Tanggal = trans.Tanggal,
Keterangan = trans.Keterangan,
Jumlah = trans.Jumlah,
Ongkos = trans.Ongkos,
Ppn = trans.Ppn,
PpnPersen = trans.PpnPersen,
TtlJumlah = trans.TtlJumlah,
DPayment = trans.DPayment,
Tagihan = trans.Tagihan,
TotalQty = trans.TotalQty,
Kode = "82",
Cek = "1",
IrTransDs = new List <IrTransD>()
};
foreach (var item in trans.IrTransDs)
{
if (item.Qty != 0)
{
if (transH.TotalQty != 0)
{
mQty5 = (item.Jumlah - item.Discount) - (item.Qty / transH.TotalQty * transH.Ppn) + (item.Qty / transH.TotalQty * transH.Ongkos);
}
transH.IrTransDs.Add(new IrTransD()
{
ItemCode = item.ItemCode.ToUpper(),
NamaItem = item.NamaItem,
Satuan = item.Satuan,
Lokasi = transH.Lokasi,
Harga = item.Harga,
Qty = item.Qty,
Persen = item.Persen,
Discount = item.Discount,
Jumlah = item.Jumlah,
Kode = "82",
NoLpb = transH.NoLpb,
Tanggal = trans.Tanggal,
JumDpp = mQty5
});
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
#region altitem
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == trans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = trans.Lokasi,
Qty = item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty += item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
#endregion altitem
cekItem.Harga = item.Harga; // harga beli barang
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty += item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost += mQty5;
}
if (cekItem.Qty != 0)
{
cekItem.HrgNetto = cekItem.Cost / cekItem.Qty;
}
else
{
cekItem.HrgNetto = cekItem.Harga;
}
_context.IcItems.Update(cekItem);
}
}
_context.IrTransHs.Add(transH);
}
ApHutang hutang = new ApHutang
{
Kode = "IR",
Dokumen = transH.NoLpb,
Tanggal = transH.Tanggal,
DueDate = transH.Tanggal,
Supplier = transH.Supplier,
Keterangan = transH.Keterangan,
Jumlah = transH.Jumlah,
Sisa = transH.Jumlah,
SldSisa = transH.Jumlah,
KodeTran = transH.Kode
};
_context.ApHutangs.Add(hutang);
var supplier = GetSupplierId(transH.Supplier);
supplier.Hutang += transH.Jumlah;
_context.ApSuppls.Update(supplier);
await _context.SaveChangesAsync();
return(true);
}
public async Task <bool> EditTransH(IrTransHView trans)
{
decimal mQty5 = 0;
var cekFirst = _context.ApHutangs.Where(x => x.Dokumen == trans.NoLpb).FirstOrDefault();
if (cekFirst != null)
{
try
{
var ExistingTrans = _context.IrTransHs.Where(x => x.IrTransHId == trans.IrTransHId).FirstOrDefault();
if (ExistingTrans != null)
{
foreach (var item in ExistingTrans.IrTransDs)
{
if (item.Qty != 0)
{
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == ExistingTrans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = ExistingTrans.Lokasi,
Qty = -1 * item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty -= item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty -= item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost -= item.JumDpp;
}
if (cekItem.Qty != 0)
{
cekItem.HrgNetto = cekItem.Cost / cekItem.Qty;
}
else
{
cekItem.HrgNetto = cekItem.Harga;
}
_context.IcItems.Update(cekItem);
}
}
}
var existingsupplier = GetSupplierId(ExistingTrans.Supplier);
existingsupplier.Hutang -= ExistingTrans.Jumlah;
_context.ApSuppls.Update(existingsupplier);
_context.ApHutangs.Remove(cekFirst);
_context.IrTransHs.Remove(ExistingTrans);
/* update nya */
IrTransH transH = new IrTransH
{
NoLpb = trans.NoLpb,
Supplier = trans.Supplier.ToUpper(),
NamaSup = trans.NamaSup,
Lokasi = trans.Lokasi.ToUpper(),
Tanggal = trans.Tanggal,
Keterangan = trans.Keterangan,
Jumlah = trans.Jumlah,
Ongkos = trans.Ongkos,
Ppn = trans.Ppn,
PpnPersen = trans.PpnPersen,
TtlJumlah = trans.TtlJumlah,
DPayment = trans.DPayment,
Tagihan = trans.Tagihan,
TotalQty = trans.TotalQty,
Kode = "82",
Cek = "1",
IrTransDs = new List <IrTransD>()
};
foreach (var item in trans.IrTransDs)
{
if (item.Qty != 0)
{
if (transH.TotalQty != 0)
{
mQty5 = (item.Jumlah - item.Discount) - (item.Qty / transH.TotalQty * transH.Ppn) + (item.Qty / transH.TotalQty * transH.Ongkos);
}
transH.IrTransDs.Add(new IrTransD()
{
ItemCode = item.ItemCode.ToUpper(),
NamaItem = item.NamaItem,
Satuan = item.Satuan,
Lokasi = transH.Lokasi,
Harga = item.Harga,
Qty = item.Qty,
Persen = item.Persen,
Discount = item.Discount,
Jumlah = item.Jumlah,
Kode = "82",
NoLpb = transH.NoLpb,
Tanggal = trans.Tanggal,
JumDpp = mQty5
});
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == trans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = trans.Lokasi,
Qty = item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty += item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty += item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost += mQty5;
}
if (cekItem.Qty != 0)
{
cekItem.HrgNetto = cekItem.Cost / cekItem.Qty;
}
else
{
cekItem.HrgNetto = cekItem.Harga;
}
_context.IcItems.Update(cekItem);
}
}
}
ApHutang hutang = new ApHutang
{
Kode = "IR",
Dokumen = transH.NoLpb,
Tanggal = transH.Tanggal,
DueDate = transH.Tanggal,
Supplier = transH.Supplier,
Keterangan = transH.Keterangan,
Jumlah = transH.Jumlah,
Sisa = transH.Jumlah,
SldSisa = transH.Jumlah,
KodeTran = transH.Kode
};
var supplier = GetSupplierId(transH.Supplier);
supplier.Hutang += transH.Jumlah;
_context.IrTransHs.Add(transH);
_context.ApSuppls.Update(supplier);
_context.ApHutangs.Add(hutang);
await _context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
return(false);
}
public async Task <bool> DelTransH(int id)
{
try
{
var ExistingTrans = _context.IrTransHs.Where(x => x.IrTransHId == id).FirstOrDefault();
if (ExistingTrans != null)
{
foreach (var item in ExistingTrans.IrTransDs)
{
if (item.Qty != 0)
{
IcItem cekItem = _context.IcItems.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault();
if (cekItem != null)
{
IcAltItem cekLokasi1 = _context.IcAltItems.Where(x => x.ItemCode == item.ItemCode && x.Lokasi == ExistingTrans.Lokasi).FirstOrDefault();
if (cekLokasi1 == null)
{
IcAltItem Produk = new IcAltItem()
{
ItemCode = cekItem.ItemCode.ToUpper(),
NamaItem = cekItem.NamaItem,
Satuan = cekItem.Satuan,
Lokasi = ExistingTrans.Lokasi,
Qty = -1 * item.Qty
};
_context.IcAltItems.Add(Produk);
}
else
{
cekLokasi1.Qty -= item.Qty;
_context.IcAltItems.Update(cekLokasi1);
}
// cekItem.Qty -= item.Qty;
// cekItem.Cost -= item.JumDpp;
if (cekItem.JnsBrng.Equals("Stock")) // jika stock
{
cekItem.Qty -= item.Qty;
}
if (cekItem.CostMethod.Equals("Moving Avarage")) // jika moving avarage
{
cekItem.Cost -= item.JumDpp;
}
if (cekItem.Qty != 0)
{
cekItem.HrgNetto = cekItem.Cost / cekItem.Qty;
}
else
{
cekItem.HrgNetto = cekItem.Harga;
}
_context.IcItems.Update(cekItem);
}
}
}
var supplier = GetSupplierId(ExistingTrans.Supplier);
var hutang = GetHutang(ExistingTrans.NoLpb);
supplier.Hutang -= ExistingTrans.Jumlah;
_context.ApSuppls.Update(supplier);
_context.ApHutangs.Remove(hutang);
_context.IrTransHs.Remove(ExistingTrans);
await _context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
