public async Task <ActionResult <IEnumerable <Film> > > GetFilmList(
[FromQuery(Name = "filmName")] string searchFilmName,
[FromQuery(Name = "page")] string page)
{
var filmsQuery = from film in _context.Films select film;
if (!string.IsNullOrEmpty(searchFilmName))
{
filmsQuery = filmsQuery.Where(film => film.filmName.Contains(searchFilmName));
}
try
{
int parsedPageNumber = StringConversionUtils.stringToInt(page);
if (parsedPageNumber != 0)
{
filmsQuery = filmsQuery.Skip(10 * (parsedPageNumber - 1)).Take(10);
}
else
{
filmsQuery = filmsQuery.Take(10);
}
}
catch (Exception e)
{
return(StatusCode(
(int)HttpStatusCode.BadRequest,
new ErrorResponse(1, e.Message)
));
}
var films = await filmsQuery.Include(film => film.broadcasts).ToListAsync();
return(films);
}
public async Task <ActionResult <IEnumerable <Ticket> > > GetTicketList(
[FromQuery(Name = "filmName")] string searchFilmName,
[FromQuery(Name = "broadcastId")] string broadcastId,
[FromQuery(Name = "userId")] string userId)
{
var TicketQuery = from ticket in _context.Tickets select ticket;
if (!string.IsNullOrEmpty(searchFilmName))
{
TicketQuery = TicketQuery.Where(t => t.broadcast.film.filmName.Contains(searchFilmName));
}
try
{
TicketQuery = TicketQuery.Where(t =>
t.broadcastId == StringConversionUtils.stringToInt(broadcastId));
TicketQuery = TicketQuery.Where(t =>
t.userId == StringConversionUtils.stringToInt(broadcastId));
}
catch (Exception e)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new ErrorResponse(1, e.Message)));
}
return(await TicketQuery.ToListAsync());
}
