protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_SCP_1137 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
foreach (var cooperatingPractice in Parameter.CooperatingPractices)
{
var associatedBussinessParticipantsQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBussinessParticipantsQuery.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associatedBussinessParticipantsQuery.Tenant_RefID = securityTicket.TenantID;
associatedBussinessParticipantsQuery.BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID;
var associtePractice = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBussinessParticipantsQuery).FirstOrDefault();
if (associtePractice != null)
{
associtePractice.IsDeleted = cooperatingPractice.isDeleted;
associtePractice.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associtePractice.Save(Connection, Transaction);
}
else
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant associatedBussinessParticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedBussinessParticipants.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
associatedBussinessParticipants.IsDeleted = cooperatingPractice.isDeleted;
associatedBussinessParticipants.BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID;
associatedBussinessParticipants.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associatedBussinessParticipants.Creation_Timestamp = DateTime.Now;
associatedBussinessParticipants.Tenant_RefID = securityTicket.TenantID;
associatedBussinessParticipants.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_L3CU_CCaMR_1308 Execute(DbConnection Connection, DbTransaction Transaction, P_L3CU_CCaMR_1308 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3CU_CCaMR_1308();
returnValue.Status = FR_Status.Error_Internal;
returnValue.Result = new L3CU_CCaMR_1308();
#region Load or Create Customer Tenant Initial Table Structure
var customerTenantStructure = cls_Create_Tenant_Initial_Table_Structure.Invoke(
Connection,
Transaction,
new P_L3TE_CTITS_1108()
{
TenantITL = Parameter.Customer_TenantITL,
BusinessParticipantITL = Parameter.Customer_BusinessParticipantITL,
TenantUniversalContactDetailITL = Parameter.Customer_TenantUniversalContactDetailITL,
CompanyInfoUniversalContactDetailITL = Parameter.Customer_CompanyInfoUniversalContactDetailITL,
CompanyName = Parameter.Customer_CompanyName,
ContactEmail = Parameter.Customer_ContactEmail
},
securityTicket);
#endregion
if (customerTenantStructure.Status != FR_Status.Success)
{
return(returnValue);
}
#region Load or Create Customer
var cust = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, new ORM_CMN_BPT_CTM_Customer.Query()
{
Ext_BusinessParticipant_RefID = customerTenantStructure.Result.BusinessParticipantID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (cust == default(ORM_CMN_BPT_CTM_Customer))
{
cust = new ORM_CMN_BPT_CTM_Customer();
cust.CMN_BPT_CTM_CustomerID = Guid.NewGuid();
cust.Ext_BusinessParticipant_RefID = customerTenantStructure.Result.BusinessParticipantID;
cust.Tenant_RefID = securityTicket.TenantID;
cust.Creation_Timestamp = DateTime.Now;
cust.Save(Connection, Transaction);
}
#endregion
#region Create booking account
var fiscalYear = cls_Get_Current_FiscalYear.Invoke(Connection, Transaction, securityTicket).Result;
var bookingAccountParam = new P_L3BA_CCAfBP_1655()
{
BusinessParticipantIDs = new Guid[1] {
customerTenantStructure.Result.BusinessParticipantID
},
FiscalYearID = fiscalYear.ACC_FiscalYearID
};
var result = cls_Create_Customer_Account_for_BusinessParticipants.Invoke(Connection, Transaction, bookingAccountParam, securityTicket).Result;
#endregion
#region create defaultPerson for customer
var businessParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
businessParticipantQuery.CMN_BPT_BusinessParticipantID = cust.Ext_BusinessParticipant_RefID;
businessParticipantQuery.IsDeleted = false;
var businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantQuery).Single();
if (businessParticipant.IsNaturalPerson)
{
if (businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID == null || businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID == Guid.Empty)
{
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.IsDeleted = false;
personInfo.FirstName = businessParticipant.DisplayName;
personInfo.LastName = businessParticipant.DisplayName;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Save(Connection, Transaction);
businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
}
}
else if (businessParticipant.IsCompany)
{
Boolean needDefaultPerson = true;
var associatedBPQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBPQuery.AssociatedBusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID;
associatedBPQuery.Tenant_RefID = securityTicket.TenantID;
associatedBPQuery.IsDeleted = false;
List <ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant> associations =
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBPQuery);
if (associations.Count > 0)
{
foreach (var assotiation in associations)
{
if (assotiation.BusinessParticipant_RefID != Guid.Empty)
{
ORM_CMN_BPT_BusinessParticipant.Query businessParticipantPersonQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
businessParticipantPersonQuery.CMN_BPT_BusinessParticipantID = assotiation.BusinessParticipant_RefID;
businessParticipantPersonQuery.IsDeleted = false;
businessParticipantPersonQuery.IsNaturalPerson = true;
List <ORM_CMN_BPT_BusinessParticipant> businessParticipantsPerson =
ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantPersonQuery);
foreach (var person in businessParticipantsPerson)
{
if (person.IfNaturalPerson_CMN_PER_PersonInfo_RefID == Guid.Empty)
{
ORM_CMN_PER_PersonInfo personInfoNew = new ORM_CMN_PER_PersonInfo();
personInfoNew.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfoNew.Tenant_RefID = securityTicket.TenantID;
personInfoNew.IsDeleted = false;
personInfoNew.FirstName = person.DisplayName;
personInfoNew.LastName = person.DisplayName;
personInfoNew.Creation_Timestamp = DateTime.Now;
personInfoNew.Save(Connection, Transaction);
person.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfoNew.CMN_PER_PersonInfoID;
}
needDefaultPerson = false;
break;
}
}
}
}
if (needDefaultPerson)
{
#region create personalInfo
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.IsDeleted = false;
personInfo.FirstName = businessParticipant.DisplayName;
personInfo.LastName = businessParticipant.DisplayName;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Save(Connection, Transaction);
#endregion
#region create new businessParticipiant
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.IsNaturalPerson = true;
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
bParticipant.DisplayName = businessParticipant.DisplayName;
bParticipant.Creation_Timestamp = DateTime.Now;
bParticipant.Save(Connection, Transaction);
#endregion
#region create associated businessParticipant table
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant associatedBP = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedBP.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
associatedBP.IsDeleted = false;
associatedBP.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
associatedBP.AssociatedBusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID;
associatedBP.Creation_Timestamp = DateTime.Now;
associatedBP.Tenant_RefID = securityTicket.TenantID;
associatedBP.Save(Connection, Transaction);
#endregion
}
}
#endregion
returnValue.Result.Customer_TenantID = customerTenantStructure.Result.TenantID;
returnValue.Result.Customer_BusinessParticipantID = customerTenantStructure.Result.BusinessParticipantID;
returnValue.Result.Customer_CompanyInfo_UniversalContactDetailID = customerTenantStructure.Result.CompanyInfoUniversalContactDetailID;
returnValue.Result.Customer_Tenant_UniversalContactDetailID = customerTenantStructure.Result.TenantUniversalContactDetailID;
returnValue.Result.Customer_CustomerID = cust.CMN_BPT_CTM_CustomerID;
returnValue.Result.Customer_CompanyInfoID = customerTenantStructure.Result.CompanyInfoID;
returnValue.Result.IsCustomerOrderAutomaticallyApprovedOnReceipt = cust.IsCustomerOrderAutomaticallyApprovedOnReceipt;
returnValue.Status = FR_Status.Success;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3MD_SDBI_1349 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var doctor = new ORM_HEC_Doctor();
if (Parameter.DoctorID != Guid.Empty)
{
var result = doctor.Load(Connection, Transaction, Parameter.DoctorID);
if (result.Status != FR_Status.Success || doctor.HEC_DoctorID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
#region Edit
bool bopAccIsChenged = (doctor.Account_RefID == Parameter.Account_RefID) ? false : true;
doctor.Account_RefID = Parameter.Account_RefID;
if (Parameter.isLucentisSave)
{
doctor.DoctorIDNumber = Parameter.ifLucentis_LANR;
}
doctor.Save(Connection, Transaction);
//bussinessParticipant
var query1 = new ORM_CMN_BPT_BusinessParticipant.Query();
query1.CMN_BPT_BusinessParticipantID = doctor.BusinessParticipant_RefID;
var bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query1).First();
if (!bopAccIsChenged)
{
//personInfo
var query2 = new ORM_CMN_PER_PersonInfo.Query();
query2.CMN_PER_PersonInfoID = bussinessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query2).First();
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.Title = Parameter.Title;
if (Parameter.isOphthalSave)
{
personInfo.Salutation_General = Parameter.ifOphthal_Salutation_General;
personInfo.Salutation_Letter = Parameter.ifOphthal_Salutation_Letter;
}
if (Parameter.isLucentisSave)
{
personInfo.PrimaryEmail = Parameter.ifLucentis_LoginEmail;
}
personInfo.Save(Connection, Transaction);
var query4 = new ORM_CMN_PER_CommunicationContact.Query();
query4.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
var communicationContactsList = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query4).ToList();
if (Parameter.Contacts != null)
{
foreach (var parContact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact communicationContacts = communicationContactsList.FirstOrDefault(c => c.Contact_Type == parContact.CMN_PER_CommunicationContact_TypeID);
if (communicationContacts != null)
{
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Content = parContact.Content;
communicationContacts.Save(Connection, Transaction);
}
else
{
communicationContacts = new ORM_CMN_PER_CommunicationContact();
communicationContacts.CMN_PER_CommunicationContactID = Guid.NewGuid();
communicationContacts.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
communicationContacts.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
communicationContacts.Content = parContact.Content;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
}
}
}
}
else
{
var account2personInfoQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
account2personInfoQuery.USR_Account_RefID = Parameter.Account_RefID;
account2personInfoQuery.Tenant_RefID = securityTicket.TenantID;
account2personInfoQuery.IsDeleted = false;
var account2personInfo = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, account2personInfoQuery).First();
var query2 = new ORM_CMN_PER_PersonInfo.Query();
query2.CMN_PER_PersonInfoID = account2personInfo.CMN_PER_PersonInfo_RefID;
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query2).First();
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.Title = Parameter.Title;
personInfo.Save(Connection, Transaction);
var query4 = new ORM_CMN_PER_CommunicationContact.Query();
query4.PersonInfo_RefID = bussinessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
var communicationContactsList = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query4).ToList();
if (communicationContactsList != null)
{
foreach (var c in communicationContactsList)
{
c.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
c.Save(Connection, Transaction);
}
}
if (Parameter.Contacts != null)
{
foreach (var parContact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact communicationContacts = communicationContactsList.FirstOrDefault(c => c.Contact_Type == parContact.CMN_PER_CommunicationContact_TypeID);
if (communicationContacts != null)
{
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Content = parContact.Content;
communicationContacts.Save(Connection, Transaction);
}
else
{
communicationContacts = new ORM_CMN_PER_CommunicationContact();
communicationContacts.CMN_PER_CommunicationContactID = Guid.NewGuid();
communicationContacts.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
communicationContacts.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
communicationContacts.Content = parContact.Content;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
}
}
}
bussinessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
bussinessParticipant.Save(Connection, Transaction);
}
if (Parameter.isLucentisSave)
{
foreach (var practice in Parameter.Practices)
{
//if (practice.PracticeID != Guid.Empty) {
var medPract = new ORM_HEC_MedicalPractis.Query();
medPract.HEC_MedicalPractiseID = practice.PracticeID;
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, medPract).First();
var queryCompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
queryCompanyInfo.CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, queryCompanyInfo).First();
var practiceQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
practiceQuery.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
var practiceBPT = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, practiceQuery).First();
var query3 = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
query3.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
query3.AssociatedBusinessParticipant_RefID = practiceBPT.CMN_BPT_BusinessParticipantID;
query3.IsDeleted = false;
var associatedbusinessparticipantsOriginal = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, query3).FirstOrDefault();
if (associatedbusinessparticipantsOriginal != null)
{
associatedbusinessparticipantsOriginal.IsDeleted = practice.isDeleted;
associatedbusinessparticipantsOriginal.Save(Connection, Transaction);
}
else
{
var associatedbusinessparticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedbusinessparticipants.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.AssociatedBusinessParticipant_RefID = practiceBPT.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.AssociatedParticipant_FunctionName = practice.AssociatedParticipant_FunctionName;
associatedbusinessparticipants.Creation_Timestamp = DateTime.Now;
associatedbusinessparticipants.Tenant_RefID = securityTicket.TenantID;
associatedbusinessparticipants.Save(Connection, Transaction);
// }
}
}
}
if (Parameter.isOphthalSave && Parameter.Practices.Length == 1)
{
var query3 = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
query3.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
query3.IsDeleted = false;
var associatedbusinessparticipantsRes = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, query3);
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant firstPractice;
var medPract = new ORM_HEC_MedicalPractis.Query();
medPract.HEC_MedicalPractiseID = Parameter.Practices[0].PracticeID;
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, medPract).First();
var queryCompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
queryCompanyInfo.CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, queryCompanyInfo).First();
var practiceQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
practiceQuery.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
var practiceBPT = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, practiceQuery).First();
if (associatedbusinessparticipantsRes.Count > 0)
{
associatedbusinessparticipantsRes = associatedbusinessparticipantsRes.OrderBy(a => a.Creation_Timestamp).ToList();
firstPractice = associatedbusinessparticipantsRes.First();
foreach (var item in associatedbusinessparticipantsRes)
{
if (item != firstPractice && item.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID == practiceBPT.CMN_BPT_BusinessParticipantID)
{
item.IsDeleted = true;
item.Save(Connection, Transaction);
}
}
}
else
{
firstPractice = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
firstPractice.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
firstPractice.Tenant_RefID = securityTicket.TenantID;
firstPractice.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
}
firstPractice.AssociatedParticipant_FunctionName = Parameter.Practices[0].AssociatedParticipant_FunctionName;
firstPractice.AssociatedBusinessParticipant_RefID = practiceBPT.CMN_BPT_BusinessParticipantID;
firstPractice.Save(Connection, Transaction);
}
#endregion
}
else
{
#region Save
//personInfo
Guid personInfoID;
if (Parameter.Account_RefID == Guid.Empty)
{
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
if (Parameter.isLucentisSave)
{
personInfo.PrimaryEmail = Parameter.ifLucentis_LoginEmail;
}
personInfo.Title = Parameter.Title;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Tenant_RefID = securityTicket.TenantID;
if (Parameter.isOphthalSave)
{
personInfo.Salutation_Letter = Parameter.ifOphthal_Salutation_Letter;
personInfo.Salutation_General = Parameter.ifOphthal_Salutation_General;
}
personInfo.Save(Connection, Transaction);
personInfoID = personInfo.CMN_PER_PersonInfoID;
}
else
{
var account2personInfoQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
account2personInfoQuery.USR_Account_RefID = Parameter.Account_RefID;
account2personInfoQuery.Tenant_RefID = securityTicket.TenantID;
account2personInfoQuery.IsDeleted = false;
var account2personInfo = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, account2personInfoQuery).First();
var query2 = new ORM_CMN_PER_PersonInfo.Query();
query2.CMN_PER_PersonInfoID = account2personInfo.CMN_PER_PersonInfo_RefID;
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query2).First();
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.Title = Parameter.Title;
personInfo.Save(Connection, Transaction);
personInfoID = personInfo.CMN_PER_PersonInfoID;
}
//bussinessParticipants
var bussinessParticipantTable = new ORM_CMN_BPT_BusinessParticipant();
bussinessParticipantTable.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bussinessParticipantTable.IsNaturalPerson = true;
bussinessParticipantTable.IsTenant = false;
bussinessParticipantTable.IsCompany = false;
bussinessParticipantTable.IsDeleted = false;
bussinessParticipantTable.Creation_Timestamp = DateTime.Now;
bussinessParticipantTable.Tenant_RefID = securityTicket.TenantID;
bussinessParticipantTable.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfoID;
bussinessParticipantTable.Save(Connection, Transaction);
doctor.HEC_DoctorID = Guid.NewGuid();
if (Parameter.isLucentisSave)
{
doctor.DoctorIDNumber = Parameter.ifLucentis_LANR;
}
doctor.Creation_Timestamp = DateTime.Now;
doctor.Tenant_RefID = securityTicket.TenantID;
doctor.BusinessParticipant_RefID = bussinessParticipantTable.CMN_BPT_BusinessParticipantID;
doctor.Account_RefID = Parameter.Account_RefID;
doctor.Save(Connection, Transaction);
if (Parameter.Contacts != null)
{
foreach (var contact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact communicationContacts = new ORM_CMN_PER_CommunicationContact();
communicationContacts.CMN_PER_CommunicationContactID = Guid.NewGuid();
communicationContacts.PersonInfo_RefID = personInfoID;
communicationContacts.Contact_Type = contact.CMN_PER_CommunicationContact_TypeID;
communicationContacts.Content = contact.Content;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
}
}
foreach (var practice in Parameter.Practices)
{
if (practice.isDeleted == true)
{
continue;
}
var medPract = new ORM_HEC_MedicalPractis.Query();
medPract.HEC_MedicalPractiseID = practice.PracticeID;
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, medPract).First();
var queryCompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
queryCompanyInfo.CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, queryCompanyInfo).First();
var practiceQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
practiceQuery.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
var practiceBPT = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, practiceQuery).First();
//associatedbusinessparticipants
var associatedbusinessparticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedbusinessparticipants.BusinessParticipant_RefID = bussinessParticipantTable.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.AssociatedBusinessParticipant_RefID = practiceBPT.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.AssociatedParticipant_FunctionName = practice.AssociatedParticipant_FunctionName;
associatedbusinessparticipants.Creation_Timestamp = DateTime.Now;
associatedbusinessparticipants.Tenant_RefID = securityTicket.TenantID;
associatedbusinessparticipants.Save(Connection, Transaction);
}
#endregion
}
returnValue.Result = doctor.HEC_DoctorID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DR_SD_1537 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
if (Parameter.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
#region Create Mode
#region BusinessParticipant
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = Guid.NewGuid();
bParticipant.IsNaturalPerson = true;
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.Creation_Timestamp = DateTime.Now;
bParticipant.Save(Connection, Transaction);
#endregion
#region Account
ORM_USR_Account account = new ORM_USR_Account();
account.Username = Parameter.FirstName + "_" + Parameter.LastName;
account.AccountType = 3;
account.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
account.Tenant_RefID = securityTicket.TenantID;
account.Creation_Timestamp = DateTime.Now;
account.Save(Connection, Transaction);
P_L2DC_GUDCfT_1505 codeParam = new P_L2DC_GUDCfT_1505();
codeParam.codeLength = 8;
var checkCodeValue = cls_GetUniqueDeviceCodeForTenant.Invoke(Connection, Transaction, codeParam, securityTicket).Result;
ORM_USR_Device_AccountCode accountCode = new ORM_USR_Device_AccountCode();
accountCode.Account_RefID = account.USR_AccountID;
accountCode.AccountCode_Value = checkCodeValue.CodeValue;
accountCode.AccountCode_ValidFrom = DateTime.Now;
accountCode.AccountCode_CurrentStatus_RefID = Guid.NewGuid();
accountCode.IsAccountCode_Expirable = false;
accountCode.Tenant_RefID = securityTicket.TenantID;
accountCode.Creation_Timestamp = DateTime.Now;
accountCode.Save(Connection, Transaction);
ORM_USR_Device_AccountCode_StatusHistory Device_AccountCode_StatusHistory = new ORM_USR_Device_AccountCode_StatusHistory();
Device_AccountCode_StatusHistory.USR_Device_AccountCode_StatusHistoryID = accountCode.AccountCode_CurrentStatus_RefID;
Device_AccountCode_StatusHistory.IsAccountCode_Active = true;
Device_AccountCode_StatusHistory.Device_AccountCode_RefID = accountCode.USR_Device_AccountCodeID;
Device_AccountCode_StatusHistory.Tenant_RefID = securityTicket.TenantID;
Device_AccountCode_StatusHistory.Creation_Timestamp = DateTime.Now;
Device_AccountCode_StatusHistory.Save(Connection, Transaction);
ORM_USR_Device_AccountCode_UsageHistory USR_Device_AccountCode_UsageHistory = new ORM_USR_Device_AccountCode_UsageHistory();
USR_Device_AccountCode_UsageHistory.USR_Device_AccountCode_UsageHistoryID = Guid.NewGuid();
USR_Device_AccountCode_UsageHistory.Tenant_RefID = securityTicket.TenantID;
USR_Device_AccountCode_UsageHistory.Device_AccountCode_RefID = accountCode.USR_Device_AccountCodeID;
USR_Device_AccountCode_UsageHistory.Creation_Timestamp = DateTime.Now;
USR_Device_AccountCode_UsageHistory.Save(Connection, Transaction);
#endregion
#region PersonInfo and Adresses
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
personInfo.Salutation_General = Parameter.Salutation_General;
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.PrimaryEmail = Parameter.PrimaryMail;
personInfo.Address_RefID = Guid.NewGuid();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.Save(Connection, Transaction);
ORM_CMN_PER_PersonInfo_2_Address personAdress = new ORM_CMN_PER_PersonInfo_2_Address();
personAdress.AssignmentID = Guid.NewGuid();
personAdress.CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
personAdress.CMN_Address_RefID = personInfo.Address_RefID;
personAdress.IsPrimary = true;
personAdress.Tenant_RefID = securityTicket.TenantID;
personAdress.Save(Connection, Transaction);
ORM_CMN_Address adress = new ORM_CMN_Address();
adress.CMN_AddressID = personInfo.Address_RefID;
adress.City_Name = Parameter.City_Name;
adress.Province_Name = Parameter.Province_Name;
adress.Street_Name = Parameter.Street_Name;
adress.Street_Number = Parameter.Street_Number;
adress.City_PostalCode = Parameter.City_PostalCode;
adress.Tenant_RefID = securityTicket.TenantID;
adress.Save(Connection, Transaction);
#endregion
#region Contacts
foreach (var parContact in Parameter.Contacts)
{
ORM_CMN_PER_CommunicationContact contact = new ORM_CMN_PER_CommunicationContact();
contact.Content = parContact.Content;
contact.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
contact.Tenant_RefID = securityTicket.TenantID;
contact.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
contact.Save(Connection, Transaction);
}
#endregion
#region Driver To Employer
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant bpt_asBP = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
bpt_asBP.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
bpt_asBP.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
bpt_asBP.AssociatedParticipant_FunctionName = "Driver";
bpt_asBP.Tenant_RefID = securityTicket.TenantID;
bpt_asBP.AssociatedBusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID_Of_Employer;
bpt_asBP.Save(Connection, Transaction);
#endregion
#endregion
}
else
{
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.Load(Connection, Transaction, Parameter.CMN_BPT_BusinessParticipantID);
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Load(Connection, Transaction, bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID);
personInfo.Salutation_General = Parameter.Salutation_General;
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.PrimaryEmail = Parameter.PrimaryMail;
personInfo.Save(Connection, Transaction);
ORM_CMN_Address adress = new ORM_CMN_Address();
adress.Load(Connection, Transaction, personInfo.Address_RefID);
adress.City_Name = Parameter.City_Name;
adress.Province_Name = Parameter.Province_Name;
adress.Street_Name = Parameter.Street_Name;
adress.Street_Number = Parameter.Street_Number;
adress.Save(Connection, Transaction);
foreach (var parContact in Parameter.Contacts)
{
var query = new ORM_CMN_PER_CommunicationContact.Query();
query.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
query.IsDeleted = false;
query.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
var contact = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query).First();
contact.Content = parContact.Content;
contact.Contact_Type = parContact.CMN_PER_CommunicationContact_TypeID;
contact.Save(Connection, Transaction);
}
var associationQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associationQuery.BusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID;
associationQuery.IsDeleted = false;
var bpt_asBP = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associationQuery).First();
bpt_asBP.AssociatedBusinessParticipant_RefID = Parameter.CMN_BPT_BusinessParticipantID_Of_Employer;
bpt_asBP.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CL5CO_SC_1724 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
Guid personInfoID = Guid.Empty;
ORM_CMN_BPT_CTM_Customer.Query customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.CMN_BPT_CTM_CustomerID = Parameter.CustomerID;
customerQuery.IsDeleted = false;
ORM_CMN_BPT_CTM_Customer customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).Single();
ORM_CMN_BPT_BusinessParticipant.Query businessParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
businessParticipantQuery.CMN_BPT_BusinessParticipantID = customer.Ext_BusinessParticipant_RefID;
businessParticipantQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantQuery).Single();
if (businessParticipant.IsNaturalPerson)
{
personInfoID = businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
}
else
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query associationQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associationQuery.AssociatedBusinessParticipant_RefID = businessParticipant.CMN_BPT_BusinessParticipantID;
associationQuery.IsDeleted = false;
List <ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant> associations = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associationQuery);
foreach (var association in associations)
{
ORM_CMN_BPT_BusinessParticipant.Query bpQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
bpQuery.CMN_BPT_BusinessParticipantID = association.BusinessParticipant_RefID;
bpQuery.IsDeleted = false;
bpQuery.IsNaturalPerson = true;
ORM_CMN_BPT_BusinessParticipant bp = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bpQuery).First();
if (bp != null)
{
personInfoID = bp.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
break;
}
}
}
if (personInfoID != Guid.Empty)
{
if (Parameter.Correspondences.Any(x => x.IsDefaultCorrespondence) && !Parameter.Correspondences.Any(x => x.IsDeleted))
{
var findDefaultCorrespondenceQuery = ORM_CMN_PER_PersonInfo_Correspondence.Query.Search(Connection, Transaction,
new ORM_CMN_PER_PersonInfo_Correspondence.Query
{
CMN_PER_PersonInfo_RefID = personInfoID,
IsDefaultCorrespondence = true,
IsDeleted = false,
Tenant_RefID = customer.Tenant_RefID
});
if (findDefaultCorrespondenceQuery != null && findDefaultCorrespondenceQuery.Any())
{
foreach (var item in findDefaultCorrespondenceQuery)
{
item.IsDefaultCorrespondence = false;
item.Save(Connection, Transaction);
}
}
}
foreach (var item in Parameter.Correspondences)
{
ORM_CMN_PER_PersonInfo_Correspondence.Query correspondenceQuery = new ORM_CMN_PER_PersonInfo_Correspondence.Query();
correspondenceQuery.IsDeleted = false;
correspondenceQuery.CMN_PER_PersonInfo_CorrespondenceID = item.CorrespondenceID;
List <ORM_CMN_PER_PersonInfo_Correspondence> correspondences = ORM_CMN_PER_PersonInfo_Correspondence.Query.Search(Connection, Transaction, correspondenceQuery);
if (item.IsDeleted && correspondences.Count > 0)
{
correspondences.First().IsDeleted = true;
correspondences.First().Save(Connection, Transaction);
}
else if (!item.IsDeleted)
{
if (correspondences.Count > 0)
{
correspondences.First().CorrespondenceText = item.CorrespondenceText;
correspondences.First().IsDefaultCorrespondence = item.IsDefaultCorrespondence;
correspondences.First().CorrespondenceType_RefID = item.CorrespondenceTypeRefId;
correspondences.First().Save(Connection, Transaction);
// save name in correspodencetype
//var correspodenceTypeQuery = ORM_CMN_PER_PersonInfo_CorrespondenceType.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo_CorrespondenceType.Query{
// CMN_PER_PersonInfo_CorrespondenceTypeID = correspondences.First().CorrespondenceType_RefID,
// Tenant_RefID = customer.Tenant_RefID
//}).SingleOrDefault()
//if (correspodenceTypeQuery != null)
//{
// correspodenceTypeQuery.DisplayName = item.CorrespondenceName;
// correspodenceTypeQuery.Save(Connection, Transaction);
//}
}
else
{
ORM_CMN_PER_PersonInfo.Query personQuery = new ORM_CMN_PER_PersonInfo.Query();
personQuery.CMN_PER_PersonInfoID = personInfoID;
personQuery.IsDeleted = false;
ORM_CMN_PER_PersonInfo person = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, personQuery).First();
ORM_CMN_PER_PersonInfo_Correspondence newCorrespondance = new ORM_CMN_PER_PersonInfo_Correspondence();
newCorrespondance.CorrespondenceText = item.CorrespondenceText;
newCorrespondance.IsDefaultCorrespondence = item.IsDefaultCorrespondence;
newCorrespondance.CorrespondenceType_RefID = item.CorrespondenceTypeRefId;
newCorrespondance.IsDeleted = false;
newCorrespondance.Creation_Timestamp = DateTime.Now;
newCorrespondance.CMN_PER_PersonInfo_CorrespondenceID = Guid.NewGuid();
newCorrespondance.CMN_PER_PersonInfo_RefID = person.CMN_PER_PersonInfoID;
newCorrespondance.Tenant_RefID = customer.Tenant_RefID;
newCorrespondance.Save(Connection, Transaction);
// We will need some of this code later
//var correspodenceTypeQuery = ORM_CMN_PER_PersonInfo_CorrespondenceType.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo_CorrespondenceType.Query{
// CMN_PER_PersonInfo_CorrespondenceTypeID = newCorrespondance.CorrespondenceType_RefID,
// Tenant_RefID = customer.Tenant_RefID
//}).SingleOrDefault()
//if (correspodenceTypeQuery != null)
//{
// correspodenceTypeQuery.DisplayName = item.CorrespondenceName;
// correspodenceTypeQuery.Save(Connection,Transaction);
//}
//else
//{
// ORM_CMN_PER_PersonInfo_CorrespondenceType newCorrespodenceType = new ORM_CMN_PER_PersonInfo_CorrespondenceType();
// newCorrespodenceType.Tenant_RefID = customer.Tenant_RefID;
// newCorrespodenceType.CMN_PER_PersonInfo_CorrespondenceTypeID = newCorrespondance.CorrespondenceType_RefID;
// newCorrespodenceType.DisplayName = item.CorrespondenceName;
//}
}
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ACACU_SPC_1047 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
if (Parameter.IsDelete && (Parameter.CMN_BPT_CTM_CustomerID == Guid.Empty))
{
return(returnValue);
}
ORM_CMN_BPT_CTM_Customer customer;
if (Parameter.CMN_BPT_CTM_CustomerID != Guid.Empty)
{
var customerQ = new ORM_CMN_BPT_CTM_Customer.Query();
customerQ.Tenant_RefID = securityTicket.TenantID;
customerQ.IsDeleted = false;
customerQ.CMN_BPT_CTM_CustomerID = Parameter.CMN_BPT_CTM_CustomerID;
customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQ).First();
customer.IsCustomerOrderAutomaticallyApprovedOnReceipt =
Parameter.IsCustomerOrderAutomaticallyApprovedOnReceipt;
}
else
{
customer = new ORM_CMN_BPT_CTM_Customer();
customer.Tenant_RefID = securityTicket.TenantID;
customer.CMN_BPT_CTM_CustomerID = Guid.NewGuid();
customer.InternalCustomerNumber = Parameter.Number;
customer.IsCustomerOrderAutomaticallyApprovedOnReceipt =
Parameter.IsCustomerOrderAutomaticallyApprovedOnReceipt;
}
ORM_CMN_BPT_CTM_AvailablePaymentType customer2PaymentType;
var customer2PaymentTypeQ = new ORM_CMN_BPT_CTM_AvailablePaymentType.Query();
customer2PaymentTypeQ.Tenant_RefID = securityTicket.TenantID;
customer2PaymentTypeQ.IsDeleted = false;
customer2PaymentTypeQ.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
customer2PaymentType = ORM_CMN_BPT_CTM_AvailablePaymentType.Query.Search(Connection, Transaction, customer2PaymentTypeQ).FirstOrDefault();
if (customer2PaymentType == null)
{
customer2PaymentType = new ORM_CMN_BPT_CTM_AvailablePaymentType();
customer2PaymentType.ACC_PAY_Type_RefID = Guid.NewGuid();
customer2PaymentType.Tenant_RefID = securityTicket.TenantID;
customer2PaymentType.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
}
customer2PaymentType.ACC_PAY_Type_RefID = Parameter.PaymentTypeID;
customer2PaymentType.Save(Connection, Transaction);
#region payment condition
ORM_CMN_BPT_CTM_AvailablePaymentCondition customer2PaymentCondition;
var customer2PaymentConditionQ = new ORM_CMN_BPT_CTM_AvailablePaymentCondition.Query();
customer2PaymentConditionQ.Tenant_RefID = securityTicket.TenantID;
customer2PaymentConditionQ.IsDeleted = false;
customer2PaymentConditionQ.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
customer2PaymentCondition = ORM_CMN_BPT_CTM_AvailablePaymentCondition.Query.Search(Connection, Transaction, customer2PaymentConditionQ).FirstOrDefault();
if (customer2PaymentCondition == null)
{
customer2PaymentCondition = new ORM_CMN_BPT_CTM_AvailablePaymentCondition();
customer2PaymentCondition.ACC_PAY_Condition_RefID = Guid.NewGuid();
customer2PaymentCondition.Tenant_RefID = securityTicket.TenantID;
customer2PaymentCondition.Customer_RefID = customer.CMN_BPT_CTM_CustomerID;
}
customer2PaymentCondition.ACC_PAY_Condition_RefID = Parameter.PaymentConditionID;
customer2PaymentCondition.Save(Connection, Transaction);
#endregion
ORM_CMN_BPT_BusinessParticipant bParticipant;
if (customer.Ext_BusinessParticipant_RefID != Guid.Empty)
{
var bParticipantQ = new ORM_CMN_BPT_BusinessParticipant.Query();
bParticipantQ.Tenant_RefID = securityTicket.TenantID;
bParticipantQ.IsDeleted = false;
bParticipantQ.CMN_BPT_BusinessParticipantID = customer.Ext_BusinessParticipant_RefID;
bParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bParticipantQ).First();
}
else
{
bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.IsNaturalPerson = true;
customer.Ext_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
}
bParticipant.DisplayName = Parameter.FirstName + " " + Parameter.LastName;
ORM_CMN_PER_PersonInfo personInfo;
if (bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID != Guid.Empty)
{
var personInfoQ = new ORM_CMN_PER_PersonInfo.Query();
personInfoQ.Tenant_RefID = securityTicket.TenantID;
personInfoQ.IsDeleted = false;
personInfoQ.CMN_PER_PersonInfoID = bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, personInfoQ).First();
}
else
{
personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
}
#region connection with legal guardian
//checking is there allready legal guardian associated with this business participant
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query LGCheckQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
LGCheckQuery.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
LGCheckQuery.IsDeleted = false;
Boolean oldLegalGuardianConnectionExist = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Exists(Connection, Transaction, LGCheckQuery);
if (Parameter.IsRepresentedByLegalGuardian)
{
if (oldLegalGuardianConnectionExist)
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant oldLegalGuardianConnection = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, LGCheckQuery).First();
ORM_CMN_BPT_BusinessParticipant.Query oldLegalGuardianQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
oldLegalGuardianQuery.CMN_BPT_BusinessParticipantID = oldLegalGuardianConnection.AssociatedBusinessParticipant_RefID;
oldLegalGuardianQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant oldLegalGuardian = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, oldLegalGuardianQuery).First();
oldLegalGuardian.DisplayName = Parameter.LegalGuardianName;
oldLegalGuardian.Save(Connection, Transaction);
}
else
{
// creating a new legal guardian
ORM_CMN_BPT_BusinessParticipant newLegalGuardian = new ORM_CMN_BPT_BusinessParticipant();
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant legalGuardianLink = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
newLegalGuardian.DisplayName = Parameter.LegalGuardianName;
legalGuardianLink.AssociatedBusinessParticipant_RefID = newLegalGuardian.CMN_BPT_BusinessParticipantID;
legalGuardianLink.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
newLegalGuardian.Save(Connection, Transaction);
legalGuardianLink.Save(Connection, Transaction);
}
}
else
{
//delete old legal guardian if there is an old legal guardian
if (oldLegalGuardianConnectionExist)
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant oldLegalGuardianConnection = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, LGCheckQuery).First();
ORM_CMN_BPT_BusinessParticipant.Query oldLegalGuardianQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
oldLegalGuardianQuery.CMN_BPT_BusinessParticipantID = oldLegalGuardianConnection.AssociatedBusinessParticipant_RefID;
oldLegalGuardianQuery.IsDeleted = false;
//deleting old legal guardian from business participant table
if (ORM_CMN_BPT_BusinessParticipant.Query.Exists(Connection, Transaction, oldLegalGuardianQuery))
{
ORM_CMN_BPT_BusinessParticipant oldLegalGuardian = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, oldLegalGuardianQuery).First();
oldLegalGuardian.IsDeleted = true;
oldLegalGuardian.Save(Connection, Transaction);
}
// deleting connenction beetwen customer and legal guardian
oldLegalGuardianConnection.IsDeleted = true;
oldLegalGuardianConnection.Save(Connection, Transaction);
}
}
#endregion
personInfo.FirstName = Parameter.FirstName;
personInfo.LastName = Parameter.LastName;
personInfo.BirthDate = Parameter.BirthDate;
personInfo.IsRepresentedByLegalGuardian = Parameter.IsRepresentedByLegalGuardian;
personInfo.IsDeleted = Parameter.IsDelete;
bParticipant.IsDeleted = Parameter.IsDelete;
customer.IsDeleted = Parameter.IsDelete;
personInfo.Save(Connection, Transaction);
bParticipant.Save(Connection, Transaction);
customer.Save(Connection, Transaction);
returnValue.Result = customer.CMN_BPT_CTM_CustomerID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_SMP__1122 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
if (Parameter.isDeleted == true)
{
P_L3MP_DPBID_1026 param = new P_L3MP_DPBID_1026();
param.HEC_MedicalPractiseID = Parameter.PracticeID;
cls_Delete_Practice_By_ID.Invoke(Connection, Transaction, param, securityTicket);
}
else
{
#region Save
if (Parameter.PracticeID == Guid.Empty)
{
/*********************************
* Save ContactPerson
********************************/
//business Participants
ORM_CMN_BPT_BusinessParticipant contactPerson = new ORM_CMN_BPT_BusinessParticipant();
Guid businessParticipantsID = Guid.NewGuid();
contactPerson.CMN_BPT_BusinessParticipantID = businessParticipantsID;
contactPerson.IsCompany = false;
contactPerson.IsNaturalPerson = true;
contactPerson.IsTenant = false;
contactPerson.Creation_Timestamp = DateTime.Now;
contactPerson.Tenant_RefID = securityTicket.TenantID;
//person info
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
Guid personInfoID = Guid.NewGuid();
contactPerson.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfoID;
contactPerson.Save(Connection, Transaction);
personInfo.CMN_PER_PersonInfoID = personInfoID;
personInfo.FirstName = Parameter.ContactPersonFirstName;
personInfo.LastName = Parameter.ContactPersonLastName;
personInfo.PrimaryEmail = Parameter.ContactPersonEmail;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.Save(Connection, Transaction);
//Communication Contact
ORM_CMN_PER_CommunicationContact communicationContacts = new ORM_CMN_PER_CommunicationContact();
communicationContacts.CMN_PER_CommunicationContactID = Guid.NewGuid();
communicationContacts.PersonInfo_RefID = personInfoID;
communicationContacts.Contact_Type = Parameter.ContactTypePhone;
communicationContacts.Content = Parameter.ContactPersonPhoneNumber;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
/*********************************
* Save Practice
********************************/
P_L3MP_SPBI_1602 param = new P_L3MP_SPBI_1602();
param.Street_Number = Parameter.PracticeNumber;
param.Street_Name = Parameter.PracticeStreet;
param.Street_Name_Line2 = Parameter.PracticeStreet2;
param.PracticeName = Parameter.PracticeName;
param.isLucentis = true;
param.ifLucentis_BSNR = Parameter.BSNR;
param.PracticeEmail = Parameter.PracitceEmail;
param.Town = Parameter.Town;
param.ZIP = Parameter.ZIP;
param.HEC_MedicalPractiseID = Parameter.PracticeID;
Guid HEC_MedicalPractiseID = cls_Save_Practice_BaseInfo.Invoke(Connection, Transaction, param, securityTicket).Result;
/*********************************
* Save Cooperating Practices
********************************/
var queryMedicalPractice = new ORM_HEC_MedicalPractis.Query();
queryMedicalPractice.HEC_MedicalPractiseID = HEC_MedicalPractiseID;
queryMedicalPractice.IsDeleted = false;
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, queryMedicalPractice).FirstOrDefault();
if (medicalPractice != null)
{
medicalPractice.ContactPerson_RefID = businessParticipantsID;
medicalPractice.Save(Connection, Transaction);
var queryCompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
queryCompanyInfo.CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID;
queryCompanyInfo.IsDeleted = false;
var CompanyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, queryCompanyInfo).FirstOrDefault();
if (CompanyInfo != null)
{
var queryBussinessParticipients = new ORM_CMN_BPT_BusinessParticipant.Query();
queryBussinessParticipients.IfCompany_CMN_COM_CompanyInfo_RefID = CompanyInfo.CMN_COM_CompanyInfoID;
queryBussinessParticipients.IsDeleted = false;
var bussinessParticipants = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, queryBussinessParticipients).FirstOrDefault();
if (bussinessParticipants != null)
{
foreach (var cooperatingPractice in Parameter.CooperatingPractices)
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant associatedBussinessParticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedBussinessParticipants.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
associatedBussinessParticipants.IsDeleted = cooperatingPractice.isDeleted;
associatedBussinessParticipants.BusinessParticipant_RefID = bussinessParticipants.CMN_BPT_BusinessParticipantID;
associatedBussinessParticipants.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associatedBussinessParticipants.Creation_Timestamp = DateTime.Now;
associatedBussinessParticipants.Tenant_RefID = bussinessParticipants.Tenant_RefID;
associatedBussinessParticipants.Save(Connection, Transaction);
}
}
}
returnValue.Result = medicalPractice.HEC_MedicalPractiseID;
}
}
#endregion
else
{
/*********************************
* Edit Practice
********************************/
P_L3MP_SPBI_1602 param = new P_L3MP_SPBI_1602();
param.Street_Number = Parameter.PracticeNumber;
param.Street_Name = Parameter.PracticeStreet;
param.Street_Name_Line2 = Parameter.PracticeStreet2;
param.PracticeName = Parameter.PracticeName;
param.isLucentis = true;
param.ifLucentis_BSNR = Parameter.BSNR;
param.PracticeEmail = Parameter.PracitceEmail;
param.Town = Parameter.Town;
param.ZIP = Parameter.ZIP;
param.HEC_MedicalPractiseID = Parameter.PracticeID;
Guid HEC_MedicalPractiseID = cls_Save_Practice_BaseInfo.Invoke(Connection, Transaction, param, securityTicket).Result;
var medicalPracticeQuery = new ORM_HEC_MedicalPractis.Query();
medicalPracticeQuery.IsDeleted = false;
medicalPracticeQuery.HEC_MedicalPractiseID = HEC_MedicalPractiseID;
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, medicalPracticeQuery).FirstOrDefault();
if (medicalPractice != null)
{
/*********************************
* Edit Contact Person
********************************/
//contact person
var contactPerson = new ORM_CMN_BPT_BusinessParticipant();
var contactPersonQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
contactPersonQuery.IsDeleted = false;
if (medicalPractice.ContactPerson_RefID != Guid.Empty)
{
contactPersonQuery.CMN_BPT_BusinessParticipantID = medicalPractice.ContactPerson_RefID;
contactPerson = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, contactPersonQuery).FirstOrDefault();
}
else
{
contactPerson = null;
}
Guid personInfoID = Guid.NewGuid();
if (contactPerson == null)
{
contactPerson = new ORM_CMN_BPT_BusinessParticipant();
contactPerson.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
contactPerson.IsCompany = false;
contactPerson.IsNaturalPerson = true;
contactPerson.IsTenant = false;
contactPerson.Creation_Timestamp = DateTime.Now;
contactPerson.Tenant_RefID = securityTicket.TenantID;
contactPerson.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfoID;
contactPerson.Save(Connection, Transaction);
medicalPractice.ContactPerson_RefID = contactPerson.CMN_BPT_BusinessParticipantID;
medicalPractice.Save(Connection, Transaction);
}
var personInfo = new ORM_CMN_PER_PersonInfo();
//person info
var personInfoQuery = new ORM_CMN_PER_PersonInfo.Query();
personInfoQuery.IsDeleted = false;
personInfoQuery.CMN_PER_PersonInfoID = contactPerson.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, personInfoQuery).FirstOrDefault();
if (personInfo == null)
{
personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.CMN_PER_PersonInfoID = personInfoID;
contactPerson.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
contactPerson.Save(Connection, Transaction);
}
personInfo.FirstName = Parameter.ContactPersonFirstName;
personInfo.LastName = Parameter.ContactPersonLastName;
personInfo.PrimaryEmail = Parameter.ContactPersonEmail;
personInfo.Save(Connection, Transaction);
//Communication Contact
var communicationContacts = new ORM_CMN_PER_CommunicationContact();
var communicationContactsQuery = new ORM_CMN_PER_CommunicationContact.Query();
communicationContactsQuery.IsDeleted = false;
communicationContactsQuery.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
communicationContacts = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, communicationContactsQuery).FirstOrDefault();
if (communicationContacts == null)
{
communicationContacts = new ORM_CMN_PER_CommunicationContact();
communicationContacts.CMN_PER_CommunicationContactID = Guid.NewGuid();
communicationContacts.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
}
communicationContacts.Contact_Type = Parameter.ContactTypePhone;
communicationContacts.Content = Parameter.ContactPersonPhoneNumber;
communicationContacts.Save(Connection, Transaction);
/*********************************
* Edit Cooperating Practices
********************************/
var queryCompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
queryCompanyInfo.CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID;
queryCompanyInfo.IsDeleted = false;
var CompanyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, queryCompanyInfo).FirstOrDefault();
if (CompanyInfo != null)
{
var queryBussinessParticipients = new ORM_CMN_BPT_BusinessParticipant.Query();
queryBussinessParticipients.IfCompany_CMN_COM_CompanyInfo_RefID = CompanyInfo.CMN_COM_CompanyInfoID;
queryBussinessParticipients.IsDeleted = false;
var bussinessParticipants = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, queryBussinessParticipients).FirstOrDefault();
if (bussinessParticipants != null)
{
foreach (var cooperatingPractice in Parameter.CooperatingPractices)
{
var associatedBussinessParticipantsQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBussinessParticipantsQuery.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associatedBussinessParticipantsQuery.Tenant_RefID = bussinessParticipants.Tenant_RefID;
associatedBussinessParticipantsQuery.BusinessParticipant_RefID = bussinessParticipants.CMN_BPT_BusinessParticipantID;
var associtePractice = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBussinessParticipantsQuery).FirstOrDefault();
if (associtePractice != null)
{
associtePractice.IsDeleted = cooperatingPractice.isDeleted;
associtePractice.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associtePractice.Save(Connection, Transaction);
}
else
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant associatedBussinessParticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedBussinessParticipants.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
associatedBussinessParticipants.IsDeleted = cooperatingPractice.isDeleted;
associatedBussinessParticipants.BusinessParticipant_RefID = bussinessParticipants.CMN_BPT_BusinessParticipantID;
associatedBussinessParticipants.AssociatedBusinessParticipant_RefID = cooperatingPractice.PracticeID;
associatedBussinessParticipants.Creation_Timestamp = DateTime.Now;
associatedBussinessParticipants.Tenant_RefID = bussinessParticipants.Tenant_RefID;
associatedBussinessParticipants.Save(Connection, Transaction);
}
}
}
}
returnValue.Result = medicalPractice.HEC_MedicalPractiseID;
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PI_CDPfC_1134 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
#region get company tenant
ORM_CMN_BPT_BusinessParticipant.Query tenantBPQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
tenantBPQuery.IsTenant = true;
tenantBPQuery.IfTenant_Tenant_RefID = securityTicket.TenantID;
tenantBPQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant tenantBP = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, tenantBPQuery).First();
#endregion
#region check if tenant need default person
Boolean needDefaultPerson = tenantBP.IsNaturalPerson;
if (needDefaultPerson)
{
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query associatedBPQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBPQuery.AssociatedBusinessParticipant_RefID = tenantBP.CMN_BPT_BusinessParticipantID;
associatedBPQuery.IsDeleted = false;
List <ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant> association = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBPQuery);
if (association.Count > 0)
{
foreach (var item in association)
{
if ((item.BusinessParticipant_RefID != null) || (item.BusinessParticipant_RefID != Guid.Empty))
{
needDefaultPerson = false;
}
break;
}
}
}
#endregion
if (needDefaultPerson)
{
#region create personalInfo
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.IsDeleted = false;
personInfo.FirstName = tenantBP.DisplayName;
personInfo.LastName = tenantBP.DisplayName;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Save(Connection, Transaction);
#endregion
#region create new businessParticipiant
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.Tenant_RefID = securityTicket.TenantID;
bParticipant.IsNaturalPerson = true;
bParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
bParticipant.DisplayName = tenantBP.DisplayName;
bParticipant.Creation_Timestamp = DateTime.Now;
bParticipant.Save(Connection, Transaction);
#endregion
#region create associated businessParticipant table
ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant associatedBP = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedBP.CMN_BPT_BusinessParticipant_AssociatedBusinessParticipantID = Guid.NewGuid();
associatedBP.IsDeleted = false;
associatedBP.BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
associatedBP.AssociatedBusinessParticipant_RefID = tenantBP.CMN_BPT_BusinessParticipantID;
associatedBP.Creation_Timestamp = DateTime.Now;
associatedBP.Tenant_RefID = securityTicket.TenantID;
associatedBP.Save(Connection, Transaction);
#endregion
returnValue.Result = bParticipant.CMN_BPT_BusinessParticipantID;
}
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5MD_GDwPfID_1414 Execute(DbConnection Connection, DbTransaction Transaction, P_L5MD_GDwPfID_1414 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5MD_GDwPfID_1414();
P_L3MD_GDBIfID_1150 biParam = new P_L3MD_GDBIfID_1150();
biParam.DoctorID = Parameter.DoctorID;
var baseInfo = cls_Get_Doctor_BaseInfo_byID.Invoke(Connection, Transaction, biParam, securityTicket).Result;
returnValue.Result = new L5MD_GDwPfID_1414();
returnValue.Result.BaseInfo = baseInfo;
P_L3DAC_RACDbBPID_1056 aiParam = new P_L3DAC_RACDbBPID_1056();
aiParam.BPrticipantID = baseInfo.Doctor_CMN_BPT_BusinessParticipantID;
var accInfo = cls_Retrive_Account_Code_Details_byBParticipantID.Invoke(Connection, Transaction, aiParam, securityTicket).Result;
if (accInfo != null)
{
var AccountInfo = new L5MD_GDwPfID_1414_AccountInfo();
AccountInfo.AccountCode_ValidFrom = accInfo.AccountCode_ValidFrom;
AccountInfo.AccountCode_Value = accInfo.AccountCode_Value;
AccountInfo.USR_AccountID = baseInfo.Account_RefID;
AccountInfo.USR_Device_AccountCodeID = accInfo.USR_Device_AccountCodeID;
returnValue.Result.AccountInfo = AccountInfo;
}
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Ext_BusinessParticipant_RefID = baseInfo.Doctor_CMN_BPT_BusinessParticipantID;
customerQuery.IsDeleted = false;
var customerRes = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery);
if (customerRes.Count > 0)
{
var ORM_CMN_BPT_CTM_Customer_2_SalesRepresentativeQuery = new ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative.Query();
ORM_CMN_BPT_CTM_Customer_2_SalesRepresentativeQuery.Customer_RefID = customerRes.First().CMN_BPT_CTM_CustomerID;
ORM_CMN_BPT_CTM_Customer_2_SalesRepresentativeQuery.IsDeleted = false;
var ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative1 = ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative.Query.Search(Connection, Transaction, ORM_CMN_BPT_CTM_Customer_2_SalesRepresentativeQuery).First();
returnValue.Result.SalesRepresentative = new L5MD_GDwPfID_1414_SalesRepresentative();
returnValue.Result.SalesRepresentative.SalesRepresentative_RefID = ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative1.SalesRepresentative_RefID;
}
var assocBPQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
assocBPQuery.BusinessParticipant_RefID = baseInfo.Doctor_CMN_BPT_BusinessParticipantID;
assocBPQuery.IsDeleted = false;
var assocBPQs = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, assocBPQuery).ToArray();
if (assocBPQs.Length > 0)
{
assocBPQs = assocBPQs.OrderBy(a => a.Creation_Timestamp).ToArray();
var assocBPQ = assocBPQs.First();
var practiceBPQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
practiceBPQuery.CMN_BPT_BusinessParticipantID = assocBPQ.AssociatedBusinessParticipant_RefID;
var practiceBP = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, practiceBPQuery).First();
var companInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
companInfoQuery.CMN_COM_CompanyInfoID = practiceBP.IfCompany_CMN_COM_CompanyInfo_RefID;
var companInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companInfoQuery).First();
var practiceQuery = new ORM_HEC_MedicalPractis.Query();
practiceQuery.Ext_CompanyInfo_RefID = companInfo.CMN_COM_CompanyInfoID;
var prac = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, practiceQuery).First();
P_L3MP_GPfID_1222 pbiParam = new P_L3MP_GPfID_1222();
pbiParam.HEC_MedicalPractiseID = prac.HEC_MedicalPractiseID;
var practiceBasInfo = cls_Get_Practice_For_ID.Invoke(Connection, Transaction, pbiParam, securityTicket).Result;
if (practiceBasInfo != null)
{
L5MD_GDwPfID_1414_Practice practice = new L5MD_GDwPfID_1414_Practice();
practice.AssociatedParticipant_FunctionName = assocBPQ.AssociatedParticipant_FunctionName;
practice.CMN_BPT_BusinessParticipantID = practiceBasInfo.BaseInfo.CMN_BPT_BusinessParticipantID;
if (practiceBasInfo.OtherOphthal_PracticeData != null)
{
practice.HealthAssociation_Name = practiceBasInfo.OtherOphthal_PracticeData.HealthAssociation_Name;
}
practice.PracticeID = practiceBasInfo.BaseInfo.HEC_MedicalPractiseID;
practice.PracticeName = practiceBasInfo.BaseInfo.PracticeName;
practice.Region_Name = practiceBasInfo.BaseInfo.Region_Name;
practice.Street_Name = practiceBasInfo.BaseInfo.Street_Name;
practice.Street_Number = practiceBasInfo.BaseInfo.Street_Number;
practice.Town = practiceBasInfo.BaseInfo.Town;
practice.ZIP = practiceBasInfo.BaseInfo.ZIP;
returnValue.Result.Practice = practice;
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3MD_DDbID_1031 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var doctor = new ORM_HEC_Doctor();
if (Parameter.DoctorID != Guid.Empty)
{
var result = doctor.Load(Connection, Transaction, Parameter.DoctorID);
if (result.Status != FR_Status.Success || doctor.HEC_DoctorID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
doctor.IsDeleted = true;
doctor.Save(Connection, Transaction);
//bussinessParticipant
var query1 = new ORM_CMN_BPT_BusinessParticipant.Query();
query1.CMN_BPT_BusinessParticipantID = doctor.BusinessParticipant_RefID;
var bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query1).First();
bussinessParticipant.IsDeleted = true;
bussinessParticipant.Save(Connection, Transaction);
if (doctor.Account_RefID != Guid.Empty)
{
var account2personInfoQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
account2personInfoQuery.USR_Account_RefID = doctor.Account_RefID;
account2personInfoQuery.Tenant_RefID = securityTicket.TenantID;
var account2personInfo = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, account2personInfoQuery).FirstOrDefault();
if (account2personInfo != null)
{
account2personInfo.IsDeleted = true;
account2personInfo.Save(Connection, Transaction);
var query2 = new ORM_CMN_PER_PersonInfo.Query();
query2.CMN_PER_PersonInfoID = account2personInfo.CMN_PER_PersonInfo_RefID;
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query2).First();
personInfo.IsDeleted = true;
personInfo.Save(Connection, Transaction);
}
var query4 = new ORM_CMN_PER_CommunicationContact.Query();
query4.PersonInfo_RefID = bussinessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
var communicationContactsList = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query4).ToList();
foreach (var contact in communicationContactsList)
{
contact.IsDeleted = true;
contact.Save(Connection, Transaction);
}
}
var query3 = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
query3.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
query3.IsDeleted = false;
var abpRes = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, query3);
foreach (ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant assigned in abpRes)
{
assigned.IsDeleted = true;
assigned.Save(Connection, Transaction);
}
#endregion
ORM_CMN_BPT_CTM_Customer customer;
ORM_CMN_BPT_CTM_Customer_2_SalesRepresentative SalesRepresentative;
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Ext_BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
var customerRes = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery);
if (customerRes.Count != 0)
{
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();
customer.IsDeleted = true;
customer.Save(Connection, Transaction);
SalesRepresentative.IsDeleted = true;
SalesRepresentative.Save(Connection, Transaction);
}
var accountQuery = new ORM_USR_Account.Query();
accountQuery.BusinessParticipant_RefID = bussinessParticipant.CMN_BPT_BusinessParticipantID;
accountQuery.AccountType = 3;
var accountQueryRes = ORM_USR_Account.Query.Search(Connection, Transaction, accountQuery);
if (accountQueryRes.Count != 0)
{
var account = accountQueryRes.First();
account.IsDeleted = true;
account.Save(Connection, Transaction);
var codeQuery = new ORM_USR_Device_AccountCode.Query();
codeQuery.Account_RefID = account.USR_AccountID;
var code = ORM_USR_Device_AccountCode.Query.Search(Connection, Transaction, codeQuery).First();
code.IsDeleted = true;
code.Save(Connection, Transaction);
var codeStatusQuery = new ORM_USR_Device_AccountCode_StatusHistory.Query();
codeStatusQuery.Device_AccountCode_RefID = code.USR_Device_AccountCodeID;
var codeStatus = ORM_USR_Device_AccountCode_StatusHistory.Query.Search(Connection, Transaction, codeStatusQuery).First();
codeStatus.IsDeleted = true;
codeStatus.Save(Connection, Transaction);
}
}
returnValue.Result = doctor.HEC_DoctorID;
return(returnValue);
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3MP_DPBID_1026 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
P_L3MP_GPfID_1222 param = new P_L3MP_GPfID_1222();
param.HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID;
var practice = cls_Get_Practice_For_ID.Invoke(Connection, Transaction, param, securityTicket).Result;
if (practice != null)
{
ORM_CMN_UniversalContactDetail contactDetails = new ORM_CMN_UniversalContactDetail();
if (practice.BaseInfo.CMN_UniversalContactDetailID != Guid.Empty)
{
var result = contactDetails.Load(Connection, Transaction, practice.BaseInfo.CMN_UniversalContactDetailID);
if (result.Status != FR_Status.Success || contactDetails.CMN_UniversalContactDetailID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
contactDetails.IsDeleted = true;
contactDetails.Save(Connection, Transaction);
}
ORM_CMN_COM_CompanyInfo info = new ORM_CMN_COM_CompanyInfo();
if (practice.BaseInfo.CMN_COM_CompanyInfoID != Guid.Empty)
{
var result = info.Load(Connection, Transaction, practice.BaseInfo.CMN_COM_CompanyInfoID);
if (result.Status != FR_Status.Success || info.CMN_COM_CompanyInfoID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
info.IsDeleted = true;
info.Save(Connection, Transaction);
}
ORM_CMN_BPT_BusinessParticipant bParticipant = new ORM_CMN_BPT_BusinessParticipant();
if (practice.BaseInfo.CMN_BPT_BusinessParticipantID != Guid.Empty)
{
var result = bParticipant.Load(Connection, Transaction, practice.BaseInfo.CMN_BPT_BusinessParticipantID);
if (result.Status != FR_Status.Success || bParticipant.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
bParticipant.IsDeleted = true;
bParticipant.Save(Connection, Transaction);
}
ORM_HEC_MedicalPractis practis = new ORM_HEC_MedicalPractis();
if (practice.BaseInfo.HEC_MedicalPractiseID != Guid.Empty)
{
var result = practis.Load(Connection, Transaction, practice.BaseInfo.HEC_MedicalPractiseID);
if (result.Status != FR_Status.Success || practis.HEC_MedicalPractiseID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
practis.IsDeleted = true;
practis.Save(Connection, Transaction);
}
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
ORM_CMN_CAL_WeeklyOfficeHours_Template consultationHours = new ORM_CMN_CAL_WeeklyOfficeHours_Template();
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
var result = consultationHours.Load(Connection, Transaction, practice.BaseInfo.WeeklyOfficeHours_Template_RefID);
if (result.Status != FR_Status.Success || consultationHours.CMN_CAL_WeeklyOfficeHours_TemplateID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
consultationHours.IsDeleted = true;
consultationHours.Save(Connection, Transaction);
}
}
if (practice.BaseInfo.WeeklySurgeryHours_Template_RefID != Guid.Empty)
{
ORM_CMN_CAL_WeeklyOfficeHours_Template consultationHours = new ORM_CMN_CAL_WeeklyOfficeHours_Template();
if (practice.BaseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty)
{
var result = consultationHours.Load(Connection, Transaction, practice.BaseInfo.WeeklySurgeryHours_Template_RefID);
if (result.Status != FR_Status.Success || consultationHours.CMN_CAL_WeeklyOfficeHours_TemplateID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
consultationHours.IsDeleted = true;
consultationHours.Save(Connection, Transaction);
}
}
if (practice.ShippingAddress != null)
{
ORM_CMN_UniversalContactDetail shippingDetails = new ORM_CMN_UniversalContactDetail();
if (practice.ShippingAddress.CMN_UniversalContactDetailID != Guid.Empty)
{
var result = shippingDetails.Load(Connection, Transaction, practice.ShippingAddress.CMN_UniversalContactDetailID);
if (result.Status != FR_Status.Success || contactDetails.CMN_UniversalContactDetailID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
shippingDetails.IsDeleted = true;
shippingDetails.Save(Connection, Transaction);
}
ORM_CMN_COM_CompanyInfo_Address shippingAddress = new ORM_CMN_COM_CompanyInfo_Address();
if (practice.ShippingAddress.CMN_COM_CompanyInfo_AddressID != Guid.Empty)
{
var result = shippingAddress.Load(Connection, Transaction, practice.ShippingAddress.CMN_COM_CompanyInfo_AddressID);
if (result.Status != FR_Status.Success || shippingAddress.CMN_COM_CompanyInfo_AddressID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
shippingAddress.IsDeleted = true;
shippingAddress.Save(Connection, Transaction);
}
}
var associatedBussinessParticipantsQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
associatedBussinessParticipantsQuery.AssociatedBusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
associatedBussinessParticipantsQuery.IsDeleted = false;
var associatedBussinessParticipants = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, associatedBussinessParticipantsQuery);
if (associatedBussinessParticipants.Count != 0)
{
foreach (var assBussiness in associatedBussinessParticipants)
{
assBussiness.IsDeleted = true;
assBussiness.Save(Connection, Transaction);
//brisanje doktora ako je imao jednu praksu
//var d2pAssignmentQuery = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query();
//d2pAssignmentQuery.IsDeleted = false;
//d2pAssignmentQuery.BusinessParticipant_RefID = assBussiness.BusinessParticipant_RefID;
//var d2pAssignmentRes = ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant.Query.Search(Connection, Transaction, d2pAssignmentQuery).ToArray();
//if (d2pAssignmentRes.Length == 0)
//{
// var docQuery = new ORM_HEC_Doctor.Query();
// docQuery.BusinessParticipant_RefID = assBussiness.BusinessParticipant_RefID;
// var doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, docQuery).First();
// P_L3MD_DDbID_1031 delDoc = new P_L3MD_DDbID_1031();
// delDoc.DoctorID = doctor.HEC_DoctorID;
// var delRes = cls_Delete_Doctor_byID.Invoke(Connection, Transaction, delDoc, securityTicket).Result;
//}
}
}
if (practice.OtherOphthal_PracticeData != null)
{
ORM_HEC_PublicHealthcare_PhysitianAssociation association = new ORM_HEC_PublicHealthcare_PhysitianAssociation();
if (practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID != Guid.Empty)
{
var result = association.Load(Connection, Transaction, practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID);
if (result.Status != FR_Status.Success || association.HEC_PublicHealthcare_PhysitianAssociationID == Guid.Empty)
{
var item = STLD_MedicalAssociation.associationItems.FirstOrDefault(a => a.Value == practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID);
if (item != null)
{
association.IsDeleted = true;
association.HealthAssociation_Name = item.Text;
association.Save(Connection, Transaction);
}
}
}
var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query();
customerQuery.Ext_BusinessParticipant_RefID = practice.BaseInfo.CMN_BPT_BusinessParticipantID;
var customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).FirstOrDefault();
if (customer != null)
{
customer.IsDeleted = true;
customer.Save(Connection, Transaction);
}
var companyTypeQuery = new ORM_CMN_COM_CompanyInfo_Type.Query();
companyTypeQuery.IsDeleted = false;
companyTypeQuery.CMN_COM_CompanyInfo_TypeID = practice.OtherOphthal_PracticeData.CMN_COM_CompanyInfo_TypeID;
var companyType = ORM_CMN_COM_CompanyInfo_Type.Query.Search(Connection, Transaction, companyTypeQuery).First();
var pHealthcareQuery = new ORM_HEC_PublicHealthcare_PhysitianAssociation.Query();
pHealthcareQuery.HEC_PublicHealthcare_PhysitianAssociationID = practice.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID;
var pHealthcare = ORM_HEC_PublicHealthcare_PhysitianAssociation.Query.Search(Connection, Transaction, pHealthcareQuery).First();
pHealthcare.IsDeleted = true;
pHealthcare.Save(Connection, Transaction);
if (customer != null)
{
var affinityStatusQuery = new ORM_CMN_BPT_CTM_AffinityStatus.Query();
affinityStatusQuery.CMN_BPT_CTM_AffinityStatusID = customer.CustomerAffinityStatus_RefID;
var affinityStatus = ORM_CMN_BPT_CTM_AffinityStatus.Query.Search(Connection, Transaction, affinityStatusQuery).First();
if (affinityStatus != null)
{
affinityStatus.IsDeleted = true;
affinityStatus.Save(Connection, Transaction);
}
}
}
}
return(returnValue);
#endregion UserCode
}
