Beispiel #1
0
        public HttpResponseMessage CreateUser(UserModel user)
        {
            if (user.Name == null || user.Email == null)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest, "User could not be created, missing name and/or email.");
            }

            // Set unique user id
            user.Id = DatabaseInteractor.GetHighestUserId() + 1;

            DatabaseInteractionResponse result = DatabaseInteractor.CreateUser(user);

            if (result.Success)
            {
                return Request.CreateResponse(HttpStatusCode.OK, user);
            }

            return Request.CreateResponse(HttpStatusCode.BadRequest, "User could not be created. The following error occurred: " + result.Message);
        }
        public static DatabaseInteractionResponse CreateUser(UserModel userModel)
        {
            // Check if userId is currently being used
            if (GetUserById(userModel.Id) != null)
            {
                return new DatabaseInteractionResponse() { Success = false, Message = "There already exists a user with the id: " + userModel.Id };
            }

            List<SqlParameter> parameters = new List<SqlParameter>
            {
                new SqlParameter("@userId", userModel.Id),
                new SqlParameter("@name", userModel.Name),
                new SqlParameter("@email", userModel.Email),
                new SqlParameter("@location", userModel.Location.ToString())
            };

            return ExecuteSqlNonQuery("CreateUser", parameters);
        }