Please enable JavaScript.

Coggle requires JavaScript to display documents.

ESR-4639 - Parcel File Creation Email (SQL Scripts (BEGIN TRAN USE…

- - - - packages = _packageRepository.
        GetPackagesForBrokerManifestOut()
        
        S. Proc.: [packages].
        [GetPackagesForBrokerManifestOut]
        
        select top (200) p.packageId, b.brokerId, b.BrokerName, *
        from packages.packages p
        join orders.orders o on o.orderid= p.OrderId
        Join Parties.Brokers b on p.BrokerId = b.BrokerId
        where p.PackageStatusId = 1 (Routing Applied) and o.OrderTypeId <> 4 (Completed)
        
        result =
        GetPackagesFromBrokerManifestOutAssignResults
        (reader, db)
    - - IF: BrokerId = 1 (Asendia)
        
        ProcessAsendiaPackages
        (packages.ToList(),
        brandsWithActivations)
        
        AsendiaParcelFileCreation
        (packages, brandsWithActivations)
        
        \FileProcessing\
        AsendiaParcelFileCreation.cs
        
        Start()
      - ELSE:
        
        ProcessEswBrokerManifestOutPackages
        (packages.ToList())
- - - - \BusinessObjects\esw.BusinessObjects.Objects\EmailBpc.cs
        
        GetSmtpClient(...)
        
        //DEBUG ONLY! REPLACE username AND password WITH YOUR GMAIL ACCOUNT TO TEST THIS FUNCTIONALITY LOCALLY!//host = "smtp.gmail.com";
        //port = 587;
        //username = "esw5574@gmail.com";
        //password = "eshopworld";
        //client.EnableSsl = true;