/// <summary> /// 根据酒店id获取酒店评论 /// </summary> /// <param name="hotelId"></param> /// <returns></returns> public List <HotelComment> GetHotelCommentsByHotelId(Guid hotelId) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; List <HotelComment> hotelComments = dbContext.Hotels.Find(hotelId).HotelComments; return(hotelComments); }
/// <summary> /// 根据酒店id获取酒店图片 /// </summary> /// <param name="hotelId"></param> /// <returns></returns> public List <HotelImage> GetHotelImagesByHotelId(Guid hotelId) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; List <HotelImage> hotelImages = dbContext.Hotels.Find(hotelId).HotelImages; return(hotelImages); }
/// <summary> /// 根据酒店评论id获取酒店评论 /// </summary> /// <param name="id"></param> /// <returns></returns> public HotelComment GetHotelCommentByKey(Guid hotelId, Guid id) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; HotelComment hotelComment = dbContext.Hotels.Find(hotelId).HotelComments.Where(account => account.Id.Equals(id)).FirstOrDefault(); return(hotelComment); }
/// <summary> /// 根据房间id获取房间图片 /// </summary> /// <param name="RoomId"></param> /// <returns></returns> public List <RoomImage> GetRoomImagesByRoomId(Guid roomId) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; List <RoomImage> roomImages = dbContext.Rooms.Find(roomId).RoomImages; return(roomImages); }
/// <summary> /// 根据酒店名称获取活动图片 /// </summary> /// <param name="hotelName"></param> /// <returns></returns> public List <PromotionImage> GetPromotionImagesByHotelName(string hotelName) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Hotel hotel = dbContext.Hotels.Find(Specification <Hotel> .Eval(h => h.Name.Equals(hotelName))); return(this.Find(Specification <THotelPromotion> .Eval(h => h.HotelId.Equals(hotel.Id))).PromotionImages); }
/// <summary> /// 根据酒店图片id获取酒店图片 /// </summary> /// <param name="hotelId"></param> /// <param name="id"></param> /// <returns></returns> public HotelImage GetHotelImageByKey(Guid hotelId, Guid id) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; HotelImage hotelImage = dbContext.Hotels.Find(hotelId).HotelImages.Where(image => image.Id.Equals(id)).FirstOrDefault(); return(hotelImage); }
/// <summary> /// 根据房间图片id获取房间图片 /// </summary> /// <param name="id"></param> /// <returns></returns> public RoomImage GetRoomImageByKey(Guid roomId, Guid id) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; RoomImage roomImage = dbContext.Rooms.Find(roomId).RoomImages.Where(Image => Image.Id.Equals(id)).FirstOrDefault(); return(roomImage); }
/// <summary> /// 删除酒店图片 /// </summary> /// <param name="id">需要删除的酒店图片id值</param> public void DeleteHotelImage(Guid hotelId, List <string> ids) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Hotel hotel = dbContext.Hotels.Find(hotelId); hotel.HotelImages.RemoveAll(item => ids.Contains(item.Id.ToString())); this.Context.RegisterModify <Hotel>(hotel); this.Context.Commit(); }
public void DeleteCustomerAccount(Guid userId, List <CustomerAccount> customerAccounts) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Customer customer = dbContext.Customer.Find(userId); customer.CustomerAccount.RemoveAll(item => customerAccounts.Select(a => a.Id).Contains(item.Id)); this.Context.RegisterModify <Customer>(customer); this.Context.Commit(); }
public void AddCustomerAccount(Guid userId, List <CustomerAccount> customerAccounts) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Customer customer = dbContext.Customer.Find(userId); customer.CustomerAccount.AddRange(customerAccounts); this.Context.RegisterModify <Customer>(customer); this.Context.Commit(); }
/// <summary> /// 删除房间图片 /// </summary> /// <param name="ids">需要删除的房间图片id值</param> public void DeleteRoomImage(Guid roomId, List <string> ids) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Room room = dbContext.Rooms.Find(roomId); room.RoomImages.RemoveAll(item => ids.Contains(item.Id.ToString())); this.Update(room); this.Context.Commit(); }
/// <summary> /// 删除活动图片 /// </summary> /// <param name="ids">需要删除的活动图片id值</param> public void DeletePromotionImage(Guid PromotionId, List <string> ids) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; HotelPromotion hotelPromotion = dbContext.HotelPromotions.Find(PromotionId); hotelPromotion.PromotionImages.RemoveAll(item => ids.Contains(item.Id.ToString())); this.Context.RegisterModify <HotelPromotion>(hotelPromotion); this.Context.Commit(); }
/// <summary> /// 根据酒店Id获取预定信息 /// </summary> /// <param name="hotelId"></param> /// <returns></returns> public List <Reservation> GetReservationsForHotel(Guid hotelId) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; var query = from r in dbContext.Rooms join res in dbContext.Reservations on r.Id equals res.RoomId where r.HotelId.Equals(hotelId) select res; return(query.ToList()); }
/// <summary> /// 更新酒店图片 /// </summary> /// <param name="hotelImages"></param> /// <returns></returns> public List <HotelImage> UpdateHotelImage(Guid hotelId, List <HotelImage> hotelImages) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Hotel hotel = dbContext.Hotels.Find(hotelId); List <HotelImage> listHotelImage = hotel.HotelImages; foreach (HotelImage updatehotelImage in hotelImages) { for (int i = 0; i < listHotelImage.Count; i++) { if (listHotelImage[i].Id.Equals(updatehotelImage.Id)) { listHotelImage[i] = updatehotelImage; } } } this.Context.RegisterModify <Hotel>(hotel); this.Context.Commit(); return(hotelImages); }
public List <CustomerAccount> UpdateCustomerAccount(Guid userId, List <CustomerAccount> customerAccounts) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Customer customer = dbContext.Customer.Find(userId); List <CustomerAccount> listCustomerAccount = customer.CustomerAccount; foreach (CustomerAccount updatecustomerAccount in customerAccounts) { for (int i = 0; i < customerAccounts.Count; i++) { if (customerAccounts[i].Id.Equals(updatecustomerAccount.Id)) { customerAccounts[i] = updatecustomerAccount; } } } this.Context.RegisterModify <Customer>(customer); this.Context.Commit(); return(customerAccounts); }
/// <summary> /// 更新活动图片 /// </summary> /// <param name="PromotionImage"></param> /// <returns></returns> public List <PromotionImage> UpdatePromotionImage(Guid PromotionId, List <PromotionImage> PromotionImages) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; HotelPromotion hotelPromotion = dbContext.HotelPromotions.Find(PromotionId); List <PromotionImage> listPromotionImage = hotelPromotion.PromotionImages; foreach (PromotionImage updatePromotionImage in PromotionImages) { for (int i = 0; i < listPromotionImage.Count; i++) { if (listPromotionImage[i].Id.Equals(updatePromotionImage.Id)) { listPromotionImage[i] = updatePromotionImage; } } } this.Context.RegisterModify <HotelPromotion>(hotelPromotion); this.Context.Commit(); return(PromotionImages); }
/// <summary> /// 更新酒店评论 /// </summary> /// <param name="HotelComments"></param> /// <returns></returns> public List <HotelComment> UpdateHotelComment(Guid hotelId, List <HotelComment> HotelComments) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Hotel hotel = dbContext.Hotels.Find(hotelId); List <HotelComment> listHotelComment = hotel.HotelComments; foreach (HotelComment updateHotelComment in HotelComments) { for (int i = 0; i < listHotelComment.Count; i++) { if (listHotelComment[i].Id.Equals(updateHotelComment.Id)) { listHotelComment[i] = updateHotelComment; } } } this.Context.RegisterModify <Hotel>(hotel); this.Context.Commit(); return(HotelComments); }
/// <summary> /// 更新房间图片 /// </summary> /// <param name="RoomImages"></param> /// <returns></returns> public List <RoomImage> UpdateRoomImage(Guid roomId, List <RoomImage> RoomImages) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; Room room = dbContext.Rooms.Find(roomId); List <RoomImage> listRoomImage = room.RoomImages; foreach (RoomImage updateRoomImage in RoomImages) { for (int i = 0; i < listRoomImage.Count; i++) { if (listRoomImage[i].Id.Equals(updateRoomImage.Id)) { listRoomImage[i] = updateRoomImage; } } } // this.Context.RegisterModify<Room>(room); this.Update(room); this.Context.Commit(); return(RoomImages); }
public List <Reservation> GetReservationsByUserName(string userName) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; return(dbContext.Customer.Where(new UserNameEqualsSpecification <Customer>(userName).GetExpression()).FirstOrDefault().Reservations); }
/// <summary> /// 获取所有活动图片 /// </summary> /// <returns></returns> public List <PromotionImage> GetPromotionImages(Guid PromotionId) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; return(dbContext.HotelPromotions.Find(PromotionId).PromotionImages); }
/// <summary> /// 根据活动图片id获取活动图片 /// </summary> /// <param name="id"></param> /// <returns></returns> public PromotionImage GetPromotionImageByKey(Guid PromotionId, Guid id) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; return(dbContext.HotelPromotions.Find(PromotionId).PromotionImages.Where(a => a.Id.Equals(id)).FirstOrDefault()); }
/// <summary> /// 根据房间名称获取预定 /// </summary> /// <param name="roomName"></param> /// <returns></returns> public List <Reservation> GetReservationsByRoomName(string roomName) { JXHotelDbContext dbContext = this.EFContext.dbContext as JXHotelDbContext; return(dbContext.Rooms.Where(new RoomNameEqualSpecification(roomName).GetExpression()).FirstOrDefault().Reservations); }