This application is designed to process job data from an input file, compute necessary formulas, and save the results to an output file. Here's a step-by-step explanation of how it works:

1. Handle CLI Arguments: The application begins by handling command-line interface (CLI) arguments to determine the input and output file paths.

2. Read Input File: It reads job data from the specified input file using a helper function that deserializes the JSON content into a class object. If reading the file fails, an error message is displayed, and the application exits with an error code.

3. Parse Jobs: The raw job data is parsed into a list of job objects that the application can work with.

4. Evaluate Formulas: Evaluate formulas, such as "A1 + B2" to include the referenced values, like "5 + 6" using recursion.

5. Compute Formulas: The application processes the string formulas "5 + 6" to compute a single value: "11".

6. Prepare Output Structure: A post request structure is created to format the computed job data appropriately for the output file.

7. Save Output File: The computed and formatted job data is serialized back into JSON and saved to the specified output file. If saving the file fails, an error message is displayed, and the application exits with an error code.

8. Completion: Upon successful completion, a success message is displayed, and the application exits with a success code.

• C#
• .NET 8
• Console
• Moq
• Fluent Assertions
• and other NUGET packages

• Features Domain-Driven design (DDD) architecture.
• The project has exit codes, console logs to inform the user about the program's state.
• Exception handling, displaying errors to the user.
• Using 3rd party libraries to ease our work: to help with json parsing, DI, unit testing and more.
• Application settings. You can set hard-coded values inside appsettings.json.
• We also have different class models (DTOs) for different HTTP GET and POST requests.
• For the testing part, we use xUnit, mocking, fluent assertions and more.
• We use AAA (Act-Arrange-Assert) structure for our tests.

You can find both input and expected output files in the data folder.

Input example:

{
  "jobs": [
    {
      "id": "job-3",
      "data": [
        [
          { "value": { "number": 6 } },
          { "value": { "number": 4 } },
          {
            "formula": {
              "sum": [
                { "reference": "A1" },
                { "reference": "B1" }
              ]
            }
          }
        ]
      ]
    },
    {
      "id": "job-4",
      "data": [
        [
          { "value": { "number": 6 } },
          { "value": { "number": 4 } },
          { "value": { "number": 7 } },
          {
            "formula": {
              "multiply": [
                { "reference": "A1" },
                { "reference": "B1" },
                { "reference": "C1" }
              ]
            }
          }
        ]
      ]
    },
  ]
}

Output example:

{
  "email": "gintautas",
  "results": [
    {
      "id": "job-3",
      "data": [
        [
          {
            "value": {
              "number": 6.0
            }
          },
          {
            "value": {
              "number": 4.0
            }
          },
          {
            "value": {
              "number": 10.0
            }
          }
        ]
      ]
    },
    {
      "id": "job-4",
      "data": [
        [
          {
            "value": {
              "number": 6.0
            }
          },
          {
            "value": {
              "number": 4.0
            }
          },
          {
            "value": {
              "number": 7.0
            }
          },
          {
            "value": {
              "number": 168.0
            }
          }
        ]
      ]
    }
  ]
}

1. Have Microsoft .NET 8 SDK installed.
2. Open CMD.
3. cd src\SpreadsheetEvaluator.Application
4. Run the console app:

   dotnet run -i "path to the InputJobs.json" -o "path to the output file.json"

Successfully running the console app with arguments.

Argument validation present when a required argument is not present.

The video demo

This project is licensed under the MIT license. Feel free to edit and distribute this template as you like.

See LICENSE for more information.