public AuthenticationLogon GetLogonByCredentials(string username, string password) { var dbConnection = DbConnectionService.GetDbConnection(); var user = dbConnection.Query <AuthenticationLogon>( "SELECT * FROM [User] WHERE Username = @Username AND Password = @Password", new { Username = username, Password = password }).SingleOrDefault(); return(user); }
public void LogMessage(string message) { var dbConnection = DbConnectionService.GetDbConnection(); // Voeg hier code toe die de IDbConnection nodig heeft }
public UserService(IDbConnectionService conn, IMapper mapper) { Mapper = mapper; Db = conn.GetDbConnection(); }
public CategoryService(IDbConnectionService conn, IMapper mapper) { Db = conn.GetDbConnection(); Mapper = mapper; }