// 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); }