public string Add(GolfReservationModel reservationModel)
{
var newGolfReservation = new Golf_Reservation()
{
Id = Guid.NewGuid().ToString(),
StartTime = reservationModel.StartTime,
PeopleNumber = reservationModel.NumberOfPeople,
Golf_Package = db.Golf_Package.Where(p => p.Id == reservationModel.GolfPackageId).FirstOrDefault(),
IsPaid = 0,
TotalPrice = reservationModel.TotalPrice,
Golf_Package_Id = reservationModel.GolfPackageId,
GolfHole = reservationModel.GolfHole
};
var member = db.Members.FirstOrDefault(m => m.Id == reservationModel.MemberId);
member.Golf_Reservation.Add(newGolfReservation);
newGolfReservation.Members.Add(member);
db.Golf_Reservation.Add(newGolfReservation);
newGolfReservation.Members.Add(member);
if (db.SaveChanges() > 0)
{
return("添加成功");
}
return("");
}
public string Update(Golf_Reservation golfReservation)
{
Golf_Reservation newGolfReservation = db.Golf_Reservation.Where(r => r.Id == golfReservation.Id).FirstOrDefault();
newGolfReservation.IsPaid = golfReservation.IsPaid;
db.Entry(newGolfReservation).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return("更新成功");
}
return("更新失败");
}
public string Delete(string golfReservationId, string memberId)
{
Golf_Reservation golfReservation = db.Golf_Reservation.FirstOrDefault(v => v.Id == golfReservationId);
Member member = golfReservation.Members.FirstOrDefault(m => m.Id == memberId);
if (golfReservation != null && member != null)
{
golfReservation.Members.Remove(member);
db.Golf_Reservation.Remove(golfReservation);
if (db.SaveChanges() > 0)
{
return("删除成功");
}
}
return("删除失败");
}
