public static List<NewCategory> GetCategoryForHomepage(int length)
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.GetAll().OrderByDescending(s => s.CreatedDate).Take(length).ToList();
}
}
public static NewCategory Update(NewCategory item)
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.Update(item);
}
}
public static NewCategory GetByMeta(string meta)
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.Find(s => s.MetaTittle == meta);
}
}
public static NewCategory GetByName(string categoryName)
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.Find(s => s.Name.Trim().ToLower().Contains(categoryName.Trim().ToLower()));
}
}
public static List<NewCategory> GetAll()
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.GetAll().ToList();
}
}
public static NewCategory GetById(long? id)
{
using (var uow = new UnitOfWork())
{
return uow.NewCategoryRepository.Find(s => s.ID == id);
}
}
public static News GetNewByMeta(string MetaTittle)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.Find(s => s.MetaTittle == MetaTittle);
}
}
public static List<News> GetNewByCategry(long id)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.FindAll(s => s.CategoryID == id).ToList();
}
}
public static News GetById(long newId)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.Find(s => s.ID == newId);
}
}
public static IEnumerable<News> GetAllNew( int page, int pageSize)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.GetAll().OrderBy(x=>x.ID).ToPagedList(page,pageSize);
}
}
public static bool Delete(News item)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.Delete(item);
}
}
public static News Add(News item)
{
using (var uow = new UnitOfWork())
{
return uow.NewRepository.Add(item);
}
}
public static User GetUser(string username, string password)
{
using (var uow = new UnitOfWork())
{
var user = uow.UserRepository.Find(s => s.UserName == username && s.Password == password);
return user ?? null;
}
}
public static User Login(string userName, string password)
{
using (var uow = new UnitOfWork())
{
var user = uow.UserRepository.Find(s => s.UserName.ToLower() == userName.ToLower() && s.Password == password);
return user ?? null;
}
}
public static List<News> ListNewRelated(long id)
{
using (var uow = new UnitOfWork())
{
var news = uow.NewRepository.Find(s => s.ID == id);
return uow.NewRepository.FindAll(s => s.ID != id && s.CategoryID == news.CategoryID).ToList();
}
}
