public List <ComplexWithHouses> GetAllComplexWithHousesSorted()
        {
            List <ComplexWithHouses> complexListSorted = ComplexAccess.SelectAllComplexWithHouses()
                                                         .OrderBy(s => s.City)
                                                         .ThenBy(s => s.StatusConstructionHousingComplexName)
                                                         .ToList();

            var houseList = new ObservableCollection <House>(HouseAccess.SelectAllHouse());

            foreach (var complex in complexListSorted)
            {
                int count = houseList.Count(x => x.IdComplex.Equals(complex.IdComplex));

                complex.HouseCount = count;
            }

            return(complexListSorted ?? new List <ComplexWithHouses>());
        }
        public List <ComplexWithHouses> GetAllComplexWithHouses()
        {
            List <ComplexWithHouses> complexList = ComplexAccess.SelectAllComplexWithHouses();

            return(complexList ?? new List <ComplexWithHouses>());
        }