public ActionResult Update(int id)
{
AllNewsUpdateVM news = new AllNewsUpdateVM();
AllNews model = service.AllNewsService.GetByID(id);
news.AllNewsS.ID = model.ID;
news.AllNewsS.Header = model.Header;
news.AllNewsS.Content = model.Content;
news.AllNewsS.Image = model.Image;
news.Categories = service.CategoryService.GetActive();
return(View(news));
}
public ActionResult Update(AllNewsDTO data)
{
AllNews model = service.AllNewsService.GetByID(data.ID);
model.Header = data.Header;
model.Description = data.Description;
model.Content = data.Content;
model.Image = data.Image;
model.CategoryID = data.CategoryID;
model.Status = Status.Update;
model.UpdateDate = DateTime.Now;
service.AllNewsService.Update(model);
return(Redirect("/AdminNews/List"));
}
public ActionResult Add(AllNewsDTO data)
{
AllNews model = new AllNews();
model.Header = data.Header;
model.Description = data.Description;
model.Content = data.Content;
model.Image = data.Image;
model.Status = Status.Active;
model.AddDate = DateTime.Now;
model.CategoryID = data.CategoryID;
service.AllNewsService.Add(model);
return(Redirect("/AdminNews/List"));
}
public async Task Initial()
{
AllNews = await _dbContext.News.Include(n => n.Images).Include(n => n.Detail).OrderByDescending(n => n.Detail.ClickCount).AsNoTracking().ToListAsync();
BannerNews = AllNews.Where(p => p.Images.Count() > 0).Take(4);
TopNewsGroup = new List <TopNewsGroup>();
for (int i = 0; i < GroupNumber; i++)
{
TopNewsGroup group = new TopNewsGroup(AllNews.Skip(TopNewsGroup.Count() * 3).Take(3));
((List <TopNewsGroup>)TopNewsGroup).Add(group);
}
//HotNewsGroup = new HotNewsGroup { ImageNews = AllNews.Where(p => p.Images.Count() > 0).Take(4),News = AllNews.Take(10) };
CategoryNews = new CategoryNews {
News = AllNews.Skip(TopNewsGroup.Count() * 3)
};
}
public ActionResult NewsList()
{
try
{
string _connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString as string;
using (IDbConnection db = new SqlConnection(_connectionString))
{
AllNews pageVM = new AllNews();
var query = "SelectAllNews";
pageVM.Newsz = db.Query <summernoteNews>(query, commandType: CommandType.StoredProcedure);
return(View(pageVM));
}
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public JsonResult GetPosts()
{
using (MinhThanhEntities db = new MinhThanhEntities())
{
AllNews model = new AllNews();
model.Posts = (
from p in db.Posts
where
p.idCategory == (db.CategoryPosts.Where(cp => cp.alias == "tin-tuc").FirstOrDefault().id) &&
p.published == true
select new AltPost()
{
id = p.id,
title = p.title,
alias = p.alias,
description = p.description,
image = p.image,
timePublished = p.timePublished
}
).OrderByDescending(p => p.id).ToList();
model.CategoryPost = (
from cp in db.CategoryPosts
where cp.alias == "tin-tuc"
select new AltCategoryPost()
{
id = cp.id,
title = cp.title,
description = cp.description,
imageBanner = cp.imageBanner
}
).FirstOrDefault();
return(Json(model, JsonRequestBehavior.AllowGet));
}
}
public async Task <IEnumerable <News> > Handle(AllNews request, CancellationToken cancellationToken)
{
var result = await _dbContext.News.ToListAsync <News>(cancellationToken);
return(result);
}
