I am new to C# and method directives so would like some guidance regarding modifying a method directive. Method directive I am updating is post-processing.
Objective: Set the “Character05” field in the “OrderRel_UD” table to “Character12” in the “QuoteHed_UD” field.
Below snap shots include the mappings, my current C# that I need to add to the current method directive custom C# code.
FYI, you are doing 4 database calls and returning whole records when all you wanted was one field.
In this case, I would offer a Data DIrective on OrderRel (don’t hate me guys…).
The query is the important part.
foreach (var tt in ttOrderRel.Where(tt => tt.Added() ))
{
var char12 = (from D in Db.OrderDtl.Where(D => D.Company == tt.Company && D.OrderNum == tt.OrderNum && D.OrderLine == tt.OrderLine)
join Q in Db.QuoteHed on
new {D.Company, D.QuoteNum} equals
new {Q.COmpany, Q.QuoteNum}
select Q.Character12).FirstOrDefault();
tt.Character05 = char12;
}