public async Task <IEnumerable <DayShow> > SearchDayshowByPeriod(SeacrhDayRequests requests)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@ToDate", requests.ToDate);
parameters.Add("@FromDate", requests.FromDate);
return(await SqlMapper.QueryAsync <DayShow>(cnn: conn,
param: parameters,
sql: "sp_SearchDayshowByPeriod",
commandType: CommandType.StoredProcedure));
}
/// <summary>
/// Tìm kiếm các phim sẽ chiếu trong 1 khoảng thời gian
/// </summary>
/// <param name="requests"></param>
/// <returns></returns>
public async Task <IEnumerable <Film> > GetFilmsByPeriod(SeacrhDayRequests requests)
{
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@ToDate", requests.ToDate);
parameters.Add("@FromDate", requests.FromDate);
return(await SqlMapper.QueryAsync <Film>(cnn: conn,
param: parameters,
sql: "sp_SearchFilmByPeriod",
commandType: CommandType.StoredProcedure));
}
catch (Exception e)
{
throw e;
}
}
public Task <IEnumerable <Film> > GetFilmsByPeriod(SeacrhDayRequests requests)
{
return(filmRepository.GetFilmsByPeriod(requests));
}
public Task <IEnumerable <DayShow> > SearchDayshowByPeriod(SeacrhDayRequests requests)
{
return(showingRepository.SearchDayshowByPeriod(requests));
}
public async Task <IEnumerable <Film> > GetFilmsByPeriod(SeacrhDayRequests requests)
{
return(await filmService.GetFilmsByPeriod(requests));
}
public async Task <IEnumerable <DayShow> > SearchDayshowByPeriod(SeacrhDayRequests requests)
{
return(await showingService.SearchDayshowByPeriod(requests));
}
