public int Insert(EventRSVPRequest model)
{
int returnValue = 0;
DataProvider.ExecuteNonQuery("dbo.EventRSVP_Insert",
inputParamMapper: (SqlParameterCollection inputs) =>
{
inputs.AddWithValue("@EventId", model.EventId);
inputs.AddWithValue("@UserBaseId", model.UserBaseId);
inputs.AddWithValue("@RSVPTypeId", model.RSVPTypeId);
SqlParameter idOut1 = new SqlParameter("@PeopleGoing", 0);
SqlParameter idOut2 = new SqlParameter("@PeopleInterested", 0);
idOut1.Direction = ParameterDirection.Output;
idOut2.Direction = ParameterDirection.Output;
inputs.Add(idOut1);
inputs.Add(idOut2);
},
returnParameters: (SqlParameterCollection inputs) =>
{
int.TryParse(inputs["@PeopleGoing"].Value.ToString(), out returnValue);
int.TryParse(inputs["@PeopleInterested"].Value.ToString(), out returnValue);
});
return(returnValue);
}
public void Update(EventRSVPRequest model)
{
DataProvider.ExecuteNonQuery("dbo.EventRSVP_Update",
inputParamMapper: (SqlParameterCollection inputs) =>
{
inputs.AddWithValue("@EventId", model.EventId);
inputs.AddWithValue("@UserBaseId", model.UserBaseId);
inputs.AddWithValue("@RSVPTypeId", model.RSVPTypeId);
});
}
public IHttpActionResult Put(EventRSVPRequest model)
{
try
{
model.UserBaseId = _userService.GetCurrentUserId();
_eventRSVPService.Update(model);
return(Ok(new SuccessResponse()));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Post(EventRSVPRequest model)
{
try
{
model.UserBaseId = _userService.GetCurrentUserId();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
ItemResponse <int> response = new ItemResponse <int>
{
Item = _eventRSVPService.Insert(model)
};
return(Ok(response));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
