Example #1
0
        public IHttpActionResult PostToiletType(ToiletType toiletType)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.ToiletTypes.Add(toiletType);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (ToiletTypeExists(toiletType.Id))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = toiletType.Id }, toiletType));
        }
Example #2
0
        /// <summary>
        /// получает объект для сохранения с уровня представления и создает по нему объект Apartment и сохраняет его в базу данных.
        /// </summary>
        /// <param name="appartmentDto"></param>
        public void MakeAdvert(ApartmentDTO appartmentDto)
        {
            Salesman salesman = Database.Salesmans.Get(appartmentDto.SalesmanId);

            // валидация
            if (salesman == null)
            {
                throw new ValidationException("Арендодатель не найден", "");
            }

            // смотрим состояние проплаченных сервисов арендодателя
            bool salesmanPayedState = new SalesmanState(30.0).GetSalesmanPayedState(salesman.PayedDate);

            // применяем автомаппер для проекции HouseDTO на House
            Mapper.Initialize(cfg => cfg.CreateMap <HouseDTO, House>());
            House house = Mapper.Map <HouseDTO, House>(appartmentDto.House);

            Mapper.Initialize(cfg => cfg.CreateMap <ToiletTypeDTO, ToiletType>());
            ToiletType toiletType = Mapper.Map <ToiletTypeDTO, ToiletType>(appartmentDto.ToiletType);

            Mapper.Initialize(cfg => cfg.CreateMap <BalconyDTO, Balcony>());
            Balcony balcony = Mapper.Map <BalconyDTO, Balcony>(appartmentDto.Balcony);

            Mapper.Initialize(cfg => cfg.CreateMap <RepairTypeDTO, RepairType>());
            RepairType repairType = Mapper.Map <RepairTypeDTO, RepairType>(appartmentDto.RepairType);

            Mapper.Initialize(cfg => cfg.CreateMap <ElevatorDTO, Elevator>());
            Elevator elevator = Mapper.Map <ElevatorDTO, Elevator>(appartmentDto.Elevator);

            // применяем автомаппер для проекции одной коллекции на другую
            Mapper.Initialize(cfg => cfg.CreateMap <ApartmentIncludeDTO, ApartmentInclude>());
            var includes = Mapper.Map <IEnumerable <ApartmentIncludeDTO>, List <ApartmentInclude> >(appartmentDto.ApartmentIncludes);

            Mapper.Initialize(cfg => cfg.CreateMap <ImagesIncludeDTO, ImagesInclude>());
            var images = Mapper.Map <IEnumerable <ImagesIncludeDTO>, List <ImagesInclude> >(appartmentDto.ImagesIncludes);

            Apartment apartment = new Apartment
            {
                PublishDate        = DateTime.Now,
                Salesman           = salesman,
                SalesmanPayedState = salesmanPayedState,
                Price             = appartmentDto.Price,
                PriceInfo         = appartmentDto.PriceInfo,
                Floor             = appartmentDto.Floor,
                TotalArea         = appartmentDto.TotalArea,
                LivingArea        = appartmentDto.LivingArea,
                KitchenArea       = appartmentDto.KitchenArea,
                OtherInfo         = appartmentDto.OtherInfo,
                House             = house,
                ToiletType        = toiletType,
                Balcony           = balcony,
                RepairType        = repairType,
                Elevator          = elevator,
                ApartmentIncludes = includes,
                ImagesIncludes    = images
            };

            Database.Apartments.Create(apartment);
            Database.Save();
        }
Example #3
0
        public IHttpActionResult PutToiletType(int id, ToiletType toiletType)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != toiletType.Id)
            {
                return(BadRequest());
            }

            db.Entry(toiletType).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!ToiletTypeExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Example #4
0
        public IHttpActionResult GetToiletType(int id)
        {
            ToiletType toiletType = db.ToiletTypes.Find(id);

            if (toiletType == null)
            {
                return(NotFound());
            }

            return(Ok(toiletType));
        }
