public HttpResponseMessage Insert(PhoneAddRequest model) { try { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _phoneService.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int Insert(PhoneAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery("dbo.Phone_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@CountryCode", model.CountryCode); paramCollection.AddWithValue("@PhoneNumber", model.PhoneNumber); paramCollection.AddWithValue("@Extension", model.Extension); paramCollection.AddWithValue("@ModifiedBy", model.ModifiedBy); SqlParameter idParameter = new SqlParameter("@UserId", System.Data.SqlDbType.Int); idParameter.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(idParameter); }, returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@UserId"].Value.ToString(), out id); }); return(id); }
public void UpdatePhone(PhoneAddRequest model, string userId) { if (model.Phone != null) { model.Phone = ParsePhone(model.Phone); } DataProvider.ExecuteNonQuery(GetConnection, "dbo.AspNetUsers_UpdatePhoneNumber" , inputParamMapper: delegate (SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@PhoneNumber", model.Phone); paramCollection.AddWithValue("@Id", userId); } , returnParameters: delegate (SqlParameterCollection param) { } ); }
public int GeneratePhoneVerificationCodeText(PhoneAddRequest model, string userId, string currentPhone) { Random rnd = new Random(); int code = rnd.Next(1000, 10000); InsertCode(code, userId); //string toNumber = "+18186203478"; //delete when ready for production //string toNumber = "+19172946087"; //ramona's cell string toNumber = "+1" + model.Phone; //uncomment when ready for production var twilio = new TwilioRestClient(_AccountSid, _AuthToken); string messageBody = "Here is your verification code: " + code; var message = twilio.SendMessage(_TwilioNumber, toNumber , messageBody); string oldPhone = currentPhone; int logId = TextMessageLogInsert(userId, oldPhone , model.Phone, messageBody); return logId; }