コード例 #1
0
ファイル: SearchController.cs プロジェクト: Burima/LYSApp
 public ActionResult GetPGs(SearchViewModel searchViewModel)
 {
     if (searchViewModel !=null)
        {
        Session["SearchCriteria"] = searchViewModel;
        return View("Index", searchManagement.GetPGsBySearchCriteria(searchViewModel));
        }
        else
        {
        return RedirectToAction("Index", "Account");
        }
 }
コード例 #2
0
ファイル: SearchManagement.cs プロジェクト: Burima/LYSApp
        /// <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;
        }
コード例 #3
0
ファイル: SearchManagement.cs プロジェクト: Burima/LYSApp
        /// <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;
        }