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;
}