Example #5
0
 protected override void UpdateValuesFromConcreteModel()
 {
     TotalSquare       = DbEntity.TotalSquare.HasValue ? DbEntity.TotalSquare.Value.ToString("0.#") : String.Empty;
     KitchenSquare     = DbEntity.KitchenSquare.HasValue ? DbEntity.KitchenSquare.Value.ToString("0.#") : String.Empty;
     ResidentialSquare = DbEntity.ResidentialSquare.HasValue ? DbEntity.ResidentialSquare.Value.ToString("0.#") : String.Empty;
     TotalRoomCount    = DbEntity.TotalRoomCount.HasValue ? DbEntity.TotalRoomCount.Value.ToString() : String.Empty;
     TotalFloor        = DbEntity.TotalFloor.HasValue ? DbEntity.TotalFloor.Value.ToString() : String.Empty;
     Floor             = DbEntity.Floor.HasValue ? DbEntity.Floor.Value.ToString() : String.Empty;
     Terrace.MoveCurrentTo(DbEntity.Terrace);
     Material.MoveCurrentTo(DbEntity.Material);
     Layout.MoveCurrentTo(DbEntity.Layout);
     FloorLevel.MoveCurrentTo(DbEntity.FloorLevel);
     ToiletType.MoveCurrentTo(DbEntity.ToiletType);
 }
