public int QuoteItemInsert(QuoteItemInsertRequest model) { int id = 0; try { DataProvider.ExecuteNonQuery(GetConnection, "dbo.QuoteItem_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@quoteId", model.QuoteId); paramCollection.AddWithValue("@name", model.Name); paramCollection.AddWithValue("@volume", model.Volume); paramCollection.AddWithValue("@weight", model.Weight); paramCollection.AddWithValue("@quantity", model.Quantity); paramCollection.AddWithValue("@unit", model.Unit); SqlParameter p = new SqlParameter("@id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@id"].Value.ToString(), out id); }); } catch (Exception ex) { throw ex; } return(id); }
public HttpResponseMessage QuoteItemInsert(QuoteItemInsertRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _QuoteService.QuoteItemInsert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }