if ((new Select(UserConnection).Column(Func.Count("Id")).From("ActivityCorrespondence").Where("ActivityId").IsEqual(Column.Parameter(Entity.ActivityId)) as Select).ExecuteScalar<int>() > 0) {
//...
}

DateTime _today = DateTime.Today;
				DateTime _yesterday = DateTime.Today.AddDays(-1);
				var userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];
 
				var entityRowCount = (new Select(userConnection)
						.Column(Func.Count("Rate"))
						.From("CurrencyRate")
						.Where("StartDate").IsLessOrEqual(Column.Const(_today))
							.And("StartDate").IsGreaterOrEqual(Column.Const(_yesterday))
						as Select).ExecuteScalar<int>();
				if ( entityRowCount > 0) 
				{
					return "That date already exists!";
				} else {

define("СustomDetailScheme", [], function() {
	return {
		entitySchemaName: "CustomObject",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {}
	};
});

define("CustomObjectAddPage", [], function() {
	return {
		entitySchemaName: "CustomObject",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",
				"name": "SomeField4e5d48ba-e8d3-4e7f-936d-cbf296d05c99",
				"values": {
					"layout": {
						"colSpan": 24,
						"rowSpan": 1,
						"column": 0,
						"row": 0,
						"layoutName": "Header"
					},
					"bindTo": "SomeField"
				},
				"parentName": "Header",
				"propertyName": "items",
				"index": 0
			}
		]/**SCHEMA_DIFF*/,
		methods: {},
		rules: {}
	};
});

define("ContactPageV2", [],
	function() {
		return {
			entitySchemaName: "Contact",
			attributes: {},
			details: {
				"myCustomDetail": {
					"schemaName": "СustomDetailScheme",
					"filter": {
						"detailColumn": "Contact",
						"masterColumn": "Id"
					}
				}
			},
			diff: [
				{
					"operation": "insert",
					"name": "myCustomDetail",
					"values": {
						"itemType": 2,
						"markerValue": "added-detail",
						"visible": true
					},
					"parentName": "GeneralInfoTab",
					"propertyName": "items",
					"index": 3
				}
			],
			methods: {}
		};
	}
);

define("OrderSectionV2", ["OrderConfigurationConstants"],
    function (OrderConfigurationConstants) {
        return {
            // Название схемы раздела.
            entitySchemaName: "Order",
            // Коллекция методов модели представления раздела.
            methods: {
                // Переопределение базового метода, который модифицирует строку данных перед загрузкой в реестр.
                prepareResponseCollectionItem: function (item) {
                    this.callParent(arguments);
                    item.customStyle = null;
                    var running = item.get("Status");
                    //Если условие подходит, меняем цвет записи на темно-серый, а фон на светло-зеленый.
                    if (running.value === OrderConfigurationConstants.Order.OrderStatus.Running) {
                        item.customStyle = {
                            'color': "darkgrey",
                            'background': "#D8FBC2"
                        }
                    }
                }
            }
        };
    });

 define("UsrMyModalModule", ["ModalBox", "BaseSchemaModuleV2"],
        function(ModalBox) {
    Ext.define("Terrasoft.configuration.UsrMyModalModule", {
        extend: "Terrasoft.BaseSchemaModule",
        alternateClassName: "Terrasoft.UsrMyModalModule",
        /**
         * @inheritDoc Terrasoft.BaseSchemaModule#generateViewContainerId
         * @overridden
         */
        generateViewContainerId: false,
        /**
         * @inheritDoc Terrasoft.BaseSchemaModule#initSchemaName
         * @overridden
         */
        initSchemaName: function() {
            this.schemaName = "UsrMyModalPage";
        },
        /**
         * @inheritDoc Terrasoft.BaseSchemaModule#initHistoryState
         * @overridden
         */
        initHistoryState: Terrasoft.emptyFn,
    });
    return Terrasoft.UsrMyModalModule;
});

