public async Task <ActionResult <Audio> > GetLatestAudio()
{
var audio = await _context.Audio
.Include(a => a.Message)
.Where(a => EF.Functions.DateDiffDay(
DateTools.GetNominalDateForDayOfWeek(
DayOfWeek.Sunday),
a.Message.Date) % 7 == 0)
.OrderByDescending(a => a.Message.Date)
.FirstOrDefaultAsync();
if (audio == null)
{
return(NotFound());
}
return(audio);
}
public async Task <ActionResult <Notes> > GetLatestNotes()
{
var notes = await _context.Notes
.Include(n => n.Message)
.Where(n => EF.Functions.DateDiffDay(
DateTools.GetNominalDateForDayOfWeek(
DayOfWeek.Sunday),
n.Message.Date) % 7 == 0)
.OrderByDescending(n => n.Message.Date)
.FirstOrDefaultAsync();
if (notes == null)
{
return(NotFound());
}
return(notes);
}
public async Task <ActionResult <Video> > GetLatestVideo()
{
var video = await _context.Video
.Include(v => v.Message)
.Where(v => EF.Functions.DateDiffDay(
DateTools.GetNominalDateForDayOfWeek(
DayOfWeek.Sunday),
v.Message.Date) % 7 == 0)
.OrderByDescending(v => v.Message.Date)
.FirstOrDefaultAsync();
if (video == null)
{
return(NotFound());
}
return(video);
}
