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