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; }