protected static FR_L3TX_GTOFTO_1006 Execute(DbConnection Connection, DbTransaction Transaction, P_L3TX_GTOFTO_1006 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3TX_GTOFTO_1006();
returnValue.Result = new L3TX_GTOFTO_1006();
var item = new ORM_ACC_TAX_TaxOffice();
returnValue.Result.TaxOffice = new L3TX_GTOFT_0914();
var result = item.Load(Connection, Transaction, Parameter.ACC_TAX_TaxOfficeID);
ORM_CMN_BPT_BusinessParticipant bparticipant = new ORM_CMN_BPT_BusinessParticipant();
bparticipant.Load(Connection, Transaction, item.CMN_BPT_BusinessParticipant_RefID);
returnValue.Result.TaxOffice.DisplayName = bparticipant.DisplayName;
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
returnValue.Result.TaxOffice.VATIdentificationNumber = companyInfo.VATIdentificationNumber;
returnValue.Result.TaxOffice.ACC_TAX_TaxOfficeID = item.ACC_TAX_TaxOfficeID;
returnValue.Result.TaxOffice.Country_639_1_ISOCode = ucd.Country_639_1_ISOCode;
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5HI_GHIFHIID_1329 Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_GHIFHIID_1329 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5HI_GHIFHIID_1329();
//Put your code here
returnValue.Result = new L5HI_GHIFHIID_1329();
ORM_HEC_HIS_HealthInsurance_Company.Query healthInsurenceQuery = new ORM_HEC_HIS_HealthInsurance_Company.Query();
healthInsurenceQuery.HEC_HealthInsurance_CompanyID = Parameter.HEC_HealthInsurance_CompanyID;
healthInsurenceQuery.Tenant_RefID = securityTicket.TenantID;
healthInsurenceQuery.IsDeleted = false;
List <ORM_HEC_HIS_HealthInsurance_Company> healthInsurances = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, healthInsurenceQuery);
if (healthInsurances.Count == 0)
{
return(null);
}
else
{
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = healthInsurances[0].CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
L5HI_GHIFT_1138 healthInsurance = new L5HI_GHIFT_1138();
healthInsurance.HEC_HealthInsurance_CompanyID = healthInsurances[0].HEC_HealthInsurance_CompanyID;
healthInsurance.DisplayName = bpart.DisplayName;
healthInsurance.HealthInsurance_IKNumber = healthInsurances[0].HealthInsurance_IKNumber;
healthInsurance.Country_ISO = ucd.Country_639_1_ISOCode;
healthInsurance.Town = ucd.Town;
returnValue.Result.HealthInsurance = healthInsurance;
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5HI_GHIFT_1138_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5HI_GHIFT_1138_Array();
List <L5HI_GHIFT_1138> healthInsuranceResult = new List <L5HI_GHIFT_1138>();
ORM_HEC_HIS_HealthInsurance_Company.Query healthInsurenceQuery = new ORM_HEC_HIS_HealthInsurance_Company.Query();
healthInsurenceQuery.Tenant_RefID = securityTicket.TenantID;
healthInsurenceQuery.IsDeleted = false;
List <ORM_HEC_HIS_HealthInsurance_Company> healthInsurances = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, healthInsurenceQuery);
foreach (var healthInsurance in healthInsurances)
{
if (healthInsurance.CMN_BPT_BusinessParticipant_RefID == Guid.Empty)
{
continue;
}
L5HI_GHIFT_1138 item = new L5HI_GHIFT_1138();
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = healthInsurance.CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
item.HEC_HealthInsurance_CompanyID = healthInsurance.HEC_HealthInsurance_CompanyID;
item.DisplayName = bpart.DisplayName;
item.HealthInsurance_IKNumber = healthInsurance.HealthInsurance_IKNumber;
item.Country_ISO = ucd.Country_639_1_ISOCode;
item.Town = ucd.Town;
healthInsuranceResult.Add(item);
}
returnValue.Result = healthInsuranceResult.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L3TX_DTO_1148 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Base();
ORM_ACC_TAX_TaxOffice taxOffice = new ORM_ACC_TAX_TaxOffice();
if (Parameter.ACC_TAX_TaxOfficeID != Guid.Empty)
{
var result = taxOffice.Load(Connection, Transaction, Parameter.ACC_TAX_TaxOfficeID);
if (result.Status != FR_Status.Success || taxOffice.ACC_TAX_TaxOfficeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID.";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
taxOffice.IsDeleted = true;
taxOffice.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant.Query bptQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
bptQuery.CMN_BPT_BusinessParticipantID = taxOffice.CMN_BPT_BusinessParticipant_RefID;
bptQuery.IsDeleted = false;
bptQuery.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bparticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bptQuery).FirstOrDefault();
bparticipant.IsDeleted = true;
bparticipant.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo.Query cmpInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
cmpInfoQuery.CMN_COM_CompanyInfoID = bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
cmpInfoQuery.IsDeleted = false;
cmpInfoQuery.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_COM_CompanyInfo companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, cmpInfoQuery).FirstOrDefault();
companyInfo.IsDeleted = true;
companyInfo.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_L3TE_CTITS_1108 Execute(DbConnection Connection, DbTransaction Transaction, P_L3TE_CTITS_1108 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3TE_CTITS_1108();
returnValue.Result = new L3TE_CTITS_1108();
returnValue.Status = FR_Status.Error_Internal;
#region Load or Create Tenant
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.TenantITL,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
};
var customerTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (customerTenant == default(ORM_CMN_Tenant))
{
customerTenant = new ORM_CMN_Tenant();
customerTenant.CMN_TenantID = Guid.NewGuid();
customerTenant.TenantITL = Parameter.TenantITL;
customerTenant.Tenant_RefID = securityTicket.TenantID;
customerTenant.Creation_Timestamp = DateTime.Now;
customerTenant.UniversalContactDetail_RefID = Guid.NewGuid();
if (customerTenant.Save(Connection, Transaction).Status != FR_Status.Success)
{
return(returnValue);
}
}
#endregion
#region Load or Create BusinessParticipant
var businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
IsTenant = true,
IfTenant_Tenant_RefID = customerTenant.CMN_TenantID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (businessParticipant == default(ORM_CMN_BPT_BusinessParticipant))
{
businessParticipant = new ORM_CMN_BPT_BusinessParticipant();
businessParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
businessParticipant.BusinessParticipantITL = Parameter.BusinessParticipantITL;
businessParticipant.DisplayName = Parameter.CompanyName;
businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = Guid.NewGuid();
businessParticipant.IfTenant_Tenant_RefID = customerTenant.CMN_TenantID;
businessParticipant.IsCompany = true;
businessParticipant.IsTenant = true;
businessParticipant.Tenant_RefID = securityTicket.TenantID;
businessParticipant.Creation_Timestamp = DateTime.Now;
if (businessParticipant.Save(Connection, Transaction).Status != FR_Status.Success)
{
return(returnValue);
}
}
#endregion
#region Load or Create CompanyInfo
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, new ORM_CMN_COM_CompanyInfo.Query()
{
CMN_COM_CompanyInfoID = businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (companyInfo == default(ORM_CMN_COM_CompanyInfo))
{
companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = businessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfo.Contact_UCD_RefID = Guid.NewGuid();
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Creation_Timestamp = DateTime.Now;
if (companyInfo.Save(Connection, Transaction).Status != FR_Status.Success)
{
return(returnValue);
}
}
#endregion
#region Load or Create UniversalContactDetails for Tenant and CompanyInfo
var ucdTenant = ORM_CMN_UniversalContactDetail.Query.Search(
Connection,
Transaction,
new ORM_CMN_UniversalContactDetail.Query()
{
CMN_UniversalContactDetailID = customerTenant.UniversalContactDetail_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (ucdTenant == default(ORM_CMN_UniversalContactDetail))
{
ucdTenant = new ORM_CMN_UniversalContactDetail();
ucdTenant.CMN_UniversalContactDetailID = customerTenant.UniversalContactDetail_RefID;
ucdTenant.UniversalContactDetailsITL = Parameter.TenantUniversalContactDetailITL;
ucdTenant.IsCompany = true;
ucdTenant.CompanyName_Line1 = Parameter.CompanyName;
ucdTenant.Contact_Email = Parameter.ContactEmail;
ucdTenant.Tenant_RefID = securityTicket.TenantID;
ucdTenant.Creation_Timestamp = DateTime.Now;
if (ucdTenant.Save(Connection, Transaction).Status != FR_Status.Success)
{
return(returnValue);
}
}
var ucdCompanyInfo = ORM_CMN_UniversalContactDetail.Query.Search(
Connection,
Transaction,
new ORM_CMN_UniversalContactDetail.Query()
{
CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (ucdCompanyInfo == default(ORM_CMN_UniversalContactDetail))
{
ucdCompanyInfo = new ORM_CMN_UniversalContactDetail();
ucdCompanyInfo.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
ucdCompanyInfo.UniversalContactDetailsITL = Parameter.CompanyInfoUniversalContactDetailITL;
ucdCompanyInfo.IsCompany = true;
ucdCompanyInfo.CompanyName_Line1 = Parameter.CompanyName;
ucdCompanyInfo.Contact_Email = Parameter.ContactEmail;
ucdCompanyInfo.Tenant_RefID = securityTicket.TenantID;
ucdCompanyInfo.Creation_Timestamp = DateTime.Now;
if (ucdCompanyInfo.Save(Connection, Transaction).Status != FR_Status.Success)
{
return(returnValue);
}
}
#endregion
returnValue.Result.TenantID = customerTenant.CMN_TenantID;
returnValue.Result.BusinessParticipantID = businessParticipant.CMN_BPT_BusinessParticipantID;
returnValue.Result.TenantUniversalContactDetailID = ucdTenant.CMN_UniversalContactDetailID;
returnValue.Result.CompanyInfoUniversalContactDetailID = ucdCompanyInfo.CMN_UniversalContactDetailID;
returnValue.Result.CompanyInfoID = companyInfo.CMN_COM_CompanyInfoID;
returnValue.Status = FR_Status.Success;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_SHI_1158 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
FR_Base result = new FR_Base();
//Put your code here
var item = new ORM_HEC_HIS_HealthInsurance_Company();
if (Parameter.HEC_HealthInsurance_CompanyID != Guid.Empty)
{
result = item.Load(Connection, Transaction, Parameter.HEC_HealthInsurance_CompanyID);
if (result.Status != FR_Status.Success || item.HEC_HealthInsurance_CompanyID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
item.HealthInsurance_IKNumber = Parameter.HealthInsurance_IKNumber;
item.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bpart = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
CMN_BPT_BusinessParticipantID = item.CMN_BPT_BusinessParticipant_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
if (bpart == null || bpart.CMN_BPT_BusinessParticipantID == Guid.Empty)
{
bpart = new ORM_CMN_BPT_BusinessParticipant();
}
bpart.DisplayName = Parameter.CompanyName;
bpart.Tenant_RefID = securityTicket.TenantID;
item.CMN_BPT_BusinessParticipant_RefID = bpart.CMN_BPT_BusinessParticipantID;
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
result = companyInfo.Load(Connection, Transaction, bpart.IfCompany_CMN_COM_CompanyInfo_RefID);
if (result.Status != FR_Status.Success || companyInfo.CMN_COM_CompanyInfoID == Guid.Empty)
{
companyInfo = new ORM_CMN_COM_CompanyInfo();
}
bpart.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
bpart.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
result = ucd.Load(Connection, Transaction, companyInfo.Contact_UCD_RefID);
if (result.Status != FR_Status.Success || ucd.CMN_UniversalContactDetailID == Guid.Empty)
{
ucd = new ORM_CMN_UniversalContactDetail();
}
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Contact_UCD_RefID = ucd.CMN_UniversalContactDetailID;
companyInfo.Save(Connection, Transaction);
returnValue.Result = item.HEC_HealthInsurance_CompanyID;
if (Parameter.Country_ISO != "")
{
ucd.Country_639_1_ISOCode = Parameter.Country_ISO;
ucd.Town = Parameter.Town;
ucd.Tenant_RefID = securityTicket.TenantID;
}
ucd.Save(Connection, Transaction);
item.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ACACU_SCC_1051 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.InternalCustomerNumber = Parameter.Number;
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.IsCompany = true;
customer.Ext_BusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
}
bParticipant.DisplayName = Parameter.FirmName;
ORM_CMN_COM_CompanyInfo company;
if (bParticipant.IfCompany_CMN_COM_CompanyInfo_RefID != Guid.Empty)
{
var companyQ = new ORM_CMN_COM_CompanyInfo.Query();
companyQ.Tenant_RefID = securityTicket.TenantID;
companyQ.IsDeleted = false;
companyQ.CMN_COM_CompanyInfoID = bParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
company = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companyQ).First();
}
else
{
company = new ORM_CMN_COM_CompanyInfo();
company.Tenant_RefID = securityTicket.TenantID;
company.CMN_COM_CompanyInfoID = Guid.NewGuid();
bParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = company.CMN_COM_CompanyInfoID;
}
ORM_CMN_UniversalContactDetail ucd;
if (company.Contact_UCD_RefID != Guid.Empty)
{
var ucdQ = new ORM_CMN_UniversalContactDetail.Query();
ucdQ.Tenant_RefID = securityTicket.TenantID;
ucdQ.IsDeleted = false;
ucdQ.CMN_UniversalContactDetailID = company.Contact_UCD_RefID;
ucd = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, ucdQ).First();
}
else
{
ucd = new ORM_CMN_UniversalContactDetail();
ucd.Tenant_RefID = securityTicket.TenantID;
ucd.CMN_UniversalContactDetailID = Guid.NewGuid();
ucd.IsCompany = true;
company.Contact_UCD_RefID = ucd.CMN_UniversalContactDetailID;
}
ucd.CompanyName_Line1 = Parameter.FirmName;
ucd.CompanyName_Line2 = Parameter.Additional;
ucd.IsDeleted = Parameter.IsDelete;
company.IsDeleted = Parameter.IsDelete;
bParticipant.IsDeleted = Parameter.IsDelete;
customer.IsDeleted = Parameter.IsDelete;
ucd.Save(Connection, Transaction);
company.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_L3CCfTaIC_1526_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3CCfTaIC_1526 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3CCfTaIC_1526_Array();
//Put your code here
List <L3CCfTaIC_1526> ProductList = new List <L3CCfTaIC_1526>();
returnValue.Result = ProductList.ToArray();
var _service = CatalogServiceFactory.GetSubscriptionService();
//make data to send to Architecture so that they will know which catalog to update
var subscriptionRequest = new SubscriptionRequest();
subscriptionRequest.CatalogCode = Parameter.CatalogCodeITL;
Customer customer = new Customer();
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
customer.BusinessParticipantITL = Parameter.SubscribedBy_BusinessParticipant_RefID.ToString();
}
else
{
customer.BusinessParticipantITL = securityTicket.TenantID.ToString();
}
customer.TenantITL = securityTicket.TenantID.ToString();
customer.Name = Parameter.ClientName;
// customer.SourceRealm = BOp.Infrastructure.PropertyRepository.Instance.RealmID.ToString();
subscriptionRequest.Customer = customer;
/*
* @see if catalog with the same ITL for that bussinessParticipant exists
* */
var subscribedCatalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
subscribedCatalogQuery.Tenant_RefID = securityTicket.TenantID;
subscribedCatalogQuery.CatalogCodeITL = Parameter.CatalogCodeITL;
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
subscribedCatalogQuery.SubscribedBy_BusinessParticipant_RefID = Parameter.SubscribedBy_BusinessParticipant_RefID;
}
subscribedCatalogQuery.IsDeleted = false;
var subscribedCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, subscribedCatalogQuery).FirstOrDefault();
#region Get VAT
var defaultCountryISOCode = cls_Get_DefaultCountryISOCode_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
var param = new P_L3TX_GTfCICaT_1359();
param.CountryISOCode = "DE";
var taxes = cls_Get_Taxes_for_CountryISOCode_and_TenantID.Invoke(Connection, Transaction, param, securityTicket).Result;
//if there are no taxes for tenant
Guid countryID = Guid.Empty;
if (taxes.Length == 0)
{
var country = cls_Get_AllCountries_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result.FirstOrDefault();
if (country != null)
{
countryID = country.CMN_CountryID;
}
}
else
{
countryID = taxes.First().CMN_CountryID; // ti slucajni posmatracu ovog koda nemoj zameriti na ovakvom resenju.
}
#endregion
#region save
if (subscribedCatalog == null)
{
/*
* @save ORM_CMN_PRO_SubscribedCatalog
* */
subscribedCatalog = new ORM_CMN_PRO_SubscribedCatalog();
subscribedCatalog.CMN_PRO_SubscribedCatalogID = Guid.NewGuid();
subscribedCatalog.CatalogCodeITL = Parameter.CatalogCodeITL;
subscribedCatalog.SubscribedCatalog_Name = Parameter.CatalogName;
subscribedCatalog.SubscribedBy_BusinessParticipant_RefID = Parameter.SubscribedBy_BusinessParticipant_RefID;
subscribedCatalog.Tenant_RefID = securityTicket.TenantID;
subscribedCatalog.SubscribedCatalog_ValidFrom = Parameter.ValidFrom_Date;
subscribedCatalog.SubscribedCatalog_ValidThrough = Parameter.ValidTo_Date;
subscribedCatalog.SubscribedCatalog_Description = Parameter.CatalogDescription;
subscribedCatalog.Creation_Timestamp = DateTime.Now;
subscribedCatalog.IsDeleted = false;
subscribedCatalog.SubscribedCatalog_CurrentRevision = Parameter.CatalogVersion;
subscribedCatalog.IsCatalogPublic = Parameter.IsCatalogPublic;
// check if language with that ISO exists for Tenant (Lower, exmpl de)
var languageQuery = new ORM_CMN_Language.Query();
languageQuery.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes.ToLower();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
var language = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery).FirstOrDefault();
// if language does not exist for that Tenant
if (language == null)
{
//check if language with that ISO exists for Tenant (Upper exmpl DE)
languageQuery = new ORM_CMN_Language.Query();
languageQuery.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes.ToUpper();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
language = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery).FirstOrDefault();
// if language does not exist for that Tenant
if (language == null)
{
ORM_CMN_Language newLanguage = new ORM_CMN_Language();
newLanguage.CMN_LanguageID = Guid.NewGuid();
newLanguage.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes;
newLanguage.Creation_Timestamp = DateTime.Now;
newLanguage.Tenant_RefID = securityTicket.TenantID;
newLanguage.IsDeleted = false;
newLanguage.Save(Connection, Transaction);
subscribedCatalog.SubscribedCatalog_Language_RefID = newLanguage.CMN_LanguageID;
}
else
{
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
}
}
else
{
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
}
// check if currency with that ISO exists for Tenant
var currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
var currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
ORM_CMN_Currency newCurrency = new ORM_CMN_Currency();
newCurrency.CMN_CurrencyID = Guid.NewGuid();
newCurrency.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
newCurrency.Tenant_RefID = securityTicket.TenantID;
newCurrency.Creation_Timestamp = DateTime.Now;
newCurrency.Save(Connection, Transaction);
subscribedCatalog.SubscribedCatalog_Currency_RefID = newCurrency.CMN_CurrencyID;
}
else
{
subscribedCatalog.SubscribedCatalog_Currency_RefID = currency.CMN_CurrencyID;
}
#region product group
/*
* @Search product group
* */
ORM_CMN_PRO_ProductGroup productGroup = new ORM_CMN_PRO_ProductGroup();
var productGroupQuery = new ORM_CMN_PRO_ProductGroup.Query();
productGroupQuery.Tenant_RefID = securityTicket.TenantID;
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
//if (Parameter.IsCatalogPublic == false)
//{
// productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
//}
//else
//{
// productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.ABDA);
//}
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
productGroupQuery.GlobalPropertyMatchingID += Parameter.SubscribedBy_BusinessParticipant_RefID;
}
productGroupQuery.IsDeleted = false;
productGroup = ORM_CMN_PRO_ProductGroup.Query.Search(Connection, Transaction, productGroupQuery).FirstOrDefault();
if (productGroup == null)
{
/*
* @Create product group for products if product group for that BP and Tenent does not exist
* */
productGroup = new ORM_CMN_PRO_ProductGroup();
productGroup.Tenant_RefID = securityTicket.TenantID;
productGroup.Creation_Timestamp = DateTime.Now;
productGroup.CMN_PRO_ProductGroupID = Guid.NewGuid();
productGroup.ProductGroup_Name = new Dict(ORM_CMN_PRO_ProductGroup.TableName);
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "Treatment Group");
//if (Parameter.IsCatalogPublic == false)
//{
// productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
// productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "HauseList Group");
//}
//else
//{
// productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.ABDA);
// productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "ABDA Group");
//}
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
productGroup.GlobalPropertyMatchingID += Parameter.SubscribedBy_BusinessParticipant_RefID;
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "Treatment Group");
}
productGroup.Save(Connection, Transaction);
}
#endregion
#region create priceList for Catalog
/*
* @create pricelist_Release
* */
ORM_CMN_SLS_Pricelist_Release pricelist_Release = new ORM_CMN_SLS_Pricelist_Release();
pricelist_Release.CMN_SLS_Pricelist_ReleaseID = Guid.NewGuid();
pricelist_Release.Release_Version = "v1";
if (Parameter.IsCatalogPublic == false)
{
pricelist_Release.PricelistRelease_ValidFrom = Parameter.ValidFrom_Date;
pricelist_Release.PricelistRelease_ValidTo = Parameter.ValidTo_Date;
}
else
{
pricelist_Release.IsPricelistAlwaysActive = true;
}
pricelist_Release.Tenant_RefID = securityTicket.TenantID;
pricelist_Release.Creation_Timestamp = DateTime.Now;
pricelist_Release.Pricelist_RefID = Guid.NewGuid();//priceList.CMN_SLS_PricelistID
pricelist_Release.Save(Connection, Transaction);
/*
* @create pricelist
* */
ORM_CMN_SLS_Pricelist priceList = new ORM_CMN_SLS_Pricelist();
priceList.CMN_SLS_PricelistID = pricelist_Release.Pricelist_RefID;
var DBLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result.ToList();
Dict nameDict = new Dict("cmn_sls_pricelist");
if (Parameter.IsCatalogPublic == false)
{
for (int i = 0; i < DBLanguages.Count; i++)
{
nameDict.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.CatalogName + "_" + Parameter.ValidFrom_Date.ToShortDateString() + "_" + Parameter.ValidTo_Date.ToShortDateString());
}
}
else
{
for (int i = 0; i < DBLanguages.Count; i++)
{
nameDict.AddEntry(DBLanguages[i].CMN_LanguageID, "ABDA_PriceList");
}
}
priceList.Pricelist_Name = nameDict;
priceList.Tenant_RefID = securityTicket.TenantID;
priceList.Creation_Timestamp = DateTime.Now;
priceList.Save(Connection, Transaction);
#endregion
if (Parameter.IsCatalogPublic == false)
{
#region create and save products in product group and give product its price , product amout and measure unit
/*
* @create and save products in product group
* */
bool isAlreadyInABDA = false;
foreach (var item in Parameter.Products)
{
ORM_CMN_PRO_Product product = new ORM_CMN_PRO_Product();
// only for Tenant specific cases add Business Participant ID (!Lucentis)
if (Parameter.SubscribedBy_BusinessParticipant_RefID == Guid.Empty)
{
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.ProductITL = item.ProductITL;
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.IsProductAvailableForOrdering = true;
product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).FirstOrDefault();
//if it is not in ABDA
if (product == null)
{
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.ProductITL = item.ProductITL;
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = item.IsProduct_Article;
product.IsProductAvailableForOrdering = true;
product.PackageInfo_RefID = Guid.NewGuid();//packageInfo.CMN_PRO_PAC_PackageInfoID
isAlreadyInABDA = false;
}
else
{
isAlreadyInABDA = true;
}
}
else
{
product.CMN_PRO_ProductID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.ProductITL = item.ProductITL;
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = item.IsProduct_Article;
product.IsProductAvailableForOrdering = true;
product.PackageInfo_RefID = Guid.NewGuid();//packageInfo.CMN_PRO_PAC_PackageInfoID
isAlreadyInABDA = false;
}
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = subscribedCatalog.CMN_PRO_SubscribedCatalogID;
product.Save(Connection, Transaction);
L3CCfTaIC_1526 pro = new L3CCfTaIC_1526();
pro.ProductID = product.CMN_PRO_ProductID;
if (product.IsProduct_Article)
{
pro.Dosage = item.Dosage;
}
pro.isEdit = false;
ProductList.Add(pro);
ORM_CMN_PRO_Product_2_ProductGroup product_2_productGroup = new ORM_CMN_PRO_Product_2_ProductGroup();
product_2_productGroup.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
product_2_productGroup.CMN_PRO_ProductGroup_RefID = productGroup.CMN_PRO_ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
if (isAlreadyInABDA == false)
{
ORM_CMN_SLS_Price price = new ORM_CMN_SLS_Price();
price.CMN_SLS_PriceID = Guid.NewGuid();
price.Tenant_RefID = securityTicket.TenantID;
price.Creation_Timestamp = DateTime.Now;
price.PricelistRelease_RefID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
price.PriceAmount = item.Price;
price.CMN_Currency_RefID = subscribedCatalog.SubscribedCatalog_Currency_RefID;
price.Save(Connection, Transaction);
//add amount and Measure
ORM_CMN_PRO_PAC_PackageInfo packageInfo = new ORM_CMN_PRO_PAC_PackageInfo();
packageInfo.CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID;
packageInfo.Tenant_RefID = securityTicket.TenantID;
packageInfo.Creation_Timestamp = DateTime.Now;
packageInfo.PackageContent_Amount = item.Amount;
//check if MeasureUnit exists for this Tenant
var unitsQuery = new ORM_CMN_Unit.Query();
unitsQuery.Tenant_RefID = securityTicket.TenantID;
unitsQuery.ISOCode = item.MeasuredInUnit_ISO_um_ums;
unitsQuery.IsDeleted = false;
var measuredInUnit = ORM_CMN_Unit.Query.Search(Connection, Transaction, unitsQuery).FirstOrDefault();
if (measuredInUnit == null)
{
ORM_CMN_Unit newMeasuredInUnit = new ORM_CMN_Unit();
newMeasuredInUnit.Tenant_RefID = securityTicket.TenantID;
newMeasuredInUnit.Creation_Timestamp = DateTime.Now;
newMeasuredInUnit.ISOCode = item.MeasuredInUnit_ISO_um_ums;
newMeasuredInUnit.CMN_UnitID = Guid.NewGuid();
newMeasuredInUnit.Save(Connection, Transaction);
packageInfo.PackageContent_MeasuredInUnit_RefID = newMeasuredInUnit.CMN_UnitID;
}
else
{
packageInfo.PackageContent_MeasuredInUnit_RefID = measuredInUnit.CMN_UnitID;
}
packageInfo.Save(Connection, Transaction);
if (countryID != Guid.Empty)// if there is a country for this Tenant
{
#region Create Taxes
double productVAT = 0;
Double.TryParse(item.VAT, out productVAT);
var tax = taxes.Where(i => i.TaxRate == productVAT).SingleOrDefault();
if (tax == default(L3TX_GTfCICaT_1359))
{
#region CreateTax
var saveTaxParam = new P_L3TX_STX_1119();
saveTaxParam.ACC_TAX_TaxeID = Guid.Empty;
saveTaxParam.TaxName = new Dict(ORM_ACC_TAX_Tax.TableName);
saveTaxParam.TaxName.AddEntry(language.CMN_LanguageID, productVAT.ToString());
saveTaxParam.TaxRate = productVAT;
if (taxes.Length != 0)
{
saveTaxParam.EconomicRegion_RefID = taxes.First().CMN_EconomicRegionID;
saveTaxParam.Country_RefID = taxes.First().CMN_CountryID;
}
else
{
saveTaxParam.EconomicRegion_RefID = Guid.Empty;
saveTaxParam.Country_RefID = countryID;
}
var saveTaxResult = cls_Save_Tax.Invoke(Connection, Transaction, saveTaxParam, securityTicket).Result;
#endregion
#region Update Available taxes
param = new P_L3TX_GTfCICaT_1359();
param.CountryISOCode = "DE";
taxes = cls_Get_Taxes_for_CountryISOCode_and_TenantID.Invoke(Connection, Transaction, param, securityTicket).Result;
tax = taxes.Where(i => i.TaxRate == productVAT).SingleOrDefault();
#endregion
}
var salesTax = new ORM_CMN_PRO_Product_SalesTaxAssignmnet();
salesTax.CMN_PRO_Product_SalesTaxAssignmnetID = Guid.NewGuid();
salesTax.Product_RefID = product.CMN_PRO_ProductID;
salesTax.ApplicableSalesTax_RefID = tax.ACC_TAX_TaxeID;
salesTax.Creation_Timestamp = DateTime.Now;
salesTax.Tenant_RefID = securityTicket.TenantID;
salesTax.Save(Connection, Transaction);
#endregion
}
}
}
#endregion
}
/*
* @See if Supplier already exists in database
* */
ORM_CMN_BPT_Supplier supplier = new ORM_CMN_BPT_Supplier();
var supplierQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
supplierQuery.BusinessParticipantITL = Parameter.SupplierData.SupplierITL;
supplierQuery.Tenant_RefID = securityTicket.TenantID;
supplierQuery.IsDeleted = false;
var supplier_bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, supplierQuery).FirstOrDefault();
#region if supplier does not exist
if (supplier_bussinessParticipant == null)
{
/*
* @Make Supplier Data
* */
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.SupplierData.TenantITL,
Tenant_RefID = securityTicket.TenantID
};
var supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.SupplierData.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
}
supplier.CMN_BPT_SupplierID = Guid.NewGuid();
supplier.Ext_BusinessParticipant_RefID = Guid.NewGuid();//supplierBussinessParticipant.CMN_BPT_BusinessParticipantID
supplier.Creation_Timestamp = DateTime.Now;
supplier.IsDeleted = false;
supplier.Tenant_RefID = securityTicket.TenantID;
supplier.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant supplierBussinessParticipant = new ORM_CMN_BPT_BusinessParticipant();
supplierBussinessParticipant.CMN_BPT_BusinessParticipantID = supplier.Ext_BusinessParticipant_RefID;
supplierBussinessParticipant.DisplayName = Parameter.SupplierData.Supplier_Name;
supplierBussinessParticipant.BusinessParticipantITL = Parameter.SupplierData.SupplierITL;
supplierBussinessParticipant.Creation_Timestamp = DateTime.Now;
supplierBussinessParticipant.Tenant_RefID = securityTicket.TenantID;
supplierBussinessParticipant.IsCompany = true;
supplierBussinessParticipant.IsTenant = true;
supplierBussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = Guid.NewGuid();//companyInfo.CMN_COM_CompanyInfoID
supplierBussinessParticipant.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfo.Creation_Timestamp = DateTime.Now;
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Contact_UCD_RefID = Guid.NewGuid();//universalContactDetail.CMN_UniversalContactDetailID
companyInfo.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail universalContactDetail = new ORM_CMN_UniversalContactDetail();
universalContactDetail.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetail.IsCompany = true;
universalContactDetail.Country_639_1_ISOCode = Parameter.SupplierData.CountryISO;
universalContactDetail.Street_Name = Parameter.SupplierData.Supplier_Name;
universalContactDetail.Street_Number = Parameter.SupplierData.Street_Number;
universalContactDetail.ZIP = Parameter.SupplierData.ZIP;
universalContactDetail.Town = Parameter.SupplierData.Town;
universalContactDetail.Region_Code = Parameter.SupplierData.Region_Code;
universalContactDetail.Tenant_RefID = securityTicket.TenantID;
universalContactDetail.Creation_Timestamp = DateTime.Now;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
#region if supplier exists , check if its data is changed
else
{
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.SupplierData.TenantITL,
Tenant_RefID = securityTicket.TenantID
};
var supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.SupplierData.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
supplier_bussinessParticipant.IsTenant = true;
supplier_bussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
}
supplier_bussinessParticipant.DisplayName = Parameter.SupplierData.Supplier_Name;
supplier_bussinessParticipant.Save(Connection, Transaction);
var query = new ORM_CMN_BPT_Supplier.Query();
query.Ext_BusinessParticipant_RefID = supplier_bussinessParticipant.CMN_BPT_BusinessParticipantID;
query.Tenant_RefID = securityTicket.TenantID;
query.IsDeleted = false;
supplier = ORM_CMN_BPT_Supplier.Query.Search(Connection, Transaction, query).First();
//edit universal contact details
var companyInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
companyInfoQuery.CMN_COM_CompanyInfoID = supplier_bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfoQuery.Tenant_RefID = securityTicket.TenantID;
companyInfoQuery.IsDeleted = false;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companyInfoQuery).First();
var universalContactDetailQuery = new ORM_CMN_UniversalContactDetail.Query();
universalContactDetailQuery.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetailQuery.Tenant_RefID = securityTicket.TenantID;
universalContactDetailQuery.IsDeleted = false;
var universalContactDetail = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, universalContactDetailQuery).First();
universalContactDetail.Country_639_1_ISOCode = Parameter.SupplierData.CountryISO;
universalContactDetail.Street_Name = Parameter.SupplierData.Supplier_Name;
universalContactDetail.Street_Number = Parameter.SupplierData.Street_Number;
universalContactDetail.ZIP = Parameter.SupplierData.ZIP;
universalContactDetail.Town = Parameter.SupplierData.Town;
universalContactDetail.Region_Code = Parameter.SupplierData.Region_Code;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
subscribedCatalog.SubscribedCatalog_PricelistRelease_RefID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
subscribedCatalog.PublishingSupplier_RefID = supplier.CMN_BPT_SupplierID;
subscribedCatalog.Save(Connection, Transaction);
/*
* @send Kika information which catalog has been subscribed to who
* */
var result = _service.SubscribeToCatalog(subscriptionRequest);
if (result.ResponseStatus != ResponseStatus.OK)
{
throw new Exception("Catalog subscription failed!");
}
}
#endregion
returnValue.Result = ProductList.ToArray();
return(returnValue);
#endregion UserCode
}
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
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3TX_STXO_0929 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_ACC_TAX_TaxOffice();
if (Parameter.ACC_TAX_TaxOfficeID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.ACC_TAX_TaxOfficeID);
if (result.Status != FR_Status.Success || item.ACC_TAX_TaxOfficeID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
ORM_CMN_BPT_BusinessParticipant.Query bptQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
bptQuery.CMN_BPT_BusinessParticipantID = item.CMN_BPT_BusinessParticipant_RefID;
bptQuery.Tenant_RefID = securityTicket.TenantID;
bptQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant bparticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bptQuery).FirstOrDefault();
bparticipant.DisplayName = Parameter.DisplayName;
bparticipant.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo.Query cmpInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
cmpInfoQuery.CMN_COM_CompanyInfoID = bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
cmpInfoQuery.IsDeleted = false;
cmpInfoQuery.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_COM_CompanyInfo companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, cmpInfoQuery).FirstOrDefault();
companyInfo.VATIdentificationNumber = Parameter.VATIdentificationNumber;
companyInfo.Save(Connection, Transaction);
returnValue.Result = item.ACC_TAX_TaxOfficeID;
if (companyInfo.Contact_UCD_RefID != Guid.Empty)
{
var countries = cls_Get_AllCountries.Invoke(Connection, Transaction, securityTicket).Result;
ORM_CMN_UniversalContactDetail.Query ucdQuery = new ORM_CMN_UniversalContactDetail.Query();
ucdQuery.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
ucdQuery.Tenant_RefID = securityTicket.TenantID;
ucdQuery.IsDeleted = false;
ORM_CMN_UniversalContactDetail ucd = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, ucdQuery).FirstOrDefault();
ucd.Country_639_1_ISOCode = Parameter.Country_ISO;
ucd.Save(Connection, Transaction);
}
}
else
{
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.VATIdentificationNumber = Parameter.VATIdentificationNumber;
companyInfo.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant bparticipant = new ORM_CMN_BPT_BusinessParticipant();
bparticipant.DisplayName = Parameter.DisplayName;
bparticipant.IsCompany = true;
bparticipant.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
bparticipant.Tenant_RefID = securityTicket.TenantID;
bparticipant.Save(Connection, Transaction);
ORM_ACC_TAX_TaxOffice taxOffice = new ORM_ACC_TAX_TaxOffice();
taxOffice.CMN_BPT_BusinessParticipant_RefID = bparticipant.CMN_BPT_BusinessParticipantID;
taxOffice.Tenant_RefID = securityTicket.TenantID;
taxOffice.Save(Connection, Transaction);
returnValue.Result = taxOffice.ACC_TAX_TaxOfficeID;
if (Parameter.Country_ISO != "")
{
var countries = cls_Get_AllCountries.Invoke(Connection, Transaction, securityTicket).Result;
ORM_CMN_UniversalContactDetail ucd = new ORM_CMN_UniversalContactDetail();
ucd.Country_639_1_ISOCode = Parameter.Country_ISO;
ucd.Tenant_RefID = securityTicket.TenantID;
ucd.Save(Connection, Transaction);
companyInfo.Contact_UCD_RefID = ucd.CMN_UniversalContactDetailID;
}
companyInfo.Save(Connection, Transaction);
}
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PH_SP_1226 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_Pharmacy item = new ORM_HEC_Pharmacy();
if (Parameter.PharmacyID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.PharmacyID);
if (result.Status != FR_Status.Success)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
#region Delete
if (Parameter.IsDeleted)
{
//Contact person data finding and deleting
var query_BusinessParticipant_ContactPerson_del = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BusinessParticipant_ContactPerson_del.CMN_BPT_BusinessParticipantID = item.ContactPerson_BusinessParticipant_RefID;
query_BusinessParticipant_ContactPerson_del.Tenant_RefID = item.Tenant_RefID;
ORM_CMN_BPT_BusinessParticipant found_BusinessParticipant_ContactPerson_del = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BusinessParticipant_ContactPerson_del).First();
found_BusinessParticipant_ContactPerson_del.IsDeleted = true;
var query_PersonInfo_del = new ORM_CMN_PER_PersonInfo.Query();
query_PersonInfo_del.CMN_PER_PersonInfoID = found_BusinessParticipant_ContactPerson_del.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
ORM_CMN_PER_PersonInfo found_PersonInfo_del = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query_PersonInfo_del).First();
found_PersonInfo_del.IsDeleted = true;
var query_CommunicationContact_del = new ORM_CMN_PER_CommunicationContact.Query();
query_CommunicationContact_del.PersonInfo_RefID = found_PersonInfo_del.CMN_PER_PersonInfoID;
ORM_CMN_PER_CommunicationContact found_CommunicationContact_del = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query_CommunicationContact_del).First();
found_CommunicationContact_del.IsDeleted = true;
found_BusinessParticipant_ContactPerson_del.Save(Connection, Transaction);
found_CommunicationContact_del.Save(Connection, Transaction);
found_PersonInfo_del.Save(Connection, Transaction);
//Company (pharmacy) finding and deleting
var query_CompanyInfo_del = new ORM_CMN_COM_CompanyInfo.Query();
query_CompanyInfo_del.CMN_COM_CompanyInfoID = item.Ext_CompanyInfo_RefID;
ORM_CMN_COM_CompanyInfo found_CompanyInfo_del = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, query_CompanyInfo_del).First();
found_CompanyInfo_del.IsDeleted = true;
var query_CompanyContactDetails_del = new ORM_CMN_UniversalContactDetail.Query();
query_CompanyContactDetails_del.CMN_UniversalContactDetailID = found_CompanyInfo_del.Contact_UCD_RefID;
ORM_CMN_UniversalContactDetail found_CompanyContactDetails_del = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, query_CompanyContactDetails_del).First();
found_CompanyContactDetails_del.IsDeleted = true;
var query_BusinessParticipant_Company_del = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BusinessParticipant_Company_del.IfCompany_CMN_COM_CompanyInfo_RefID = found_CompanyInfo_del.CMN_COM_CompanyInfoID;
ORM_CMN_BPT_BusinessParticipant found_BusinessParticipant_Company_del = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BusinessParticipant_Company_del).First();
found_BusinessParticipant_Company_del.IsDeleted = true;
found_CompanyInfo_del.Save(Connection, Transaction);
found_CompanyContactDetails_del.Save(Connection, Transaction);
found_BusinessParticipant_Company_del.Save(Connection, Transaction);
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.HEC_PharmacyID));
}
#endregion
#region Edit
//Contact person data finding and edit
var query_BusinessParticipant_ContactPerson = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BusinessParticipant_ContactPerson.CMN_BPT_BusinessParticipantID = item.ContactPerson_BusinessParticipant_RefID;
query_BusinessParticipant_ContactPerson.Tenant_RefID = item.Tenant_RefID;
ORM_CMN_BPT_BusinessParticipant found_BusinessParticipant_ContactPerson = new ORM_CMN_BPT_BusinessParticipant();
if (item.ContactPerson_BusinessParticipant_RefID != null && item.ContactPerson_BusinessParticipant_RefID != Guid.Empty)
{
found_BusinessParticipant_ContactPerson = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BusinessParticipant_ContactPerson).First();
}
else
{
found_BusinessParticipant_ContactPerson = null;
}
if (found_BusinessParticipant_ContactPerson != null)
{
var query_PersonInfo = new ORM_CMN_PER_PersonInfo.Query();
query_PersonInfo.CMN_PER_PersonInfoID = found_BusinessParticipant_ContactPerson.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
ORM_CMN_PER_PersonInfo found_PersonInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query_PersonInfo).First();
found_PersonInfo.FirstName = Parameter.ContactFirstName;
found_PersonInfo.LastName = Parameter.ContactLastName;
found_PersonInfo.PrimaryEmail = Parameter.ContactEmail;
var query_CommunicationContact = new ORM_CMN_PER_CommunicationContact.Query();
query_CommunicationContact.PersonInfo_RefID = found_PersonInfo.CMN_PER_PersonInfoID;
ORM_CMN_PER_CommunicationContact found_CommunicationContact = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query_CommunicationContact).First();
found_CommunicationContact.Content = Parameter.ContactPhoneNumber;
found_CommunicationContact.Save(Connection, Transaction);
found_PersonInfo.Save(Connection, Transaction);
}
else
{
ORM_CMN_BPT_BusinessParticipant contactPerson = new ORM_CMN_BPT_BusinessParticipant();
Guid businessParticipantID = Guid.NewGuid();
contactPerson.CMN_BPT_BusinessParticipantID = businessParticipantID;
contactPerson.IsCompany = false;
contactPerson.IsNaturalPerson = true;
contactPerson.IsTenant = false;
contactPerson.Creation_Timestamp = DateTime.Now;
contactPerson.Tenant_RefID = securityTicket.TenantID;
item.ContactPerson_BusinessParticipant_RefID = businessParticipantID;
//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.ContactFirstName;
personInfo.LastName = Parameter.ContactLastName;
personInfo.PrimaryEmail = Parameter.ContactEmail;
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.ContactPhoneNumber;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
item.ContactPerson_BusinessParticipant_RefID = businessParticipantID;
item.Save(Connection, Transaction);
}
//Company (pharmacy) finding and edit
var query_CompanyInfo = new ORM_CMN_COM_CompanyInfo.Query();
query_CompanyInfo.CMN_COM_CompanyInfoID = item.Ext_CompanyInfo_RefID;
ORM_CMN_COM_CompanyInfo found_CompanyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, query_CompanyInfo).First();
var query_CompanyContactDetails = new ORM_CMN_UniversalContactDetail.Query();
query_CompanyContactDetails.CMN_UniversalContactDetailID = found_CompanyInfo.Contact_UCD_RefID;
ORM_CMN_UniversalContactDetail found_CompanyContactDetails = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, query_CompanyContactDetails).FirstOrDefault();
if (found_CompanyContactDetails != null)
{
found_CompanyContactDetails.CompanyName_Line1 = Parameter.PharmacyName;
found_CompanyContactDetails.Contact_Email = Parameter.MainEmail;
found_CompanyContactDetails.Street_Name = Parameter.Street;
found_CompanyContactDetails.Street_Number = Parameter.Number;
found_CompanyContactDetails.Street_Name_Line2 = Parameter.Street2;
found_CompanyContactDetails.Town = Parameter.Town;
found_CompanyContactDetails.ZIP = Parameter.ZIP;
found_CompanyContactDetails.Save(Connection, Transaction);
}
else
{
ORM_CMN_UniversalContactDetail universalContactDetails = new ORM_CMN_UniversalContactDetail();
universalContactDetails.CMN_UniversalContactDetailID = Guid.NewGuid();
universalContactDetails.IsCompany = true;
universalContactDetails.CompanyName_Line1 = Parameter.PharmacyName;
universalContactDetails.Street_Name = Parameter.Street;
universalContactDetails.Street_Name_Line2 = Parameter.Street2;
universalContactDetails.Street_Number = Parameter.Number;
universalContactDetails.Contact_Email = Parameter.MainEmail;
universalContactDetails.ZIP = Parameter.ZIP;
universalContactDetails.Town = Parameter.Town;
universalContactDetails.Tenant_RefID = securityTicket.TenantID;
universalContactDetails.Save(Connection, Transaction);
found_CompanyInfo.Contact_UCD_RefID = universalContactDetails.CMN_UniversalContactDetailID;
found_CompanyInfo.Save(Connection, Transaction);
}
var query_BusinessParticipant_Company = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BusinessParticipant_Company.IfCompany_CMN_COM_CompanyInfo_RefID = found_CompanyInfo.CMN_COM_CompanyInfoID;
ORM_CMN_BPT_BusinessParticipant found_BusinessParticipant_Company = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BusinessParticipant_Company).First();
found_BusinessParticipant_Company.DisplayName = Parameter.PharmacyName;
found_BusinessParticipant_Company.Save(Connection, Transaction);
#endregion
}
else
{
#region Save
item.HEC_PharmacyID = Guid.NewGuid();
item.Creation_Timestamp = DateTime.Now;
item.Tenant_RefID = securityTicket.TenantID;
//business Participants
ORM_CMN_BPT_BusinessParticipant contactPerson = new ORM_CMN_BPT_BusinessParticipant();
Guid businessParticipantID = Guid.NewGuid();
contactPerson.CMN_BPT_BusinessParticipantID = businessParticipantID;
contactPerson.IsCompany = false;
contactPerson.IsNaturalPerson = true;
contactPerson.IsTenant = false;
contactPerson.Creation_Timestamp = DateTime.Now;
contactPerson.Tenant_RefID = securityTicket.TenantID;
item.ContactPerson_BusinessParticipant_RefID = businessParticipantID;
//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.ContactFirstName;
personInfo.LastName = Parameter.ContactLastName;
personInfo.PrimaryEmail = Parameter.ContactEmail;
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.ContactPhoneNumber;
communicationContacts.Creation_Timestamp = DateTime.Now;
communicationContacts.Tenant_RefID = securityTicket.TenantID;
communicationContacts.Save(Connection, Transaction);
//ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
//Guid companyInfoID = Guid.NewGuid();
ORM_CMN_COM_CompanyInfo extCompanyInfo = new ORM_CMN_COM_CompanyInfo();
Guid extCompanyInfoID = Guid.NewGuid();
extCompanyInfo.CMN_COM_CompanyInfoID = extCompanyInfoID;
Guid contactUCDID = Guid.NewGuid();
extCompanyInfo.Contact_UCD_RefID = contactUCDID;
extCompanyInfo.Creation_Timestamp = DateTime.Now;
extCompanyInfo.Tenant_RefID = securityTicket.TenantID;
item.Ext_CompanyInfo_RefID = extCompanyInfoID;
ORM_CMN_UniversalContactDetail universalContactDetails = new ORM_CMN_UniversalContactDetail();
universalContactDetails.CMN_UniversalContactDetailID = contactUCDID;
universalContactDetails.IsCompany = true;
universalContactDetails.CompanyName_Line1 = Parameter.PharmacyName;
universalContactDetails.Street_Name = Parameter.Street;
universalContactDetails.Street_Name_Line2 = Parameter.Street2;
universalContactDetails.Street_Number = Parameter.Number;
universalContactDetails.Contact_Email = Parameter.MainEmail;
universalContactDetails.ZIP = Parameter.ZIP;
universalContactDetails.Town = Parameter.Town;
universalContactDetails.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_BPT_BusinessParticipant extCompany = new ORM_CMN_BPT_BusinessParticipant();
extCompany.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
extCompany.Creation_Timestamp = DateTime.Now;
extCompany.Tenant_RefID = securityTicket.TenantID;
extCompany.DisplayName = Parameter.PharmacyName;
extCompany.IsCompany = true;
extCompany.IsNaturalPerson = false;
extCompany.IsTenant = false;
extCompany.IsDeleted = false;
extCompany.IfCompany_CMN_COM_CompanyInfo_RefID = extCompanyInfoID;
extCompany.Save(Connection, Transaction);
extCompanyInfo.Save(Connection, Transaction);
universalContactDetails.Save(Connection, Transaction);
item.Save(Connection, Transaction);
returnValue.Result = item.HEC_PharmacyID;
#endregion
}
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
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3MP_SPBI_1602 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_MedicalPractis practices;
if (Parameter.HEC_MedicalPractiseID != Guid.Empty)
{
var practicesQuery = new ORM_HEC_MedicalPractis.Query();
practicesQuery.HEC_MedicalPractiseID = Parameter.HEC_MedicalPractiseID;
practices = ORM_HEC_MedicalPractis.Query.Search(Connection, Transaction, practicesQuery).First();
}
else
{
practices = new ORM_HEC_MedicalPractis();
practices.HEC_MedicalPractiseID = Guid.NewGuid();
}
practices.Tenant_RefID = securityTicket.TenantID;
if (Parameter.isLucentis == false)
{
practices.Contact_EmergencyPhoneNumber = Parameter.Contact_EmergencyPhoneNumber;
}
ORM_CMN_COM_CompanyInfo companyInfo;
if (practices.Ext_CompanyInfo_RefID != Guid.Empty)
{
var companyInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
companyInfoQuery.CMN_COM_CompanyInfoID = practices.Ext_CompanyInfo_RefID;
companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companyInfoQuery).First();
}
else
{
companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = Guid.NewGuid();
practices.Ext_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
}
companyInfo.Tenant_RefID = securityTicket.TenantID;
if (Parameter.isLucentis)
{
companyInfo.CompanyInfo_EstablishmentNumber = Parameter.ifLucentis_BSNR;
}
ORM_CMN_BPT_BusinessParticipant bParticipant;
var bParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
bParticipantQuery.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
var bpRes = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, bParticipantQuery);
if (bpRes.Count == 0)
{
bParticipant = new ORM_CMN_BPT_BusinessParticipant();
bParticipant.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bParticipant.IsCompany = true;
bParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
}
else
{
bParticipant = bpRes.First();
}
bParticipant.DisplayName = Parameter.PracticeName;
bParticipant.Tenant_RefID = securityTicket.TenantID;
ORM_CMN_UniversalContactDetail contactDetails;
if (companyInfo.Contact_UCD_RefID != Guid.Empty)
{
var ucdQuery = new ORM_CMN_UniversalContactDetail.Query();
ucdQuery.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
contactDetails = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, ucdQuery).First();
}
else
{
contactDetails = new ORM_CMN_UniversalContactDetail();
contactDetails.CMN_UniversalContactDetailID = Guid.NewGuid();
companyInfo.Contact_UCD_RefID = contactDetails.CMN_UniversalContactDetailID;
contactDetails.IsCompany = true;
}
contactDetails.Tenant_RefID = securityTicket.TenantID;
if (Parameter.isLucentis == false)
{
contactDetails.Contact_Website_URL = Parameter.Contact_Website_URL;
}
contactDetails.Contact_Email = Parameter.PracticeEmail;
contactDetails.Town = Parameter.Town;
contactDetails.Street_Number = Parameter.Street_Number;
contactDetails.Street_Name = Parameter.Street_Name;
contactDetails.ZIP = Parameter.ZIP;
if (Parameter.isLucentis == false)
{
contactDetails.Region_Name = Parameter.Region_Name;
}
if (Parameter.isLucentis)
{
contactDetails.Street_Name_Line2 = Parameter.Street_Name_Line2;
}
companyInfo.Save(Connection, Transaction);
bParticipant.Save(Connection, Transaction);
contactDetails.Save(Connection, Transaction);
practices.Save(Connection, Transaction);
returnValue.Result = practices.HEC_MedicalPractiseID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5HI_SHIC_1519 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_HIS_HealthInsurance_Company hiCompany;
if (Parameter.HEC_HealthInsurance_CompanyID != Guid.Empty)
{
if (Parameter.IsDeleted)
{
ORM_HEC_HIS_HealthInsurance_Company.Query.SoftDelete(Connection, Transaction, new ORM_HEC_HIS_HealthInsurance_Company.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_HealthInsurance_CompanyID = Parameter.HEC_HealthInsurance_CompanyID
});
return(returnValue);
}
hiCompany = ORM_HEC_HIS_HealthInsurance_Company.Query.Search(Connection, Transaction, new ORM_HEC_HIS_HealthInsurance_Company.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_HealthInsurance_CompanyID = Parameter.HEC_HealthInsurance_CompanyID
}).Single();
}
else
{
hiCompany = new ORM_HEC_HIS_HealthInsurance_Company();
hiCompany.HEC_HealthInsurance_CompanyID = Guid.NewGuid();
hiCompany.Tenant_RefID = securityTicket.TenantID;
}
hiCompany.HealthInsurance_IKNumber = Parameter.HealthInsurance_IKNumber;
if (hiCompany.CMN_BPT_BusinessParticipant_RefID == Guid.Empty)
{
hiCompany.CMN_BPT_BusinessParticipant_RefID = Guid.NewGuid();
}
hiCompany.Save(Connection, Transaction);
var bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
IsCompany = true,
CMN_BPT_BusinessParticipantID = hiCompany.CMN_BPT_BusinessParticipant_RefID
}).SingleOrDefault();
if (bussinessParticipant == null)
{
bussinessParticipant = new ORM_CMN_BPT_BusinessParticipant();
bussinessParticipant.CMN_BPT_BusinessParticipantID = hiCompany.CMN_BPT_BusinessParticipant_RefID;
bussinessParticipant.Tenant_RefID = securityTicket.TenantID;
bussinessParticipant.IsCompany = true;
}
bussinessParticipant.DisplayName = Parameter.DisplayName;
if (bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID == Guid.Empty)
{
bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = Guid.NewGuid();
}
bussinessParticipant.Save(Connection, Transaction);
var comapny = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, new ORM_CMN_COM_CompanyInfo.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_COM_CompanyInfoID = bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID
}).SingleOrDefault();
if (comapny == null)
{
comapny = new ORM_CMN_COM_CompanyInfo();
comapny.CMN_COM_CompanyInfoID = bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
comapny.Tenant_RefID = securityTicket.TenantID;
}
comapny.Save(Connection, Transaction);
returnValue.Result = hiCompany.HEC_HealthInsurance_CompanyID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3CA_CoUSfIC_1545 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
/*
* @See if Supplier already exists in database
* */
ORM_CMN_BPT_Supplier supplier = new ORM_CMN_BPT_Supplier();
var supplierQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
supplierQuery.BusinessParticipantITL = Parameter.SupplierITL;
supplierQuery.Tenant_RefID = securityTicket.TenantID;
supplierQuery.IsDeleted = false;
var supplier_bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, supplierQuery).FirstOrDefault();
#region if supplier does not exist
if (supplier_bussinessParticipant == null)
{
/*
* @Make Supplier Data
* */
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.TenantITL,
Tenant_RefID = securityTicket.TenantID
};
var supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
}
supplier.CMN_BPT_SupplierID = Guid.NewGuid();
supplier.Ext_BusinessParticipant_RefID = Guid.NewGuid();//supplierBussinessParticipant.CMN_BPT_BusinessParticipantID
supplier.Creation_Timestamp = DateTime.Now;
supplier.IsDeleted = false;
supplier.Tenant_RefID = securityTicket.TenantID;
supplier.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant supplierBussinessParticipant = new ORM_CMN_BPT_BusinessParticipant();
supplierBussinessParticipant.CMN_BPT_BusinessParticipantID = supplier.Ext_BusinessParticipant_RefID;
supplierBussinessParticipant.DisplayName = Parameter.Supplier_Name;
supplierBussinessParticipant.BusinessParticipantITL = Parameter.SupplierITL;
supplierBussinessParticipant.Creation_Timestamp = DateTime.Now;
supplierBussinessParticipant.Tenant_RefID = securityTicket.TenantID;
supplierBussinessParticipant.IsCompany = true;
supplierBussinessParticipant.IsTenant = true;
supplierBussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = Guid.NewGuid();//companyInfo.CMN_COM_CompanyInfoID
supplierBussinessParticipant.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfo.Creation_Timestamp = DateTime.Now;
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Contact_UCD_RefID = Guid.NewGuid();//universalContactDetail.CMN_UniversalContactDetailID
companyInfo.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail universalContactDetail = new ORM_CMN_UniversalContactDetail();
universalContactDetail.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetail.IsCompany = true;
universalContactDetail.Country_639_1_ISOCode = Parameter.CountryISO;
universalContactDetail.Street_Name = Parameter.Supplier_Name;
universalContactDetail.Street_Number = Parameter.Street_Number;
universalContactDetail.ZIP = Parameter.ZIP;
universalContactDetail.Town = Parameter.Town;
universalContactDetail.Region_Code = Parameter.Region_Code;
universalContactDetail.Tenant_RefID = securityTicket.TenantID;
universalContactDetail.Creation_Timestamp = DateTime.Now;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
#region if supplier exists , check if its data is changed
else
{
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.TenantITL,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
};
ORM_CMN_Tenant supplierTenant;
if (ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).Count > 1)
{
supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).First(); //QUICKFIX
}
else
{
supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
}
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
supplier_bussinessParticipant.IsTenant = true;
supplier_bussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
}
supplier_bussinessParticipant.DisplayName = Parameter.Supplier_Name;
supplier_bussinessParticipant.Save(Connection, Transaction);
var query = new ORM_CMN_BPT_Supplier.Query();
query.Ext_BusinessParticipant_RefID = supplier_bussinessParticipant.CMN_BPT_BusinessParticipantID;
query.Tenant_RefID = securityTicket.TenantID;
query.IsDeleted = false;
supplier = ORM_CMN_BPT_Supplier.Query.Search(Connection, Transaction, query).First();
//edit universal contact details
var companyInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
companyInfoQuery.CMN_COM_CompanyInfoID = supplier_bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfoQuery.Tenant_RefID = securityTicket.TenantID;
companyInfoQuery.IsDeleted = false;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companyInfoQuery).First();
var universalContactDetailQuery = new ORM_CMN_UniversalContactDetail.Query();
universalContactDetailQuery.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetailQuery.Tenant_RefID = securityTicket.TenantID;
universalContactDetailQuery.IsDeleted = false;
var universalContactDetail = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, universalContactDetailQuery).First();
universalContactDetail.Country_639_1_ISOCode = Parameter.CountryISO;
universalContactDetail.Street_Name = Parameter.Supplier_Name;
universalContactDetail.Street_Number = Parameter.Street_Number;
universalContactDetail.ZIP = Parameter.ZIP;
universalContactDetail.Town = Parameter.Town;
universalContactDetail.Region_Code = Parameter.Region_Code;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
returnValue.Result = supplier.CMN_BPT_SupplierID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_SP__1122 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_HEC_MedicalPractis item = new ORM_HEC_MedicalPractis();
if (Parameter.PracticeID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.PracticeID);
if (result.Status != FR_Status.Success || item.HEC_MedicalPractiseID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
#region Delete
if (Parameter.isDeleted == true)
{
var query_BP_ContactPerson_del = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BP_ContactPerson_del.CMN_BPT_BusinessParticipantID = item.ContactPerson_RefID;
query_BP_ContactPerson_del.Tenant_RefID = securityTicket.TenantID;
var found_BP_ContactPerson_del = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BP_ContactPerson_del).First();
found_BP_ContactPerson_del.IsDeleted = true;
var query_PersonInfo_del = new ORM_CMN_PER_PersonInfo.Query();
query_PersonInfo_del.CMN_PER_PersonInfoID = found_BP_ContactPerson_del.IfNaturalPerson_CMN_PER_PersonInfo_RefID;
var found_PersonInfo_del = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, query_PersonInfo_del).First();
found_PersonInfo_del.IsDeleted = true;
found_PersonInfo_del.Save(Connection, Transaction);
var query_CommunicationContact_del = new ORM_CMN_PER_CommunicationContact.Query();
query_CommunicationContact_del.PersonInfo_RefID = found_PersonInfo_del.CMN_PER_PersonInfoID;
var found_CommunicationContact_del = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query_CommunicationContact_del).First();
found_CommunicationContact_del.IsDeleted = true;
found_CommunicationContact_del.Save(Connection, Transaction);
var query_CompanyInfo_del = new ORM_CMN_COM_CompanyInfo.Query();
query_CompanyInfo_del.CMN_COM_CompanyInfoID = item.Ext_CompanyInfo_RefID;
var found_CompanyInfo_del = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, query_CompanyInfo_del).First();
found_CompanyInfo_del.IsDeleted = true;
found_CompanyInfo_del.Save(Connection, Transaction);
var query_BP_Company_del = new ORM_CMN_BPT_BusinessParticipant.Query();
query_BP_Company_del.IfCompany_CMN_COM_CompanyInfo_RefID = found_CompanyInfo_del.CMN_COM_CompanyInfoID;
var found_BP_Company_del = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query_BP_Company_del).First();
found_BP_Company_del.IsDeleted = true;
found_BP_Company_del.Save(Connection, Transaction);
var query_UniversalContactDetails_del = new ORM_CMN_UniversalContactDetail.Query();
query_UniversalContactDetails_del.CMN_UniversalContactDetailID = found_CompanyInfo_del.Contact_UCD_RefID;
var found_UniversalCompanyDetails_del = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, query_UniversalContactDetails_del).First();
found_UniversalCompanyDetails_del.IsDeleted = true;
found_UniversalCompanyDetails_del.Save(Connection, Transaction);
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.HEC_MedicalPractiseID));
}
#endregion
#region Edit
var query1 = new ORM_CMN_BPT_BusinessParticipant.Query();
query1.CMN_BPT_BusinessParticipantID = item.ContactPerson_RefID;
query1.Tenant_RefID = securityTicket.TenantID;
query1.IsCompany = false;
query1.IsNaturalPerson = true;
query1.IsTenant = false;
var bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query1).First();
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.ContactPersonFirstName;
personInfo.LastName = Parameter.ContactPersonLastName;
personInfo.PrimaryEmail = Parameter.ContactPersonEmail;
personInfo.Save(Connection, Transaction);
var query3 = new ORM_CMN_PER_CommunicationContact.Query();
query3.PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
var communicationContacts = ORM_CMN_PER_CommunicationContact.Query.Search(Connection, Transaction, query3).First();
communicationContacts.Contact_Type = Parameter.ContactTypePhone;
communicationContacts.Content = Parameter.ContactPersonPhoneNumber;
communicationContacts.Save(Connection, Transaction);
var query4 = new ORM_CMN_COM_CompanyInfo.Query();
query4.CMN_COM_CompanyInfoID = item.Ext_CompanyInfo_RefID;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, query4).First();
companyInfo.CompanyInfo_EstablishmentNumber = Parameter.BSNR;
companyInfo.Save(Connection, Transaction);
var query5 = new ORM_CMN_BPT_BusinessParticipant.Query();
query5.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
var extCompany = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, query5).First();
extCompany.DisplayName = Parameter.PracticeName;
extCompany.Save(Connection, Transaction);
var query6 = new ORM_CMN_UniversalContactDetail.Query();
query6.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
var companyDetails = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, query6).First();
companyDetails.ZIP = Parameter.ZIP;
companyDetails.Town = Parameter.Town;
companyDetails.Street_Name = Parameter.PracticeStreet;
companyDetails.Street_Number = Parameter.PracticeNumber;
companyDetails.Contact_Email = Parameter.PracitceEmail;
companyDetails.Street_Name_Line2 = Parameter.PracticeStreet2;
companyDetails.Save(Connection, Transaction);
#endregion
}
else
{
#region Save
item.HEC_MedicalPractiseID = Guid.NewGuid();
item.Creation_Timestamp = DateTime.Now;
item.Tenant_RefID = securityTicket.TenantID;
//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;
item.ContactPerson_RefID = businessParticipantsID;
//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);
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
Guid companyInfoID = Guid.NewGuid();
companyInfo.CMN_COM_CompanyInfoID = companyInfoID;
companyInfo.Creation_Timestamp = DateTime.Now;
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.CompanyInfo_EstablishmentNumber = Parameter.BSNR;
item.Ext_CompanyInfo_RefID = companyInfoID;
ORM_CMN_BPT_BusinessParticipant extCompany = new ORM_CMN_BPT_BusinessParticipant();
extCompany.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
extCompany.Creation_Timestamp = DateTime.Now;
extCompany.Tenant_RefID = securityTicket.TenantID;
extCompany.DisplayName = Parameter.PracticeName;
extCompany.IsCompany = true;
extCompany.IsNaturalPerson = false;
extCompany.IsTenant = false;
extCompany.IsDeleted = false;
extCompany.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfoID;
extCompany.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail companyDetails = new ORM_CMN_UniversalContactDetail();
Guid companyDetailsID = Guid.NewGuid();
companyInfo.Contact_UCD_RefID = companyDetailsID;
companyInfo.Save(Connection, Transaction);
companyDetails.CMN_UniversalContactDetailID = companyDetailsID;
companyDetails.Tenant_RefID = securityTicket.TenantID;
companyDetails.Creation_Timestamp = DateTime.Now;
companyDetails.IsCompany = true;
companyDetails.ZIP = Parameter.ZIP;
companyDetails.Town = Parameter.Town;
companyDetails.Street_Name = Parameter.PracticeStreet;
companyDetails.Street_Number = Parameter.PracticeNumber;
companyDetails.Contact_Email = Parameter.PracitceEmail;
companyDetails.Street_Name_Line2 = Parameter.PracticeStreet2;
companyDetails.IsDeleted = false;
companyDetails.Save(Connection, Transaction);
item.Save(Connection, Transaction);
#endregion
}
returnValue.Result = item.HEC_MedicalPractiseID;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_SP_1538 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var practice = new ORM_HEC_MedicalPractis()
{
HEC_MedicalPractiseID = Guid.NewGuid(),
Tenant_RefID = securityTicket.TenantID,
Ext_CompanyInfo_RefID = Guid.NewGuid()
};
practice.Save(Connection, Transaction);
var companyInfo = new ORM_CMN_COM_CompanyInfo()
{
CMN_COM_CompanyInfoID = practice.Ext_CompanyInfo_RefID,
Tenant_RefID = securityTicket.TenantID,
CompanyInfo_EstablishmentNumber = Parameter.Practice_BSNR
};
companyInfo.Save(Connection, Transaction);
var bParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
IsTenant = true
}).Single();
bParticipant.IsCompany = true;
bParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
bParticipant.Save(Connection, Transaction);
if (Parameter.Doctor != null)
{
var account2personInfo = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo_2_Account.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
USR_Account_RefID = Parameter.Doctor.AccountID
}).Single();
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, new ORM_CMN_PER_PersonInfo.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_PER_PersonInfoID = account2personInfo.CMN_PER_PersonInfo_RefID
}).First();
personInfo.FirstName = Parameter.Doctor.FirstName;
personInfo.LastName = Parameter.Doctor.LastName;
personInfo.Title = Parameter.Doctor.Title;
personInfo.Save(Connection, Transaction);
var bussinessParticipantTable = new ORM_CMN_BPT_BusinessParticipant();
bussinessParticipantTable.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
bussinessParticipantTable.IsNaturalPerson = true;
bussinessParticipantTable.Tenant_RefID = securityTicket.TenantID;
bussinessParticipantTable.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
bussinessParticipantTable.Save(Connection, Transaction);
var doctor = new ORM_HEC_Doctor();
doctor.Tenant_RefID = securityTicket.TenantID;
doctor.BusinessParticipant_RefID = bussinessParticipantTable.CMN_BPT_BusinessParticipantID;
doctor.Account_RefID = Parameter.Doctor.AccountID;
doctor.DoctorIDNumber = Parameter.Doctor.LANR;
doctor.Save(Connection, Transaction);
var associatedbusinessparticipants = new ORM_CMN_BPT_BusinessParticipant_AssociatedBusinessParticipant();
associatedbusinessparticipants.BusinessParticipant_RefID = bussinessParticipantTable.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.AssociatedBusinessParticipant_RefID = bParticipant.CMN_BPT_BusinessParticipantID;
associatedbusinessparticipants.Tenant_RefID = securityTicket.TenantID;
associatedbusinessparticipants.Save(Connection, Transaction);
if (Parameter.Doctor.BankData != null)
{
ORM_CMN_BPT_BusinessParticipant_2_BankAccount bussiness_2_BankaAccount = new ORM_CMN_BPT_BusinessParticipant_2_BankAccount();
bussiness_2_BankaAccount.AssignmentID = Guid.NewGuid();
bussiness_2_BankaAccount.CMN_BPT_BusinessParticipant_RefID = doctor.BusinessParticipant_RefID;
bussiness_2_BankaAccount.ACC_BNK_BankAccount_RefID = Guid.NewGuid();
bussiness_2_BankaAccount.Tenant_RefID = securityTicket.TenantID;
bussiness_2_BankaAccount.Save(Connection, Transaction);
ORM_ACC_BNK_BankAccount bankAccount = new ORM_ACC_BNK_BankAccount();
bankAccount.ACC_BNK_BankAccountID = bussiness_2_BankaAccount.ACC_BNK_BankAccount_RefID;
bankAccount.Tenant_RefID = securityTicket.TenantID;
bankAccount.OwnerText = Parameter.Doctor.BankData.AccountHolder;
bankAccount.AccountNumber = Parameter.Doctor.BankData.AccountNumber;
bankAccount.IBAN = Parameter.Doctor.BankData.IBAN;
bankAccount.Bank_RefID = Guid.NewGuid();
bankAccount.Save(Connection, Transaction);
ORM_ACC_BNK_Bank bank = new ORM_ACC_BNK_Bank();
bank.ACC_BNK_BankID = bankAccount.Bank_RefID;
bank.Tenant_RefID = securityTicket.TenantID;
bank.BankName = Parameter.Doctor.BankData.BankName;
bank.BICCode = Parameter.Doctor.BankData.BIC;
bank.BankNumber = Parameter.Doctor.BankData.BankNumber;
bank.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_PH_SP_1124 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
#region Pharmacy
var pharmacy = ORM_HEC_Pharmacy.Query.Search(Connection, Transaction, new ORM_HEC_Pharmacy.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_PharmacyID = Parameter.Pharmacy.PharmacyID
}).SingleOrDefault();
if (pharmacy == null)
{
pharmacy = new ORM_HEC_Pharmacy();
pharmacy.Tenant_RefID = securityTicket.TenantID;
}
#endregion
#region CompanyInfo
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, new ORM_CMN_COM_CompanyInfo.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_COM_CompanyInfoID = pharmacy.Ext_CompanyInfo_RefID
}).SingleOrDefault();
if (companyInfo == null)
{
companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.Tenant_RefID = securityTicket.TenantID;
pharmacy.Ext_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
}
var contractUCD = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, new ORM_CMN_UniversalContactDetail.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID
}).SingleOrDefault();
if (contractUCD == null)
{
contractUCD = new ORM_CMN_UniversalContactDetail();
contractUCD.Tenant_RefID = securityTicket.TenantID;
contractUCD.IsCompany = true;
}
contractUCD.CompanyName_Line1 = Parameter.Pharmacy.PharmacyName;
contractUCD.First_Name = Parameter.Pharmacy.PharmacyName;
contractUCD.Contact_Email = Parameter.Pharmacy.Email;
contractUCD.Contact_Telephone = Parameter.Pharmacy.PhoneNumber;
contractUCD.Contact_Fax = Parameter.Pharmacy.Fax;
contractUCD.Street_Name = Parameter.Pharmacy.Street;
contractUCD.Street_Number = Parameter.Pharmacy.StreetNumber;
contractUCD.ZIP = Parameter.Pharmacy.ZipCode;
contractUCD.Town = Parameter.Pharmacy.Town;
contractUCD.Save(Connection, Transaction);
companyInfo.Contact_UCD_RefID = contractUCD.CMN_UniversalContactDetailID;
companyInfo.Save(Connection, Transaction);
var ciBusinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID
}).SingleOrDefault();
if (ciBusinessParticipant == null)
{
ciBusinessParticipant = new ORM_CMN_BPT_BusinessParticipant();
ciBusinessParticipant.Tenant_RefID = securityTicket.TenantID;
ciBusinessParticipant.IsCompany = true;
ciBusinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = companyInfo.CMN_COM_CompanyInfoID;
}
ciBusinessParticipant.Save(Connection, Transaction);
var pharmacyType = EPharmacyType.Internal.Value();
if (Parameter.Pharmacy.IsExternalPharmacy)
{
pharmacyType = EPharmacyType.External.Value();
}
var businessParticipantGroup = ORM_CMN_BPT_BusinessParticipant_Group.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant_Group.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
GlobalPropertyMatchingID = pharmacyType
}).SingleOrDefault();
if (businessParticipantGroup == null)
{
businessParticipantGroup = new ORM_CMN_BPT_BusinessParticipant_Group();
businessParticipantGroup.Tenant_RefID = securityTicket.TenantID;
businessParticipantGroup.GlobalPropertyMatchingID = pharmacyType;
businessParticipantGroup.Save(Connection, Transaction);
}
var bpToBpGroup = ORM_CMN_BPT_BusinessParticipant_2_BusinessParticipantGroup.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant_2_BusinessParticipantGroup.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_BPT_BusinessParticipant_RefID = ciBusinessParticipant.CMN_BPT_BusinessParticipantID,
CMN_BPT_BusinessParticipant_Group_RefID = businessParticipantGroup.CMN_BPT_BusinessParticipant_GroupID
}).SingleOrDefault();
if (bpToBpGroup == null)
{
bpToBpGroup = new ORM_CMN_BPT_BusinessParticipant_2_BusinessParticipantGroup();
bpToBpGroup.Tenant_RefID = securityTicket.TenantID;
bpToBpGroup.CMN_BPT_BusinessParticipant_Group_RefID = businessParticipantGroup.CMN_BPT_BusinessParticipant_GroupID;
bpToBpGroup.CMN_BPT_BusinessParticipant_RefID = ciBusinessParticipant.CMN_BPT_BusinessParticipantID;
bpToBpGroup.Save(Connection, Transaction);
}
#endregion
#region ContactPersonInfo
var contactInfo = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_BPT_BusinessParticipantID = pharmacy.ContactPerson_BusinessParticipant_RefID
}).SingleOrDefault();
if (contactInfo == null)
{
contactInfo = new ORM_CMN_BPT_BusinessParticipant();
contactInfo.Tenant_RefID = securityTicket.TenantID;
contactInfo.IsNaturalPerson = true;
}
var personInfo = ORM_CMN_PER_PersonInfo.Query.Search(Connection, Transaction, new ORM_CMN_PER_PersonInfo.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDead = false,
CMN_PER_PersonInfoID = contactInfo.IfNaturalPerson_CMN_PER_PersonInfo_RefID
}).SingleOrDefault();
if (personInfo == null)
{
personInfo = new ORM_CMN_PER_PersonInfo();
personInfo.Tenant_RefID = securityTicket.TenantID;
}
var splitedName = Parameter.Pharmacy.ContactPersonName.Split(' ');
var firstName = splitedName.Length > 1 ? string.Join(" ", splitedName.Take(splitedName.Length - 1)) : splitedName[0];
var lastName = splitedName.Length > 1 ? splitedName.Last() : "";
personInfo.FirstName = firstName;
personInfo.LastName = lastName;
personInfo.Save(Connection, Transaction);
contactInfo.IfNaturalPerson_CMN_PER_PersonInfo_RefID = personInfo.CMN_PER_PersonInfoID;
contactInfo.Save(Connection, Transaction);
pharmacy.ContactPerson_BusinessParticipant_RefID = contactInfo.CMN_BPT_BusinessParticipantID;
#endregion
pharmacy.Save(Connection, Transaction);
returnValue.Result = pharmacy.HEC_PharmacyID;
return(returnValue);
#endregion UserCode
}
