private static void MoveEntity(ISession hb, DataClassesDataContext linq) { var helper = new DataResolveHelper(hb); helper.IdDictionaryMaps = _idDictionaryMaps; //IFlatService foreach (var l in linq.AppartmentForSales.Where(x => x.bActual.HasValue && x.bActual.Value)) { var hbEntity = new Flat { CreateDate = l.DateOfAdd.HasValue ? l.DateOfAdd.Value : DateTime.Now, DealVariant = helper.ResolveHbEntity <DealVariant>(l.Variant), Description = l.vcComment, District = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.District>(l.District), Floor = l.iFloor, FloorLevel = null, HasVideo = l.bVideo ?? false, KitchenSquare = l.iKitchenArea, Layout = helper.ResolveHbEntity <Layout>(l.Planing), Material = helper.ResolveHbEntity <Material>(l.WallMatherial), Ownership = null, Price = l.iPrice, Realtor = helper.ResolveHbEntity <Realtor>(l.Rielter), ResidentialSquare = l.iLivArea, Street = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.Street>(l.Street), Terrace = helper.ResolveHbEntity <Terrace>(l.Balcony), TerritorialNumber = l.vcHouseNumber, ToiletType = helper.ResolveHbEntity <ToiletType>(l.SanUsel), TotalFloor = l.iFloors, TotalRoomCount = l.iRoomsAmount, TotalSquare = l.iAllArea }; hb.SaveOrUpdate(hbEntity); } Console.WriteLine("Квартиры - готово"); //IHouseService foreach (var l in linq.HousesForSales.Where(x => x.bActual.HasValue && x.bActual.Value)) { var hbEntity = new House { CreateDate = l.DateOfAdd.HasValue ? l.DateOfAdd.Value : DateTime.Now, DealVariant = helper.ResolveHbEntity <DealVariant>(l.Variant), Description = l.vcComment, District = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.District>(l.District), HasVideo = l.bVideo ?? false, Ownership = null, Price = l.iPrice, Realtor = helper.ResolveHbEntity <Realtor>(l.Rielter), Street = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.Street>(l.Street), TerritorialNumber = l.vcHouseNumber, TotalFloor = l.iFloors, HouseSquare = l.iHouseArea, PlotSquare = l.iLandArea, }; hb.SaveOrUpdate(hbEntity); } Console.WriteLine("Дома - готово"); //IPlotService foreach (var l in linq.HomestadForSales.Where(x => x.bActual.HasValue && x.bActual.Value)) { var hbEntity = new Plot { CreateDate = l.DateOfAdd.HasValue ? l.DateOfAdd.Value : DateTime.Now, DealVariant = helper.ResolveHbEntity <DealVariant>(l.Variant), Description = l.vcComment, District = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.District>(l.District), HasVideo = l.bVideo ?? false, Ownership = null, Price = l.iPrice, Realtor = helper.ResolveHbEntity <Realtor>(l.Rielter), Street = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.Street>(l.Street), TerritorialNumber = l.vcHouseNumber, PlotSquare = l.iArea }; hb.SaveOrUpdate(hbEntity); } Console.WriteLine("Участки - готово"); //IResidenceService foreach (var l in linq.PlacementForSales.Where(x => x.bActual.HasValue && x.bActual.Value)) { var hbEntity = new Residence { CreateDate = l.DateOfAdd.HasValue ? l.DateOfAdd.Value : DateTime.Now, DealVariant = helper.ResolveHbEntity <DealVariant>(l.Variant), Description = l.vcComment, District = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.District>(l.District), HasVideo = l.bVideo ?? false, Material = helper.ResolveHbEntity <Material>(l.WallMatherial), Ownership = null, Price = l.iPrice, Realtor = helper.ResolveHbEntity <Realtor>(l.Rielter), Street = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.Street>(l.Street), TerritorialNumber = l.vcHouseNumber, TotalFloor = l.iFloors, Floor = l.iFloor, TotalSquare = l.iPlaceArea }; hb.SaveOrUpdate(hbEntity); } Console.WriteLine("Помещения - готово"); //IRoomService foreach (var l in linq.RoomsForSales.Where(x => x.bActual.HasValue && x.bActual.Value)) { var hbEntity = new Room { CreateDate = l.DateOfAdd.HasValue ? l.DateOfAdd.Value : DateTime.Now, DealVariant = helper.ResolveHbEntity <DealVariant>(l.Variant), Description = l.vcComment, District = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.District>(l.District), HasVideo = l.bVideo ?? false, Material = helper.ResolveHbEntity <Material>(l.WallMatherial), Ownership = null, Price = l.iPrice, Realtor = helper.ResolveHbEntity <Realtor>(l.Rielter), Street = helper.ResolveHbEntity <RealEstateDirectory.Domain.Entities.Dictionaries.Street>(l.Street), TerritorialNumber = l.vcHouseNumber, TotalFloor = l.iFloors, Floor = l.iFloor, FloorLevel = null, Layout = helper.ResolveHbEntity <Layout>(l.Planing), RoomCount = l.iRoomsAmount, TotalRoomCount = l.iRoomsAll, Terrace = helper.ResolveHbEntity <Terrace>(l.Balcony), TotalSquare = l.iAllArea }; hb.SaveOrUpdate(hbEntity); } Console.WriteLine("Комнаты - готово"); }
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("Агентства - готово"); }