protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2RP_SRP_1421 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var item = new ORM_LOG_RET_ReturnPolicy();
var price = new ORM_CMN_Price();
var priceValue = new ORM_CMN_Price_Value();
if (Parameter.LOG_RET_ReturnPolicyID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.LOG_RET_ReturnPolicyID);
var price1 = price.Load(Connection, Transaction, item.ReturnPolicy_Cost_RefID);
var query = new ORM_CMN_Price_Value.Query();
query.Price_RefID = item.ReturnPolicy_Cost_RefID;
priceValue = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, query).First();
if (result.Status != FR_Status.Success || item.LOG_RET_ReturnPolicyID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
price.IsDeleted = true;
priceValue.IsDeleted = true;
price.Save(Connection, Transaction);
priceValue.Save(Connection, Transaction);
return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_RET_ReturnPolicyID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.LOG_RET_ReturnPolicyID == Guid.Empty)
{
priceValue.Price_RefID = price.CMN_PriceID;
//priceValue.PriceValue_Currency_RefID = Parameter.PriceValue_Currency_RefID;
item.ReturnPolicy_Cost_RefID = price.CMN_PriceID;
item.Tenant_RefID = securityTicket.TenantID;
price.Tenant_RefID = securityTicket.TenantID;
priceValue.Tenant_RefID = securityTicket.TenantID;
}
priceValue.PriceValue_Currency_RefID = Parameter.PriceValue_Currency_RefID;
item.ReturnPolicy_Abbreviation = Parameter.ReturnPolicy_Abbreviation;
item.ReturnPolicy_Reason = Parameter.ReturnPolicy_Reason_DictID;
item.GlobalPropertyMatchingID = Parameter.GlobalPropertyMatchingID;
priceValue.PriceValue_Amount = Parameter.PriceValue_Amount;
price.Save(Connection, Transaction);
priceValue.Save(Connection, Transaction);
return(new FR_Guid(item.Save(Connection, Transaction), item.LOG_RET_ReturnPolicyID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AT_SA_1301 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_RES_ACT_Action_Version oldVersion = new ORM_RES_ACT_Action_Version();
ORM_RES_ACT_Action action = new ORM_RES_ACT_Action();
int versionNumber = 0;
if (Parameter.RES_ACT_ActionID != Guid.Empty)
{
var result = action.Load(Connection, Transaction, Parameter.RES_ACT_ActionID);
if (result.Status != FR_Status.Success || action.RES_ACT_ActionID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
ORM_RES_ACT_Action_Version.Query versionQuery = new ORM_RES_ACT_Action_Version.Query();
versionQuery.Tenant_RefID = securityTicket.TenantID;
versionQuery.IsDeleted = false;
versionQuery.Action_RefID = action.RES_ACT_ActionID;
List <ORM_RES_ACT_Action_Version> versions = ORM_RES_ACT_Action_Version.Query.Search(Connection, Transaction, versionQuery);
action.RES_ACT_ActionID = Parameter.RES_ACT_ActionID;
versionNumber = versions.Max(i => i.Action_Version);
oldVersion = versions.FirstOrDefault(i => i.Action_Version == versionNumber);
versionNumber++;
}
else
{
versionNumber = 1;
action.Tenant_RefID = securityTicket.TenantID;
}
action.ActionType_RefID = Parameter.ActionType_RefID;
ORM_CMN_Price price = new ORM_CMN_Price();
if (Parameter.Default_PricePerUnit_RefID != Guid.Empty)
{
var result = price.Load(Connection, Transaction, Parameter.Default_PricePerUnit_RefID);
if (result.Status != FR_Status.Success || action.RES_ACT_ActionID == 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);
ORM_CMN_Price_Value.Query priceQuery = new ORM_CMN_Price_Value.Query();
priceQuery.Tenant_RefID = securityTicket.TenantID;
priceQuery.Price_RefID = price.CMN_PriceID;
priceQuery.IsDeleted = false;
List <ORM_CMN_Price_Value> priceValueList = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, priceQuery);
ORM_CMN_Price_Value priceValue = new ORM_CMN_Price_Value();
if (priceValueList.Count != 0)
{
priceValue.Load(Connection, Transaction, priceValueList[0].CMN_Price_ValueID);
}
priceValue.Tenant_RefID = securityTicket.TenantID;
priceValue.Price_RefID = price.CMN_PriceID;
priceValue.PriceValue_Amount = Parameter.Default_PricePerUnit;
priceValue.Save(Connection, Transaction);
ORM_RES_ACT_Action_Version version = new ORM_RES_ACT_Action_Version();
version.Action_Description = Parameter.Action_Description_DictID;
version.Action_Name = Parameter.Action_Name_DictID;
version.Action_RefID = action.RES_ACT_ActionID;
version.Action_Version = Parameter.Action_Version;
version.Default_PricePerUnit_RefID = price.CMN_PriceID;
version.Default_Unit_RefID = Parameter.Default_Unit_RefID;
version.Default_UnitAmount = Parameter.Default_UnitAmount;
version.Tenant_RefID = securityTicket.TenantID;
version.Action_Version = versionNumber;
version.Save(Connection, Transaction);
action.CurrentVersion_RefID = version.RES_ACT_Action_VersionID;
action.Save(Connection, Transaction);
if (Parameter.RES_ACT_ActionID != Guid.Empty)
{
ORM_RES_STR_OutdoorFacility_Property_AvailableAction.Query query1 = new ORM_RES_STR_OutdoorFacility_Property_AvailableAction.Query();
query1.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_OutdoorFacility_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query1);
ORM_RES_STR_Facade_Property_AvailableAction.Query query2 = new ORM_RES_STR_Facade_Property_AvailableAction.Query();
query2.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Facade_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query2);
ORM_RES_STR_Roof_Property_AvailableAction.Query query3 = new ORM_RES_STR_Roof_Property_AvailableAction.Query();
query3.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Roof_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query3);
ORM_RES_STR_Attic_Property_AvailableAction.Query query4 = new ORM_RES_STR_Attic_Property_AvailableAction.Query();
query4.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Attic_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query4);
ORM_RES_STR_Staircase_Property_AvailableAction.Query query5 = new ORM_RES_STR_Staircase_Property_AvailableAction.Query();
query5.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Staircase_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query5);
ORM_RES_STR_Basement_Property_AvailableAction.Query query6 = new ORM_RES_STR_Basement_Property_AvailableAction.Query();
query6.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Basement_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query6);
ORM_RES_STR_HVACR_Property_AvailableAction.Query query7 = new ORM_RES_STR_HVACR_Property_AvailableAction.Query();
query7.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_HVACR_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query7);
ORM_RES_STR_Apartment_Property_AvailableAction.Query query8 = new ORM_RES_STR_Apartment_Property_AvailableAction.Query();
query8.RES_ACT_Action_RefID = Parameter.RES_ACT_ActionID;
ORM_RES_STR_Apartment_Property_AvailableAction.Query.SoftDelete(Connection, Transaction, query8);
}
if (Parameter.availableQuestions != null)
{
foreach (var question in Parameter.availableQuestions)
{
if (question.questionType == "OutdoorFacility")
{
ORM_RES_STR_OutdoorFacility_Property_AvailableAction item = new ORM_RES_STR_OutdoorFacility_Property_AvailableAction();
item.RES_STR_OutdoorFacility_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Facade")
{
ORM_RES_STR_Facade_Property_AvailableAction item = new ORM_RES_STR_Facade_Property_AvailableAction();
item.RES_STR_Facade_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Roof")
{
ORM_RES_STR_Roof_Property_AvailableAction item = new ORM_RES_STR_Roof_Property_AvailableAction();
item.RES_STR_Roof_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Attic")
{
ORM_RES_STR_Attic_Property_AvailableAction item = new ORM_RES_STR_Attic_Property_AvailableAction();
item.RES_STR_Attic_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Staircase")
{
ORM_RES_STR_Staircase_Property_AvailableAction item = new ORM_RES_STR_Staircase_Property_AvailableAction();
item.RES_STR_Staircase_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Basement")
{
ORM_RES_STR_Basement_Property_AvailableAction item = new ORM_RES_STR_Basement_Property_AvailableAction();
item.RES_STR_Basement_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "HVCAR")
{
ORM_RES_STR_HVACR_Property_AvailableAction item = new ORM_RES_STR_HVACR_Property_AvailableAction();
item.RES_STR_HVACR_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
if (question.questionType == "Apartment")
{
ORM_RES_STR_Apartment_Property_AvailableAction item = new ORM_RES_STR_Apartment_Property_AvailableAction();
item.RES_STR_Apartment_Property_RefID = question.questionID;
item.RES_ACT_Action_RefID = action.RES_ACT_ActionID;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
}
}
}
returnValue.Result = action.RES_ACT_ActionID;
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
}
