Edit Contract Bin Quantities

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";

const string ContractNo = "A120-12";
const string JobNo = "31", CustomerId = "100198", ShipToId = "200";

// Per bin: the line's item_id, the bin id, and the new quantities.
var binEdits = new (string ItemId, string BinId, int Min, int Max, int Reorder, int Capacity)[]
{
    ("WIDGET-001", "A01-02", 30, 100, 40, 100),
    ("WIDGET-002", "A01-02", 5, 50, 10, 50),
};

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

JObject BuildBinPayload()
{
    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("job_no",      JobNo),
                Edit("customer_id", CustomerId),
                Edit("ship_to_id",  ShipToId),
            } } }
        }
    };
    foreach (var e in binEdits)
    {
        elements.Add(new JObject
        {
            ["Name"] = "JOBPRICELINE.jobpriceline", ["Type"] = "List",
            ["Keys"] = new JArray { "item_id" },   // select by item_id, NOT line_no
            ["Rows"] = new JArray { new JObject {
                ["Edits"] = new JArray { Edit("item_id", e.ItemId) } } }
        });
        elements.Add(new JObject
        {
            ["Name"] = "BINS.bins", ["Type"] = "List",
            ["Keys"] = new JArray { "contract_bin_id", "customer_id", "ship_to_id" },
            ["Rows"] = new JArray { new JObject { ["Edits"] = new JArray {
                Edit("contract_bin_id", e.BinId),
                Edit("customer_id",     CustomerId),
                Edit("ship_to_id",      ShipToId),
                Edit("min_qty",         e.Min.ToString()),
                Edit("max_qty",         e.Max.ToString()),
                Edit("reorder_qty",     e.Reorder.ToString()),
                Edit("capacity",        e.Capacity.ToString()),
            } } }
        });
    }
    return new JObject
    {
        ["Name"] = "JobContractPricing", ["UseCodeValues"] = false,
        ["IgnoreDisabled"] = true,  // top level — mandatory for the BINS sub-tab
        ["Transactions"] = new JArray {
            new JObject { ["Status"] = "New", ["DataElements"] = elements } }
    };
}

var resp = await session.Http.PostAsync(
    $"{session.UiServer}/api/v2/transaction",
    new StringContent(BuildBinPayload().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"]!;
Console.WriteLine($"Succeeded: {summary["Succeeded"]}, Failed: {summary["Failed"]}");
if ((int)summary["Failed"]! > 0 || (int)summary["Succeeded"]! == 0)
{
    foreach (var msg in result["Messages"] as JArray ?? new JArray())
        Console.WriteLine($"  FAILED: {msg}");
    return;
}

// --- 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 r = await session.Http.GetAsync(url);
    r.EnsureSuccessStatusCode();
    return (JArray)JObject.Parse(await r.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 '{ContractNo}' and job_no eq '{JobNo}'"))[0];
foreach (var e in binEdits)
{
    var imUid = (await ODataAsync("inv_mast", $"item_id eq '{e.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];
    foreach (var binRow in await ODataAsync("job_price_bin",
        $"job_price_line_uid eq {line["job_price_line_uid"]}"))
    {
        Console.WriteLine($"{e.ItemId}: min={binRow["min_qty"]} max={binRow["max_qty"]} " +
                          $"reorder={binRow["reorder_qty"]} " +
                          $"(expected {e.Min}/{e.Max}/{e.Reorder})");
    }
}