public ActionResult Searching()
{
CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel();
//建案
CBuildCaseViewModel buildcase_VM = new CBuildCaseViewModel();
List <CBuildCaseViewModel> buildcase_VM_lt = new List <CBuildCaseViewModel>();
var b = dbSA.BuildCase;
foreach (var item in b)
{
buildcase_VM_lt.Add(new CBuildCaseViewModel()
{
entity_buildcase = item
});
}
abtRoom_VM.buildcaseViewModels = buildcase_VM_lt;
//Roomstyle
CRoomStyleViewModel roomstyle_VM = new CRoomStyleViewModel();
List <CRoomStyleViewModel> roomstyle_VM_lt = new List <CRoomStyleViewModel>();
var rs = dbSA.RoomStyle;
foreach (var item in rs)
{
roomstyle_VM_lt.Add(new CRoomStyleViewModel()
{
entity_roomstyle = item
});
}
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
return(View(abtRoom_VM));
}
public ActionResult PartialResult(string buildcaseID, string roomstyleID, string peoplecount, string amountrent)
{
CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel();
var result = from t in dbSA.BuildCase
join r in dbSA.Room
on t.ID equals r.BuildCaseID
join rms in dbSA.RoomStyle
on r.RoomStyleID equals rms.ID
where t.ID == buildcaseID &&
r.RoomStyleID.ToString() == roomstyleID &&
rms.MaxNumberOfPeople.ToString() == peoplecount
//rms.Rent.ToString() == amountrent
select new { b = t, r = r, rms = rms };
List <CRoomStyleViewModel> roomstyle_VM_lt = new List <CRoomStyleViewModel>();
List <CBuildCaseViewModel> buildcase_VM_lt = new List <CBuildCaseViewModel>();
List <CRoomViewModel> room_VM_lt = new List <CRoomViewModel>();
var test = result.ToList();
foreach (var item in result)
{
CRoomStyleViewModel roomstyle_VM = new CRoomStyleViewModel()
{
entity_roomstyle = item.rms
};
roomstyle_VM_lt.Add(roomstyle_VM);
CBuildCaseViewModel buildcase_VM = new CBuildCaseViewModel()
{
entity_buildcase = item.b
};
buildcase_VM_lt.Add(buildcase_VM);
CRoomViewModel room_VM = new CRoomViewModel()
{
entity_room = item.r
};
room_VM_lt.Add(room_VM);
}
abtRoom_VM.buildcaseViewModels = buildcase_VM_lt;
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
abtRoom_VM.roomViewModels = room_VM_lt;
ViewData.Model = abtRoom_VM;
return(PartialView("_PartialSearchResult"));
}
public ActionResult ListAllRooms(
string buildcaseID, string roomname, string roomstyleID, string area)
{
CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel();
var result = from b in dbSA.BuildCase
join r in dbSA.Room
on b.ID equals r.BuildCaseID
join rms in dbSA.RoomStyle
on r.RoomStyleID equals rms.ID
where b.ID == buildcaseID &&
rms.ID.ToString() == roomstyleID
select new { b = b, r = r, rms = rms };
List <CBuildCaseViewModel> buildcase_VM_lt = new List <CBuildCaseViewModel>();
List <CRoomViewModel> rooom_VM_lt = new List <CRoomViewModel>();
List <CRoomStyleViewModel> roomstyle_VM_lt = new List <CRoomStyleViewModel>();
var test = result.ToList();
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.rms
};
roomstyle_VM_lt.Add(roomstyle_VM);
CRoomViewModel room_VM = new CRoomViewModel()
{
entity_room = item.r
};
rooom_VM_lt.Add(room_VM);
}
abtRoom_VM.buildcaseViewModels = buildcase_VM_lt;
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
abtRoom_VM.roomViewModels = rooom_VM_lt;
ViewData.Model = abtRoom_VM;
return(View(abtRoom_VM));
}
public ActionResult Searching(
string buildcaseID, string roomstyleID, string peoplecount, string amountrent)
{
CAboutRoomViewModel abtRoom_VM = new CAboutRoomViewModel();
#region Find room by buildcase
CBuildCaseViewModel buildcase_VM = new CBuildCaseViewModel();
List <CBuildCaseViewModel> buildcase_VM_lt = new List <CBuildCaseViewModel>();
var b = dbSA.BuildCase.Where(r => r.ID == buildcaseID);
foreach (var item in b)
{
buildcase_VM_lt.Add(new CBuildCaseViewModel()
{
entity_buildcase = item
});
}
abtRoom_VM.buildcaseViewModels = buildcase_VM_lt;
#endregion
#region Find room by roomstyle
CRoomStyleViewModel roomstyle_VM = new CRoomStyleViewModel();
List <CRoomStyleViewModel> roomstyle_VM_lt = new List <CRoomStyleViewModel>();
var rs = dbSA.RoomStyle.Where(i => i.ID.ToString() == roomstyleID);
foreach (var item in rs)
{
roomstyle_VM_lt.Add(new CRoomStyleViewModel()
{
entity_roomstyle = item
});
}
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
#endregion
#region Find room by peoplecount
var p = dbSA.RoomStyle.Where(t => t.MaxNumberOfPeople.ToString() == peoplecount);
foreach (var item in p)
{
roomstyle_VM_lt.Add(new CRoomStyleViewModel()
{
entity_roomstyle = item
});
}
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
#endregion
#region Find room by rent
var a = dbSA.RoomStyle.Where(f => f.Rent.ToString() == amountrent);
foreach (var item in a)
{
roomstyle_VM_lt.Add(new CRoomStyleViewModel()
{
entity_roomstyle = item
});
}
abtRoom_VM.roomStyleViewModels = roomstyle_VM_lt;
#endregion
ViewData.Model = abtRoom_VM;
ViewBag.amountrent = amountrent;
ViewBag.peoplecount = peoplecount;
ViewBag.buildcaseID = buildcaseID;
ViewBag.roomstyleID = roomstyleID;
return(RedirectToAction("ListAllRooms",
new
{
buildcaseID = buildcaseID,
roomstyleID = roomstyleID,
peoplecount = peoplecount,
amountrent = amountrent
}));
}
//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));
}
//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));
}
