private void UpdateStock(string pStrWarehouse, ItemBatchDTO pObjItemBatch)
{
Stock lObjCurrentStock = null;
Stock lObjNewStock = null;
try
{
lObjCurrentStock = LocalStockService.GetListByWhs().FirstOrDefault(x => x.Item.Code == pObjItemBatch.ItemCode
&& x.BatchNumber == pObjItemBatch.BatchNumber);
if (lObjCurrentStock != null)
{
lObjNewStock = GetStockByFilters(pStrWarehouse, pObjItemBatch.ItemCode, pObjItemBatch.BatchNumber);
lObjCurrentStock.Quantity = lObjNewStock.Quantity;
lObjCurrentStock.CreationDate = lObjNewStock.CreationDate;
lObjCurrentStock.ModificationDate = lObjNewStock.ModificationDate;
lObjCurrentStock.ExpirationDate = lObjNewStock.ExpirationDate;
lObjCurrentStock.CustomerId = lObjNewStock.CustomerId;
LocalStockService.SaveOrUpdate(lObjCurrentStock);
}
}
catch (Exception lObjException)
{
LogUtility.Write(string.Format("[ERROR] {0}", lObjException.ToString()));
}
}
private bool StockHasChanges(ItemBatchDTO pObjStock)
{
string lStrLocalStockDate = LocalStockService.GetListByWhs().Where(x => x.Item.Code == pObjStock.ItemCode && x.BatchNumber == pObjStock.BatchNumber).Select(x => x.ModificationDate).FirstOrDefault().ToString("yyyy-MM-dd HH:mm:ss");
string lStrSAPStockDate = pObjStock.UpdateDate.ToString("yyyy-MM-dd HH:mm:ss");
return lStrLocalStockDate != lStrSAPStockDate ? true : false;
}
private DateTime GetLastCreationDate()
{
#if DEBUG
var a = LocalStockService.GetList().Count() > 0;
#endif
return LocalStockService.GetListByWhs().Count() > 0 ?
LocalStockService.GetListByWhs().Max(x => x.CreationDate) : DateTime.Today.AddYears(-10);
}
private void ImportStock(string pStrWarehouse, string pStrItemCode, string pStrBatchNumber)
{
try
{
LocalStockService.SaveOrUpdate(GetStockByFilters(pStrWarehouse, pStrItemCode, pStrBatchNumber));
}
catch (Exception lObjException)
{
LogUtility.Write(string.Format("[ERROR] {0}", lObjException.ToString()));
}
}
private IList<ItemBatchDTO> GetStockToImport(string pStrWhsCode,DateTime pAuctionDate)
{
//Get Stock from SAP B1
IList<ItemBatchDTO> lLstObjSapStock = SapStockService.GetItemBatchesListByWarehouse(pStrWhsCode,pAuctionDate);
//Get Local Stock
IList<string> lLstStrLocalStock = LocalStockService.GetListByWhs()
.Select(x => x.BatchNumber)
.ToList();
//Get imported customers for valid that customer exists before then import his stock
IList<string> lLstStrImportedCustomer = LocalBusinessPartnerService
.GetList()
.Select(x => x.Code)
.ToList();
//Get imported items for valid that item exists before then import the customer's stock
IList<string> lLstStrImportedItems = LocalItemService
.GetList()
.Select(x => x.Code)
.ToList();
return lLstObjSapStock.Where(x => !lLstStrLocalStock.Contains(x.BatchNumber) && lLstStrImportedCustomer.Contains(x.CardCode) && lLstStrImportedItems.Contains(x.ItemCode)).ToList();
}
private bool StockHasBeenImported(ItemBatchDTO pObjStock)
{
return LocalStockService.GetListByWhs().Where(x => x.Item.Code == pObjStock.ItemCode && x.BatchNumber == pObjStock.BatchNumber).Count() > 0 ? true : false;
}
private DateTime GetLastModificationDate()
{
return LocalStockService.GetListByWhs().Count() > 0 ?
LocalStockService.GetListByWhs().Max(x => x.ModificationDate) : DateTime.Today.AddYears(-10);
}
