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.

    • Clearing\Resetting The Local Cache in SmartViews

      This article is out of date. Read this one instead: Synergy Resources (zoho.com) There are times in which the local database becomes out of sync with the cloud database causing the sync functionality to stop working. Clearing the cache will solve ...

    • 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     ...