public IQueryOver <BusByDate, BusByDate> BusByDateGetAllByCriterionAndAllWay(DateTime?date, BusType busType, Route route)
{
var query = _session.QueryOver <BusByDate>();
var listRoute = RouteRepository.RouteGetAllById(route.Id).Future().ToList();
var listRouteId = listRoute.Select(x => x.Id).ToList();
if (date.HasValue)
{
query = query.Where(x => x.Date == date);
}
BusType busTypeAlias = null;
query = query.JoinAlias(x => x.BusType, () => busTypeAlias);
if (busType != null && busType.Id > 0)
{
query = query.Where(() => busTypeAlias.Id == busType.Id);
}
Route routeAlias = null;
query = query.JoinAlias(x => x.Route, () => routeAlias);
if (route != null && route.Id > 0)
{
query = query.AndRestrictionOn(() => routeAlias.Id).IsIn(listRouteId);
}
return(query);
}
public BusByDateRepository(ISession session)
: base(session)
{
RouteRepository = new RouteRepository();
ExpenseRepository = new ExpenseRepository();
CostTypeRepository = new CostTypeRepository();
ExpenseServiceRepository = new ExpenseServiceRepository();
}
public new void Dispose()
{
if (RouteRepository != null)
{
RouteRepository.Dispose();
RouteRepository = null;
}
if (ExpenseRepository != null)
{
ExpenseRepository.Dispose();
ExpenseRepository = null;
}
if (CostTypeRepository != null)
{
CostTypeRepository.Dispose();
CostTypeRepository = null;
}
if (ExpenseServiceRepository != null)
{
ExpenseServiceRepository.Dispose();
ExpenseServiceRepository = null;
}
base.Dispose();
}