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));
}
