private double GetTotalNota(ReturJualProduk obj)
{
var total = obj.item_retur.Where(f => f.Produk != null && f.entity_state != EntityState.Deleted)
.Sum(f => f.jumlah_retur * f.harga_jual);
return(total);
}
private double GetTotalNota(ReturJualProduk obj)
{
var total = obj.item_retur.Where(f => f.Produk != null && f.entity_state != EntityState.Deleted)
.Sum(f => f.jumlah_retur * f.harga_jual);
return(Math.Round(total, MidpointRounding.AwayFromZero));
}
public int Update(ReturJualProduk obj)
{
var result = 0;
try
{
_context.BeginTransaction();
var transaction = _context.transaction;
obj.total_nota = GetTotalNota(obj);
// update header
result = _context.db.Update <ReturJualProduk>(obj, transaction) ? 1 : 0;
// delete detail
foreach (var item in obj.item_retur_deleted)
{
result = _context.db.Delete <ItemReturJualProduk>(item, transaction) ? 1 : 0;
}
// insert/update detail
foreach (var item in obj.item_retur.Where(f => f.Produk != null))
{
item.retur_jual_id = obj.retur_jual_id;
item.pengguna_id = obj.pengguna_id;
if (item.entity_state == EntityState.Added)
{
item.item_retur_jual_id = _context.GetGUID();
_context.db.Insert <ItemReturJualProduk>(item, transaction);
result = 1;
}
else if (item.entity_state == EntityState.Modified)
{
result = _context.db.Update <ItemReturJualProduk>(item, transaction) ? 1 : 0;
}
// update entity state
item.entity_state = EntityState.Unchanged;
}
_context.Commit();
LogicalThreadContext.Properties["NewValue"] = obj.ToJson();
_log.Info("Update data");
result = 1;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public ReturJualProduk GetByID(string id)
{
ReturJualProduk obj = null;
using (IDapperContext context = new DapperContext())
{
_unitOfWork = new UnitOfWork(context, _log);
obj = _unitOfWork.ReturJualProdukRepository.GetByID(id);
}
return(obj);
}
public int Delete(ReturJualProduk obj)
{
var result = 0;
using (IDapperContext context = new DapperContext())
{
_unitOfWork = new UnitOfWork(context, _log);
result = _unitOfWork.ReturJualProdukRepository.Delete(obj);
}
return(result);
}
public int Update(ReturJualProduk obj)
{
var result = 0;
using (IDapperContext context = new DapperContext())
{
IUnitOfWork uow = new UnitOfWork(context, _log);
result = uow.ReturJualProdukRepository.Update(obj);
}
return(result);
}
public FrmEntryReturPenjualanProduk(string header, ReturJualProduk retur, IReturJualProdukBll bll)
: base()
{
InitializeComponent();
ColorManagerHelper.SetTheme(this, this);
base.SetHeader(header);
base.SetButtonSelesaiToBatal();
this._bll = bll;
this._retur = retur;
this._customer = retur.Customer;
this._jual = retur.JualProduk;
this._log = MainProgram.log;
this._pengguna = MainProgram.pengguna;
txtNota.Text = this._retur.nota;
txtNota.Enabled = false;
dtpTanggal.Value = (DateTime)this._retur.tanggal;
txtCustomer.Text = this._customer.nama_customer;
txtKeterangan.Text = this._retur.keterangan;
if (this._jual != null)
{
txtNotaJual.Text = this._jual.nota;
txtNotaJual.Enabled = false;
LoadItemJual(this._jual);
}
// simpan data lama
_listOfItemReturOld.Clear();
foreach (var item in this._retur.item_retur)
{
_listOfItemReturOld.Add(new ItemReturJualProduk
{
item_retur_jual_id = item.item_retur_jual_id,
jumlah_retur = item.jumlah_retur,
harga_jual = item.harga_jual
});
}
_listOfItemRetur = this._retur.item_retur;
_listOfItemRetur.Add(new ItemReturJualProduk()); // add dummy objek
InitGridControl(gridControl);
RefreshTotal();
}
public void DeleteTest()
{
var obj = new ReturJualProduk
{
retur_jual_id = "a1597295-c11d-4ea2-b074-e8c6369bf028"
};
var result = _bll.Delete(obj);
Assert.IsTrue(result != 0);
var deletedObj = _bll.GetByID(obj.retur_jual_id);
Assert.IsNull(deletedObj);
}
public int Delete(ReturJualProduk obj)
{
var result = 0;
try
{
result = _context.db.Delete <ReturJualProduk>(obj) ? 1 : 0;
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public int Update(ReturJualProduk obj, ref ValidationError validationError)
{
var validatorResults = _validator.Validate(obj);
if (!validatorResults.IsValid)
{
foreach (var failure in validatorResults.Errors)
{
validationError.Message = failure.ErrorMessage;
validationError.PropertyName = failure.PropertyName;
return(0);
}
}
return(Update(obj));
}
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 SaveTest()
{
var obj = new ReturJualProduk
{
jual_id = "376625eb-13ba-4620-bc12-e8260501b689",
customer_id = "c7b1ac7f-d201-474f-b018-1dc363d5d7f3",
nota = _bll.GetLastNota(),
tanggal = DateTime.Today,
keterangan = "keterangan header"
};
var listOfItemRetur = new List <ItemReturJualProduk>();
listOfItemRetur.Add(new ItemReturJualProduk {
item_jual_id = "3db2b20c-2e31-4934-b04a-a77f7ff85419", Produk = new Produk {
produk_id = "eafc755f-cab6-4066-a793-660fcfab20d0"
}, produk_id = "eafc755f-cab6-4066-a793-660fcfab20d0", harga_jual = 53000, jumlah = 5, jumlah_retur = 2
});
listOfItemRetur.Add(new ItemReturJualProduk {
item_jual_id = "7ea1f32f-b47f-4945-a7ed-3e6da34f5108", Produk = new Produk {
produk_id = "6e587b32-9d87-4ec3-8e7c-ce15c7b0aecd"
}, produk_id = "6e587b32-9d87-4ec3-8e7c-ce15c7b0aecd", harga_jual = 50000, jumlah = 10, jumlah_retur = 5
});
obj.item_retur = listOfItemRetur; // menghubungkan retur dan item retur
var validationError = new ValidationError();
var result = _bll.Save(obj, ref validationError);
Console.WriteLine("Error : " + validationError.Message);
Assert.IsTrue(result != 0);
var newObj = _bll.GetByID(obj.retur_jual_id);
Assert.IsNotNull(newObj);
Assert.AreEqual(obj.retur_jual_id, newObj.retur_jual_id);
Assert.AreEqual(obj.jual_id, newObj.jual_id);
Assert.AreEqual(obj.pengguna_id, newObj.pengguna_id);
Assert.AreEqual(obj.customer_id, newObj.customer_id);
Assert.AreEqual(obj.nota, newObj.nota);
Assert.AreEqual(obj.tanggal, newObj.tanggal);
Assert.AreEqual(obj.keterangan, newObj.keterangan);
Assert.AreEqual(obj.total_nota, newObj.total_nota);
}
public int Delete(ReturJualProduk obj)
{
var result = 0;
try
{
result = _context.db.Delete <ReturJualProduk>(obj) ? 1 : 0;
if (result > 0)
{
LogicalThreadContext.Properties["OldValue"] = obj.ToJson();
_log.Info("Hapus data");
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(result);
}
public ReturJualProduk GetByID(string id)
{
ReturJualProduk obj = null;
try
{
_sql = SQL_TEMPLATE.Replace("{WHERE}", "WHERE t_retur_jual_produk.retur_jual_id = @id");
_sql = _sql.Replace("{ORDER BY}", "");
obj = MappingRecordToObject(_sql, new { id }).SingleOrDefault();
if (obj != null)
{
// load item retur
obj.item_retur = GetItemRetur(obj.retur_jual_id);
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(obj);
}
protected override void Simpan()
{
if (this._customer == null || txtCustomer.Text.Length == 0)
{
MsgHelper.MsgWarning("'Customer' tidak boleh kosong !");
txtCustomer.Focus();
return;
}
var total = SumGrid(this._listOfItemRetur);
if (!(total > 0))
{
MsgHelper.MsgWarning("Anda belum melengkapi inputan data produk !");
return;
}
if (!MsgHelper.MsgKonfirmasi("Apakah proses ingin dilanjutkan ?"))
{
return;
}
if (_isNewData)
{
_retur = new ReturJualProduk();
}
_retur.jual_id = this._jual.jual_id;
_retur.JualProduk = this._jual;
_retur.pengguna_id = this._pengguna.pengguna_id;
_retur.Pengguna = this._pengguna;
_retur.customer_id = this._customer.customer_id;
_retur.Customer = this._customer;
_retur.nota = txtNota.Text;
_retur.tanggal = dtpTanggal.Value;
_retur.keterangan = txtKeterangan.Text;
_retur.item_retur = this._listOfItemRetur.Where(f => f.Produk != null).ToList();
if (!_isNewData) // update
{
_retur.item_retur_deleted = _listOfItemReturDeleted;
}
var result = 0;
var validationError = new ValidationError();
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
if (_isNewData)
{
result = _bll.Save(_retur, ref validationError);
}
else
{
result = _bll.Update(_retur, ref validationError);
}
if (result > 0)
{
Listener.Ok(this, _isNewData, _retur);
_customer = null;
_listOfItemRetur.Clear();
_listOfItemReturDeleted.Clear();
this.Close();
}
else
{
if (validationError.Message.NullToString().Length > 0)
{
MsgHelper.MsgWarning(validationError.Message);
base.SetFocusObject(validationError.PropertyName, this);
}
else
{
MsgHelper.MsgUpdateError();
}
}
}
}
