protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5OU_SOUGD_1221 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
#region Save
if (Parameter.OrgUnitID == null || Parameter.OrgUnitID == Guid.Empty)
{
//*******************MedicalPracticeType************************
var medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
foreach (var item in Parameter.MedicalPracticeType)
{
var medicalPractice2PracticeType = new ORM_HEC_MedicalPractice_2_PracticeType();
medicalPractice2PracticeType.AssignmentID = Guid.NewGuid();
medicalPractice2PracticeType.HEC_MedicalPractice_Type_RefID = item.HEC_MedicalPractice_TypeID;
medicalPractice2PracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medicalPractice2PracticeType.Tenant_RefID = securityTicket.TenantID;
medicalPractice2PracticeType.IsDeleted = false;
medicalPractice2PracticeType.Save(Connection, Transaction);
}
//******************* Office************************
var Office = new ORM_CMN_STR_Office();
Office.CMN_STR_OfficeID = Guid.NewGuid();
Office.Office_Name = Parameter.OrgUnitName_DictID;
Office.Tenant_RefID = securityTicket.TenantID;
if (Parameter.ParentID != null && Parameter.ParentID != Guid.Empty)
{
Office.Parent_RefID = Parameter.ParentID;
}
Office.Creation_Timestamp = DateTime.Now;
var officeQuery = new ORM_CMN_STR_Office.Query();
officeQuery.Tenant_RefID = securityTicket.TenantID;
int officeCount = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officeQuery).Count;
Office.Office_InternalNumber = String.Format("{0:00000}", officeCount + 1);
Office.Default_PhoneNumber = Parameter.Telephone;
Office.DisplayImage_Document_RefID = Parameter.DisplayImage_Document_RefID;
Office.Default_Email = Parameter.Email;
Office.Default_Website = Parameter.Website;
Office.Office_Description = new Dict("cmn_str_offices");
Office.Comment = Parameter.Notes;
Office.IsMedicalPractice = true;
Office.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
Office.Save(Connection, Transaction);
//*******************Save Address************************
foreach (var address in Parameter.Adresses)
{
var Office_2_Address = new ORM_CMN_STR_Office_Address();
Office_2_Address.CMN_STR_Office_AddressID = Guid.NewGuid();
Office_2_Address.IsBillingAddress = address.IsBillingAddress;
Office_2_Address.IsShippingAddress = address.IsShippingAddress;
Office_2_Address.IsSpecialAddress = address.IsSpecialAddress;
Office_2_Address.CMN_Address_RefID = address.AddressID;
Office_2_Address.Office_RefID = Office.CMN_STR_OfficeID;
Office_2_Address.Tenant_RefID = securityTicket.TenantID;
Office_2_Address.Creation_Timestamp = DateTime.Now;
Office_2_Address.IsDefault = address.IsDefault;
Office_2_Address.Save(Connection, Transaction);
var Address = new ORM_CMN_Address();
Address.CMN_AddressID = Office_2_Address.CMN_Address_RefID;
Address.Tenant_RefID = securityTicket.TenantID;
Address.Creation_Timestamp = DateTime.Now;
Address.City_Name = address.City;
Address.Street_Name = address.Street_Name;
Address.Street_Number = address.Street_Number;
Address.Country_ISOCode = address.CountryISO;
Address.Country_Name = address.CountryName;
Address.City_PostalCode = address.ZIP;
if (address.IsDefault)
{
Address.Lattitude = address.Lattitude;
Address.Longitude = address.Longitude;
}
Address.Save(Connection, Transaction);
}
//*******************Save Languages************************
foreach (var item in Parameter.SpokenLanguage)
{
var officeSpokenLanguages = new ORM_CMN_STR_Office_SpokenLanguage();
officeSpokenLanguages.CMN_STR_Office_SpokenLanguageID = Guid.NewGuid();
officeSpokenLanguages.Office_RefID = Office.CMN_STR_OfficeID;
officeSpokenLanguages.Language_RefID = item.CMN_LanguageID;
officeSpokenLanguages.IsDeleted = item.IsDeleted;
officeSpokenLanguages.Tenant_RefID = securityTicket.TenantID;
officeSpokenLanguages.Save(Connection, Transaction);
}
//*******************Save Contact Person************************
var responsiblePerson = new ORM_CMN_STR_Office_ResponsiblePerson();
responsiblePerson.CMN_STR_Office_ResponsiblePersonID = Guid.NewGuid();
responsiblePerson.Office_RefID = Office.CMN_STR_OfficeID;
responsiblePerson.CMN_BPT_EMP_Employee_RefID = Guid.NewGuid();
responsiblePerson.Tenant_RefID = securityTicket.TenantID;
responsiblePerson.Creation_Timestamp = DateTime.Now;
responsiblePerson.Save(Connection, Transaction);
var employee = new ORM_CMN_BPT_EMP_Employee();
employee.CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID;
employee.BusinessParticipant_RefID = Guid.NewGuid();
employee.Creation_Timestamp = DateTime.Now;
employee.Tenant_RefID = securityTicket.TenantID;
employee.Save(Connection, Transaction);
var businessParticpant = new ORM_CMN_BPT_BusinessParticipant();
businessParticpant.CMN_BPT_BusinessParticipantID = employee.BusinessParticipant_RefID;
businessParticpant.IsNaturalPerson = true;
businessParticpant.DisplayName = Parameter.ContactPerson.Title + " " + Parameter.ContactPerson.FirstName + " " + Parameter.ContactPerson.LastName;
businessParticpant.Tenant_RefID = securityTicket.TenantID;
businessParticpant.Creation_Timestamp = DateTime.Now;
businessParticpant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = Guid.NewGuid();
businessParticpant.Save(Connection, Transaction);
var personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = businessParticpant.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
personInfo.Title = Parameter.ContactPerson.Title;
personInfo.FirstName = Parameter.ContactPerson.FirstName;
personInfo.LastName = Parameter.ContactPerson.LastName;
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.Creation_Timestamp = DateTime.Now;
personInfo.Save(Connection, Transaction);
//*******************AppointmentType************************
foreach (var item in Parameter.AppoitmentType)
{
ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability orgUnitToAppointmentType = new ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability();
orgUnitToAppointmentType.PPS_TSK_Task_Template_OrganizationalUnitAvailabilityID = Guid.NewGuid();
orgUnitToAppointmentType.CMN_STR_Office_RefID = Office.CMN_STR_OfficeID;
orgUnitToAppointmentType.PPS_TSK_Task_Template_RefID = item.PPS_TSK_Task_Template_RefID;
orgUnitToAppointmentType.Creation_Timestamp = DateTime.Now;
orgUnitToAppointmentType.Tenant_RefID = securityTicket.TenantID;
orgUnitToAppointmentType.Save(Connection, Transaction);
}
returnValue.Result = Office.CMN_STR_OfficeID;
}
#endregion
#region Delete
else if (Parameter.IsDeleted)
{
List <Guid> guidList = new List <Guid>();
guidList.Add(Parameter.OrgUnitID);
cls_Delete_OrgsUnitsGeneralData.Invoke(Connection, Transaction, new P_L5OU_DOUGD_1221 {
OrgUnitID = guidList.ToArray()
}, securityTicket);
}
#endregion
#region Edit
else
{
var officeQuery = new ORM_CMN_STR_Office.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_STR_OfficeID = Parameter.OrgUnitID
};
var office = ORM_CMN_STR_Office.Query.Search(Connection, Transaction, officeQuery).Single();
office.Office_Name = Parameter.OrgUnitName_DictID;
office.Default_PhoneNumber = Parameter.Telephone;
office.DisplayImage_Document_RefID = Parameter.DisplayImage_Document_RefID;
office.Default_Email = Parameter.Email;
office.Comment = Parameter.Notes;
office.Default_Website = Parameter.Website;
if (Parameter.ParentID != null && Parameter.ParentID != Guid.Empty)
{
office.Parent_RefID = Parameter.ParentID;
}
office.IsMedicalPractice = true;
office.Save(Connection, Transaction);
//*******************Medical practice type************************
var medicalPractice2TypeQuery = new ORM_HEC_MedicalPractice_2_PracticeType.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_MedicalPractice_RefID = office.IfMedicalPractise_HEC_MedicalPractice_RefID
};
var medicalPractice2Type = ORM_HEC_MedicalPractice_2_PracticeType.Query.Search(Connection, Transaction, medicalPractice2TypeQuery).ToList();
foreach (var item in Parameter.MedicalPracticeType)
{
if (item.IsDeleted)
{
foreach (var medicalPractice2TypeItem in medicalPractice2Type)
{
if (medicalPractice2TypeItem.HEC_MedicalPractice_Type_RefID == item.HEC_MedicalPractice_TypeID)
{
medicalPractice2TypeItem.Tenant_RefID = securityTicket.TenantID;
if (office.IfMedicalPractise_HEC_MedicalPractice_RefID != Guid.Empty)
{
medicalPractice2TypeItem.HEC_MedicalPractice_RefID = office.IfMedicalPractise_HEC_MedicalPractice_RefID;
}
else
{
var medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
office.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
office.Save(Connection, Transaction);
medicalPractice2TypeItem.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
}
medicalPractice2TypeItem.IsDeleted = true;
medicalPractice2TypeItem.Save(Connection, Transaction);
break;
}
}
}
else
{
ORM_HEC_MedicalPractice_2_PracticeType medPracticeType = null;
foreach (var medicalPractice2TypeItem in medicalPractice2Type)
{
if (medicalPractice2TypeItem.HEC_MedicalPractice_Type_RefID == item.HEC_MedicalPractice_TypeID)
{
medPracticeType = medicalPractice2TypeItem;
if (medPracticeType.HEC_MedicalPractice_RefID == Guid.Empty)
{
var medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
office.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
office.Save(Connection, Transaction);
medPracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medPracticeType.Save(Connection, Transaction);
}
break;
}
}
if (medPracticeType == null)
{
medPracticeType = new ORM_HEC_MedicalPractice_2_PracticeType();
medPracticeType.Tenant_RefID = securityTicket.TenantID;
medPracticeType.IsDeleted = false;
medPracticeType.HEC_MedicalPractice_Type_RefID = item.HEC_MedicalPractice_TypeID;
if (office.IfMedicalPractise_HEC_MedicalPractice_RefID != Guid.Empty)
{
medPracticeType.HEC_MedicalPractice_RefID = office.IfMedicalPractise_HEC_MedicalPractice_RefID;
}
else
{
var medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
office.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
office.Save(Connection, Transaction);
medPracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
}
medPracticeType.Save(Connection, Transaction);
}
else
{
if (medPracticeType.IsDeleted)
{
medPracticeType.Tenant_RefID = securityTicket.TenantID;
medPracticeType.IsDeleted = true;
if (office.IfMedicalPractise_HEC_MedicalPractice_RefID != Guid.Empty)
{
medPracticeType.HEC_MedicalPractice_RefID = office.IfMedicalPractise_HEC_MedicalPractice_RefID;
}
else
{
var medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
office.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
office.Save(Connection, Transaction);
medPracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
}
medPracticeType.Save(Connection, Transaction);
}
}
}
}
//*******************Save Spoken Languages************************
var office_spoken_languages = new ORM_CMN_STR_Office_SpokenLanguage.Query()
{
Tenant_RefID = securityTicket.TenantID,
Office_RefID = office.CMN_STR_OfficeID,
IsDeleted = false
};
var officeSpokenLanguageQuery = ORM_CMN_STR_Office_SpokenLanguage.Query.Search(Connection, Transaction, office_spoken_languages);
foreach (var item in Parameter.SpokenLanguage)
{
ORM_CMN_STR_Office_SpokenLanguage officeSpokenLang = null;
foreach (var officeSpokenLanguageItem in officeSpokenLanguageQuery)
{
if (officeSpokenLanguageItem.Language_RefID == item.CMN_LanguageID && officeSpokenLanguageItem.Office_RefID == office.CMN_STR_OfficeID)
{
officeSpokenLang = officeSpokenLanguageItem;
break;
}
}
if (officeSpokenLang == null)
{
var officeSpokenLanguage = new ORM_CMN_STR_Office_SpokenLanguage();
officeSpokenLanguage.CMN_STR_Office_SpokenLanguageID = Guid.NewGuid();
officeSpokenLanguage.Language_RefID = item.CMN_LanguageID;
officeSpokenLanguage.IsDeleted = item.IsDeleted;
officeSpokenLanguage.Office_RefID = office.CMN_STR_OfficeID;
officeSpokenLanguage.Tenant_RefID = securityTicket.TenantID;
officeSpokenLanguage.Save(Connection, Transaction);
}
else
{
officeSpokenLang.Language_RefID = item.CMN_LanguageID;
officeSpokenLang.IsDeleted = item.IsDeleted;
officeSpokenLang.Save(Connection, Transaction);
}
}
//*******************Save Address************************
foreach (var address in Parameter.Adresses)
{
var Office_2_Address = ORM_CMN_STR_Office_Address.Query.Search(Connection, Transaction, new ORM_CMN_STR_Office_Address.Query()
{
IsBillingAddress = address.IsBillingAddress,
IsShippingAddress = address.IsShippingAddress,
IsSpecialAddress = address.IsSpecialAddress,
Office_RefID = office.CMN_STR_OfficeID,
Tenant_RefID = securityTicket.TenantID,
CMN_Address_RefID = address.AddressID,
IsDeleted = false
}).SingleOrDefault();
if (Office_2_Address == null)
{
Office_2_Address = new ORM_CMN_STR_Office_Address();
Office_2_Address.CMN_STR_Office_AddressID = Guid.NewGuid();
Office_2_Address.IsBillingAddress = address.IsBillingAddress;
Office_2_Address.IsShippingAddress = address.IsShippingAddress;
Office_2_Address.IsSpecialAddress = address.IsSpecialAddress;
Office_2_Address.CMN_Address_RefID = address.AddressID;
Office_2_Address.Office_RefID = office.CMN_STR_OfficeID;
Office_2_Address.Tenant_RefID = securityTicket.TenantID;
Office_2_Address.Creation_Timestamp = DateTime.Now;
}
Office_2_Address.IsDefault = address.IsDefault;
var Address = ORM_CMN_Address.Query.Search(Connection, Transaction, new ORM_CMN_Address.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_AddressID = Office_2_Address.CMN_Address_RefID
}).SingleOrDefault();
if (Address == null)
{
Address = new ORM_CMN_Address();
Address.CMN_AddressID = Office_2_Address.CMN_Address_RefID;
Address.Tenant_RefID = securityTicket.TenantID;
Address.Creation_Timestamp = DateTime.Now;
}
if (address.IsDeleted)
{
Address.IsDeleted = true;
Office_2_Address.IsDeleted = true;
}
else
{
Address.City_Name = address.City;
Address.Street_Name = address.Street_Name;
Address.Street_Number = address.Street_Number;
Address.Country_ISOCode = address.CountryISO;
Address.Country_Name = address.CountryName;
Address.City_PostalCode = address.ZIP;
if (address.IsDefault)
{
Address.Lattitude = address.Lattitude;
Address.Longitude = address.Longitude;
}
}
Office_2_Address.Save(Connection, Transaction);
Address.Save(Connection, Transaction);
}
//*******************AppointmentType************************
foreach (var item in Parameter.AppoitmentType)
{
var orgUnitToAppointmentTypeQuery = new ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability.Query();
orgUnitToAppointmentTypeQuery.CMN_STR_Office_RefID = Parameter.OrgUnitID;
orgUnitToAppointmentTypeQuery.PPS_TSK_Task_Template_RefID = item.PPS_TSK_Task_Template_RefID;
orgUnitToAppointmentTypeQuery.Tenant_RefID = securityTicket.TenantID;
orgUnitToAppointmentTypeQuery.IsDeleted = false;
var orgUnitToAppointmentType = ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability.Query.Search(Connection, Transaction, orgUnitToAppointmentTypeQuery).SingleOrDefault();
if (orgUnitToAppointmentType == null)
{
if (!item.IsDeleted)
{
orgUnitToAppointmentType = new ORM_PPS_TSK_Task_Template_OrganizationalUnitAvailability();
orgUnitToAppointmentType.PPS_TSK_Task_Template_OrganizationalUnitAvailabilityID = Guid.NewGuid();
orgUnitToAppointmentType.CMN_STR_Office_RefID = Parameter.OrgUnitID;
orgUnitToAppointmentType.PPS_TSK_Task_Template_RefID = item.PPS_TSK_Task_Template_RefID;
orgUnitToAppointmentType.Creation_Timestamp = DateTime.Now;
orgUnitToAppointmentType.Tenant_RefID = securityTicket.TenantID;
orgUnitToAppointmentType.Save(Connection, Transaction);
}
}
else
{
if (item.IsDeleted)
{
orgUnitToAppointmentType.IsDeleted = true;
orgUnitToAppointmentType.Save(Connection, Transaction);
}
}
}
//*******************Save Contact Person************************
var responsiblePerson = ORM_CMN_STR_Office_ResponsiblePerson.Query.Search(Connection, Transaction, new ORM_CMN_STR_Office_ResponsiblePerson.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Office_RefID = office.CMN_STR_OfficeID
}).Single();
var employee = ORM_CMN_BPT_EMP_Employee.Query.Search(Connection, Transaction, new ORM_CMN_BPT_EMP_Employee.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_BPT_EMP_EmployeeID = responsiblePerson.CMN_BPT_EMP_Employee_RefID
}).Single();
var businessParticpant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_BPT_BusinessParticipantID = employee.BusinessParticipant_RefID
}).Single();
businessParticpant.DisplayName = Parameter.ContactPerson.Title + " " + Parameter.ContactPerson.FirstName + " " + Parameter.ContactPerson.LastName;
businessParticpant.Save(Connection, Transaction);
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_PER_PersonInfoID = businessParticpant.IfNaturalPerson_CMN_PER_PersonInfo_RefID
}).Single();
personInfo.Title = Parameter.ContactPerson.Title;
personInfo.FirstName = Parameter.ContactPerson.FirstName;
personInfo.LastName = Parameter.ContactPerson.LastName;
personInfo.Save(Connection, Transaction);
returnValue.Result = office.CMN_STR_OfficeID;
}
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5PA_SPER_1422 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
var examination = ORM_HEC_ACT_PerformedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_ACT_PerformedActionID = Parameter.ExaminationID
}).Single();
ORM_HEC_ACT_PerformedAction_Referral examinationReferral = ORM_HEC_ACT_PerformedAction_Referral.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_Referral.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_ACT_PerformedAction_RefID = examination.HEC_ACT_PerformedActionID
}).SingleOrDefault();
//save
if (examinationReferral == null)
{
examinationReferral = new ORM_HEC_ACT_PerformedAction_Referral();
examinationReferral.Tenant_RefID = securityTicket.TenantID;
examinationReferral.HEC_ACT_PerformedAction_ReferralID = Guid.NewGuid();
examinationReferral.HEC_ACT_PerformedAction_RefID = examination.HEC_ACT_PerformedActionID;
examinationReferral.ReferralComment = Parameter.Comment;
if (Parameter.HospitalID != Guid.Empty)
{
var medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, new ORM_HEC_MedicalPractis.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
IsHospital = true,
HEC_MedicalPractiseID = Parameter.HospitalID
}).Single();
ORM_HEC_MedicalPractice_2_PracticeType medPrac2Type = ORM_HEC_MedicalPractice_2_PracticeType.Query.Search(Connection, Transaction, new ORM_HEC_MedicalPractice_2_PracticeType.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_MedicalPractice_RefID = Parameter.HospitalID
}).Single();
examinationReferral.ReferralTo_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
examinationReferral.ReferralTo_MedicalPracticeType_RefID = medPrac2Type.HEC_MedicalPractice_Type_RefID;
}
else
{
examinationReferral.ReferralTo_MedicalPractice_RefID = Guid.Empty;
examinationReferral.ReferralTo_MedicalPracticeType_RefID = Parameter.ReferralPracticeTypeID;
}
examinationReferral.ReferralTo_BusinessParticipant_RefID = Guid.Empty;
if (Parameter.RecomendedDoctorID != Guid.Empty)
{
var doctorBusinessParticipant = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_DoctorID = Parameter.RecomendedDoctorID
}).Single().BusinessParticipant_RefID;
examinationReferral.ReferralTo_BusinessParticipant_RefID = doctorBusinessParticipant;
}
ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure performedActionProcedure = new ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure();
performedActionProcedure.Action_Referral_RefID = examinationReferral.HEC_ACT_PerformedAction_ReferralID;
performedActionProcedure.PotentialTreatment_RefID = Parameter.ProcedureID;
performedActionProcedure.Tenant_RefID = securityTicket.TenantID;
performedActionProcedure.Save(Connection, Transaction);
examinationReferral.Save(Connection, Transaction);
}
else
{//edit
if (!Parameter.IsDeleted)
{
examinationReferral.ReferralComment = Parameter.Comment;
if (Parameter.HospitalID != Guid.Empty)
{
if (examinationReferral.ReferralTo_MedicalPracticeType_RefID == null)
{
examinationReferral.ReferralTo_MedicalPracticeType_RefID = new Guid();
}
examinationReferral.ReferralTo_MedicalPracticeType_RefID = Guid.Empty;
if (examinationReferral.ReferralTo_BusinessParticipant_RefID == null)
{
examinationReferral.ReferralTo_BusinessParticipant_RefID = new Guid();
}
examinationReferral.ReferralTo_BusinessParticipant_RefID = Guid.Empty;
examinationReferral.ReferralTo_MedicalPractice_RefID = Parameter.HospitalID;
ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure performedActionProcedure = ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Action_Referral_RefID = examinationReferral.HEC_ACT_PerformedAction_ReferralID
}).SingleOrDefault();
if (performedActionProcedure != null)
{
performedActionProcedure.IsDeleted = true;
performedActionProcedure.Save(Connection, Transaction);
}
examinationReferral.Save(Connection, Transaction);
}
else
{
examinationReferral.ReferralTo_MedicalPracticeType_RefID = Parameter.ReferralPracticeTypeID;
examinationReferral.ReferralTo_MedicalPractice_RefID = Parameter.HospitalID;
ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure performedActionProcedure = ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Action_Referral_RefID = examinationReferral.HEC_ACT_PerformedAction_ReferralID
}).SingleOrDefault();
if (performedActionProcedure == null)
{
performedActionProcedure = new ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure();
performedActionProcedure.Action_Referral_RefID = examinationReferral.HEC_ACT_PerformedAction_ReferralID;
performedActionProcedure.HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedureID = Guid.NewGuid();
performedActionProcedure.Tenant_RefID = securityTicket.TenantID;
performedActionProcedure.Save(Connection, Transaction);
}
performedActionProcedure.PotentialTreatment_RefID = Parameter.ProcedureID;
performedActionProcedure.Save(Connection, Transaction);
examinationReferral.ReferralTo_BusinessParticipant_RefID = Guid.Empty;
if (Parameter.RecomendedDoctorID != Guid.Empty)
{
var doctorBusinessParticipant = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_DoctorID = Parameter.RecomendedDoctorID
}).Single().BusinessParticipant_RefID;
examinationReferral.ReferralTo_BusinessParticipant_RefID = doctorBusinessParticipant;
}
examinationReferral.Save(Connection, Transaction);
}
}
else
{//delete
ORM_HEC_ACT_PerformedAction_Referral refferal = ORM_HEC_ACT_PerformedAction_Referral.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_Referral.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_ACT_PerformedAction_RefID = examination.HEC_ACT_PerformedActionID
}).Single();
ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure performedActionProcedure = ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction_Referral_RequestedPotentialProcedure.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Action_Referral_RefID = refferal.HEC_ACT_PerformedAction_ReferralID
}).Single();
performedActionProcedure.IsDeleted = true;
performedActionProcedure.Save(Connection, Transaction);
refferal.IsDeleted = true;
refferal.Save(Connection, Transaction);
}
}
returnValue.Result = true;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DI_SRMP_1425 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
P_L2LN_GALFTID_1530 langParam = new P_L2LN_GALFTID_1530();
langParam.Tenant_RefID = securityTicket.TenantID;
var DBLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, langParam, securityTicket).Result;
#region Save
if (Parameter.HEC_MedicalPractiseID == Guid.Empty)
{
ORM_HEC_MedicalPractis medicalPractice = new ORM_HEC_MedicalPractis();
medicalPractice.HEC_MedicalPractiseID = Guid.NewGuid();
medicalPractice.IsHospital = Parameter.IsHospital;
medicalPractice.Tenant_RefID = securityTicket.TenantID;
medicalPractice.IsDeleted = false;
medicalPractice.Save(Connection, Transaction);
//*******************Save Medical Practice Type*******************
if (Parameter.MedicalPracticeType != null && Parameter.MedicalPracticeType.Count() > 0)
{
foreach (var medicalPracticeTypeParam in Parameter.MedicalPracticeType)
{
if (!medicalPracticeTypeParam.IsDeleted)
{
ORM_HEC_MedicalPractice_2_PracticeType medicalPracticeType = new ORM_HEC_MedicalPractice_2_PracticeType();
medicalPracticeType.AssignmentID = Guid.NewGuid();
medicalPracticeType.HEC_MedicalPractice_Type_RefID = medicalPracticeTypeParam.HEC_MedicalPractice_TypeID;
medicalPracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medicalPracticeType.Tenant_RefID = securityTicket.TenantID;
medicalPracticeType.IsDeleted = false;
medicalPracticeType.Save(Connection, Transaction);
}
}
}
//*******************Save Medical Practice Service*******************
//on front we must find if medical practice already exist for given service name
if (Parameter.MedicalService != null && Parameter.MedicalService.Count() > 0)
{
//ORM_HEC_MedicalService medicalService = ORM_HEC_MedicalService.Query.Search(Connection, Transaction, new ORM_HEC_MedicalService.Query
//{
// HEC_MedicalServiceID = Parameter.MedicalService.HEC_MedicalServiceID,
// IsDeleted = false,
// Tenant_RefID = securityTicket.TenantID
//}).SingleOrDefault();
foreach (var medicalServiceParam in Parameter.MedicalService)
{
ORM_HEC_MedicalService medicalService = new ORM_HEC_MedicalService();
if (medicalServiceParam.NewMedicalService)
{
medicalService.HEC_MedicalServiceID = Guid.NewGuid();
medicalService.ServiceName = medicalServiceParam.ServiceName;
medicalService.Tenant_RefID = securityTicket.TenantID;
medicalService.IsDeleted = false;
medicalService.Save(Connection, Transaction);
}
ORM_HEC_MedicalPractice_OfferedService medicalPracticeOfferedService = new ORM_HEC_MedicalPractice_OfferedService();
if (!medicalServiceParam.NewMedicalService)
{
medicalPracticeOfferedService.MedicalService_RefID = medicalServiceParam.HEC_MedicalServiceID;
}
else
{
medicalPracticeOfferedService.MedicalService_RefID = medicalService.HEC_MedicalServiceID;
}
medicalPracticeOfferedService.MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medicalPracticeOfferedService.IsDeleted = false;
medicalPracticeOfferedService.Tenant_RefID = securityTicket.TenantID;
medicalPracticeOfferedService.Save(Connection, Transaction);
}
}
//*******************Save Contact Person************************
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.CMN_PER_PersonInfoID = Guid.NewGuid();
personInfo.Title = Parameter.ContactPersonTitle;
personInfo.FirstName = Parameter.ContactPersonFirstName;
personInfo.LastName = Parameter.ContactPersonLastName;
personInfo.Tenant_RefID = securityTicket.TenantID;
personInfo.IsDeleted = false;
personInfo.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant businessParticpant = new ORM_CMN_BPT_BusinessParticipant();
businessParticpant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
businessParticpant.IsNaturalPerson = true;
businessParticpant.DisplayName = Parameter.ContactPersonTitle + " " + Parameter.ContactPersonFirstName + " " + Parameter.ContactPersonLastName;
businessParticpant.Tenant_RefID = securityTicket.TenantID;
businessParticpant.IsDeleted = false;
businessParticpant.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
businessParticpant.Save(Connection, Transaction);
medicalPractice.ContactPerson_RefID = businessParticpant.CMN_BPT_BusinessParticipantID;
//*******************Customer OrganizationalUnit************************
ORM_CMN_BPT_CTM_OrganizationalUnit organizationalUnit = new ORM_CMN_BPT_CTM_OrganizationalUnit();
organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID = Guid.NewGuid();
Dict medicationPracticeName = new Dict("hec_dia_potentialdiagnoses");
for (int i = 0; i < DBLanguages.Length; i++)
{
medicationPracticeName.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.MedicalPractiseName);
}
organizationalUnit.OrganizationalUnit_Name = medicationPracticeName;
organizationalUnit.IsDeleted = false;
organizationalUnit.Tenant_RefID = securityTicket.TenantID;
organizationalUnit.Default_PhoneNumber = Parameter.Contact_Telephone;
organizationalUnit.IsMedicalPractice = true;
organizationalUnit.IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
organizationalUnit.Save(Connection, Transaction);
//*******************AppointmentType************************
//if (Parameter.AppoitmentType != null && Parameter.AppoitmentType.Count() > 0)
//{
// foreach (var item in Parameter.AppoitmentType)
// {
// ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability customerOrgUnitAvailability = new ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability();
// customerOrgUnitAvailability.PPS_TSK_Task_Template_CustomerOrgUnitAvailabilityID = Guid.NewGuid();
// customerOrgUnitAvailability.CMN_BPT_CTM_OrganizationalUnit_RefID = organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID;
// customerOrgUnitAvailability.PPS_TSK_Task_Template_RefID = item.PPS_TSK_Task_Template_RefID;
// customerOrgUnitAvailability.Tenant_RefID = securityTicket.TenantID;
// customerOrgUnitAvailability.Save(Connection, Transaction);
// }
//}
//*******************Save Address************************
ORM_CMN_UniversalContactDetail contactDetail = new ORM_CMN_UniversalContactDetail();
contactDetail.CMN_UniversalContactDetailID = Guid.NewGuid();
contactDetail.IsCompany = true;
contactDetail.Street_Name = Parameter.Street_Name;
contactDetail.Street_Number = Parameter.Street_Number;
contactDetail.Town = Parameter.Town;
contactDetail.Contact_Website_URL = Parameter.Contact_Website_URL;
contactDetail.Contact_Telephone = Parameter.Contact_Telephone;
contactDetail.IsDeleted = false;
contactDetail.Tenant_RefID = securityTicket.TenantID;
contactDetail.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = Guid.NewGuid();
companyInfo.Contact_UCD_RefID = contactDetail.CMN_UniversalContactDetailID;
companyInfo.IsDeleted = false;
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Save(Connection, Transaction);
medicalPractice.Ext_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
medicalPractice.Save(Connection, Transaction);
//*******************Save Address************************
//ORM_CMN_UniversalContactDetail contactDetail = new ORM_CMN_UniversalContactDetail();
//contactDetail.CMN_UniversalContactDetailID = Guid.NewGuid();
//contactDetail.IsCompany = true;
//contactDetail.Street_Name = Parameter.Street_Name;
//contactDetail.Street_Number = Parameter.Street_Number;
//contactDetail.Town = Parameter.Town;
//contactDetail.Contact_Website_URL = Parameter.Contact_Website_URL;
//contactDetail.Contact_Telephone = Parameter.Contact_Telephone;
//contactDetail.IsDeleted = false;
//contactDetail.Tenant_RefID = securityTicket.TenantID;
//contactDetail.Save(Connection, Transaction);
//ORM_CMN_BPT_CTM_OrganizationalUnit_Address organizationalUnitAddress = new ORM_CMN_BPT_CTM_OrganizationalUnit_Address();
//organizationalUnitAddress.UniversalContactDetail_Address_RefID = contactDetail.CMN_UniversalContactDetailID;
//organizationalUnitAddress.OrganizationalUnit_RefID = organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID;
//organizationalUnitAddress.IsDeleted = false;
//organizationalUnitAddress.Tenant_RefID = securityTicket.TenantID;
//organizationalUnitAddress.Save(Connection, Transaction);
returnValue.Result = medicalPractice.HEC_MedicalPractiseID;
}
#endregion
//=====================Edit or Delete=====================
else
{
ORM_HEC_MedicalPractis medicalPractice = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, new ORM_HEC_MedicalPractis.Query
{
HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
ORM_CMN_BPT_CTM_OrganizationalUnit organizationalUnit = ORM_CMN_BPT_CTM_OrganizationalUnit.Query.Search(Connection, Transaction, new ORM_CMN_BPT_CTM_OrganizationalUnit.Query
{
IfMedicalPractise_HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
#region Edit
if (Parameter.IsDeleted == false)
{
//*******************Edit Medical Practice Service*******************
if (Parameter.MedicalService != null && Parameter.MedicalService.Count() > 0)
{
foreach (var medicalServiceParam in Parameter.MedicalService)
{
ORM_HEC_MedicalPractice_OfferedService medicalPracticeOfferedService = ORM_HEC_MedicalPractice_OfferedService.Query.Search(Connection, Transaction, new ORM_HEC_MedicalPractice_OfferedService.Query
{
HEC_MedicalPractice_OfferedServiceID = medicalServiceParam.HEC_MedicalPractice_OfferedServiceID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
ORM_HEC_MedicalService medicalService = ORM_HEC_MedicalService.Query.Search(Connection, Transaction, new ORM_HEC_MedicalService.Query
{
HEC_MedicalServiceID = medicalServiceParam.HEC_MedicalServiceID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (medicalServiceParam.NewMedicalService && !medicalServiceParam.IsDeleted)
{
medicalService = new ORM_HEC_MedicalService();
medicalService.HEC_MedicalServiceID = Guid.NewGuid();
medicalService.ServiceName = medicalServiceParam.ServiceName;
medicalService.Tenant_RefID = securityTicket.TenantID;
medicalService.IsDeleted = false;
medicalService.Save(Connection, Transaction);
}
if (medicalPracticeOfferedService == null && !medicalServiceParam.IsDeleted)
{
medicalPracticeOfferedService = new ORM_HEC_MedicalPractice_OfferedService();
if (!medicalServiceParam.NewMedicalService)
{
medicalPracticeOfferedService.MedicalService_RefID = medicalServiceParam.HEC_MedicalServiceID;
}
else
{
medicalPracticeOfferedService.MedicalService_RefID = medicalService.HEC_MedicalServiceID;
}
medicalPracticeOfferedService.MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medicalPracticeOfferedService.IsDeleted = false;
medicalPracticeOfferedService.Tenant_RefID = securityTicket.TenantID;
medicalPracticeOfferedService.Save(Connection, Transaction);
}
else if (medicalPracticeOfferedService != null && !medicalServiceParam.IsDeleted)
{
medicalPracticeOfferedService.MedicalService_RefID = medicalService.HEC_MedicalServiceID;
medicalPracticeOfferedService.Save(Connection, Transaction);
}
else if (medicalPracticeOfferedService != null && medicalServiceParam.IsDeleted)
{
medicalPracticeOfferedService.IsDeleted = true;
medicalPracticeOfferedService.Save(Connection, Transaction);
}
}
}
//*******************Edit Customer OrganizationalUnit************************
Dict medicationPracticeName = new Dict("hec_dia_potentialdiagnoses");
for (int i = 0; i < DBLanguages.Length; i++)
{
medicationPracticeName.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.MedicalPractiseName);
}
organizationalUnit.OrganizationalUnit_Name = medicationPracticeName;
organizationalUnit.Default_PhoneNumber = Parameter.Contact_Telephone;
organizationalUnit.Save(Connection, Transaction);
//*******************Edit Contact Person************************
ORM_CMN_BPT_BusinessParticipant businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = medicalPractice.ContactPerson_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
businessParticipant.DisplayName = Parameter.ContactPersonTitle + " " + Parameter.ContactPersonFirstName + " " + Parameter.ContactPersonLastName;
businessParticipant.Save(Connection, Transaction);
ORM_CMN_PER_PersonInfo personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo.Query
{
CMN_PER_PersonInfoID = businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
personInfo.Title = Parameter.ContactPersonTitle;
personInfo.FirstName = Parameter.ContactPersonFirstName;
personInfo.LastName = Parameter.ContactPersonLastName;
personInfo.Save(Connection, Transaction);
//*******************Edit Medical Practice Type*******************
foreach (var medicalPracticeTypeParam in Parameter.MedicalPracticeType)
{
ORM_HEC_MedicalPractice_2_PracticeType existingPracticeType = ORM_HEC_MedicalPractice_2_PracticeType.Query.Search(Connection, Transaction, new ORM_HEC_MedicalPractice_2_PracticeType.Query
{
HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID,
HEC_MedicalPractice_Type_RefID = medicalPracticeTypeParam.HEC_MedicalPractice_TypeID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (existingPracticeType == null && !medicalPracticeTypeParam.IsDeleted)
{
ORM_HEC_MedicalPractice_2_PracticeType medicalPracticeType = new ORM_HEC_MedicalPractice_2_PracticeType();
medicalPracticeType.AssignmentID = Guid.NewGuid();
medicalPracticeType.HEC_MedicalPractice_Type_RefID = medicalPracticeTypeParam.HEC_MedicalPractice_TypeID;
medicalPracticeType.HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID;
medicalPracticeType.Tenant_RefID = securityTicket.TenantID;
medicalPracticeType.IsDeleted = false;
medicalPracticeType.Save(Connection, Transaction);
}
else if (existingPracticeType != null && !medicalPracticeTypeParam.IsDeleted)
{
existingPracticeType.HEC_MedicalPractice_Type_RefID = medicalPracticeTypeParam.HEC_MedicalPractice_TypeID;
existingPracticeType.Save(Connection, Transaction);
}
else if (existingPracticeType != null && medicalPracticeTypeParam.IsDeleted)
{
existingPracticeType.IsDeleted = true;
existingPracticeType.Save(Connection, Transaction);
}
}
//*******************Edit AppointmentType*******************
//if (Parameter.AppoitmentType != null && Parameter.AppoitmentType.Count() > 0)
//{
// foreach (var appointmentTypeParam in Parameter.AppoitmentType)
// {
// ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability existingAppointmentType = ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability.Query
// {
// CMN_BPT_CTM_OrganizationalUnit_RefID = organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID,
// PPS_TSK_Task_Template_RefID = appointmentTypeParam.PPS_TSK_Task_Template_RefID,
// IsDeleted = false,
// Tenant_RefID = securityTicket.TenantID
// }).SingleOrDefault();
// if (existingAppointmentType == null & !appointmentTypeParam.IsDeleted)
// {
// ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability customerOrgUnitAvailability = new ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability();
// customerOrgUnitAvailability.PPS_TSK_Task_Template_CustomerOrgUnitAvailabilityID = Guid.NewGuid();
// customerOrgUnitAvailability.CMN_BPT_CTM_OrganizationalUnit_RefID = organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID;
// customerOrgUnitAvailability.PPS_TSK_Task_Template_RefID = appointmentTypeParam.PPS_TSK_Task_Template_RefID;
// customerOrgUnitAvailability.Tenant_RefID = securityTicket.TenantID;
// customerOrgUnitAvailability.Save(Connection, Transaction);
// }
// else if (existingAppointmentType != null & !appointmentTypeParam.IsDeleted)
// {
// existingAppointmentType.PPS_TSK_Task_Template_RefID = appointmentTypeParam.PPS_TSK_Task_Template_RefID;
// existingAppointmentType.Save(Connection, Transaction);
// }
// else if (existingAppointmentType != null & !appointmentTypeParam.IsDeleted)
// {
// existingAppointmentType.IsDeleted = true;
// existingAppointmentType.Save(Connection, Transaction);
// }
// }
//}
//*******************Edit Address and name************************
ORM_CMN_COM_CompanyInfo companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, new ORM_CMN_COM_CompanyInfo.Query
{
CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
ORM_CMN_UniversalContactDetail contactDetail = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, new ORM_CMN_UniversalContactDetail.Query
{
CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
contactDetail.Street_Name = Parameter.Street_Name;
contactDetail.Street_Number = Parameter.Street_Number;
contactDetail.Town = Parameter.Town;
contactDetail.Contact_Website_URL = Parameter.Contact_Website_URL;
contactDetail.Contact_Telephone = Parameter.Contact_Telephone;
contactDetail.Save(Connection, Transaction);
returnValue.Result = medicalPractice.HEC_MedicalPractiseID;
}
#endregion
#region Delete
else
{
ORM_HEC_MedicalPractice_2_PracticeType.Query.SoftDelete(Connection, Transaction, new ORM_HEC_MedicalPractice_2_PracticeType.Query
{
HEC_MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_Template_CustomerOrgUnitAvailability.Query
{
CMN_BPT_CTM_OrganizationalUnit_RefID = organizationalUnit.CMN_BPT_CTM_OrganizationalUnitID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
ORM_HEC_MedicalPractice_OfferedService.Query.SoftDelete(Connection, Transaction, new ORM_HEC_MedicalPractice_OfferedService.Query
{
MedicalPractice_RefID = medicalPractice.HEC_MedicalPractiseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
ORM_CMN_BPT_BusinessParticipant businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = medicalPractice.ContactPerson_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
businessParticipant.IsDeleted = true;
ORM_CMN_PER_PersonInfo personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo.Query
{
CMN_PER_PersonInfoID = businessParticipant.IfNaturalPerson_CMN_PER_PersonInfo_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
personInfo.IsDeleted = true;
ORM_CMN_COM_CompanyInfo companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, new ORM_CMN_COM_CompanyInfo.Query
{
CMN_COM_CompanyInfoID = medicalPractice.Ext_CompanyInfo_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
companyInfo.IsDeleted = true;
ORM_CMN_UniversalContactDetail contactDetail = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, new ORM_CMN_UniversalContactDetail.Query
{
CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
contactDetail.IsDeleted = true;
ORM_HEC_MedicalPractis.Query.SoftDelete(Connection, Transaction, new ORM_HEC_MedicalPractis.Query
{
HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
contactDetail.Save(Connection, Transaction);
companyInfo.Save(Connection, Transaction);
personInfo.Save(Connection, Transaction);
businessParticipant.Save(Connection, Transaction);
}
#endregion
returnValue.Result = medicalPractice.HEC_MedicalPractiseID;
}
return(returnValue);
#endregion UserCode
}
