public static IEnumerable<Comment> GetByParentAndUser(string parentId, string container, string parentType, string user) { CommentsDataSource comDS = new CommentsDataSource(); var comments = from g in comDS.SelectAll() where g.DatasetId == parentId && g.PartitionKey == container && g.ParentType == parentType && g.Email == user select g; return CreateCommentEnumerator(comments); }
public static IEnumerable<Comment> GetDatasetComments(string datasetId, string parentType, string container) { var commentDS = new CommentsDataSource(); var comments = from g in commentDS.SelectAll() where g.DatasetId == datasetId && g.ParentType == parentType && container == g.PartitionKey select g; return CreateCommentEnumerator(comments); }
public static IEnumerable<String> GetSubscribers(string objectId, string container, string parentType, string exclude) { CommentsDataSource comDS = new CommentsDataSource(); var results = from com in comDS.SelectAll() where com.Notify == true && com.Email != "" && com.DatasetId == objectId && com.PartitionKey == container && com.ParentType == parentType && com.RowKey != exclude select com; return results.AsEnumerable().Select(c => c.Email).Distinct(); }
public DatasetCommentsDataSource() { IEnumerable<EntitySet> entitySets = new List<EntitySet>(); foreach (Container container in ContainerAliases) { var sets = EntitySetRepository.GetEntitySets(container.Alias, null) as List<EntitySet>; if (sets != null) { entitySets = entitySets.Union(sets); } } var cds = new CommentsDataSource(); IEnumerable<CommentEntry> comments = cds.SelectAll().Where(t => t.ParentType == ParentType.Dataset.ToString()); _list = (from es in entitySets join c in comments on es.EntitySetName equals c.DatasetId select new DatasetComment(es.EntityId, es.Name, es.Description, es.CategoryValue, es.ContainerAlias, es.LastUpdateDate, es.EntitySetName, c.Subject, c.Username, c.Email, c.PostedOn)); _list = _list.OrderBy(c => c.CommentDate) .OrderBy(c => c.DatasetName) .OrderBy(c => c.DatasetCategoryValue) .OrderBy(c => c.DatasetContainerAlias); }