New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Pull all existing vehicles with inactive ones #2

Open

ibrahimhuycn opened this issue Apr 25, 2020 · 1 comment

Labels

bug enhancement

Owner

ibrahimhuycn commented Apr 25, 2020

The application currently pulls all vehicles on the database even the one not actively delivering stuff.

ibrahimhuycn added bug enhancement labels

Owner Author

ibrahimhuycn commented Apr 25, 2020

The feature was not designed into the application. Steps to solve the issue

Database modification

Add a boolean IsActive field to the table, Vehicle Location. 1 = true and 0 = false
Modify the query fetching all records to fetch records with the condition IsActive = 1
Add a stored procedure to modify the status.

API

Add a post endpoint which accepts a class with the vehicle unique name and active status for the purpose of modification of the database IsActive status on the table Vehicle location.
A model is required {string UniqueVehicleName; bool IsActive; }
Add necessary code.

Application

The same model as API and some code for the API call

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment