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