public IEnumerable <Post> GetPostsByMonth(DateTime monthYear)
{
var fromDate = new DateTime(monthYear.Year, monthYear.Month, 1);
var toDate = fromDate.AddMonths(1).AddDays(-1);
return(MyDbSet.Where(p => p.PostedOn >= fromDate && p.PostedOn <= toDate).ToList());
}
public Post Find(int year, int month, string urlSlug)
{
var post =
MyDbSet.Include("Category").SingleOrDefault <Post>(p => p.Published && p.PostedOn.Year == year && p.PostedOn.Month == month && p.UrlSlug == urlSlug);
return(post);
}
public static MyDbSet <T> ToMyDbSet <T>(this IEnumerable <T> source)
where T : class
{
var collection = new MyDbSet <T>();
foreach (var item in source)
{
collection.Add(item);
}
return(collection);
}
public override bool Update(SaleBillDetail entity)
{
var oldSaleBillDetail = MyDbSet.Find(entity.Id);
var oldQuantity = oldSaleBillDetail.Quantity;
var newQuantity = entity.Quantity;
var changedQuantity = Math.Abs(newQuantity - oldQuantity);
var isSuccess = base.Update(entity);
if (isSuccess)
{
if (newQuantity < oldQuantity)
{
TriggerQuantityIncrease(changedQuantity, entity.ProductId);
}
else if (newQuantity > oldQuantity)
{
TriggerQuantityReduced(changedQuantity, entity.ProductId);
}
return(true);
}
return(false);
}
public IEnumerable <Post> GetMostViewedPost(int size)
{
return(MyDbSet.Where(p => p.Published).OrderByDescending(p => p.ViewCount).Take(size).ToList());
}
public Category GetByUrlSlug(string urlSlug)
{
var category = MyDbSet.FirstOrDefault(c => c.UrlSlug == urlSlug);
return(category);
}
public IEnumerable <Tag> GetBySize(int size)
{
return(MyDbSet.Take(size).ToList());
}
public Tag GetTagByUrlSlug(string urlSlug)
{
var tag = MyDbSet.FirstOrDefault <Tag>(t => t.UrlSlug == urlSlug);
return(tag);
}
public IQueryable <Flower> GetByCategory(int categoryId)
{
return(MyDbSet.Where(p => p.Category.CategoryId == categoryId).OrderByDescending(p => p.CategoryId));
}
public IEnumerable <Post> GetLatestPost(int size)
{
return(MyDbSet.Where(p => p.Published).OrderByDescending(p => p.PostedOn).Take(size).ToList());
}
public IEnumerable <Post> GetLatestPost()
{
return(MyDbSet.OrderByDescending(p => p.PostedOn).ToList());
}
public IEnumerable <Post> GetUnpublisedPosts()
{
return(MyDbSet.Where(p => !p.Published).OrderByDescending(p => p.Modified).ToList());
}
public IEnumerable <Post> GetMostViewedPost()
{
return(MyDbSet.OrderByDescending(p => p.ViewCount).ToList());
}
public IQueryable <Post> GetPostsByTag(string tag)
{
return(MyDbSet.Where(p => p.Tags.Any(t => t.UrlSlug == tag)).OrderByDescending(p => p.PostedOn));
}
public IEnumerable <Post> GetHighestPosts()
{
return(MyDbSet.OrderByDescending(p => p.Rate).ToList());
}
public IQueryable <Post> GetPostsByCategory(string category)
{
return(MyDbSet.Where(p => p.Category.Name == category).OrderByDescending(p => p.PostedOn));
}
public int CountPostsForTag(string tag)
{
return(MyDbSet.Count(p => p.Tags.Any(t => t.Name == tag)));
}
public int CountPostsForCategory(string category)
{
return(MyDbSet.Count(p => p.Category.Name == category));
}
