protected static FR_L5LI_GCLIFRP_0936 Execute(DbConnection Connection, DbTransaction Transaction, P_L5LI_GCLIFRP_0936 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5LI_GCLIFRP_0936(); returnValue.Result = new L5LI_GCLIFRP_0936(); ORM_RES_RealestateProperty orm_realestate = new ORM_RES_RealestateProperty(); orm_realestate.Load(Connection, Transaction, Parameter.RealestatePropertyID); ORM_CMN_LOC_Location orm_location = new ORM_CMN_LOC_Location(); orm_location.Load(Connection, Transaction, orm_realestate.RealestateProperty_Location_RefID); returnValue.Result.CMN_LOC_LocationID = orm_location.CMN_LOC_LocationID; ORM_CMN_Address orm_address = new ORM_CMN_Address(); orm_address.Load(Connection, Transaction, orm_location.Address_RefID); L5LI_GCLIFRP_0936_Address address = new L5LI_GCLIFRP_0936_Address(); address.CMN_AddressID = orm_address.CMN_AddressID; address.Street_Name = orm_address.Street_Name; address.Street_Number = orm_address.Street_Number; address.City_PostalCode = orm_address.City_PostalCode; address.City_Name = orm_address.City_Name; address.City_Region = orm_address.City_Region; address.City_AdministrativeDistrict = orm_address.City_AdministrativeDistrict; address.Province_Name = orm_address.Province_Name; returnValue.Result.Address = address; ORM_CMN_LOC_Region orm_region = new ORM_CMN_LOC_Region(); orm_region.Load(Connection, Transaction, orm_location.Region_RefID); L5LI_GCLIFRP_0936_Region region = new L5LI_GCLIFRP_0936_Region(); region.CMN_LOC_RegionID = orm_region.CMN_LOC_RegionID; region.Country_RefID = orm_region.Country_RefID; returnValue.Result.Region = region; ORM_RES_LOC_LocationInformation.Query locationInfoQuery = new ORM_RES_LOC_LocationInformation.Query(); locationInfoQuery.CMN_LOC_Location_RefID = orm_location.CMN_LOC_LocationID; locationInfoQuery.Tenant_RefID = securityTicket.TenantID; locationInfoQuery.IsDeleted = false; ORM_RES_LOC_LocationInformation locationInfoFromQuery = ORM_RES_LOC_LocationInformation.Query.Search(Connection, Transaction, locationInfoQuery).FirstOrDefault(); L5LI_GCLIFRP_0936_LocationInformation locationInfo = new L5LI_GCLIFRP_0936_LocationInformation(); locationInfo.RES_LOC_LocationInformationID = locationInfoFromQuery.RES_LOC_LocationInformationID; locationInfo.MapImage = locationInfoFromQuery.LocationInformation_MapImage_DocID; locationInfo.SateliteImage = locationInfoFromQuery.LocationInformation_SatelliteImage_DocID; locationInfo.AddressImage = locationInfoFromQuery.LocationInformation_AddressImage_DocID; returnValue.Result.LocationInformation = locationInfo; ORM_RES_LOC_RegionInformation.Query regionInfoQuery = new ORM_RES_LOC_RegionInformation.Query(); regionInfoQuery.CMN_LOC_Region_RefID = orm_region.CMN_LOC_RegionID; regionInfoQuery.Tenant_RefID = securityTicket.TenantID; regionInfoQuery.IsDeleted = false; List <ORM_RES_LOC_RegionInformation> regionInfos = ORM_RES_LOC_RegionInformation.Query.Search(Connection, Transaction, regionInfoQuery); L5LI_GCLIFRP_0936_RegionInformation regionInfo = new L5LI_GCLIFRP_0936_RegionInformation(); regionInfo.RegionInformation_RegionArea_in_sqkm = regionInfos[0].RegionInformation_RegionArea_in_sqkm; regionInfo.RegionInformation_TotalPopulation = regionInfos[0].RegionInformation_TotalPopulation; regionInfo.RegionInformation_Population_per_sqkm = regionInfos[0].RegionInformation_Population_per_sqkm; regionInfo.RegionInformation_RegionUnemploymentRatePercent = regionInfos[0].RegionInformation_RegionUnemploymentRatePercent; regionInfo.RegionInformation_NumberOfHouseholds_Current = regionInfos[0].RegionInformation_NumberOfHouseholds_Current; regionInfo.RegionInformation_NumberOfHouseholds_Forecast = regionInfos[0].RegionInformation_NumberOfHouseholds_Forecast; regionInfo.RegionInformation_PurchasingPowerAmount_Current_RefID = regionInfos[0].RegionInformation_PurchasingPowerAmount_Current_RefID; regionInfo.RegionInformation_PurchasingPowerAmount_Forecast_RefID = regionInfos[0].RegionInformation_PurchasingPowerAmount_Forecast_RefID; regionInfo.RegionInformation_ResidentialRent_MinPrice_RefID = regionInfos[0].RegionInformation_ResidentialRent_MinPrice_RefID; regionInfo.RegionInformation_ResidentialRent_AveragePrice_RefID = regionInfos[0].RegionInformation_ResidentialRent_AveragePrice_RefID; regionInfo.RegionInformation_ResidentialRent_MaxPrice_RefID = regionInfos[0].RegionInformation_ResidentialRent_MaxPrice_RefID; regionInfo.RegionInformation_NonResidentialRent_MinPrice_RefID = regionInfos[0].RegionInformation_NonResidentialRent_MinPrice_RefID; regionInfo.RegionInformation_NonResidentialRent_AveragePrice_RefID = regionInfos[0].RegionInformation_NonResidentialRent_AveragePrice_RefID; regionInfo.RegionInformation_NonResidentialRent_MaxPrice_RefID = regionInfos[0].RegionInformation_NonResidentialRent_MaxPrice_RefID; returnValue.Result.RegionInformation = regionInfo; P_L2PR_GPVFP_0932 priceParam = new P_L2PR_GPVFP_0932(); priceParam.PriceID = regionInfos[0].RegionInformation_NonResidentialRent_AveragePrice_RefID; returnValue.Result.RegionInformation_NonResidentialRent_AveragePrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_NonResidentialRent_MaxPrice_RefID; returnValue.Result.RegionInformation_NonResidentialRent_MaxPrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_NonResidentialRent_MinPrice_RefID; returnValue.Result.RegionInformation_NonResidentialRent_MinPrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_PurchasingPowerAmount_Current_RefID; returnValue.Result.RegionInformation_PurchasingPowerAmount_Current_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_PurchasingPowerAmount_Forecast_RefID; returnValue.Result.RegionInformation_PurchasingPowerAmount_Forecast_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_ResidentialRent_AveragePrice_RefID; returnValue.Result.RegionInformation_ResidentialRent_AveragePrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_ResidentialRent_MaxPrice_RefID; returnValue.Result.RegionInformation_ResidentialRent_MaxPrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; priceParam.PriceID = regionInfos[0].RegionInformation_ResidentialRent_MinPrice_RefID; returnValue.Result.RegionInformation_ResidentialRent_MinPrice_Amount = cls_Get_PriceValue_For_PriceID.Invoke(Connection, Transaction, priceParam, securityTicket).Result.PriceValue_Amount; //result.Means_of_Transportation ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query locationInfo_2_mot_Query = new ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query(); locationInfo_2_mot_Query.RES_LOC_LocationInformation_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; locationInfo_2_mot_Query.Tenant_RefID = securityTicket.TenantID; locationInfo_2_mot_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInformation_2_MeansOfTransportation> locationInfo_2_mots = ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query.Search(Connection, Transaction, locationInfo_2_mot_Query); List <L5LI_GCLIFRP_0936_MeansOfTransportation> MeansOfTransportation_List = new List <L5LI_GCLIFRP_0936_MeansOfTransportation>(); L5LI_GCLIFRP_0936_MeansOfTransportation MeansOfTransportation; if (locationInfo_2_mots.Count > 0) { ORM_RES_LOC_MeansOfTransportation.Query motQuery; foreach (var locationInfi_2_mot in locationInfo_2_mots) { motQuery = new ORM_RES_LOC_MeansOfTransportation.Query(); motQuery.RES_LOC_MeansOfTransportationID = locationInfi_2_mot.RES_LOC_MeansOfTransportation_RefID; motQuery.Tenant_RefID = securityTicket.TenantID; motQuery.IsDeleted = false; List <ORM_RES_LOC_MeansOfTransportation> mots = ORM_RES_LOC_MeansOfTransportation.Query.Search(Connection, Transaction, motQuery); MeansOfTransportation = new L5LI_GCLIFRP_0936_MeansOfTransportation(); MeansOfTransportation.MeansOfTransportation_ID = mots[0].RES_LOC_MeansOfTransportationID; MeansOfTransportation.MeansOfTransportation_Name = mots[0].Transportation_Name; MeansOfTransportation_List.Add(MeansOfTransportation); } } returnValue.Result.MeansOfTransportation = MeansOfTransportation_List.ToArray(); //result.Emmissions ORM_RES_LOC_LocationInformation_2_Emmission.Query emmissions_Query = new ORM_RES_LOC_LocationInformation_2_Emmission.Query(); emmissions_Query.RES_LOC_LocationInformation_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; emmissions_Query.Tenant_RefID = securityTicket.TenantID; emmissions_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInformation_2_Emmission> emmissions = ORM_RES_LOC_LocationInformation_2_Emmission.Query.Search(Connection, Transaction, emmissions_Query); List <L5LI_GCLIFRP_0936_Emmissions> Emmissions_List = new List <L5LI_GCLIFRP_0936_Emmissions>(); L5LI_GCLIFRP_0936_Emmissions Emmission; if (emmissions.Count > 0) { ORM_RES_LOC_Emmission.Query emmissionQuery; foreach (var emmission in emmissions) { emmissionQuery = new ORM_RES_LOC_Emmission.Query(); emmissionQuery.RES_LOC_EmmissionID = emmission.RES_LOC_Emmission_RefID; emmissionQuery.Tenant_RefID = securityTicket.TenantID; emmissionQuery.IsDeleted = false; List <ORM_RES_LOC_Emmission> orm_emmissions = ORM_RES_LOC_Emmission.Query.Search(Connection, Transaction, emmissionQuery); Emmission = new L5LI_GCLIFRP_0936_Emmissions(); Emmission.Emmissions_ID = orm_emmissions[0].RES_LOC_EmmissionID; Emmission.Emmissions_Name = orm_emmissions[0].Emmission_Name; Emmissions_List.Add(Emmission); } } returnValue.Result.Emmissions = Emmissions_List.ToArray(); //result.SurroundingInfrastructures ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query SurroundingInfrastructures_Query = new ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query(); SurroundingInfrastructures_Query.RES_LOC_LocationInformation_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; SurroundingInfrastructures_Query.Tenant_RefID = securityTicket.TenantID; SurroundingInfrastructures_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure> SurroundingInfrastructures = ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query.Search(Connection, Transaction, SurroundingInfrastructures_Query); List <L5LI_GCLIFRP_0936_SurroundingInfrastructures> SurroundingInfrastructures_List = new List <L5LI_GCLIFRP_0936_SurroundingInfrastructures>(); L5LI_GCLIFRP_0936_SurroundingInfrastructures SurroundingInfrastructure; if (SurroundingInfrastructures.Count > 0) { ORM_RES_LOC_SurroundingInfrastructure.Query SurroundingInfrastructure_Query; foreach (var infrastructure in SurroundingInfrastructures) { SurroundingInfrastructure_Query = new ORM_RES_LOC_SurroundingInfrastructure.Query(); SurroundingInfrastructure_Query.RES_LOC_SurroundingInfrastructureID = infrastructure.RES_LOC_SurroundingInfrastructure_RefID; SurroundingInfrastructure_Query.Tenant_RefID = securityTicket.TenantID; SurroundingInfrastructure_Query.IsDeleted = false; List <ORM_RES_LOC_SurroundingInfrastructure> orm_SurroundingInfrastructure = ORM_RES_LOC_SurroundingInfrastructure.Query.Search(Connection, Transaction, SurroundingInfrastructure_Query); SurroundingInfrastructure = new L5LI_GCLIFRP_0936_SurroundingInfrastructures(); SurroundingInfrastructure.SurroundingInfrastructures_ID = orm_SurroundingInfrastructure[0].RES_LOC_SurroundingInfrastructureID; SurroundingInfrastructure.SurroundingInfrastructures_Name = orm_SurroundingInfrastructure[0].SurroundingInfrastructure_Name; SurroundingInfrastructures_List.Add(SurroundingInfrastructure); } } returnValue.Result.SurroundingInfrastructures = SurroundingInfrastructures_List.ToArray(); //result.Neighborhood ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query neighborhoodQuality_Query = new ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query(); neighborhoodQuality_Query.RES_LOC_LocationInformation_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; neighborhoodQuality_Query.Tenant_RefID = securityTicket.TenantID; neighborhoodQuality_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality> neighborhoodQualities = ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query.Search(Connection, Transaction, neighborhoodQuality_Query); List <L5LI_GCLIFRP_0936_NeighborhoodQualities> NeighborhoodQualities_List = new List <L5LI_GCLIFRP_0936_NeighborhoodQualities>(); L5LI_GCLIFRP_0936_NeighborhoodQualities NeighborhoodQuality; if (neighborhoodQualities.Count > 0) { ORM_RES_LOC_NeighborhoodQuality.Query NeighborhoodQuality_Query; foreach (var quality in neighborhoodQualities) { NeighborhoodQuality_Query = new ORM_RES_LOC_NeighborhoodQuality.Query(); NeighborhoodQuality_Query.RES_LOC_NeighborhoodQualityID = quality.RES_LOC_NeighborhoodQuality_RefID; NeighborhoodQuality_Query.Tenant_RefID = securityTicket.TenantID; NeighborhoodQuality_Query.IsDeleted = false; List <ORM_RES_LOC_NeighborhoodQuality> orm_neighborhoodQualities = ORM_RES_LOC_NeighborhoodQuality.Query.Search(Connection, Transaction, NeighborhoodQuality_Query); NeighborhoodQuality = new L5LI_GCLIFRP_0936_NeighborhoodQualities(); NeighborhoodQuality.NeighborhoodQualities_ID = orm_neighborhoodQualities[0].RES_LOC_NeighborhoodQualityID; NeighborhoodQuality.NeighborhoodQualities_Name = orm_neighborhoodQualities[0].NeighborhoodQuality_Name; NeighborhoodQualities_List.Add(NeighborhoodQuality); } } returnValue.Result.NeighborhoodQualities = NeighborhoodQualities_List.ToArray(); //result.ParkingSituation ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query parkingSituation_Query = new ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query(); parkingSituation_Query.RES_LOC_LocationInfo_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; parkingSituation_Query.Tenant_RefID = securityTicket.TenantID; parkingSituation_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInfo_2_ParkingSituation> parkingSituations = ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query.Search(Connection, Transaction, parkingSituation_Query); List <L5LI_GCLIFRP_0936_ParkingSituations> ParkingSituations_List = new List <L5LI_GCLIFRP_0936_ParkingSituations>(); L5LI_GCLIFRP_0936_ParkingSituations ParkingSituation; if (parkingSituations.Count > 0) { ORM_RES_LOC_ParkingSituation.Query ParkingSituation_Query; foreach (var situtaion in parkingSituations) { ParkingSituation_Query = new ORM_RES_LOC_ParkingSituation.Query(); ParkingSituation_Query.RES_LOC_ParkingSituationID = situtaion.RES_LOC_ParkingSituation_RefID; ParkingSituation_Query.Tenant_RefID = securityTicket.TenantID; ParkingSituation_Query.IsDeleted = false; List <ORM_RES_LOC_ParkingSituation> orm_parkingSituations = ORM_RES_LOC_ParkingSituation.Query.Search(Connection, Transaction, ParkingSituation_Query); ParkingSituation = new L5LI_GCLIFRP_0936_ParkingSituations(); ParkingSituation.ParkingSituations_ID = orm_parkingSituations[0].RES_LOC_ParkingSituationID; ParkingSituation.ParkingSituations_Name = orm_parkingSituations[0].ParkingSituation_Name; ParkingSituations_List.Add(ParkingSituation); } } returnValue.Result.ParkingSituations = ParkingSituations_List.ToArray(); //result.ResidentialVacancies ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query residentialVacancy_Query = new ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query(); residentialVacancy_Query.RES_LOC_LocationInfo_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; residentialVacancy_Query.Tenant_RefID = securityTicket.TenantID; residentialVacancy_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInfo_2_ResidentialVacancy> residentalVacancies = ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query.Search(Connection, Transaction, residentialVacancy_Query); List <L5LI_GCLIFRP_0936_ResidentialVacancies> ResidentialVacancies_List = new List <L5LI_GCLIFRP_0936_ResidentialVacancies>(); L5LI_GCLIFRP_0936_ResidentialVacancies ResidentialVacancy; if (residentalVacancies.Count > 0) { ORM_RES_LOC_ResidentialVacancy.Query ResidentialVacancy_Query; foreach (var vacancy in residentalVacancies) { ResidentialVacancy_Query = new ORM_RES_LOC_ResidentialVacancy.Query(); ResidentialVacancy_Query.RES_LOC_ResidentialVacancyID = vacancy.RES_LOC_ResidentialVacancy_RefID; ResidentialVacancy_Query.Tenant_RefID = securityTicket.TenantID; ResidentialVacancy_Query.IsDeleted = false; List <ORM_RES_LOC_ResidentialVacancy> orm_residentalVacancies = ORM_RES_LOC_ResidentialVacancy.Query.Search(Connection, Transaction, ResidentialVacancy_Query); ResidentialVacancy = new L5LI_GCLIFRP_0936_ResidentialVacancies(); ResidentialVacancy.ResidentialVacancies_ID = orm_residentalVacancies[0].RES_LOC_ResidentialVacancyID; ResidentialVacancy.ResidentialVacancies_Name = orm_residentalVacancies[0].ResidentialVacancy_Name; ResidentialVacancies_List.Add(ResidentialVacancy); } } returnValue.Result.ResidentialVacancies = ResidentialVacancies_List.ToArray(); //return.CommercialVacancies ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query commercialVacancies_Query = new ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query(); commercialVacancies_Query.RES_LOC_LocationInfo_RefID = locationInfoFromQuery.RES_LOC_LocationInformationID; commercialVacancies_Query.Tenant_RefID = securityTicket.TenantID; commercialVacancies_Query.IsDeleted = false; List <ORM_RES_LOC_LocationInfo_2_CommercialVacancy> commaericalVacancies = ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query.Search(Connection, Transaction, commercialVacancies_Query); List <L5LI_GCLIFRP_0936_CommercialVacancies> CommercialVacancies_List = new List <L5LI_GCLIFRP_0936_CommercialVacancies>(); L5LI_GCLIFRP_0936_CommercialVacancies CommercialVacancy; if (commaericalVacancies.Count > 0) { ORM_RES_LOC_CommercialVacancy.Query CommercialVacancies_Query; foreach (var vacancy in commaericalVacancies) { CommercialVacancies_Query = new ORM_RES_LOC_CommercialVacancy.Query(); CommercialVacancies_Query.RES_LOC_CommercialVacancyID = vacancy.RES_LOC_CommercialVacancy_RefID; CommercialVacancies_Query.Tenant_RefID = securityTicket.TenantID; CommercialVacancies_Query.IsDeleted = false; List <ORM_RES_LOC_CommercialVacancy> orm_commercialVacancies = ORM_RES_LOC_CommercialVacancy.Query.Search(Connection, Transaction, CommercialVacancies_Query); CommercialVacancy = new L5LI_GCLIFRP_0936_CommercialVacancies(); CommercialVacancy.CommercialVacancies_ID = orm_commercialVacancies[0].RES_LOC_CommercialVacancyID; CommercialVacancy.CommercialVacancies_Name = orm_commercialVacancies[0].CommercialVacancy_Name; CommercialVacancies_List.Add(CommercialVacancy); } } returnValue.Result.CommercialVacancies = CommercialVacancies_List.ToArray(); //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5LI_SLI_1538 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); Guid PurchasingPowerAmount_Current; Guid PurchasingPowerAmount_Forecast; Guid ResidentialRent_MinPrice; Guid ResidentialRent_AveragePrice; Guid ResidentialRent_MaxPrice; Guid NonResidentialRent_MinPrice; Guid NonResidentialRent_AveragePrice; Guid NonResidentialRent_MaxPrice; ORM_CMN_Address address = new ORM_CMN_Address(); if (Parameter.AddressID != Guid.Empty) { var result = address.Load(Connection, Transaction, Parameter.AddressID); if (result.Status != FR_Status.Success || address.CMN_AddressID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } address.City_Region = Parameter.City_Region; address.Street_Name = Parameter.Street_Name; address.Street_Number = Parameter.Street_Number; address.City_AdministrativeDistrict = Parameter.City_AdministrativeDistrict; address.City_Name = Parameter.City_Name; address.City_PostalCode = Parameter.City_PostalCode; address.Province_Name = Parameter.Province_Name; address.Tenant_RefID = securityTicket.TenantID; address.Save(Connection, Transaction); //for purchasingPowerAmountCurrent ORM_CMN_Price price = new ORM_CMN_Price(); if (Parameter.RegionInformation_PurchasingPowerAmount_Current_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_PurchasingPowerAmount_Current_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); PurchasingPowerAmount_Current = price.CMN_PriceID; ORM_CMN_Price_Value.Query priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; List <ORM_CMN_Price_Value> prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); ORM_CMN_Price_Value priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_PurchasingPowerAmount_Current_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_PurchasingPowerAmount_Forecast_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_PurchasingPowerAmount_Forecast_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_PurchasingPowerAmount_Forecast_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); PurchasingPowerAmount_Forecast = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_PurchasingPowerAmount_Forecast_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_ResidentialRent_MinPrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_ResidentialRent_MinPrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_ResidentialRent_MinPrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); ResidentialRent_MinPrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_ResidentialRent_MinPrice_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_ResidentialRent_AveragePrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_ResidentialRent_AveragePrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_ResidentialRent_AveragePrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); ResidentialRent_AveragePrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_ResidentialRent_AveragePrice_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_ResidentialRent_MaxPrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_ResidentialRent_MaxPrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_ResidentialRent_MaxPrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); ResidentialRent_MaxPrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_ResidentialRent_MaxPrice_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_NonResidentialRent_MinPrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_NonResidentialRent_MinPrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_NonResidentialRent_MinPrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); NonResidentialRent_MinPrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_NonResidentialRent_MinPrice_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_NonResidentialRent_AveragePrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_NonResidentialRent_AveragePrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_NonResidentialRent_AveragePrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); NonResidentialRent_AveragePrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_NonResidentialRent_AveragePrice_RefIDValue; priceValue.Save(Connection, Transaction); //for RegionInformation_NonResidentialRent_MaxPrice_RefID price = new ORM_CMN_Price(); if (Parameter.RegionInformation_NonResidentialRent_MaxPrice_RefID != Guid.Empty) { var result = price.Load(Connection, Transaction, Parameter.RegionInformation_NonResidentialRent_MaxPrice_RefID); if (result.Status != FR_Status.Success || price.CMN_PriceID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } price.Tenant_RefID = securityTicket.TenantID; price.Save(Connection, Transaction); NonResidentialRent_MaxPrice = price.CMN_PriceID; priceValueQuery = new ORM_CMN_Price_Value.Query(); priceValueQuery.Tenant_RefID = securityTicket.TenantID; priceValueQuery.Price_RefID = price.CMN_PriceID; priceValueQuery.IsDeleted = false; prices = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceValueQuery); priceValue = new ORM_CMN_Price_Value(); if (prices.Count != 0) { priceValue.Load(Connection, Transaction, prices[0].CMN_Price_ValueID); } priceValue.Tenant_RefID = securityTicket.TenantID; priceValue.Price_RefID = price.CMN_PriceID; priceValue.PriceValue_Amount = Parameter.RegionInformation_NonResidentialRent_MaxPrice_RefIDValue; priceValue.Save(Connection, Transaction); //for regionInfo and region ORM_CMN_LOC_Region region = new ORM_CMN_LOC_Region(); if (Parameter.RegionID != Guid.Empty) { var result = region.Load(Connection, Transaction, Parameter.RegionID); if (result.Status != FR_Status.Success || region.CMN_LOC_RegionID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } ORM_RES_LOC_RegionInformation.Query regionInfo = new ORM_RES_LOC_RegionInformation.Query(); regionInfo.CMN_LOC_Region_RefID = region.CMN_LOC_RegionID; regionInfo.Tenant_RefID = securityTicket.TenantID; regionInfo.IsDeleted = false; List <ORM_RES_LOC_RegionInformation> infos = ORM_RES_LOC_RegionInformation.Query.Search(Connection, Transaction, regionInfo); ORM_RES_LOC_RegionInformation info; if (infos.Count > 0) { info = infos[0]; info.RegionInformation_RegionArea_in_sqkm = Parameter.RegionInformation_RegionArea_in_sqkm; info.RegionInformation_TotalPopulation = Parameter.RegionInformation_TotalPopulation; info.RegionInformation_Population_per_sqkm = Parameter.RegionInformation_Population_per_sqkm; info.RegionInformation_RegionUnemploymentRatePercent = Parameter.RegionInformation_RegionUnemploymentRatePercent; info.RegionInformation_NumberOfHouseholds_Current = Parameter.RegionInformation_NumberOfHouseholds_Current; info.RegionInformation_NumberOfHouseholds_Forecast = Parameter.RegionInformation_NumberOfHouseholds_Forecast; info.Tenant_RefID = securityTicket.TenantID; info.Save(Connection, Transaction); } else { info = new ORM_RES_LOC_RegionInformation(); info.CMN_LOC_Region_RefID = region.CMN_LOC_RegionID; info.RegionInformation_RegionArea_in_sqkm = Parameter.RegionInformation_RegionArea_in_sqkm; info.RegionInformation_TotalPopulation = Parameter.RegionInformation_TotalPopulation; info.RegionInformation_Population_per_sqkm = Parameter.RegionInformation_Population_per_sqkm; info.RegionInformation_RegionUnemploymentRatePercent = Parameter.RegionInformation_RegionUnemploymentRatePercent; info.RegionInformation_NumberOfHouseholds_Current = Parameter.RegionInformation_NumberOfHouseholds_Current; info.RegionInformation_NumberOfHouseholds_Forecast = Parameter.RegionInformation_NumberOfHouseholds_Forecast; info.RegionInformation_PurchasingPowerAmount_Current_RefID = PurchasingPowerAmount_Current; info.RegionInformation_PurchasingPowerAmount_Forecast_RefID = PurchasingPowerAmount_Forecast; info.RegionInformation_ResidentialRent_MinPrice_RefID = ResidentialRent_MinPrice; info.RegionInformation_ResidentialRent_AveragePrice_RefID = ResidentialRent_AveragePrice; info.RegionInformation_ResidentialRent_MaxPrice_RefID = ResidentialRent_MaxPrice; info.RegionInformation_NonResidentialRent_MinPrice_RefID = NonResidentialRent_MinPrice; info.RegionInformation_NonResidentialRent_AveragePrice_RefID = NonResidentialRent_AveragePrice; info.RegionInformation_NonResidentialRent_MaxPrice_RefID = NonResidentialRent_MaxPrice; info.Tenant_RefID = securityTicket.TenantID; info.Save(Connection, Transaction); } //save region region.Country_RefID = Parameter.Country_RefID; region.Tenant_RefID = securityTicket.TenantID; region.Save(Connection, Transaction); //for location ORM_CMN_LOC_Location location = new ORM_CMN_LOC_Location(); if (Parameter.CMN_LOC_LocationID != Guid.Empty) { var result = location.Load(Connection, Transaction, Parameter.CMN_LOC_LocationID); if (result.Status != FR_Status.Success || location.CMN_LOC_LocationID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } location.Region_RefID = region.CMN_LOC_RegionID; location.Address_RefID = address.CMN_AddressID; location.Tenant_RefID = securityTicket.TenantID; location.Save(Connection, Transaction); //add location ref id in realesteProperty ORM_RES_RealestateProperty.Query realestatePropertyQuery = new ORM_RES_RealestateProperty.Query(); realestatePropertyQuery.RES_RealestatePropertyID = Parameter.RealestatePropertyID; List <ORM_RES_RealestateProperty> realestates = ORM_RES_RealestateProperty.Query.Search(Connection, Transaction, realestatePropertyQuery); ORM_RES_RealestateProperty realestate = realestates[0]; realestate.RealestateProperty_Location_RefID = location.CMN_LOC_LocationID; realestate.Save(Connection, Transaction); //for locationInformation ORM_RES_LOC_LocationInformation locationInformation = new ORM_RES_LOC_LocationInformation(); if (Parameter.LocationInformationID != Guid.Empty) { var result = locationInformation.Load(Connection, Transaction, Parameter.LocationInformationID); if (result.Status != FR_Status.Success || locationInformation.RES_LOC_LocationInformationID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } } locationInformation.CMN_LOC_Location_RefID = location.CMN_LOC_LocationID; locationInformation.LocationInformation_MapImage_DocID = Parameter.MapImage; locationInformation.LocationInformation_SatelliteImage_DocID = Parameter.SateliteImage; locationInformation.LocationInformation_AddressImage_DocID = Parameter.AddressImage; locationInformation.Tenant_RefID = securityTicket.TenantID; locationInformation.Save(Connection, Transaction); //for meansOfTrasnportation, emmissions, infrastructures... ORM_RES_LOC_LocationInformation_2_MeansOfTransportation transportation; ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure infrastructure; ORM_RES_LOC_LocationInformation_2_Emmission emmission; ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality qualitie; ORM_RES_LOC_LocationInfo_2_ParkingSituation parkingSituation; ORM_RES_LOC_LocationInfo_2_ResidentialVacancy residentialVacancy; ORM_RES_LOC_LocationInfo_2_CommercialVacancy commercialVacancy; ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query transportationQuery = new ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query(); transportationQuery.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; transportationQuery.Tenant_RefID = securityTicket.TenantID; transportationQuery.IsDeleted = false; ORM_RES_LOC_LocationInformation_2_MeansOfTransportation.Query.SoftDelete(Connection, Transaction, transportationQuery); if (Parameter.RES_LOC_MeansOfTransportation_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_MeansOfTransportation_RefID) { transportation = new ORM_RES_LOC_LocationInformation_2_MeansOfTransportation(); transportation.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; transportation.RES_LOC_MeansOfTransportation_RefID = guid; transportation.Tenant_RefID = securityTicket.TenantID; transportation.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query infrastructureQuery = new ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query(); infrastructureQuery.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; infrastructureQuery.Tenant_RefID = securityTicket.TenantID; infrastructureQuery.IsDeleted = false; ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure.Query.SoftDelete(Connection, Transaction, infrastructureQuery); if (Parameter.RES_LOC_SurroundingInfrastructure_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_SurroundingInfrastructure_RefID) { infrastructure = new ORM_RES_LOC_LocationInformation_2_SurroundingInfrastructure(); infrastructure.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; infrastructure.RES_LOC_SurroundingInfrastructure_RefID = guid; infrastructure.Tenant_RefID = securityTicket.TenantID; infrastructure.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInformation_2_Emmission.Query emmissionQuery = new ORM_RES_LOC_LocationInformation_2_Emmission.Query(); emmissionQuery.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; emmissionQuery.Tenant_RefID = securityTicket.TenantID; emmissionQuery.IsDeleted = false; ORM_RES_LOC_LocationInformation_2_Emmission.Query.SoftDelete(Connection, Transaction, emmissionQuery); if (Parameter.RES_LOC_Emmission_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_Emmission_RefID) { emmission = new ORM_RES_LOC_LocationInformation_2_Emmission(); emmission.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; emmission.RES_LOC_Emmission_RefID = guid; emmission.Tenant_RefID = securityTicket.TenantID; emmission.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query neighborhoodQuery = new ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query(); neighborhoodQuery.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; neighborhoodQuery.Tenant_RefID = securityTicket.TenantID; neighborhoodQuery.IsDeleted = false; ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality.Query.SoftDelete(Connection, Transaction, neighborhoodQuery); if (Parameter.RES_LOC_NeighborhoodQuality_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_NeighborhoodQuality_RefID) { qualitie = new ORM_RES_LOC_LocationInformation_2_NeighborhoodQuality(); qualitie.RES_LOC_LocationInformation_RefID = locationInformation.RES_LOC_LocationInformationID; qualitie.RES_LOC_NeighborhoodQuality_RefID = guid; qualitie.Tenant_RefID = securityTicket.TenantID; qualitie.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query parkingQuery = new ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query(); parkingQuery.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; parkingQuery.Tenant_RefID = securityTicket.TenantID; parkingQuery.IsDeleted = false; ORM_RES_LOC_LocationInfo_2_ParkingSituation.Query.SoftDelete(Connection, Transaction, parkingQuery); if (Parameter.RES_LOC_ParkingSituation_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_ParkingSituation_RefID) { parkingSituation = new ORM_RES_LOC_LocationInfo_2_ParkingSituation(); parkingSituation.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; parkingSituation.RES_LOC_ParkingSituation_RefID = guid; parkingSituation.Tenant_RefID = securityTicket.TenantID; parkingSituation.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query residentalQuery = new ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query(); residentalQuery.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; residentalQuery.Tenant_RefID = securityTicket.TenantID; residentalQuery.IsDeleted = false; ORM_RES_LOC_LocationInfo_2_ResidentialVacancy.Query.SoftDelete(Connection, Transaction, residentalQuery); if (Parameter.RES_LOC_ResidentialVacancies_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_ResidentialVacancies_RefID) { residentialVacancy = new ORM_RES_LOC_LocationInfo_2_ResidentialVacancy(); residentialVacancy.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; residentialVacancy.RES_LOC_ResidentialVacancy_RefID = guid; residentialVacancy.Tenant_RefID = securityTicket.TenantID; residentialVacancy.Save(Connection, Transaction); } } ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query commercialQuery = new ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query(); commercialQuery.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; commercialQuery.Tenant_RefID = securityTicket.TenantID; commercialQuery.IsDeleted = false; ORM_RES_LOC_LocationInfo_2_CommercialVacancy.Query.SoftDelete(Connection, Transaction, commercialQuery); if (Parameter.RES_LOC_CommercialVacancies_RefID != null) { foreach (Guid guid in Parameter.RES_LOC_CommercialVacancies_RefID) { commercialVacancy = new ORM_RES_LOC_LocationInfo_2_CommercialVacancy(); commercialVacancy.RES_LOC_LocationInfo_RefID = locationInformation.RES_LOC_LocationInformationID; commercialVacancy.RES_LOC_CommercialVacancy_RefID = guid; commercialVacancy.Tenant_RefID = securityTicket.TenantID; commercialVacancy.Save(Connection, Transaction); } } returnValue.Result = location.CMN_LOC_LocationID; return(returnValue); #endregion UserCode }