patrick711

public class SPS_OrderToCashSetup : CustomizationPlugin
{
	//This method executed right after website files were updated, but before website was restarted
	//Method invoked on each cluster node in cluster environment
	//Method invoked only if runtimecompilation is enabled
	//Do not access custom code published to bin folder, it may not be loaded yet
	public override void OnPublished()
	{
		this.WriteLog("OnPublished Event");
	}

patrick711

        #region Constructor
        public ISPSOut846SendProcess()
        {
            Customers.SetProcessAllCaption("Send All");
            Customers.SetProcessCaption("Send");
            Customers.SetProcessDelegate(SendData);
            ISPSCustomerSettings settings = CustomerSettings.Current;
            if (!(settings.OutboundInventoryAdviceEnabled ?? false))
            {
                throw new PXSetupNotEnteredException(ISPSMessages.FeatureNotEnbabled, typeof(ISPSCustomerSettings), "Outbound 846");

patrick711

try
  {
      new_package = Packages.Insert(new_package);
  }
catch (Exception ex)
  {
      PXProcessing<SOShipment>.SetError(RowIndex, ex.Message));
      return false;
  }
//Uh-oh

patrick711

/***************************
Check_Field_Lengths_InsertUpdate - Check incoming data for excessive string lengths and then insert/update.  
Inputs
myCache - Data View Cache
mylist - List of DAC objects that corresponds to the myCache

Patrick Chen SPS Commerce
02-2022
***************************/

patrick711

        public void Test2()
        {
            //Method I
            foreach (var cust in PXSelect<BAccount, Where<ISPSCustomerExtension.iSPSEDICust, Equal<True>>>.Select(this))
            {
                foreach (BAccount child in
                    PXSelect<BAccount, Where<BAccount.parentBAccountID, Equal<Required<BAccount.parentBAccountID>>>>
                        .Select(this, mycustomer.BAccountID))
                {
                }

patrick711

        public void Test()
        {
            //Method I
            var soLineSplitsLinkedWithCurrentPO =
                SelectFrom<SOLineSplit>
                    .Where<SOLineSplit.pOType.IsEqual<@P.AsString.ASCII>.And<SOLineSplit.pONbr.IsEqual<@P.AsString>>>
                    .AggregateTo<GroupBy<SOLineSplit.orderType>, GroupBy<SOLineSplit.orderNbr>>
                    .View.Select(this, row.OrderType, row.OrderNbr);
            foreach (var item in soLineSplitsLinkedWithCurrentPO)
            { }

patrick711

/***************************
DatabaseOperations - Code for communicating with MS Sql Server in order to perform a restore from backup.

Patrick Chen SPS Commerce
08-2020
***************************/

namespace TestAcumatica
{
    class DatabaseOperations

patrick711

    [Serializable]
    [PXCacheName("Warehouse Trading Partner")]
    [PXTable(typeof(INSite.siteID), IsOptional = true)]
    public class ISPSMapadocINSiteExtension : PXCacheExtension<INSite>
    {
        #region Siteid
        [PXDBInt(IsKey = true)]
        [PXUIField(DisplayName = "Siteid")]
        public virtual int? Siteid { get; set; }
        public abstract class siteid : PX.Data.BQL.BqlInt.Field<siteid> { }

patrick711

/***************************
Mod_RestoreDB - This class encapsulates the process of restoring Acumatica instance to clean state
1. Unpublish customizations to remove Web elements
2. Restore db backup
3. Log into the site
Patrick Chen SPS Commerce
04-2020
***************************/

namespace TestAcumatica

patrick711

/***************************
Mod_SetupVars - Codebase that will tale config inputs and create variable object
Patrick Chen SPS Commerce
04-2020
***************************/


namespace TestAcumatica
{
    public class Mod_SetupVars