public RouteOrderVehicleDetailList GetVehicleListByRoute(int routeOrderId)
{
OQL oql = new OQL(typeof(RouteOrderVehicleDetail));
RouteOrderVehicleDetail v = new RouteOrderVehicleDetail();
oql.AddAssociation("RouteOrderDetail", "rod")
.AddCondition(Condition.Eq("rod.RouteOrderID", routeOrderId));
oql.AddAssociation("RouteOrderDetail.FareType", "ft")
.AddCondition(Condition.Eq("ft.CategoryId", 2));
return new RouteOrderVehicleDetail().GetList(oql);
}
public RouteOrderDetailList GetListByRoute(int categoryId)
{
OQL oql = new OQL(typeof(RouteOrderDetail));
oql.AddAssociation("FareType", "ft")
.AddCondition(Condition.Eq("ft.CategoryId", categoryId));
oql.AddCondition(Condition.Eq(RouteOrderDetail.Properties.RouteOrderID, this.ID));
return new RouteOrderDetail().GetList(oql);
}
public RouteOrderPassengerDetailList GetPassengerList(int bookingId)
{
OQL oql = new OQL(typeof(RouteOrderPassengerDetail));
if (bookingId != 0)
oql.AddAssociation("RouteOrder", "ro")
.AddCondition(Condition.Eq("ro.BookingID", bookingId));
oql.OrderBy(RouteOrderPassengerDetail.Properties.RouteOrderID);
oql.OrderBy(RouteOrderPassengerDetail.Properties.IsLeader);
return new RouteOrderPassengerDetail().GetList(oql);
}
public FareItemList GetFareItemList(int categoryId, int fareId)
{
OQL oql = new OQL(typeof(FareItem));
if (categoryId != 0)
oql.AddAssociation("FareType", "ft")
.AddCondition(Condition.Eq("ft.CategoryId", categoryId));
if (fareId != 0)
oql.AddCondition(Condition.Eq(FareItem.Properties.FareId, fareId));
return new FareItem().GetList(oql);
}
public RouteOrderPassengerDetailList GetPassengerListByRoute(int routeOrderId)
{
//RouteOrderPassengerDetail r = new RouteOrderPassengerDetail();
//r.FareType.CategoryId
OQL oql = new OQL(typeof(RouteOrderPassengerDetail));
if (routeOrderId != 0)
oql.AddAssociation("FareType", "ft")
//.AddAssociation("Category", "c")
.AddCondition(Condition.Eq("ft.CategoryId", 3));
oql.AddCondition(Condition.Eq(RouteOrderPassengerDetail.Properties.RouteOrderID, routeOrderId));
oql.OrderBy(RouteOrderPassengerDetail.Properties.IsLeader, OrderByDirect.Desc);
return new RouteOrderPassengerDetail().GetList(oql);
}
public RouteOrderPassengerDetail GetPrimaryPassenger(int bookingId)
{
OQL oql = new OQL(typeof(RouteOrderPassengerDetail));
if (bookingId != 0)
{
oql.AddAssociation("RouteOrder", "ro")
.AddCondition(Condition.Eq("ro.BookingID", bookingId));
oql.AddCondition(Condition.Eq(RouteOrderPassengerDetail.Properties.IsLeader, true));
}
else
{
return null;
}
RouteOrderPassengerDetailList list = new RouteOrderPassengerDetail().GetList(oql);
if (list.Count >= 1)
return list[0];
return null;
}
public FareList GetFareList(int operatorId, int routeId, DateTime startDate, DateTime endDate)
{
OQL oql = new OQL(typeof(Fare));
if (operatorId != 0)
oql.AddAssociation("Routes", "r")
.AddCondition(Condition.Eq("r.OperatorId", operatorId));
if (routeId != 0)
oql.AddCondition(Condition.Eq(Fare.Properties.RoutesID, routeId));
oql.AddCondition(Condition.Ge(Fare.Properties.StartDate, startDate));
oql.AddCondition(Condition.Le(Fare.Properties.EndDate, endDate));
return new Fare().GetList(oql);
}
public DataTable GetRouteTable()
{
OQL oql = new OQL(typeof(Route));
oql.AddAssociation("Operator");
oql.AddAssociation("DeparturePort");
oql.AddAssociation("ArriavlPort");
oql.SelectProperty(Route.Properties.ID);
oql.SelectProperty("Operator." + Company.Properties.ID);
oql.SelectProperty("Operator." + Company.Properties.CompanyShortName);
oql.SelectProperty("DeparturePort." + Port.Properties.PortName);
oql.SelectProperty("ArriavlPort." + Port.Properties.PortName);
oql.AddCondition(Condition.Disjunction()
.AddCondition(Condition.IsNull(Route.Properties.IsActive))
.AddCondition(Condition.Eq(Route.Properties.IsActive, true))
);
oql.OrderBy("DeparturePort." + Port.Properties.PortName)
.OrderBy("ArriavlPort." + Port.Properties.PortName);
DataTable dt = Dao.GetTable(oql);
return dt;
}
