// GET api/news
public List <NewsDto> Get()
{
using (var context = new BasicAppEntityContext())
{
var list = context.News.Select(x => new NewsDto {
Id = x.Id, Title = x.Title
}).ToList();
return(list);
}
}
// DELETE api/news/5
public void Delete(int id)
{
using (var context = new BasicAppEntityContext())
{
var item = context.News.SingleOrDefault(x => x.Id == id);
context.Entry(item).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
// POST api/news
public void Post(NewsDetailDto data)
{
using (var context = new BasicAppEntityContext())
{
context.News.Add(new News
{
Title = data.Title,
Content = data.Content,
CreationDate = data.CreationDate,
Image = data.Image
});
context.SaveChanges();
}
}
// PUT api/news/5
public void Put(NewsDetailDto data)
{
using (var context = new BasicAppEntityContext())
{
var item = context.News.SingleOrDefault(x => x.Id == data.Id);
item.Title = data.Title;
item.Content = data.Content;
item.Image = data.Image;
item.CreationDate = data.CreationDate;
context.Entry(item).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
// GET api/news/5
public NewsDetailDto Get(int id)
{
using (var context = new BasicAppEntityContext())
{
var item = context.News.Select(x => new NewsDetailDto
{
Id = x.Id,
Title = x.Title,
Content = x.Content,
CreationDate = x.CreationDate,
Image = x.Image
}).SingleOrDefault(x => x.Id == id);
return(item);
}
}
public List <NewsDetailDto> Today()
{
using (var context = new BasicAppEntityContext())
{
var today = DateTime.Now;
var list = context.News
.Where(x => x.CreationDate.Year == today.Year &&
x.CreationDate.Month == today.Month &&
x.CreationDate.Day == today.Day)
.Select(x => new NewsDetailDto
{
Id = x.Id,
Title = x.Title,
CreationDate = x.CreationDate
}).ToList();
return(list);
}
}