public ActionResult <ItemResponse <int> > CreateByCustomer(LocationByCustomerAddRequest model) { ObjectResult result = null; try { int userId = _authService.GetCurrentUserId(); int id = _service.AddByCustomer(model, userId); 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); }
public int AddByCustomer(LocationByCustomerAddRequest model, int userId) { int id = 0; string procName = "[dbo].[Locations_Insert_ByCustomerId]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection collection) { CommonParams(model, collection); collection.AddWithValue("@CreatedBy", userId); collection.AddWithValue("@CustomerId", model.CustomerId); SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int); idOut.Direction = ParameterDirection.Output; collection.Add(idOut); }, returnParameters : delegate(SqlParameterCollection returnCollection) { object objId = returnCollection["@Id"].Value; int.TryParse(objId.ToString(), out id); }); return(id); }