Calculate fines for categories in stored procedure

Viewed 9

if the fines will be for Book

every day will be 1 Kč

if the fines will be for CD

every day will be 1Kč

if the fines will be for Games

every day will be 10 Kč

fine is automatically calculated when API is called and list of borrowed products is returned.

Fine value will be defined in appsettings per product type.

e.g.

I have 1 book, which has to be returned on Aug 10th, today is Aug 18th, API will return that fine = 8 (1 Kč per day)

0 Answers
Related