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
}
