public string Add(ReservationModel reservationModel)
{
var newGuideReservation = new Guide_Reservation()
{
Id = Guid.NewGuid().ToString(),
Start_Time = reservationModel.StartTime,
End_Time = reservationModel.EndTime,
People_Number = reservationModel.NumberOfPeople,
ID_Guide_Package = reservationModel.GuidePackageId,
IsPaid = 0,
TotalPrice = reservationModel.TotalPrice,
Guide_Package = db.Guide_Package.Where(p => p.Id == reservationModel.GuidePackageId).FirstOrDefault()
};
var member = db.Members.FirstOrDefault(m => m.Id == reservationModel.MemberId);
member.Guide_Reservation.Add(newGuideReservation);
newGuideReservation.Members.Add(member);
db.Guide_Reservation.Add(newGuideReservation);
newGuideReservation.Members.Add(member);
if (db.SaveChanges() > 0)
{
return("添加成功");
}
return("");
}
public string Update(Guide_Reservation guideReservation)
{
Guide_Reservation newGuideReservation = db.Guide_Reservation.Where(r => r.Id == guideReservation.Id).FirstOrDefault();
if (guideReservation.ID_Guide == "choose")
{
newGuideReservation.ID_Guide = null;
newGuideReservation.IsPaid = guideReservation.IsPaid;
newGuideReservation.People_Number = guideReservation.People_Number;
newGuideReservation.TotalPrice = guideReservation.TotalPrice;
}
else
{
newGuideReservation.ID_Guide = guideReservation.ID_Guide;
newGuideReservation.IsPaid = guideReservation.IsPaid;
newGuideReservation.People_Number = guideReservation.People_Number;
newGuideReservation.TotalPrice = guideReservation.TotalPrice;
}
db.Entry(newGuideReservation).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return("更新成功");
}
return("更新失败");
}
public string Delete(string guideReservationId, string memberId)
{
Guide_Reservation guideReservation = db.Guide_Reservation.FirstOrDefault(r => r.Id == guideReservationId);
Member member = guideReservation.Members.FirstOrDefault(m => m.Id == memberId);
if (guideReservation != null && member != null)
{
guideReservation.Members.Remove(member);
db.Guide_Reservation.Remove(guideReservation);
if (db.SaveChanges() > 0)
{
return("删除成功");
}
}
return("删除失败");
}
