public LMSDocResponse GetById(int id)
{
LMSDocResponse lmsDoc = null;
dataProvider.ExecuteCmd(
"LmsDocumentResponses_getbyid",
delegate(SqlParameterCollection parameter)
{
parameter.AddWithValue("@id", id);
},
delegate(IDataReader reader, short resultIndex)
{
lmsDoc = new LMSDocResponse();
lmsDoc.Id = reader.GetInt32(0);
lmsDoc.UserId = reader.GetInt32(1);
lmsDoc.DocId = reader.GetInt32(2);
lmsDoc.DateCreated = reader.GetDateTime(3);
lmsDoc.DateModified = reader.GetDateTime(4);
lmsDoc.Feedback = reader.GetSafeString(5);
var json = reader.GetSafeString(6);
lmsDoc.DatePublished = reader.GetDateTime(7);
lmsDoc.TimeSpentInSec = reader.GetFloat(8);
lmsDoc.Content =
JArray.Parse(json)
.Select(item => item.Value <string>("content"))
.ToArray();
});
return(lmsDoc);
}
public List <LMSDocResponse> GetAll()
{
List <LMSDocResponse> lmsDocs = null;
dataProvider.ExecuteCmd(
"LMSDocumentResponses_getall",
null,
delegate(IDataReader reader, short resultIndex)
{
LMSDocResponse lmsDoc = new LMSDocResponse();
lmsDoc.Id = reader.GetInt32(0);
lmsDoc.UserId = reader.GetInt32(1);
lmsDoc.DocId = reader.GetInt32(2);
lmsDoc.DateCreated = reader.GetDateTime(3);
lmsDoc.DateModified = reader.GetDateTime(4);
lmsDoc.Feedback = reader.GetSafeString(5);
var json = reader.GetSafeString(6);
lmsDoc.DatePublished = reader.GetSafeDateTime(7);
lmsDoc.TimeSpentInSec = reader.GetFloat(8);
lmsDoc.Content =
JArray.Parse(json)
.Select(item => item.Value <string>("contents"))
.ToArray();
lmsDocs.Add(lmsDoc);
});
return(lmsDocs);
}
public HttpResponseMessage GetById(int id)
{
LMSDocResponse lmsResponse = lmsService.GetById(id);
ItemResponse <LMSDocResponse> response = new ItemResponse <LMSDocResponse>();
response.Item = lmsResponse;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}