public IQueryable <Review> GetAllPublishedWidhoutDraft()
{
PublicationStatusRepository productStatusRepository = new PublicationStatusRepository(this.context);
IQueryable <int> publishedIds = (from d in this.context.DraftReviews.Where(d => d.OriginReview != null && d.PublicationStatus.Name == draftStatus.Name.ToUpper()) select d.OriginReview.ID);
return(this.context.Reviews.Where(r => !publishedIds.Contains(r.ID)));
}
/// <summary>
/// Receives and set the context for the repository
/// </summary>
/// <param name="context">The context</param>
public ProductRepository(DatabaseContext context)
: base(context)
{
this.publicationStatusRepository = new PublicationStatusRepository(context);
this.draftStatus = this.publicationStatusRepository.GetByName(Constants.PublicationStatusName.DRAFT);
}
