okay I'm too lazy to write all queries by hand

will rewrite DAL to use EntityFramework (and use Dapper on slow
queries...)
and use standart MVC Auth framework