public JsonResult Details(string Id)
{
QDTourAdminEntities db = new QDTourAdminEntities();
var result = from guideReservation in db.Guide_Reservation
from member in guideReservation.Members
join guidePackage in db.Guide_Package on guideReservation.ID_Guide_Package equals guidePackage.Id
join guide in db.Guides on guideReservation.ID_Guide equals guide.Id
where guideReservation.Id == Id
select new
{
guideReservationId = guideReservation.Id,
memberName = member.Name,
email = member.Email,
startTime = guideReservation.Start_Time,
endTime = guideReservation.End_Time,
numberOfPeople = guideReservation.People_Number,
isPaid = guideReservation.IsPaid,
guideId = guide.Id,
Photo = guidePackage.Photo,
totalPrice = guideReservation.TotalPrice,
destination = guidePackage.Destination
};
var aa = from guideReservation in db.Guide_Reservation
from member in guideReservation.Members
join guidePackage in db.Guide_Package on guideReservation.ID_Guide_Package equals guidePackage.Id
where guideReservation.Id == Id
select new
{
guideReservationId = guideReservation.Id,
memberName = member.Name,
email = member.Email,
startTime = guideReservation.Start_Time,
endTime = guideReservation.End_Time,
numberOfPeople = guideReservation.People_Number,
isPaid = guideReservation.IsPaid,
Photo = guidePackage.Photo,
totalPrice = guideReservation.TotalPrice,
destination = guidePackage.Destination,
};
if (result.Count() == 0)
{
return(Json(aa, JsonRequestBehavior.AllowGet));
}
return(Json(result, JsonRequestBehavior.AllowGet));
}