public string Delete(string vehicleReservationId, string memberId)
{
Vehicle_Reservation vehicleReservation = db.Vehicle_Reservation.FirstOrDefault(v => v.Id == vehicleReservationId);
Member member = vehicleReservation.Members.FirstOrDefault(m => m.Id == memberId);
if (vehicleReservation != null && member != null)
{
vehicleReservation.Members.Remove(member);
db.Vehicle_Reservation.Remove(vehicleReservation);
if (db.SaveChanges() > 0)
{
return("删除成功");
}
}
return("删除失败");
}
public string Update(Vehicle_Reservation vehicleReservation)
{
Vehicle_Reservation newVehicleReservation = db.Vehicle_Reservation.Where(r => r.Id == vehicleReservation.Id).FirstOrDefault();
newVehicleReservation.IsPaid = vehicleReservation.IsPaid;
newVehicleReservation.People_Number = vehicleReservation.People_Number;
newVehicleReservation.TotalPrice = vehicleReservation.TotalPrice;
newVehicleReservation.Type = vehicleReservation.Type;
db.Entry(newVehicleReservation).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return("更新成功");
}
return("更新失败");
}
public string Add(VehicleReservationModel reservationModel)
{
if (HttpContext.Session["logedIn"] == null)
{
return("need login");
}
var newVehicleReservation = new Vehicle_Reservation()
{
Id = Guid.NewGuid().ToString(),
Start_Time = reservationModel.StartTime,
End_Time = reservationModel.EndTime,
People_Number = reservationModel.NumberOfPeople,
ID_Vehicle_Package = reservationModel.GuidePackageId,
IsPaid = 0,
TotalPrice = reservationModel.TotalPrice,
Vehicle_Package = db.Vehicle_Package.Where(p => p.Id == reservationModel.GuidePackageId).FirstOrDefault(),
Type = reservationModel.VehicleType
};
var member = db.Members.FirstOrDefault(m => m.Id == reservationModel.MemberId);
member.Vehicle_Reservation.Add(newVehicleReservation);
newVehicleReservation.Members.Add(member);
db.Vehicle_Reservation.Add(newVehicleReservation);
newVehicleReservation.Members.Add(member);
if (db.SaveChanges() > 0)
{
return("添加成功");
}
return("");
}
