From Clomosy Docs

(Created page with "In Clomosy programming, classes are the fundamental building blocks of object-oriented programming. A class is a structure that encompasses data and behaviors, forming the basis for creating objects. Clomosy's class-based structure enhances the organization, clarity, and manageability of code. The properties of the Clomosy class gather data and behaviors together, enabling the design of complex projects in a more comprehensible manner. = General Features = {| class="w...")
 
No edit summary
Line 40: Line 40:


[[Clomosy_Scripts|Review example]].
[[Clomosy_Scripts|Review example]].
= SQL Servers Feature =
{| class="wikitable"
! Feature !! Use of !!Definition 
|-
|Function DBSQLServerConnect(ProviderName, Server, UserName, UserPassword, Database:String; Port:Integer=1433):Boolean;||Clomosy.DBSQLServerConnect('SQL Server', Server, Kull, Sifre, DB, 1433);||It is a component used to connect Clomosy applications with SQL Server.
|-
|Function DBSQLServerQueryWith(SQLStr:String):TUniQuery; ||Clomosy.DBSQLServerQueryWith('SELECT * FROM TBLSTOK'); ||Sql Server database query is made and data is accessed.
|}
= Local Database Feature =
{| class="wikitable"
! Feature !! Use of !!Definition 
|-
|Function DBSQLiteConnect(Database, UPassword:String):Boolean;||Clomosy.DBSQLiteConnect(DB, Sifre); ||It is a component used to connect Clomosy applications with SQLite.
|-
|Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery;||Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); ||Sqlite database query is made and data is accessed.
|}

Revision as of 15:11, 17 August 2023

In Clomosy programming, classes are the fundamental building blocks of object-oriented programming. A class is a structure that encompasses data and behaviors, forming the basis for creating objects. Clomosy's class-based structure enhances the organization, clarity, and manageability of code.

The properties of the Clomosy class gather data and behaviors together, enabling the design of complex projects in a more comprehensible manner.

General Features

Feature Use of Definition
Firm_GUID: String; Clomosy.Firm_GUID; The GUID of the company where the user is located is provided. Educational accounts do not have a company GUID. For this reason, it returns "CLOSTARTER."
Clomosy.Project_GUID: String; Clomosy.Project_GUID; The GUID of the project entered by the user is provided.
Procedure RunUnit(AUnitName:String); Clomosy.RunUnit('MyUnit1'); When you want to invoke a simple unit in Clomosy, you can use the "RunUnit" property.
Function GetProjectUserDefParam(xParamName:String):TClJSonQuery; Clomosy.GetProjectUserDefParam('harfCombo').FieldByName('Value_Integer').AsInteger; You can get the values ​​of the variable created in the param template. Not available for free membership.
Function RunOpenForm(OpenFormParams:TOpenFormParams):Integer; Clomosy.RunOpenForm(Clomosy.OpenFormParams); It was created to enable the execution of the created custom form. Review example.
Function OpenForm(FormName:TFormTemplate; OpenStyle:TFormDisplayType; Recording:TFormRecordOption; FilterOption:TFormFilterOption):Integer; Clomosy.OpenForm(ftItems,fdtSingle,froAddNew,ffoNoFilter); Used to open custom form.
Procedure AskAndCall(xAskStr:WideString; CallYesProc, CallNoProc:String); Clomosy.AskAndCall('Are You Cola','ProcYes','ProcNo'); It returns a check box. Operations can be made according to the yes or no option.
Function Ask(AskStr:String):Boolean; Clomosy.Ask('Are You Cola?') It is the parameter required to write the question in the confirmation box.
Function ClomosyID:Integer; Clomosy.ClomosyID; If the return value is 0, it is known that you are in Clomosy CRM, and if it is 1, you are in the Clomosy Learn application.

Send Message/Mail/Notify Feature

Feature Use of Definition
Function SendNotification(TitleStr, BodyStr, UserGUID :String):Boolean; Clomosy.SendNotification(notifTitleEdt.Text, notifTextEdt.Text, notifSendToEdt.Text); Used to send notifications to all users in the project.
Function SendNotifyAllUsers(TitleStr, BodyStr, WithoutUsers :String):Boolean; Clomosy.SendNotifyAllUsers(TitleEdt.Text, TextEdt.Text, SendToEdt.Text); If there is a user in the project that is not wanted to be notified, by selecting that user, notifications are sent to others.
Function SendMailNoReplay(TitleStr, BodyStr, UserGUID :String):Boolean; Clomosy.SendMailNoReplay('Title:Information',ztStr,'[email protected]'); It is used to send a message to the desired e-mail address.

Review example.

SQL Servers Feature

Feature Use of Definition
Function DBSQLServerConnect(ProviderName, Server, UserName, UserPassword, Database:String; Port:Integer=1433):Boolean; Clomosy.DBSQLServerConnect('SQL Server', Server, Kull, Sifre, DB, 1433); It is a component used to connect Clomosy applications with SQL Server.
Function DBSQLServerQueryWith(SQLStr:String):TUniQuery; Clomosy.DBSQLServerQueryWith('SELECT * FROM TBLSTOK'); Sql Server database query is made and data is accessed.

Local Database Feature

Feature Use of Definition
Function DBSQLiteConnect(Database, UPassword:String):Boolean; Clomosy.DBSQLiteConnect(DB, Sifre); It is a component used to connect Clomosy applications with SQLite.
Function DBSQLiteQueryWith(SQLStr:String):TClSQLiteQuery; Clomosy.DBSQLiteQueryWith('SELECT * FROM TBLSTOK'); Sqlite database query is made and data is accessed.