smarenich

	public class FeatureEnabledBoolAttribute : PXDBBoolAttribute
	{
		protected Type RecordType;

		public BCFeatureEnabledBoolAttribute(Type recordType)
		{
			RecordType = recordType;
		}
		public override void CommandPreparing(PXCache sender, PXCommandPreparingEventArgs e)
		{

smarenich

	#region Filter
	[Serializable]
	public class YearFilter : IBqlTable
	{
		#region Year
		public abstract class year : PX.Data.IBqlField { }
		[PXDBInt()]
		[PXDefault(2014)]
		[PXUIField(DisplayName = "Year")]
		[PXIntList(new Int32[] { 2013, 2014, 2015}, new String[] { "2013", "2014", "2015"})]

smarenich

public class SOOrderEntry_Extension:PXGraphExtension<SOOrderEntry>
{
    //Lets define additional button than will call automation button.
    public PXAction<SOOrder> ButtonExample;
    
    [PXButton()]
    [PXUIField(DisplayName = "Button Example")]
    public virtual IEnumerable buttonExample(PXAdapter adapter)
    {
        SOOrder order = Base.Document.Current;

smarenich

using PX.Data;
using PX.Objects;
using PX.Common;
using PX.Objects.GL;
using PX.Objects.CM;
using PX.Objects.CS;
using PX.Objects.TX;
using PX.Objects.CR;
using PX.Objects.CA;

smarenich

using System;
using PX.Data;
using PX.Objects.CM;
using PX.Objects.CS;
using PX.Objects.IN;
using PX.Objects.TX;

namespace PX.Objects.AR
{
  public class ARTaxExtensionAttribute : ARTaxAttribute

smarenich

--Specific customer data like email info, credit cards info, etc.
update PreferencesSecurity set PasswordMinLength = 3, PasswordComplexity = 0, PasswordSecurityType = 0
update users set password = '123', PasswordChangeOnNextLogin =0, PasswordNeverExpires = 1 where source = 0
delete from userfilter
Update EMailAccount set Password = '123'
UPDATE AUSchedule SET IsActive = 0
update CustomerPaymentMethodDetail set value = '' where detailid in ('CCDNUM', 'ADDLN1', 'ADDLN2', 'NAMEONCC', 'CVV')
update ccproctran set PCResponse = ''
update CCProcessingCenterDetail set Value = '1111' where DetailID='LOGINID' or DetailID = 'TRANKEY'
UPDATE TXAvalaraSetup SET Account = NULL, Licence = NULL WHERE CompanyID > 0

smarenich

IF OBJECT_ID ('dbo.[px_Rates]', 'V') IS NOT NULL 
    DROP VIEW [dbo].[px_Rates]
GO

CREATE VIEW [dbo].[px_Rates] AS
select FromCury.CompanyID as CompanyID, FromCury.CuryID as FromCuryID, ToCury.CuryID as ToCuryID, Date as CuryEffDate, 
    Coalesce((Select top 1 CuryRateID
		  from CurrencyRate r
		  where r.CuryEffDate <= Date and r.CompanyID = FromCury.CompanyID and r.FromCuryID = FromCury.CuryID and r.ToCuryID = ToCury.CuryID
		  order by CuryEffDate), 0) as RateID

smarenich

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<data-set>
  <relations format-version="3" relations-version="20180809" main-table="GIDesign" stable-sharing="True" file-name="(Name)">
    <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

	public class SOARDocTypesListAttribute : PXStringListAttribute, IPXRowSelectedSubscriber
	{
		public Type _Module;
		public class OrderTypesDefinition : IPrefetchable
		{
			public Dictionary<String, String> list = new Dictionary<String, String>();

			public void Prefetch()
			{
				list.Clear();

smarenich

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using PX.Data;
using System.Text;
using System.Xml;
using System.IO;
using PX.Data.SQLTree;