public ActionResult CategoryNews(int id)
{
Category category = db.Categories.Find(id);
List<News> res = (from item in db.News
where item.Category == category.id
select item).ToList();
var resultList = new List<ModifiedNews>();
foreach (var item in res)
{
ModifiedNews ev = new ModifiedNews();
ev.Id = item.Id;
ev.Title = item.Title;
ev.ShortText = item.ShortText;
ev.Text = item.Text;
ev.Date = item.Date;
ev.ImageId = (from myImage in db.Images
where myImage.Id == item.ImageId
select myImage.ImageUrl).First();
resultList.Add(ev);
}
return View(resultList);
}
// GET: /Admin/News/
public ActionResult Index()
{
var resultList = new List<ModifiedNews>();
foreach (var item in db.News.ToList())
{
ModifiedNews ev = new ModifiedNews();
ev.Id = item.Id;
ev.Title = item.Title;
ev.ShortText = item.ShortText;
ev.Text = item.Text;
ev.Date = item.Date;
ev.ImageId = (from myImage in db.Images
where myImage.Id == item.ImageId
select myImage.ImageUrl).First();
ev.Category = (from myCategory in db.Categories
where myCategory.id == item.Category
select myCategory.CategoryName).First();
resultList.Add(ev);
}
return View(resultList);
}
