Component installation and communication

Applications communicate with the database through the IIS web service on a port to be defined, for example, ports 8080 or 8081.

The web service of each of the applications communicates with its respective database through the classes of data access. The connection string for the database must be defined in the "web.config" file for each of the web services.

Open

Note: the figure shows a clear separation of layers: data, services, customer / front-end.

With this suggestion, it is only intended to demonstrate the possibility of separating all layers of the system, and it is also possible to install multiple layers on the same computer. Example: server with SQL Server and IIS.

Within the types of implementation demonstrated there are two typical possibilities, with their advantages and disadvantages.

2.1 Server - Client (Workstation)

The installation of the database and Web service is done on a computer (server) without the need for major technical requirements at the server level, as these are light and have little impact on other resources.

Installation of client applications (Windows Forms) on several computers: the workstation computer that will generate the schedules should have significant capacities, not only in terms of RAM, CPU, but also in terms of the quality of the workstation's connection to the server.

In the event of version updates, Bullet Solutions has access to the server or requires IT Services to conduct the update process (simply replace files and run scripts in the database).

Benefits:

1. Processing is spread over several computers (clients) and does not overload the server, so there is no need to allocate a server with large computing capacities.

2. Better user experience when software is controlled directly from a Windows application (instead of being used inside other windows - see point 2.2).

Disadvantages:

1. installation (1st time) on multiple computers; computers (client) need to have good processing power and high RAM for generating schedules;

2. Need for a good network connection from workstations to the server (both upload and download), since the amount of data that is transferred between client and server is considerable.

2.2 Multiple Remote Accesses via Windows Remote Desktop (RDP)

Install all layers on the same virtual server dedicated exclusively to this process. All users (and Bullet Solutions) have remote access to the application via RDP - Windows Remote Desktop (remote desktop), multiple instances are launched from the same application.

Minimum requirements: 8GB RAM.

Benefits:

1. Faster installation process (1st time); the entire system in a single dedicated computer; faster updates and no entropy;

2. There is no need to ensure a good network connection from the workstations to the server, since the exchange of data between application and database is done locally, on the server.

Disadvantages:

1. Computer overload with multiple clients and Microsoft “Terminal Services” license required so that multiple users can access the application simultaneously;

2. User experience / work via RDP may not be very comfortable from the user's point of view, since he is working in a window, inside a window, with no possibility of easily moving between the application and other applications on his computer (Excel, Internet, etc.). Probable need to use two monitors.