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
}
