private string GenNewID()
{
var prefix = "S";
var result = _paramNoBL.GenNewID(prefix, 5);
return(result);
}
private string GenNewID()
{
var prefix = "BY" + DateTime.Now.ToString("yyMM");
var result = _paramNoBL.GenNewID(prefix, 10);
return(result);
}
public PenjualanModel Save(PenjualanModel penjualan)
{
// validasi
var result = penjualan;
result = TryValidate(penjualan);
var trsID = "";
// save
using (var trans = TransHelper.NewScope())
{
// edit: delete data lama
if (penjualan.PenjualanID.Trim() != "")
{
_penjualan2Dal.Delete(penjualan.PenjualanID);
_penjualanBayarDal.Delete(penjualan.PenjualanID);
_penjualanDal.Delete(penjualan.PenjualanID);
trsID = penjualan.PenjualanID;
}
// baru: generate no.transaksi
else
{
var prefix = "JL" + DateTime.Now.ToString("yyMM");
trsID = _paramNoBL.GenNewID(prefix, 10);
}
// save header
penjualan.PenjualanID = trsID;
_penjualanDal.Insert(penjualan);
// save detil barang
foreach (var item in penjualan.ListBrg)
{
item.PenjualanID = trsID;
item.PenjualanID2 = string.Format("{0}-{1}", trsID, item.NoUrut.ToString().PadLeft(3, '0'));
_penjualan2Dal.Insert(item);
}
// save detil bayar
if (penjualan.ListBayar != null)
{
foreach (var item in penjualan.ListBayar)
{
item.PenjualanID = trsID;
item.PenjualanID2 = string.Format("{0}-{1}", trsID, item.NoUrut.ToString().PadLeft(2, '0'));
_penjualanBayarDal.Insert(item);
}
}
trans.Complete();
}
return(result);
}
public StokAdjustmentModel Save(StokAdjustmentModel stokAdjustment)
{
// validasi
var result = stokAdjustment;
result = TryValidate(stokAdjustment);
var trsID = "";
// save
using (var trans = TransHelper.NewScope())
{
// edit: delete data lama
if (stokAdjustment.StokAdjustmentID.Trim() != "")
{
// kembalikan stok lama
_stokAdjustment2Dal.Delete(stokAdjustment.StokAdjustmentID);
_stokAdjustmentDal.Delete(stokAdjustment.StokAdjustmentID);
trsID = stokAdjustment.StokAdjustmentID;
}
// baru: generate no.transaksi
else
{
var prefix = "AJ" + DateTime.Now.ToString("yyMM");
trsID = _paramNoBL.GenNewID(prefix, 10);
}
// save header
stokAdjustment.StokAdjustmentID = trsID;
// delete data lama
_stokAdjustment2Dal.Delete(trsID);
_stokAdjustmentDal.Delete(trsID);
// insert data baru
_stokAdjustmentDal.Insert(stokAdjustment);
foreach (var item in stokAdjustment.ListBrg)
{
item.StokAdjustmentID = trsID;
item.StokAdjustmentID2 = string.Format("{0}-{1}", trsID, item.NoUrut.ToString().PadLeft(3, '0'));
_stokAdjustment2Dal.Insert(item);
}
trans.Complete();
}
return(result);
}
private void BrgIDText_KeyDown(object sender, KeyEventArgs e)
{
switch (e.KeyCode)
{
case Keys.F1:
// jika sudah terisi, exit
if (BrgIDText.Text.Trim() != "")
{
return;
}
// generate nomor baru da tampilkan
var newID = _paramNoBL.GenNewID("B", 5);
BrgIDText.Text = newID;
break;
default:
break;
}
}
public OrderJualModel Save(OrderJualModel orderJual)
{
// validasi
var result = orderJual;
result = TryValidate(orderJual);
var trsID = "";
// save
using (var trans = TransHelper.NewScope())
{
// edit: delete data lama
if (orderJual.OrderJualID.Trim() != "")
{
_orderJual2Dal.Delete(orderJual.OrderJualID);
_orderJualDal.Delete(orderJual.OrderJualID);
trsID = orderJual.OrderJualID;
}
// baru: generate no.transaksi
else
{
var prefix = "JL" + DateTime.Now.ToString("yyMM");
trsID = _paramNoBL.GenNewID(prefix, 10);
}
// save header
orderJual.OrderJualID = trsID;
_orderJualDal.Insert(orderJual);
// save detil barang
foreach (var item in orderJual.ListBrg)
{
item.OrderJualID = trsID;
item.OrderJualID2 = string.Format("{0}-{1}", trsID, item.NoUrut.ToString().PadLeft(3, '0'));
_orderJual2Dal.Insert(item);
}
trans.Complete();
}
return(result);
}
public BrgModel Save(BrgModel brg)
{
// validasi
var result = brg;
result = TryValidate(brg);
using (var trans = TransHelper.NewScope())
{
// save
if (brg.BrgID.Trim() == "")
{
brg.BrgID = _paramNoBL.GenNewID("B", 5);
_brgDal.Insert(result);
// insert ke barangStokHarga
_brgStokHargaBL.UpdateStok(brg.BrgID);
}
else
{
var dummyBrg = _brgDal.GetData(brg.BrgID);
if (dummyBrg == null)
{
_brgDal.Insert(result);
// insert ke barangStokHarga
_brgStokHargaBL.UpdateStok(brg.BrgID);
}
else
{
_brgDal.Update(result);
// insert ke barangStokHarga
_brgStokHargaBL.UpdateStok(brg.BrgID);
}
}
trans.Complete();
}
return(result);
}
public void AddStok(string brgID, decimal qty, double hpp,
string tgl, string jam, string trsMasukID,
string trsDOID, string jenisMutasiID)
{
#region VALIDASI-INPUT
// validasi brg
var brg = _brgBL.GetData(brgID);
if (brg == null)
{
var errMsg = string.Format("BrgID invalid: {0}", brgID);
throw new ArgumentException(errMsg);
}
// cek jenis mutasi
var jenisMutasi = _jenisMutasiBL.GetData(jenisMutasiID);
if (jenisMutasi == null)
{
var errMsg = string.Format("JenisMutasiID invalid : {0}", jenisMutasiID);
throw new ArgumentException(errMsg);
}
if (!jenisMutasi.IsBrgMasuk)
{
var errMsg = string.Format("JenisMutasiID invalid bukan BrgMasuk: {0}", jenisMutasiID);
throw new ArgumentException(errMsg);
}
// validasi tgl
if (!tgl.IsValidTgl("dd-MM-yyyy"))
{
var errMsg = string.Format("Tgl invalid: {0}", tgl);
throw new ArgumentException(errMsg);
}
// validasi jam
if (!tgl.IsValidJam("HH:mm:ss"))
{
var errMsg = string.Format("Jam invalid: {0}", jam);
throw new ArgumentException(errMsg);
}
#endregion
#region PERSIAPAN-ID-TABLE
// contoh StokInID = SI.1901.00031
var prefixStokIn = PREFIX_STOK_IN + DateTime.Now.ToString(".yyMM.");
var stokInID = _paramNoBL.GenNewID(prefixStokIn, 12);
// contoh StokInOutID = SI.1901.00031.001
var prefixStokInOut = stokInID + ".";
var stokInOutID = _paramNoBL.GenNewID(prefixStokInOut, 16);
// contoh StokControlID = DO.1901.00021-B5431
var stokControlID = string.Format("{0}-{1}", trsDOID, brgID);
#endregion
#region PROSES-INSERT-DATA
using (var trans = TransHelper.NewScope())
{
var stokIn = new StokInModel
{
StokInID = stokInID,
BrgID = brgID,
TglMasuk = tgl,
JamMasuk = jam,
TrsMasukID = trsMasukID,
QtyIn = qty,
QtySaldo = qty,
Hpp = hpp,
StokControlID = stokControlID,
TrsDOID = trsDOID,
};
_stokInDal.Insert(stokIn);
var stokInOut = new StokInOutModel
{
StokInID = stokInID,
StokInOutID = stokInOutID,
TglTrs = tgl,
JamTrs = jam,
ReffTrsID = trsMasukID,
JenisMutasiID = jenisMutasiID,
QtyIn = qty,
QtyOut = 0,
Hpp = hpp,
HargaJual = 0
};
_stokInOutDal.Insert(stokInOut);
trans.Complete();
}
#endregion
}
