// GET BY ID
public HttpResponseMessage SelectById(int id)
{
try
{
UserDashFb resp = new UserDashFb();
resp = _facebookDbService.SelectById(id);
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public UserDashFb SelectById(int id)
{
UserDashFb singleItem = new UserDashFb();
singleItem.Id = id;
this.DataProvider.ExecuteCmd("dbo.UserDashboard_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
int startingIndex = 0; //startingOrdinal
singleItem.Facebook = reader.GetSafeString(startingIndex++);
singleItem.Twitter = reader.GetSafeString(startingIndex++);
singleItem.WklyFb = reader.GetSafeBool(startingIndex++);
singleItem.WklyTwt = reader.GetSafeBool(startingIndex++);
});
return(singleItem);
}
