Webapi

mostly jshint applications, some sql changes