public RouteOrderList GetRouteOrderList(int bookingId) { OQL oql = new OQL(typeof(RouteOrder)); oql.AddCondition(Condition.Eq(RouteOrder.Properties.BookingID, bookingId)); oql.OrderBy(RouteOrder.Properties.IsPrimary); oql.OrderBy(RouteOrder.Properties.ID); return new RouteOrder().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 FareCategoryList GetAllList() { OQL oql = new OQL(typeof(FareCategory)); oql.OrderBy(FareCategory.Properties.CategoryName); return new FareCategory().GetList(oql); }
public RouteList GetAllList() { OQL oql = new OQL(typeof(Route)); oql.OrderBy(Route.Properties.OperatorId) .OrderBy(Route.Properties.DeparturePortId) .OrderBy(Route.Properties.ArriavlPortId); return new Route().GetList(oql); }
public CompanyList GetCompanyList(string companyName) { OQL oql = new OQL(typeof(Company)); if (!string.IsNullOrEmpty(companyName)) oql.AddCondition(Condition.Like(Company.Properties.CompanyName, companyName, LikeMode.Start)); oql.OrderBy(Company.Properties.CompanyName); return new Company().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 BookingList GetBookingList(int statusId, DateTime startDate, DateTime endDate) { OQL oql = new OQL(typeof(Booking)); if (statusId != 0) oql.AddCondition(Condition.Eq(Booking.Properties.Status, statusId)); oql.AddCondition(Condition.Ge(Booking.Properties.BookingDate, startDate)); oql.AddCondition(Condition.Le(Booking.Properties.BookingDate, endDate)); oql.OrderBy(Booking.Properties.BookingDate, OrderByDirect.Desc); return new Booking().GetList(oql); }
public ScheduleList GetScheduleList(int vesselId, int fareId, DateTime startTime, DateTime endTime) { OQL oql = new OQL(typeof(Schedule)); if (vesselId != 0) oql.AddCondition(Condition.Eq(Schedule.Properties.VesselId, vesselId)); if (fareId!=0) oql.AddCondition(Condition.Eq(Schedule.Properties.FareId, fareId)); oql.AddCondition(Condition.Ge(Schedule.Properties.SailingTime, startTime)); oql.AddCondition(Condition.Le(Schedule.Properties.SailingTime, endTime)); oql.OrderBy(Schedule.Properties.SailingTime, OrderByDirect.Desc); return new Schedule().GetList(oql); }
public ScheduleList GetAllList() { OQL oql = new OQL(typeof(Schedule)); oql.OrderBy(Schedule.Properties.VesselId).OrderBy(Schedule.Properties.FareId); return new Schedule().GetList(oql); }
public CompanyList GetAllList() { OQL oql = new OQL(typeof(Company)); oql.OrderBy(Company.Properties.CompanyName); return new Company().GetList(oql); }
public FareList GetAllList() { OQL oql = new OQL(typeof(Fare)); oql.OrderBy(Fare.Properties.RoutesID).OrderBy(Fare.Properties.StartDate); 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; }
public RouteList GetRouteList(int operatorId) { OQL oql = new OQL(typeof(Route)); if (operatorId != 0) oql.AddCondition(Condition.Eq(Route.Properties.OperatorId, operatorId)); oql.OrderBy(Route.Properties.DeparturePortId) .OrderBy(Route.Properties.ArriavlPortId); return new Route().GetList(oql); }