Tezislər / Theses

THE 3
rd
 INTERNATIONAL SCIENTIFIC CONFERENCES OF STUDENTS AND YOUNG RESEARCHERS 
dedicated to the 99
th
anniversary of the National Leader of Azerbaijan Heydar Aliyev
230
approach. In further improvements, web based, and mobile version of the 
application can also be developed. Additionally, more sophisticated protections 
can be built in desktop application in terms of security issues. [1]. The main 
programming language which is going to be used is C#. C# provides us with 
unusual flexibility and breadth, representing the seventh major update to 
Microsoft’s flagship programming language. It offers us higher level abstractions 
including asynchronous continuations and query expressions. In terms of IDE, 
Visual Studio 2022 will be used for the machines working on Windows 
Operating System. But in future, Jetbrains can be used to develop the cross-
platform application for macOS, Linux and other operating systems. [2] 
To build the front end of application, WPF will be used for Windows 
platforms. Microsoft Windows Presentation Foundation is an UI (User 
Interface) framework which is a part of MS dot Net family. In early days, 
developers mainly used Windows Forms, which has a lot of pros, as well as 
cons. However, WPF is superior to the Window Forms if you want to build a 
standalone, browser-hosted, client applications. The application in question 
will include a lot of media types which is a deal-breaker to use the WPF 
instead of Windows forms. For the database, Microsoft SQL will be used. 
Microsoft SQL is one of the relational database systems (also known as 
RDBMS) which supports variety of intelligent business processes, 
processing of transactions, and data analytics in huge companies, banks, IT 
companies. There are 3 leader technologies in database management 
systems and MSSQL is one of them while Oracle DB and DB2 which is 
developed by IBM comes second and third. 
In SQL servers, there is a row-based table structure which connects 
related elements in different tables with each other. By doing so, it also 
avoids redundantly copying data in multiple places within the database to 
increase the optimization of the system. SQL Server Database Engine is the 
main component of MSSQL Server which includes relational engine to 
control processing, storing and security of data. Database engine executes 
and creates database objects, triggers views while a stored engine is used 
to manage buffers, indexes, and transactions. [3]
While developing a desktop application, there are a few design patterns 
that should be followed in order to build optimized, proper application. One 
of them is MVVM called Model-View-View-Model design pattern which is 
consists of 3 groups, namely Models, Views and View models. Models are 
basically classes or structs that holds application data, while the Views are 
elements controlling the view and screens. View models are simply classes 
which helps to transform the model into a suitable form to display it on the 
screen and they are passed around as a reference. MVVM makes it possible 
for developers to work on the code while the designers work on the UI at the 
same time without interrupting each other by separating the visual section of 
the app from the related code. 

---