protected static FR_L5PP_GPFTIDaPIDA_1406 Execute(DbConnection Connection, DbTransaction Transaction, P_L5PP_GPFTIDaPIDA_1406 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5PP_GPFTIDaPIDA_1406(); returnValue.Result = new L5PP_GPFTIDaPIDA_1406(); returnValue.Result.ContactPerson = new L3MP_GPCPfPID_1155(); returnValue.Result.PracticeData = new L3MP_GPBIfID_1131(); List <L3MP_GCPfPBITID_1228> copPractices = new List <L3MP_GCPfPBITID_1228>(); returnValue.Result.CooperatingPractices = copPractices.ToArray(); P_L3MP_GPBIfID_1131 par = new P_L3MP_GPBIfID_1131(); par.HEC_MedicalPractiseID = Parameter.PracticeID; L3MP_GPBIfID_1131 PracticeData = cls_Get_Practice_BaseInfo_For_ID.Invoke(Connection, Transaction, par, securityTicket).Result; returnValue.Result.PracticeData = PracticeData; P_L3MP_GPCPfPID_1155 param = new P_L3MP_GPCPfPID_1155(); param.CMN_BPT_BusinessParticipantID = PracticeData.ContactPerson_RefID; L3MP_GPCPfPID_1155 ContactPerson = cls_Get_Practice_ContactPerson_For_PersonID.Invoke(Connection, Transaction, param, securityTicket).Result; returnValue.Result.ContactPerson = ContactPerson; P_L3MP_GCPfPBITID_1228 parameter = new P_L3MP_GCPfPBITID_1228(); parameter.PracticeBussinessParticipant_RefID = PracticeData.CMN_BPT_BusinessParticipantID; List <L3MP_GCPfPBITID_1228> CooperatingPractices = cls_Get_CooperatingPractices_For_PracticeBussinessID_and_TenantID.Invoke(Connection, Transaction, parameter, securityTicket).Result.ToList(); returnValue.Result.CooperatingPractices = CooperatingPractices.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L3MP_GPfID_1222 Execute(DbConnection Connection, DbTransaction Transaction, P_L3MP_GPfID_1222 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L3MP_GPfID_1222(); returnValue.Result = new L3MP_GPfID_1222(); P_L3MP_GPBIfID_1131 paramBasicInfo = new P_L3MP_GPBIfID_1131(); paramBasicInfo.HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID; var baseInfo = cls_Get_Practice_BaseInfo_For_ID.Invoke(Connection, Transaction, paramBasicInfo, securityTicket).Result; if (baseInfo == null) { returnValue.Result = null; return(returnValue); } returnValue.Result.BaseInfo = baseInfo; P_L3MP_GPCPfPID_1155 paramCP = new P_L3MP_GPCPfPID_1155(); paramCP.CMN_BPT_BusinessParticipantID = baseInfo.ContactPerson_RefID; var contactPerson = cls_Get_Practice_ContactPerson_For_PersonID.Invoke(Connection, Transaction, paramCP, securityTicket).Result; returnValue.Result.ContactPerson = contactPerson; if (baseInfo.WeeklyOfficeHours_Template_RefID != Guid.Empty && baseInfo.WeeklySurgeryHours_Template_RefID != Guid.Empty) { returnValue.Result.OfficeHours = new L3MP_GPfID_1222_OfficeHours(); var officeHoursQuery = new ORM_CMN_CAL_WeeklyOfficeHours_Template.Query(); officeHoursQuery.IsDeleted = false; officeHoursQuery.Tenant_RefID = securityTicket.TenantID; officeHoursQuery.CMN_CAL_WeeklyOfficeHours_TemplateID = baseInfo.WeeklyOfficeHours_Template_RefID; var officeHours = ORM_CMN_CAL_WeeklyOfficeHours_Template.Query.Search(Connection, Transaction, officeHoursQuery).First(); returnValue.Result.OfficeHours.WorkingHours_FormattedOfficeHours = officeHours.FormattedOfficeHours; officeHoursQuery.CMN_CAL_WeeklyOfficeHours_TemplateID = baseInfo.WeeklySurgeryHours_Template_RefID; var consultingHours = ORM_CMN_CAL_WeeklyOfficeHours_Template.Query.Search(Connection, Transaction, officeHoursQuery).First(); returnValue.Result.OfficeHours.ConsultingHours_FormattedOfficeHours = consultingHours.FormattedOfficeHours; returnValue.Result.OtherOphthal_PracticeData = new L3MP_GPfID_1222_OtherOphthal_PracticeData(); var companyTypeQuery = new ORM_CMN_COM_CompanyInfo_Type.Query(); companyTypeQuery.IsDeleted = false; companyTypeQuery.CMN_COM_CompanyInfo_TypeID = baseInfo.CompanyType_RefID; var companyType = ORM_CMN_COM_CompanyInfo_Type.Query.Search(Connection, Transaction, companyTypeQuery).First(); returnValue.Result.OtherOphthal_PracticeData.CompanyType_Name = companyType.CompanyType_Name; returnValue.Result.OtherOphthal_PracticeData.CMN_COM_CompanyInfo_TypeID = companyType.CMN_COM_CompanyInfo_TypeID; var pHealthcareQuery = new ORM_HEC_PublicHealthcare_PhysitianAssociation.Query(); pHealthcareQuery.HEC_PublicHealthcare_PhysitianAssociationID = baseInfo.AssociatedWith_PhysitianAssociation_RefID; var pHealthcare = ORM_HEC_PublicHealthcare_PhysitianAssociation.Query.Search(Connection, Transaction, pHealthcareQuery).First(); returnValue.Result.OtherOphthal_PracticeData.HealthAssociation_Name = pHealthcare.HealthAssociation_Name; returnValue.Result.OtherOphthal_PracticeData.HEC_PublicHealthcare_PhysitianAssociationID = baseInfo.AssociatedWith_PhysitianAssociation_RefID; var customerQuery = new ORM_CMN_BPT_CTM_Customer.Query(); customerQuery.Ext_BusinessParticipant_RefID = baseInfo.CMN_BPT_BusinessParticipantID; var customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, customerQuery).FirstOrDefault(); 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).FirstOrDefault(); if (affinityStatus != null) { returnValue.Result.OtherOphthal_PracticeData.CMN_BPT_CTM_AffinityStatusID = affinityStatus.CMN_BPT_CTM_AffinityStatusID; returnValue.Result.OtherOphthal_PracticeData.AffinityStatus_Name = affinityStatus.AffinityStatus_Name; } } returnValue.Result.ShippingAddress = new L3MP_GPfID_1222_ShippingAddress(); var compAddressQuery = new ORM_CMN_COM_CompanyInfo_Address.Query(); compAddressQuery.Tenant_RefID = securityTicket.TenantID; compAddressQuery.CompanyInfo_RefID = baseInfo.CMN_COM_CompanyInfoID; compAddressQuery.IsShipping = true; compAddressQuery.IsDeleted = false; var compAddress = ORM_CMN_COM_CompanyInfo_Address.Query.Search(Connection, Transaction, compAddressQuery).First(); var addressQuery = new ORM_CMN_UniversalContactDetail.Query(); addressQuery.Tenant_RefID = securityTicket.TenantID; addressQuery.IsDeleted = false; addressQuery.CMN_UniversalContactDetailID = compAddress.Address_UCD_RefID; var address = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, addressQuery).First(); returnValue.Result.ShippingAddress.CMN_UniversalContactDetailID = address.CMN_UniversalContactDetailID; returnValue.Result.ShippingAddress.CMN_COM_CompanyInfo_AddressID = compAddress.CMN_COM_CompanyInfo_AddressID; returnValue.Result.ShippingAddress.Region_Name = address.Region_Name; returnValue.Result.ShippingAddress.Street_Name = address.Street_Name; returnValue.Result.ShippingAddress.Street_Number = address.Street_Number; returnValue.Result.ShippingAddress.Town = address.Town; returnValue.Result.ShippingAddress.ZIP = address.ZIP; } return(returnValue); #endregion UserCode }