public VehicleAdditionPriceSettingList GetList(int companyId, AdditionPriceType additionPriceType)
{
OQL oql = new OQL(typeof(VehicleAdditionPriceSetting));
oql.AddCondition(Condition.Eq(VehicleAdditionPriceSetting.Properties.OperatorId, companyId));
oql.AddCondition(Condition.Eq(VehicleAdditionPriceSetting.Properties.VAPSettingType, Convert.ToInt32(additionPriceType)));
return this.GetList(oql);
}
public FareTypeList GetFareTypeList(int operatorId, int fareCategoryId)
{
OQL oql = new OQL(typeof(FareType));
if (operatorId != 0)
oql.AddCondition(Condition.Eq(FareType.Properties.OperatorId, operatorId));
if (fareCategoryId != 0)
oql.AddCondition(Condition.Eq(FareType.Properties.CategoryId, fareCategoryId));
return new FareType().GetList(oql);
}
public RouteOrder GetPrimaryRouteOrder(int bookingId)
{
OQL oql = new OQL(typeof(RouteOrder));
oql.AddCondition(Condition.Eq(RouteOrder.Properties.BookingID, bookingId));
oql.AddCondition(Condition.Eq(RouteOrder.Properties.IsPrimary, true));
RouteOrderList list = new RouteOrder().GetList(oql);
if (list.Count >= 1)
return list[0];
else
return null;
}
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 static Fare GetFareForSchedule(int routeId, DateTime depDateTime)
{
OQL oql = new OQL(typeof(Fare));
oql.AddCondition(Condition.Eq(Fare.Properties.RoutesID, routeId));
oql.AddCondition(Condition.Le(Fare.Properties.StartDate, depDateTime));
oql.AddCondition(Condition.Ge(Fare.Properties.EndDate, depDateTime));
FareList list = new Fare().GetList(oql);
if (list.Count >= 1)
return list[0];
else
return null;
}
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 static Fare GetFareByRouteAndDateRange(int routeId, DateTime startDate, DateTime endDate)
{
OQL oql = new OQL(typeof(Fare));
oql.AddCondition(Condition.Eq(Fare.Properties.RoutesID, routeId));
oql.AddCondition(Condition.Eq(Fare.Properties.StartDate, startDate));
oql.AddCondition(Condition.Eq(Fare.Properties.EndDate, endDate));
FareList list = new Fare().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate fare record found.");
else
return null;
}
public static Schedule GetScheduleByValues(int vesselId, int fareId, DateTime sailingTime, DateTime arrivalTime)
{
OQL oql = new OQL(typeof(Schedule));
oql.AddCondition(Condition.Eq(Schedule.Properties.VesselId, vesselId));
oql.AddCondition(Condition.Eq(Schedule.Properties.FareId, fareId));
oql.AddCondition(Condition.Eq(Schedule.Properties.SailingTime, sailingTime));
oql.AddCondition(Condition.Eq(Schedule.Properties.ArrivalTime, arrivalTime));
ScheduleList list = new Schedule().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate Schedule Found");
else
return null;
}
public static FareItem GetFareItemByValues(int fareTypeId, int fareId, int rangeStart, int rangeEnd, decimal amount)
{
OQL oql = new OQL(typeof(FareItem));
oql.AddCondition(Condition.Eq(FareItem.Properties.FareTypeId, fareTypeId));
oql.AddCondition(Condition.Eq(FareItem.Properties.FareId, fareId));
oql.AddCondition(Condition.Eq(FareItem.Properties.RangeStart, rangeStart));
oql.AddCondition(Condition.Eq(FareItem.Properties.RangeEnd, rangeEnd));
oql.AddCondition(Condition.Eq(FareItem.Properties.Amount, amount));
FareItemList list = new FareItem().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate FareItem Found");
else
return null;
}
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 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 static Route GetRouteByPortId(string depPortId, string arrPortId, int operatorId)
{
OQL oql = new OQL(typeof(Route));
if (string.IsNullOrEmpty(depPortId) || string.IsNullOrEmpty(arrPortId) || operatorId <= 0)
return null;
oql.AddCondition(Condition.Eq(Route.Properties.OperatorId, operatorId));
oql.AddCondition(Condition.Eq(Route.Properties.DeparturePortId, depPortId));
oql.AddCondition(Condition.Eq(Route.Properties.ArriavlPortId, arrPortId));
RouteList list = new Route().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate route with same operator, departure port and arrival port found.");
else
return null;
}
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 static FareType GetFareTypeByValue(int operatorId, int categoryId, string fareTypeName, string fareTypeDesc)
{
OQL oql = new OQL(typeof(FareType));
if (string.IsNullOrEmpty(fareTypeName) || string.IsNullOrEmpty(fareTypeDesc) || operatorId <= 0 || categoryId <= 0)
return null;
oql.AddCondition(Condition.Eq(FareType.Properties.OperatorId, operatorId));
oql.AddCondition(Condition.Eq(FareType.Properties.CategoryId, categoryId));
oql.AddCondition(Condition.Eq(FareType.Properties.FareTypeName, fareTypeName));
oql.AddCondition(Condition.Eq(FareType.Properties.FareTypeDescription, fareTypeDesc));
FareTypeList list = new FareType().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate Fare Type Found");
else
return null;
}
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 static FareCategory GetCategoryByName(string categoryName)
{
OQL oql = new OQL(typeof(FareCategory));
if (!string.IsNullOrEmpty(categoryName))
oql.AddCondition(Condition.Eq(FareCategory.Properties.CategoryName, categoryName.Trim()));
FareCategoryList list = new FareCategory().GetList(oql);
if (list.Count == 1)
return list[0];
else if (list.Count > 1)
throw new Exception("Duplicate Fare Category found.");
else
return null;
}
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 static Company GetCompanyByShortName(string shortName)
{
OQL oql = new OQL(typeof(Company));
if (string.IsNullOrEmpty(shortName))
return null;
oql.AddCondition(Condition.Eq(Company.Properties.CompanyShortName, shortName));
CompanyList list = new Company().GetList(oql);
if (list.Count == 1)
return list[0];
else
return null;
}
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 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);
}
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 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);
}
