public HttpResponseMessage AddUserDataItem(UserDataAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <int> response = new ItemResponse <int>(); string UserId = UserService.GetCurrentUserId(); response.Item = UserDataService.InsertUserDataItem(model, UserId); return(Request.CreateResponse(response)); } catch (Exception ex) { ErrorResponse er = new ErrorResponse(ex.Message); return(Request.CreateResponse(HttpStatusCode.BadRequest, er)); } }
public static int InsertUserDataItem(UserDataAddRequest model, string UserId) { var id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.UserData_Insert" , inputParamMapper : delegate(SqlParameterCollection AddUserData) { AddUserData.AddWithValue("@FirstName", model.FirstName); AddUserData.AddWithValue("@LastName", model.LastName); AddUserData.AddWithValue("@PhoneNumber", model.PhoneNumber); AddUserData.AddWithValue("@UserId", UserId); SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; AddUserData.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); }); return(id); }