smarenich

using System;
using PX.Objects;
using PX.Data;

namespace PX.Data
{
  public class LEPMaint_Extension : PXGraphExtension<LEPMaint>
  {
    #region Event Handlers
    public PXAction<PX.Data.ListEntryPoint> ToggleActivation;

smarenich

using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using System.Text;
using System.Linq;
using PX.Data;
using PX.Common;
using PX.Objects.AP.BQL;
using PX.Objects.CM;

smarenich

public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry>
{
  #region Event Handlers
  public PXAction<PX.Objects.SO.SOOrder> CreateReceipt;

  [PXButton(CommitChanges = true)]
  [PXUIField(DisplayName = "Create IN Receipt")]
  protected void createReceipt()
  {
   INReceiptEntry graph = PXGraph.CreateInstance<INReceiptEntry>();

smarenich

using System;
using PX.Data;

namespace Test
{
  public class TwoGrids : PXGraph<TwoGrids, TwoGrids.MasterTable>
  {
    public PXFilter<MasterTable> MasterView;
    
    public PXFilter<DetailsTableA> DetailsViewA;

smarenich

<?xml version="1.0" encoding="utf-8"?>  
<CodeSnippets  
    xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">  
    <CodeSnippet Format="1.0.0">
	     <Header>  
			<Title>DAC Field Template</Title>  
			<Author>Acumatica</Author>  
			<Description>Acumatica DAC Field Placeholder</Description>
			<Shortcut>dac</Shortcut>  
		</Header>

smarenich

if exists(select * from sys.triggers where parent_id = object_id('Users') and name = 'SuncUserPassword')
Drop trigger dbo.SuncUserPassword
GO

Create trigger dbo.SuncUserPassword on dbo.Users for Update as
Begin
    declare @companyID int
    select @companyID = CompanyID from inserted

    Update u Set Password = i.Password from [dbo].[Users] u

smarenich

public class DACExt : PXCacheExtension<DAC>
{
	#region UsrField
	[PXDBInt]
	[PXUIField(DisplayName = "My Field")]
	[MultiCompanyList(new Object[]
		{
			new Object[] { 2,  				//Company with ID 2
				new int[] { 1, 2, 3 },			//Values for Company 2
				new string[] { "1", "2", "3" } },	//Labels for Company 2

smarenich

using System;
using PX.Data;

namespace PX.Objects.CM
{    
	[Serializable]
	public class cv_Rates : IBqlTable
	{
		#region TenantID
		[PXDBInt(IsKey = true)]

smarenich

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<data-set>
  <relations format-version="3" relations-version="20160530" main-table="GIDesign">
    <link from="GIFilter (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIGroupBy (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIMassAction (DesignID)" to="GIDesign (DesignID)" />
    <link from="GIMassUpdateField (DesignID)" to="GIDesign (DesignID)" />
    <link from="GINavigationScreen (DesignID)" to="GIDesign (DesignID)" />
    <link from="GINavigationParameter (DesignID, ScreenID)" to="GINavigationScreen (DesignID, ScreenID)" />
    <link from="GIOn (DesignID, RelationNbr)" to="GIRelation (DesignID, LineNbr)" />

smarenich

if exists(select * from sys.objects where object_id = object_id('dbo.pp_CopyDashboard') and objectproperty(object_id,'IsProcedure')=1)
drop proc dbo.pp_CopyDashboard
go
create procedure dbo.pp_CopyDashboard @companyID int, @dashboardID int AS
BEGIN
    DECLARE @id int
    DECLARE @ids table([id] int)

    Insert Into Dashboard ([CompanyID], [Name], [DefaultOwnerRole], [ScreenID], [AllowCopy], [Workspace1Size], [Workspace2Size], [IsPortal], [CreatedByID], [CreatedByScreenID], [CreatedDateTime], [LastModifiedByID], [LastModifiedByScreenID], [LastModifiedDateTime])
	   OUTPUT inserted.DashboardID INTO @ids