public ResourceListPayload Get(int id)
{
ResourceListPayload payload = new ResourceListPayload();
payload.resourceList = new List<ResourceList>();
using (ResourcesDataContext dc = new ResourcesDataContext())
{
var r = dc.sps_getResourceList(true, id + 1, 20, null, null);
foreach (var item in r)
{
ResourceList tmpPayload = new ResourceList();
tmpPayload.ResourceName = item.name;
tmpPayload.ResourceDescription = item.description;
tmpPayload.ResourceLanguage = item.language;
tmpPayload.ResourceTopic = item.topic;
tmpPayload.ResourceUploadDate = item.uploadDate.ToShortDateString();
tmpPayload.ResourceId = item.id;
tmpPayload.ResourceType = item.type;
payload.count = (int)item.total;
payload.resourceList.Add(tmpPayload);
if (item.previewFileId.HasValue)
{
tmpPayload.PreviewFileId = (int)item.previewFileId;
}
else
{
tmpPayload.PreviewFileId = 0;
}
}
}
return payload;
}
public ResourceListPayload Get(int id, string topic, string orderby, string order)
{
int topicId = int.Parse(topic);
ResourceListPayload payload = new ResourceListPayload();
payload.resourceList = new List<ResourceList>();
using (ResourcesDataContext dc = new ResourcesDataContext())
{
//var r = dc.sps_getResourceList(false, id + 1, 20, search); //name, rating or topic
var r = dc.sps_getResourceListByTopic(topicId, true, id + 1, 20, orderby, order);
foreach (var item in r)
{
ResourceList tmpPayload = new ResourceList();
tmpPayload.ResourceName = item.name;
tmpPayload.ResourceDescription = item.description;
tmpPayload.ResourceLanguage = item.language;
tmpPayload.ResourceTopic = item.topic;
tmpPayload.ResourceUploadDate = item.uploadDate.ToShortDateString();
tmpPayload.ResourceId = item.id;
tmpPayload.ResourceType = item.type;
payload.count = (int)item.total;
payload.resourceList.Add(tmpPayload);
if (item.previewFileId.HasValue)
{
tmpPayload.PreviewFileId = (int)item.previewFileId;
}
else
{
tmpPayload.PreviewFileId = 0;
}
}
}
return payload;
}
