public ActionResult MyRoom() { CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel(); var user = Session[CDictionary.welcome] as CMember; if (user == null) { return(RedirectToAction("Login", "Member")); } CMember member = Session[CDictionary.welcome] as CMember; int memberID = member.fMemberId; var result = from L in dbSA.Lease join R in dbSA.Room on L.RoomID equals R.ID where L.MemberID == memberID select new { L, R }; List <CRoomViewModel> List_Room = new List <CRoomViewModel>(); List <CLeaseViewModel> List_Lease = new List <CLeaseViewModel>(); var test = result.ToList(); foreach (var item in result) { CRoomViewModel ViewM_Room = new CRoomViewModel() { entity_room = item.R }; List_Room.Add(ViewM_Room); CLeaseViewModel ViewM_Lease = new CLeaseViewModel() { entity_lease = item.L }; List_Lease.Add(ViewM_Lease); } abtRoom_VM.roomViewModels = List_Room; abtRoom_VM.leaseViewModels = List_Lease; ViewData.Model = abtRoom_VM; return(View(abtRoom_VM)); }
//PartialRoomFavorite //public ActionResult PartialRoomFavorite(string MemberID, int page = 1, int pageSize = 6) //{ // SingleApartmentEntities db = new SingleApartmentEntities(); // var list = db.RoomFavorite.Where(r => r.MemberID.ToString() == MemberID); // int currentPage = page < 1 ? 1 : page; // List<CRoomFavorite> lt = new List<CRoomFavorite>(); // foreach (var item in list) // { // lt.Add(new CRoomFavorite { entity_RoomFavorite = item }); // } // var result = lt.ToPagedList(currentPage, pageSize); // ViewData.Model = result; // ViewBag.MemberID = MemberID; // return PartialView("_PartialRoomFavorite"); //} //GET public ActionResult ListRoomDetail(int id) { CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel(); var result = from r in dbSA.Room join rs in dbSA.RoomStyle on r.RoomStyleID equals rs.ID join b in dbSA.BuildCase on r.BuildCaseID equals b.ID where r.ID == id select new { r = r, b = b, rs = rs, }; 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); } List <CLeaseViewModel> lease_VM_lt = new List <CLeaseViewModel>(); var l_result = from l in dbSA.Lease select l; foreach (var litem in l_result) { CLeaseViewModel lease_VM = new CLeaseViewModel() { entity_lease = litem }; lease_VM_lt.Add(lease_VM); } CMember member = Session[CDictionary.welcome] as CMember; 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; abtRoom_VM.leaseViewModels = lease_VM_lt; ViewData.Model = abtRoom_VM; return(View(abtRoom_VM)); }