public int Add(AdvertiserAddRequest model) { int id = 0; string procName = "[dbo].[Advertisers_Insert]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { col.AddWithValue("@ShortTitle", model.ShortTitle); col.AddWithValue("@Title", model.Title); col.AddWithValue("@ShortDescription", model.ShortDescription); col.AddWithValue("@Content", model.Content); col.AddWithValue("@CreatedBy", model.CreatedBy); col.AddWithValue("@Slug", model.Slug); col.AddWithValue("@EntityTypeId", model.EntityTypeId); col.AddWithValue("@StatusId", model.StatusId); col.AddWithValue("@MetaDataId", model.MetaDataId); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCollection) { object oId = returnCollection["@Id"].Value; int.TryParse(oId.ToString(), out id); }); return(id); }
public ActionResult <ItemResponse <int> > Create(AdvertiserAddRequest model) { ObjectResult result = null; try { int id = _service.Add(model); ItemResponse <int> response = new ItemResponse <int>() { Item = id }; result = Created201(response); } catch (Exception ex) { Logger.LogError(ex.ToString()); ErrorResponse response = new ErrorResponse(ex.Message); result = StatusCode(500, response); } return(result); }