public HttpResponseMessage VerifyPhone(VerifyPhoneAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }

            string userId = _userService.GetCurrentUserId();

            ItemResponse<bool> response = new ItemResponse<bool>();

            response.Item = _userService.VerifyCode(model, userId);

            return Request.CreateResponse(response);
        }
        public bool VerifyCode(VerifyPhoneAddRequest model, string userId)
        {
            bool verified = false;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.AspNetUsers_VerifyPhoneCode"
               , inputParamMapper: delegate (SqlParameterCollection paramCollection)
               {
                   paramCollection.AddWithValue("@Id", userId);
                   paramCollection.AddWithValue("@Code", model.VerificationCode);

                   SqlParameter p = new SqlParameter("@Verified", System.Data.SqlDbType.Bit);
                   p.Direction = System.Data.ParameterDirection.Output;

                   paramCollection.Add(p);
               }

               , returnParameters: delegate (SqlParameterCollection param)
               {
                   bool.TryParse(param["@Verified"].Value.ToString(), out verified);
               }
               );

            return verified;
        }