public IHttpActionResult Registration([FromBody] UserAccount userAccount) { using (IDbConnection connection = base.ConnectionProvider.GetMySqlConnection()) { if (string.IsNullOrEmpty(userAccount.FirstName) || string.IsNullOrEmpty(userAccount.LastName) || string.IsNullOrEmpty(userAccount.UserName) || string.IsNullOrEmpty(userAccount.Password)) { return(BadRequest("Firstname, lastname, username and password must be set.")); } long userAccountCount = service.CountUserAccountByUsername(connection, userAccount.UserName); if (userAccountCount > 0) { return(BadRequest("Username does already exist.")); } service.Insert(connection, userAccount.FirstName, userAccount.LastName, userAccount.UserName, userAccount.Password, userAccount.StatusMessage, userAccount.UserIcon, UserAccountStatus.Active); UserAccount loadedUserAccount = service.GetUserAccountByUsernameAndPassword(connection, userAccount.UserName, userAccount.Password); return(Ok(loadedUserAccount)); } }