define("UsrMyModalPage", ["ModalBox"], function(ModalBox) {
    return {
        attributes: {
            "TestText": {
                dataValueType: Terrasoft.DataValueType.TEXT,
                type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN
            }
        },
        messages: {
            "DataFromModal": {
                mode: Terrasoft.MessageMode.PTP,
                direction: Terrasoft.MessageDirectionType.PUBLISH
            }
        },
        methods: {
            init: function(callback, scope) {
                this.callParent(arguments);
            },
            onRender: function() {
            },
            onCloseButtonClick: function() {
                this.sandbox.publish("DataFromModal", { test: this.get("TestText") }, [this.sandbox.id]);
                ModalBox.close();
            }
        },
        diff: [
            {
                "operation": "insert",
                "name": "MyContainer",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.CONTAINER,
                    "items": []
                }
            },
            {
                "operation": "insert",
                "parentName": "MyContainer",
                "propertyName": "items",
                "name": "MyGridContainer",
                "values": {
                    "itemType": Terrasoft.ViewItemType.GRID_LAYOUT,
                    "items": []
                }
            },
            {
                "operation": "insert",
                "parentName": "MyGridContainer",
                "propertyName": "items",
                "name": "TestText",
                "values": {
                    "bindTo": "TestText",
                    "caption": "Test text",
                    "layout": {"column": 0, "row": 0, "colSpan": 10}
                }
            },
            {
                "operation": "insert",
                "parentName": "MyGridContainer",
                "name": "CloseButton",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "style": Terrasoft.controls.ButtonEnums.style.BLUE,
                    "click": {bindTo: "onCloseButtonClick"},
                    "markerValue": "CloseButton",
                    "caption": "OK",
                    "layout": { "column": 0, "row": 1, "colSpan": 3 }
                }
            }
        ]
    };
});

define("ContactPageV2", ["ContactPageV2Resources", "GeneralDetails", "ModalBox"],
function(resources, GeneralDetails, ModalBox) {
    return {
        entitySchemaName: "Contact",
        messages: {
            "DataFromModal": {
                mode: Terrasoft.MessageMode.PTP,
                direction: Terrasoft.MessageDirectionType.SUBSCRIBE
            }
        },
        details: /**SCHEMA_DETAILS*/{
        }/**SCHEMA_DETAILS*/,
        methods: {
            subscribeSandboxEvents: function() {
                this.callParent(arguments);
                this.sandbox.subscribe("DataFromModal", function(arg) {
                    console.log("msg from modal: " + arg.test);
                }, this, [this.sandbox.id + "_" + "UsrMyModalModule"]);
            },
            loadMyModal: function() {
                var sandbox = this.sandbox;
                var config = {
                    heightPixels: 420,
                    widthPixels: 750
                };
                var moduleName = "UsrMyModalModule";
                var moduleId = sandbox.id + "_" + moduleName;
                var renderTo = ModalBox.show(config, function() {
                    sandbox.unloadModule(moduleId, renderTo);
                });
                sandbox.loadModule(moduleName, {
                    id: moduleId,
                    renderTo: renderTo
                });
            },
            onMyClick: function() {
                this.loadMyModal();
            },
            onEntityInitialized: function() {
                this.callParent(arguments);
            }
        },
        diff: /**SCHEMA_DIFF*/[
            {
                "operation": "insert",
                "parentName": "CombinedModeActionButtonsCardContainer",
                "propertyName": "items",
                "name": "MainContactButton",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "caption": "пыщь-пыщь",
                    "click": {"bindTo": "onMyClick"}
                }
            }
        ]/**SCHEMA_DIFF*/
    };
});

define("UsrMyModalPage", ["ModalBox"], function (ModalBox) {
    return {
        attributes: {
            "GridDataTest": { dataValueType: Terrasoft.DataValueType.COLLECTION },
        },
        messages: {
            "DataFromModal": {
                mode: Terrasoft.MessageMode.PTP,
                direction: Terrasoft.MessageDirectionType.PUBLISH
            }
        },
        methods: {
            init: function (callback, scope) {
                this.callParent(arguments);
 
                var esq = this.Ext.create("Terrasoft.EntitySchemaQuery", {
                    rootSchemaName: "UsrPLP"
                });
                esq.addColumn("Name");
                esq.addColumn("UsrPoints");
 
                esq.getEntityCollection(function (result) {
                    if (!result.success) {
                        this.showInformationDialog("Ошибка запроса данных");
                        return;
                    }
                    this.set("GridDataTest", result.collection);
                }, this);
            },
            onCloseButtonClick: function () {
                ModalBox.close();
            }
        },
        diff: [
            {
                "operation": "insert",
                "name": "MyContainer",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.CONTAINER,
                    "items": []
                }
            },
            {
                "operation": "insert",
                "parentName": "MyContainer",
                "propertyName": "items",
                "name": "MyGridContainer",
                "values": {
                    "itemType": Terrasoft.ViewItemType.GRID_LAYOUT,
                    "items": []
                }
            },
             {
                 "operation": "insert",
                 "name": "DataGrid",
                 "parentName": "MyContainer",
                 "propertyName": "items",
                 "values": {
                     "itemType": Terrasoft.ViewItemType.GRID,
                     "listedZebra": true,
                     "collection": { "bindTo": "GridDataTest" },
                 }
 
             },
            {
                "operation": "insert",
                "parentName": "MyGridContainer",
                "name": "CloseButton",
                "propertyName": "items",
                "values": {
                    "itemType": Terrasoft.ViewItemType.BUTTON,
                    "style": Terrasoft.controls.ButtonEnums.style.BLUE,
                    "click": { bindTo: "onCloseButtonClick" },
                    "markerValue": "CloseButton",
                    "caption": "Close",
                    "layout": { "column": 0, "row": 1, "colSpan": 3 }
                }
            }
        ]
    };
});

