===== 3. Standalone Script =====

Standalone Script is used for starting a logic individually from Produmex WMS by the WMS robot tool. It can be scheduled in the Windows Scheduler. This can be for example a very complex replenishment order generation.

====3.1. Database Connection====

**Necessary classes:**
^ Class   ^ Reference  ^ 
| TransactionScope   | <code>using System.Transactions;</code>    | 
| PmxDbConnection   | <code>using Produmex.Foundation.Data.Sbo;</code>     | 

<WRAP round box> **Steps:**
  * **1. Define the connection string:**
Copy your connection string text from any config file of the Produmex WMS tools or Fat Client application.
<code>private static string CONNECTION_STRING = “”;</code>
  * **2. Start a transaction:**
<code>using (TransactionScope scope = PmxDbConnection.GetNewTransactionScope())</code>
  * **3. Create the connection:**
<code>using (PmxDbConnectionDirect conn = PmxDbConnectionMgr.GetDirectConnection(SboConnectionString.ParseStringToObject(CONNECTION_STRING)))</code>
</WRAP>
<WRAP round box>**Example:**
<code>
using ( TransactionScope scope = 
PmxDbConnection.GetNewTransactionScope())
{
      using (PmxDbConnectionDirect conn = PmxDbConnectionMgr.GetDirectConnection(SboConnectionString.ParseStringToObject(CONNECTION_STRING)))
{
conn.Open();
                    Console.WriteLine("Connection is open");

       	             string query = @"SELECT TOP 1 DocEntry FROM PMX_PLHE WHERE DocStatus = 'O' ORDER BY DocEntry ";

             	       using (ISboRecordset rs1 = SboRecordsetHelper.RunQuery(s_log, query, conn))
                    	{
                        while (!rs1.EoF)
       	                 {
					… Do Something … 
             	               rs1.MoveNext();
                        }
       	             }
      	             }
                    scope.Complete();	//Complete transaction
}

</code>
</WRAP>