private void LoadItemMatch(tblSampleRVCMatchDTO tblSampleRVCMatch, SampleOrderItem orderItem)
{
if (tblSampleRVCMatch == null)
{
return;
}
LoadCount.AddRead(EntityType.SampleOrderItemMatch);
orderItem.Match = new SampleOrderItemMatch
{
SampleOrderYear = orderItem.SampleOrderYear,
SampleOrderSequence = orderItem.SampleOrderSequence,
ItemSequence = orderItem.ItemSequence,
Gran = tblSampleRVCMatch.Gran,
AvgAsta = tblSampleRVCMatch.AvgAsta,
AoverB = tblSampleRVCMatch.AoverB,
AvgScov = tblSampleRVCMatch.AvgScov,
H2O = tblSampleRVCMatch.H2O,
Scan = tblSampleRVCMatch.Scan,
Yeast = tblSampleRVCMatch.Yeast,
Mold = tblSampleRVCMatch.Mold,
Coli = tblSampleRVCMatch.Coli,
TPC = tblSampleRVCMatch.TPC,
EColi = tblSampleRVCMatch.EColi,
Sal = tblSampleRVCMatch.Sal,
InsPrts = tblSampleRVCMatch.InsPrts,
RodHrs = tblSampleRVCMatch.RodHrs,
Notes = tblSampleRVCMatch.Notes,
RVCMatchID = tblSampleRVCMatch.RVCMatchID
};
}
internal static void AssertEqual(this ISampleOrderItemParameters expected, SampleOrderItem result)
{
if (!string.IsNullOrWhiteSpace(expected.SampleOrderItemKey))
{
Assert.AreEqual(expected.SampleOrderItemKey, result.ToSampleOrderItemKey().KeyValue);
}
Assert.AreEqual(expected.Quantity, result.Quantity);
Assert.AreEqual(expected.Description, result.Description);
Assert.AreEqual(expected.CustomerProductName, result.CustomerProductName);
if (!string.IsNullOrWhiteSpace(expected.ProductKey))
{
Assert.AreEqual(expected.ProductKey, result.Product.ToProductKey().KeyValue);
}
else
{
Assert.IsNull(result.Product);
if (!string.IsNullOrWhiteSpace(expected.LotKey))
{
Assert.AreEqual(expected.LotKey, result.Lot.ToLotKey().KeyValue);
}
else
{
Assert.IsNull(result.Lot);
}
}
}
internal static void AssertEqual(this SampleOrderItem expected, ISampleOrderItemReturn result)
{
Assert.AreEqual(expected.ToSampleOrderItemKey().KeyValue, result.ItemKey);
Assert.AreEqual(expected.CustomerProductName, result.CustomerProductName);
Assert.AreEqual(expected.Lot == null ? null : expected.Lot.ToLotKey().KeyValue, result.LotKey);
Assert.AreEqual(expected.Product == null ? null : expected.Product.ToProductKey().KeyValue, result.ProductKey);
Assert.AreEqual(expected.Product == null ? (ProductTypeEnum?)null : expected.Product.ProductType, result.ProductType);
Assert.AreEqual(expected.Quantity, result.Quantity);
Assert.AreEqual(expected.Description, result.Description);
expected.Spec.AssertEqual(result.CustomerSpec);
expected.Match.AssertEqual(result.LabResults);
}
private void LoadItemSpec(tblSampleCustSpecDTO tblSampleCustSpec, SampleOrderItem orderItem)
{
if (tblSampleCustSpec == null)
{
return;
}
LoadCount.AddRead(EntityType.SampleOrderItemSpec);
orderItem.Spec = new SampleOrderItemSpec
{
SampleOrderYear = orderItem.SampleOrderYear,
SampleOrderSequence = orderItem.SampleOrderSequence,
ItemSequence = orderItem.ItemSequence,
AstaMin = tblSampleCustSpec.AstaMin,
AstaMax = tblSampleCustSpec.AstaMax,
MoistureMin = tblSampleCustSpec.MoistureMin,
MoistureMax = tblSampleCustSpec.MoistureMax,
WaterActivityMin = tblSampleCustSpec.WaterActivityMin,
WaterActivityMax = tblSampleCustSpec.WaterActivityMax,
Mesh = tblSampleCustSpec.Mesh,
AoverB = tblSampleCustSpec.AoverB,
ScovMin = tblSampleCustSpec.ScovMin,
ScovMax = tblSampleCustSpec.ScovMax,
ScanMin = tblSampleCustSpec.ScanMin,
ScanMax = tblSampleCustSpec.ScanMax,
TPCMin = tblSampleCustSpec.TPCMin,
TPCMax = tblSampleCustSpec.TPCMax,
YeastMin = tblSampleCustSpec.YeastMin,
YeastMax = tblSampleCustSpec.YeastMax,
MoldMin = tblSampleCustSpec.MoldMin,
MoldMax = tblSampleCustSpec.MoldMax,
ColiformsMin = tblSampleCustSpec.ColiformsMin,
ColiformsMax = tblSampleCustSpec.ColiformsMax,
EColiMin = tblSampleCustSpec.EColiMin,
EColiMax = tblSampleCustSpec.EColiMax,
SalMin = tblSampleCustSpec.SalMin,
SalMax = tblSampleCustSpec.SalMax,
Notes = tblSampleCustSpec.Notes,
CustSpecID = tblSampleCustSpec.CustSpecID
};
}
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;
}
