public ActionResult BookingDone(int id) { CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel(); //For room List <CRoomViewModel> r_VM_lt = new List <CRoomViewModel>(); var a = dbSA.Room.Where(r => r.RoomStyleID == id); foreach (var item in a) { r_VM_lt.Add(new CRoomViewModel() { entity_room = item }); } abtRoom_VM.roomViewModels = r_VM_lt; // For roomstyle CRoomStyleViewModel roomsty_VM = new CRoomStyleViewModel(); List <CRoomStyleViewModel> rsty_VM_lt = new List <CRoomStyleViewModel>(); var b = dbSA.RoomStyle.Where(r => r.ID == id); foreach (var item in b) { rsty_VM_lt.Add(new CRoomStyleViewModel() { entity_roomstyle = item }); } abtRoom_VM.roomStyleViewModels = rsty_VM_lt; //for pic. CPictureViewModel roompic_VM = new CPictureViewModel(); List <CPictureViewModel> rpic_VM_lt = new List <CPictureViewModel>(); var c = dbSA.Picture.Where(r => r.ID == id); foreach (var item in c) { rpic_VM_lt.Add(new CPictureViewModel() { entity_picture = item }); } abtRoom_VM.roomPicViewModels = rpic_VM_lt; //for facility CFacilityViewModel facility_VM = new CFacilityViewModel(); List <CFacilityViewModel> facility_VM_lt = new List <CFacilityViewModel>(); var i = dbSA.RoomStyle.Where(r => r.ID == id).FirstOrDefault(); foreach (var item in i.RoomFacilities) { facility_VM_lt.Add(new CFacilityViewModel() { entity_Facility = item.Facility }); } abtRoom_VM.facilityViewModels = facility_VM_lt; return(View(abtRoom_VM)); }
//GET public ActionResult ListRoomDetail(int id) { CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel(); var result = from r in dbSA.Room join b in dbSA.BuildCase on r.BuildCaseID equals b.ID join rs in dbSA.RoomStyle on r.RoomStyleID equals rs.ID join rf in dbSA.RoomFacilities on rs.ID equals rf.RoomStyleID join f in dbSA.Facility on rf.FacilityID equals f.ID where r.ID == id select new { r = r, b = b, rs = rs, rf = rf, f = f }; List <CBuildCaseViewModel> buildcase_VM_lt = new List <CBuildCaseViewModel>(); List <CRoomViewModel> rooom_VM_lt = new List <CRoomViewModel>(); List <CRoomStyleViewModel> roomstyle_VM_lt = new List <CRoomStyleViewModel>(); List <CRoomFacilityViewModel> roomfacility_VM_lt = new List <CRoomFacilityViewModel>(); List <CFacilityViewModel> facility_VM_lt = new List <CFacilityViewModel>(); var test = result.ToList(); //有4個 foreach (var item in result) { CBuildCaseViewModel buildcase_VM = new CBuildCaseViewModel() { entity_buildcase = item.b }; buildcase_VM_lt.Add(buildcase_VM); CRoomStyleViewModel roomstyle_VM = new CRoomStyleViewModel() { entity_roomstyle = item.rs }; roomstyle_VM_lt.Add(roomstyle_VM); CRoomViewModel room_VM = new CRoomViewModel() { entity_room = item.r }; rooom_VM_lt.Add(room_VM); CRoomFacilityViewModel roomfacility_VM = new CRoomFacilityViewModel() { entity_roomfacilities = item.rf }; roomfacility_VM_lt.Add(roomfacility_VM); CFacilityViewModel facility_VM = new CFacilityViewModel() { entity_Facility = item.f }; facility_VM_lt.Add(facility_VM); } abtRoom_VM.buildcaseViewModels = buildcase_VM_lt; abtRoom_VM.roomfacilityViewModel = roomfacility_VM_lt; abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt; abtRoom_VM.roomViewModels = rooom_VM_lt; abtRoom_VM.facilityViewModels = facility_VM_lt; ViewData.Model = abtRoom_VM; return(View(abtRoom_VM)); }