public static MVC4Grid.Grid.GridResult GetALLACRDocuments(MVC4Grid.Grid.GridFilter Filter)
{
using (EditorsEntities entity = new EditorsEntities())
{
var res = (from a in entity.docs
select new ACRDocumentsModel
{
Id = a.id,
Source = a.source,
Name = a.nm,
LastUpdatedDate = a.last_updated_dt,
IsAutoUpdate = a.auto_upd,
ClicksCount = a.clicks_count
}).GridFilterBy(Filter);
return(res);
}
}
// Get All ACR Document Relations based on Doc Id
public static MVC4Grid.Grid.GridResult GetALLACRDocumentRelations(int DocId, MVC4Grid.Grid.GridFilter Filter)
{
using (EditorsEntities entity = new EditorsEntities())
{
var ACRDocumentRelations = (from r in entity.doc_in_subtopic
join d in entity.docs on r.doc_id equals d.id
join s in entity.SubTopics on r.subtopic_id equals s.SubTopicID
join t in entity.Topics on s.TopicID equals t.TopicID
where r.doc_id == DocId
select new ACRDocumentRelationshipModel
{
DocId = r.doc_id,
DocName = d.nm,
DocSource = d.source,
RelationId = r.id,
SubTopicId = r.subtopic_id,
SubTopicName = s.SubTopicName,
TopicName = t.TopicName
}).GridFilterBy(Filter);
return(ACRDocumentRelations);
}
}