define("OrderPageV2", [], function() {
	return {
		entitySchemaName: "Order",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[
	{
		"operation": "insert",
		"name": "myEnum",
		"values": {
			"caption": "myEnum",
			"layout": {
				"colSpan": 12,
				"rowSpan": 1,
				"column": 0,
				"row": 2,
				"layoutName": "Header"
			},
			"controlConfig": {
				"className": "Terrasoft.ComboBoxEdit",
				"list": {
					"bindTo": "myList"
				},
				"change": {
					"bindTo": "onMyValueChange"
				},
				"prepareList": {
					"bindTo": "prepareMyList"
				}
			},
			"labelConfig": {},
			"enabled": true,
			"bindTo": "myEnum"
		},
		"parentName": "Header",
		"propertyName": "items",
		"index": 4
	}]/**SCHEMA_DIFF*/,
		methods: {
			onPageInitialized: function(callback, scope) {
				if (!this.get("myList")) {
					this.set("myList", this.Ext.create("Terrasoft.Collection"));
				}
				if (callback) {
					callback.call(scope || this);
				}
			},
			prepareMyList: function(filter, list) {
				if (list === null) {
					return;
				}
				list.clear();
				var columns = {};
				var value1 = {
					displayValue: "a123",
					value: "1"
				};
				var value2 = {
					displayValue: "b234",
					value: "2"
				};
				var value3 = {
					displayValue: "c345",
					value: "3"
				};
				columns[1] = value1;
				columns[2] = value2;
				columns[3] = value3;
				list.loadAll(columns);
			},
			 onMyValueChange: function(val) {
				if (val && val.displayValue) {
					console.log("you pick: ", val.displayValue);
				}
			}
		},
		attributes: {
			"myEnum": {
				"dataValueType": Terrasoft.DataValueType.ENUM,
				"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
				"caption": "myEnum"
			},
			"myList": {
				"dataValueType": Terrasoft.DataValueType.ENUM,
				"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
				"isCollection": true
			}
		},
		rules: {}
	};
});

getFilters: function() {
	//гора кода
	filters.add("NotEmailFilter", Terrasoft.createColumnFilterWithParameter(
		Terrasoft.ComparisonType.NOT_EQUAL, 
		"Type", 
		ConfigurationConstants.Activity.Type.Email));
	//...еще хуже
},

define("TmEmails1Section" /*вместо TmEmails1Section название схемы раздела*/, ["ConfigurationConstants"], function(ConfigurationConstants) {
	return {
		entitySchemaName: "Activity",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {
			getFilters: function() {
				var filters = this.callParent(arguments);
				filters.add("NotEmailFilter", this.Terrasoft.createColumnFilterWithParameter(
						this.Terrasoft.ComparisonType.EQUAL, "Type", ConfigurationConstants.Activity.Type.Email
					));
				return filters;
			}
		}
	};
});

define("TmEmails1Page" /*вместо TmEmails1Page название схемы страницы*/, [], function() {
	return {
		entitySchemaName: "Activity",
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
		methods: {},
		rules: {}
	};
});

diff: /**SCHEMA_DIFF*/ [
{
     "operation": "remove",
     "name": "Account"
}
] /**SCHEMA_DIFF*/

diff: /**SCHEMA_DIFF*/ [
{
    "operation": "merge",
     "name": "Account",
     "values": {
            "visible": false
      }
}
] /**SCHEMA_DIFF*/

this.isAddMode()/this.isCopyMode()/this.isEditMode()

this.isAddMode()/this.isCopyMode()/this.isEditMode()