Example #6
0
        public IHttpActionResult DeleteToiletType(int id)
        {
            ToiletType toiletType = db.ToiletTypes.Find(id);

            if (toiletType == null)
            {
                return(NotFound());
            }

            db.ToiletTypes.Remove(toiletType);
            db.SaveChanges();

            return(Ok(toiletType));
        }
        private static void AddDicitonaryValue(bool addRealEstate = false)
        {
            var dealVariantEntityNew = new DealVariant("dealVariant1");

            if (dealVariantService.IsValid(dealVariantEntityNew))
            {
                dealVariantService.Save(dealVariantEntityNew);
            }

            var dealVariantEntityNew2 = new DealVariant("dealVariant2");

            if (dealVariantService.IsValid(dealVariantEntityNew2))
            {
                dealVariantService.Save(dealVariantEntityNew2);
            }
            var dealVariantEntityNew3 = new DealVariant("dealVariant2");

            if (dealVariantService.IsValid(dealVariantEntityNew3))
            {
                dealVariantService.Save(dealVariantEntityNew3);
            }

            var districtEntityNew = new District("district1");

            if (districtService.IsValid(districtEntityNew))
            {
                districtService.Save(districtEntityNew);
            }

            var districtEntityNew2 = new District("district2");

            if (districtService.IsValid(districtEntityNew2))
            {
                districtService.Save(districtEntityNew2);
            }
            var districtEntityNew3 = new District("district2");

            if (districtService.IsValid(districtEntityNew3))
            {
                districtService.Save(districtEntityNew3);
            }

            var floorLevelEntityNew = new FloorLevel("floorLevel1");

            if (floorLevelService.IsValid(floorLevelEntityNew))
            {
                floorLevelService.Save(floorLevelEntityNew);
            }

            var floorLevelEntityNew2 = new FloorLevel("floorLevel2");

            if (floorLevelService.IsValid(floorLevelEntityNew2))
            {
                floorLevelService.Save(floorLevelEntityNew2);
            }
            var floorLevelEntityNew3 = new FloorLevel("floorLevel2");

            if (floorLevelService.IsValid(floorLevelEntityNew3))
            {
                floorLevelService.Save(floorLevelEntityNew3);
            }

            var layoutEntityNew = new Layout("layout1");

            if (layoutService.IsValid(layoutEntityNew))
            {
                layoutService.Save(layoutEntityNew);
            }

            var layoutEntityNew2 = new Layout("layout2");

            if (layoutService.IsValid(layoutEntityNew2))
            {
                layoutService.Save(layoutEntityNew2);
            }
            var layoutEntityNew3 = new Layout("layout2");

            if (layoutService.IsValid(layoutEntityNew3))
            {
                layoutService.Save(layoutEntityNew3);
            }

            var materialEntityNew = new Material("material1");

            if (materialService.IsValid(materialEntityNew))
            {
                materialService.Save(materialEntityNew);
            }

            var materialEntityNew2 = new Material("material2");

            if (materialService.IsValid(materialEntityNew2))
            {
                materialService.Save(materialEntityNew2);
            }
            var materialEntityNew3 = new Material("material2");

            if (materialService.IsValid(materialEntityNew3))
            {
                materialService.Save(materialEntityNew3);
            }

            var ownershipEntityNew = new Ownership("ownership1");

            if (ownershipService.IsValid(ownershipEntityNew))
            {
                ownershipService.Save(ownershipEntityNew);
            }

            var ownershipEntityNew2 = new Ownership("ownership2");

            if (ownershipService.IsValid(ownershipEntityNew2))
            {
                ownershipService.Save(ownershipEntityNew2);
            }
            var ownershipEntityNew3 = new Ownership("ownership2");

            if (ownershipService.IsValid(ownershipEntityNew3))
            {
                ownershipService.Save(ownershipEntityNew3);
            }

            var realtorEntityNew = new Realtor("realtor1", "phone");

            if (realtorService.IsValid(realtorEntityNew))
            {
                realtorService.Save(realtorEntityNew);
            }

            var realtorEntityNew2 = new Realtor("realtor2", "phone");

            if (realtorService.IsValid(realtorEntityNew2))
            {
                realtorService.Save(realtorEntityNew2);
            }
            var realtorEntityNew3 = new Realtor("realtor2", "phone");

            if (realtorService.IsValid(realtorEntityNew3))
            {
                realtorService.Save(realtorEntityNew3);
            }

            var sewageEntityNew = new Sewage("sewage1");

            if (sewageService.IsValid(sewageEntityNew))
            {
                sewageService.Save(sewageEntityNew);
            }

            var sewageEntityNew2 = new Sewage("sewage2");

            if (sewageService.IsValid(sewageEntityNew2))
            {
                sewageService.Save(sewageEntityNew2);
            }
            var sewageEntityNew3 = new Sewage("sewage2");

            if (sewageService.IsValid(sewageEntityNew3))
            {
                sewageService.Save(sewageEntityNew3);
            }

            var streetEntityNew = new Street("street1");

            if (streetService.IsValid(streetEntityNew))
            {
                districtEntityNew.AddStreet(streetEntityNew);
                districtService.Save(districtEntityNew);
            }

            var streetEntityNew1 = new Street("street11");

            if (streetService.IsValid(streetEntityNew1))
            {
                districtEntityNew.AddStreet(streetEntityNew1);
                districtService.Save(districtEntityNew);
            }

            var streetEntityNew2 = new Street("street2");

            if (streetService.IsValid(streetEntityNew2))
            {
                districtEntityNew2.AddStreet(streetEntityNew2);
                streetService.Save(streetEntityNew);
            }

            var streetEntityNew3 = new Street("street2");

            if (streetService.IsValid(streetEntityNew3))
            {
                Debug.Assert(false, "Не должан была пройти валидация.");
            }

            var terraceEntityNew = new Terrace("terrace1");

            if (terraceService.IsValid(terraceEntityNew))
            {
                terraceService.Save(terraceEntityNew);
            }

            var terraceEntityNew2 = new Terrace("terrace2");

            if (terraceService.IsValid(terraceEntityNew2))
            {
                terraceService.Save(terraceEntityNew2);
            }
            var terraceEntityNew3 = new Terrace("terrace2");

            if (terraceService.IsValid(terraceEntityNew3))
            {
                terraceService.Save(terraceEntityNew3);
            }

            var toiletTypeEntityNew = new ToiletType("toiletType1");

            if (toiletTypeService.IsValid(toiletTypeEntityNew))
            {
                toiletTypeService.Save(toiletTypeEntityNew);
            }

            var toiletTypeEntityNew2 = new ToiletType("toiletType2");

            if (toiletTypeService.IsValid(toiletTypeEntityNew2))
            {
                toiletTypeService.Save(toiletTypeEntityNew2);
            }
            var toiletTypeEntityNew3 = new ToiletType("toiletType2");

            if (toiletTypeService.IsValid(toiletTypeEntityNew3))
            {
                toiletTypeService.Save(toiletTypeEntityNew3);
            }

            var waterSupplyEntityNew = new WaterSupply("waterSupply1");

            if (waterSupplyService.IsValid(waterSupplyEntityNew))
            {
                waterSupplyService.Save(waterSupplyEntityNew);
            }

            var waterSupplyEntityNew2 = new WaterSupply("waterSupply2");

            if (waterSupplyService.IsValid(waterSupplyEntityNew2))
            {
                waterSupplyService.Save(waterSupplyEntityNew2);
            }
            var waterSupplyEntityNew3 = new WaterSupply("waterSupply2");

            if (waterSupplyService.IsValid(waterSupplyEntityNew3))
            {
                waterSupplyService.Save(waterSupplyEntityNew3);
            }
            if (!addRealEstate)
            {
                return;
            }

            var flat = new Flat
            {
                DealVariant       = dealVariantEntityNew,
                Description       = "decr",
                District          = districtEntityNew,
                Floor             = 3,
                FloorLevel        = floorLevelEntityNew,
                HasVideo          = true,
                KitchenSquare     = 32,
                Layout            = layoutEntityNew,
                Material          = materialEntityNew,
                Ownership         = ownershipEntityNew,
                Price             = 32323,
                Realtor           = realtorEntityNew,
                ResidentialSquare = 323,
                Street            = streetEntityNew,
                SubmitToDomino    = false,
                SubmitToVDV       = true,
                Terrace           = terraceEntityNew,
                TerritorialNumber = "32a",
                ToiletType        = toiletTypeEntityNew,
                TotalFloor        = 32,
                TotalRoomCount    = 5,
                TotalSquare       = 323
            };

            if (flatService.IsValid(flat))
            {
                flatService.Save(flat);
            }

            var room = new Room
            {
                DealVariant       = dealVariantEntityNew,
                Description       = "decr",
                District          = districtEntityNew,
                Floor             = 3,
                FloorLevel        = floorLevelEntityNew,
                HasVideo          = true,
                Layout            = layoutEntityNew,
                Material          = materialEntityNew,
                Ownership         = ownershipEntityNew,
                Price             = 32323,
                Realtor           = realtorEntityNew,
                Street            = streetEntityNew,
                SubmitToDomino    = false,
                SubmitToVDV       = true,
                Terrace           = terraceEntityNew,
                TerritorialNumber = "32a",
                TotalFloor        = 32,
                TotalRoomCount    = 5,
                TotalSquare       = 323,
                RoomCount         = 2
            };

            if (roomService.IsValid(room))
            {
                roomService.Save(room);
            }

            var residence = new Residence
            {
                DealVariant       = dealVariantEntityNew,
                Description       = "decr",
                District          = districtEntityNew,
                Floor             = 3,
                HasVideo          = true,
                Material          = materialEntityNew,
                Ownership         = ownershipEntityNew,
                Price             = 32323,
                Realtor           = realtorEntityNew,
                Street            = streetEntityNew,
                SubmitToDomino    = false,
                SubmitToVDV       = true,
                TerritorialNumber = "32a",
                TotalFloor        = 32,
                TotalSquare       = 323
            };

            if (residenceService.IsValid(residence))
            {
                residenceService.Save(residence);
            }

            var house = new House
            {
                DealVariant       = dealVariantEntityNew,
                Description       = "decr",
                District          = districtEntityNew,
                HasVideo          = true,
                Material          = materialEntityNew,
                Ownership         = ownershipEntityNew,
                Price             = 32323,
                Realtor           = realtorEntityNew,
                Street            = streetEntityNew,
                SubmitToDomino    = false,
                SubmitToVDV       = true,
                TerritorialNumber = "32a",
                TotalFloor        = 32,
                HasBathhouse      = true,
                HasGarage         = true,
                HasGas            = true,
                HouseSquare       = 342,
                PlotSquare        = 123,
                Sewage            = sewageEntityNew,
                WaterSupply       = waterSupplyEntityNew
            };

            if (houseService.IsValid(house))
            {
                houseService.Save(house);
            }
            var plot = new Plot
            {
                DealVariant       = dealVariantEntityNew,
                Description       = "decr",
                District          = districtEntityNew,
                HasVideo          = true,
                Ownership         = ownershipEntityNew,
                Price             = 32323,
                Realtor           = realtorEntityNew,
                Street            = streetEntityNew,
                SubmitToDomino    = false,
                SubmitToVDV       = true,
                TerritorialNumber = "32a",
                PlotSquare        = 123
            };

            if (plotService.IsValid(plot))
            {
                plotService.Save(plot);
            }
        }
