protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2UT_SU_1250 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnValue = new FR_Guid();
var item = new ORM_CMN_Unit();
if (Parameter.CMN_UnitID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.CMN_UnitID);
if (result.Status != FR_Status.Success || item.CMN_UnitID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_UnitID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.CMN_UnitID == Guid.Empty)
{
item.Tenant_RefID = securityTicket.TenantID;
}
item.Label = Parameter.Label;
item.Abbreviation = Parameter.Abbreviation;
item.ISOCode = Parameter.ISOCode;
return(new FR_Guid(item.Save(Connection, Transaction), item.CMN_UnitID));
}
protected static FR_L3PR_IoUPBD_1614_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3PR_IoUPBD_1614 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L3PR_IoUPBD_1614_Array();
var result = new List <L3PR_IoUPBD_1614>();
//Put your code here
#region Get All Producers for Tenant
var allProducers = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
#endregion
#region Get Taxes For Default Country
var taxesToImport = Parameter.Products.Select(i => i.VAT).Distinct();
var param = new P_L3TX_STfDCaRR_1119();
param.TaxRates = taxesToImport.ToArray();
var allTaxes = cls_Save_Taxes_for_DefaultCountry_and_ReturnResult.Invoke(Connection, Transaction, param, securityTicket).Result;
#endregion
foreach (var item in Parameter.Products)
{
bool alreadyExistingInDB = true;
#region ORM_CMN_PRO_Product
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.ProductITL = item.ProductITL;
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.IsProductAvailableForOrdering = true;
var product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).FirstOrDefault();
if (product == null)
{
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.ProductITL = item.ProductITL;
product.PackageInfo_RefID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
alreadyExistingInDB = false;
}
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = true;
product.IsProductAvailableForOrdering = true;
#region Save Producer
var producerBPT = allProducers.Where(i => i.DisplayName == item.Producer).FirstOrDefault();
if (producerBPT == default(ORM_CMN_BPT_BusinessParticipant))
{
producerBPT = new ORM_CMN_BPT_BusinessParticipant();
producerBPT.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
producerBPT.DisplayName = item.Producer;
producerBPT.IsCompany = true;
producerBPT.Tenant_RefID = securityTicket.TenantID;
producerBPT.Creation_Timestamp = DateTime.Now;
producerBPT.Save(Connection, Transaction);
}
#endregion
product.ProducingBusinessParticipant_RefID = producerBPT.CMN_BPT_BusinessParticipantID;
product.Save(Connection, Transaction);
#endregion
#region Unit
//Unit could be used for multiple products, there is no sense to edit unit
//If there is need to change unit, we should find unit with that iso code and change reference
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)
{
measuredInUnit = new ORM_CMN_Unit();
measuredInUnit.Tenant_RefID = securityTicket.TenantID;
measuredInUnit.Creation_Timestamp = DateTime.Now;
measuredInUnit.ISOCode = item.MeasuredInUnit_ISO_um_ums;
measuredInUnit.CMN_UnitID = Guid.NewGuid();
measuredInUnit.Save(Connection, Transaction);
}
#endregion
#region PackageInfo
var packageInfo = new ORM_CMN_PRO_PAC_PackageInfo();
packageInfo.Load(Connection, Transaction, product.PackageInfo_RefID);
if (packageInfo.CMN_PRO_PAC_PackageInfoID == Guid.Empty)
{
packageInfo.CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID;
packageInfo.Creation_Timestamp = DateTime.Now;
packageInfo.Tenant_RefID = securityTicket.TenantID;
}
packageInfo.PackageContent_DisplayLabel = item.Amount;
packageInfo.PackageContent_Amount = PackageAmountUtils.GetPackageAmount(item.Amount);
packageInfo.PackageContent_MeasuredInUnit_RefID = measuredInUnit.CMN_UnitID;
packageInfo.Save(Connection, Transaction);
#endregion
#region VAT
var salesTax = ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query()
{
Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).FirstOrDefault();
if (salesTax == null)
{
salesTax = new ORM_CMN_PRO_Product_SalesTaxAssignmnet();
salesTax.CMN_PRO_Product_SalesTaxAssignmnetID = Guid.NewGuid();
salesTax.Product_RefID = product.CMN_PRO_ProductID;
salesTax.Creation_Timestamp = DateTime.Now;
salesTax.Tenant_RefID = securityTicket.TenantID;
}
salesTax.ApplicableSalesTax_RefID = allTaxes.Where(i => i.TaxRate == item.VAT).Select(j => j.TaxID).FirstOrDefault();
salesTax.Save(Connection, Transaction);
#endregion
result.Add(new L3PR_IoUPBD_1614()
{
ProductITL = product.ProductITL,
ProductID = product.CMN_PRO_ProductID,
IsAlreadyExisted = alreadyExistingInDB
});
}
returnValue.Result = result.ToArray();
return(returnValue);
}
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_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L3_AUTT_0950 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Base();
if (Parameter == null)
{
returnValue.Status = FR_Status.Error_Internal;
returnValue.ErrorMessage = "Assign_Units_To_Tenant method returned error message: Parameter is null.";
return(returnValue);
}
ORM_CMN_Unit[] units = null;
#region Retrieve all units fro tenant
units = ORM_CMN_Unit.Query.Search(Connection, Transaction, new ORM_CMN_Unit.Query()
{
Tenant_RefID = securityTicket.TenantID
}).ToArray();
#endregion
#region Assign/deassign units
foreach (var unitToAssign in Parameter.AssignedUnits)
{
var unit = units.FirstOrDefault(u => u.ISOCode == unitToAssign.UnitIsoCode);
if (unit == null)
{
unit = new ORM_CMN_Unit();
unit.CMN_UnitID = Guid.NewGuid();
unit.Creation_Timestamp = DateTime.Now;
unit.IsDeleted = false;
unit.ISOCode = unitToAssign.UnitIsoCode;
unit.Label = unitToAssign.UnitLabel;
unit.Tenant_RefID = securityTicket.TenantID;
unit.Abbreviation = unitToAssign.UnitAbbrevation;
unit.Save(Connection, Transaction);
}
if (unit.IsDeleted == true)
{
unit.IsDeleted = false;
unit.Save(Connection, Transaction);
}
}
foreach (var unit in units.Where(u => u.IsDeleted == false))
{
var unitToAssign = Parameter.AssignedUnits.FirstOrDefault(uta => uta.UnitIsoCode == unit.ISOCode);
if (unitToAssign == null)
{
unit.IsDeleted = true;
unit.Save(Connection, Transaction);
}
}
#endregion
#region Set default unit for tenant
// TODO: When Stefan Martinov changes database then it will be possible to make this change
#endregion
returnValue.Status = FR_Status.Success;
return(returnValue);
#endregion UserCode
}
protected static FR_L3AR_IoUPBD_1631_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3AR_IoUPBD_1631 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3AR_IoUPBD_1631_Array();
var result = new List <L3AR_IoUPBD_1631>();
#region Get All Producers for Tenant
var allProducers = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, new ORM_CMN_BPT_BusinessParticipant.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
#endregion
#region Get Taxes For Default Country
var taxesToImport = Parameter.Products.Select(i => i.VAT).Distinct();
var param = new P_L3TX_STfDCaRR_1119();
param.TaxRates = taxesToImport.ToArray();
var allTaxes = cls_Save_Taxes_for_DefaultCountry_and_ReturnResult.Invoke(Connection, Transaction, param, securityTicket).Result;
#endregion
#region DosageForms
var dosageQuery = new ORM_HEC_Product_DosageForm.Query();
dosageQuery.Tenant_RefID = securityTicket.TenantID;
dosageQuery.IsDeleted = false;
var allDosages = ORM_HEC_Product_DosageForm.Query.Search(Connection, Transaction, dosageQuery);
#endregion
foreach (var item in Parameter.Products)
{
bool alreadyExistingInDB = true;
#region ORM_CMN_PRO_Product
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.ProductITL = item.ProductITL;
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.IsProductAvailableForOrdering = true;
var product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).FirstOrDefault();
if (product == null)
{
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.ProductITL = item.ProductITL;
product.PackageInfo_RefID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
alreadyExistingInDB = false;
}
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = true;
product.IsProductAvailableForOrdering = true;
product.DefaultExpirationPeriod_in_sec = item.DefaultExpirationPeriod_in_sec;
if (item.DefaultStorageTemperature_min_in_kelvin != 0)
{
product.DefaultStorageTemperature_min_in_kelvin = (float)Math.Round(item.DefaultStorageTemperature_min_in_kelvin, 2);
}
if (item.DefaultStorageTemperature_max_in_kelvin != 0)
{
product.DefaultStorageTemperature_max_in_kelvin = (float)Math.Round(item.DefaultStorageTemperature_max_in_kelvin, 2);
}
product.IsStorage_CoolingRequired = item.IsStorage_CoolingRequired;
var xmlModel = new ProductAdditionalInfoXML()
{
IsPharmacyOnlyDistribution = item.IsPharmacyOnlyDistribution
};
product.ProductAdditionalInfoXML = xmlModel.ToPayload();
product.IsStorage_ExpiryDateMandatory = (item.DefaultExpirationPeriod_in_sec != 0);
product.Save(Connection, Transaction);
#endregion
#region Save Producer
var producerBPT = allProducers.Where(i => i.DisplayName == item.Producer).FirstOrDefault();
if (producerBPT == default(ORM_CMN_BPT_BusinessParticipant))
{
producerBPT = new ORM_CMN_BPT_BusinessParticipant();
producerBPT.CMN_BPT_BusinessParticipantID = Guid.NewGuid();
producerBPT.DisplayName = item.Producer;
producerBPT.IsCompany = true;
producerBPT.Tenant_RefID = securityTicket.TenantID;
producerBPT.Creation_Timestamp = DateTime.Now;
producerBPT.Save(Connection, Transaction);
}
product.ProducingBusinessParticipant_RefID = producerBPT.CMN_BPT_BusinessParticipantID;
product.Save(Connection, Transaction);
#endregion
#region Product Code (EAN)
var product2Code = ORM_CMN_PRO_Product_2_ProductCode.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_2_ProductCode.Query()
{
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (product2Code == null)
{
var eanID = DMProductCodeTypes.Get_ProductCodeType_ByGlobalMatchingID(Connection, Transaction, EProductCodeType.EAN, securityTicket);
var productCode = new ORM_CMN_PRO_ProductCode();
productCode.CMN_PRO_ProductCodeID = Guid.NewGuid();
productCode.ProductCode_Type_RefID = eanID;
productCode.ProductCode_Value = String.Empty;
productCode.Creation_Timestamp = DateTime.Now;
productCode.Tenant_RefID = securityTicket.TenantID;
productCode.Save(Connection, Transaction);
product2Code = new ORM_CMN_PRO_Product_2_ProductCode();
product2Code.AssignmentID = Guid.NewGuid();
product2Code.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
product2Code.CMN_PRO_ProductCode_RefID = productCode.CMN_PRO_ProductCodeID;
product2Code.Creation_Timestamp = DateTime.Now;
product2Code.Tenant_RefID = securityTicket.TenantID;
product2Code.Save(Connection, Transaction);
}
else
{
var productCode = new ORM_CMN_PRO_ProductCode();
productCode.Load(Connection, Transaction, product2Code.CMN_PRO_ProductCode_RefID);
productCode.ProductCode_Value = String.Empty;
productCode.Save(Connection, Transaction);
}
#endregion
#region Unit
//Unit could be used for multiple products, there is no sense to edit unit
//If there is need to change unit, we should find unit with that iso code and change reference
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)
{
measuredInUnit = new ORM_CMN_Unit();
measuredInUnit.Tenant_RefID = securityTicket.TenantID;
measuredInUnit.Creation_Timestamp = DateTime.Now;
measuredInUnit.ISOCode = item.MeasuredInUnit_ISO_um_ums;
measuredInUnit.CMN_UnitID = Guid.NewGuid();
measuredInUnit.Save(Connection, Transaction);
}
#endregion
#region PackageInfo
var packageInfo = new ORM_CMN_PRO_PAC_PackageInfo();
packageInfo.Load(Connection, Transaction, product.PackageInfo_RefID);
if (packageInfo.CMN_PRO_PAC_PackageInfoID == Guid.Empty)
{
packageInfo.CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID;
packageInfo.Creation_Timestamp = DateTime.Now;
packageInfo.Tenant_RefID = securityTicket.TenantID;
}
packageInfo.PackageContent_DisplayLabel = item.Amount;
packageInfo.PackageContent_Amount = PackageAmountUtils.GetPackageAmount(item.Amount);
packageInfo.PackageContent_MeasuredInUnit_RefID = measuredInUnit.CMN_UnitID;
packageInfo.Save(Connection, Transaction);
#endregion
#region VAT
var salesTax = ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query()
{
Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (salesTax == null)
{
salesTax = new ORM_CMN_PRO_Product_SalesTaxAssignmnet();
salesTax.CMN_PRO_Product_SalesTaxAssignmnetID = Guid.NewGuid();
salesTax.Product_RefID = product.CMN_PRO_ProductID;
salesTax.Creation_Timestamp = DateTime.Now;
salesTax.Tenant_RefID = securityTicket.TenantID;
}
salesTax.ApplicableSalesTax_RefID = allTaxes.Where(i => i.TaxRate == item.VAT).Select(j => j.TaxID).FirstOrDefault();
salesTax.Save(Connection, Transaction);
#endregion
#region DosageForms
//DosageForms could be used for multiple products, there is no sense to edit unit
//If there is need to change unit, we should find unit with that GlobalPropertyMatchingID and change reference
var dosage = allDosages.Where(i => i.GlobalPropertyMatchingID == item.Dosage).FirstOrDefault();
//if not create new
if (dosage == null)
{
dosage = new ORM_HEC_Product_DosageForm();
dosage.HEC_Product_DosageFormID = Guid.NewGuid();
dosage.Tenant_RefID = securityTicket.TenantID;
dosage.Creation_Timestamp = DateTime.Now;
dosage.GlobalPropertyMatchingID = item.Dosage;
dosage.Save(Connection, Transaction);
}
#endregion
#region HecProduct
var hec_product = ORM_HEC_Product.Query.Search(Connection, Transaction, new ORM_HEC_Product.Query()
{
Ext_PRO_Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (hec_product == null)
{
hec_product = new ORM_HEC_Product();
hec_product.HEC_ProductID = Guid.NewGuid();
hec_product.Creation_Timestamp = DateTime.Now;
hec_product.Tenant_RefID = securityTicket.TenantID;
}
hec_product.Ext_PRO_Product_RefID = product.CMN_PRO_ProductID;
hec_product.ProductDosageForm_RefID = dosage.HEC_Product_DosageFormID;
hec_product.ProductDistributionStatus = item.DistributionStatus;
hec_product.IsProduct_AddictiveDrug = item.IsProduct_AddictiveDrug;
hec_product.Save(Connection, Transaction);
#endregion
var date = DateTime.Now;
#region Save Active Components
var componentsParam = new P_L3CO_SCfIPFC_1324();
componentsParam.HEC_ProductID = hec_product.HEC_ProductID;
componentsParam.ActiveComponents = item.ActiveComponents;
cls_Save_Componets_for_ImportedProductFromCatalog.Invoke(Connection, Transaction, componentsParam, securityTicket);
#endregion
result.Add(new L3AR_IoUPBD_1631()
{
ProductITL = product.ProductITL,
ProductID = product.CMN_PRO_ProductID,
IsAlreadyExisted = alreadyExistingInDB
});
date = DateTime.Now;
}
returnValue.Result = result.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5PA_SPEM_1413 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
var medPro_Credentials = cls_Get_TenantMemershipData.Invoke(Connection, Transaction, securityTicket).Result;
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;
var examination = ORM_HEC_ACT_PerformedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
HEC_ACT_PerformedActionID = Parameter.ExaminationID
}).Single();
#region Save
foreach (var item in Parameter.new_medication)
{
//check if dosage exists
var dosageQuery = new ORM_HEC_Dosage.Query();
dosageQuery.IsDeleted = false;
dosageQuery.Tenant_RefID = securityTicket.TenantID;
dosageQuery.DosageText = item.dosage_text;
var dosage_table = ORM_HEC_Dosage.Query.Search(Connection, Transaction, dosageQuery).SingleOrDefault();
if (dosage_table == null)
{
dosage_table = new ORM_HEC_Dosage();
dosage_table.HEC_DosageID = Guid.NewGuid();
dosage_table.Tenant_RefID = securityTicket.TenantID;
dosage_table.Creation_Timestamp = DateTime.Now;
dosage_table.Modification_Timestamp = DateTime.Now;
dosage_table.DosageText = item.dosage_text;
dosage_table.Save(Connection, Transaction);
}
ORM_HEC_ACT_PerformedAction_MedicationUpdate medicationUpdate = new ORM_HEC_ACT_PerformedAction_MedicationUpdate();
medicationUpdate.HEC_ACT_PerformedAction_MedicationUpdateID = Guid.NewGuid();
medicationUpdate.Tenant_RefID = securityTicket.TenantID;
medicationUpdate.Creation_Timestamp = DateTime.Now;
medicationUpdate.Modification_Timestamp = DateTime.Now;
medicationUpdate.IsSubstance = !item.is_product;
medicationUpdate.IsHealthcareProduct = item.is_product;
medicationUpdate.IntendedApplicationDuration_in_days = item.days_valid;
medicationUpdate.HEC_ACT_PerformedAction_RefID = Parameter.ExaminationID;
medicationUpdate.HEC_Patient_Medication_RefID = Guid.NewGuid();
ORM_HEC_Patient_Medication patient_medications = new ORM_HEC_Patient_Medication();
patient_medications.HEC_Patient_MedicationID = medicationUpdate.HEC_Patient_Medication_RefID;
patient_medications.Patient_RefID = Parameter.PatientID;
patient_medications.Creation_Timestamp = DateTime.Now;
patient_medications.Tenant_RefID = securityTicket.TenantID;
patient_medications.Modification_Timestamp = DateTime.Now;
patient_medications.R_IsActive = true;
patient_medications.R_DateOfAdding = examination.IfPerfomed_DateOfAction;
patient_medications.R_IsHealthcareProduct = item.is_product;
patient_medications.R_IsSubstance = !item.is_product;
patient_medications.R_ActiveUntill = patient_medications.R_DateOfAdding.AddDays(item.days_valid);
if (item.is_product)//medication is a product
{
Guid Hec_ProductID = Guid.Empty;
//check if product exists
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.ProductITL = item.product_itl;
var product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).SingleOrDefault();
//if product does not exist create it
if (product == null)
{
ORM_CMN_PRO_Product cmn_pro_product = new ORM_CMN_PRO_Product();
cmn_pro_product.CMN_PRO_ProductID = Guid.NewGuid();
cmn_pro_product.Tenant_RefID = securityTicket.TenantID;
cmn_pro_product.Creation_Timestamp = DateTime.Now;
cmn_pro_product.Modification_Timestamp = DateTime.Now;
Dict product_name = new Dict("cmn_pro_products");
for (int i = 0; i < DBLanguages.Length; i++)
{
product_name.AddEntry(DBLanguages[i].CMN_LanguageID, item.product_name);
}
cmn_pro_product.Product_Name = product_name;
cmn_pro_product.ProductITL = item.product_itl;
cmn_pro_product.ProducingBusinessParticipant_RefID = Guid.NewGuid(); //manufacturer
cmn_pro_product.PackageInfo_RefID = Guid.NewGuid(); // package info
cmn_pro_product.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant manufacturer = new ORM_CMN_BPT_BusinessParticipant();
manufacturer.CMN_BPT_BusinessParticipantID = cmn_pro_product.ProducingBusinessParticipant_RefID;
manufacturer.DisplayName = item.product_manufacturer;
manufacturer.IsCompany = true;
manufacturer.IsNaturalPerson = false;
manufacturer.Tenant_RefID = securityTicket.TenantID;
manufacturer.Creation_Timestamp = DateTime.Now;
manufacturer.Modification_Timestamp = DateTime.Now;
manufacturer.Save(Connection, Transaction);
ORM_CMN_PRO_PAC_PackageInfo package_info = new ORM_CMN_PRO_PAC_PackageInfo();
package_info.CMN_PRO_PAC_PackageInfoID = cmn_pro_product.PackageInfo_RefID;
package_info.Tenant_RefID = securityTicket.TenantID;
package_info.Creation_Timestamp = DateTime.Now;
package_info.Modification_Timestamp = DateTime.Now;
string amount = String.Empty;
string unit = String.Empty;
foreach (char c in item.product_strength)
{
// Do not use IsDigit as it will include more than the characters 0 through to 9
if (c >= '0' && c <= '9')
{
amount += c;
}
else
{
unit += c;
}
}
package_info.PackageContent_Amount = Int32.Parse(amount);
package_info.PackageContent_DisplayLabel = amount;
var unitQuery = new ORM_CMN_Unit.Query();
unitQuery.IsDeleted = false;
unitQuery.Tenant_RefID = securityTicket.TenantID;
unitQuery.ISOCode = unit;
var cmn_unit = ORM_CMN_Unit.Query.Search(Connection, Transaction, unitQuery).FirstOrDefault();
if (cmn_unit == null)
{
cmn_unit = new ORM_CMN_Unit();
cmn_unit.CMN_UnitID = Guid.NewGuid();
cmn_unit.Tenant_RefID = securityTicket.TenantID;
cmn_unit.Creation_Timestamp = DateTime.Now;
cmn_unit.Modification_Timestamp = DateTime.Now;
cmn_unit.ISOCode = unit;
cmn_unit.Save(Connection, Transaction);
}
package_info.PackageContent_MeasuredInUnit_RefID = cmn_unit.CMN_UnitID;
package_info.Save(Connection, Transaction);
//hec_products
ORM_HEC_Product hec_product = new ORM_HEC_Product();
hec_product.HEC_ProductID = Guid.NewGuid();
hec_product.Ext_PRO_Product_RefID = cmn_pro_product.CMN_PRO_ProductID;
hec_product.Tenant_RefID = securityTicket.TenantID;
hec_product.Creation_Timestamp = DateTime.Now;
hec_product.Modification_Timestamp = DateTime.Now;
Hec_ProductID = hec_product.HEC_ProductID;
var dosage_formQuery = new ORM_HEC_Product_DosageForm.Query();
dosage_formQuery.Tenant_RefID = securityTicket.TenantID;
dosage_formQuery.IsDeleted = false;
dosage_formQuery.GlobalPropertyMatchingID = item.product_form;
var dosage_form = ORM_HEC_Product_DosageForm.Query.Search(Connection, Transaction, dosage_formQuery).SingleOrDefault();
if (dosage_form == null)
{
dosage_form = new ORM_HEC_Product_DosageForm();
dosage_form.HEC_Product_DosageFormID = Guid.NewGuid();
dosage_form.GlobalPropertyMatchingID = item.product_form;
dosage_form.Tenant_RefID = securityTicket.TenantID;
dosage_form.Creation_Timestamp = DateTime.Now;
dosage_form.Modification_Timestamp = DateTime.Now;
Dict form_name = new Dict("hec_product_dosageforms");
for (int i = 0; i < DBLanguages.Length; i++)
{
form_name.AddEntry(DBLanguages[i].CMN_LanguageID, item.product_form);
}
dosage_form.DosageForm_Name = form_name;
dosage_form.Save(Connection, Transaction);
}
hec_product.ProductDosageForm_RefID = dosage_form.HEC_Product_DosageFormID; //dosage form
hec_product.Save(Connection, Transaction);
//product component
ORM_HEC_PRO_Product_Component product_component = new ORM_HEC_PRO_Product_Component();
product_component.HEC_PRO_Product_ComponentID = Guid.NewGuid();
product_component.HEC_PRO_Component_RefID = Guid.NewGuid();//pro_component
product_component.HEC_PRO_Product_RefID = hec_product.HEC_ProductID;
product_component.Tenant_RefID = securityTicket.TenantID;
product_component.Creation_Timestamp = DateTime.Now;
product_component.Modification_Timestamp = DateTime.Now;
product_component.Save(Connection, Transaction);
ORM_HEC_PRO_Component pro_component = new ORM_HEC_PRO_Component();
pro_component.HEC_PRO_ComponentID = product_component.HEC_PRO_Component_RefID;
pro_component.Tenant_RefID = securityTicket.TenantID;
pro_component.Creation_Timestamp = DateTime.Now;
pro_component.Modification_Timestamp = DateTime.Now;
pro_component.Save(Connection, Transaction);
ORM_HEC_PRO_Component_SubstanceIngredient component_SubstanceIngredient = new ORM_HEC_PRO_Component_SubstanceIngredient();
component_SubstanceIngredient.HEC_PRO_Component_SubstanceIngredientID = Guid.NewGuid();
component_SubstanceIngredient.Component_RefID = pro_component.HEC_PRO_ComponentID;
component_SubstanceIngredient.Tenant_RefID = securityTicket.TenantID;
component_SubstanceIngredient.Creation_Timestamp = DateTime.Now;
component_SubstanceIngredient.Modification_Timestamp = DateTime.Now;
var substanceQuery = new ORM_HEC_SUB_Substance.Query();
substanceQuery.IsDeleted = false;
substanceQuery.Tenant_RefID = securityTicket.TenantID;
substanceQuery.HealthcareSubstanceITL = item.substance_itl;
var substance = ORM_HEC_SUB_Substance.Query.Search(Connection, Transaction, substanceQuery).SingleOrDefault();
if (substance == null)
{
substance = new ORM_HEC_SUB_Substance();
substance.HealthcareSubstanceITL = item.substance_itl;
substance.HEC_SUB_SubstanceID = Guid.NewGuid();
substance.GlobalPropertyMatchingID = item.substance_name;
substance.Tenant_RefID = securityTicket.TenantID;
substance.Creation_Timestamp = DateTime.Now;
substance.Modification_Timestamp = DateTime.Now;
substance.Save(Connection, Transaction);
ORM_HEC_SUB_Substance_Name substance_name = new ORM_HEC_SUB_Substance_Name();
substance_name.HEC_SUB_Substance_NameID = Guid.NewGuid();
substance_name.HEC_SUB_Substance_RefID = substance.HEC_SUB_SubstanceID;
Dict substance_name_ = new Dict("hec_sub_substance_names");
for (int i = 0; i < DBLanguages.Length; i++)
{
substance_name_.AddEntry(DBLanguages[i].CMN_LanguageID, item.substance_name);
}
substance_name.SubstanceName_Label = substance_name_;
substance_name.Tenant_RefID = securityTicket.TenantID;
substance_name.Creation_Timestamp = DateTime.Now;
substance_name.Modification_Timestamp = DateTime.Now;
substance_name.Save(Connection, Transaction);
}
component_SubstanceIngredient.Substance_RefID = substance.HEC_SUB_SubstanceID;
component_SubstanceIngredient.Save(Connection, Transaction);
}
else
{
var hec_productQuery = new ORM_HEC_Product.Query();
hec_productQuery.IsDeleted = false;
hec_productQuery.Tenant_RefID = securityTicket.TenantID;
hec_productQuery.Ext_PRO_Product_RefID = product.CMN_PRO_ProductID;
var hec_product = ORM_HEC_Product.Query.Search(Connection, Transaction, hec_productQuery).Single();
Hec_ProductID = hec_product.HEC_ProductID;
}
medicationUpdate.HEC_Product_RefID = Hec_ProductID;
patient_medications.R_HEC_Product_RefID = Hec_ProductID;
patient_medications.R_DosageText = item.dosage_text;
medicationUpdate.DosageText = item.dosage_text;
}
else// medication is a substance
{
medicationUpdate.IfSubstance_Strength = item.substance_strength;
patient_medications.R_IfSubstance_Strength = item.substance_strength;
medicationUpdate.IfSubstance_Unit_RefID = item.substance_unit;
patient_medications.R_IfSubstance_Unit_RefID = item.substance_unit;
patient_medications.R_DosageText = item.dosage_text;
medicationUpdate.DosageText = item.dosage_text;
var substanceQuery = new ORM_HEC_SUB_Substance.Query();
substanceQuery.IsDeleted = false;
substanceQuery.Tenant_RefID = securityTicket.TenantID;
substanceQuery.HealthcareSubstanceITL = item.substance_itl;
var substance = ORM_HEC_SUB_Substance.Query.Search(Connection, Transaction, substanceQuery).SingleOrDefault();
if (substance == null)
{
substance = new ORM_HEC_SUB_Substance();
substance.HealthcareSubstanceITL = item.substance_itl;
substance.HEC_SUB_SubstanceID = Guid.NewGuid();
substance.GlobalPropertyMatchingID = item.substance_name;
substance.Tenant_RefID = securityTicket.TenantID;
substance.Creation_Timestamp = DateTime.Now;
substance.Modification_Timestamp = DateTime.Now;
substance.Save(Connection, Transaction);
ORM_HEC_SUB_Substance_Name substance_name = new ORM_HEC_SUB_Substance_Name();
substance_name.HEC_SUB_Substance_NameID = Guid.NewGuid();
substance_name.HEC_SUB_Substance_RefID = substance.HEC_SUB_SubstanceID;
Dict substance_name_ = new Dict("hec_sub_substance_names");
for (int i = 0; i < DBLanguages.Length; i++)
{
substance_name_.AddEntry(DBLanguages[i].CMN_LanguageID, item.substance_name);
}
substance_name.SubstanceName_Label = substance_name_;
substance_name.Tenant_RefID = securityTicket.TenantID;
substance_name.Creation_Timestamp = DateTime.Now;
substance_name.Modification_Timestamp = DateTime.Now;
substance_name.Save(Connection, Transaction);
}
medicationUpdate.IfSubstance_Substance_RefiD = substance.HEC_SUB_SubstanceID;
patient_medications.R_IfSubstance_Substance_RefiD = substance.HEC_SUB_SubstanceID;
}
patient_medications.Save(Connection, Transaction);
medicationUpdate.Save(Connection, Transaction);
returnValue.Result = true;
}
#endregion
#region Delete
foreach (var item in Parameter.deleted_medications)
{
var medicationUpdateQuery = new ORM_HEC_ACT_PerformedAction_MedicationUpdate.Query();
medicationUpdateQuery.IsDeleted = false;
medicationUpdateQuery.IsMedicationDeactivated = false;
medicationUpdateQuery.Tenant_RefID = securityTicket.TenantID;
medicationUpdateQuery.HEC_ACT_PerformedAction_MedicationUpdateID = item.performedAction_medicationUpdate_id;
var medicationUpdate = ORM_HEC_ACT_PerformedAction_MedicationUpdate.Query.Search(Connection, Transaction, medicationUpdateQuery).Single();
medicationUpdate.IsMedicationDeactivated = true;
medicationUpdate.Save(Connection, Transaction);
}
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ME_SP_1054 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
returnValue.Result = new Guid();
if (!Parameter.IsDeleted)
{
var DBLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result;
Guid Hec_ProductID = Guid.Empty;
//check if product exists
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.CMN_PRO_ProductID = Guid.Parse(Parameter.product_itl);
var product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).SingleOrDefault();
//save
if (product == null)
{
ORM_CMN_PRO_Product cmn_pro_product = new ORM_CMN_PRO_Product();
cmn_pro_product.CMN_PRO_ProductID = Guid.NewGuid();
cmn_pro_product.Tenant_RefID = securityTicket.TenantID;
cmn_pro_product.Creation_Timestamp = DateTime.Now;
cmn_pro_product.Modification_Timestamp = DateTime.Now;
Dict product_name = new Dict("cmn_pro_products");
for (int i = 0; i < DBLanguages.Length; i++)
{
product_name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.product_name);
}
cmn_pro_product.Product_Name = product_name;
cmn_pro_product.ProductITL = Guid.NewGuid().ToString();
cmn_pro_product.ProducingBusinessParticipant_RefID = Guid.NewGuid(); //manufacturer
cmn_pro_product.PackageInfo_RefID = Guid.NewGuid(); // package info
cmn_pro_product.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant manufacturer = new ORM_CMN_BPT_BusinessParticipant();
var manufacturerQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
manufacturerQuery.Tenant_RefID = securityTicket.TenantID;
manufacturerQuery.IsDeleted = false;
manufacturerQuery.CMN_BPT_BusinessParticipantID = Guid.Parse(Parameter.product_manufacturer_id);
if (Parameter.product_manufacturer_id == Guid.Empty.ToString())
{
manufacturer.CMN_BPT_BusinessParticipantID = cmn_pro_product.ProducingBusinessParticipant_RefID;
manufacturer.DisplayName = Parameter.product_manufacturer;
manufacturer.IsCompany = true;
manufacturer.IsNaturalPerson = false;
manufacturer.Tenant_RefID = securityTicket.TenantID;
manufacturer.Creation_Timestamp = DateTime.Now;
manufacturer.Modification_Timestamp = DateTime.Now;
manufacturer.Save(Connection, Transaction);
}
else
{
manufacturer = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, manufacturerQuery).Single();
}
ORM_CMN_PRO_PAC_PackageInfo package_info = new ORM_CMN_PRO_PAC_PackageInfo();
package_info.CMN_PRO_PAC_PackageInfoID = cmn_pro_product.PackageInfo_RefID;
package_info.Tenant_RefID = securityTicket.TenantID;
package_info.Creation_Timestamp = DateTime.Now;
package_info.Modification_Timestamp = DateTime.Now;
string amount = String.Empty;
string unit = String.Empty;
foreach (char c in Parameter.product_strength)
{
// Do not use IsDigit as it will include more than the characters 0 through to 9
if (c >= '0' && c <= '9')
{
amount += c;
}
else
{
unit += c;
}
}
package_info.PackageContent_Amount = Int32.Parse(amount);
package_info.PackageContent_DisplayLabel = amount;
var unitQuery = new ORM_CMN_Unit.Query();
unitQuery.IsDeleted = false;
unitQuery.Tenant_RefID = securityTicket.TenantID;
unitQuery.ISOCode = unit;
var cmn_unit = ORM_CMN_Unit.Query.Search(Connection, Transaction, unitQuery).FirstOrDefault();
if (cmn_unit == null)
{
cmn_unit = new ORM_CMN_Unit();
cmn_unit.CMN_UnitID = Guid.NewGuid();
cmn_unit.Tenant_RefID = securityTicket.TenantID;
cmn_unit.Creation_Timestamp = DateTime.Now;
cmn_unit.Modification_Timestamp = DateTime.Now;
cmn_unit.ISOCode = unit;
cmn_unit.Save(Connection, Transaction);
}
package_info.PackageContent_MeasuredInUnit_RefID = cmn_unit.CMN_UnitID;
package_info.Save(Connection, Transaction);
//hec_products
ORM_HEC_Product hec_product = new ORM_HEC_Product();
hec_product.HEC_ProductID = Guid.NewGuid();
hec_product.Ext_PRO_Product_RefID = cmn_pro_product.CMN_PRO_ProductID;
hec_product.Tenant_RefID = securityTicket.TenantID;
hec_product.Creation_Timestamp = DateTime.Now;
hec_product.Modification_Timestamp = DateTime.Now;
Hec_ProductID = hec_product.HEC_ProductID;
var dosage_formQuery = new ORM_HEC_Product_DosageForm.Query();
dosage_formQuery.Tenant_RefID = securityTicket.TenantID;
dosage_formQuery.IsDeleted = false;
dosage_formQuery.GlobalPropertyMatchingID = Parameter.product_form;
var dosage_form = ORM_HEC_Product_DosageForm.Query.Search(Connection, Transaction, dosage_formQuery).SingleOrDefault();
if (dosage_form == null)
{
dosage_form = new ORM_HEC_Product_DosageForm();
dosage_form.HEC_Product_DosageFormID = Guid.NewGuid();
dosage_form.GlobalPropertyMatchingID = Parameter.product_form;
dosage_form.Tenant_RefID = securityTicket.TenantID;
dosage_form.Creation_Timestamp = DateTime.Now;
dosage_form.Modification_Timestamp = DateTime.Now;
Dict form_name = new Dict("hec_product_dosageforms");
for (int i = 0; i < DBLanguages.Length; i++)
{
form_name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.product_form);
}
dosage_form.DosageForm_Name = form_name;
dosage_form.Save(Connection, Transaction);
}
hec_product.ProductDosageForm_RefID = dosage_form.HEC_Product_DosageFormID; //dosage form
hec_product.Save(Connection, Transaction);
//product component
ORM_HEC_PRO_Product_Component product_component = new ORM_HEC_PRO_Product_Component();
product_component.HEC_PRO_Product_ComponentID = Guid.NewGuid();
product_component.HEC_PRO_Component_RefID = Guid.NewGuid();//pro_component
product_component.HEC_PRO_Product_RefID = hec_product.HEC_ProductID;
product_component.Tenant_RefID = securityTicket.TenantID;
product_component.Creation_Timestamp = DateTime.Now;
product_component.Modification_Timestamp = DateTime.Now;
product_component.Save(Connection, Transaction);
ORM_HEC_PRO_Component pro_component = new ORM_HEC_PRO_Component();
pro_component.HEC_PRO_ComponentID = product_component.HEC_PRO_Component_RefID;
pro_component.Tenant_RefID = securityTicket.TenantID;
pro_component.Creation_Timestamp = DateTime.Now;
pro_component.Modification_Timestamp = DateTime.Now;
pro_component.Save(Connection, Transaction);
ORM_HEC_PRO_Component_SubstanceIngredient component_SubstanceIngredient = new ORM_HEC_PRO_Component_SubstanceIngredient();
component_SubstanceIngredient.HEC_PRO_Component_SubstanceIngredientID = Guid.NewGuid();
component_SubstanceIngredient.Component_RefID = pro_component.HEC_PRO_ComponentID;
component_SubstanceIngredient.Tenant_RefID = securityTicket.TenantID;
component_SubstanceIngredient.Creation_Timestamp = DateTime.Now;
component_SubstanceIngredient.Modification_Timestamp = DateTime.Now;
var substanceQuery = new ORM_HEC_SUB_Substance.Query();
substanceQuery.IsDeleted = false;
substanceQuery.Tenant_RefID = securityTicket.TenantID;
substanceQuery.HEC_SUB_SubstanceID = Parameter.substance_id;
var substance = ORM_HEC_SUB_Substance.Query.Search(Connection, Transaction, substanceQuery).SingleOrDefault();
component_SubstanceIngredient.Substance_RefID = substance.HEC_SUB_SubstanceID;
component_SubstanceIngredient.Save(Connection, Transaction);
Parameter.IsSaved = true;
Parameter.product_itl = cmn_pro_product.CMN_PRO_ProductID.ToString();
returnValue.Result = cmn_pro_product.CMN_PRO_ProductID;
}
else
{
//edit
Parameter.IsEdited = true;
Dict product_name = new Dict("cmn_pro_products");
for (int i = 0; i < DBLanguages.Length; i++)
{
product_name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.product_name);
}
product.Product_Name = product_name;
var manufacturerQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
manufacturerQuery.Tenant_RefID = securityTicket.TenantID;
manufacturerQuery.IsDeleted = false;
manufacturerQuery.CMN_BPT_BusinessParticipantID = Guid.Parse(Parameter.product_manufacturer_id);
ORM_CMN_BPT_BusinessParticipant manufacturer = new ORM_CMN_BPT_BusinessParticipant();
if (Parameter.product_manufacturer_id == Guid.Empty.ToString())
{
manufacturer.CMN_BPT_BusinessParticipantID = new Guid();
manufacturer.DisplayName = Parameter.product_manufacturer;
manufacturer.IsCompany = true;
manufacturer.IsNaturalPerson = false;
manufacturer.Tenant_RefID = securityTicket.TenantID;
manufacturer.Creation_Timestamp = DateTime.Now;
manufacturer.Modification_Timestamp = DateTime.Now;
manufacturer.Save(Connection, Transaction);
}
else
{
manufacturer = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, manufacturerQuery).Single();
}
product.ProducingBusinessParticipant_RefID = manufacturer.CMN_BPT_BusinessParticipantID;
var package_info = ORM_CMN_PRO_PAC_PackageInfo.Query.Search(Connection, Transaction, new ORM_CMN_PRO_PAC_PackageInfo.Query()
{
CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
string amount = String.Empty;
string unit = String.Empty;
foreach (char c in Parameter.product_strength)
{
// Do not use IsDigit as it will include more than the characters 0 through to 9
if (c >= '0' && c <= '9')
{
amount += c;
}
else
{
unit += c;
}
}
package_info.PackageContent_Amount = Int32.Parse(amount);
package_info.PackageContent_DisplayLabel = amount;
package_info.Save(Connection, Transaction);
var unitQuery = new ORM_CMN_Unit.Query();
unitQuery.IsDeleted = false;
unitQuery.Tenant_RefID = securityTicket.TenantID;
unitQuery.ISOCode = unit;
var cmn_unit = ORM_CMN_Unit.Query.Search(Connection, Transaction, unitQuery).FirstOrDefault();
if (cmn_unit == null)
{
cmn_unit = new ORM_CMN_Unit();
cmn_unit.CMN_UnitID = Guid.NewGuid();
cmn_unit.Tenant_RefID = securityTicket.TenantID;
cmn_unit.Creation_Timestamp = DateTime.Now;
cmn_unit.Modification_Timestamp = DateTime.Now;
cmn_unit.ISOCode = unit;
cmn_unit.Save(Connection, Transaction);
}
package_info.PackageContent_MeasuredInUnit_RefID = cmn_unit.CMN_UnitID;
package_info.Save(Connection, Transaction);
var dosage_formQuery = new ORM_HEC_Product_DosageForm.Query();
dosage_formQuery.Tenant_RefID = securityTicket.TenantID;
dosage_formQuery.IsDeleted = false;
dosage_formQuery.GlobalPropertyMatchingID = Parameter.product_form;
var dosage_form = ORM_HEC_Product_DosageForm.Query.Search(Connection, Transaction, dosage_formQuery).SingleOrDefault();
if (dosage_form == null)
{
dosage_form = new ORM_HEC_Product_DosageForm();
dosage_form.HEC_Product_DosageFormID = Guid.NewGuid();
dosage_form.GlobalPropertyMatchingID = Parameter.product_form;
dosage_form.Tenant_RefID = securityTicket.TenantID;
dosage_form.Creation_Timestamp = DateTime.Now;
dosage_form.Modification_Timestamp = DateTime.Now;
Dict form_name = new Dict("hec_product_dosageforms");
for (int i = 0; i < DBLanguages.Length; i++)
{
form_name.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.product_form);
}
dosage_form.DosageForm_Name = form_name;
dosage_form.Save(Connection, Transaction);
}
ORM_HEC_Product hec_product = ORM_HEC_Product.Query.Search(Connection, Transaction, new ORM_HEC_Product.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Ext_PRO_Product_RefID = product.CMN_PRO_ProductID
}).Single();
hec_product.ProductDosageForm_RefID = dosage_form.HEC_Product_DosageFormID;
hec_product.Save(Connection, Transaction);
ORM_HEC_PRO_Product_Component product_component = ORM_HEC_PRO_Product_Component.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Product_Component.Query()
{
HEC_PRO_Product_RefID = hec_product.HEC_ProductID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_HEC_PRO_Component pro_component = ORM_HEC_PRO_Component.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Component.Query()
{
HEC_PRO_ComponentID = product_component.HEC_PRO_Component_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_HEC_PRO_Component_SubstanceIngredient component_SubstanceIngredient = ORM_HEC_PRO_Component_SubstanceIngredient.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Component_SubstanceIngredient.Query()
{
Component_RefID = pro_component.HEC_PRO_ComponentID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
var substanceQuery = new ORM_HEC_SUB_Substance.Query();
substanceQuery.IsDeleted = false;
substanceQuery.Tenant_RefID = securityTicket.TenantID;
substanceQuery.HEC_SUB_SubstanceID = Parameter.substance_id;
var substance = ORM_HEC_SUB_Substance.Query.Search(Connection, Transaction, substanceQuery).SingleOrDefault();
component_SubstanceIngredient.Substance_RefID = substance.HEC_SUB_SubstanceID;
component_SubstanceIngredient.Save(Connection, Transaction);
}
}
else
{
//delete
ORM_CMN_PRO_Product product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product.Query()
{
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ProductID = Guid.Parse(Parameter.product_itl),
IsDeleted = false
}).Single();
ORM_HEC_Product hec_product = ORM_HEC_Product.Query.Search(Connection, Transaction, new ORM_HEC_Product.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Ext_PRO_Product_RefID = product.CMN_PRO_ProductID
}).Single();
ORM_CMN_PRO_PAC_PackageInfo package_info = ORM_CMN_PRO_PAC_PackageInfo.Query.Search(Connection, Transaction, new ORM_CMN_PRO_PAC_PackageInfo.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID
}).Single();
ORM_HEC_PRO_Product_Component product_component = ORM_HEC_PRO_Product_Component.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Product_Component.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
HEC_PRO_Product_RefID = hec_product.HEC_ProductID
}).Single();
ORM_HEC_PRO_Component pro_component = ORM_HEC_PRO_Component.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Component.Query()
{
HEC_PRO_ComponentID = product_component.HEC_PRO_Component_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ORM_HEC_PRO_Component_SubstanceIngredient component_SubstanceIngredient = ORM_HEC_PRO_Component_SubstanceIngredient.Query.Search(Connection, Transaction, new ORM_HEC_PRO_Component_SubstanceIngredient.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Component_RefID = pro_component.HEC_PRO_ComponentID
}).Single();
component_SubstanceIngredient.IsDeleted = true;
component_SubstanceIngredient.Save(Connection, Transaction);
pro_component.IsDeleted = true;
pro_component.Save(Connection, Transaction);
product_component.IsDeleted = true;
product_component.Save(Connection, Transaction);
package_info.IsDeleted = true;
package_info.Save(Connection, Transaction);
product.IsDeleted = true;
product.Save(Connection, Transaction);
returnValue.Result = product.CMN_PRO_ProductID;
}
return(returnValue);
#endregion UserCode
}
