protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_SPfAID_1347 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
var price = new ORM_CMN_SLS_Price();
//edit
if (Parameter.CMN_SLS_PriceID != Guid.Empty)
{
var priceLoaded = price.Load(Connection, Transaction, Parameter.CMN_SLS_PriceID);
if (priceLoaded.Status != FR_Status.Success)
{
return(new FR_Guid("Not exist", FR_Status.Error_Internal));
}
}
//fill price properties
price.PricelistRelease_RefID = Parameter.PricelistRelease_RefID;
price.CMN_PRO_Product_RefID = Parameter.CMN_PRO_Product_RefID;
price.PriceAmount = Parameter.PriceAmount;
returnValue = new FR_Guid(price.Save(Connection, Transaction), price.CMN_SLS_PriceID);
return(returnValue);
#endregion UserCode
}
protected static FR_L6WS_GSCDfSCID_1458 Execute(DbConnection Connection, DbTransaction Transaction, P_L6WS_GSCDfSCID_1458 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6WS_GSCDfSCID_1458();
//Put your code here
if (Parameter.ShoppingCartID == Guid.Empty)
{
return(null);
}
returnValue.Result = new L6WS_GSCDfSCID_1458();
#region ShoppingCart
returnValue.Result.ShoppingCart = cls_Get_ShoppingCart_for_ShoppingCartID.Invoke(Connection, Transaction, new P_L6WS_GSCfSCID_1448()
{
ShoppingCartID = Parameter.ShoppingCartID
}, securityTicket).Result;
if (returnValue.Result.ShoppingCart == null)
{
return(null);
}
#endregion
#region ShoppingCart_Notes
returnValue.Result.ShoppingCart_Notes = cls_Get_ShoppingCart_Notes_for_ShoppingCartID.Invoke(Connection, Transaction, new P_L5AWSAR_GSCNfSC_1454()
{
ShoppingCartID = Parameter.ShoppingCartID
}, securityTicket).Result.OrderBy(i => i.UpdatedOn).ToArray();
#endregion
#region Articles
ORM_ORD_PRC_ShoppingCart_Product.Query shoppingCartProductsQuery = new ORM_ORD_PRC_ShoppingCart_Product.Query();
shoppingCartProductsQuery.ORD_PRC_ShoppingCart_RefID = returnValue.Result.ShoppingCart.ORD_PRC_ShoppingCartID;
shoppingCartProductsQuery.IsDeleted = false;
shoppingCartProductsQuery.IsCanceled = false;
shoppingCartProductsQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_ORD_PRC_ShoppingCart_Product> productList = ORM_ORD_PRC_ShoppingCart_Product.Query.Search(Connection, Transaction, shoppingCartProductsQuery);
List <Guid> articleIds = new List <Guid>();
if (productList != null && productList.Count > 0)
{
articleIds.AddRange(productList.Select(i => i.CMN_PRO_Product_RefID));
}
List <L3AR_GAfAL_0942> articleInfos = new List <L3AR_GAfAL_0942>();
if (articleIds.Count > 0)
{
articleInfos = cls_Get_Articles_for_ArticleList.Invoke(Connection, Transaction,
new P_L3AR_GAfAL_0942()
{
ProductID_List = articleIds.ToArray()
}, securityTicket).Result.ToList();
}
List <L6WS_GSCDfSCID_1458_Product> products = new List <L6WS_GSCDfSCID_1458_Product>();
L6WS_GSCDfSCID_1458_Product product;
L3AR_GAfAL_0942 articleInfo;
double taxRate = 0;
#region ORM and Querie objects
ORM_CMN_PRO_Product orm_product;
ORM_CMN_SLS_Price.Query priceQuery;
ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query taxAssignmentQuery;
ORM_ACC_TAX_Tax orm_tax;
#endregion
foreach (var productItem in productList)
{
#region check procurement order date and number
if (returnValue.Result.OrderDate == null || returnValue.Result.OrderDate.Ticks == 0)
{
ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query shoppingCartOrderPositionQuery = new ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query();
shoppingCartOrderPositionQuery.IsDeleted = false;
shoppingCartOrderPositionQuery.Tenant_RefID = securityTicket.TenantID;
shoppingCartOrderPositionQuery.ORD_PRC_ShoppingCart_Product_RefID = productItem.ORD_PRC_ShoppingCart_ProductID;
List <ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition> shoppingCartOrderPositionList = ORM_ORD_PRC_ShoppingCart_2_ProcurementOrderPosition.Query.Search(Connection, Transaction, shoppingCartOrderPositionQuery);
foreach (var shoppingCartOrderPosition in shoppingCartOrderPositionList)
{
ORM_ORD_PRC_ProcurementOrder_Position procurementOrder_Position = new ORM_ORD_PRC_ProcurementOrder_Position();
var procurementOrder_PositionResult = procurementOrder_Position.Load(Connection, Transaction, shoppingCartOrderPosition.ORD_PRC_ProcurementOrder_Position_RefID);
if (procurementOrder_PositionResult.Status != FR_Status.Success || procurementOrder_Position.ORD_PRC_ProcurementOrder_PositionID == Guid.Empty)
{
continue;
}
ORM_ORD_PRC_ProcurementOrder_Header procurementOrder_Header = new ORM_ORD_PRC_ProcurementOrder_Header();
var procurementOrder_HeaderResult = procurementOrder_Header.Load(Connection, Transaction, procurementOrder_Position.ProcurementOrder_Header_RefID);
if (procurementOrder_HeaderResult.Status != FR_Status.Success || procurementOrder_Header.ORD_PRC_ProcurementOrder_HeaderID == Guid.Empty)
{
continue;
}
returnValue.Result.OrderDate = procurementOrder_Header.ProcurementOrder_Date;
returnValue.Result.OrderNumber = procurementOrder_Header.ProcurementOrder_Number;
break;
}
}
#endregion
#region get product
orm_product = new ORM_CMN_PRO_Product();
var productResult = orm_product.Load(Connection, Transaction, productItem.CMN_PRO_Product_RefID);
if (productResult.Status != FR_Status.Success || orm_product.CMN_PRO_ProductID == Guid.Empty)
{
continue;
}
#endregion
#region get price
ORM_CMN_PRO_SubscribedCatalog.Query catalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
catalogQuery.Tenant_RefID = securityTicket.TenantID;
catalogQuery.IsDeleted = false;
List <ORM_CMN_PRO_SubscribedCatalog> catalogList = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, catalogQuery);
priceQuery = new ORM_CMN_SLS_Price.Query();
priceQuery.CMN_PRO_Product_RefID = orm_product.CMN_PRO_ProductID;
priceQuery.Tenant_RefID = securityTicket.TenantID;
priceQuery.IsDeleted = false;
List <ORM_CMN_SLS_Price> prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, priceQuery);
ORM_CMN_SLS_Price price = prices.Where(i => catalogList.Select(j => j.SubscribedCatalog_PricelistRelease_RefID).Contains(i.PricelistRelease_RefID)).FirstOrDefault();
#endregion
#region get taxes
taxRate = 0;
taxAssignmentQuery = new ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query();
taxAssignmentQuery.Product_RefID = orm_product.CMN_PRO_ProductID;
taxAssignmentQuery.Tenant_RefID = securityTicket.TenantID;
taxAssignmentQuery.IsDeleted = false;
List <ORM_CMN_PRO_Product_SalesTaxAssignmnet> taxAssignmentList = ORM_CMN_PRO_Product_SalesTaxAssignmnet.Query.Search(Connection, Transaction, taxAssignmentQuery);
foreach (var taxAssignment in taxAssignmentList)
{
orm_tax = new ORM_ACC_TAX_Tax();
var taxResult = orm_tax.Load(Connection, Transaction, taxAssignment.ApplicableSalesTax_RefID);
if (taxResult.Status == FR_Status.Success && orm_tax.ACC_TAX_TaxeID != Guid.Empty)
{
taxRate += orm_tax.TaxRate;
}
}
#endregion
#region set product item
product = new L6WS_GSCDfSCID_1458_Product();
product.CMN_PRO_Product_RefID = orm_product.CMN_PRO_ProductID;
product.PriceAmount = price == null ? 0 : (price.PriceAmount == null ? 0 : Double.Parse(price.PriceAmount.ToString()));
product.TaxRate = taxRate;
product.Quantity = productItem.Quantity.ToString();
product.IsProductCanceled = productItem.IsCanceled;
if (!String.IsNullOrEmpty(productItem.Comment))
{
string[] comments = productItem.Comment.Split('@');
if (comments.Length == 2)
{
product.ProductComment = comments[1];
}
}
product.IsProductReplacementAllowed = productItem.IsProductReplacementAllowed;
articleInfo = articleInfos.FirstOrDefault(i => i.CMN_PRO_ProductID == orm_product.CMN_PRO_ProductID);
if (articleInfo != null)
{
product.Product_Name = articleInfo.Product_Name;
product.Product_Number = articleInfo.Product_Number;
product.UnitAmount = articleInfo.UnitAmount.ToString();
product.UnitIsoCode = articleInfo.UnitIsoCode;
product.DossageFormName = articleInfo.DossageFormName;
}
#endregion
products.Add(product);
}
returnValue.Result.Products = products.ToArray();
#endregion
#region Person info
// current user
ORM_CMN_PER_PersonInfo_2_Account.Query accountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
accountQuery.USR_Account_RefID = securityTicket.AccountID;
accountQuery.Tenant_RefID = securityTicket.TenantID;
accountQuery.IsDeleted = false;
ORM_CMN_PER_PersonInfo_2_Account account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, accountQuery).FirstOrDefault();
if (account != null)
{
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
var personInfoResult = personInfo.Load(Connection, Transaction, account.CMN_PER_PersonInfo_RefID);
if (personInfoResult.Status == FR_Status.Success && personInfo.CMN_PER_PersonInfoID != Guid.Empty)
{
returnValue.Result.CurrentUser = personInfo.FirstName + " " + personInfo.LastName;
}
}
#region Approved by user
ORM_ORD_PRC_ShoppingCart_Status.Query stusesQuery = new ORM_ORD_PRC_ShoppingCart_Status.Query();
stusesQuery.Tenant_RefID = securityTicket.TenantID;
stusesQuery.IsDeleted = false;
List <ORM_ORD_PRC_ShoppingCart_Status> statuses = ORM_ORD_PRC_ShoppingCart_Status.Query.Search(Connection, Transaction, stusesQuery);
ORM_ORD_PRC_ShoppingCart_Status approvedStatus = statuses.FirstOrDefault(i => i.GlobalPropertyMatchingID.Contains("approved"));
if (approvedStatus != null)
{
ORM_ORD_PRC_ShoppingCartStatus_History.Query statusHistoryQuery = new ORM_ORD_PRC_ShoppingCartStatus_History.Query();
statusHistoryQuery.Tenant_RefID = securityTicket.TenantID;
statusHistoryQuery.IsDeleted = false;
statusHistoryQuery.ORD_PRC_ShoppingCart_RefID = returnValue.Result.ShoppingCart.ORD_PRC_ShoppingCartID;
statusHistoryQuery.ORD_PRC_ShoppingCart_Status_RefID = approvedStatus.ORD_PRC_ShoppingCart_StatusID;
ORM_ORD_PRC_ShoppingCartStatus_History statusHistory = ORM_ORD_PRC_ShoppingCartStatus_History.Query.Search(Connection, Transaction, statusHistoryQuery).FirstOrDefault();
if (statusHistory != null)
{
accountQuery = new ORM_CMN_PER_PersonInfo_2_Account.Query();
accountQuery.USR_Account_RefID = statusHistory.PerformedBy_Account_RefID;
accountQuery.Tenant_RefID = securityTicket.TenantID;
accountQuery.IsDeleted = false;
account = ORM_CMN_PER_PersonInfo_2_Account.Query.Search(Connection, Transaction, accountQuery).FirstOrDefault();
if (account != null)
{
ORM_CMN_PER_PersonInfo personInfo = new ORM_CMN_PER_PersonInfo();
var personInfoResult = personInfo.Load(Connection, Transaction, account.CMN_PER_PersonInfo_RefID);
if (personInfoResult.Status == FR_Status.Success && personInfo.CMN_PER_PersonInfoID != Guid.Empty)
{
returnValue.Result.ApprovedByUser = personInfo.FirstName + " " + personInfo.LastName;
returnValue.Result.DateOfApproval = statusHistory.Creation_Timestamp;
}
}
}
}
#endregion
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_L3PR_IoUPfSC_1326_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3PR_IoUPfSC_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3PR_IoUPfSC_1326_Array();
//Put your code here
var importedProducts = new List <L3PR_IoUPfSC_1326>();
#region ImportOrUpdate Product's BaseData
P_L3PR_IoUPBD_1614 param = new P_L3PR_IoUPBD_1614();
param.Products = Parameter.Products.Select(i => i.Product).ToArray();
var importedProductsBaseData = cls_ImportOrUpdate_Products_BaseData.Invoke(Connection, Transaction, param, securityTicket).Result;
#endregion
//TODO: for each product saved, create or update product_2_productGroup
foreach (var importedProductBaseData in importedProductsBaseData)
{
var currentParameter = Parameter.Products.SingleOrDefault(i => i.Product.ProductITL == importedProductBaseData.ProductITL);
var product = new ORM_CMN_PRO_Product();
product.Load(Connection, Transaction, importedProductBaseData.ProductID);
if (!importedProductBaseData.IsAlreadyExisted)
{
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
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 = Parameter.ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
}
else
{
#region Update Product_2_ProductGroup
var isAlreadyInGroup = ORM_CMN_PRO_Product_2_ProductGroup.Query.Exists(Connection, Transaction, new ORM_CMN_PRO_Product_2_ProductGroup.Query()
{
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID,
CMN_PRO_ProductGroup_RefID = Parameter.ProductGroupID,
Tenant_RefID = securityTicket.TenantID
});
if (!isAlreadyInGroup)
{
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 = Parameter.ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
}
#endregion
}
#region Default Price
var price = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, new ORM_CMN_SLS_Price.Query()
{
PricelistRelease_RefID = Parameter.PriceListReleaseID,
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
CMN_Currency_RefID = Parameter.CatalogCurrencyID,
IsDeleted = false
}).SingleOrDefault();
if (price == null)
{
price = new ORM_CMN_SLS_Price();
price.CMN_SLS_PriceID = Guid.NewGuid();
price.PricelistRelease_RefID = Parameter.PriceListReleaseID;
price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
price.CMN_Currency_RefID = Parameter.CatalogCurrencyID;
price.Tenant_RefID = securityTicket.TenantID;
price.Creation_Timestamp = DateTime.Now;
}
price.PriceAmount = currentParameter.Price;
price.Save(Connection, Transaction);
#endregion
importedProducts.Add(new L3PR_IoUPfSC_1326()
{
ProductID = product.CMN_PRO_ProductID,
ProductITL = product.ProductITL
});
}
returnValue.Result = importedProducts.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PL_SPfPRaPV_0920 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
foreach (var item in Parameter.Data)
{
foreach (var currentPrice in item.Prices)
{
var price = new ORM_CMN_SLS_Price();
price.Tenant_RefID = securityTicket.TenantID;
if (currentPrice.PriceAmount == 0 && currentPrice.PriceID != Guid.Empty)
{
price.Load(Connection, Transaction, currentPrice.PriceID);
price.PriceAmount = 0;
price.IsDeleted = true;
price.Save(Connection, Transaction);
}
else if (currentPrice.PriceAmount != 0)
{
if (currentPrice.PriceID != Guid.Empty)
{
price.Load(Connection, Transaction, currentPrice.PriceID);
price.PriceAmount = currentPrice.PriceAmount;
price.Save(Connection, Transaction);
}
else
{
var pricequery = new ORM_CMN_SLS_Price.Query();
pricequery.CMN_Currency_RefID = currentPrice.CurrencyID;
pricequery.CMN_PRO_Product_Variant_RefID = item.ProductVariantID;
pricequery.PricelistRelease_RefID = item.PricelistReleaseID;
var prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, pricequery);
if (prices != null && prices.Count > 0)
{
price = prices.FirstOrDefault();
price.IsDeleted = false;
price.PriceAmount = currentPrice.PriceAmount;
price.Save(Connection, Transaction);
}
else
{
var productVariant = new CL1_CMN_PRO.ORM_CMN_PRO_Product_Variant();
productVariant.Load(Connection, Transaction, item.ProductVariantID);
price.CMN_SLS_PriceID = Guid.NewGuid();
price.CMN_Currency_RefID = currentPrice.CurrencyID;
price.CMN_PRO_Product_Variant_RefID = item.ProductVariantID;
price.CMN_PRO_Product_RefID = productVariant.CMN_PRO_Product_RefID;
price.PricelistRelease_RefID = item.PricelistReleaseID;
price.PriceAmount = currentPrice.PriceAmount;
price.Save(Connection, Transaction);
}
}
}
returnValue.Result = price.CMN_SLS_PriceID;
}
}
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_L3AR_IoUPfSC_1325_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3AR_IoUPfSC_1325 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3AR_IoUPfSC_1325_Array();
var importedProducts = new List <L3AR_IoUPfSC_1325>();
#region ABDA catalog
var catalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
catalogQuery.Tenant_RefID = securityTicket.TenantID;
catalogQuery.IsDeleted = false;
catalogQuery.CatalogCodeITL = EnumUtils.GetEnumDescription(EPublicCatalogs.ABDA);
var abdaCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, catalogQuery).SingleOrDefault();
#endregion
#region ImportOrUpdate Product's BaseData
var param = new P_L3AR_IoUPBD_1631();
var products = Parameter.Products.Select(item => new P_L3AR_IoUPBD_1631a()
{
ProductITL = item.ProductITL,
Product_Name = item.Product_Name,
Product_Description = item.Product_Description,
Product_Number = item.Product_Number,
Dosage = item.Dosage,
Amount = item.Amount,
MeasuredInUnit_ISO_um_ums = item.MeasuredInUnit_ISO_um_ums,
VAT = Double.Parse(item.VAT),
Producer = item.Producer,
DistributionStatus = item.DistributionStatus,
DefaultExpirationPeriod_in_sec = item.DefaultExpirationPeriod_in_sec,
DefaultStorageTemperature_min_in_kelvin = item.DefaultStorageTemperature_min_in_kelvin,
DefaultStorageTemperature_max_in_kelvin = item.DefaultStorageTemperature_max_in_kelvin,
IsStorage_CoolingRequired = item.IsStorage_CoolingRequired,
IsProduct_AddictiveDrug = item.IsProduct_AddictiveDrug,
ActiveComponents = item.ActiveComponents,
IsPharmacyOnlyDistribution = item.IsPharmacyOnlyDistribution
}).ToArray();
param.Products = products;
var importedProductsBaseData = cls_ImportOrUpdate_Products_BaseData.Invoke(Connection, Transaction, param, securityTicket).Result;
#endregion
foreach (var importedProductBaseData in importedProductsBaseData)
{
var currentParameter = Parameter.Products.SingleOrDefault(i => i.ProductITL == importedProductBaseData.ProductITL);
var product = new ORM_CMN_PRO_Product();
product.Load(Connection, Transaction, importedProductBaseData.ProductID);
if (!importedProductBaseData.IsAlreadyExisted)
{
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
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 = Parameter.ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
}
else
{
#region Update Product_2_ProductGroup
var groupsParam = new P_CL2_MP_GAPGfP_1735();
groupsParam.ProductID = product.CMN_PRO_ProductID;
var productGroups = cls_Get_All_ProductGroups_for_ProductID.Invoke(Connection, Transaction, groupsParam, securityTicket).Result;
var abdaGroup = productGroups.Where(i => i.GlobalPropertyMatchingID == EnumUtils.GetEnumDescription(EProductGroup.ABDA)).FirstOrDefault();
var houselistGroup = productGroups.Where(i => i.GlobalPropertyMatchingID == EnumUtils.GetEnumDescription(EProductGroup.HauseList)).FirstOrDefault();
if (abdaGroup == default(CL2_MP_GAPGfP_1735))
{
//it's not in abda
if (houselistGroup == default(CL2_MP_GAPGfP_1735))
{
//it's not in abda and it's not in houselist
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
}
else
{
//it's not in abda but it's in houselist
//check if new import isn't from abda
//it could be new house list
if (abdaCatalog == null || abdaCatalog.CMN_PRO_SubscribedCatalogID != Parameter.SubscribedCatalogID)
{
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
}
}
}
else
{
//it's in abda
if (houselistGroup == default(CL2_MP_GAPGfP_1735))
{
//it's in abda but it's not in houselist
//it could be house list or just update abda
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
}
else
{
//it's in abda and it's in houselist
//check if new import isn't from abda
//it could be only house list
if (abdaCatalog.CMN_PRO_SubscribedCatalogID != Parameter.SubscribedCatalogID)
{
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID;
product.IsImportedFromExternalCatalog = true;
product.Save(Connection, Transaction);
}
}
}
var isAlreadyInGroup = ORM_CMN_PRO_Product_2_ProductGroup.Query.Exists(Connection, Transaction, new ORM_CMN_PRO_Product_2_ProductGroup.Query()
{
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID,
CMN_PRO_ProductGroup_RefID = Parameter.ProductGroupID,
Tenant_RefID = securityTicket.TenantID
});
if (!isAlreadyInGroup)
{
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 = Parameter.ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
}
#endregion
}
#region Default Price
var price = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, new ORM_CMN_SLS_Price.Query()
{
PricelistRelease_RefID = Parameter.PriceListReleaseID,
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID,
Tenant_RefID = securityTicket.TenantID,
CMN_Currency_RefID = Parameter.CatalogCurrencyID,
IsDeleted = false
}).SingleOrDefault();
if (price == null)
{
price = new ORM_CMN_SLS_Price();
price.CMN_SLS_PriceID = Guid.NewGuid();
price.PricelistRelease_RefID = Parameter.PriceListReleaseID;
price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
price.CMN_Currency_RefID = Parameter.CatalogCurrencyID;
price.Tenant_RefID = securityTicket.TenantID;
price.Creation_Timestamp = DateTime.Now;
}
price.PriceAmount = currentParameter.Price;
price.Save(Connection, Transaction);
#endregion
importedProducts.Add(new L3AR_IoUPfSC_1325()
{
ProductID = product.CMN_PRO_ProductID, ProductITL = product.ProductITL
});
}
returnValue.Result = importedProducts.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6DTPG_SCL_1016 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_CMN_BPT_InvestedWorkTime_ChargingLevel();
#region Unnecessary
if (Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.CMN_BPT_InvestedWorkTime_ChargingLevelID);
if (result.Status != FR_Status.Success || item.CMN_BPT_InvestedWorkTime_ChargingLevelID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
if (Parameter.ChargingLevelName != null)
{
item.ChangingLevel_Name = Parameter.ChargingLevelName;
}
item.Save(Connection, Transaction);
ORM_CMN_SLS_Price.Query priceQuery = new ORM_CMN_SLS_Price.Query();
priceQuery.Tenant_RefID = securityTicket.TenantID;
priceQuery.IsDeleted = false;
priceQuery.CMN_PRO_Product_RefID = item.CMN_PRO_Product_RefID;
List <ORM_CMN_SLS_Price> prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, priceQuery);
if (prices != null && prices.Count == 1)
{
ORM_CMN_SLS_Price price = prices[0];
price.PriceAmount = Parameter.PricePerMinute;
price.CMN_Currency_RefID = Parameter.CurrencyID;
price.Save(Connection, Transaction);
}
}
else
{
var structureHeader = new ORM_DOC_Structure_Header();
structureHeader.Label = "document_header_for_product";
structureHeader.Tenant_RefID = securityTicket.TenantID;
var structureStatusSave = structureHeader.Save(Connection, Transaction);
ORM_CMN_PRO_Product product = new ORM_CMN_PRO_Product();
product.Product_Name = Parameter.ChargingLevelName;
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
product.Product_Number = "product_number";
product.Tenant_RefID = securityTicket.TenantID;
product.Save(Connection, Transaction);
ORM_CMN_BPT_InvestedWorkTime_ChargingLevel charginglevel = new ORM_CMN_BPT_InvestedWorkTime_ChargingLevel();
charginglevel.ChangingLevel_Name = Parameter.ChargingLevelName;
charginglevel.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
charginglevel.Tenant_RefID = securityTicket.TenantID;
charginglevel.Save(Connection, Transaction);
ORM_CMN_SLS_Price price = new ORM_CMN_SLS_Price();
price.CMN_Currency_RefID = Parameter.CurrencyID;
price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
price.PriceAmount = Parameter.PricePerMinute;
price.Tenant_RefID = securityTicket.TenantID;
price.Save(Connection, Transaction);
}
#endregion
return(returnValue);
#endregion UserCode
}
