public int Insert(CMSTemplateAddRequest model, int userId)
{
int id = 0;
string procName = "[dbo].[CMSTemplate_Insert]";
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
col.AddWithValue("@Name", model.Name);
col.AddWithValue("@Description", model.Description);
col.AddWithValue("@PrimaryImage", model.PrimaryImage);
col.AddWithValue("@CreatedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
Int32.TryParse(oId.ToString(), out id);
});
return(id);
}
public ActionResult <ItemResponse <int> > Insert(CMSTemplateAddRequest model)
{
int iCode = 201;
BaseResponse response;
try
{
int userId = _authService.GetCurrentUserId();
int id = _cmsTemplateService.Insert(model, userId);
response = new ItemResponse <int> {
Item = id
};
}
catch (Exception ex)
{
iCode = 500;
base.Logger.LogError(ex.ToString());
response = new ErrorResponse($"Generic Error: ${ ex.Message }");
}
return(StatusCode(iCode, response));
}