public void InsertScrapTransactionBuffer(IEnumerable<DispositionTag> tags) { PartMasterDataContext dbPart = new PartMasterDataContext(); DispositionLabelMaker labelMaker = new DispositionLabelMaker(); foreach (var tag in tags) { string fromLocation = tag.Part.location.Trim(); string toLocation = ""; if (tag.Disposition.Transaction.Trim() == "TRANSFER") { if (fromLocation.Equals("PILOT")) toLocation = "PILOTHLD"; else toLocation = "HOLDASSM"; } string reason = labelMaker.GetTrans4mReasonCode(tag); dbPart.InsertTransactionBuffer(tag.Part.partno.Trim(), (short)tag.Disposition.Qty, tag.Disposition.Transaction.Trim(), reason.Trim(), fromLocation, toLocation, ""); } }