Delete a Packlist with SBO

Delete a Packlist with SBO

 public bool Delete_Packlist(string packlist_id)
        {
            DatabaseConnection _Database;
            bool result = true;
            try
            {
                // Add DB connection specific code here.

                using (IDbConnection conn = _Database.Connection)
                {
                    conn.Open();
                    SHIPPER s = new SHIPPER(_Database).Load(packlist_id);
                    s.Delete();
                    s.Save();
                }
            }
            catch (Exception ex)
            {
                _Database.Transaction?.Rollback();
                result = false;
            }
            finally
            {
                _Database.Transaction?.Dispose();
                _Database.Transaction = null;
            }

            return result;
        }

    • Related Articles

    • Retrieving Customizable User Defined Field (CUDF) List Values with SBO

      The UFD List data is stored in the USER_DEF_FIELDS table. It looks like this: You can retrieve it with a direct SQL query, but you need to know the UDF’s ID for the field in question. Here is an example: SELECT PROGRAM_ID, ID, DOCUMENT_ID, LINE_NO, ...

    • VELogon - INI settings - delete lines using Policy Profile folder

      See attached for generic instructions for deleting lines from an INI file using the Policy Profile\VMFG folder in a VEScripts/VELogon environment.

    • Expensify - Release Notes

      v1000.1300 - Strip alpha characters out of Report ID (to keep the data mapping the same) v1000.1200 - use the NumericField to store the Report ID value - Change display to be Numeric for that column (not string so it doesn't turn it into an ...

    • Shipper Connect - Release Notes

      "DatabaseConnectionUI: Fix Server not always being disabled for Oracle DatabaseConnectionUI & DefaultDatabaseConnectionUI: Ignore case for string compares FrmMain: Eliminate try/catch for alias" Add MacroStub.vms to the ClientLoader Project Macro ...

    • Synergy Tax Process Flow

      Order Entry Shipping Invoice Generation Technical Notes: During the install, a Windows Service (Synergy Job Queue) and database tables & triggers are created. These triggers interact with the Windows service to run the tasks without the need for a ...