public List <PurchasingDetailViewModel> RetrievePurchasingDetail(int purchasingID)
{
List <PurchasingDetail> result = _purchasingDetailRepository.GetMany(c => c.PurchasingId == purchasingID).ToList();
List <PurchasingDetailViewModel> mappedResult = new List <PurchasingDetailViewModel>();
return(Map(result, mappedResult));
}
public List <ReturnViewModel> RetrieveReturnList(int purchaseReturnID, int purchasingID)
{
List <ReturnViewModel> result = new List <ReturnViewModel>();
List <PurchasingDetail> listPurchasingDetail = _purchasingDetailRepository.GetMany(x => x.PurchasingId == purchasingID).ToList();
if (purchaseReturnID > 0)
{
List <PurchaseReturnDetail> listDetail = this.RetrievePurchaseReturnDetail(purchaseReturnID);
if (listDetail != null && listDetail.Count > 0)
{
foreach (var itemDetail in listPurchasingDetail)
{
if (string.IsNullOrEmpty(itemDetail.SerialNumber))
{
result.Add(new ReturnViewModel
{
SparepartId = itemDetail.SparepartId,
SparepartName = itemDetail.Sparepart.Name,
ReturQty = listDetail.Where(x => x.PurchasingDetailId == itemDetail.Id).FirstOrDefault().Qty,
ReturQtyLimit = itemDetail.Qty,
SerialNumber = itemDetail.SerialNumber,
PurchasingDetailId = itemDetail.Id,
PricePerItem = itemDetail.Price
});
}
else
{
result.Add(new ReturnViewModel
{
SparepartId = itemDetail.SparepartId,
SparepartName = itemDetail.Sparepart.Name,
ReturQty = listDetail.Where(x => x.PurchasingDetailId == itemDetail.Id).FirstOrDefault().Qty,
ReturQtyLimit = itemDetail.Qty,
SerialNumber = itemDetail.SerialNumber,
PurchasingDetailId = itemDetail.Id,
PricePerItem = itemDetail.Price
});
}
}
}
}
else
{
foreach (var itemDetail in listPurchasingDetail)
{
result.Add(new ReturnViewModel
{
SparepartId = itemDetail.SparepartId,
SparepartName = itemDetail.Sparepart.Name,
ReturQty = 0,
ReturQtyLimit = itemDetail.Qty,
SerialNumber = itemDetail.SerialNumber,
PurchasingDetailId = itemDetail.Id,
PricePerItem = itemDetail.Price
});
}
}
return(result);
}
public List <PurchasingDetailViewModel> RetrievePurchasingDetail(int purchasingID)
{
List <PurchasingDetail> result = _purchasingDetailRepository.GetMany(c => c.PurchasingId == purchasingID).ToList();
List <PurchasingDetailViewModel> mappedResult = new List <PurchasingDetailViewModel>();
Map(result, mappedResult);
foreach (var itemMapped in mappedResult)
{
itemMapped.IsSpecialSparepart = IsSparepartWheel(itemMapped.SparepartId);
}
return(mappedResult);
}
public List <ReturnViewModel> GetReturnListDetail(int purchaseReturnID, int purchasingID)
{
List <ReturnViewModel> result = new List <ReturnViewModel>();
List <PurchasingDetail> listPurchasingDetail = _purchasingDetailRepository.GetMany(x => x.PurchasingId == purchasingID).ToList();
if (purchaseReturnID > 0)
{
List <PurchaseReturnDetail> listDetail = this.RetrievePurchaseReturnDetail(purchaseReturnID);
if (listDetail != null && listDetail.Count > 0)
{
foreach (var itemDetail in listPurchasingDetail)
{
result.Add(new ReturnViewModel
{
SparepartId = itemDetail.SparepartId,
SparepartName = itemDetail.Sparepart.Name,
//temp delete
//ReturQty = Convert.ToDecimal(listDetail.Where(x => x.Qty).Sum()),
ReturQtyLimit = itemDetail.Qty,
PricePerItem = itemDetail.Price,
SparepartCode = itemDetail.Sparepart.Code,
UnitName = itemDetail.Sparepart.UnitReference.Name
});
}
}
}
return(result);
}
public List <SPKDetailSparepartDetail> getRandomSPKDetails(int sparepartId, int qty, int ssDetailId)
{
List <SparepartManualTransaction> spManuals = new List <SparepartManualTransaction>();
List <PurchasingDetail> purchasingDetails = new List <PurchasingDetail>();
List <SPKDetailSparepartDetail> result = new List <SPKDetailSparepartDetail>();
if (qty > 0 && sparepartId > 0)
{
int qtyRemains = qty;
List <SparepartManualTransaction> spManual = _sparepartManualTransactionRepository
.GetMany(
spd => spd.SparepartId == sparepartId &&
spd.QtyRemaining > 0
)
.OrderBy(spd => spd.CreateDate).ToList();
foreach (var itemManual in spManual)
{
if (itemManual.QtyRemaining > qtyRemains)
{
itemManual.QtyRemaining = itemManual.QtyRemaining - qtyRemains;
SPKDetailSparepartDetail spkspd = new SPKDetailSparepartDetail
{
SparepartManualTransaction = itemManual,
SparepartManualTransactionId = itemManual.Id,
SPKDetailSparepartId = itemManual.SparepartId,
Qty = qtyRemains
};
if (ssDetailId > 0)
{
spkspd.SpecialSparepartDetailId = ssDetailId;
}
result.Add(spkspd);
qtyRemains = 0;
}
else
{
SPKDetailSparepartDetail spkspd = new SPKDetailSparepartDetail
{
SparepartManualTransaction = itemManual,
SparepartManualTransactionId = itemManual.Id,
SPKDetailSparepartId = itemManual.SparepartId,
Qty = itemManual.QtyRemaining
};
if (ssDetailId > 0)
{
spkspd.SpecialSparepartDetailId = ssDetailId;
}
result.Add(spkspd);
qtyRemains -= itemManual.QtyRemaining;
itemManual.QtyRemaining = 0;
}
if (qtyRemains == 0)
{
break;
}
}
if (qtyRemains > 0)
{
List <PurchasingDetail> purchasingDetail = _purchasingDetailRepository
.GetMany(
spd => spd.SparepartId == sparepartId &&
spd.QtyRemaining > 0
)
.OrderBy(spd => spd.CreateDate).ToList();
foreach (var itemPD in purchasingDetail)
{
if (itemPD.QtyRemaining > qtyRemains)
{
itemPD.QtyRemaining = itemPD.QtyRemaining - qtyRemains;
SPKDetailSparepartDetail spkspd = new SPKDetailSparepartDetail
{
PurchasingDetail = itemPD,
PurchasingDetailId = itemPD.Id,
SPKDetailSparepartId = itemPD.SparepartId,
Qty = qtyRemains
};
if (ssDetailId > 0)
{
spkspd.SpecialSparepartDetailId = ssDetailId;
}
result.Add(spkspd);
qtyRemains = 0;
}
else
{
SPKDetailSparepartDetail spkspd = new SPKDetailSparepartDetail
{
PurchasingDetail = itemPD,
PurchasingDetailId = itemPD.Id,
SPKDetailSparepartId = itemPD.SparepartId,
Qty = itemPD.QtyRemaining
};
if (ssDetailId > 0)
{
spkspd.SpecialSparepartDetailId = ssDetailId;
}
result.Add(spkspd);
qtyRemains -= itemPD.QtyRemaining;
itemPD.QtyRemaining = 0;
}
if (qtyRemains == 0)
{
break;
}
}
}
}
return(result);
}
public List <GroupSparepartStockCardViewModel> RetrieveStockCards(DateTime fromDate, DateTime toDate, int sparepartId)
{
List <GroupSparepartStockCard> result = new List <GroupSparepartStockCard>();
DateTime lastDay = toDate.AddDays(1).AddSeconds(-1);
//result = _sparepartStockCardDetailRepository.RetrieveFIFOCurrentSparepart(fromDate, toDate, sparepartId);
List <SparepartStockCardDetail> list = _sparepartStockCardDetailRepository.GetMany(sp => sp.ParentStockCard.PurchaseDate >= fromDate && sp.ParentStockCard.PurchaseDate <= lastDay &&
(sparepartId > 0 ? sp.ParentStockCard.SparepartId == sparepartId : true)).ToList();
if (list != null)
{
var spp = from sp in list
group sp by new
{
sp.ParentStockCard.Sparepart,
sp.ParentStockCard.SparepartId,
sp.Purchasing,
sp.PurchasingId,
sp.SparepartManualTransaction,
sp.SparepartManualTransactionId
} into gsp
select new GroupSparepartStockCard
{
LastPurchaseDate = gsp.FirstOrDefault().Purchasing != null?gsp.FirstOrDefault().Purchasing.Date : gsp.FirstOrDefault().SparepartManualTransaction.CreateDate,
Sparepart = gsp.Key.Sparepart,
SparepartId = gsp.Key.SparepartId,
Purchasing = gsp.Key.Purchasing,
PurchasingId = gsp.Key.PurchasingId,
SparepartManualTransaction = gsp.Key.SparepartManualTransaction,
SparepartManualTransactionId = gsp.Key.SparepartManualTransactionId,
PricePerItem = gsp.LastOrDefault().PricePerItem,
TotalQtyFirst = gsp.FirstOrDefault().QtyFirst,
TotalQtyFirstPrice = gsp.FirstOrDefault().QtyFirstPrice,
TotalQtyIn = gsp.Sum(g => g.QtyIn),
TotalQtyInPrice = gsp.Sum(g => g.QtyInPrice),
TotalQtyOut = gsp.Sum(g => g.QtyOut),
TotalQtyOutPrice = gsp.Sum(g => g.QtyOutPrice),
TotalQtyLast = gsp.LastOrDefault().QtyLast,
TotalQtyLastPrice = gsp.LastOrDefault().QtyLastPrice
};
result = spp.ToList();
}
List <GroupSparepartStockCard> reportResult = result;
//check if there are sparepartID not in range of filter, just fill with totalqtyfirst from the day close to start date filter
if (sparepartId != 0)
{
var itemSparepart = _sparepartRepository.GetById(sparepartId);
var listPurchasing = _purchasingDetailRepository.GetMany(x => x.SparepartId == sparepartId).Select(x => x.Purchasing);
var listSparepartManual = _sparepartManualTransactionRepository.GetMany(x => x.SparepartId == sparepartId);
if (reportResult == null || reportResult.Count() == 0)
{
reportResult = new List <GroupSparepartStockCard>();
}
foreach (var itemPurchasing in listPurchasing)
{
if (reportResult.Where(x => x.PurchasingId == itemPurchasing.Id).Count() == 0)
{
SparepartStockCardDetail firstInitData = _sparepartStockCardDetailRepository.GetMany(x => x.PurchasingId == itemPurchasing.Id && x.ParentStockCard.PurchaseDate < fromDate).LastOrDefault();
if (firstInitData != null)
{
GroupSparepartStockCard newItem = new GroupSparepartStockCard();
newItem.TotalQtyFirst = firstInitData.QtyLast;
newItem.TotalQtyFirstPrice = firstInitData.QtyLastPrice;
newItem.LastPurchaseDate = firstInitData.Purchasing.CreateDate;
newItem.Sparepart = firstInitData.ParentStockCard.Sparepart;
newItem.SparepartId = firstInitData.ParentStockCard.SparepartId;
newItem.Purchasing = firstInitData.Purchasing;
newItem.PurchasingId = firstInitData.PurchasingId;
newItem.PricePerItem = firstInitData.PricePerItem;
newItem.TotalQtyIn = 0;
newItem.TotalQtyInPrice = 0;
newItem.TotalQtyOut = 0;
newItem.TotalQtyOutPrice = 0;
newItem.TotalQtyLast = firstInitData.QtyLast;
newItem.TotalQtyLastPrice = firstInitData.QtyLastPrice;
reportResult.Add(newItem);
}
}
}
foreach (var itemSpManual in listSparepartManual)
{
if (reportResult.Where(x => x.SparepartManualTransactionId == itemSpManual.Id).Count() == 0)
{
SparepartStockCardDetail firstInitData = _sparepartStockCardDetailRepository.GetMany(x => x.SparepartManualTransactionId == itemSpManual.Id && x.ParentStockCard.PurchaseDate < fromDate).LastOrDefault();
if (firstInitData != null)
{
GroupSparepartStockCard newItem = new GroupSparepartStockCard();
newItem.TotalQtyFirst = firstInitData.QtyLast;
newItem.TotalQtyFirstPrice = firstInitData.QtyLastPrice;
newItem.LastPurchaseDate = firstInitData.SparepartManualTransaction.CreateDate;
newItem.Sparepart = firstInitData.ParentStockCard.Sparepart;
newItem.SparepartId = firstInitData.ParentStockCard.SparepartId;
newItem.SparepartManualTransaction = firstInitData.SparepartManualTransaction;
newItem.SparepartManualTransactionId = firstInitData.SparepartManualTransactionId;
newItem.PricePerItem = firstInitData.PricePerItem;
newItem.TotalQtyIn = 0;
newItem.TotalQtyInPrice = 0;
newItem.TotalQtyOut = 0;
newItem.TotalQtyOutPrice = 0;
newItem.TotalQtyLast = firstInitData.QtyLast;
newItem.TotalQtyLastPrice = firstInitData.QtyLastPrice;
reportResult.Add(newItem);
}
}
}
}
List <GroupSparepartStockCardViewModel> mappedResult = new List <GroupSparepartStockCardViewModel>();
mappedResult = Map(reportResult, mappedResult);
return(mappedResult.OrderBy(x => x.Sparepart.Code).ToList());
}
