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("删除失败"); }