public EditMission Get(int id)
{
EditMission retrieved_mission = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Missions_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@id", id);
}
, map : delegate(IDataReader reader, short set)
{
retrieved_mission = new EditMission();
int startingIndex = 0; //startingOrdinal
retrieved_mission.Id = reader.GetSafeInt32(startingIndex++);
retrieved_mission.DateCreated = reader.GetSafeDateTime(startingIndex++);
retrieved_mission.DateModified = reader.GetSafeDateTime(startingIndex++);
retrieved_mission.UserId = reader.GetSafeString(startingIndex++);
retrieved_mission.Title = reader.GetSafeString(startingIndex++);
retrieved_mission.Description = reader.GetSafeString(startingIndex++);
retrieved_mission.MediaId = reader.GetSafeInt32(startingIndex++);
retrieved_mission.PointScore = reader.GetSafeInt32(startingIndex++);
retrieved_mission.Url = reader.GetSafeString(startingIndex++);
retrieved_mission.PlacesCount = reader.GetSafeInt32(startingIndex++);
}
);
return(retrieved_mission);
}
public HttpResponseMessage GetById(int id)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
EditMission retrieved_mission = _MissionsService.Get(id);
ItemResponse <EditMission> Response = new ItemResponse <EditMission>();
Response.Item = retrieved_mission;
return(Request.CreateResponse(HttpStatusCode.OK, Response));
}
