public int Add(VirtualEventAddRequest model) { int id = 0; string procName = "[dbo].[VirtualEvents_Insert]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { VirtualEventParams(model, col); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; col.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCol) { object oId = returnCol["@Id"].Value; int.TryParse(oId.ToString(), out id); }); return(id); }
private static void VirtualEventParams(VirtualEventAddRequest model, SqlParameterCollection col) { col.AddWithValue("@EventTypeId", model.EventTypeId); col.AddWithValue("@Name", model.Name); col.AddWithValue("@Summary", model.Summary); col.AddWithValue("@Description", model.Description); col.AddWithValue("@VirtualTypeId", model.VirtualTypeId); col.AddWithValue("@EventStatusId", model.EventStatusId); col.AddWithValue("@ImageUrl", model.ImageUrl); col.AddWithValue("@ExternalSiteUrl", model.ExternalSiteUrl); col.AddWithValue("@IsFree", model.IsFree); col.AddWithValue("@DateStart", model.DateStart); col.AddWithValue("@DateEnd", model.DateEnd); }
public ActionResult<ItemResponse<int>> Add(VirtualEventAddRequest model) { ObjectResult result = null; try { int id = _service.Add(model); ItemResponse<int> response = new ItemResponse<int>() { Item = id }; result = Created201(response); } catch (Exception ex) { base.Logger.LogError(ex.ToString()); ErrorResponse response = new ErrorResponse(ex.Message); result = StatusCode(500, response); } return result; }