public ResourceApprovePayload Get() { ResourceApprovePayload payload = new ResourceApprovePayload(); payload.resourceList = new List<ResourceList>(); using (ResourcesDataContext dc = new ResourcesDataContext()) { var r = (from d in dc.bhdResources join l in dc.bhdResourceLanguages on d.languageId equals l.id join top in dc.bhdResourceTopics on d.topicId equals top.id join typ in dc.bhdResourceTypes on d.typeId equals typ.id where !d.isActive && !d.approvalDate.HasValue && !d.approvalUser.HasValue select new { d.name, d.description, d.uploadDate, d.id, language = l.name , topic = top.name, type = typ.name, d.isActive }).Take(20); 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; tmpPayload.isActive = item.isActive; payload.resourceList.Add(tmpPayload); } } return payload; }
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 ResourceFeaturedPayload Get() { ResourceFeaturedPayload payload = new ResourceFeaturedPayload(); payload.resourceList = new List<ResourceList>(); using (ResourcesDataContext dc = new ResourcesDataContext()) { var r = dc.sps_getFeaturedResources(0, true); 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.resourceList.Add(tmpPayload); } } return payload; }
public ResourceList Get(int id) { using (ResourcesDataContext dc = new ResourcesDataContext()) { var r = (from d in dc.bhdResources join l in dc.bhdResourceLanguages on d.languageId equals l.id join top in dc.bhdResourceTopics on d.topicId equals top.id join typ in dc.bhdResourceTypes on d.typeId equals typ.id where !d.isActive && !d.approvalDate.HasValue && !d.approvalUser.HasValue && d.id == id select new { d.name, d.description, d.uploadDate, d.id, language = l.name, topic = top.name, type = typ.name, d.isActive }).FirstOrDefault(); ResourceList resource = new ResourceList(); resource.ResourceName = r.name; resource.ResourceDescription = r.description; resource.ResourceLanguage = r.language; resource.ResourceTopic = r.topic; resource.ResourceUploadDate = r.uploadDate.ToShortDateString(); resource.ResourceId = r.id; resource.ResourceType = r.type; resource.isActive = r.isActive; return resource; } }
public ResourceViewPayload Get(int id) { //this is to get a resource ResourceViewPayload tmpResource = new ResourceViewPayload(); ResourceList tmpList = new ResourceList(); using (ResourcesDataContext dc = new ResourcesDataContext()) { var r = (from d in dc.bhdResources join l in dc.bhdResourceLanguages on d.languageId equals l.id join top in dc.bhdResourceTopics on d.topicId equals top.id join typ in dc.bhdResourceTypes on d.typeId equals typ.id join rf in dc.bhdResourceFormats on d.id equals rf.resourceId where d.id == id select new { ResourceName = d.name, ResourceDescription = d.description, ResourceUpload = d.uploadDate, ResourceId = d.id, ResourceLanguage = l.name, ResourceTopic = top.name, ResourceType = typ.name, ResourceFormat = rf.bhdFormat.name, ResourceTopicId = top.id, PreviewFileId = d.previewFileId}).FirstOrDefault(); if (r != null) { tmpList.ResourceName = r.ResourceName; tmpList.ResourceDescription = r.ResourceDescription; tmpList.ResourceUploadDate = r.ResourceUpload.ToShortDateString(); tmpList.ResourceId = r.ResourceId; tmpList.ResourceLanguage = r.ResourceLanguage; tmpList.ResourceType = r.ResourceType; tmpList.ResourceFormat = r.ResourceFormat; } if (r.PreviewFileId != null) tmpList.PreviewFileId = (int)r.PreviewFileId; //get rating score var rate = (from d in dc.bhdResourceRatings where d.resourceId == id select d); if (rate != null) { int ratingAve = 0; tmpResource.ratingCount = rate.Count(); foreach (var item in rate) { ratingAve = ratingAve + item.rating; } if (ratingAve > 0 && rate.Count() > 0) { ratingAve = (ratingAve / rate.Count()); } tmpResource.averageRating = ratingAve; } else { tmpResource.ratingCount = 0; tmpResource.averageRating = 0; } // resource comments List<Comment> resourceComments = dc.bhdResourceComments.Where((x) => x.resourceId == id && x.isActive.Value).Select(x => new Comment { userId = x.userId, resourceId = x.resourceId, commentDate = x.commentDate.Value, comment = x.comment, commentId = x.id, active = x.isActive.Value }).ToList(); tmpResource.comments = resourceComments; tmpResource.resourceInfo = tmpList; //fix for the topic var rtopic = dc.sps_getResourceTopicListById(r.ResourceTopicId, true); foreach (var item in rtopic) { if (tmpList.ResourceTopic != null) { tmpList.ResourceTopic = tmpList.ResourceTopic + " > " + item.name; } else { tmpList.ResourceTopic = item.name; } } List<FileViewInfo> files = (from f in dc.bhdResourceFiles where f.resourceId == r.ResourceId select new FileViewInfo() { FileName = f.bhdFile.name, FileSize = f.bhdFile.size, FileContentType = f.bhdFile.bhdFileType.extension, FileId = f.bhdFile.id }).ToList(); foreach (var item in files) { if (item.FileSize != null && item.FileSize != 0) { item.FileSize = item.FileSize / 1000; } string fileContentType = item.FileContentType; if (fileContentType != null && fileContentType != "") { fileContentType = fileContentType.Substring((fileContentType.IndexOf('/') + 1), fileContentType.Length - (fileContentType.IndexOf('/') + 1)); } item.FileContentType = fileContentType; } tmpResource.fileInfo = files; List<LinkViewInfo> urls = (from u in dc.bhdResourceLinks where u.resourceId == r.ResourceId select new LinkViewInfo() { resourceURL = u.bhdLink.url }).ToList(); tmpResource.urlInfo = urls; string tagRet = ""; var tags = (from t in dc.bhdResourceKeywords join k in dc.bhdKeywords on t.KeywordId equals k.id where k.isActive && t.Resourceid == id select k.value).ToList(); foreach (var item in tags) { tagRet = tagRet + item + ","; } if (tagRet.Length > 0) tagRet = tagRet.Remove(tagRet.Length - 1, 1); tmpResource.resourceInfo.ResourceTags = tagRet; } return tmpResource; }
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; }