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