public List <PayingGuestHouse> GetAllPgs() { var pgs = (from pg in _dbContext.tbl_pgsb_paying_guest_homestay select new PayingGuestHouse { PGFullName = pg.name, AddressLine1 = pg.address_line_1, AddressLine2 = pg.address_line_2, DetailedDescription = pg.incharge_person_details, IsInCharge = !string.IsNullOrEmpty(pg.incharge_id), OwnerName = pg.owner_name, PhoneNumber = pg.contact_phone_number, Email = pg.email_id, PGMasterId = Guid.Parse(pg.pg_id), //PointOfContact = pg.tbl_pgsb_users. Area = new Area(CodeValues.GetCodeValue("Area", pg.area_code), CodeValues.GetCodeValue("pincode", Convert.ToInt32(pg.pin_code))), PGType = new PGTypeGenderWise(CodeValues.GetCodeValue("pgtype", pg.pg_type_code)), //PointOfContact //pg.tbl_pgsb_pg_amenities.ToList().ForEach( //a => //{ // Amenities.Add(CodeValues.GetCodeValue("PGAmenity", a.amenity_code)); //}), } ); return(pgs.ToList()); }