public void DeleteSalesReturn(int salesReturnID, int userID)
{
using (var trans = _unitOfWork.BeginTransaction())
{
try
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_SALESRETURN).FirstOrDefault();
SalesReturn salesReturn = _salesReturnRepository.GetById(salesReturnID);
salesReturn.Status = (int)DbConstant.DefaultDataStatus.Deleted;
salesReturn.ModifyDate = serverTime;
salesReturn.ModifyUserId = userID;
_salesReturnRepository.AttachNavigation(salesReturn.CreateUser);
_salesReturnRepository.AttachNavigation(salesReturn.ModifyUser);
_salesReturnRepository.AttachNavigation(salesReturn.Invoice);
_salesReturnRepository.Update(salesReturn);
_unitOfWork.SaveChanges();
List <SalesReturnDetail> listDetail = _salesReturnDetailRepository.GetMany(x => x.SalesReturnId == salesReturnID).ToList();
List <ReturnViewModel> listReturn = listDetail
.GroupBy(l => l.InvoiceDetail.SPKDetailSparepartDetail.SPKDetailSparepart.SparepartId)
.Select(cl => new ReturnViewModel
{
SparepartId = cl.First().InvoiceDetail.SPKDetailSparepartDetail.SPKDetailSparepart.SparepartId,
ReturQty = cl.Count(),
}).ToList();
List <PurchasingDetail> listPurchasingDetail = new List <PurchasingDetail>();
List <SparepartManualTransaction> listSparepartManualTrans = new List <SparepartManualTransaction>();
foreach (var itemDetail in listDetail)
{
itemDetail.Status = (int)DbConstant.DefaultDataStatus.Deleted;
itemDetail.ModifyDate = serverTime;
itemDetail.ModifyUserId = userID;
_salesReturnDetailRepository.AttachNavigation(itemDetail.CreateUser);
_salesReturnDetailRepository.AttachNavigation(itemDetail.ModifyUser);
_salesReturnDetailRepository.AttachNavigation(itemDetail.SalesReturn);
_salesReturnDetailRepository.AttachNavigation(itemDetail.InvoiceDetail);
_salesReturnDetailRepository.Update(itemDetail);
if (itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail != null)
{
listPurchasingDetail.Add(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail);
}
if (itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction != null)
{
listSparepartManualTrans.Add(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction);
}
}
foreach (var itemReturn in listReturn)
{
Sparepart sparepart = _sparepartRepository.GetById(itemReturn.SparepartId);
sparepart.StockQty -= itemReturn.ReturQty;
_sparepartRepository.AttachNavigation(sparepart.CreateUser);
_sparepartRepository.AttachNavigation(sparepart.ModifyUser);
_sparepartRepository.AttachNavigation(sparepart.CategoryReference);
_sparepartRepository.AttachNavigation(sparepart.UnitReference);
_sparepartRepository.Update(sparepart);
SparepartStockCard stockCard = new SparepartStockCard();
stockCard.CreateUserId = userID;
stockCard.PurchaseDate = serverTime;
stockCard.PrimaryKeyValue = salesReturn.Id;
stockCard.ReferenceTableId = transactionReferenceTable.Id;
stockCard.SparepartId = sparepart.Id;
stockCard.Description = "Pembatalan Retur Penjualan";
stockCard.QtyOut = itemReturn.ReturQty;
stockCard.QtyOutPrice = Convert.ToDouble(listPurchasingDetail.Sum(x => x.Price) + listSparepartManualTrans.Sum(x => x.Price));
SparepartStockCard lastStockCard = _sparepartStokCardRepository.RetrieveLastCard(sparepart.Id);
double lastStock = 0;
double lastStockPrice = 0;
if (lastStockCard != null)
{
lastStock = lastStockCard.QtyLast;
lastStockPrice = lastStockCard.QtyLastPrice;
}
stockCard.QtyFirst = lastStock;
stockCard.QtyFirstPrice = lastStockPrice;
stockCard.QtyLast = lastStock - stockCard.QtyOut;
stockCard.QtyLastPrice = lastStockPrice - stockCard.QtyOutPrice;
_sparepartStokCardRepository.AttachNavigation(stockCard.CreateUser);
_sparepartStokCardRepository.AttachNavigation(stockCard.Sparepart);
_sparepartStokCardRepository.AttachNavigation(stockCard.ReferenceTable);
stockCard = _sparepartStokCardRepository.Add(stockCard);
_unitOfWork.SaveChanges();
if (listPurchasingDetail.Count > 0)
{
List <PurchasingDetailViewModel> listPurchasing = listPurchasingDetail
.GroupBy(l => l.PurchasingId)
.Select(cl => new PurchasingDetailViewModel
{
PurchasingId = cl.Key,
Qty = cl.Count(),
Price = cl.First().Price
}).ToList();
foreach (var itemPurchasing in listPurchasing)
{
SparepartStockCardDetail stockCardDtail = new SparepartStockCardDetail();
stockCardDtail.ParentStockCard = stockCard;
stockCardDtail.PricePerItem = Convert.ToDouble(itemPurchasing.Price);
stockCardDtail.QtyOut = itemPurchasing.Qty;
stockCardDtail.QtyOutPrice = Convert.ToDouble(itemPurchasing.Qty * itemPurchasing.Price);
SparepartStockCardDetail lastStockCardDetail = _sparepartStokCardDetailRepository.RetrieveLastCardDetailByPurchasingId(sparepart.Id, itemPurchasing.PurchasingId);
double lastStockDetail = 0;
double lastStockDetailPrice = 0;
if (lastStockCardDetail != null)
{
lastStockDetail = lastStockCardDetail.QtyLast;
lastStockDetailPrice = lastStockCardDetail.QtyLastPrice;
}
stockCardDtail.QtyFirst = lastStockDetail;
stockCardDtail.QtyFirstPrice = lastStockDetailPrice;
stockCardDtail.QtyLast = lastStockDetail - stockCardDtail.QtyOut;
stockCardDtail.QtyLastPrice = lastStockDetailPrice - stockCardDtail.QtyOutPrice;
stockCardDtail.PurchasingId = itemPurchasing.PurchasingId;
_sparepartStokCardDetailRepository.AttachNavigation(stockCardDtail.ParentStockCard);
_sparepartStokCardDetailRepository.Add(stockCardDtail);
_unitOfWork.SaveChanges();
PurchasingDetail pDetail = _purchasingDetailRepository.GetById(itemPurchasing.Id);
pDetail.ModifyDate = serverTime;
pDetail.ModifyUserId = userID;
pDetail.QtyRemaining = pDetail.QtyRemaining - itemPurchasing.Qty;
_purchasingDetailRepository.AttachNavigation(pDetail.Purchasing);
_purchasingDetailRepository.AttachNavigation(pDetail.Sparepart);
_purchasingDetailRepository.AttachNavigation(pDetail.CreateUser);
_purchasingDetailRepository.AttachNavigation(pDetail.ModifyUser);
_purchasingDetailRepository.Update(pDetail);
_unitOfWork.SaveChanges();
}
}
if (listSparepartManualTrans.Count > 0)
{
List <SparepartManualTransactionViewModel> listSpManual = listSparepartManualTrans
.GroupBy(l => l.Id)
.Select(cl => new SparepartManualTransactionViewModel
{
Id = cl.Key,
Qty = cl.Count(),
Price = cl.First().Price
}).ToList();
foreach (var itemSpTrans in listSpManual)
{
SparepartStockCardDetail stockCardDtail = new SparepartStockCardDetail();
stockCardDtail.ParentStockCard = stockCard;
stockCardDtail.PricePerItem = Convert.ToDouble(itemSpTrans.Price);
stockCardDtail.QtyOut = 1;
stockCardDtail.QtyOutPrice = Convert.ToDouble(1 * itemSpTrans.Price);
SparepartStockCardDetail lastStockCardDetail = _sparepartStokCardDetailRepository.RetrieveLastCardDetailByTransactionManualId(sparepart.Id, itemSpTrans.Id);
double lastStockDetail = 0;
double lastStockDetailPrice = 0;
if (lastStockCardDetail != null)
{
lastStockDetail = lastStockCardDetail.QtyLast;
lastStockDetailPrice = lastStockCardDetail.QtyLastPrice;
}
stockCardDtail.QtyFirst = lastStockDetail;
stockCardDtail.QtyFirstPrice = lastStockDetailPrice;
stockCardDtail.QtyLast = lastStockDetail - stockCardDtail.QtyOut;
stockCardDtail.QtyLastPrice = lastStockDetailPrice - stockCardDtail.QtyOutPrice;
stockCardDtail.SparepartManualTransactionId = itemSpTrans.Id;
_sparepartStokCardDetailRepository.AttachNavigation(stockCardDtail.ParentStockCard);
_sparepartStokCardDetailRepository.Add(stockCardDtail);
_unitOfWork.SaveChanges();
SparepartManualTransaction spManual = _sparepartManualTransactionRepository.GetById(itemSpTrans.Id);
spManual.ModifyDate = serverTime;
spManual.ModifyUserId = userID;
spManual.QtyRemaining = spManual.QtyRemaining - 1;
_sparepartManualTransactionRepository.AttachNavigation(spManual.UpdateType);
_sparepartManualTransactionRepository.AttachNavigation(spManual.Sparepart);
_sparepartManualTransactionRepository.AttachNavigation(spManual.CreateUser);
_sparepartManualTransactionRepository.AttachNavigation(spManual.ModifyUser);
_sparepartManualTransactionRepository.Update(spManual);
_unitOfWork.SaveChanges();
}
}
}
_unitOfWork.SaveChanges();
Transaction transaction = _transactionRepository.GetMany(x => x.PrimaryKeyValue == salesReturnID && x.ReferenceTableId == transactionReferenceTable.Id).FirstOrDefault();
transaction.Status = (int)DbConstant.DefaultDataStatus.Deleted;
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userID;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
_transactionRepository.Update(transaction);
Invoice invoice = _invoiceRepository.GetById(salesReturn.InvoiceId);
invoice.Status = (int)DbConstant.InvoiceStatus.Printed;
invoice.ModifyDate = serverTime;
invoice.ModifyUserId = userID;
if (invoice.TotalPrice != invoice.TotalHasPaid && (invoice.TotalPrice - invoice.TotalHasPaid) >= (decimal)transaction.TotalTransaction)
{
invoice.TotalHasPaid -= (decimal)transaction.TotalTransaction;
}
if (invoice.TotalPrice == invoice.TotalHasPaid)
{
invoice.PaymentStatus = (int)DbConstant.PaymentStatus.Settled;
}
else
{
invoice.PaymentStatus = (int)DbConstant.PaymentStatus.NotSettled;
}
_invoiceRepository.AttachNavigation(invoice.CreateUser);
_invoiceRepository.AttachNavigation(invoice.ModifyUser);
_invoiceRepository.AttachNavigation(invoice.PaymentMethod);
_invoiceRepository.AttachNavigation(invoice.SPK);
_unitOfWork.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}
public void DeleteSalesReturn(int salesReturnID, int userID)
{
using (var trans = _unitOfWork.BeginTransaction())
{
try
{
DateTime serverTime = DateTime.Now;
Reference transactionReferenceTable = _referenceRepository.GetMany(c => c.Code == DbConstant.REF_TRANSTBL_SALESRETURN).FirstOrDefault();
SalesReturn salesReturn = _salesReturnRepository.GetById(salesReturnID);
salesReturn.Status = (int)DbConstant.DefaultDataStatus.Deleted;
salesReturn.ModifyDate = serverTime;
salesReturn.ModifyUserId = userID;
_salesReturnRepository.AttachNavigation(salesReturn.CreateUser);
_salesReturnRepository.AttachNavigation(salesReturn.ModifyUser);
_salesReturnRepository.AttachNavigation(salesReturn.Invoice);
_salesReturnRepository.Update(salesReturn);
_unitOfWork.SaveChanges();
List <SalesReturnDetail> listDetail = _salesReturnDetailRepository.GetMany(x => x.SalesReturnId == salesReturnID).ToList();
foreach (var itemDetail in listDetail)
{
itemDetail.Status = (int)DbConstant.DefaultDataStatus.Deleted;
itemDetail.ModifyDate = serverTime;
itemDetail.ModifyUserId = userID;
_salesReturnDetailRepository.AttachNavigation(itemDetail.CreateUser);
_salesReturnDetailRepository.AttachNavigation(itemDetail.ModifyUser);
_salesReturnDetailRepository.AttachNavigation(itemDetail.SalesReturn);
_salesReturnDetailRepository.AttachNavigation(itemDetail.InvoiceDetail);
_salesReturnDetailRepository.Update(itemDetail);
Sparepart sparepart = _sparepartRepository.GetById(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SPKDetailSparepart.SparepartId);
sparepart.StockQty -= 1;
_sparepartRepository.AttachNavigation(sparepart.CreateUser);
_sparepartRepository.AttachNavigation(sparepart.ModifyUser);
_sparepartRepository.AttachNavigation(sparepart.CategoryReference);
_sparepartRepository.AttachNavigation(sparepart.UnitReference);
_sparepartRepository.Update(sparepart);
SparepartStockCard stockCard = new SparepartStockCard();
stockCard.CreateUserId = userID;
stockCard.PurchaseDate = serverTime;
stockCard.PrimaryKeyValue = salesReturn.Id;
stockCard.ReferenceTableId = transactionReferenceTable.Id;
stockCard.SparepartId = sparepart.Id;
stockCard.Description = "Pembatalan Retur Penjualan";
stockCard.QtyOut = 1;
stockCard.QtyOutPrice = Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail != null ? itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price : itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction != null ? itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction.Price : 0);
SparepartStockCard lastStockCard = _sparepartStokCardRepository.RetrieveLastCard(sparepart.Id);
double lastStock = 0;
double lastStockPrice = 0;
if (lastStockCard != null)
{
lastStock = lastStockCard.QtyLast;
lastStockPrice = lastStockCard.QtyLastPrice;
}
stockCard.QtyFirst = lastStock;
stockCard.QtyFirstPrice = lastStockPrice;
stockCard.QtyLast = lastStock - 1;
stockCard.QtyLastPrice = lastStockPrice - Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail != null ? itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price : itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction != null ? itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction.Price : 0);
_sparepartStokCardRepository.AttachNavigation(stockCard.CreateUser);
_sparepartStokCardRepository.AttachNavigation(stockCard.Sparepart);
_sparepartStokCardRepository.AttachNavigation(stockCard.ReferenceTable);
stockCard = _sparepartStokCardRepository.Add(stockCard);
_unitOfWork.SaveChanges();
if (itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail != null)
{
SparepartStockCardDetail stockCardDtail = new SparepartStockCardDetail();
stockCardDtail.ParentStockCard = stockCard;
stockCardDtail.PricePerItem = Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price);
stockCardDtail.QtyOut = 1;
stockCardDtail.QtyOutPrice = Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price);
SparepartStockCardDetail lastStockCardDetail = _sparepartStokCardDetailRepository.RetrieveLastCardDetailByPurchasingId(sparepart.Id, itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.PurchasingId);
double lastStockDetail = 0;
double lastStockDetailPrice = 0;
if (lastStockCardDetail != null)
{
lastStockDetail = lastStockCardDetail.QtyLast;
lastStockDetailPrice = lastStockCardDetail.QtyLastPrice;
}
stockCardDtail.QtyFirst = lastStockDetail;
stockCardDtail.QtyFirstPrice = lastStockDetailPrice;
stockCardDtail.QtyLast = lastStockDetail - stockCardDtail.QtyOut;
stockCardDtail.QtyLastPrice = lastStockDetailPrice - stockCardDtail.QtyOutPrice;
stockCardDtail.PurchasingId = itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.PurchasingId;
_sparepartStokCardDetailRepository.AttachNavigation(stockCardDtail.ParentStockCard);
_sparepartStokCardDetailRepository.Add(stockCardDtail);
_unitOfWork.SaveChanges();
PurchasingDetail pDetail = _purchasingDetailRepository.GetById(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetailId);
pDetail.ModifyDate = serverTime;
pDetail.ModifyUserId = userID;
pDetail.QtyRemaining = pDetail.QtyRemaining - 1;
_purchasingDetailRepository.AttachNavigation(pDetail.Purchasing);
_purchasingDetailRepository.AttachNavigation(pDetail.Sparepart);
_purchasingDetailRepository.AttachNavigation(pDetail.CreateUser);
_purchasingDetailRepository.AttachNavigation(pDetail.ModifyUser);
_purchasingDetailRepository.Update(pDetail);
_unitOfWork.SaveChanges();
}
if (itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction != null)
{
SparepartStockCardDetail stockCardDtail = new SparepartStockCardDetail();
stockCardDtail.ParentStockCard = stockCard;
stockCardDtail.PricePerItem = Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price);
stockCardDtail.QtyOut = 1;
stockCardDtail.QtyOutPrice = Convert.ToDouble(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.PurchasingDetail.Price);
SparepartStockCardDetail lastStockCardDetail = _sparepartStokCardDetailRepository.RetrieveLastCardDetailByTransactionManualId(sparepart.Id, itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction.Id);
double lastStockDetail = 0;
double lastStockDetailPrice = 0;
if (lastStockCardDetail != null)
{
lastStockDetail = lastStockCardDetail.QtyLast;
lastStockDetailPrice = lastStockCardDetail.QtyLastPrice;
}
stockCardDtail.QtyFirst = lastStockDetail;
stockCardDtail.QtyFirstPrice = lastStockDetailPrice;
stockCardDtail.QtyLast = lastStockDetail - stockCardDtail.QtyOut;
stockCardDtail.QtyLastPrice = lastStockDetailPrice - stockCardDtail.QtyOutPrice;
stockCardDtail.SparepartManualTransactionId = itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransaction.Id;
_sparepartStokCardDetailRepository.AttachNavigation(stockCardDtail.ParentStockCard);
_sparepartStokCardDetailRepository.Add(stockCardDtail);
_unitOfWork.SaveChanges();
SparepartManualTransaction spManual = _sparepartManualTransactionRepository.GetById(itemDetail.InvoiceDetail.SPKDetailSparepartDetail.SparepartManualTransactionId);
spManual.ModifyDate = serverTime;
spManual.ModifyUserId = userID;
spManual.QtyRemaining = spManual.QtyRemaining - 1;
_sparepartManualTransactionRepository.AttachNavigation(spManual.UpdateType);
_sparepartManualTransactionRepository.AttachNavigation(spManual.Sparepart);
_sparepartManualTransactionRepository.AttachNavigation(spManual.CreateUser);
_sparepartManualTransactionRepository.AttachNavigation(spManual.ModifyUser);
_sparepartManualTransactionRepository.Update(spManual);
_unitOfWork.SaveChanges();
}
}
_unitOfWork.SaveChanges();
Transaction transaction = _transactionRepository.GetMany(x => x.PrimaryKeyValue == salesReturnID && x.ReferenceTableId == transactionReferenceTable.Id).FirstOrDefault();
transaction.Status = (int)DbConstant.DefaultDataStatus.Deleted;
transaction.ModifyDate = serverTime;
transaction.ModifyUserId = userID;
_transactionRepository.AttachNavigation(transaction.CreateUser);
_transactionRepository.AttachNavigation(transaction.ModifyUser);
_transactionRepository.AttachNavigation(transaction.PaymentMethod);
_transactionRepository.AttachNavigation(transaction.ReferenceTable);
_transactionRepository.Update(transaction);
_unitOfWork.SaveChanges();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}