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_L5OD_SD_1130 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
Guid accounrRefID = Guid.Empty;
var doctorQuery = new ORM_HEC_Doctor.Query();
ORM_HEC_Doctor doctor;
if (Parameter.HEC_DoctorID != Guid.Empty)
{
doctorQuery.HEC_DoctorID = Parameter.HEC_DoctorID;
doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, doctorQuery).First();
accounrRefID = doctor.Account_RefID;
}
P_L3MD_SDBI_1349 sbdParam = new P_L3MD_SDBI_1349();
sbdParam.DoctorID = Parameter.HEC_DoctorID;
sbdParam.Account_RefID = accounrRefID;
sbdParam.FirstName = Parameter.FirstName;
sbdParam.LastName = Parameter.LastName;
sbdParam.isOphthalSave = true;
sbdParam.ifOphthal_Salutation_General = Parameter.Salutation_General;
sbdParam.ifOphthal_Salutation_Letter = Parameter.Salutation_Letter;
sbdParam.Title = Parameter.Title;
List <P_L3MD_SDBI_1349_Contacts> contactsParams = new List <P_L3MD_SDBI_1349_Contacts>();
if (Parameter.Contacts != null)
{
foreach (var item in Parameter.Contacts)
{
var c = new P_L3MD_SDBI_1349_Contacts();
c.CMN_PER_CommunicationContact_TypeID = item.CMN_PER_CommunicationContact_TypeID;
c.Content = item.Content;
contactsParams.Add(c);
}
}
sbdParam.Contacts = contactsParams.ToArray();
List <P_L3MD_SDBI_1349_Practice> practicesParams = new List <P_L3MD_SDBI_1349_Practice>();
if (Parameter.Practices != null)
{
foreach (var item in Parameter.Practices)
{
var p = new P_L3MD_SDBI_1349_Practice();
p.PracticeID = item.PracticeID;
p.isDeleted = item.isDeleted;
p.AssociatedParticipant_FunctionName = item.AssociatedParticipant_FunctionName;
practicesParams.Add(p);
}
}
sbdParam.Practices = practicesParams.ToArray();
var docID = cls_Save_Doctor_BaseInfo.Invoke(Connection, Transaction, sbdParam, securityTicket).Result;
doctorQuery = new ORM_HEC_Doctor.Query();
doctorQuery.HEC_DoctorID = docID;
doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, doctorQuery).First();
var bParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
bParticipantQuery.CMN_BPT_BusinessParticipantID = doctor.BusinessParticipant_RefID;
var bParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bParticipantQuery).First();
ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative SalesRepresentative;
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Ext_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
var customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).FirstOrDefault();
if (customer == null)
{
customer = new ORM_CMN_BPT_CTM_Customer();
customer.CMN_BPT_CTM_CustomerID = Guid.NewGuid();
customer.Tenant_RefID = securityTicket.TenantID;
SalesRepresentative = new ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative();
SalesRepresentative.AssignmentID = Guid.NewGuid();
SalesRepresentative.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
SalesRepresentative.Tenant_RefID = securityTicket.TenantID;
customer.Ext_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
}
else
{
customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).First();
var SalesRepresentativeQuery = new ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative.Query();
SalesRepresentativeQuery.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
SalesRepresentative = ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative.Query.Search(Connection, Transaction, SalesRepresentativeQuery).First();
}
SalesRepresentative.SalesRepresentative_RefID = Parameter.CMN_BPT_SalesRepresentativeID;
var sRepresentativeQuery = new ORM_CMN_BPT_SalesRepresentative.Query();
sRepresentativeQuery.CMN_BPT_SalesRepresentativeID = Parameter.CMN_BPT_SalesRepresentativeID;
sRepresentativeQuery.IsDeleted = false;
var sRepresentative = ORM_CMN_BPT_SalesRepresentative.Query.Search(Connection, Transaction, sRepresentativeQuery).FirstOrDefault();
if (sRepresentative == null)
{
sRepresentative = new ORM_CMN_BPT_SalesRepresentative();
sRepresentative.CMN_BPT_SalesRepresentativeID = Parameter.CMN_BPT_SalesRepresentativeID;
sRepresentative.Save(Connection, Transaction);
}
customer.Save(Connection, Transaction);
SalesRepresentative.Save(Connection, Transaction);
ORM_USR_Account account;
ORM_USR_Device_AccountCode code;
ORM_USR_Device_AccountCode_StatusHistory codeStatus;
var accountQuery = new ORM_USR_Account.Query();
accountQuery.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
accountQuery.AccountType = 3;
var accountQueryRes = ORM_USR_Account.Query.Search(Connection, Transaction, accountQuery);
if (accountQueryRes.Count == 0)
{
account = new ORM_USR_Account();
account.USR_AccountID = Guid.NewGuid();
account.Tenant_RefID = securityTicket.TenantID;
account.AccountType = 3;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.Save(Connection, Transaction);
code = new ORM_USR_Device_AccountCode();
code.Tenant_RefID = securityTicket.TenantID;
code.USR_Device_AccountCodeID = Guid.NewGuid();
code.Account_RefID = account.USR_AccountID;
code.AccountCode_ValidFrom = DateTime.Now;
codeStatus = new ORM_USR_Device_AccountCode_StatusHistory();
codeStatus.USR_Device_AccountCode_StatusHistoryID = Guid.NewGuid();
codeStatus.Device_AccountCode_RefID = code.USR_Device_AccountCodeID;
codeStatus.Tenant_RefID = securityTicket.TenantID;
codeStatus.IsAccountCode_Active = true;
codeStatus.Save(Connection, Transaction);
code.AccountCode_CurrentStatus_RefID = codeStatus.USR_Device_AccountCode_StatusHistoryID;
L3DAC_GDACFTCV_1616 checkCodeValue;
P_L3DAC_GDACFTCV_1616 codeParam = new P_L3DAC_GDACFTCV_1616();
string codeValue;
do
{
codeValue = RandomString.Generate(8);
codeParam.CodeValue = codeValue;
checkCodeValue = cls_GetDeviceAccountCodeForTenantAndCodeValue.Invoke(Connection, Transaction, codeParam, securityTicket).Result;
} while (checkCodeValue != null);
code.AccountCode_Value = codeValue;
code.Save(Connection, Transaction);
}
returnValue.Result = docID;
return(returnValue);
#endregion UserCode
}