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