public FareCategoryList GetAllList() { OQL oql = new OQL(typeof(FareCategory)); oql.OrderBy(FareCategory.Properties.CategoryName); return new FareCategory().GetList(oql); }
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 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 SubOQLCondition(OQL subOQL, SubQueryOP subQueryOP, SubQueryQuantifier subQueryQuantifier,string propertyName,object value) { _subOQL = subOQL; _subQueryOP = subQueryOP; _subQueryQuantifier = subQueryQuantifier; _propertyName = propertyName; _value = value; }
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 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 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 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 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 ScheduleList GetScheduleListForRoute(int routeId,DateTime startdate) { OQL oql = new OQL(typeof(Schedule)) .AddAssociation("Fare","Fare") .AddCondition(Condition.Eq("Fare."+ Fare.Properties.RoutesID, routeId)) .AddCondition(Condition.Ge(Schedule.Properties.SailingTime,startdate)) .OrderBy(Schedule.Properties.SailingTime); return new Schedule().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 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 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 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 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 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 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 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 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 RouteOrderVehicleDetail GetUnique(OQL oql) { return Dao.GetUnique(oql); }
public RouteOrderVehicleDetailList GetList(OQL oql, int startRow, int pageSize) { return Dao.GetList(oql, startRow, pageSize); }
public VehicleType GetUnique(OQL oql) { return Dao.GetUnique(oql); }
public RouteOrderVehicleDetailList GetList(OQL oql) { return Dao.GetList(oql); }
public SubOQLCondition(OQL subOQL, SubQueryOP subQueryOP, SubQueryQuantifier subQueryQuantifier) { _subOQL = subOQL; _subQueryOP = subQueryOP; _subQueryQuantifier = subQueryQuantifier; }