public GameWithLinks GetById(int Id)
{
GameWithLinks model = null;
_dataProvider.ExecuteCmd(
"dbo.Games_SelectById_InnerJoinLinks",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@GameId", Id);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
model = new GameWithLinks();
int index = 0;
model.Id = reader.GetSafeInt32(index++);
model.Title = reader.GetSafeString(index++);
model.Plain = reader.GetSafeString(index++);
index++; //Column Sale Price is repeat of Current Low. Refactor when i reorganize tables
model.SalePrice = reader.GetSafeFloat(index++); //column currentLow
model.LastUpdated = reader.GetSafeDateTime(index++);
model.RetailPrice = reader.GetSafeFloat(index++);
model.ReleaseDate = reader.GetSafeDateTime(index++);
model.Links = new GameLinks();
model.Links.AppId = reader.GetSafeString(index++);
model.Links.Shop = reader.GetSafeString(index++);
model.Links.Url = reader.GetSafeString(index++);
}
);
return(model);
}
public ActionResult <ItemResponse <GameWithLinks> > GetById(int id)
{
try
{
GameWithLinks item = _gamesServices.GetById(id);
if (item == null)
{
return(NotFound404(new ErrorResponse("Record Not Found")));
}
else
{
ItemResponse <GameWithLinks> response = new ItemResponse <GameWithLinks>();
response.Item = item;
return(Ok200(response));
}
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
return(StatusCode(500, new ErrorResponse(ex.Message)));
}
}
