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); }