SyteLine IDO Custom Load Method (CLM) Generator

using System;
using System.Data;
using Mongoose.IDO;
using Mongoose.IDO.Protocol;

namespace Netray.SyteLine.Ext
{
    [IDOExtensionClass("UETOpenOrderLines")]
    public class UETOpenOrderLinesExt : IDOExtensionClass
    {
        // Custom load method: returns a DataTable whose column names must match
        // the property names defined on the UETOpenOrderLines IDO.
        [IDOMethod(MethodFlags.CustomLoad)]
        public DataTable GetLateLinesClm(string Whse, int DaysLate)
        {
            DataTable dt = new DataTable("Results");
            dt.Columns.Add("CoNum", typeof(string));
            dt.Columns.Add("CoLine", typeof(short));
            dt.Columns.Add("CoRelease", typeof(short));
            dt.Columns.Add("Item", typeof(string));
            dt.Columns.Add("DueDate", typeof(DateTime));
            dt.Columns.Add("QtyOpen", typeof(decimal));

            DateTime cutoff = DateTime.Today.AddDays(-DaysLate);
            string safeWhse = (Whse ?? string.Empty).Replace("'", "''");
            string filter = string.Format("Whse = N'{0}' AND Stat = N'O'", safeWhse);

            LoadCollectionResponseData response = this.Context.Commands.LoadCollection(
                "SLCoitems",
                "CoNum, CoLine, CoRelease, Item, DueDate, QtyOrdered, QtyShipped",
                filter,
                "DueDate",
                0);

            int iCoNum = response.PropertyList.IndexOf("CoNum");
            int iCoLine = response.PropertyList.IndexOf("CoLine");
            int iCoRelease = response.PropertyList.IndexOf("CoRelease");
            int iItem = response.PropertyList.IndexOf("Item");
            int iDue = response.PropertyList.IndexOf("DueDate");
            int iOrdered = response.PropertyList.IndexOf("QtyOrdered");
            int iShipped = response.PropertyList.IndexOf("QtyShipped");

            foreach (IDOItem row in response.Items)
            {
                if (row.PropertyValues[iDue].IsNull)
                {
                    continue;
                }
                DateTime due = row.PropertyValues[iDue].GetValue<DateTime>();
                if (due >= cutoff)
                {
                    continue;
                }
                decimal qtyOpen = row.PropertyValues[iOrdered].GetValue<decimal>()
                    - row.PropertyValues[iShipped].GetValue<decimal>();
                if (qtyOpen <= 0m)
                {
                    continue;
                }
                dt.Rows.Add(
                    row.PropertyValues[iCoNum].GetValue<string>(),
                    row.PropertyValues[iCoLine].GetValue<short>(),
                    row.PropertyValues[iCoRelease].GetValue<short>(),
                    row.PropertyValues[iItem].GetValue<string>(),
                    due,
                    qtyOpen);
            }

            return dt;
        }
    }
}

// IDO metadata checklist for UETOpenOrderLines.GetLateLinesClm
// 1. Import the assembly on the IDO Custom Assemblies form and set the IDO's
//    Custom Assembly Name and Ext Class Name (Netray.SyteLine.Ext.UETOpenOrderLinesExt).
// 2. Add method GetLateLinesClm with method type Custom Load and parameters
//    Whse (string) and DaysLate (int), in that order.
// 3. Define IDO properties CoNum, CoLine, CoRelease, Item, DueDate, QtyOpen.
//    Names must match the DataTable column names exactly, including case.
// 4. Make them unbound (not bound to a table column) with data types and
//    lengths that match the values returned.
// 5. Refresh IDO metadata on the application server, then test with the
//    REST call below or from a form whose collection uses the custom load.

GET https://sl-app01/IDORequestService/ido/load/UETOpenOrderLines?properties=CoNum,CoLine,CoRelease,Item,DueDate,QtyOpen&clm=GetLateLinesClm&clmparam=MAIN,5
Authorization: <token from the token request>
X-Infor-MongooseConfig: SL_PROD
Accept: application/json

# clmparam lists the method parameters in declaration order, comma separated.
# URL encode values that contain spaces or commas.