public ActionResult GetPGs(SearchViewModel searchViewModel)
{
if (searchViewModel !=null)
{
Session["SearchCriteria"] = searchViewModel;
return View("Index", searchManagement.GetPGsBySearchCriteria(searchViewModel));
}
else
{
return RedirectToAction("Index", "Account");
}
}
/// <summary>
/// This methos provides all the type of houeses group by MonthlyRent
/// for a specific PG based on PGID
/// </summary>
/// <param name="PGDetailsID">PGID of the PG selected</param>
/// <returns>List of Houses of the PG selected</returns>
public PropertyDetailsViewModel GetPropertyDetails(int PGDetailsID, SearchViewModel searchViewModel)
{
var propertyDetailsViewModel = (from pg in pgDetailRepository.Get()
join a in apartmentRepository.Get() on pg.PGDetailID equals a.PGDetailID
join x in blockRepository.Get() on a.ApartmentID equals x.ApartmentID
join h in houseRepository.Get() on x.BlockID equals h.BlockID
join r in roomRepository.Get() on h.HouseID equals r.HouseID
join b in bedRepository.Get() on r.RoomID equals b.RoomID
join pgreview in pgReviewsRepository.Get() on pg.PGDetailID equals pgreview.PGDetailID
where pg.PGDetailID == PGDetailsID //selected area
// h.Status!=null && h.Status==true && h.Gender==searchViewModel.Gender &&//status active for House
// r.Status!=null && r.Status==true && //Status active for Room
// b.Status != null && b.Status == true && b.BedStatus == (int)Constants.Bed_Status.Vacant && ((b.UserID==0)||(((DateTime)b.BookingToDate-searchViewModel.BookingFromDate).Days>=30))//Status active for Bed and bed is empty (zero)
select new PropertyDetailsViewModel
{
PGDetailID = pg.PGDetailID,
PGName = pg.PGName,
Latitude = pg.Latitude,
Longitude = pg.Longitude,
Address = pg.Address,
Landmark = pg.Landmark,
PGReviews = (from review in pg.PGReviews
select new Model.PGReview
{
Comments = review.Comments,
Rating = review.Rating
}).ToList(),
HouseList = (from p in x.Houses
select new Model.House
{
HouseID = p.HouseID,
HouseName = p.HouseName,
Gender = p.Gender,
NoOfBalconnies = p.NoOfBalconnies,
NoOfBathrooms = p.NoOfBathrooms,
HouseAmenities = (from g in p.HouseAmenities
select new LYSApp.Model.HouseAmenity
{
HouseAmenityID = g.HouseAmenityID,
AC = g.AC,
Aquaguard = g.Aquaguard,
AttachBathrooms = g.AttachBathrooms,
BreakFastGiven = g.BreakFastGiven,
Clubhouse = g.Clubhouse,
CommonTV = g.CommonTV,
CreatedOn = g.CreatedOn,
DinnerGiven = g.DinnerGiven,
EmergencyMedicalServices = g.EmergencyMedicalServices,
FourWheelerCloseParking = g.FourWheelerCloseParking,
FourWheelerOpenParking = g.FourWheelerOpenParking,
Fridge = g.Fridge,
GuardianEntry = g.GuardianEntry,
GYM = g.GYM,
HotColdWaterSupply = g.HotColdWaterSupply,
Housekeeping = g.Housekeeping,
IndividualTV = g.IndividualTV,
IntercomFacility = g.IntercomFacility,
IroningWashingServices = g.IroningWashingServices,
KitchenFacilityWithGas = g.KitchenFacilityWithGas,
LCDTVCableConnection = g.LCDTVCableConnection,
Lift = g.Lift,
Lockers = g.Lockers,
LunchGiven = g.LunchGiven,
MineralDrinkingWater = g.MineralDrinkingWater,
Newspaper = g.Newspaper,
NoBoysEntry = g.NoBoysEntry,
NoDrinking = g.NoDrinking,
NoSmoking = g.NoSmoking,
NonVegAllowed = g.NonVegAllowed,
Partyhall = g.Partyhall,
Playground = g.Playground,
Powerbackup = g.Powerbackup,
RoomService = g.RoomService,
Security = g.Security,
SwimmingPool = g.SwimmingPool,
TwoWheelerCloseParking = g.TwoWheelerCloseParking,
TwoWheelerOpenParking = g.TwoWheelerOpenParking,
VideoSurveillance = g.VideoSurveillance,
Wardrobes = g.Wardrobes,
Washingmachine = g.Washingmachine,
WaterSupply = g.WaterSupply,
Wifi = g.Wifi
}).ToList(),
HouseImages = (from i in p.HouseImages
select new LYSApp.Model.HouseImage
{
HouseImageID = i.HouseImageID,
ImagePath = i.ImagePath
}).ToList(),
Rooms = (from room in p.Rooms.GroupBy(m => m.MonthlyRent).Select(y => y.FirstOrDefault()) //grouped rooms by MonthlyRent
select new LYSApp.Model.Room
{
RoomID = room.RoomID,
RoomNumber = room.RoomNumber,
MonthlyRent = room.MonthlyRent,
Deposit = room.Deposit,
NoOfBeds = room.NoOfBeds
}).ToList()//roomList
}).ToList(),//houseList
}).FirstOrDefault();
return propertyDetailsViewModel;
}
/// <summary>
/// This methods returns list of PGs filtered by Search Criteria
/// </summary>
/// <param name="searchViewModel">contains search criteria</param>
/// <returns>List of PGs</returns>
public IList<SearchResultViewModel> GetPGsBySearchCriteria(SearchViewModel searchViewModel)
{
var modelPGs = (from pg in pgDetailRepository.Get()
join a in apartmentRepository.Get() on pg.PGDetailID equals a.PGDetailID
join blk in blockRepository.Get() on a.ApartmentID equals blk.ApartmentID
join h in houseRepository.Get() on blk.BlockID equals h.BlockID
join r in roomRepository.Get() on h.HouseID equals r.HouseID
join b in bedRepository.Get() on r.RoomID equals b.RoomID
where pg.AreaID == searchViewModel.AreaID && blk.BlockID>0//selected area
// h.Status!=null && h.Status==true && h.Gender==searchViewModel.Gender &&//status active for House
// r.Status!=null && r.Status==true && //Status active for Room
// b.Status != null && b.Status == true && b.BedStatus == (int)Constants.Bed_Status.Vacant && ((b.UserID==0)||(((DateTime)b.BookingToDate-searchViewModel.BookingFromDate).Days>=30))//Status active for Bed and bed is empty (zero)
//group pg by pg.PGDetailID into pg
select new SearchResultViewModel
{
PGDetailID = pg.PGDetailID,
PGName = pg.PGName,
Latitude = pg.Latitude,
Longitude = pg.Longitude,
Address = pg.Address,
PGReviews = (from review in pg.PGReviews
select new Model.PGReview
{
PGReviewID = review.PGReviewID,
PGDetailID = pg.PGDetailID,
Rating = review.Rating,
}).ToList(),//get all ratings
MinimumRentHouse = (from p in blk.Houses//order house with minimum MonthlRent first
select new Model.House
{
BlockID = p.BlockID,
//PGDetailID = p.PGDetailID,
HouseAmenities = (from amenity in p.HouseAmenities
select new LYSApp.Model.HouseAmenity
{
HouseAmenityID = amenity.HouseAmenityID,
HouseID = p.HouseID,
AC = amenity.AC,
Fridge = amenity.Fridge
}).ToList(),
HouseImages = (from i in p.HouseImages
select new LYSApp.Model.HouseImage
{
HouseImageID = i.HouseImageID,
HouseID = p.HouseID,
ImagePath = i.ImagePath
}).ToList(),//get all house images
Rooms = (from room in p.Rooms.OrderBy(y => y.MonthlyRent)//order Rooms with minimum MonthlRent
select new LYSApp.Model.Room
{
RoomID = room.RoomID,
MonthlyRent = room.MonthlyRent,
HouseID = p.HouseID
//NoOfBeds = room.NoOfBeds
}).ToList(),//get all rooms
}).FirstOrDefault()
}).Where(h => h.MinimumRentHouse != null && h.MinimumRentHouse.Rooms != null && h.MinimumRentHouse.Rooms.Count() > 0).GroupBy(x => x.PGDetailID).Select(y => y.FirstOrDefault() ).ToList();
return modelPGs;
}