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