Example #8
0
        // DropCreateDatabaseAlways  <->  DropCreateDatabaseIfModelChanges
        protected override void Seed(RentContext db)
        {
            // Salesmans
            Salesman sale1 = new Salesman {
                RegisterDate = DateTime.Now.AddYears(-1), PayedDate = DateTime.Now.AddDays(-35), Name = "Иванов И.И.", Email = "*****@*****.**", PhoneNumber = "+7 926 750-00-88"
            };
            Salesman sale2 = new Salesman {
                RegisterDate = DateTime.Now.AddMonths(-10), PayedDate = DateTime.Now.AddDays(-25), Name = "Петров П.П.", Email = "*****@*****.**", PhoneNumber = "+7 921 750-55-00"
            };
            Salesman sale3 = new Salesman {
                RegisterDate = DateTime.Now.AddMonths(-2), PayedDate = DateTime.Now.AddDays(-15), Name = "Сидоров С.С.", Email = "*****@*****.**", PhoneNumber = "+7 926 760-33-33"
            };

            db.Salesmans.AddRange(new List <Salesman> {
                sale1, sale2, sale3
            });
            db.SaveChanges();

            // BuildingTypes
            BuildingType build1 = new BuildingType {
                Name = "кирпичный"
            };
            BuildingType build2 = new BuildingType {
                Name = "панельный"
            };
            BuildingType build3 = new BuildingType {
                Name = "монолитный"
            };

            db.BuildingTypes.AddRange(new List <BuildingType> {
                build1, build2, build3
            });
            db.SaveChanges();

            // Houses
            House house1 = new House {
                Address = "Сиреневый проезд 14К2", Year = 1969, Floors = 12, BuildingType = build1
            };
            House house2 = new House {
                Address = "Кирпичный переулок 18К5", Year = 1979, Floors = 10, BuildingType = build2
            };
            House house3 = new House {
                Address = "1-я Парковая 67", Year = 1988, Floors = 25, BuildingType = build3
            };

            db.Houses.AddRange(new List <House> {
                house1, house2, house3
            });
            db.SaveChanges();


            // ToiletTypes
            ToiletType toilet1 = new ToiletType {
                Name = "совмещенный"
            };
            ToiletType toilet2 = new ToiletType {
                Name = "раздельный"
            };

            db.ToiletTypes.AddRange(new List <ToiletType> {
                toilet1, toilet2
            });
            db.SaveChanges();


            // Balconies
            Balcony balcony1 = new Balcony {
                Name = "балкон"
            };
            Balcony balcony2 = new Balcony {
                Name = "лоджия"
            };
            Balcony balcony3 = new Balcony {
                Name = "балкон + лоджия"
            };

            db.Balconies.AddRange(new List <Balcony> {
                balcony1, balcony2, balcony3
            });
            db.SaveChanges();



            // RepairTypes
            RepairType repair1 = new RepairType {
                Name = "косметический"
            };
            RepairType repair2 = new RepairType {
                Name = "евроремонт"
            };
            RepairType repair3 = new RepairType {
                Name = "дизайнерский"
            };
            RepairType repair4 = new RepairType {
                Name = "без ремонта"
            };

            db.RepairTypes.AddRange(new List <RepairType> {
                repair1, repair2, repair3, repair4
            });
            db.SaveChanges();

            // Elevator
            Elevator elevator1 = new Elevator {
                Name = "обычный"
            };
            Elevator elevator2 = new Elevator {
                Name = "грузовой"
            };
            Elevator elevator3 = new Elevator {
                Name = "обычный + грузовой"
            };

            db.Elevators.AddRange(new List <Elevator> {
                elevator1, elevator2, elevator3
            });
            db.SaveChanges();

            // ApartmentIncludes
            ApartmentInclude include1 = new ApartmentInclude {
                Name = "мебель"
            };
            ApartmentInclude include2 = new ApartmentInclude {
                Name = "холодильник"
            };
            ApartmentInclude include3 = new ApartmentInclude {
                Name = "стиральная машина"
            };
            ApartmentInclude include4 = new ApartmentInclude {
                Name = "интернет"
            };
            ApartmentInclude include5 = new ApartmentInclude {
                Name = "телевизор"
            };
            ApartmentInclude include6 = new ApartmentInclude {
                Name = "кондиционер"
            };
            ApartmentInclude include7 = new ApartmentInclude {
                Name = "посудомоечная машина"
            };
            ApartmentInclude include8 = new ApartmentInclude {
                Name = "телефон"
            };
            ApartmentInclude include9 = new ApartmentInclude {
                Name = "ванна"
            };

            db.ApartmentIncludes.AddRange(new List <ApartmentInclude> {
                include1, include2, include3, include4, include5, include6, include7, include8, include9
            });
            db.SaveChanges();


            // Images for apartments
            ImagesInclude img01 = new ImagesInclude {
                Name = "вид 1", Path = "..//Content//207-1.jpg"
            };
            ImagesInclude img02 = new ImagesInclude {
                Name = "вид 2", Path = "..//Content//207-2.jpg"
            };
            ImagesInclude img03 = new ImagesInclude {
                Name = "вид 3", Path = "..//Content//207-3.jpg"
            };
            ImagesInclude img04 = new ImagesInclude {
                Name = "вид 1", Path = "..//Content//208-1.jpg"
            };
            ImagesInclude img05 = new ImagesInclude {
                Name = "вид 2", Path = "..//Content//208-2.jpg"
            };
            ImagesInclude img06 = new ImagesInclude {
                Name = "вид 3", Path = "..//Content//208-3.jpg"
            };
            ImagesInclude img07 = new ImagesInclude {
                Name = "вид 4", Path = "..//Content//208-4.jpg"
            };
            ImagesInclude img08 = new ImagesInclude {
                Name = "вид 1", Path = "..//Content//209-1.jpg"
            };
            ImagesInclude img09 = new ImagesInclude {
                Name = "вид 2", Path = "..//Content//209-2.jpg"
            };

            db.ImagesIncludes.AddRange(new List <ImagesInclude> {
                img01, img02, img03, img04, img05, img06, img07, img08, img09
            });
            db.SaveChanges();


            // Apartments
            Apartment apt1 = new Apartment {
                PublishDate        = DateTime.Now.AddDays(-2),
                Salesman           = sale1,
                SalesmanPayedState = true,
                Price             = 20000m,
                PriceInfo         = "на длительный срок (от года), коммунальные платежи включены (кроме счетчиков)",
                Floor             = 1,
                TotalArea         = 36m,
                LivingArea        = 20m,
                KitchenArea       = 10m,
                OtherInfo         = "Сдаётся квартира ПОСЛЕ КАЧЕСТВЕННОГО РЕМОНТА.",
                House             = house1,
                ToiletType        = toilet1,
                Balcony           = balcony1,
                RepairType        = repair1,
                Elevator          = elevator1,
                ApartmentIncludes = new List <ApartmentInclude> {
                    include1, include4, include9
                },
                ImagesIncludes = new List <ImagesInclude> {
                    img01, img02, img03
                }
            };

            Apartment apt2 = new Apartment {
                PublishDate        = DateTime.Now.AddDays(-1),
                Salesman           = sale2,
                SalesmanPayedState = true,
                Price             = 21000m,
                PriceInfo         = "1 мес. предоплата + залог 10 000 руб., комиссия 25%",
                Floor             = 10,
                TotalArea         = 38m,
                LivingArea        = 22m,
                KitchenArea       = 9m,
                OtherInfo         = "Укомплектована минимумом мебели. Быт техника в наличии.",
                House             = house2,
                ToiletType        = toilet2,
                Balcony           = balcony2,
                RepairType        = repair1,
                Elevator          = elevator2,
                ApartmentIncludes = new List <ApartmentInclude> {
                    include2, include5, include8
                },
                ImagesIncludes = new List <ImagesInclude> {
                    img04, img05, img06, img07
                }
            };

            Apartment apt3 = new Apartment {
                PublishDate        = DateTime.Now.AddHours(-10),
                Salesman           = sale3,
                SalesmanPayedState = true,
                Price             = 20000m,
                PriceInfo         = "на длительный срок (от года)+ залог 20 000 руб., комиссия 50%",
                Floor             = 12,
                TotalArea         = 30m,
                LivingArea        = 18m,
                KitchenArea       = 8m,
                OtherInfo         = "Санузел совмещен. Балкона нет. Сдадим приличным, платежеспособным.",
                House             = house3,
                ToiletType        = toilet1,
                Balcony           = balcony3,
                RepairType        = repair4,
                Elevator          = elevator3,
                ApartmentIncludes = new List <ApartmentInclude> {
                    include1, include3, include4, include7, include8
                },
                ImagesIncludes = new List <ImagesInclude> {
                    img08, img09
                }
            };

            db.Apartments.AddRange(new List <Apartment> {
                apt1, apt2, apt3
            });
            db.SaveChanges();
        }
