private static void VirtualEventWizardParamMapper(VirtualEventWizardAddRequest model, SqlParameterCollection col, int userId)
{
//Event
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);
//User
col.AddWithValue("@UserId", userId);
}
public ActionResult<ItemResponse<int>> WizardAdd(VirtualEventWizardAddRequest model)
{
int iCode = 201;
BaseResponse response = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.WizardAdd(model, userId);
response = new ItemResponse<int> { Item = id };
}
catch (Exception ex)
{
iCode = 500;
base.Logger.LogError(ex.ToString());
response = new ErrorResponse($"Server Error {ex.Message}");
}
return StatusCode(iCode, response);
}
public int WizardAdd(VirtualEventWizardAddRequest model, int userId)
{
int id = 0;
string procName = "[dbo].[VirtualEventWizard_Insert]";
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
VirtualEventWizardParamMapper(model, col, userId);
SqlParameter idOut = new SqlParameter("@OutputId", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
}, returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@OutputId"].Value;
int.TryParse(oId.ToString(), out id);
});
return(id);
}
