private static void SetMatch(tblSampleRVCMatch match, SampleOrderItemMatch itemMatch)
{
match.Notes = itemMatch.Notes;
match.Gran = itemMatch.Gran;
match.AvgAsta = itemMatch.AvgAsta;
match.AoverB = itemMatch.AoverB;
match.AvgScov = itemMatch.AvgScov;
match.H2O = itemMatch.H2O;
match.Scan = itemMatch.Scan;
match.Yeast = itemMatch.Yeast;
match.Mold = itemMatch.Mold;
match.Coli = itemMatch.Coli;
match.TPC = itemMatch.TPC;
match.EColi = itemMatch.EColi;
match.Sal = itemMatch.Sal;
match.InsPrts = itemMatch.InsPrts;
match.RodHrs = itemMatch.RodHrs;
}
private void SetTblSampleDetails(tblSample tblSample, SampleOrder sampleOrder, ref bool commitNewContext)
{
var existingDetails = tblSample.tblSampleDetails.ToDictionary(n => n.SampleDetailID);
var sampleDetailId = OldContext.tblSampleDetails.Select(n => n.SampleDetailID).DefaultIfEmpty(DateTime.Now.RoundMillisecondsForSQL()).Max();
var custSpecId = OldContext.tblSampleCustSpecs.Select(n => n.CustSpecID).DefaultIfEmpty(DateTime.Now.RoundMillisecondsForSQL()).Max();
var rvcMatchId = OldContext.tblSampleRVCMatches.Select(n => n.RVCMatchID).DefaultIfEmpty(DateTime.Now.RoundMillisecondsForSQL()).Max();
foreach(var item in sampleOrder.Items)
{
tblSampleDetail detail = null;
if(item.SampleDetailID != null && existingDetails.TryGetValue(item.SampleDetailID.Value, out detail))
{
existingDetails.Remove(detail.SampleDetailID);
}
if(detail == null)
{
commitNewContext = true;
sampleDetailId = sampleDetailId.AddSeconds(1);
detail = new tblSampleDetail
{
SampleDetailID = sampleDetailId,
SampleID = tblSample.SampleID,
s_GUID = Guid.NewGuid()
};
OldContext.tblSampleDetails.AddObject(detail);
item.SampleDetailID = detail.SampleDetailID;
}
detail.ProdID = item.Product == null ? (int?) null : int.Parse(item.Product.ProductCode);
detail.Lot = item.Lot == null ? (int?) null : LotNumberParser.BuildLotNumber(item.Lot);
detail.Qty = item.Quantity;
detail.Desc = item.Description;
detail.SampleMatch = item.CustomerProductName;
if(item.Spec == null)
{
DeleteTblSampleCustSpecs(detail);
}
else
{
var spec = detail.tblSampleCustSpecs.FirstOrDefault(s => s.CustSpecID == item.Spec.CustSpecID);
if(spec == null)
{
commitNewContext = true;
custSpecId = custSpecId.AddSeconds(1);
spec = new tblSampleCustSpec
{
CustSpecID = custSpecId,
SampleDetailID = detail.SampleDetailID
};
OldContext.tblSampleCustSpecs.AddObject(spec);
item.Spec.CustSpecID = spec.CustSpecID;
}
SetSpec(spec, item.Spec);
}
if(item.Match == null)
{
DeleteTblSampleRVCMatches(detail);
}
else
{
var match = detail.tblSampleRVCMatches.FirstOrDefault(s => s.RVCMatchID == item.Match.RVCMatchID);
if(match == null)
{
commitNewContext = true;
rvcMatchId = rvcMatchId.AddSeconds(1);
match = new tblSampleRVCMatch
{
RVCMatchID = rvcMatchId,
SampleDetailID = detail.SampleDetailID
};
OldContext.tblSampleRVCMatches.AddObject(match);
item.Match.RVCMatchID = match.RVCMatchID;
}
SetMatch(match, item.Match);
}
}
foreach(var detail in existingDetails)
{
DeleteTblSampleDetail(detail.Value);
}
}
