public HttpResponseMessage Insert(MetaUrlAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <int> response = new ItemResponse <int>(); response.Item = _metaUrlService.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int Insert(MetaUrlAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery("dbo.MetaOT_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Name", model.Name); paramCollection.AddWithValue("@Url", model.Url); SqlParameter idParamter = new SqlParameter("@Id", SqlDbType.Int); idParamter.Direction = ParameterDirection.Output; paramCollection.Add(idParamter); } , returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@Id"].Value.ToString(), out id); }); return(id); }