Update Contract Lines

using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

var session = await P21Session.CreateAsync(
    "https://play.p21server.com", "api_user", "api_pass");
const string BaseUrl = "https://play.p21server.com";

var contract = new { CompanyId = "ACME", ContractNo = "A120-12",
                     JobNo = "31", EndDate = "2030-01-01" };

JObject Edit(string name, string value) =>
    new JObject { ["Name"] = name, ["Value"] = value };

JObject LinePayload(string itemId, string uom, decimal price, decimal? commissionCost)
{
    var elements = new JArray
    {
        new JObject
        {
            ["Name"] = "FORM.d_dw_job_price_hdr", ["Type"] = "Form",
            ["Keys"] = new JArray(),
            ["Rows"] = new JArray { new JObject {
                ["Edits"] = new JArray {
                    Edit("company_id",  contract.CompanyId),
                    Edit("contract_no", contract.ContractNo),
                    Edit("job_no",      contract.JobNo),
                    Edit("end_date",    contract.EndDate),
                },
                ["RelativeDateEdits"] = new JArray() } }
        },
        new JObject
        {
            ["Name"] = "JOBPRICELINE.jobpriceline", ["Type"] = "List",
            ["Keys"] = new JArray { "item_id" },
            ["Rows"] = new JArray { new JObject {
                ["Edits"] = new JArray {
                    Edit("item_id",        itemId),
                    Edit("uom",            uom),
                    Edit("pricing_method", "Price"),          // before price!
                    Edit("price",          price.ToString()),
                },
                ["RelativeDateEdits"] = new JArray() } }
        },
    };
    var payload = new JObject
    {
        ["Name"] = "JobContractPricing", ["UseCodeValues"] = false,
        ["Transactions"] = new JArray {
            new JObject { ["Status"] = "New", ["DataElements"] = elements } }
    };
    if (commissionCost is not null)
    {
        payload["IgnoreDisabled"] = true;  // top level, NOT inside the Transaction
        elements.Add(new JObject
        {
            ["Name"] = "JOBPRICECOST.jobpricecost", ["Type"] = "Form",
            ["Keys"] = new JArray { "item_id" },
            ["Rows"] = new JArray { new JObject { ["Edits"] = new JArray {
                Edit("item_id",                 itemId),
                Edit("commission_cost_type_cd", "Value"),     // type before value
                Edit("commission_cost_value",   commissionCost.ToString()!),
            } } }
        });
    }
    return payload;
}

async Task<bool> PostLineAsync(JObject payload)
{
    var resp = await session.Http.PostAsync(
        $"{session.UiServer}/api/v2/transaction",
        new StringContent(payload.ToString(), Encoding.UTF8, "application/json"));
    resp.EnsureSuccessStatusCode();  // HTTP 200 even when the transaction failed
    var result = JObject.Parse(await resp.Content.ReadAsStringAsync());
    var summary = result["Summary"]!;
    if ((int)summary["Failed"]! > 0 || (int)summary["Succeeded"]! == 0)
    {
        foreach (var msg in result["Messages"] as JArray ?? new JArray())
            Console.WriteLine($"  FAILED: {msg}");
        return false;
    }
    return true;
}

// One POST per line: inserts re-save the shared header and collide when batched.
var lines = new (string ItemId, string Uom, decimal Price, decimal? Commission)[]
{
    ("WIDGET-001", "EA", 36.58m, 17.19m),  // already on contract -> updated
    ("WIDGET-002", "EA", 12.40m, null),    // not on contract     -> inserted (upsert)
};
foreach (var l in lines)
{
    var ok = await PostLineAsync(LinePayload(l.ItemId, l.Uom, l.Price, l.Commission));
    Console.WriteLine($"{l.ItemId}: {(ok ? "OK" : "failed")}");
}

// --- Verify via OData (no joins: chain the uid columns) ---
async Task<JArray> ODataAsync(string table, string filter)
{
    var url = $"{BaseUrl}/odataservice/odata/table/{table}" +
              $"?$filter={Uri.EscapeDataString(filter)}";
    var resp = await session.Http.GetAsync(url);
    resp.EnsureSuccessStatusCode();
    return (JArray)JObject.Parse(await resp.Content.ReadAsStringAsync())["value"]!;
}

// Renewals can return two headers for one contract_no — match job_no too.
var hdr = (JObject)(await ODataAsync("job_price_hdr",
    $"contract_no eq '{contract.ContractNo}' and job_no eq '{contract.JobNo}'"))[0];
foreach (var l in lines)
{
    var imUid = (await ODataAsync("inv_mast", $"item_id eq '{l.ItemId}'"))[0]["inv_mast_uid"];
    var line = (await ODataAsync("job_price_line",
        $"job_price_hdr_uid eq {hdr["job_price_hdr_uid"]} and inv_mast_uid eq {imUid}"))[0];
    var match = (decimal)line["price"]! == l.Price ? "OK" : "MISMATCH";
    Console.WriteLine($"{l.ItemId}: price={line["price"]} expected={l.Price} -> {match}");
}