AicaDocsApi Download - AicaDocsApi Source code download

AicaDocsApi

Other categories

1.0.0

Download

Aicadocsapi

PROJECT OF COMPUTER ENGINEERING I PROJECT.

A system for the control of the documentation for the quality management system of the company Pharmaceutical Laboratories of AICA+was created.

An API minimal was created in Asp.net Core 8 complying with all the requisitions captured.

A database was created in PostgreSql robust with these requirements, and for the storage of the files minio was used

Problem

In AICA laboratories, you want to keep control of the company's quality management system documentation. This documentation is organized according to a scope, which can be a rector (apply throughout the company) or specific (apply in an EUB); a process, which corresponds to one of the processes defined on the map of organization processes; and a type of document, which is defined by the specialists of the quality area. The code, title, editing, pages, validity date and two associated files, one in PDF format and another in Word is known. It is desired to create a system that allows the creation and visualization of this documentation. To do this, the following requirements are defined:

Creation of documents
Documents search, with filters associated with each property property
Download documents, where it is specified that file is desired to download (PDF or Word) and a reason for download

? ️ Physical model of the database

Physical model

? Connection configuration to the database

In order to configure the connection to the PostgreSQL database, follow the following steps:

Create/Update on the Root Route of the project an appsettings.json file
In this file, place the following lines, replacing INFO with the corresponding information in each case:

 }
    (...),
    "ConnectionStrings" : {
        "PostgreSQLConnection" : " Server=INFO;Port=INFO;Database=INFO;User Id=INFO;password=INFO "
    }
}

If you do not have the AICA database, write the following command: dotnet ef database update . Make sure you have the Migrations , if you do not execute the command before: dotnet ef migrations add InitialCreate

? Minio connection configuration

IMPORTANT

MinIO Server must be installed and the necessary user with writing permit and the bucket in which the data will be stored with the folder structure /pdf and /word configured.

In order to configure the minio connection, follow the following steps:

Create/Update on the Root Route of the project an appsettings.json file
In this file, place the following lines, replacing INFO with the corresponding information in each case:

 }
    (...),
    "Minio" : {
       "Endpoint" : " INFO " ,
       "AccessKey" : " INFO " ,
       "SecretKey" : " INFO " ,
       "Bucket" : " INFO "
    }
}

Another possible way to test the API is using the minio cloud test server, using the following data in the appsettings.json file: Json:

 }
    (...),
    "Minio" : {
       "Endpoint" : " play.min.io " ,
       "AccessKey" : " testuser " ,
       "SecretKey" : " testuser " ,
       "Bucket" : " aica-docs "
    }
}