protected static FR_L5AR_GWSAfAG_0908_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_GWSAfAG_0908 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5AR_GWSAfAG_0908_Array();
var paramArticles = new CL3_Articles.Atomic.Retrieval.P_L3AR_GAfT_0942
{
ActiveComponent = Parameter.ActiveComponent,
ActiveComponentStartWith = Parameter.ActiveComponentStartWith,
CustomArticlesGroupGlobalPropertyID = Parameter.ArticlesGroupGlobalPropertyID,
DosageFormQuery = Parameter.DosageFormQuery,
GeneralQuery = Parameter.GeneralQuery,
IsAvailableForOrdering = true,
LanguageID = Parameter.LanguageID,
ProducerName = Parameter.ProducerName,
ProductNameStartWith = Parameter.ProductNameStartWith,
PZNQuery = Parameter.PZNQuery,
UnitQuery = Parameter.UnitQuery,
};
List <L3AR_GAfT_0942> articles = cls_Get_Articles_for_Tenant.Invoke(Connection, Transaction, paramArticles, securityTicket).Result.ToList();
#region Get Prices
var subscribedCatalogID = articles.Select(i => i.IfImportedFromExternalCatalog_CatalogSubscription_RefID).Distinct().SingleOrDefault();
var subscribedCatalog = new ORM_CMN_PRO_SubscribedCatalog();
subscribedCatalog.Load(Connection, Transaction, subscribedCatalogID);
var param = new P_L2PR_GPVfSC_1424()
{
SubscribedCatalogITL = subscribedCatalog.CatalogCodeITL
};
var prices = cls_Get_PriceValues_for_SubscribedCatalogITL.Invoke(Connection, Transaction, param, securityTicket).Result;
#endregion
List <L5AR_GWSAfAG_0908> results = new List <L5AR_GWSAfAG_0908>();
foreach (var article in articles)
{
var articlesWithPrices = new L5AR_GWSAfAG_0908();
articlesWithPrices.Article = article;
articlesWithPrices.Price = prices.Where(x => x.CMN_PRO_Product_RefID == article.CMN_PRO_ProductID).Select(j => j.PriceAmount).SingleOrDefault();
results.Add(articlesWithPrices);
}
returnValue.Result = results.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_L5CA_GAGfSC_1456_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_GAGfSC_1456 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5CA_GAGfSC_1456_Array();
ORM_CMN_PRO_SubscribedCatalog.Query query = new ORM_CMN_PRO_SubscribedCatalog.Query();
query.CMN_PRO_SubscribedCatalogID = Parameter.SubscribedCatalogID;
query.Tenant_RefID = securityTicket.TenantID;
query.IsDeleted = false;
ORM_CMN_PRO_SubscribedCatalog subscribedCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, query).SingleOrDefault();
if (subscribedCatalog != null && subscribedCatalog.CMN_PRO_SubscribedCatalogID == Parameter.SubscribedCatalogID)
{
string matching = subscribedCatalog.IsCatalogPublic ? EnumUtils.GetEnumDescription(EProductGroup.ABDA) : EnumUtils.GetEnumDescription(EProductGroup.HauseList);
ORM_USR_Account.Query query2 = new ORM_USR_Account.Query();
query2.USR_AccountID = securityTicket.AccountID;
query2.Tenant_RefID = securityTicket.TenantID;
query2.IsDeleted = false;
ORM_USR_Account account = ORM_USR_Account.Query.Search(Connection, Transaction, query2).SingleOrDefault();
if (account != null && account.USR_AccountID == query2.USR_AccountID)
{
ORM_CMN_PRO_ProductGroup.Query query3 = new ORM_CMN_PRO_ProductGroup.Query();
query3.GlobalPropertyMatchingID = matching; //+ account.BusinessParticipant_RefID;
query3.Tenant_RefID = securityTicket.TenantID;
query3.IsDeleted = false;
var productGroups = ORM_CMN_PRO_ProductGroup.Query.Search(Connection, Transaction, query3);
returnValue.Result = productGroups.Select(x =>
new L5CA_GAGfSC_1456
{
CMN_PRO_ProductGroupID = x.CMN_PRO_ProductGroupID,
Parent_RefID = x.Parent_RefID,
ProductGroup_Name = x.ProductGroup_Name,
ProductGroup_Description = x.ProductGroup_Description
}
).ToArray();
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_UfC_1352 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
ORM_CMN_PRO_SubscribedCatalog catalog = new ORM_CMN_PRO_SubscribedCatalog();
catalog.Load(Connection, Transaction, Parameter.SubscribedCatalogID);
catalog.IsDeleted = true;
catalog.Save(Connection, Transaction);
ORM_CMN_PRO_Product.Query productsQuery = new ORM_CMN_PRO_Product.Query()
{
IsDeleted = false, IsImportedFromExternalCatalog = true, IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.SubscribedCatalogID, Tenant_RefID = securityTicket.TenantID
};
var products = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productsQuery);
if (products != null && products.Count > 0)
{
foreach (var product in products)
{
product.IsProductAvailableForOrdering = false;
product.Save(Connection, Transaction);
ORM_CMN_PRO_Product_Variant.Query variantsQuery = new ORM_CMN_PRO_Product_Variant.Query()
{
CMN_PRO_Product_RefID = product.CMN_PRO_ProductID, Tenant_RefID = securityTicket.TenantID
};
var variants = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, variantsQuery).ToList();
foreach (var variant in variants)
{
variant.IsProductAvailableForOrdering = false;
variant.Save(Connection, Transaction);
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_L6PO_GPfCOCM_1502 Execute(DbConnection Connection, DbTransaction Transaction, P_L6PO_GPfCOCM_1502 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L6PO_GPfCOCM_1502();
returnValue.Result = new L6PO_GPfCOCM_1502();
#region Get Languages
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 LanguageID = DBLanguages.Where(i => i.ISO_639_1 == "DE").SingleOrDefault().CMN_LanguageID;
#endregion
#region ORM_ORD_PRC_ProcurementOrder_Header
var procurementHeader = new ORM_ORD_PRC_ProcurementOrder_Header();
procurementHeader.Load(Connection, Transaction, Parameter.ProcurementHeaderID);
#endregion
#region ORM_ORD_PRC_ProcurementOrder_Positions
var paramShoppingProducts = new P_L5PO_GPPaSCIfH_1750();
paramShoppingProducts.ProcurementOrderHeaderID = Parameter.ProcurementHeaderID;
var shoppingProducts = cls_Get_ProcurementPositions_and_ShoppingCartInfo_for_HeaderID.Invoke(Connection, Transaction, paramShoppingProducts, securityTicket).Result;
#endregion
#region Positions
var positions = new List <L6PO_GPfCOCM_1502a>();
foreach (var shoppingProduct in shoppingProducts)
{
var product = new ORM_CMN_PRO_Product();
product.Load(Connection, Transaction, shoppingProduct.CMN_PRO_Product_RefID);
if (String.IsNullOrEmpty(product.ProductITL))
{
product.ProductITL = Guid.NewGuid().ToString();
product.Save(Connection, Transaction);
}
var catalogSubscription = new ORM_CMN_PRO_SubscribedCatalog();
catalogSubscription.Load(Connection, Transaction, product.IfImportedFromExternalCatalog_CatalogSubscription_RefID);
var position = new L6PO_GPfCOCM_1502a();
position.ProductITL = product.ProductITL;
position.ProductNumber = product.Product_Number;
position.ProductName = product.Product_Name.GetContent(LanguageID);
position.ProductDescription = product.Product_Description.GetContent(LanguageID);
position.Comment = "NotDefinedBySender";
position.Quantity = shoppingProduct.Position_Quantity;
position.IsProductReplacementAllowed = shoppingProduct.IsProductReplacementAllowed;
position.SourceCatalogITL = catalogSubscription.CatalogCodeITL;
position.UnitPrice = shoppingProduct.Position_ValuePerUnit;
position.NetoPrice = shoppingProduct.Position_ValueTotal;
var shoppingCart2Office = ORM_ORD_PRC_Office_ShoppingCart.Query.Search(Connection, Transaction,
new ORM_ORD_PRC_Office_ShoppingCart.Query {
ORD_PRC_ShoppingCart_RefID = shoppingProduct.ORD_PRC_ShoppingCart_RefID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}
).Single();
position.Quantites = new L6PO_GPfCOCM_1502b[] {
new L6PO_GPfCOCM_1502b()
{
OfficeID = shoppingCart2Office.CMN_STR_Office_RefID,
Quantity = shoppingProduct.Position_Quantity
}
};
positions.Add(position);
}
#endregion
#region Comments
var procurmentNotes = ORM_ORD_PRC_ProcurementOrder_Note.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Note.Query()
{
ORD_PRC_ProcurementOrder_Header_RefID = procurementHeader.ORD_PRC_ProcurementOrder_HeaderID,
IsDeleted = false
}).ToList();
var comments = new List <L6PO_GPfCOCM_1502c>();
foreach (var note in procurmentNotes)
{
comments.Add(
new L6PO_GPfCOCM_1502c()
{
OfficeID = note.CMN_STR_Office_RefID,
Content = note.Comment,
PublilshDate = note.NotePublishDate,
SequenceNumber = note.SequenceOrderNumber,
Title = note.Title
}
);
}
#endregion
returnValue.Result.ProcurProcurementHeaderID = procurementHeader.ORD_PRC_ProcurementOrder_HeaderID;
returnValue.Result.OrderNumber = procurementHeader.ProcurementOrder_Number;
returnValue.Result.ProcurementOrderDate = procurementHeader.ProcurementOrder_Date;
returnValue.Result.Comments = comments.ToArray();
returnValue.Result.Positions = positions.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3CA_DIC_1511 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var subscribedCatalog = new ORM_CMN_PRO_SubscribedCatalog();
subscribedCatalog.Load(Connection, Transaction, Parameter.SubscribedCatalogID);
subscribedCatalog.IsDeleted = true;
subscribedCatalog.Save(Connection, Transaction);
/*
* @all products from this catalog are not available anymore
* */
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IfImportedFromExternalCatalog_CatalogSubscription_RefID = subscribedCatalog.CMN_PRO_SubscribedCatalogID;
productQuery.IsDeleted = false;
var productList = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).ToList();
foreach (var product in productList)
{
product.IsProductAvailableForOrdering = false;
product.Save(Connection, Transaction);
}
/*
* @delete priceList and all products prices
* */
var priceReleaseQuery = new ORM_CMN_SLS_Pricelist_Release.Query();
priceReleaseQuery.Tenant_RefID = securityTicket.TenantID;
priceReleaseQuery.CMN_SLS_Pricelist_ReleaseID = subscribedCatalog.SubscribedCatalog_PricelistRelease_RefID;
priceReleaseQuery.IsDeleted = false;
var priceRelease = ORM_CMN_SLS_Pricelist_Release.Query.Search(Connection, Transaction, priceReleaseQuery).First();
priceRelease.IsDeleted = true;
var priceListQuery = new ORM_CMN_SLS_Pricelist.Query();
priceListQuery.Tenant_RefID = securityTicket.TenantID;
priceListQuery.CMN_SLS_PricelistID = priceRelease.Pricelist_RefID;
priceListQuery.IsDeleted = false;
var priceList = ORM_CMN_SLS_Pricelist.Query.Search(Connection, Transaction, priceListQuery).First();
priceList.IsDeleted = true;
priceList.Save(Connection, Transaction);
var priceQuery = new ORM_CMN_SLS_Price.Query();
priceQuery.Tenant_RefID = securityTicket.TenantID;
priceQuery.PricelistRelease_RefID = priceRelease.Pricelist_RefID;
priceQuery.IsDeleted = false;
var prices = ORM_CMN_SLS_Price.Query.Search(Connection, Transaction, priceQuery).ToList();
foreach (var price in prices)
{
price.IsDeleted = true;
price.Save(Connection, Transaction);
}
priceRelease.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_L3CCfTaIC_1526_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L3CCfTaIC_1526 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3CCfTaIC_1526_Array();
//Put your code here
List <L3CCfTaIC_1526> ProductList = new List <L3CCfTaIC_1526>();
returnValue.Result = ProductList.ToArray();
var _service = CatalogServiceFactory.GetSubscriptionService();
//make data to send to Architecture so that they will know which catalog to update
var subscriptionRequest = new SubscriptionRequest();
subscriptionRequest.CatalogCode = Parameter.CatalogCodeITL;
Customer customer = new Customer();
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
customer.BusinessParticipantITL = Parameter.SubscribedBy_BusinessParticipant_RefID.ToString();
}
else
{
customer.BusinessParticipantITL = securityTicket.TenantID.ToString();
}
customer.TenantITL = securityTicket.TenantID.ToString();
customer.Name = Parameter.ClientName;
// customer.SourceRealm = BOp.Infrastructure.PropertyRepository.Instance.RealmID.ToString();
subscriptionRequest.Customer = customer;
/*
* @see if catalog with the same ITL for that bussinessParticipant exists
* */
var subscribedCatalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
subscribedCatalogQuery.Tenant_RefID = securityTicket.TenantID;
subscribedCatalogQuery.CatalogCodeITL = Parameter.CatalogCodeITL;
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
subscribedCatalogQuery.SubscribedBy_BusinessParticipant_RefID = Parameter.SubscribedBy_BusinessParticipant_RefID;
}
subscribedCatalogQuery.IsDeleted = false;
var subscribedCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, subscribedCatalogQuery).FirstOrDefault();
#region Get VAT
var defaultCountryISOCode = cls_Get_DefaultCountryISOCode_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
var param = new P_L3TX_GTfCICaT_1359();
param.CountryISOCode = "DE";
var taxes = cls_Get_Taxes_for_CountryISOCode_and_TenantID.Invoke(Connection, Transaction, param, securityTicket).Result;
//if there are no taxes for tenant
Guid countryID = Guid.Empty;
if (taxes.Length == 0)
{
var country = cls_Get_AllCountries_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result.FirstOrDefault();
if (country != null)
{
countryID = country.CMN_CountryID;
}
}
else
{
countryID = taxes.First().CMN_CountryID; // ti slucajni posmatracu ovog koda nemoj zameriti na ovakvom resenju.
}
#endregion
#region save
if (subscribedCatalog == null)
{
/*
* @save ORM_CMN_PRO_SubscribedCatalog
* */
subscribedCatalog = new ORM_CMN_PRO_SubscribedCatalog();
subscribedCatalog.CMN_PRO_SubscribedCatalogID = Guid.NewGuid();
subscribedCatalog.CatalogCodeITL = Parameter.CatalogCodeITL;
subscribedCatalog.SubscribedCatalog_Name = Parameter.CatalogName;
subscribedCatalog.SubscribedBy_BusinessParticipant_RefID = Parameter.SubscribedBy_BusinessParticipant_RefID;
subscribedCatalog.Tenant_RefID = securityTicket.TenantID;
subscribedCatalog.SubscribedCatalog_ValidFrom = Parameter.ValidFrom_Date;
subscribedCatalog.SubscribedCatalog_ValidThrough = Parameter.ValidTo_Date;
subscribedCatalog.SubscribedCatalog_Description = Parameter.CatalogDescription;
subscribedCatalog.Creation_Timestamp = DateTime.Now;
subscribedCatalog.IsDeleted = false;
subscribedCatalog.SubscribedCatalog_CurrentRevision = Parameter.CatalogVersion;
subscribedCatalog.IsCatalogPublic = Parameter.IsCatalogPublic;
// check if language with that ISO exists for Tenant (Lower, exmpl de)
var languageQuery = new ORM_CMN_Language.Query();
languageQuery.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes.ToLower();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
var language = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery).FirstOrDefault();
// if language does not exist for that Tenant
if (language == null)
{
//check if language with that ISO exists for Tenant (Upper exmpl DE)
languageQuery = new ORM_CMN_Language.Query();
languageQuery.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes.ToUpper();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
language = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery).FirstOrDefault();
// if language does not exist for that Tenant
if (language == null)
{
ORM_CMN_Language newLanguage = new ORM_CMN_Language();
newLanguage.CMN_LanguageID = Guid.NewGuid();
newLanguage.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes;
newLanguage.Creation_Timestamp = DateTime.Now;
newLanguage.Tenant_RefID = securityTicket.TenantID;
newLanguage.IsDeleted = false;
newLanguage.Save(Connection, Transaction);
subscribedCatalog.SubscribedCatalog_Language_RefID = newLanguage.CMN_LanguageID;
}
else
{
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
}
}
else
{
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
}
// check if currency with that ISO exists for Tenant
var currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
var currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
ORM_CMN_Currency newCurrency = new ORM_CMN_Currency();
newCurrency.CMN_CurrencyID = Guid.NewGuid();
newCurrency.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
newCurrency.Tenant_RefID = securityTicket.TenantID;
newCurrency.Creation_Timestamp = DateTime.Now;
newCurrency.Save(Connection, Transaction);
subscribedCatalog.SubscribedCatalog_Currency_RefID = newCurrency.CMN_CurrencyID;
}
else
{
subscribedCatalog.SubscribedCatalog_Currency_RefID = currency.CMN_CurrencyID;
}
#region product group
/*
* @Search product group
* */
ORM_CMN_PRO_ProductGroup productGroup = new ORM_CMN_PRO_ProductGroup();
var productGroupQuery = new ORM_CMN_PRO_ProductGroup.Query();
productGroupQuery.Tenant_RefID = securityTicket.TenantID;
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
//if (Parameter.IsCatalogPublic == false)
//{
// productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
//}
//else
//{
// productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.ABDA);
//}
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
productGroupQuery.GlobalPropertyMatchingID += Parameter.SubscribedBy_BusinessParticipant_RefID;
}
productGroupQuery.IsDeleted = false;
productGroup = ORM_CMN_PRO_ProductGroup.Query.Search(Connection, Transaction, productGroupQuery).FirstOrDefault();
if (productGroup == null)
{
/*
* @Create product group for products if product group for that BP and Tenent does not exist
* */
productGroup = new ORM_CMN_PRO_ProductGroup();
productGroup.Tenant_RefID = securityTicket.TenantID;
productGroup.Creation_Timestamp = DateTime.Now;
productGroup.CMN_PRO_ProductGroupID = Guid.NewGuid();
productGroup.ProductGroup_Name = new Dict(ORM_CMN_PRO_ProductGroup.TableName);
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "Treatment Group");
//if (Parameter.IsCatalogPublic == false)
//{
// productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
// productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "HauseList Group");
//}
//else
//{
// productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.ABDA);
// productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "ABDA Group");
//}
// for only Tenant specific cases add Business Participant ID
if (Parameter.SubscribedBy_BusinessParticipant_RefID != Guid.Empty)
{
productGroup.GlobalPropertyMatchingID += Parameter.SubscribedBy_BusinessParticipant_RefID;
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "Treatment Group");
}
productGroup.Save(Connection, Transaction);
}
#endregion
#region create priceList for Catalog
/*
* @create pricelist_Release
* */
ORM_CMN_SLS_Pricelist_Release pricelist_Release = new ORM_CMN_SLS_Pricelist_Release();
pricelist_Release.CMN_SLS_Pricelist_ReleaseID = Guid.NewGuid();
pricelist_Release.Release_Version = "v1";
if (Parameter.IsCatalogPublic == false)
{
pricelist_Release.PricelistRelease_ValidFrom = Parameter.ValidFrom_Date;
pricelist_Release.PricelistRelease_ValidTo = Parameter.ValidTo_Date;
}
else
{
pricelist_Release.IsPricelistAlwaysActive = true;
}
pricelist_Release.Tenant_RefID = securityTicket.TenantID;
pricelist_Release.Creation_Timestamp = DateTime.Now;
pricelist_Release.Pricelist_RefID = Guid.NewGuid();//priceList.CMN_SLS_PricelistID
pricelist_Release.Save(Connection, Transaction);
/*
* @create pricelist
* */
ORM_CMN_SLS_Pricelist priceList = new ORM_CMN_SLS_Pricelist();
priceList.CMN_SLS_PricelistID = pricelist_Release.Pricelist_RefID;
var DBLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result.ToList();
Dict nameDict = new Dict("cmn_sls_pricelist");
if (Parameter.IsCatalogPublic == false)
{
for (int i = 0; i < DBLanguages.Count; i++)
{
nameDict.AddEntry(DBLanguages[i].CMN_LanguageID, Parameter.CatalogName + "_" + Parameter.ValidFrom_Date.ToShortDateString() + "_" + Parameter.ValidTo_Date.ToShortDateString());
}
}
else
{
for (int i = 0; i < DBLanguages.Count; i++)
{
nameDict.AddEntry(DBLanguages[i].CMN_LanguageID, "ABDA_PriceList");
}
}
priceList.Pricelist_Name = nameDict;
priceList.Tenant_RefID = securityTicket.TenantID;
priceList.Creation_Timestamp = DateTime.Now;
priceList.Save(Connection, Transaction);
#endregion
if (Parameter.IsCatalogPublic == false)
{
#region create and save products in product group and give product its price , product amout and measure unit
/*
* @create and save products in product group
* */
bool isAlreadyInABDA = false;
foreach (var item in Parameter.Products)
{
ORM_CMN_PRO_Product product = new ORM_CMN_PRO_Product();
// only for Tenant specific cases add Business Participant ID (!Lucentis)
if (Parameter.SubscribedBy_BusinessParticipant_RefID == Guid.Empty)
{
var productQuery = new ORM_CMN_PRO_Product.Query();
productQuery.ProductITL = item.ProductITL;
productQuery.Tenant_RefID = securityTicket.TenantID;
productQuery.IsDeleted = false;
productQuery.IsProductAvailableForOrdering = true;
product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productQuery).FirstOrDefault();
//if it is not in ABDA
if (product == null)
{
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.ProductITL = item.ProductITL;
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = item.IsProduct_Article;
product.IsProductAvailableForOrdering = true;
product.PackageInfo_RefID = Guid.NewGuid();//packageInfo.CMN_PRO_PAC_PackageInfoID
isAlreadyInABDA = false;
}
else
{
isAlreadyInABDA = true;
}
}
else
{
product.CMN_PRO_ProductID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.ProductITL = item.ProductITL;
product.Product_Name = item.Product_Name;
product.Product_Description = item.Product_Description;
product.Product_Number = item.Product_Number;
product.IsProduct_Article = item.IsProduct_Article;
product.IsProductAvailableForOrdering = true;
product.PackageInfo_RefID = Guid.NewGuid();//packageInfo.CMN_PRO_PAC_PackageInfoID
isAlreadyInABDA = false;
}
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = subscribedCatalog.CMN_PRO_SubscribedCatalogID;
product.Save(Connection, Transaction);
L3CCfTaIC_1526 pro = new L3CCfTaIC_1526();
pro.ProductID = product.CMN_PRO_ProductID;
if (product.IsProduct_Article)
{
pro.Dosage = item.Dosage;
}
pro.isEdit = false;
ProductList.Add(pro);
ORM_CMN_PRO_Product_2_ProductGroup product_2_productGroup = new ORM_CMN_PRO_Product_2_ProductGroup();
product_2_productGroup.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
product_2_productGroup.CMN_PRO_ProductGroup_RefID = productGroup.CMN_PRO_ProductGroupID;
product_2_productGroup.Tenant_RefID = securityTicket.TenantID;
product_2_productGroup.Creation_Timestamp = DateTime.Now;
product_2_productGroup.Save(Connection, Transaction);
if (isAlreadyInABDA == false)
{
ORM_CMN_SLS_Price price = new ORM_CMN_SLS_Price();
price.CMN_SLS_PriceID = Guid.NewGuid();
price.Tenant_RefID = securityTicket.TenantID;
price.Creation_Timestamp = DateTime.Now;
price.PricelistRelease_RefID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
price.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
price.PriceAmount = item.Price;
price.CMN_Currency_RefID = subscribedCatalog.SubscribedCatalog_Currency_RefID;
price.Save(Connection, Transaction);
//add amount and Measure
ORM_CMN_PRO_PAC_PackageInfo packageInfo = new ORM_CMN_PRO_PAC_PackageInfo();
packageInfo.CMN_PRO_PAC_PackageInfoID = product.PackageInfo_RefID;
packageInfo.Tenant_RefID = securityTicket.TenantID;
packageInfo.Creation_Timestamp = DateTime.Now;
packageInfo.PackageContent_Amount = item.Amount;
//check if MeasureUnit exists for this Tenant
var unitsQuery = new ORM_CMN_Unit.Query();
unitsQuery.Tenant_RefID = securityTicket.TenantID;
unitsQuery.ISOCode = item.MeasuredInUnit_ISO_um_ums;
unitsQuery.IsDeleted = false;
var measuredInUnit = ORM_CMN_Unit.Query.Search(Connection, Transaction, unitsQuery).FirstOrDefault();
if (measuredInUnit == null)
{
ORM_CMN_Unit newMeasuredInUnit = new ORM_CMN_Unit();
newMeasuredInUnit.Tenant_RefID = securityTicket.TenantID;
newMeasuredInUnit.Creation_Timestamp = DateTime.Now;
newMeasuredInUnit.ISOCode = item.MeasuredInUnit_ISO_um_ums;
newMeasuredInUnit.CMN_UnitID = Guid.NewGuid();
newMeasuredInUnit.Save(Connection, Transaction);
packageInfo.PackageContent_MeasuredInUnit_RefID = newMeasuredInUnit.CMN_UnitID;
}
else
{
packageInfo.PackageContent_MeasuredInUnit_RefID = measuredInUnit.CMN_UnitID;
}
packageInfo.Save(Connection, Transaction);
if (countryID != Guid.Empty)// if there is a country for this Tenant
{
#region Create Taxes
double productVAT = 0;
Double.TryParse(item.VAT, out productVAT);
var tax = taxes.Where(i => i.TaxRate == productVAT).SingleOrDefault();
if (tax == default(L3TX_GTfCICaT_1359))
{
#region CreateTax
var saveTaxParam = new P_L3TX_STX_1119();
saveTaxParam.ACC_TAX_TaxeID = Guid.Empty;
saveTaxParam.TaxName = new Dict(ORM_ACC_TAX_Tax.TableName);
saveTaxParam.TaxName.AddEntry(language.CMN_LanguageID, productVAT.ToString());
saveTaxParam.TaxRate = productVAT;
if (taxes.Length != 0)
{
saveTaxParam.EconomicRegion_RefID = taxes.First().CMN_EconomicRegionID;
saveTaxParam.Country_RefID = taxes.First().CMN_CountryID;
}
else
{
saveTaxParam.EconomicRegion_RefID = Guid.Empty;
saveTaxParam.Country_RefID = countryID;
}
var saveTaxResult = cls_Save_Tax.Invoke(Connection, Transaction, saveTaxParam, securityTicket).Result;
#endregion
#region Update Available taxes
param = new P_L3TX_GTfCICaT_1359();
param.CountryISOCode = "DE";
taxes = cls_Get_Taxes_for_CountryISOCode_and_TenantID.Invoke(Connection, Transaction, param, securityTicket).Result;
tax = taxes.Where(i => i.TaxRate == productVAT).SingleOrDefault();
#endregion
}
var salesTax = new ORM_CMN_PRO_Product_SalesTaxAssignmnet();
salesTax.CMN_PRO_Product_SalesTaxAssignmnetID = Guid.NewGuid();
salesTax.Product_RefID = product.CMN_PRO_ProductID;
salesTax.ApplicableSalesTax_RefID = tax.ACC_TAX_TaxeID;
salesTax.Creation_Timestamp = DateTime.Now;
salesTax.Tenant_RefID = securityTicket.TenantID;
salesTax.Save(Connection, Transaction);
#endregion
}
}
}
#endregion
}
/*
* @See if Supplier already exists in database
* */
ORM_CMN_BPT_Supplier supplier = new ORM_CMN_BPT_Supplier();
var supplierQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
supplierQuery.BusinessParticipantITL = Parameter.SupplierData.SupplierITL;
supplierQuery.Tenant_RefID = securityTicket.TenantID;
supplierQuery.IsDeleted = false;
var supplier_bussinessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, supplierQuery).FirstOrDefault();
#region if supplier does not exist
if (supplier_bussinessParticipant == null)
{
/*
* @Make Supplier Data
* */
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.SupplierData.TenantITL,
Tenant_RefID = securityTicket.TenantID
};
var supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.SupplierData.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
}
supplier.CMN_BPT_SupplierID = Guid.NewGuid();
supplier.Ext_BusinessParticipant_RefID = Guid.NewGuid();//supplierBussinessParticipant.CMN_BPT_BusinessParticipantID
supplier.Creation_Timestamp = DateTime.Now;
supplier.IsDeleted = false;
supplier.Tenant_RefID = securityTicket.TenantID;
supplier.Save(Connection, Transaction);
ORM_CMN_BPT_BusinessParticipant supplierBussinessParticipant = new ORM_CMN_BPT_BusinessParticipant();
supplierBussinessParticipant.CMN_BPT_BusinessParticipantID = supplier.Ext_BusinessParticipant_RefID;
supplierBussinessParticipant.DisplayName = Parameter.SupplierData.Supplier_Name;
supplierBussinessParticipant.BusinessParticipantITL = Parameter.SupplierData.SupplierITL;
supplierBussinessParticipant.Creation_Timestamp = DateTime.Now;
supplierBussinessParticipant.Tenant_RefID = securityTicket.TenantID;
supplierBussinessParticipant.IsCompany = true;
supplierBussinessParticipant.IsTenant = true;
supplierBussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID = Guid.NewGuid();//companyInfo.CMN_COM_CompanyInfoID
supplierBussinessParticipant.Save(Connection, Transaction);
ORM_CMN_COM_CompanyInfo companyInfo = new ORM_CMN_COM_CompanyInfo();
companyInfo.CMN_COM_CompanyInfoID = supplierBussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfo.Creation_Timestamp = DateTime.Now;
companyInfo.Tenant_RefID = securityTicket.TenantID;
companyInfo.Contact_UCD_RefID = Guid.NewGuid();//universalContactDetail.CMN_UniversalContactDetailID
companyInfo.Save(Connection, Transaction);
ORM_CMN_UniversalContactDetail universalContactDetail = new ORM_CMN_UniversalContactDetail();
universalContactDetail.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetail.IsCompany = true;
universalContactDetail.Country_639_1_ISOCode = Parameter.SupplierData.CountryISO;
universalContactDetail.Street_Name = Parameter.SupplierData.Supplier_Name;
universalContactDetail.Street_Number = Parameter.SupplierData.Street_Number;
universalContactDetail.ZIP = Parameter.SupplierData.ZIP;
universalContactDetail.Town = Parameter.SupplierData.Town;
universalContactDetail.Region_Code = Parameter.SupplierData.Region_Code;
universalContactDetail.Tenant_RefID = securityTicket.TenantID;
universalContactDetail.Creation_Timestamp = DateTime.Now;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
#region if supplier exists , check if its data is changed
else
{
var tenantQuery = new ORM_CMN_Tenant.Query()
{
TenantITL = Parameter.SupplierData.TenantITL,
Tenant_RefID = securityTicket.TenantID
};
var supplierTenant = ORM_CMN_Tenant.Query.Search(Connection, Transaction, tenantQuery).SingleOrDefault();
if (supplierTenant == default(ORM_CMN_Tenant))
{
supplierTenant = new ORM_CMN_Tenant();
supplierTenant.CMN_TenantID = Guid.NewGuid();
supplierTenant.TenantITL = Parameter.SupplierData.TenantITL;
supplierTenant.Tenant_RefID = securityTicket.TenantID;
supplierTenant.Creation_Timestamp = DateTime.Now;
supplierTenant.Save(Connection, Transaction);
supplier_bussinessParticipant.IsTenant = true;
supplier_bussinessParticipant.IfTenant_Tenant_RefID = supplierTenant.CMN_TenantID;
}
supplier_bussinessParticipant.DisplayName = Parameter.SupplierData.Supplier_Name;
supplier_bussinessParticipant.Save(Connection, Transaction);
var query = new ORM_CMN_BPT_Supplier.Query();
query.Ext_BusinessParticipant_RefID = supplier_bussinessParticipant.CMN_BPT_BusinessParticipantID;
query.Tenant_RefID = securityTicket.TenantID;
query.IsDeleted = false;
supplier = ORM_CMN_BPT_Supplier.Query.Search(Connection, Transaction, query).First();
//edit universal contact details
var companyInfoQuery = new ORM_CMN_COM_CompanyInfo.Query();
companyInfoQuery.CMN_COM_CompanyInfoID = supplier_bussinessParticipant.IfCompany_CMN_COM_CompanyInfo_RefID;
companyInfoQuery.Tenant_RefID = securityTicket.TenantID;
companyInfoQuery.IsDeleted = false;
var companyInfo = ORM_CMN_COM_CompanyInfo.Query.Search(Connection, Transaction, companyInfoQuery).First();
var universalContactDetailQuery = new ORM_CMN_UniversalContactDetail.Query();
universalContactDetailQuery.CMN_UniversalContactDetailID = companyInfo.Contact_UCD_RefID;
universalContactDetailQuery.Tenant_RefID = securityTicket.TenantID;
universalContactDetailQuery.IsDeleted = false;
var universalContactDetail = ORM_CMN_UniversalContactDetail.Query.Search(Connection, Transaction, universalContactDetailQuery).First();
universalContactDetail.Country_639_1_ISOCode = Parameter.SupplierData.CountryISO;
universalContactDetail.Street_Name = Parameter.SupplierData.Supplier_Name;
universalContactDetail.Street_Number = Parameter.SupplierData.Street_Number;
universalContactDetail.ZIP = Parameter.SupplierData.ZIP;
universalContactDetail.Town = Parameter.SupplierData.Town;
universalContactDetail.Region_Code = Parameter.SupplierData.Region_Code;
universalContactDetail.Save(Connection, Transaction);
}
#endregion
subscribedCatalog.SubscribedCatalog_PricelistRelease_RefID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
subscribedCatalog.PublishingSupplier_RefID = supplier.CMN_BPT_SupplierID;
subscribedCatalog.Save(Connection, Transaction);
/*
* @send Kika information which catalog has been subscribed to who
* */
var result = _service.SubscribeToCatalog(subscriptionRequest);
if (result.ResponseStatus != ResponseStatus.OK)
{
throw new Exception("Catalog subscription failed!");
}
}
#endregion
returnValue.Result = ProductList.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_IPfC_1648 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var defaultLanguages = ORM_CMN_Language.Query.Search(Connection, Transaction, new ORM_CMN_Language.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
var productFromCatalog = Parameter.Product;
ORM_CMN_PRO_SubscribedCatalog subscribedCatalog = new ORM_CMN_PRO_SubscribedCatalog();
var existingCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, new ORM_CMN_PRO_SubscribedCatalog.Query()
{
CatalogCodeITL = productFromCatalog.CatalogITL
});
if (existingCatalog != null && existingCatalog.Count() > 0)
{
subscribedCatalog = existingCatalog.First();
}
var supplierID = subscribedCatalog.PublishingSupplier_RefID;
ORM_CMN_PRO_Product productToCreateUpdate = new ORM_CMN_PRO_Product();
productToCreateUpdate.CMN_PRO_ProductID = Guid.NewGuid();
ORM_CMN_PRO_Product.Query productDbQuery = new ORM_CMN_PRO_Product.Query();
productDbQuery.ProductITL = productFromCatalog.ProductITL;
productDbQuery.Tenant_RefID = securityTicket.TenantID;
productDbQuery.IsDeleted = false;
var product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, productDbQuery);
if (product != null && product.Count > 0)
{
productToCreateUpdate = product.First();
ORM_CMN_PRO_Dimension.Query dimensionQuery = new ORM_CMN_PRO_Dimension.Query();
dimensionQuery.Product_RefID = productToCreateUpdate.CMN_PRO_ProductID;
dimensionQuery.Tenant_RefID = securityTicket.TenantID;
dimensionQuery.IsDeleted = false;
var dimensions = ORM_CMN_PRO_Dimension.Query.Search(Connection, Transaction, dimensionQuery);
foreach (var dimension in dimensions)
{
ORM_CMN_PRO_Dimension_Value.Query dimensionValuesQuery = new ORM_CMN_PRO_Dimension_Value.Query();
dimensionValuesQuery.Dimensions_RefID = dimension.CMN_PRO_DimensionID;
dimensionValuesQuery.Tenant_RefID = securityTicket.TenantID;
var dimensionValues = ORM_CMN_PRO_Dimension_Value.Query.Search(Connection, Transaction, dimensionValuesQuery);
foreach (var dimensionValue in dimensionValues)
{
ORM_CMN_PRO_Variant_DimensionValue.Query dimensionValueVariantQuery = new ORM_CMN_PRO_Variant_DimensionValue.Query();
dimensionValueVariantQuery.DimensionValue_RefID = dimensionValue.CMN_PRO_Dimension_ValueID;
ORM_CMN_PRO_Variant_DimensionValue.Query.SoftDelete(Connection, Transaction, dimensionValueVariantQuery);
}
ORM_CMN_PRO_Dimension_Value.Query.SoftDelete(Connection, Transaction, dimensionValuesQuery);
}
ORM_CMN_PRO_Dimension.Query.SoftDelete(Connection, Transaction, dimensionQuery);
}
productToCreateUpdate.IsImportedFromExternalCatalog = true;
productToCreateUpdate.Product_Name = new Dict(ORM_CMN_PRO_Product.TableName);
productToCreateUpdate.IsDeleted = false;
productToCreateUpdate.ProductITL = productFromCatalog.ProductITL;
productToCreateUpdate.Product_Description = new Dict(ORM_CMN_PRO_Product.TableName);
productToCreateUpdate.Tenant_RefID = securityTicket.TenantID;
productToCreateUpdate.Product_Number = productFromCatalog.Code;
foreach (var lang in defaultLanguages)
{
productToCreateUpdate.Product_Name.AddEntry(lang.CMN_LanguageID, productFromCatalog.Name);
productToCreateUpdate.Product_Description.AddEntry(lang.CMN_LanguageID, productFromCatalog.Description);
}
productToCreateUpdate.Save(Connection, Transaction);
returnValue.Result = productToCreateUpdate.CMN_PRO_ProductID;
foreach (var customizationToDelete in ORM_CMN_PRO_CUS_Customization.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
Product_RefID = productToCreateUpdate.CMN_PRO_ProductID
}))
{
ORM_CMN_PRO_CUS_Customization.Query.SoftDelete(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
CMN_PRO_CUS_CustomizationID = customizationToDelete.CMN_PRO_CUS_CustomizationID
});
if (ORM_CMN_PRO_CUS_Customization_Variant.Query.Exists(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
Customization_RefID = customizationToDelete.CMN_PRO_CUS_CustomizationID
}))
{
ORM_CMN_PRO_CUS_Customization_Variant.Query.SoftDelete(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
Customization_RefID = customizationToDelete.CMN_PRO_CUS_CustomizationID
});
}
}
var customizationOrderSequence = 0;
if (productFromCatalog.Customizations != null)
{
productToCreateUpdate.IsCustomizable = true;
productToCreateUpdate.Save(Connection, Transaction);
foreach (var customization in productFromCatalog.Customizations)
{
ORM_CMN_PRO_CUS_Customization customizationToSave = new ORM_CMN_PRO_CUS_Customization();
customizationToSave.CMN_PRO_CUS_CustomizationID = Guid.NewGuid();
customizationToSave.Customization_Description = new Dict(ORM_CMN_PRO_CUS_Customization.TableName);
customizationToSave.Customization_Name = new Dict(ORM_CMN_PRO_CUS_Customization.TableName);
customizationToSave.IsDeleted = false;
customizationToSave.Product_RefID = productToCreateUpdate.CMN_PRO_ProductID;
customizationToSave.Tenant_RefID = securityTicket.TenantID;
customizationToSave.OrderSequence = customizationOrderSequence;
customizationOrderSequence++;
foreach (var lang in defaultLanguages)
{
customizationToSave.Customization_Description.UpdateEntry(lang.CMN_LanguageID, customization.Description);
customizationToSave.Customization_Name.UpdateEntry(lang.CMN_LanguageID, customization.Name);
}
customizationToSave.Save(Connection, Transaction);
var customizationVariantOrderSequence = 0;
foreach (var customizationVariant in customization.CustomizationVariants)
{
ORM_CMN_PRO_CUS_Customization_Variant customizationVariantsToSave = new ORM_CMN_PRO_CUS_Customization_Variant();
customizationVariantsToSave.CMN_PRO_CUS_Customization_VariantID = Guid.NewGuid();
customizationVariantsToSave.Customization_RefID = customizationToSave.CMN_PRO_CUS_CustomizationID;
customizationVariantsToSave.CustomizationVariant_Name = new Dict(ORM_CMN_PRO_CUS_Customization_Variant.TableName);
customizationVariantsToSave.OrderSequence = customizationVariantOrderSequence;
customizationVariantOrderSequence++;
customizationVariantsToSave.IsDeleted = false;
customizationVariantsToSave.Tenant_RefID = securityTicket.TenantID;
foreach (var lang in defaultLanguages)
{
customizationVariantsToSave.CustomizationVariant_Name.UpdateEntry(lang.CMN_LanguageID, customizationVariant.Name);
}
customizationVariantsToSave.Save(Connection, Transaction);
}
}
}
ORM_CMN_PRO_Product_Variant.Query productVariantQuery = new ORM_CMN_PRO_Product_Variant.Query();
productVariantQuery.CMN_PRO_Product_RefID = productToCreateUpdate.CMN_PRO_ProductID;
productVariantQuery.Tenant_RefID = securityTicket.TenantID;
productVariantQuery.IsDeleted = false;
var productVariantsDb = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, productVariantQuery);
List <ORM_CMN_PRO_Dimension> dimensionsToCreate = new List <ORM_CMN_PRO_Dimension>();
List <ORM_CMN_PRO_Dimension_Value> dimensionValuesToCreate = new List <ORM_CMN_PRO_Dimension_Value>();
foreach (var productVariantFromCatalog in productFromCatalog.Variants)
{
ORM_CMN_PRO_Product_Variant.Query variantToCreateQuery = new ORM_CMN_PRO_Product_Variant.Query();
variantToCreateQuery.ProductVariantITL = productVariantFromCatalog.ITL;
variantToCreateQuery.Tenant_RefID = securityTicket.TenantID;
var isVariantSaved = ORM_CMN_PRO_Product_Variant.Query.Exists(Connection, Transaction, variantToCreateQuery);
ORM_CMN_PRO_Product_Variant productVariantToCreate = new ORM_CMN_PRO_Product_Variant();
if (isVariantSaved)
{
productVariantToCreate.Load(Connection, Transaction, ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, variantToCreateQuery).FirstOrDefault().CMN_PRO_Product_VariantID);
}
else
{
productVariantToCreate.CMN_PRO_Product_VariantID = Guid.NewGuid();
}
productVariantToCreate.IsStandardProductVariant = productVariantFromCatalog.DefaultVariant;
productVariantToCreate.CMN_PRO_Product_RefID = productToCreateUpdate.CMN_PRO_ProductID;
productVariantToCreate.IsDeleted = false;
productVariantToCreate.Tenant_RefID = securityTicket.TenantID;
productVariantToCreate.IsImportedFromExternalCatalog = true;
productVariantToCreate.ProductVariantITL = productVariantFromCatalog.ITL;
productVariantToCreate.VariantName = new Dict(ORM_CMN_PRO_Product_Variant.TableName);
foreach (var lang in defaultLanguages)
{
productVariantToCreate.VariantName.UpdateEntry(lang.CMN_LanguageID, productVariantFromCatalog.Name);
}
productVariantToCreate.Save(Connection, Transaction);
ORM_CMN_Price procurementPrice = new ORM_CMN_Price();
procurementPrice.CMN_PriceID = Guid.NewGuid();
procurementPrice.IsDeleted = false;
procurementPrice.Tenant_RefID = securityTicket.TenantID;
procurementPrice.Save(Connection, Transaction);
foreach (var price in productVariantFromCatalog.PriceGrades)
{
ORM_CMN_Price_Value priceValues = new ORM_CMN_Price_Value();
priceValues.Price_RefID = procurementPrice.CMN_PriceID;
var procurementPriceAmount = price.SalesPrice ?? 0;
priceValues.PriceValue_Amount = (double)procurementPriceAmount;
priceValues.PriceValue_Currency_RefID = subscribedCatalog.SubscribedCatalog_Currency_RefID;
priceValues.IsDeleted = false;
priceValues.Tenant_RefID = securityTicket.TenantID;
priceValues.Save(Connection, Transaction);
}
ORM_CMN_PRO_Product_Supplier productSupplier = new ORM_CMN_PRO_Product_Supplier();
productSupplier.CMN_BPT_Supplier_RefID = supplierID;
productSupplier.CMN_PRO_Product_RefID = productVariantToCreate.CMN_PRO_Product_RefID;
productSupplier.CMN_PRO_Product_Variant_RefID = productVariantToCreate.CMN_PRO_Product_VariantID;
productSupplier.ProcurementPrice_RefID = procurementPrice.CMN_PriceID;
productSupplier.Tenant_RefID = securityTicket.TenantID;
productSupplier.SupplierPriority = 0;
productSupplier.IsDeleted = false;
productSupplier.Save(Connection, Transaction);
foreach (var dimension in productVariantFromCatalog.Dimensions)
{
if (dimensionsToCreate.Where(x => x.DimensionName.Contents.First().Content == dimension.Key).Count() == 0)
{
ORM_CMN_PRO_Dimension dimensionToCreate = new ORM_CMN_PRO_Dimension();
dimensionToCreate.DimensionName = new Dict(ORM_CMN_PRO_Dimension.TableName);
foreach (var lang in defaultLanguages)
{
dimensionToCreate.DimensionName.AddEntry(lang.CMN_LanguageID, dimension.Key);
}
dimensionToCreate.OrderSequence = dimensionsToCreate.Count() + 1;
dimensionToCreate.CMN_PRO_DimensionID = Guid.NewGuid();
dimensionToCreate.Product_RefID = productVariantToCreate.CMN_PRO_Product_RefID;
dimensionToCreate.IsDeleted = false;
dimensionToCreate.Tenant_RefID = securityTicket.TenantID;
dimensionsToCreate.Add(dimensionToCreate);
}
var dimensionValue = dimensionValuesToCreate.Where(x => x.DimensionValue_Text.Contents.First().Content == dimension.Value);
ORM_CMN_PRO_Dimension_Value dimensionValueToCreate = new ORM_CMN_PRO_Dimension_Value();
if (dimensionValue != null && dimensionValue.Count() > 0)
{
dimensionValueToCreate = dimensionValue.First();
}
else
{
dimensionValueToCreate.DimensionValue_Text = new Dict(ORM_CMN_PRO_Dimension_Value.TableName);
foreach (var lang in defaultLanguages)
{
dimensionValueToCreate.DimensionValue_Text.AddEntry(lang.CMN_LanguageID, dimension.Value);
}
dimensionValueToCreate.Dimensions_RefID = dimensionsToCreate.First(x => x.DimensionName.Contents.First().Content == dimension.Key).CMN_PRO_DimensionID;
dimensionValueToCreate.CMN_PRO_Dimension_ValueID = Guid.NewGuid();
dimensionValueToCreate.OrderSequence = dimensionValuesToCreate.Count() + 1;
dimensionValueToCreate.IsDeleted = false;
dimensionValueToCreate.Tenant_RefID = securityTicket.TenantID;
dimensionValuesToCreate.Add(dimensionValueToCreate);
}
ORM_CMN_PRO_Variant_DimensionValue variantDimensionValueToCreate = new ORM_CMN_PRO_Variant_DimensionValue();
variantDimensionValueToCreate.CMN_PRO_Variant_DimensionValueID = Guid.NewGuid();
variantDimensionValueToCreate.DimensionValue_RefID = dimensionValueToCreate.CMN_PRO_Dimension_ValueID;
variantDimensionValueToCreate.ProductVariant_RefID = productVariantToCreate.CMN_PRO_Product_VariantID;
variantDimensionValueToCreate.IsDeleted = false;
variantDimensionValueToCreate.Tenant_RefID = securityTicket.TenantID;
variantDimensionValueToCreate.Save(Connection, Transaction);
}
}
foreach (var dimensionToCreate in dimensionsToCreate)
{
dimensionToCreate.Save(Connection, Transaction);
}
foreach (var dimensionValueToCreate in dimensionValuesToCreate)
{
dimensionValueToCreate.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3CA_IC_1426 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
#region Tenant is already subscribed to this catalog
var subscribedCatalogQuery = new ORM_CMN_PRO_SubscribedCatalog.Query();
subscribedCatalogQuery.Tenant_RefID = securityTicket.TenantID;
subscribedCatalogQuery.CatalogCodeITL = Parameter.CatalogCodeITL;
subscribedCatalogQuery.IsDeleted = false;
var alreadySubscribedCatalog = ORM_CMN_PRO_SubscribedCatalog.Query.Search(Connection, Transaction, subscribedCatalogQuery).FirstOrDefault();
if (alreadySubscribedCatalog != null)
{
throw new Exception("Tenant is already subscribed to this catalog!");
}
#endregion
#region All tenant's languages
var allTenantLanguages = cls_Get_All_Languages.Invoke(Connection, Transaction, securityTicket).Result.ToList();
#endregion
#region Get catalog's language or create it
// 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 create it
if (language == null)
{
language = new ORM_CMN_Language();
language.CMN_LanguageID = Guid.NewGuid();
language.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1_codes;
language.Name = new Dict(ORM_CMN_Currency.TableName);
foreach (var item in allTenantLanguages)
{
language.Name.AddEntry(item.CMN_LanguageID, "CatalogLanguage - " + Parameter.CatalogLanguage_ISO_639_1_codes);
}
language.Creation_Timestamp = DateTime.Now;
language.Tenant_RefID = securityTicket.TenantID;
language.IsDeleted = false;
language.Save(Connection, Transaction);
}
}
#endregion
#region Get catalog's currency or create it
// check if currency with that ISO exists for Tenant
var currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217.ToUpper();
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
var currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217.ToLower();
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
currency = new ORM_CMN_Currency();
currency.CMN_CurrencyID = Guid.NewGuid();
currency.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
currency.Name = new Dict(ORM_CMN_Currency.TableName);
foreach (var item in allTenantLanguages)
{
currency.Name.AddEntry(item.CMN_LanguageID, "CatalogCurrency - " + Parameter.CatalogCurrency_ISO_4217);
}
currency.Tenant_RefID = securityTicket.TenantID;
currency.Creation_Timestamp = DateTime.Now;
currency.Save(Connection, Transaction);
}
}
#endregion
/*
* @save ORM_CMN_PRO_SubscribedCatalog
* */
var 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 = Guid.Empty; // This ClassLib is not used by Lucentis
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;
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
subscribedCatalog.SubscribedCatalog_Currency_RefID = currency.CMN_CurrencyID;
#region Create 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.IsDeleted = false;
if (Parameter.IsCatalogPublic == false)
{
if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.SpecialRequests))
{
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.SpecialRequests);
}
else if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.Houselist))
{
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
}
else if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.Treatment))
{
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
}
}
else
{
productGroupQuery.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.ABDA);
}
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);
if (Parameter.IsCatalogPublic == false)
{
if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.SpecialRequests))
{
productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.SpecialRequests);
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "SpecialRequests Group");
}
else if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.Houselist))
{
productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.HauseList);
productGroup.ProductGroup_Name.AddEntry(language.CMN_LanguageID, "HauseList Group");
}
else if (Parameter.CatalogType == EnumUtils.GetEnumDescription(EPrivateCatalogType.Treatment))
{
productGroup.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EProductGroup.Treatment);
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");
}
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_Release.Save(Connection, Transaction);
/*
* @create pricelist
* */
ORM_CMN_SLS_Pricelist priceList = new ORM_CMN_SLS_Pricelist();
priceList.CMN_SLS_PricelistID = pricelist_Release.Pricelist_RefID;
Dict nameDict = new Dict("cmn_sls_pricelist");
if (Parameter.IsCatalogPublic == false)
{
for (int i = 0; i < allTenantLanguages.Count; i++)
{
nameDict.AddEntry(allTenantLanguages[i].CMN_LanguageID, Parameter.CatalogName + "_" + Parameter.ValidFrom_Date.ToShortDateString() + "_" + Parameter.ValidTo_Date.ToShortDateString());
}
}
else
{
for (int i = 0; i < allTenantLanguages.Count; i++)
{
nameDict.AddEntry(allTenantLanguages[i].CMN_LanguageID, EPriceList.ABDAPriceList.ToString());
}
priceList.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EPriceList.ABDAPriceList);
}
priceList.Pricelist_Name = nameDict;
priceList.Tenant_RefID = securityTicket.TenantID;
priceList.Creation_Timestamp = DateTime.Now;
priceList.Save(Connection, Transaction);
#endregion
#region Create Supplier
var CMN_BPT_SupplierID = cls_CreateOrUpdateSupplier_for_ImportedCatalog.Invoke(Connection, Transaction, Parameter.SupplierData, securityTicket).Result;
#endregion
subscribedCatalog.SubscribedCatalog_PricelistRelease_RefID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
subscribedCatalog.PublishingSupplier_RefID = CMN_BPT_SupplierID;
subscribedCatalog.Save(Connection, Transaction);
if (Parameter.IsCatalogPublic == false)
{
var importProductsParam = new P_L3AR_IoUPfSC_1325();
importProductsParam.SubscribedCatalogID = subscribedCatalog.CMN_PRO_SubscribedCatalogID;
importProductsParam.CatalogCurrencyID = subscribedCatalog.SubscribedCatalog_Currency_RefID;
importProductsParam.CatalogLanguageID = subscribedCatalog.SubscribedCatalog_Language_RefID;
importProductsParam.ProductGroupID = productGroup.CMN_PRO_ProductGroupID;
importProductsParam.PriceListReleaseID = pricelist_Release.CMN_SLS_Pricelist_ReleaseID;
importProductsParam.Products = Parameter.Products;
cls_ImportOrUpdate_Products_for_SubscribedCatalog.Invoke(Connection, Transaction, importProductsParam, securityTicket);
}
else
{
#region Create Recommended ABDA Sales PriceList
var recommendedABDASalsesPrice_priceList = ORM_CMN_SLS_Pricelist.Query.Search(Connection, Transaction, new ORM_CMN_SLS_Pricelist.Query()
{
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EPriceList.RecommendedABDASalesPriceList),
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (recommendedABDASalsesPrice_priceList == null)
{
recommendedABDASalsesPrice_priceList = new ORM_CMN_SLS_Pricelist();
recommendedABDASalsesPrice_priceList.CMN_SLS_PricelistID = Guid.NewGuid();
recommendedABDASalsesPrice_priceList.Pricelist_Name = new Dict("cmn_sls_pricelist");
foreach (var lang in allTenantLanguages)
{
recommendedABDASalsesPrice_priceList.Pricelist_Name.AddEntry(lang.CMN_LanguageID, EPriceList.RecommendedABDASalesPriceList.ToString());
}
recommendedABDASalsesPrice_priceList.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(EPriceList.RecommendedABDASalesPriceList);
recommendedABDASalsesPrice_priceList.Tenant_RefID = securityTicket.TenantID;
recommendedABDASalsesPrice_priceList.Creation_Timestamp = DateTime.Now;
recommendedABDASalsesPrice_priceList.Save(Connection, Transaction);
ORM_CMN_SLS_Pricelist_Release recommendedABDASalsesPrice_pricelist_Release = new ORM_CMN_SLS_Pricelist_Release();
recommendedABDASalsesPrice_pricelist_Release.CMN_SLS_Pricelist_ReleaseID = Guid.NewGuid();
recommendedABDASalsesPrice_pricelist_Release.Release_Version = "v1";
recommendedABDASalsesPrice_pricelist_Release.IsPricelistAlwaysActive = true;
recommendedABDASalsesPrice_pricelist_Release.Tenant_RefID = securityTicket.TenantID;
recommendedABDASalsesPrice_pricelist_Release.Creation_Timestamp = DateTime.Now;
recommendedABDASalsesPrice_pricelist_Release.Pricelist_RefID = recommendedABDASalsesPrice_priceList.CMN_SLS_PricelistID;
recommendedABDASalsesPrice_pricelist_Release.Save(Connection, Transaction);
}
#endregion
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3CA_IC_1527 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
#region All tenant's languages
P_L2LN_GALFTID_1530 langParam = new P_L2LN_GALFTID_1530();
langParam.Tenant_RefID = securityTicket.TenantID;
var allTenantLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, langParam, securityTicket).Result;
#endregion
#region Get catalog's language or create it
// 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.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.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 create it
if (language == null)
{
language = new ORM_CMN_Language();
language.CMN_LanguageID = Guid.NewGuid();
language.ISO_639_1 = Parameter.CatalogLanguage_ISO_639_1;
language.Name = new Dict(ORM_CMN_Language.TableName);
foreach (var item in allTenantLanguages)
{
language.Name.AddEntry(item.CMN_LanguageID, "CatalogLanguage - " + Parameter.CatalogLanguage_ISO_639_1);
}
language.Creation_Timestamp = DateTime.Now;
language.Tenant_RefID = securityTicket.TenantID;
language.IsDeleted = false;
language.Save(Connection, Transaction);
}
}
#endregion
#region Get catalog's currency or create it
// check if currency with that ISO exists for Tenant
var currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217.ToUpper();
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
var currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
currencyQuery = new ORM_CMN_Currency.Query();
currencyQuery.ISO4127 = Parameter.CatalogCurrency_ISO_4217.ToLower();
currencyQuery.Tenant_RefID = securityTicket.TenantID;
currencyQuery.IsDeleted = false;
currency = ORM_CMN_Currency.Query.Search(Connection, Transaction, currencyQuery).FirstOrDefault();
if (currency == null)
{
currency = new ORM_CMN_Currency();
currency.CMN_CurrencyID = Guid.NewGuid();
currency.ISO4127 = Parameter.CatalogCurrency_ISO_4217;
currency.Name = new Dict(ORM_CMN_Currency.TableName);
foreach (var item in allTenantLanguages)
{
currency.Name.AddEntry(item.CMN_LanguageID, "CatalogCurrency - " + Parameter.CatalogCurrency_ISO_4217);
}
currency.Tenant_RefID = securityTicket.TenantID;
currency.Creation_Timestamp = DateTime.Now;
currency.Save(Connection, Transaction);
}
}
#endregion
#region save ORM_CMN_PRO_SubscribedCatalog
var businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction,
new ORM_CMN_BPT_BusinessParticipant.Query()
{
IfTenant_Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
var 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 = businessParticipant != null ? businessParticipant.CMN_BPT_BusinessParticipantID : Guid.Empty;
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;
subscribedCatalog.SubscribedCatalog_Language_RefID = language.CMN_LanguageID;
subscribedCatalog.SubscribedCatalog_Currency_RefID = currency.CMN_CurrencyID;
#region Create Supplier
var CMN_BPT_SupplierID = cls_CreateOrUpdateSupplier_for_ImportedCatalog.Invoke(Connection, Transaction, Parameter.SupplierData, securityTicket).Result;
#endregion
subscribedCatalog.PublishingSupplier_RefID = CMN_BPT_SupplierID;
subscribedCatalog.Save(Connection, Transaction);
#endregion
return(returnValue);
#endregion UserCode
}
