public HttpResponseMessage Add(AEMeAddRequest model)
{
if (!ModelState.IsValid)
{
return(CreateErrorResponse());
}
ItemResponse <int> responseBody = new ItemResponse <int>();
int userId = _auth.GetCurrentUserId();
responseBody.Item = _service.Insert(model, userId);
return(Request.CreateResponse(HttpStatusCode.Created, responseBody));
}
//new stuff
public int Insert(AEMeAddRequest data, int userId)
{
int sponsorId = 0;
string storeProc = "[dbo].[ActivityEntries_InsertPetIdActivityId]";
_dataProvider.ExecuteNonQuery(storeProc
, delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@UserId", userId);
sqlParams.AddWithValue("@PetId", data.PetId);
sqlParams.AddWithValue("@IsActive", data.IsActive);
sqlParams.AddWithValue("@ActivityTypeId", data.ActivityTypeId);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
sqlParams.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection param)
{
Int32.TryParse(param["@Id"].Value.ToString(), out sponsorId);
}
);
return(sponsorId);
}
