How to do authorization in angular 4?

Question

C++ / C#

Tell me, please, how to make reliable and convenient authorization in MEAN?
I have watched different videos and read articles but everything seems very confusing or outdated articles.
If possible, explain as for a beginner in this matter.
I would be very grateful for your suggestions!

Answer 1

If the table structure is correct, then probably like this:

SELECT sm.Model, sm.Tip, dg.Data_Zakluchenija
FROM Dogovor AS dg
JOIN Zakaz AS zk ON dg.id_zakaz = zk.id_zakaz 
JOIN Prais_List AS pr ON pr.id_prise_list = zk.id_prise_list 
JOIN Stir_Mashina AS sm ON sm.id_stir_mashina= pr.id_stir_mashina

Answer 2

As an option like this. Don't like this option?