Implement a service to upload transaction data from files of various formats into database and query transactions by specified criteria. Use best practices and design patterns, skills in design/architecture, ability to build testable and maintainable software.

You have two possible formats of input files: csv and xml based. All values are mandatory so if one missing then record is invalid. If any record is invalid whole file is treated as invalid and should not be imported. However you should be able to identify all records that was invalid and collect it in some log.

Example:

“Invoice0000001”,”1,000.00”, “USD”, “20/02/2019 12:33:16”, “Approved”
“Invoice0000002”,”300.00”,”USD”,”21/02/2019 02:04:59”, “Failed”

Example:

<Transactions>
    <Transaction id=”Inv00001”>
        <TransactionDate>2019-01-23T13:45:10</TransactionDate>
        <PaymentDetails>
            <Amount>200.00</Amount>
            <CurrencyCode>USD</CurrencyCode>
        </PaymentDetails>
        <Status>Done</Status>
    </Transaction>
    <Transaction id=”Inv00002”>
        <TransactionDate>2019-01-24T16:09:15</TransactionDate>
        <PaymentDetails>
            <Amount>10000.00</Amount>
            <CurrencyCode>EUR</CurrencyCode>
        </PaymentDetails>
        <Status>Rejected</Status>
    </Transaction>
</Transactions>

Create Web application with ability to:

1. Upload file. Create a web-page with standard file uploader. Must support both formats csv and xml. File size is max 1 MB. Save data into database. Feel free to design database structure that is suitable for this.

• If file is in unknown format then return error message “Unknown format”.
• If file didn’t pass validation return Bad Request with all validation messages.
• If everything is okay then return HTTP Code 200.

2. Get all transactions. Create API methods:

• by Currency
• by date range
• by status

Transaction should display these values:

• Id
• Payment = Amount + CurrencyCode
• Status in unified format (see table below)

Transaction status mappings:

Example of output:

[{ "id":"Inv00001", "payment":"200.00 USD", "Status": "D"},
 { "id":"Inv00002", "payment":"10000.00 EUR", "Status": "R"},
 { "id":"Invoice0000001", "payment":"1000.00 USD", "Status": "A"},
 { "id":"Invoice0000002", "payment":"300.00 USD", "Status": "R"}]

# Go into the folder with solution and run:
docker-compose up

Service will be available on port 8888.

When docker runs open http://localhost:8888/api/docs on your browser to see swagger docs and try api.