Example #9
0
        private static void MoveDictionary(ISession hb, DataClassesDataContext linq)
        {
            //DealVariant
            _idDictionaryMaps.Add(typeof(DealVariant), new List <IdMap>());
            foreach (var curEnitie in linq.Variants)
            {
                var hbEntity = new DealVariant(curEnitie.vcVariant);
                AddMapForDictionary(curEnitie.idVariant, hb, hbEntity);
            }
            Console.WriteLine("Сделки - готово");

            //District
            _idDictionaryMaps.Add(typeof(RealEstateDirectory.Domain.Entities.Dictionaries.District), new List <IdMap>());
            foreach (var curEnitie in linq.Districts)
            {
                var hbEntity = new RealEstateDirectory.Domain.Entities.Dictionaries.District(curEnitie.vcDistrict);
                AddMapForDictionary(curEnitie.idDistrict, hb, hbEntity);
            }
            Console.WriteLine("Районы - готово");

            //Layout
            _idDictionaryMaps.Add(typeof(Layout), new List <IdMap>());
            foreach (var curEnitie in linq.Planings)
            {
                var hbEntity = new Layout(curEnitie.vcPlaning);
                AddMapForDictionary(curEnitie.idPlaning, hb, hbEntity);
            }
            Console.WriteLine("Планировки - готово");

            //Material
            _idDictionaryMaps.Add(typeof(Material), new List <IdMap>());
            foreach (var curEnitie in linq.WallMatherials)
            {
                var hbEntity = new Material(curEnitie.vcWallMatherial);
                AddMapForDictionary(curEnitie.idWallMatherial, hb, hbEntity);
            }
            Console.WriteLine("Материалы - готово");

            //Realtor
            _idDictionaryMaps.Add(typeof(Realtor), new List <IdMap>());
            foreach (var curEnitie in linq.Rielters)
            {
                var hbEntity = new Realtor(curEnitie.vcName, curEnitie.vcContacts);
                AddMapForDictionary(curEnitie.idRielter, hb, hbEntity);
            }
            Console.WriteLine("Риэлторы - готово");

            //Street
            _idDictionaryMaps.Add(typeof(RealEstateDirectory.Domain.Entities.Dictionaries.Street), new List <IdMap>());
            using (var helper = new DataResolveHelper(hb))
            {
                helper.IdDictionaryMaps = _idDictionaryMaps;
                foreach (var curEnitie in linq.Streets)
                {
                    if (curEnitie.idDistrict.HasValue)
                    {
                        var hbEntity    = new RealEstateDirectory.Domain.Entities.Dictionaries.Street(curEnitie.vcStreet);
                        var hDistrictId =
                            helper.ResolveHbId <RealEstateDirectory.Domain.Entities.Dictionaries.District>(curEnitie.idDistrict.Value);

                        var distictH = hb.Get <RealEstateDirectory.Domain.Entities.Dictionaries.District>(hDistrictId);
                        hbEntity.District = distictH;
                        AddMapForDictionary(curEnitie.idStreet, hb, hbEntity);
                    }
                }
                Console.WriteLine("Улицы - готово");
            }

            //Terrace
            _idDictionaryMaps.Add(typeof(Terrace), new List <IdMap>());
            foreach (var curEnitie in linq.Balconies)
            {
                var hbEntity = new Terrace(curEnitie.vcBalcony);
                AddMapForDictionary(curEnitie.idBalcony, hb, hbEntity);
            }
            Console.WriteLine("Балконы - готово");

            //ToiletType
            _idDictionaryMaps.Add(typeof(ToiletType), new List <IdMap>());
            foreach (var curEnitie in linq.SanUsels)
            {
                var hbEntity = new ToiletType(curEnitie.vcSanUsel);
                AddMapForDictionary(curEnitie.idSanUsel, hb, hbEntity);
            }
            Console.WriteLine("Сан узел - готово");

            //Агентства
            _idDictionaryMaps.Add(typeof(RealtorAgency), new List <IdMap>());
            foreach (var curEnitie in linq.Agencies)
            {
                var hbEntity = new RealtorAgency(curEnitie.vcName)
                {
                    Address     = curEnitie.vcAddress,
                    Contacts    = curEnitie.vcContacts,
                    Description = curEnitie.vcComments,
                    Director    = curEnitie.vcDirectorName
                };

                AddMapForDictionary(curEnitie.idAgency, hb, hbEntity);
            }
            Console.WriteLine("Агентства - готово");
        }
Example #10
0
 public bool IsPossibleToDeleteToiletType(ToiletType entity)
 {
     return(CurrentSession.Query <Flat>().Count(x => x.ToiletType == entity) == 0);
 }