public string Update(Hotel_Reservation hotelReservation)
{
Hotel_Reservation newHotelReservation = db.Hotel_Reservation.Where(r => r.Id == hotelReservation.Id).FirstOrDefault();
newHotelReservation.IsPaid = hotelReservation.IsPaid;
db.Entry(newHotelReservation).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return("更新成功");
}
return("更新失败");
}
public string Delete(string hotelReservationId, string memberId)
{
Hotel_Reservation hotelReservation = db.Hotel_Reservation.FirstOrDefault(v => v.Id == hotelReservationId);
Member member = hotelReservation.Members.FirstOrDefault(m => m.Id == memberId);
if (hotelReservation != null && member != null)
{
hotelReservation.Members.Remove(member);
db.Hotel_Reservation.Remove(hotelReservation);
if (db.SaveChanges() > 0)
{
return("删除成功");
}
}
return("删除失败");
}
public string Add(HotelReservationModel reservationModel)
{
if (HttpContext.Session["logedIn"] == null)
{
return("need login");
}
var hotelPackage = db.Hotel_Package.Where(h => h.Id == reservationModel.HotelPackageId).FirstOrDefault();
var hotelId = hotelPackage.ID_Hotel;
var newHotelReservation = new Hotel_Reservation()
{
Id = Guid.NewGuid().ToString(),
StartTime = reservationModel.StartTime,
EndTime = reservationModel.EndTime,
ID_Package = reservationModel.HotelPackageId,
IsPaid = 0,
TotalPrice = reservationModel.TotalPrice,
Hotel_Package = db.Hotel_Package.Where(p => p.Id == reservationModel.HotelPackageId).FirstOrDefault(),
RoomType = reservationModel.RoomType
};
var member = db.Members.FirstOrDefault(m => m.Id == reservationModel.MemberId);
member.Hotel_Reservation.Add(newHotelReservation);
newHotelReservation.Members.Add(member);
db.Hotel_Reservation.Add(newHotelReservation);
newHotelReservation.Members.Add(member);
if (db.SaveChanges() > 0)
{
return("添加成功");
}
return("添加失败");
}
public int[] AddReservationRooms(String hotelCode, DateTime checkIn, DateTime checkOut, String roomTypeCode, int roomsRequested)
{
using (var scope = new TransactionScope())
{
if (HotelIsFull(hotelCode, checkIn, checkOut, roomTypeCode, roomsRequested))
{
throw new HotelFullException();
}
var reservations = new Hotel_Reservation[roomsRequested];
for (var i = 0; i < roomsRequested; i++)
{
var reservation = new Hotel_Reservation();
reservation.hotel_code = hotelCode;
reservation.checkin_date = checkIn;
reservation.checkout_date = checkOut;
reservation.room_type_code = roomTypeCode;
db.Hotel_Reservations.InsertOnSubmit(reservation);
reservations[i] = reservation;
}
db.SubmitChanges();
scope.Complete();
return reservations.Select(m => m.reservation_id).ToArray<int>();
}
}
