protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SEBA_1001 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); bool isEdit = false; ORM_ACC_BNK_BankAccount bankAccount = new ORM_ACC_BNK_BankAccount(); if (Parameter.ACC_BNK_BankAccountID != Guid.Empty) { var result = bankAccount.Load(Connection, Transaction, Parameter.ACC_BNK_BankAccountID); if (result.Status != FR_Status.Success || bankAccount.ACC_BNK_BankAccountID == Guid.Empty) { var error = new FR_Guid(); error.ErrorMessage = "No Such ID"; error.Status = FR_Status.Error_Internal; return(error); } isEdit = true; } ORM_ACC_BNK_Bank.Query bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.Tenant_RefID = securityTicket.TenantID; bankQuery.IsDeleted = false; ORM_ACC_BNK_Bank bank = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery).FirstOrDefault(); bankAccount.Bank_RefID = bank == null ? new Guid() : bank.ACC_BNK_BankID; bankAccount.IBAN = Parameter.IBAN; bankAccount.OwnerText = Parameter.OwnerText; bankAccount.IsValid = true; bankAccount.Tenant_RefID = securityTicket.TenantID; bankAccount.Save(Connection, Transaction); returnValue = new FR_Guid(bankAccount.ACC_BNK_BankAccountID); if (!isEdit) { ORM_CMN_BPT_BusinessParticipant_2_BankAccount bankAcc2BP = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount(); bankAcc2BP.ACC_BNK_BankAccount_RefID = bankAccount.ACC_BNK_BankAccountID; bankAcc2BP.CMN_BPT_BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipant_RefID; bankAcc2BP.Tenant_RefID = securityTicket.TenantID; bankAcc2BP.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_L5BK_GBFBID_1447 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BK_GBFBID_1447 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5BK_GBFBID_1447(); returnValue.Result = new L5BK_GBFBID_1447(); ORM_ACC_BNK_Bank.Query bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.ACC_BNK_BankID = Parameter.ACC_BNK_BankID; bankQuery.Tenant_RefID = securityTicket.TenantID; bankQuery.IsDeleted = false; List <ORM_ACC_BNK_Bank> banks = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery); if (banks == null || banks.Count == 0) { returnValue.Result = null; } else { L5BK_GBFT_1318 bank = new L5BK_GBFT_1318(); bank.ACC_BNK_BankID = banks[0].ACC_BNK_BankID; bank.BankName = banks[0].BankName; bank.BankNumber = banks[0].BankNumber; bank.BICCode = banks[0].BICCode; bank.RoutingNumber = banks[0].RoutingNumber; bank.BankLocationComment = banks[0].BankLocationComment; returnValue.Result.Bank = bank; ORM_CMN_Country.Query countryQuery = new ORM_CMN_Country.Query(); countryQuery.CMN_CountryID = banks[0].Country_RefID; countryQuery.IsDeleted = false; countryQuery.Tenant_RefID = securityTicket.TenantID; List <ORM_CMN_Country> countries = ORM_CMN_Country.Query.Search(Connection, Transaction, countryQuery); if (countries.Count != 0) { bank.Country_ISOCode_Alpha2 = countries[0].Country_ISOCode_Alpha2; } } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_L5EM_GEBAIFBPID_1111 Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_GEBAIFBPID_1111 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5EM_GEBAIFBPID_1111(); ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query bankAcc2BPQuery = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query(); bankAcc2BPQuery.CMN_BPT_BusinessParticipant_RefID = Parameter.BusinessParticipantID; bankAcc2BPQuery.IsDeleted = false; bankAcc2BPQuery.Tenant_RefID = securityTicket.TenantID; var bankAcc2BPQueryResult = ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query.Search(Connection, Transaction, bankAcc2BPQuery); if (bankAcc2BPQueryResult.Count == 0) { return(null); } ORM_ACC_BNK_BankAccount.Query bankAccQuery = new ORM_ACC_BNK_BankAccount.Query(); bankAccQuery.ACC_BNK_BankAccountID = bankAcc2BPQueryResult.FirstOrDefault().ACC_BNK_BankAccount_RefID; bankAccQuery.IsDeleted = false; bankAccQuery.Tenant_RefID = securityTicket.TenantID; var bankAccount = ORM_ACC_BNK_BankAccount.Query.Search(Connection, Transaction, bankAccQuery).FirstOrDefault(); ORM_ACC_BNK_Bank.Query banksQuery = new ORM_ACC_BNK_Bank.Query(); banksQuery.ACC_BNK_BankID = bankAccount.Bank_RefID; banksQuery.IsDeleted = false; banksQuery.Tenant_RefID = securityTicket.TenantID; var bank = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, banksQuery).FirstOrDefault(); L5EM_GEBAIFBPID_1111 result = new L5EM_GEBAIFBPID_1111(); result.BankName = bank.BankName; result.BIC = bank.BICCode; result.IBAN = bankAccount.IBAN; returnValue.Result = result; return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, PL5DO_SD_1349 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); if (Parameter.isDeleted == true) { P_L3MD_DDbID_1031 param1 = new P_L3MD_DDbID_1031(); param1.DoctorID = Parameter.DoctorID; var deleteQuery = new ORM_HEC_Patient_Treatment.Query(); deleteQuery.IsTreatmentPerformed = true; deleteQuery.IfTreatmentPerformed_ByDoctor_RefID = Parameter.DoctorID; var treatmentsList = ORM_HEC_Patient_Treatment.Query.Search(Connection, Transaction, deleteQuery).ToList(); foreach (var treatment in treatmentsList) { treatment.IsTreatmentPerformed = false; treatment.Save(Connection, Transaction); } cls_Delete_Doctor_byID.Invoke(Connection, Transaction, param1, securityTicket); } else { P_L3MD_SDBI_1349 param = new P_L3MD_SDBI_1349(); param.Account_RefID = Parameter.Account_RefID; param.DoctorID = Parameter.DoctorID; param.Title = Parameter.Title; param.FirstName = Parameter.FirstName; param.LastName = Parameter.LastName; param.ifLucentis_LoginEmail = Parameter.LoginEmail; param.isLucentisSave = true; param.ifLucentis_LANR = Parameter.ifLucentis_LANR; List <P_L3MD_SDBI_1349_Practice> practiceNewList = new List <P_L3MD_SDBI_1349_Practice>(); foreach (var practice in Parameter.Practices) { P_L3MD_SDBI_1349_Practice practiceNew = new P_L3MD_SDBI_1349_Practice(); practiceNew.AssociatedParticipant_FunctionName = practice.AssociatedParticipant_FunctionName; practiceNew.isDeleted = practice.isDeleted; practiceNew.PracticeID = practice.PracticeID; practiceNewList.Add(practiceNew); } param.Practices = practiceNewList.ToArray(); List <P_L3MD_SDBI_1349_Contacts> contactsNewList = new List <P_L3MD_SDBI_1349_Contacts>(); foreach (var contact in Parameter.Contacts) { P_L3MD_SDBI_1349_Contacts contactNew = new P_L3MD_SDBI_1349_Contacts(); contactNew.CMN_PER_CommunicationContact_TypeID = contact.CMN_PER_CommunicationContact_TypeID; contactNew.Content = contact.Content; contactsNewList.Add(contactNew); } param.Contacts = contactsNewList.ToArray(); Guid Hec_Doctor_ID = cls_Save_Doctor_BaseInfo.Invoke(Connection, Transaction, param, securityTicket).Result; if (Parameter.DoctorID != Guid.Empty) { #region Edit var doctorQuery = new ORM_HEC_Doctor.Query(); doctorQuery.IsDeleted = false; doctorQuery.HEC_DoctorID = Hec_Doctor_ID; var doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, doctorQuery).FirstOrDefault(); if (doctor != null) { var bussiness_2_BankaAccountQuery = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query(); bussiness_2_BankaAccountQuery.IsDeleted = false; bussiness_2_BankaAccountQuery.CMN_BPT_BusinessParticipant_RefID = doctor.BusinessParticipant_RefID; var bussiness_2_BankaAccount = ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query.Search(Connection, Transaction, bussiness_2_BankaAccountQuery).FirstOrDefault(); if (bussiness_2_BankaAccount != null) { var bankAccountQuery = new ORM_ACC_BNK_BankAccount.Query(); bankAccountQuery.IsDeleted = false; bankAccountQuery.ACC_BNK_BankAccountID = bussiness_2_BankaAccount.ACC_BNK_BankAccount_RefID; var bankAccount = ORM_ACC_BNK_BankAccount.Query.Search(Connection, Transaction, bankAccountQuery).FirstOrDefault(); bankAccount.OwnerText = Parameter.AccountHolder; bankAccount.AccountNumber = Parameter.AccountNumber; bankAccount.IBAN = Parameter.IBAN; bankAccount.Save(Connection, Transaction); var bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.IsDeleted = false; bankQuery.ACC_BNK_BankID = bankAccount.Bank_RefID; var bank = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery).FirstOrDefault(); bank.BankName = Parameter.BankName; bank.BICCode = Parameter.BIC; bank.BankNumber = Parameter.BankNumber; bank.Save(Connection, Transaction); } else { ORM_CMN_BPT_BusinessParticipant_2_BankAccount bussiness_2_BankaAccount1 = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount(); bussiness_2_BankaAccount1.AssignmentID = Guid.NewGuid(); bussiness_2_BankaAccount1.CMN_BPT_BusinessParticipant_RefID = doctor.BusinessParticipant_RefID; bussiness_2_BankaAccount1.ACC_BNK_BankAccount_RefID = Guid.NewGuid(); bussiness_2_BankaAccount1.Creation_Timestamp = DateTime.Now; bussiness_2_BankaAccount1.Tenant_RefID = securityTicket.TenantID; bussiness_2_BankaAccount1.IsDeleted = false; bussiness_2_BankaAccount1.Save(Connection, Transaction); ORM_ACC_BNK_BankAccount bankAccount = new ORM_ACC_BNK_BankAccount(); bankAccount.ACC_BNK_BankAccountID = bussiness_2_BankaAccount1.ACC_BNK_BankAccount_RefID; bankAccount.Creation_Timestamp = DateTime.Now; bankAccount.Tenant_RefID = securityTicket.TenantID; bankAccount.OwnerText = Parameter.AccountHolder; bankAccount.AccountNumber = Parameter.AccountNumber; bankAccount.IBAN = Parameter.IBAN; bankAccount.Bank_RefID = Guid.NewGuid(); bankAccount.IsDeleted = false; bankAccount.Save(Connection, Transaction); ORM_ACC_BNK_Bank bank = new ORM_ACC_BNK_Bank(); bank.ACC_BNK_BankID = bankAccount.Bank_RefID; bank.Tenant_RefID = securityTicket.TenantID; bank.IsDeleted = false; bank.Creation_Timestamp = DateTime.Now; bank.BankName = Parameter.BankName; bank.BICCode = Parameter.BIC; bank.BankNumber = Parameter.BankNumber; bank.Save(Connection, Transaction); } } #endregion } else { #region Save var doctorQuery = new ORM_HEC_Doctor.Query(); doctorQuery.IsDeleted = false; doctorQuery.HEC_DoctorID = Hec_Doctor_ID; var doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, doctorQuery).FirstOrDefault(); if (doctor != null) { ORM_CMN_BPT_BusinessParticipant_2_BankAccount bussiness_2_BankaAccount = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount(); bussiness_2_BankaAccount.AssignmentID = Guid.NewGuid(); bussiness_2_BankaAccount.CMN_BPT_BusinessParticipant_RefID = doctor.BusinessParticipant_RefID; bussiness_2_BankaAccount.ACC_BNK_BankAccount_RefID = Guid.NewGuid(); bussiness_2_BankaAccount.Creation_Timestamp = DateTime.Now; bussiness_2_BankaAccount.Tenant_RefID = securityTicket.TenantID; bussiness_2_BankaAccount.IsDeleted = false; bussiness_2_BankaAccount.Save(Connection, Transaction); ORM_ACC_BNK_BankAccount bankAccount = new ORM_ACC_BNK_BankAccount(); bankAccount.ACC_BNK_BankAccountID = bussiness_2_BankaAccount.ACC_BNK_BankAccount_RefID; bankAccount.Creation_Timestamp = DateTime.Now; bankAccount.Tenant_RefID = securityTicket.TenantID; bankAccount.OwnerText = Parameter.AccountHolder; bankAccount.AccountNumber = Parameter.AccountNumber; bankAccount.IBAN = Parameter.IBAN; bankAccount.Bank_RefID = Guid.NewGuid(); bankAccount.IsDeleted = false; bankAccount.Save(Connection, Transaction); ORM_ACC_BNK_Bank bank = new ORM_ACC_BNK_Bank(); bank.ACC_BNK_BankID = bankAccount.Bank_RefID; bank.Tenant_RefID = securityTicket.TenantID; bank.IsDeleted = false; bank.Creation_Timestamp = DateTime.Now; bank.BankName = Parameter.BankName; bank.BICCode = Parameter.BIC; bank.BankNumber = Parameter.BankNumber; bank.Save(Connection, Transaction); } #endregion } returnValue.Result = Hec_Doctor_ID; } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PA_SPHIaBD_1143 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region Save if (!Parameter.IsDeleted) { //ORM_HEC_Patient var patientQuery = new ORM_HEC_Patient.Query(); patientQuery.IsDeleted = false; patientQuery.Tenant_RefID = securityTicket.TenantID; patientQuery.HEC_PatientID = Parameter.PatientID; var patient = ORM_HEC_Patient.Query.Search(Connection, Transaction, patientQuery).Single(); var businessParticipantBank_2_accountQuery = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query(); businessParticipantBank_2_accountQuery.CMN_BPT_BusinessParticipant_RefID = patient.CMN_BPT_BusinessParticipant_RefID; businessParticipantBank_2_accountQuery.IsDeleted = false; businessParticipantBank_2_accountQuery.Tenant_RefID = securityTicket.TenantID; var businessParticipantBank_2_account = ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query.Search(Connection, Transaction, businessParticipantBank_2_accountQuery).SingleOrDefault(); if (businessParticipantBank_2_account == null) { //ORM_CMN_BPT_BusinessParticipant_2_BankAccount businessParticipantBank_2_account = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount(); businessParticipantBank_2_account.CMN_BPT_BusinessParticipant_RefID = patient.CMN_BPT_BusinessParticipant_RefID; businessParticipantBank_2_account.ACC_BNK_BankAccount_RefID = Guid.NewGuid(); businessParticipantBank_2_account.AssignmentID = Guid.NewGuid(); businessParticipantBank_2_account.Tenant_RefID = securityTicket.TenantID; businessParticipantBank_2_account.Creation_Timestamp = DateTime.Now; businessParticipantBank_2_account.Save(Connection, Transaction); //ORM_ACC_BNK_BankAccount var bankAccount = new ORM_ACC_BNK_BankAccount(); bankAccount.ACC_BNK_BankAccountID = businessParticipantBank_2_account.ACC_BNK_BankAccount_RefID; bankAccount.OwnerText = Parameter.OwnerText; bankAccount.AccountNumber = Parameter.AccountNumber; bankAccount.IBAN = Parameter.IBAN; bankAccount.Bank_RefID = Guid.NewGuid(); bankAccount.Tenant_RefID = securityTicket.TenantID; bankAccount.Creation_Timestamp = DateTime.Now; bankAccount.Save(Connection, Transaction); //ORM_ACC_BNK_Bank var bank = new ORM_ACC_BNK_Bank(); bank.ACC_BNK_BankID = bankAccount.Bank_RefID; bank.BankName = Parameter.BankName; bank.BICCode = Parameter.BICCode; bank.Tenant_RefID = securityTicket.TenantID; bank.Creation_Timestamp = DateTime.Now; bank.Save(Connection, Transaction); //ORM_HEC_Patient_HealthInsurance var healthInsurance = new ORM_HEC_Patient_HealthInsurance(); healthInsurance.HEC_Patient_HealthInsurancesID = Guid.NewGuid(); healthInsurance.Patient_RefID = Parameter.PatientID; healthInsurance.HealthInsurance_Number = Parameter.HealthInsurance_Number; healthInsurance.HIS_HealthInsurance_Company_RefID = Parameter.HEC_HealthInsurance_CompanyID; healthInsurance.HealthInsurance_State_RefID = Parameter.HEC_Patient_HealthInsurance_StateID; healthInsurance.InsuranceValidFrom = Parameter.InsuranceValidFrom; healthInsurance.InsuranceValidThrough = Parameter.InsuranceValidThrough; healthInsurance.IsNotSelfInsured = Parameter.IsNotSelfInsured; if (healthInsurance.IsNotSelfInsured) { healthInsurance.IsNotSelfInsured_InsuredPersonBirthday = Parameter.IsNotSelfInsured_InsuredPersonBirthday; healthInsurance.IsNotSelfInsured_InsuredPersonName = Parameter.IsNotSelfInsured_InsuredPersonName; } healthInsurance.Creation_Timestamp = DateTime.Now; healthInsurance.Tenant_RefID = securityTicket.TenantID; healthInsurance.Save(Connection, Transaction); } else { var bankAccountQuery = new ORM_ACC_BNK_BankAccount.Query(); bankAccountQuery.IsDeleted = false; bankAccountQuery.Tenant_RefID = securityTicket.TenantID; bankAccountQuery.ACC_BNK_BankAccountID = businessParticipantBank_2_account.ACC_BNK_BankAccount_RefID; var bankAccount = ORM_ACC_BNK_BankAccount.Query.Search(Connection, Transaction, bankAccountQuery).Single(); bankAccount.OwnerText = Parameter.OwnerText; bankAccount.AccountNumber = Parameter.AccountNumber; bankAccount.IBAN = Parameter.IBAN; bankAccount.Save(Connection, Transaction); var bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.ACC_BNK_BankID = bankAccount.Bank_RefID; bankQuery.IsDeleted = false; bankQuery.Tenant_RefID = securityTicket.TenantID; var bank = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery).Single(); bank.BankName = Parameter.BankName; bank.BICCode = Parameter.BICCode; bank.Save(Connection, Transaction); var healthInsuranceQuery = new ORM_HEC_Patient_HealthInsurance.Query(); healthInsuranceQuery.Patient_RefID = patient.HEC_PatientID; healthInsuranceQuery.IsDeleted = false; healthInsuranceQuery.Tenant_RefID = securityTicket.TenantID; var healthInsurance = ORM_HEC_Patient_HealthInsurance.Query.Search(Connection, Transaction, healthInsuranceQuery).Single(); healthInsurance.HealthInsurance_Number = Parameter.HealthInsurance_Number; healthInsurance.HIS_HealthInsurance_Company_RefID = Parameter.HEC_HealthInsurance_CompanyID; healthInsurance.HealthInsurance_State_RefID = Parameter.HEC_Patient_HealthInsurance_StateID; healthInsurance.InsuranceValidFrom = Parameter.InsuranceValidFrom; healthInsurance.InsuranceValidThrough = Parameter.InsuranceValidThrough; healthInsurance.IsNotSelfInsured = Parameter.IsNotSelfInsured; healthInsurance.IsNotSelfInsured_InsuredPersonBirthday = Parameter.IsNotSelfInsured_InsuredPersonBirthday; healthInsurance.IsNotSelfInsured_InsuredPersonName = Parameter.IsNotSelfInsured_InsuredPersonName; healthInsurance.Save(Connection, Transaction); } } #endregion else { #region delete var patientQuery = new ORM_HEC_Patient.Query(); patientQuery.IsDeleted = false; patientQuery.Tenant_RefID = securityTicket.TenantID; patientQuery.HEC_PatientID = Parameter.PatientID; var patient = ORM_HEC_Patient.Query.Search(Connection, Transaction, patientQuery).Single(); patient.IsDeleted = true; patient.Save(Connection, Transaction); var businessParticipantBank_2_accountQuery = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query(); businessParticipantBank_2_accountQuery.CMN_BPT_BusinessParticipant_RefID = patient.CMN_BPT_BusinessParticipant_RefID; businessParticipantBank_2_accountQuery.IsDeleted = false; businessParticipantBank_2_accountQuery.Tenant_RefID = securityTicket.TenantID; var businessParticipantBank_2_account = ORM_CMN_BPT_BusinessParticipant_2_BankAccount.Query.Search(Connection, Transaction, businessParticipantBank_2_accountQuery).Single(); businessParticipantBank_2_account.IsDeleted = true; businessParticipantBank_2_account.Save(Connection, Transaction); var bankAccountQuery = new ORM_ACC_BNK_BankAccount.Query(); bankAccountQuery.IsDeleted = false; bankAccountQuery.Tenant_RefID = securityTicket.TenantID; bankAccountQuery.ACC_BNK_BankAccountID = businessParticipantBank_2_account.ACC_BNK_BankAccount_RefID; var bankAccount = ORM_ACC_BNK_BankAccount.Query.Search(Connection, Transaction, bankAccountQuery).Single(); bankAccount.IsDeleted = true; bankAccount.Save(Connection, Transaction); var bankQuery = new ORM_ACC_BNK_Bank.Query(); bankQuery.ACC_BNK_BankID = bankAccount.Bank_RefID; bankQuery.IsDeleted = false; bankQuery.Tenant_RefID = securityTicket.TenantID; var bank = ORM_ACC_BNK_Bank.Query.Search(Connection, Transaction, bankQuery).Single(); bank.IsDeleted = true; bank.Save(Connection, Transaction); var healthInsuranceQuery = new ORM_HEC_Patient_HealthInsurance.Query(); healthInsuranceQuery.Patient_RefID = patient.HEC_PatientID; healthInsuranceQuery.IsDeleted = false; healthInsuranceQuery.Tenant_RefID = securityTicket.TenantID; var healthInsurance = ORM_HEC_Patient_HealthInsurance.Query.Search(Connection, Transaction, healthInsuranceQuery).Single(); healthInsurance.IsDeleted = true; healthInsurance.Save(Connection, Transaction); #endregion } return(returnValue); #endregion UserCode }