//ADD, UPDATE, DELETE Venues
public int Add(VenueAddRequest request, int userId)
{
int id = 0;
string procName = "[dbo].[Venues_Insert]";
_data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection collection)
{
collection.AddWithValue("@Name", request.Name);
collection.AddWithValue("@Description", request.Description);
collection.AddWithValue("@LocationId", request.LocationId);
collection.AddWithValue("@Url", request.Url);
collection.AddWithValue("@CreatedBy", userId);
collection.AddWithValue("@ModifiedBy", userId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
collection.Add(idOut);
}, returnParameters : delegate(SqlParameterCollection returnCollection)
{
object oId = returnCollection["@Id"].Value;
int.TryParse(oId.ToString(), out id);
});
return(id);
}
public int Insert(VenueAddRequest model, int userId)
{
int retVal = 0;
_dataProvider.ExecuteNonQuery("dbo.Venues_Insert", inputParamMapper: delegate (SqlParameterCollection parms)
{
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@Id";
parm.SqlDbType = SqlDbType.Int;
parm.Direction = ParameterDirection.Output;
parms.Add(parm);
parms.AddWithValue("@Name", model.Name);
parms.AddWithValue("@Description", model.Description);
parms.AddWithValue("@LocationId", model.LocationId);
parms.AddWithValue("@Url", model.Url);
parms.AddWithValue("@AvatarUrl", model.AvatarUrl);
parms.AddWithValue("@CreatedBy", userId);
parms.AddWithValue("@ModifiedBy", userId);
}, returnParameters: delegate (SqlParameterCollection parms)
{
Int32.TryParse(parms["@Id"].Value.ToString(), out retVal);
});
return retVal;
}
public ActionResult <ItemResponse <int> > Insert(VenueAddRequest model)
{
try
{
ItemResponse <int> resp = new ItemResponse <int>();
resp.Item = _venuesService.Insert(model, _authenticationService.GetCurrentUserId());
return(Created201(resp));
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
return(StatusCode(500, new ErrorResponse(ex.Message)));
}
}
public ActionResult <ItemResponse <int> > Add(VenueAddRequest model)
{
int code = 200;
BaseResponse response = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(model, userId);
response = new ItemResponse <int>()
{
Item = id
};
}
catch (Exception ex)
{
code = 500;
response = new ErrorResponse(ex.Message);
base.Logger.LogError(ex.ToString());
}
return(StatusCode(code, response));
}
