public HttpResponseMessage Add(ActivityEntryAddRequest model)
{
if (!ModelState.IsValid)
{
return(CreateErrorResponse());
}
int userId = _auth.GetCurrentUserId();
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _service.Insert(model, userId);
return(Request.CreateResponse(HttpStatusCode.Created, response));
}
public int Insert(ActivityEntryAddRequest data, int userId)
{
int ativityEntryId = 0;
if (data == null)
{
throw new ArgumentNullException("This is required");
}
string storeProc = "[dbo].[ActivityEntries_Insert]";
_dataProvider.ExecuteNonQuery(storeProc
, delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@UserId", userId);
sqlParams.AddWithValue("@PetId", data.PetId);
sqlParams.AddWithValue("@IsActive", data.IsActive);
sqlParams.AddWithValue("@DateStart", data.DateStart);
sqlParams.AddWithValue("@DateEnd", data.DateEnd);
sqlParams.AddWithValue("@ActivityTypeId", data.ActivityTypeId);
sqlParams.AddWithValue("@Value", data.Value);
sqlParams.AddWithValue("@TimeElapsed", data.TimeElapsed);
sqlParams.AddWithValue("@PointsEarned", data.PointsEarned);
sqlParams.AddWithValue("@ChallengeId", data.ChallengeId);
sqlParams.AddWithValue("@Notes", data.Notes);
sqlParams.AddWithValue("@PhotoUrl", data.PhotoUrl);
SqlParameter idParameter = new SqlParameter("@Id", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
sqlParams.Add(idParameter);
}
, returnParameters : delegate(SqlParameterCollection sqlParams)
{
Int32.TryParse(sqlParams["@Id"].Value.ToString(), out ativityEntryId);
}
);
return(ativityEntryId);
}
