yalinerkaya / insuranceapi

The Insurance API Project is a streamlined and efficient solution designed to handle the management and querying of insured clients in an insurance office or company. It provides essential functionalities for seamless administration of insured client data and comfortable ways to import and export data.

The previous commits releated to the API are here

API's credentials

username:tiki
password:admin

API overall explanation

The API has 5 controllers:

• The Insured controller
• The Company controller
• The Authentication controller
• The File controller
• The Producer controller

Unless the Authentication controller, the rest of them require a Bearer Token authentication to be accesed. The function of each one is nested to its name, and you can see and test each endpoint from them using accessing the SwaggerUI url: <host>:<port>/swagger/index.html.

Run guide

API with DotNet desktop & database with Docker

1. go to the InsuranceDB directory
2. build the container: docker build -t database:test .
3. run the container: docker run -p 1433:1433 --name insurance-db -d database:test
4. go to the InsuranceAPI directory and run install the needed dependencies: dotnet restore
5. run the project: dotnet run

the hole API in Docker with Docker-Compose, incluiding the database

1. go to the main directory
2. run the app: docker-compose up

Structure of the Excel file to parse

LICENSE	COMPANY	FOLDER	LIFE	CLIENT	BORN	ADDRESS	STATE	VTO	CITY	DNI	PHONES1 description	DESCRIPTION	CUIT	PRODUCER
string	string2	number	dd/mm-dd/mm	lastnames firstname !(string)3	dd/mm/yyyy	street number !P4 number !DTO5 number	ACTIVA or ANULADA or EN JUICIO	number	string	!DNI number or LE number	number or number !(string)6	string	string	string7

Footnotes

1. if there are more than one phone for an insured, they have to be separated by '/'. ↩

2. an abbreviation of the company's name. in the case, could be 'COOP' or 'FEDPAT'. ↩

3. the string between braces is the insured policy ↩

4. indicates the floor ↩

5. indicates the departament ↩

6. the string between braces is the description of the number phone ↩

7. this string contains the producer's name, and it needs to match with one of the corresponding producers stored in the database. The italized text means that that property is optional The parts where ! appears means that the parser expect literally that/those character/s. ↩