private void ParseLotNumber()
{
int lotNum;
if (int.TryParse(lotNumber.Text, out lotNum))
{
LotKey lotKey;
if (LotNumberParser.ParseLotNumber(lotNum, out lotKey))
{
lotDatePicker.Value = lotKey.LotKey_DateCreated;
lotDateSequence.Value = lotKey.LotKey_DateSequence;
lotTypeId.Value = lotKey.LotKey_LotTypeId;
}
SetQuery();
}
}
public void Resolved_defect_will_not_be_taken_into_account_for_LotStat_evaluation()
{
//Arrange
tblLot oldLot;
using (var oldContext = new RioAccessSQLEntities())
{
oldLot = oldContext.tblLots.OrderByDescending(l => l.EntryDate).FirstOrDefault(l => l.LotStat == (int)LotStat.Asta);
}
if (oldLot == null)
{
Assert.Inconclusive("Could not find valid tblLot record for testing.");
}
var lotKey = LotNumberParser.ParseLotNumber(oldLot.Lot);
var newLot = RVCUnitOfWork.LotRepository.FindByKey(lotKey, l => l.Attributes);
//Act
var result = Service.SetLotAttributes(new SetLotAttributeParameters
{
UserToken = TestUser.UserName,
LotKey = lotKey,
Attributes = newLot.Attributes.ToDictionary(a => a.ToAttributeNameKey().KeyValue, a => new AttributeValueParameters
{
AttributeInfo = new AttributeInfoParameters
{
Value = a.AttributeValue,
Date = a.AttributeDate
},
Resolution = new DefectResolutionParameters
{
Description = "Test!",
ResolutionType = ResolutionTypeEnum.AcceptedByUser
}
} as IAttributeValueParameters)
});
//Assert
result.AssertSuccess();
using (var oldContext = new RioAccessSQLEntities())
{
var synchedLot = oldContext.tblLots.FirstOrDefault(l => l.Lot == oldLot.Lot);
Assert.AreNotEqual((int)LotStat.Asta, synchedLot.LotStat);
}
}
protected override IEnumerable <Inventory> BirthRecords()
{
LoadCount.Reset();
foreach (var inventoryByLot in SelectLotsToLoad())
{
var inventory = inventoryByLot.ToList();
LoadCount.AddRead(EntityTypes.Inventory, (uint)inventory.Count);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(inventoryByLot.Key, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
InventoryByLot = inventoryByLot
});
continue;
}
var lot = GetLot(lotKey);
if (lot == null)
{
Log(new CallbackParameters(CallbackReason.LotNotLoaded)
{
LotKey = lotKey,
InventoryByLot = inventoryByLot
});
continue;
}
foreach (var inventoryItem in inventory)
{
var newInventory = CreateInventory(inventoryItem, lot);
if (newInventory == null)
{
continue;
}
LoadCount.AddLoaded(EntityTypes.Inventory);
yield return(newInventory);
}
}
LoadCount.LogResults(l => Log(new CallbackParameters(l)));
}
public void Will_not_create_new_tblLotHistory_record_if_new_defect_does_not_result_in_a_LotStat_change()
{
//Arrange
ChileLot chileLot;
using (var oldContext = new RioAccessSQLEntities())
{
chileLot = oldContext.tblLots
.Where(l => l.LotStat == (int)LotStat.See_Desc)
.Select(l => l.Lot)
.ToList()
.Select(l =>
{
var lotKey = LotNumberParser.ParseLotNumber(l);
var lot = RVCUnitOfWork.ChileLotRepository.FindByKey(lotKey, c => c.Lot.LotDefects.Select(d => d.Resolution));
return(lot.Lot.QualityStatus == LotQualityStatus.Released ? lot : null);
})
.FirstOrDefault(c => c != null);
}
if (chileLot == null)
{
throw new Exception("Could not find test ChileLot.");
}
var lotNumber = LotNumberBuilder.BuildLotNumber(chileLot);
var expectedLotAttributeHistories = new RioAccessSQLEntities().tblLotAttributeHistories.Count(h => h.Lot == lotNumber);
//Act
var result = Service.CreateLotDefect(new CreateLotDefectParameters
{
UserToken = TestUser.UserName,
LotKey = chileLot.ToLotKey(),
DefectType = DefectTypeEnum.InHouseContamination,
Description = "unmapped defect"
});
var lotString = GetKeyFromConsoleString(ConsoleOutput.UpdatedLot);
//Assert
result.AssertSuccess();
MockKillSwitch.Verify(k => k.Engage(), Times.Never());
Assert.AreEqual(lotNumber, int.Parse(lotString));
Assert.AreEqual(expectedLotAttributeHistories, new RioAccessSQLEntities().tblLotAttributeHistories.Count(h => h.Lot == lotNumber));
}
protected override IEnumerable <ChileMaterialsReceived> BirthRecords()
{
_loadCount.Reset();
var dataSource = OldContext.CreateObjectSet <tblIncoming>()
.Include(i => i.tblLot, i => i.tblPackaging, i => i.tblVariety)
.Where(i => i.TTypeID == (int?)TransType.DeHy || i.TTypeID == (int?)TransType.Other)
.GroupBy(i => i.Lot).ToList();
foreach (var tblIncomings in dataSource)
{
_loadCount.AddRead(EntityTypes.ChileMaterialsReceived);
var oldLot = tblIncomings.First().tblLot;
var transType = tblIncomings.Select(i => i.TTypeID).Distinct().Single().ToTransType();
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(tblIncomings.Key, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
Lot = oldLot
});
continue;
}
var employeeId = oldLot.EmployeeID ?? _newContextHelper.DefaultEmployee.EmployeeId;
if (oldLot.EmployeeID == null)
{
Log(new CallbackParameters(CallbackReason.DefaultEmployee)
{
Lot = oldLot,
EmployeeId = employeeId
});
}
if (oldLot.EntryDate == null)
{
Log(new CallbackParameters(CallbackReason.NullEntryDate)
{
Lot = oldLot
});
continue;
}
var entryDate = oldLot.EntryDate.Value.ConvertLocalToUTC();
var supplierNames = tblIncomings.Select(i => i.Company_IA).Distinct().ToList();
if (supplierNames.Count != 1)
{
Log(new CallbackParameters(CallbackReason.NoSingleSupplierName)
{
Lot = oldLot
});
continue;
}
var supplierName = (supplierNames.Single() ?? "").Trim();
if (string.IsNullOrEmpty(supplierName))
{
var locales = tblIncomings.Select(l => l.DehyLocale).Where(l => !string.IsNullOrEmpty(l)).Distinct().ToList();
if (locales.Count == 1)
{
supplierName = locales.Single();
Log(new CallbackParameters(CallbackReason.UsedDehyLocaleAsDehydrator)
{
Lot = oldLot,
DehyLocale = supplierName
});
}
}
var supplier = _newContextHelper.GetCompany(supplierName, CompanyType.Dehydrator, CompanyType.Supplier);
if (supplier == null)
{
Log(new CallbackParameters(CallbackReason.SupplierNotLoaded)
{
Lot = oldLot,
DehydratorName = supplierName
});
continue;
}
var chileLot = _newContextHelper.GetChileLotWithProduct(lotKey);
if (chileLot == null)
{
Log(new CallbackParameters(CallbackReason.ChileLotNotLoaded)
{
Lot = oldLot
});
continue;
}
var treatmentIds = tblIncomings.Select(i => i.TrtmtID).Distinct().ToList();
if (treatmentIds.Count != 1)
{
Log(new CallbackParameters(CallbackReason.NoSingleTrmtID)
{
Lot = oldLot,
});
continue;
}
var treatmentId = treatmentIds.Single();
var treatment = _newContextHelper.GetInventoryTreatment(treatmentId);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.TreatmentNotLoaded)
{
Lot = oldLot,
TrmtID = treatmentId
});
}
var newItems = new List <ChileMaterialsReceivedItem>();
var itemSequence = 1;
var oldItemGroups = tblIncomings.GroupBy(i => new ChileMaterialsItemReceivedKeys(i), new ChileMaterialsItemReceivedKeysEqualityComparer());
foreach (var oldItems in oldItemGroups)
{
var newItem = CreateItemReceived(oldItems, lotKey, itemSequence);
if (newItem != null)
{
newItems.Add(newItem);
++itemSequence;
}
}
_loadCount.AddLoaded(EntityTypes.ChileMaterialsReceived);
_loadCount.AddLoaded(EntityTypes.ChileMaterialsReceivedItem, (uint)newItems.Count);
yield return(new ChileMaterialsReceived
{
ChileMaterialsReceivedType = transType == TransType.DeHy ? ChileMaterialsReceivedType.Dehydrated : ChileMaterialsReceivedType.Other,
EmployeeId = employeeId,
TimeStamp = entryDate,
LotDateCreated = chileLot.LotDateCreated,
LotDateSequence = chileLot.LotDateSequence,
LotTypeId = chileLot.LotTypeId,
LoadNumber = oldLot.LoadNum,
DateReceived = chileLot.LotDateCreated,
ChileProductId = chileLot.ChileProductId,
SupplierId = supplier.Id,
TreatmentId = treatment.Id,
Items = newItems
});
}
_loadCount.LogResults(l => Log(new CallbackParameters(l)));
}
protected override IEnumerable <InstructionResult> BirthRecords()
{
_loadCount.Reset();
var instructions = new HashSet <string>();
foreach (var oldInstructionsByLot in SelectBatchInstructionsToLoad(OldContext).GroupBy(i => i.Lot))
{
var lastSequence = 0;
foreach (var oldInstruction in oldInstructionsByLot.OrderBy(i => i.Step))
{
_loadCount.AddRead(EntityTypes.Note);
if (string.IsNullOrWhiteSpace(oldInstruction.Action))
{
Log(new CallbackParameters(CallbackReason.EmptyAction)
{
Instruction = oldInstruction
});
continue;
}
var lotKey = LotNumberParser.ParseLotNumber(oldInstruction.Lot);
if (lotKey == null)
{
Log(new CallbackParameters(CallbackReason.InvalidLotKey)
{
Instruction = oldInstruction
});
continue;
}
var notebookKey = _newContextHelper.GetBatchInstructionNotebookKeyByLotKey(lotKey);
if (notebookKey == null)
{
Log(new CallbackParameters(CallbackReason.NotebookNotLoaded)
{
Instruction = oldInstruction
});
continue;
}
var instruction = new string(oldInstruction.Action.Take(Constants.StringLengths.InstructionText).ToArray());
Instruction newInstruction = null;
if (!instructions.Contains(instruction))
{
_loadCount.AddRead(EntityTypes.Instruction);
newInstruction = new Instruction
{
InstructionText = instruction,
InstructionType = InstructionType.ProductionBatchInstruction
};
instructions.Add(instruction);
_loadCount.AddLoaded(EntityTypes.Instruction);
}
var sequence = oldInstruction.Step.Value;
if (sequence <= lastSequence)
{
sequence = lastSequence + 1;
}
lastSequence = sequence;
var newNote = new Note
{
EmployeeId = _newContextHelper.DefaultEmployee.EmployeeId,
TimeStamp = oldInstruction.EntryDate.ConvertLocalToUTC(),
NotebookDate = notebookKey.NotebookKey_Date,
NotebookSequence = notebookKey.NotebookKey_Sequence,
Sequence = sequence,
Text = oldInstruction.Action
};
SerializableBatchInstruction.DeserializeIntoNote(newNote, oldInstruction.Serialized);
_loadCount.AddLoaded(EntityTypes.Note);
yield return(new InstructionResult
{
Note = newNote,
Instruction = newInstruction
});
}
}
_loadCount.LogResults(s => Log(new CallbackParameters(s)));
}
protected override IEnumerable <ChileLotProduction> BirthRecords()
{
_loadCount.Reset();
foreach (var lot in SelectMillAndWetdownToLoad(OldContext))
{
_loadCount.AddRead(EntityTypes.ChileLotProduction);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(lot.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
Lot = lot
});
continue;
}
var chileLot = _newContextHelper.GetChileLotWithProduct(lotKey);
if (chileLot == null)
{
Log(new CallbackParameters(CallbackReason.ChileLotNotLoaded)
{
Lot = lot,
LotKey = lotKey
});
continue;
}
bool usedDefaultProductionLine;
DateTime entryDate;
var productionResults = CreateLotProductionResults(chileLot, lot, out usedDefaultProductionLine, out entryDate);
if (productionResults == null)
{
continue;
}
var pickedInventory = CreatePickedInventory(entryDate, lot);
if (pickedInventory == null)
{
continue;
}
var production = new ChileLotProduction
{
EmployeeId = productionResults.EmployeeId,
TimeStamp = entryDate,
LotDateCreated = chileLot.LotDateCreated,
LotDateSequence = chileLot.LotDateSequence,
LotTypeId = chileLot.LotTypeId,
ProductionType = ProductionType.MillAndWetdown,
PickedInventoryDateCreated = pickedInventory.DateCreated,
PickedInventorySequence = pickedInventory.Sequence,
Results = productionResults,
PickedInventory = pickedInventory,
};
if (usedDefaultProductionLine)
{
Log(new CallbackParameters(CallbackReason.DefaultProductionLine)
{
Lot = lot,
ProductionLine = production.Results.ProductionLineLocation
});
}
_loadCount.AddLoaded(EntityTypes.ChileLotProduction);
_loadCount.AddLoaded(EntityTypes.PickedInventory);
_loadCount.AddLoaded(EntityTypes.PickedInventoryItem, (uint)production.PickedInventory.Items.Count);
_loadCount.AddLoaded(EntityTypes.LotProductionResults);
_loadCount.AddLoaded(EntityTypes.LotProductionResultItem, (uint)production.Results.ResultItems.Count);
yield return(production);
}
_loadCount.LogResults(l => Log(new CallbackParameters(l)));
}
private IEnumerable <PickedInventoryItem> CreatePickedInventoryItems(IPickedInventoryKey pickedInventoryKey, IEnumerable <OutgoingDTO> outgoings)
{
var pickedItemSequence = 0;
foreach (var outgoing in outgoings)
{
_loadCount.AddRead(EntityTypes.PickedInventoryItem);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(outgoing.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.OutgoingInvalidLotNumber)
{
Outgoing = outgoing
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.OutgoingLotNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var packagingProduct = outgoing.PTypeID == (int?)LotTypeEnum.Packaging ? _newContextHelper.NoPackagingProduct : _newContextHelper.GetPackagingProduct(outgoing.PkgID);
if (packagingProduct == null)
{
Log(new CallbackParameters(CallbackReason.OutgoingPackagingNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var warehouseLocation = _newContextHelper.GetLocation(outgoing.LocID);
if (warehouseLocation == null)
{
Log(new CallbackParameters(CallbackReason.OutgoingWarehouseLocationNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var treatment = _newContextHelper.GetInventoryTreatment(outgoing.TrtmtID);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.OutgoingTreatmentNotLoaded)
{
Outgoing = outgoing
});
continue;
}
yield return(new PickedInventoryItem
{
DateCreated = pickedInventoryKey.PickedInventoryKey_DateCreated,
Sequence = pickedInventoryKey.PickedInventoryKey_Sequence,
ItemSequence = ++pickedItemSequence,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packagingProduct.Id,
FromLocationId = warehouseLocation.Id,
TreatmentId = treatment.Id,
CurrentLocationId = warehouseLocation.Id,
ToteKey = outgoing.Tote ?? "",
Quantity = (int)(outgoing.Quantity ?? 0),
CustomerProductCode = outgoing.CustProductCode
});
}
}
private IEnumerable <InventoryAdjustmentItem> GetAdjustmentItems(InventoryAdjustment newAdjustment, IEnumerable <OutgoingDTO> outgoings)
{
var adjustmentSequence = 1;
foreach (var outgoing in outgoings)
{
_loadCount.AddRead(EntityTypes.InventoryAdjustmentItem);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(outgoing.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
Outgoing = outgoing
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.LotNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var packagingProduct = _newContextHelper.GetPackagingProduct(outgoing.PkgID);
if (packagingProduct == null)
{
Log(new CallbackParameters(CallbackReason.PackagingNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var warehouseLocation = _newContextHelper.GetLocation(outgoing.LocID);
if (warehouseLocation == null)
{
Log(new CallbackParameters(CallbackReason.WarehouseLocationNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var inventoryTreatment = _newContextHelper.GetInventoryTreatment(outgoing.TrtmtID);
if (inventoryTreatment == null)
{
Log(new CallbackParameters(CallbackReason.TreatmentNotLoaded)
{
Outgoing = outgoing
});
continue;
}
var adjustmentItem = new InventoryAdjustmentItem
{
AdjustmentDate = newAdjustment.AdjustmentDate,
Sequence = newAdjustment.Sequence,
ItemSequence = adjustmentSequence++,
TimeStamp = newAdjustment.TimeStamp,
EmployeeId = newAdjustment.EmployeeId,
QuantityAdjustment = (int)-outgoing.Quantity,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packagingProduct.Id,
LocationId = warehouseLocation.Id,
TreatmentId = inventoryTreatment.Id,
ToteKey = outgoing.Tote ?? " "
};
yield return(adjustmentItem);
}
}
private IEnumerable<PickedInventoryItem> CreatePickedInventoryItemsFromMoveDetails(IPickedInventoryKey pickedInventoryKey, MovementOrderDTO order, ShipmentStatus shipmentStatus)
{
var sequence = 0;
var moveDetails = order.tblMoveDetails.ToList();
foreach(var moveDetail in moveDetails)
{
LoadCount.AddRead(EntityTypes.PickedInventoryItem);
var lotKey = LotNumberParser.ParseLotNumber(moveDetail.Lot);
if(lotKey == null)
{
Log(new CallbackParameters(CallbackReason.MoveDetailInvalidLotNumber)
{
MoveDetail = moveDetail
});
continue;
}
if(!NewContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.MoveDetailLotNotLoaded)
{
MoveDetail = moveDetail
});
continue;
}
var packaging = moveDetail.PType == (int?)LotTypeEnum.Packaging ? NewContextHelper.NoPackagingProduct : NewContextHelper.GetPackagingProduct(moveDetail.PkgID);
if(packaging == null)
{
Log(new CallbackParameters(CallbackReason.MoveDetailPackagingNotLoaded)
{
MoveDetail = moveDetail
});
continue;
}
var pickedLocation = NewContextHelper.GetLocation(moveDetail.LocID);
if(pickedLocation == null)
{
pickedLocation = NewContextHelper.UnknownFacilityLocation;
if(pickedLocation == null)
{
Log(new CallbackParameters(CallbackReason.MoveDetailUnknownWarehouseLocationNotLoaded)
{
MoveDetail = moveDetail
});
continue;
}
Log(new CallbackParameters(CallbackReason.MoveDetailDefaultUnknownWarehouseLocation)
{
MoveDetail = moveDetail,
Location = pickedLocation
});
}
var currentLocation = shipmentStatus == ShipmentStatus.Shipped ? NewContextHelper.GetLocation(moveDetail.Move2) ?? pickedLocation : pickedLocation;
var treatment = NewContextHelper.GetInventoryTreatment(moveDetail.TrtmtID);
if(treatment == null)
{
Log(new CallbackParameters(CallbackReason.MoveDetailTreatmentNotLoaded)
{
MoveDetail = moveDetail
});
continue;
}
const string tote = "";
yield return new PickedInventoryItem
{
DateCreated = pickedInventoryKey.PickedInventoryKey_DateCreated,
Sequence = pickedInventoryKey.PickedInventoryKey_Sequence,
ItemSequence = ++sequence,
DetailID = moveDetail.MDetail,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packaging.Id,
TreatmentId = treatment.Id,
ToteKey = tote,
Quantity = (int)moveDetail.Quantity,
FromLocationId = pickedLocation.Id,
CurrentLocationId = currentLocation.Id,
CustomerLotCode = moveDetail.CustLot,
CustomerProductCode = moveDetail.CustProductCode
};
}
}
private Results LoadAllowances(int lotNumber, SerializableLot deserializedLot)
{
var results = new Results();
var lotKey = LotNumberParser.ParseLotNumber(lotNumber);
foreach (var customer in deserializedLot.CustomerAllowances ?? new List <SerializableLot.CustomerAllowance>())
{
var company = _newContextHelper.GetCompany(customer.CompanyName, CompanyType.Customer);
if (company == null)
{
Log(new CallbackParameters(lotNumber, CallbackReason.CustomerNotLoaded)
{
CustomerAllowance = customer
});
}
else
{
results.CustomerAllowances.Add(new LotCustomerAllowance
{
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
CustomerId = company.Id
});
}
}
foreach (var contract in deserializedLot.ContractAllowances ?? new List <SerializableLot.ContractAllowance>())
{
var contractKey = _newContextHelper.GetContractKey(contract.ContractId);
if (contractKey == null)
{
Log(new CallbackParameters(lotNumber, CallbackReason.ContractNotLoaded)
{
ContractAllowance = contract
});
}
else
{
results.ContractAllowances.Add(new LotContractAllowance
{
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
ContractYear = contractKey.ContractKey_Year,
ContractSequence = contractKey.ContractKey_Sequence
});
}
}
foreach (var customerOrder in deserializedLot.CustomerOrderAllowances ?? new List <SerializableLot.CustomerOrderAllowance>())
{
var order = _newContextHelper.GetInventoryShipmentOrder(customerOrder.OrderNum, InventoryShipmentOrderTypeEnum.SalesOrder);
if (order == null)
{
Log(new CallbackParameters(lotNumber, CallbackReason.SalesOrderNotLoaded)
{
CustomerOrderAllowance = customerOrder
});
}
else
{
results.CustomerOrderAllowances.Add(new LotSalesOrderAllowance
{
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
SalesOrderDateCreated = order.DateCreated,
SalesOrderSequence = order.Sequence
});
}
}
return(results);
}
public void Creates_LotKey_as_expected()
{
//Arrange
var oldContext = new RioAccessSQLEntities();
var helper = new OldContextHelper(oldContext);
var packagings = TestHelper.Context.PackagingProducts.Select(p => new
{
Packaging = p,
p.Product
}).ToList();
tblPackaging tblPackaging;
var packaging = packagings.FirstOrDefault(p => helper.GetProductFromPackagingId(p.Product.ProductCode, out tblPackaging) == null);
if (packaging == null)
{
Assert.Inconclusive("No suitable Packaging product for testing.");
}
var location = RVCUnitOfWork.LocationRepository.Filter(l => l.LocID != null).First();
var lotDate = DateTime.Now.Date;
var lotSequence = 42;
var parameters = new ReceiveInventoryParameters
{
UserToken = TestUser.UserName,
LotType = LotTypeEnum.Additive,
LotDate = lotDate,
LotSequence = lotSequence,
ProductKey = new ProductKey((IProductKey)RVCUnitOfWork.AdditiveProductRepository.All().First()),
PackagingReceivedKey = new PackagingProductKey(packaging.Packaging),
Items = new List <ReceiveInventoryItemParameters>
{
new ReceiveInventoryItemParameters
{
Quantity = 1,
PackagingProductKey = new PackagingProductKey(packaging.Packaging),
WarehouseLocationKey = new LocationKey(location),
TreatmentKey = new InventoryTreatmentKey(RVCUnitOfWork.InventoryTreatmentRepository.All().First()),
ToteKey = ""
},
}
};
//Act
var result = Service.ReceiveInventory(parameters);
result.AssertSuccess();
var lotString = GetKeyFromConsoleString(ConsoleOutput.ReceivedInventory);
MockKillSwitch.Verify(k => k.Engage(), Times.Never());
var newLot = int.Parse(lotString);
var lotKey = LotNumberParser.ParseLotNumber(newLot);
Assert.AreEqual((int)LotTypeEnum.Additive, lotKey.LotKey_LotTypeId);
Assert.AreEqual(lotDate, lotKey.LotKey_DateCreated);
Assert.AreEqual(lotSequence, lotKey.LotKey_DateSequence);
var tblLot = oldContext.tblLots.FirstOrDefault(a => a.Lot == newLot);
Assert.IsNotNull(tblLot);
Assert.IsNotNull(oldContext.tblPackagings.Single(p => p.Packaging == packaging.Product.Name));
}
private InventoryTransaction Process(TransactionDTO transaction)
{
var employeeId = _newContextHelper.DefaultEmployee.EmployeeId;
if (transaction.EmployeeID == null)
{
Log(new CallbackParameters(CallbackReason.NullEmployeeID)
{
Transaction = transaction
});
}
else
{
employeeId = transaction.EmployeeID.Value;
}
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(transaction.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.CannotParseLotNumber)
{
Transaction = transaction
});
return(null);
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.LotNotLoaded)
{
Transaction = transaction
});
return(null);
}
LotKey newLotKey = null;
if (transaction.NewLot != null)
{
if (!LotNumberParser.ParseLotNumber(transaction.NewLot.Value, out newLotKey))
{
Log(new CallbackParameters(CallbackReason.CannotParseDestLotNumber)
{
Transaction = transaction
});
return(null);
}
if (!_newContextHelper.LotLoaded(newLotKey))
{
Log(new CallbackParameters(CallbackReason.DestLotNotLoaded)
{
Transaction = transaction
});
return(null);
}
}
PackagingProduct packaging;
if (_newContextHelper.GetPackagingLotWithProduct(lotKey) != null)
{
packaging = _newContextHelper.NoPackagingProduct;
}
else
{
packaging = _newContextHelper.GetPackagingProduct(transaction.PkgID);
if (packaging == null)
{
Log(new CallbackParameters(CallbackReason.PackagingNotLoaded)
{
Transaction = transaction
});
return(null);
}
}
var location = _newContextHelper.GetLocation(transaction.LocID);
if (location == null)
{
Log(new CallbackParameters(CallbackReason.LocationNotLoaded)
{
Transaction = transaction
});
return(null);
}
var treatment = _newContextHelper.GetInventoryTreatment(transaction.TrtmtID);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.TreatmentNotLoaded)
{
Transaction = transaction
});
return(null);
}
var date = transaction.EntryDate.Date;
return(SetTransactionType(new InventoryTransaction
{
DateCreated = date,
Sequence = GetSequence(date),
TimeStamp = transaction.EntryDate.ConvertLocalToUTC(),
EmployeeId = employeeId,
SourceLotDateCreated = lotKey.LotKey_DateCreated,
SourceLotDateSequence = lotKey.LotKey_DateSequence,
SourceLotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packaging.Id,
LocationId = location.Id,
TreatmentId = treatment.Id,
ToteKey = transaction.Tote ?? "",
Quantity = (int)(transaction.Quantity ?? 0),
DestinationLotDateCreated = newLotKey != null ? newLotKey.LotKey_DateCreated : (DateTime?)null,
DestinationLotDateSequence = newLotKey != null ? newLotKey.LotKey_DateSequence : (int?)null,
DestinationLotTypeId = newLotKey != null ? newLotKey.LotKey_LotTypeId : (int?)null
}, transaction));
}
protected override IEnumerable <ProductionBatch> BirthRecords()
{
_loadCount.Reset();
var processedLotKeys = new Dictionary <LotKey, int>();
foreach (var packSchedule in SelectProductionBatchesToLoad(OldContext))
{
var packSchId = packSchedule.PackSchID;
var employeeIdentifiableByLot = GetEmployeeIdentifiableByLot(packSchedule);
foreach (var oldBatch in packSchedule.ProductionBatches)
{
_loadCount.AddRead(EntityTypes.ProductionBatch);
var invalidBatchItems = oldBatch.BatchItems.Where(b => b.PackSchID == null).ToList();
if (invalidBatchItems.Any())
{
invalidBatchItems.ForEach(b => Log(new CallbackParameters(CallbackReason.NullPackSchID)
{
BatchItem = b
}));
continue;
}
invalidBatchItems = oldBatch.BatchItems.Where(b => b.NewLot == null).ToList();
if (invalidBatchItems.Any())
{
invalidBatchItems.ForEach(b => Log(new CallbackParameters(CallbackReason.NullNewLot)
{
BatchItem = b
}));
continue;
}
invalidBatchItems = oldBatch.BatchItems.Where(b => b.ResultLot == null).ToList();
if (invalidBatchItems.Any())
{
invalidBatchItems.ForEach(b => Log(new CallbackParameters(CallbackReason.NullResultLot)
{
BatchItem = b
}));
continue;
}
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(oldBatch.ResultLot.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
Batch = oldBatch
});
continue;
}
int previousLotNumber;
if (processedLotKeys.TryGetValue(lotKey, out previousLotNumber))
{
Log(new CallbackParameters(CallbackReason.LotAlreadyProcessed)
{
Batch = oldBatch
});
continue;
}
processedLotKeys.Add(lotKey, oldBatch.ResultLot.Lot);
var newPackSchedule = _newContextHelper.GetPackSchedule(packSchId);
if (newPackSchedule == null)
{
Log(new CallbackParameters(CallbackReason.PackScheduleNotLoaded)
{
Batch = oldBatch,
PackSchedule = packSchId
});
continue;
}
Tuple <DateTime, int> employeeIdentifiable;
if (!employeeIdentifiableByLot.TryGetValue(oldBatch.ResultLot.Lot, out employeeIdentifiable))
{
employeeIdentifiable = new Tuple <DateTime, int>(oldBatch.ResultLot.EntryDate.Value, oldBatch.ResultLot.EmployeeID.Value);
}
var chileLotProduction = CreateChileLotProduction(lotKey, oldBatch, newPackSchedule, employeeIdentifiable.Item1, employeeIdentifiable.Item2);
if (chileLotProduction == null)
{
continue;
}
var productionHasBeenCompleted = false;
if (oldBatch.ResultLot != null)
{
productionHasBeenCompleted = oldBatch.ResultLot.BatchStatID == (int)BatchStatID.Produced;
}
_loadCount.AddRead(EntityTypes.ProductionBatchInstructionNotebook);
var notebook = _notebookFactory.BirthNext(oldBatch.ResultLot.EntryDate.Value, oldBatch.ResultLot.EmployeeID.Value);
var productionBatch = new ProductionBatch
{
TimeStamp = employeeIdentifiable.Item1,
EmployeeId = employeeIdentifiable.Item2,
LotDateCreated = chileLotProduction.LotDateCreated,
LotDateSequence = chileLotProduction.LotDateSequence,
LotTypeId = chileLotProduction.LotTypeId,
PackScheduleDateCreated = newPackSchedule.DateCreated,
PackScheduleSequence = newPackSchedule.SequentialNumber,
InstructionNotebookDateCreated = notebook.Date,
InstructionNotebookSequence = notebook.Sequence,
ProductionHasBeenCompleted = productionHasBeenCompleted,
TargetParameters = new ProductionBatchTargetParameters(oldBatch.ResultLot),
Production = chileLotProduction,
InstructionNotebook = notebook
};
_loadCount.AddLoaded(EntityTypes.ChileLotProduction);
_loadCount.AddLoaded(EntityTypes.ProductionBatch);
if (productionBatch.Production.Results != null)
{
_loadCount.AddLoaded(EntityTypes.LotProductionResults);
_loadCount.AddLoaded(EntityTypes.LotProductionResultItem, (uint)productionBatch.Production.Results.ResultItems.Count);
}
_loadCount.AddLoaded(EntityTypes.PickedInventory);
_loadCount.AddLoaded(EntityTypes.PickedInventoryItem, (uint)productionBatch.Production.PickedInventory.Items.Count);
_loadCount.AddLoaded(EntityTypes.ProductionBatchInstructionNotebook);
yield return(productionBatch);
}
}
_loadCount.LogResults(l => Log(new CallbackParameters(l)));
}
private IEnumerable <PickedInventoryItem> CreatePickedInventoryItems(PickedInventory pickedInventory, IEnumerable <tblBatchItemDTO> batchItems)
{
var itemSequence = 1;
foreach (var batchItem in batchItems)
{
_loadCount.AddRead(EntityTypes.PickedInventoryItem);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(batchItem.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.BatchItemInvalidLotNumber)
{
BatchItem = batchItem
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.BatchItemLotNotLoaded)
{
BatchItem = batchItem
});
continue;
}
var packaging = batchItem.PTypeID == (int?)LotTypeEnum.Packaging ? _newContextHelper.NoPackagingProduct : _newContextHelper.GetPackagingProduct(batchItem.PkgID);
if (packaging == null)
{
Log(new CallbackParameters(CallbackReason.BatchItemPackagingNotLoaded)
{
BatchItem = batchItem
});
continue;
}
var treatment = _newContextHelper.GetInventoryTreatment(batchItem.TrtmtID);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.BatchItemTreatmentNotLoaded)
{
BatchItem = batchItem
});
continue;
}
int?currentLocationId = null;
var productionLocation = _newContextHelper.GetProductionLocation(batchItem.tblLocation);
if (productionLocation != null)
{
currentLocationId = productionLocation.Id;
}
else
{
var warehouseLocation = _newContextHelper.GetLocation(batchItem.LocID);
if (warehouseLocation != null)
{
currentLocationId = warehouseLocation.Id;
}
}
if (currentLocationId == null)
{
Log(new CallbackParameters(CallbackReason.BatchItemCurrentLocationCouldnotBeDetermined)
{
BatchItem = batchItem
});
continue;
}
int?warehouseLocationId;
var warehouseLocationResult = _pickedInventoryItemLocationHelper.DeterminePickedFromLocation(batchItem, out warehouseLocationId);
if (warehouseLocationResult == PickedInventoryItemLocationHelper.Result.UnableToDetermine)
{
Log(new CallbackParameters(CallbackReason.BatchItemDefaultPickedLocation)
{
BatchItem = batchItem
});
warehouseLocationId = _newContextHelper.UnknownFacilityLocation.Id;
}
if (warehouseLocationId == null)
{
Log(new CallbackParameters(CallbackReason.BatchItemPickedLocationNotDetermined)
{
BatchItem = batchItem
});
continue;
}
yield return(new PickedInventoryItem
{
DateCreated = pickedInventory.DateCreated,
Sequence = pickedInventory.Sequence,
ItemSequence = itemSequence,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packaging.Id,
FromLocationId = warehouseLocationId.Value,
TreatmentId = treatment.Id,
CurrentLocationId = currentLocationId.Value,
ToteKey = new string((batchItem.Tote ?? "").Take(Constants.StringLengths.ToteKeyLength).ToArray()),
Quantity = (int)(batchItem.Quantity ?? 0)
});
itemSequence += 1;
}
}
private void LoadDetails(SampleOrder sampleOrder, tblSampleDTO tblSample)
{
var items = new List <SampleOrderItem>();
var itemSequence = 1;
foreach (var tblSampleDetail in tblSample.tblSampleDetails)
{
LoadCount.AddRead(EntityType.SampleOrderItem);
var product = _newContextHelper.GetProduct(tblSampleDetail.ProdID);
if (product == null && tblSampleDetail.ProdID != null)
{
Log(new CallbackParameters(CallbackReason.tblSampleDetail_MissingProduct)
{
tblSampleDetail = tblSampleDetail
});
continue;
}
LotKey lotKey = null;
if (tblSampleDetail.Lot != null)
{
lotKey = LotNumberParser.ParseLotNumber(tblSampleDetail.Lot.Value);
if (lotKey == null)
{
Log(new CallbackParameters(CallbackReason.tblSampleDetail_InvalidLotNumber)
{
tblSampleDetail = tblSampleDetail
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.tblSampleDetail_MissingLot)
{
tblSampleDetail = tblSampleDetail
});
continue;
}
}
var sampleOrderItem = new SampleOrderItem
{
SampleOrderYear = sampleOrder.Year,
SampleOrderSequence = sampleOrder.Sequence,
ItemSequence = itemSequence++,
ProductId = product == null ? (int?)null : product.ProductKey.ProductKey_ProductId,
LotDateCreated = lotKey == null ? (DateTime?)null : lotKey.LotKey_DateCreated,
LotDateSequence = lotKey == null ? (int?)null : lotKey.LotKey_DateSequence,
LotTypeId = lotKey == null ? (int?)null : lotKey.LotKey_LotTypeId,
Quantity = (int)(tblSampleDetail.Qty ?? 0),
Description = tblSampleDetail.Desc,
CustomerProductName = tblSampleDetail.SampleMatch,
SampleDetailID = tblSampleDetail.SampleDetailID,
};
LoadItemSpec(tblSampleDetail.tblSampleCustSpec, sampleOrderItem);
LoadItemMatch(tblSampleDetail.tblSampleRVCMatch, sampleOrderItem);
items.Add(sampleOrderItem);
}
sampleOrder.Items = items;
}
private IEnumerable <PickedInventoryItem> CreatePickedInventoryItems(IPickedInventoryKey pickedInventoryKey, tblRinconDTO rincon)
{
var sequence = 0;
foreach (var detail in rincon.tblRinconDetails)
{
_loadCount.AddRead(EntityTypes.PickedInventoryItem);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(detail.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotKey)
{
Detail = detail
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.LotNotLoaded)
{
Detail = detail
});
continue;
}
var packagingProduct = detail.PTypeID == (int?)LotTypeEnum.Packaging ? _newContextHelper.NoPackagingProduct : _newContextHelper.GetPackagingProduct(detail.PkgID);
if (packagingProduct == null)
{
Log(new CallbackParameters(CallbackReason.PackagingNotLoaded)
{
Detail = detail
});
continue;
}
var fromWarehouseLocation = _newContextHelper.GetLocation(detail.CurrLocID);
if (fromWarehouseLocation == null)
{
Log(new CallbackParameters(CallbackReason.FromWarehouseLocationNotLoaded)
{
Detail = detail
});
continue;
}
var treatment = _newContextHelper.GetInventoryTreatment(detail.TrtmtID);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.TreatmentNotLoaded)
{
Detail = detail
});
continue;
}
var destinationLocation = _newContextHelper.GetLocation(detail.DestLocID);
if (destinationLocation == null)
{
Log(new CallbackParameters(CallbackReason.DestinationLocationNotLoaded)
{
Detail = detail
});
continue;
}
if (detail.Quantity == null)
{
Log(new CallbackParameters(CallbackReason.MissingQuantity)
{
Detail = detail
});
continue;
}
yield return(new PickedInventoryItem
{
DateCreated = pickedInventoryKey.PickedInventoryKey_DateCreated,
Sequence = pickedInventoryKey.PickedInventoryKey_Sequence,
ItemSequence = ++sequence,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
PackagingProductId = packagingProduct.Id,
FromLocationId = fromWarehouseLocation.Id,
TreatmentId = treatment.Id,
CurrentLocationId = destinationLocation.Id,
ToteKey = "",
Quantity = (int)detail.Quantity
});
}
}
private SalesOrderLoad SetItems(SalesOrderLoad order, tblOrderDTO oldOrder)
{
var orderItemSequence = 0;
var pickedItemSequence = 0;
order.SalesOrderItems = new List <SalesOrderItem>();
order.SalesOrderPickedItems = new List <SalesOrderPickedItem>();
var latestStaged = oldOrder.tblOrderDetails.SelectMany(d => d.tblStagedFGs)
.OrderByDescending(s => s.EntryDate)
.FirstOrDefault();
if (latestStaged != null)
{
order.InventoryShipmentOrder.PickedInventory.TimeStamp = latestStaged.EntryDate.ConvertLocalToUTC();
if (latestStaged.EmployeeID != null)
{
order.InventoryShipmentOrder.PickedInventory.EmployeeId = latestStaged.EmployeeID.Value;
}
}
foreach (var detail in oldOrder.tblOrderDetails)
{
LoadCount.AddRead(EntityType.SalesOrderItem);
var product = _newContextHelper.GetProduct(detail.ProdID);
if (product == null)
{
Log(new CallbackParameters(CallbackReason.DetailProductNotFound)
{
Order = oldOrder,
Detail = detail
});
continue;
}
var packaging = _newContextHelper.GetPackagingProduct(detail.PkgID);
if (packaging == null)
{
Log(new CallbackParameters(CallbackReason.DetailPackagingNotFound)
{
Order = oldOrder,
Detail = detail
});
continue;
}
var treatment = _newContextHelper.NoTreatment;
if (detail.TrtmtID != null)
{
treatment = _newContextHelper.GetInventoryTreatment(detail.TrtmtID.Value);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.DetailTreatmentNotFound)
{
Order = oldOrder,
Detail = detail
});
continue;
}
}
IContractItemKey contractItemKey = null;
if (detail.KDetailID != null)
{
contractItemKey = _newContextHelper.GetContractItemKey(detail.KDetailID);
if (contractItemKey == null)
{
Log(new CallbackParameters(CallbackReason.ContractItemNotFound)
{
Order = oldOrder,
Detail = detail
});
continue;
}
}
order.SalesOrderItems.Add(new SalesOrderItem
{
ItemSequence = orderItemSequence,
ContractYear = contractItemKey == null ? (int?)null : contractItemKey.ContractKey_Year,
ContractSequence = contractItemKey == null ? (int?)null : contractItemKey.ContractKey_Sequence,
ContractItemSequence = contractItemKey == null ? (int?)null : contractItemKey.ContractItemKey_Sequence,
PriceBase = (double)(detail.Price ?? 0),
PriceFreight = (double)(detail.FreightP ?? 0),
PriceTreatment = (double)(detail.TrtnmntP ?? 0),
PriceWarehouse = (double)(detail.WHCostP ?? 0),
PriceRebate = (double)(detail.Rebate ?? 0),
ODetail = detail.ODetail,
InventoryPickOrderItem = new InventoryPickOrderItem
{
ItemSequence = orderItemSequence,
ProductId = product.ProductKey.ProductKey_ProductId,
PackagingProductId = packaging.Id,
TreatmentId = treatment.Id,
Quantity = (int)(detail.Quantity ?? 0),
CustomerLotCode = detail.CustLot,
CustomerProductCode = detail.CustProductCode,
}
});
foreach (var staged in detail.tblStagedFGs)
{
LoadCount.AddRead(EntityType.SalesOrderPickedItem);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(staged.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.StagedInvalidLotNumber)
{
Order = oldOrder,
Staged = staged
});
continue;
}
packaging = _newContextHelper.GetPackagingProduct(staged.PkgID);
if (packaging == null)
{
Log(new CallbackParameters(CallbackReason.StagedPackagingNotFound)
{
Order = oldOrder,
Staged = staged
});
continue;
}
var currentLocation = _newContextHelper.GetLocation(staged.LocID);
if (currentLocation == null)
{
Log(new CallbackParameters(CallbackReason.StagedLocationNotFound)
{
Order = oldOrder,
Staged = staged
});
continue;
}
var fromLocation = detail.tblOutgoing.Any() ? DeterminePickedFromLocation(detail, staged) : currentLocation;
if (fromLocation == null)
{
Log(new CallbackParameters(CallbackReason.UndeterminedPickedFromLocation)
{
Order = oldOrder,
Staged = staged
});
continue;
}
treatment = _newContextHelper.GetInventoryTreatment(staged.TrtmtID);
if (treatment == null)
{
Log(new CallbackParameters(CallbackReason.StagedTreatmentNotFound)
{
Order = oldOrder,
Staged = staged
});
continue;
}
order.SalesOrderPickedItems.Add(new SalesOrderPickedItem
{
ItemSequence = pickedItemSequence,
OrderItemSequence = orderItemSequence,
PickedInventoryItem = new PickedInventoryItem
{
DetailID = staged.EntryDate,
ItemSequence = pickedItemSequence,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
Quantity = (int)(staged.Quantity ?? 0),
PackagingProductId = packaging.Id,
FromLocationId = fromLocation.Id,
CurrentLocationId = currentLocation.Id,
TreatmentId = treatment.Id,
ToteKey = "",
CustomerLotCode = staged.CustLot,
CustomerProductCode = staged.CustProductCode
}
});
pickedItemSequence++;
}
orderItemSequence++;
}
return(order);
}
protected override IEnumerable <LotHistory> BirthRecords()
{
_loadCount.Reset();
foreach (var lot in SelectRecords(OldContext))
{
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(lot.Lot, out lotKey))
{
Log(new CallbackParameters(CallbackReason.InvalidLotNumber)
{
Lot = lot
});
continue;
}
if (!_newContextHelper.LotLoaded(lotKey))
{
Log(new CallbackParameters(CallbackReason.LotNotLoaded)
{
Lot = lot
});
continue;
}
var sequence = 0;
var computedHistory = lot.History.Where(h => h.TestDate == null).OrderBy(h => h.ArchiveDate).FirstOrDefault();
DateTime?lotHistoryTimeStamp = null;
foreach (var history in lot.History.OrderBy(h => h.ArchiveDate))
{
_loadCount.AddRead(EntityTypes.LotAttributeHistory);
if (history.EmployeeID == null)
{
Log(new CallbackParameters(CallbackReason.EmployeeIDIsNull)
{
History = history
});
}
var employeeId = history.TesterID ?? history.EmployeeID ?? _newContextHelper.DefaultEmployee.EmployeeId;
string holdDescription;
var hold = LotHelper.GetHoldStatus((LotStat?)history.LotStat, out holdDescription);
var serializedData = new SerializedLotHistory
{
TimeStamp = lotHistoryTimeStamp ?? history.EntryDate.ConvertLocalToUTC() ?? lotKey.LotKey_DateCreated,
QualityStatus = DetermineLotQualityStatus((LotStat?)history.LotStat),
ProductionStatus = LotProductionStatus.Produced,
Hold = hold,
HoldDescription = holdDescription,
LoBac = history.LoBac,
Attributes = history.GetAttributes(computedHistory)
.Where(a => a.Value != null)
.Select(attribute => new SerializedLotHistoryAttribute
{
AttributeShortName = attribute.AttributeNameKey,
AttributeValue = (double)attribute.Value,
AttributeDate = (history.TestDate ?? history.ArchiveDate).Date,
Computed = attribute.Computed
}).ToList()
};
yield return(new LotHistory
{
LotTypeId = lotKey.LotKey_LotTypeId,
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
Sequence = sequence++,
TimeStamp = (lotHistoryTimeStamp = history.ArchiveDate.ConvertLocalToUTC()).Value,
EmployeeId = employeeId,
Serialized = JsonConvert.SerializeObject(serializedData)
});
_loadCount.AddLoaded(EntityTypes.LotAttributeHistory);
}
}
_loadCount.LogResults(l => Log(new CallbackParameters(l)));
}
protected override IEnumerable <LotResults> BirthRecords()
{
_loadCount.Reset();
var lotKeys = new Dictionary <LotKey, int>();
foreach (var lot in SelectLotsToLoad(OldContext))
{
_loadCount.AddRead(EntityTypes.Lot);
LotKey lotKey;
if (!LotNumberParser.ParseLotNumber(lot.Lot, out lotKey))
{
Log(new CallbackParameters(lot, CallbackReason.InvalidLotNumber));
continue;
}
if (_newContextHelper.LotLoaded(lotKey))
{
continue;
}
if (lotKeys.ContainsKey(lotKey))
{
Log(new CallbackParameters(lot, CallbackReason.DuplicateLotNumber)
{
ExistingLotNumber = lotKeys[lotKey]
});
continue;
}
lotKeys.Add(lotKey, lot.Lot);
if (lot.EntryDate == null)
{
Log(new CallbackParameters(lot, CallbackReason.EntryDateNull));
continue;
}
if (lot.tblProduct == null)
{
Log(new CallbackParameters(lot, CallbackReason.NullProductReference));
continue;
}
var lotType = lotKey.LotKey_LotTypeId.ToLotType();
if (lotType == null)
{
Log(new CallbackParameters(lot, CallbackReason.InvalidLotType)
{
LotKey = lotKey
});
continue;
}
var deserialized = SerializableLot.Deserialize(lot.Serialized);
var packagingReceived = GetPackagingReceived(lot, deserialized);
if (packagingReceived == null)
{
continue;
}
Models.Company vendor = null;
if (!string.IsNullOrWhiteSpace(lot.Company_IA))
{
vendor = _newContextHelper.GetCompany(lot.Company_IA);
if (vendor == null)
{
Log(new CallbackParameters(lot, CallbackReason.CompanyNotLoaded));
}
}
var newLot = new Lot
{
LotDateCreated = lotKey.LotKey_DateCreated,
LotDateSequence = lotKey.LotKey_DateSequence,
LotTypeId = lotKey.LotKey_LotTypeId,
EmployeeId = lot.DeterminedEmployeeId != null ? lot.DeterminedEmployeeId.Value : _newContextHelper.DefaultEmployee.EmployeeId,
TimeStamp = lot.DeterminedTimestamp.ConvertLocalToUTC() ?? lotKey.LotKey_DateCreated,
ReceivedPackagingProductId = packagingReceived.PackagingProductKey_ProductId,
VendorId = vendor == null ? (int?)null : vendor.Id,
PurchaseOrderNumber = lot.PurchOrder,
ShipperNumber = lot.ShipperNum,
Notes = lot.Notes
};
LotResults results = null;
switch (lotType.Value.ToProductType())
{
case ProductTypeEnum.Additive: results = GetAdditiveLotResults(lot, newLot); break;
case ProductTypeEnum.Chile: results = GetChileLotResults(lot, newLot, deserialized); break;
case ProductTypeEnum.Packaging: results = GetPackagingLotResults(lot, newLot); break;
}
if (results != null)
{
_loadCount.AddLoaded(EntityTypes.Lot);
if (results.ChileLot != null)
{
_loadCount.AddLoaded(EntityTypes.ChileLot);
_loadCount.AddLoaded(EntityTypes.LotAttribute, (uint)results.ChileLot.Lot.Attributes.Count);
_loadCount.AddLoaded(EntityTypes.LotDefect, (uint)(results.ChileLot.Lot.LotDefects == null ? 0 : results.ChileLot.Lot.LotDefects.Count));
_loadCount.AddLoaded(EntityTypes.LotDefectResolution, (uint)(results.ChileLot.Lot.LotDefects == null ? 0 : results.ChileLot.Lot.LotDefects.Count(d => d.Resolution != null)));
_loadCount.AddLoaded(EntityTypes.LotAttributeDefect, (uint)(results.LotAttributeDefects == null ? 0 : results.LotAttributeDefects.Count));
}
if (results.AdditiveLot != null)
{
_loadCount.AddLoaded(EntityTypes.AdditiveLot);
_loadCount.AddLoaded(EntityTypes.LotAttribute, (uint)results.AdditiveLot.Lot.Attributes.Count);
}
_loadCount.AddLoaded(EntityTypes.PackagingLot, (uint)(results.PackagingLot != null ? 1 : 0));
yield return(results);
}
}
_loadCount.LogResults(l => Log(new CallbackParameters(l)));
}
