protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5CA_SCER_0931 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
ORM_CMN_BPT_CTM_CatalogProductExtensionRequests request = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequests();
request.Load(Connection, Transaction, Parameter.RequestID);
if (Parameter.SendAnswer)
{
ORM_USR_Account account = new ORM_USR_Account();
account.Load(Connection, Transaction, securityTicket.AccountID);
request.IfAnswerSent_By_BusinessParticipant_RefID = account.BusinessParticipant_RefID;
request.IfAnswerSent_Date = DateTime.Now;
}
request.IsAnswerSent = Parameter.SendAnswer;
request.Request_Answer = Parameter.RequestAnswer;
request.Save(Connection, Transaction);
#region Add products
ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product product = null;
if (Parameter.Products != null)
{
foreach (P_L5CA_SCER_0931a item in Parameter.Products)
{
ORM_CMN_PRO_Product.Query prodQuery = new ORM_CMN_PRO_Product.Query()
{
CMN_PRO_ProductID = item.ProductID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
};
var prod = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, prodQuery).Single();
if (String.IsNullOrEmpty(prod.ProductITL))
{
prod.ProductITL = prod.CMN_PRO_ProductID.ToString();
prod.Save(Connection, Transaction);
}
if (item.IsDeleted)
{
ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product.Query query = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product.Query();
query.CatalogProductExtensionRequest_RefID = request.CMN_BPT_CTM_CatalogProductExtensionRequestID;
query.CMN_BPT_CTM_CatalogProductExtensionRequest_ProductID = item.Request_ProductID;
//query.Tenant_RefID = securityTicket.TenantID;
//ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product.Query.SoftDelete(Connection, Transaction, query);
var itemToDelete = ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product.Query.Search(Connection, Transaction, query).SingleOrDefault();
if (itemToDelete != default(ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product))
{
itemToDelete.IsDeleted = true;
itemToDelete.Save(Connection, Transaction);
}
continue;
}
product = new ORM_CMN_BPT_CTM_CatalogProductExtensionRequest_Product();
product.CMN_BPT_CTM_CatalogProductExtensionRequest_ProductID = Guid.NewGuid();
product.CatalogProductExtensionRequest_RefID = request.CMN_BPT_CTM_CatalogProductExtensionRequestID;
product.CMN_PRO_Product_RefID = prod.CMN_PRO_ProductID;
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.Comment = "";
product.Save(Connection, Transaction);
}
}
#endregion
#region Save products in Catalog Products for Catalog Revision
if (Parameter.Products != null)
{
// Find catalog revision
var catalogRevision = ORM_CMN_PRO_Catalog_Revision.Query.Search(Connection, Transaction,
new ORM_CMN_PRO_Catalog_Revision.Query
{
PublishedBy_BusinessParticipant_RefID = Guid.Empty,
CMN_PRO_Catalog_RefID = request.RequestedFor_Catalog_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).OrderByDescending(x => x.PublishedOn_Date).FirstOrDefault();
if (catalogRevision != null)
{
foreach (P_L5CA_SCER_0931a item in Parameter.Products)
{
// Find product
var p = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction,
new ORM_CMN_PRO_Product.Query()
{
CMN_PRO_ProductID = item.ProductID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
// Find catalog product for product
var catalogProduct = ORM_CMN_PRO_Catalog_Product.Query.Search(Connection, Transaction,
new ORM_CMN_PRO_Catalog_Product.Query
{
CMN_PRO_Catalog_Revision_RefID = catalogRevision.CMN_PRO_Catalog_RevisionID,
CMN_PRO_Product_RefID = p.CMN_PRO_ProductID,
Tenant_RefID = p.Tenant_RefID,
IsDeleted = false
}).SingleOrDefault();
// If product not exist then add product to catalog products
if (catalogProduct == null)
{
// Find product variant for product
ORM_CMN_PRO_Product_Variant productVariant = null;
if (p.HasProductVariants)
{
productVariant = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction,
new ORM_CMN_PRO_Product_Variant.Query
{
CMN_PRO_Product_RefID = p.CMN_PRO_ProductID,
Tenant_RefID = p.Tenant_RefID,
IsStandardProductVariant = true,
IsDeleted = false
}).OrderByDescending(x => x.Creation_Timestamp).FirstOrDefault();
}
// Create catalog product for product
catalogProduct = new ORM_CMN_PRO_Catalog_Product();
catalogProduct.CMN_PRO_Catalog_Revision_RefID = catalogRevision.CMN_PRO_Catalog_RevisionID;
catalogProduct.CMN_PRO_Product_RefID = p.CMN_PRO_ProductID;
catalogProduct.CMN_PRO_Product_Variant_RefID = p.HasProductVariants ? productVariant.CMN_PRO_Product_VariantID : Guid.Empty;
catalogProduct.Tenant_RefID = securityTicket.TenantID;
catalogProduct.Save(Connection, Transaction);
}
else
{
if (item.IsDeleted)
{
catalogProduct.IsDeleted = true;
catalogProduct.Save(Connection, Transaction);
}
}
}
}
}
#endregion
returnValue.Result = request.CMN_BPT_CTM_CatalogProductExtensionRequestID;
return(returnValue);
#endregion UserCode
}
protected static FR_L5PR_GPCaCV_1310 Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_GPCaCV_1310 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5PR_GPCaCV_1310();
returnValue.Result = new L5PR_GPCaCV_1310();
ORM_CMN_PRO_Product product;
List <ORM_CMN_PRO_CUS_Customization> customizations = new List <ORM_CMN_PRO_CUS_Customization>();
List <ORM_CMN_PRO_CUS_Customization_Variant> customizationVariants = new List <ORM_CMN_PRO_CUS_Customization_Variant>();
#region Check if product is customizable
product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ProductID = Parameter.ProductId,
//IsCustomizable = true
}).FirstOrDefault();
if (product == null)
{
returnValue.Status = FR_Status.Error_Internal;
returnValue.ErrorMessage = String.Format("Product with ID = {0} is not customizable or does not exist in database!", Parameter.ProductId.ToString());
return(returnValue);
}
#endregion
ORM_CMN_PRO_ASS_AssortmentProduct assortmentProduct;
#region Product is not part of an assortment
// If product is not part of any assortment product,
// then it is local product so take all customizations and customization variants for that product and return that as result.
assortmentProduct = ORM_CMN_PRO_ASS_AssortmentProduct.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentProduct.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Ext_CMN_PRO_Product_RefID = product.CMN_PRO_ProductID
}).FirstOrDefault();
if (assortmentProduct == null)
{
#region Retrieve all customizations and values for product
customizations = ORM_CMN_PRO_CUS_Customization.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Product_RefID = product.CMN_PRO_ProductID
});
foreach (var customization in customizations)
{
List <ORM_CMN_PRO_CUS_Customization_Variant> variants = ORM_CMN_PRO_CUS_Customization_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Customization_RefID = customization.CMN_PRO_CUS_CustomizationID
});
customizationVariants.AddRange(variants);
}
#endregion
returnValue.Result.Customizations = customizations.ToArray();
returnValue.Result.CustomizationVariants = customizationVariants.ToArray();
return(returnValue);
}
#endregion
#region Product is part of an assortment
// Find all assortment vendor products that are bound to it
List <ORM_CMN_PRO_ASS_AssortmentProduct_VendorProduct> assortmentProductVendorProducts = ORM_CMN_PRO_ASS_AssortmentProduct_VendorProduct.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentProduct_VendorProduct.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ASS_AssortmentProduct_RefID = assortmentProduct.CMN_PRO_ASS_AssortmentProductID
});
// Check if there is customization for each asortment product vendor product
int numberOfBoundProductsThatHaveCustomizations = 0;
List <Guid> boundProductIds = new List <Guid>();
foreach (var assortmentProductVendorProduct in assortmentProductVendorProducts)
{
ORM_CMN_PRO_Product vendorProduct = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ProductID = assortmentProductVendorProduct.CMN_PRO_Product_RefID,
IsCustomizable = true
}).FirstOrDefault();
if (vendorProduct == null)
{
continue;
}
bool hasCustomizations = ORM_CMN_PRO_CUS_Customization.Query.Exists(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Product_RefID = vendorProduct.CMN_PRO_ProductID
});
if (hasCustomizations)
{
numberOfBoundProductsThatHaveCustomizations++;
boundProductIds.Add(vendorProduct.CMN_PRO_ProductID);
}
}
if (numberOfBoundProductsThatHaveCustomizations == 0)
{
// Nothing!
}
else if (numberOfBoundProductsThatHaveCustomizations == 1)
{
#region Retrieve all customizations and values for product
customizations = ORM_CMN_PRO_CUS_Customization.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Product_RefID = boundProductIds[0]
});
foreach (var customization in customizations)
{
List <ORM_CMN_PRO_CUS_Customization_Variant> variants = ORM_CMN_PRO_CUS_Customization_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Customization_RefID = customization.CMN_PRO_CUS_CustomizationID
});
customizationVariants.AddRange(variants);
}
#endregion
}
else
{
#region More then one product that is bound to assortment product has variants
ORM_CMN_PRO_ASS_AssortmentVariant assortmentProductVariant = ORM_CMN_PRO_ASS_AssortmentVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Ext_CMN_PRO_Product_Variant_RefID = Parameter.ProductVariantId
}).FirstOrDefault();
if (assortmentProductVariant != null)
{
List <ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant> assortmentVariantVendorVariants = ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ASS_AssortmentVariant_RefID = assortmentProductVariant.CMN_PRO_ASS_AssortmentVariantID
});
ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant defaultAssortmentVariantVendorVariant = assortmentVariantVendorVariants.FirstOrDefault(x => x.IsDefaultVendorVariant == true);
if (defaultAssortmentVariantVendorVariant == null)
{
defaultAssortmentVariantVendorVariant = assortmentVariantVendorVariants.OrderBy(x => x.OrderSequence).FirstOrDefault();
}
if (defaultAssortmentVariantVendorVariant != null)
{
ORM_CMN_PRO_Product_Variant productVariant = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_Product_VariantID = defaultAssortmentVariantVendorVariant.CMN_PRO_Product_Variant_RefID
}).FirstOrDefault();
if (productVariant != null)
{
product = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ProductID = productVariant.CMN_PRO_Product_RefID
}).FirstOrDefault();
if (product != null)
{
customizations = ORM_CMN_PRO_CUS_Customization.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Product_RefID = product.CMN_PRO_ProductID
});
foreach (var customization in customizations)
{
List <ORM_CMN_PRO_CUS_Customization_Variant> variants = ORM_CMN_PRO_CUS_Customization_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Customization_RefID = customization.CMN_PRO_CUS_CustomizationID
});
customizationVariants.AddRange(variants);
}
}
}
}
}
#endregion
}
#endregion
returnValue.Result.Customizations = customizations.ToArray();
returnValue.Result.CustomizationVariants = customizationVariants.ToArray();
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PR_SP_1614 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var languageQuery = new ORM_CMN_Language.Query();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
var languages = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery);
var product = new ORM_CMN_PRO_Product();
if (Parameter.ProductID == Guid.Empty)
{
#region ORM_CMN_PRO_Product
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.ProductITL = String.Empty;
product.IsCustomizable = Parameter.IsCustomizable;
product.IsProduct_Article = true;
product.IsProductAvailableForOrdering = true;
product.IsImportedFromExternalCatalog = false;
product.IsProductForInternalDistributionOnly = Parameter.IsProductForInternalDistribution;
if (Parameter.CatalogRefID != null && Parameter.CatalogRefID != Guid.Empty)
{
product.IfImportedFromExternalCatalog_CatalogSubscription_RefID = Parameter.CatalogRefID;
}
product.Product_Name = new Dict(ORM_CMN_PRO_Product.TableName);
product.Product_Description = new Dict(ORM_CMN_PRO_Product.TableName);
product.PackageInfo_RefID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.IsDeleted = Parameter.IsDeleted;
product.Save(Connection, Transaction);
#endregion
}
else
{
product.Load(Connection, Transaction, Parameter.ProductID);
}
if (Parameter.Document_ID != null && Parameter.Document_ID != Guid.Empty)
{
ORM_DOC_Structure_Header structureHeader = new ORM_DOC_Structure_Header();
if (Parameter.DocumentStructureHeaderID == Guid.Empty)
{
structureHeader.Label = "Product picture";
structureHeader.Tenant_RefID = securityTicket.TenantID;
structureHeader.Save(Connection, Transaction);
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
}
ORM_DOC_Structure structure = new ORM_DOC_Structure();
if (Parameter.DocumentStructureHeaderID == Guid.Empty)
{
structure.Label = "Product picture";
structure.Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
}
ORM_DOC_Document document = new ORM_DOC_Document();
document.DOC_DocumentID = Parameter.Document_ID;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
var documentStructureID = structure.DOC_StructureID;
var assignmentID = Guid.Empty;
List <ORM_DOC_Document_2_Structure> existingDocumentStructure = new List <ORM_DOC_Document_2_Structure>();
if (Parameter.DocumentStructureHeaderID != Guid.Empty)
{
existingDocumentStructure = ORM_DOC_Document_2_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Document_2_Structure.Query()
{
StructureHeader_RefID = Parameter.DocumentStructureHeaderID
});
}
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
if (existingDocumentStructure != null && existingDocumentStructure.Count() > 0)
{
existingDocumentStructure.First().Document_RefID = document.DOC_DocumentID;
existingDocumentStructure.First().Save(Connection, Transaction);
}
else
{
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = documentStructureID;
documentStructure.StructureHeader_RefID = structure.Structure_Header_RefID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
}
}
#region ORM_CMN_PRO_Product
product.Product_Number = Parameter.ProductNumber;
foreach (var language in languages)
{
product.Product_Name.UpdateEntry(language.CMN_LanguageID, Parameter.ProductName);
product.Product_Description.UpdateEntry(language.CMN_LanguageID, Parameter.Description);
}
product.ProductType_RefID = Guid.Empty;
product.IsPlaceholderArticle = Parameter.IsDummy;
product.IsCustomizable = Parameter.IsCustomizable;
product.ProductSuccessor_RefID = Guid.Empty;
product.IsDeleted = Parameter.IsDeleted;
product.Save(Connection, Transaction);
#endregion
#region Variant
//Create default varient
var defaultVarient = new ORM_CMN_PRO_Product_Variant();
defaultVarient.CMN_PRO_Product_VariantID = Guid.NewGuid();
defaultVarient.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
defaultVarient.IsStandardProductVariant = true;
defaultVarient.Tenant_RefID = securityTicket.TenantID;
defaultVarient.VariantName = new Dict(ORM_CMN_PRO_Product_Variant.TableName);
foreach (var language in languages)
{
defaultVarient.VariantName.UpdateEntry(language.CMN_LanguageID, String.Empty);
}
defaultVarient.Save(Connection, Transaction);
#endregion
#region Customization
if (Parameter.IsCustomizable == false && Parameter.ProductID != Guid.Empty)
{
var customizations = ORM_CMN_PRO_CUS_Customization.Query.Search(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
Product_RefID = Parameter.ProductID
});
foreach (var customization in customizations)
{
ORM_CMN_PRO_CUS_Customization_Variant.Query.SoftDelete(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization_Variant.Query()
{
Customization_RefID = customization.CMN_PRO_CUS_CustomizationID
});
}
ORM_CMN_PRO_CUS_Customization.Query.SoftDelete(Connection, Transaction, new ORM_CMN_PRO_CUS_Customization.Query()
{
Product_RefID = Parameter.ProductID
});
}
#endregion
returnValue.Result = product.CMN_PRO_ProductID;
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_L3DO_SDO_1801 Execute(DbConnection Connection, DbTransaction Transaction, P_L3DO_SDO_1801 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L3DO_SDO_1801();
returnValue.Result = new L3DO_SDO_1801();
ORM_CMN_UniversalContactDetail universalContactDetails = new ORM_CMN_UniversalContactDetail();
universalContactDetails.CMN_UniversalContactDetailID = Guid.NewGuid();
universalContactDetails.Contact_Email = Parameter.UniversalContactDetails.Email;
universalContactDetails.Contact_Telephone = Parameter.UniversalContactDetails.Phone;
universalContactDetails.Country_Name = Parameter.UniversalContactDetails.Country;
universalContactDetails.Country_639_1_ISOCode = Parameter.UniversalContactDetails.CountryIso;
universalContactDetails.Creation_Timestamp = DateTime.Now;
universalContactDetails.First_Name = Parameter.UniversalContactDetails.FirstName;
universalContactDetails.Last_Name = Parameter.UniversalContactDetails.LastName;
universalContactDetails.Street_Name = Parameter.UniversalContactDetails.StreetName;
universalContactDetails.Street_Number = Parameter.UniversalContactDetails.StreetNumber;
universalContactDetails.ZIP = Parameter.UniversalContactDetails.Zip;
universalContactDetails.Town = Parameter.UniversalContactDetails.Town;
universalContactDetails.Tenant_RefID = securityTicket.TenantID;
universalContactDetails.POBox = Parameter.UniversalContactDetails.POBox;
universalContactDetails.Save(Connection, Transaction);
ORM_CMN_NumberRange_UsageArea numberRangeUsageArea = ORM_CMN_NumberRange_UsageArea.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange_UsageArea.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalStaticMatchingID = NumberRangeGlobalPropertyMatchingID
}).FirstOrDefault();
if (numberRangeUsageArea == null)
{
throw new Exception(String.Format("Number range usage area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
ORM_CMN_NumberRange numberRange = ORM_CMN_NumberRange.Query.Search(Connection, Transaction, new ORM_CMN_NumberRange.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID
}).FirstOrDefault();
if (numberRange == null)
{
throw new Exception(String.Format("Number range for area with GPMID = {0} was not found.", NumberRangeGlobalPropertyMatchingID));
}
numberRange.Value_Current++;
numberRange.Save(Connection, Transaction);
string distributionOrderNumber = numberRange.FixedPrefix + numberRange.Value_Current.ToString().PadLeft(numberRange.Formatting_NumberLength, numberRange.Formatting_LeadingFillCharacter[0]);
ORM_ORD_DIS_DistributionOrder_Header header = new ORM_ORD_DIS_DistributionOrder_Header();
header.Charged_CostCenter_RefID = Parameter.IsCostCenterOrderRefID;
header.Creation_Timestamp = DateTime.Now;
header.DistributeTo_UCDAddress_RefID = universalContactDetails.CMN_UniversalContactDetailID;
header.DistributionOrderDate = DateTime.Now;
header.DistributionOrderNumber = distributionOrderNumber;
header.IfForDelivery_LogisticsProvider_RefID = Parameter.IsForDeliveryLogisticProviderRefID.ToString();
header.IfForDelivery_ShipmentType_RefID = Parameter.IsForDeliveryShipmentTypeRefID;
header.IfForPickup_PointOfSale_RefID = Parameter.IsForPickupPointOfSaleRefID;
header.IsCostCenterOrder = Parameter.IsCostCenterOrder;
header.IsDeleted = false;
header.IsForDelivery = Parameter.IsForDelivery;
header.ORD_DIS_DistributionOrder_HeaderID = Guid.NewGuid();
header.Tenant_RefID = securityTicket.TenantID;
header.InternallyCharged_Currency_RefID = Parameter.CurrencyID;
header.InternallyCharged_TotalNetPriceValue = 0;
header.IsForPickup = Parameter.IsForPickup;
foreach (var item in Parameter.DistributionOrderPositions)
{
if (item.Quantity == 0)
{
continue;
}
ORM_CMN_PRO_ASS_AssortmentVariant assortmentVariant = ORM_CMN_PRO_ASS_AssortmentVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Ext_CMN_PRO_Product_Variant_RefID = item.ProductVariantID
}).FirstOrDefault();
ORM_ORD_DIS_DistributionOrder_Position position = null;
if (assortmentVariant == null)
{
//This means that this product might be local one
position = new ORM_ORD_DIS_DistributionOrder_Position();
position.Product_RefID = item.ProductID;
position.Product_Variant_RefID = item.ProductVariantID;
}
else
{
//This means that product is from assortment and we are supposed to take orginal product.
List <ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant> assortmentVendorVariats = ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_ASS_AssortmentVariant_RefID = assortmentVariant.CMN_PRO_ASS_AssortmentVariantID
});
ORM_CMN_PRO_ASS_AssortmentVariant_VendorVariant defaultVendorVariant = assortmentVendorVariats.FirstOrDefault(x => x.IsDefaultVendorVariant == true);
if (defaultVendorVariant == null)
{
defaultVendorVariant = assortmentVendorVariats.First();
}
if (defaultVendorVariant != null)
{
ORM_CMN_PRO_Product_Variant productVariant = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_Variant.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
CMN_PRO_Product_VariantID = defaultVendorVariant.CMN_PRO_Product_Variant_RefID
}).FirstOrDefault();
if (productVariant != null)
{
position = new ORM_ORD_DIS_DistributionOrder_Position();
position.Product_RefID = productVariant.CMN_PRO_Product_RefID;
position.Product_Variant_RefID = productVariant.CMN_PRO_Product_VariantID;
}
}
}
if (position != null)
{
position.Creation_Timestamp = DateTime.Now;
position.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
position.ORD_DIS_DistributionOrder_PositionID = Guid.NewGuid();
position.Quantity = item.Quantity;
position.Tenant_RefID = securityTicket.TenantID;
position.InternallyCharged_TotalNetPriceValue = item.PriceValueTotal;
position.Save(Connection, Transaction);
if (item.DistributionOrderPositionCustomizations != null && item.DistributionOrderPositionCustomizations.Where(x => x.CustomizationVariantID != Guid.Empty).Count() > 0)
{
foreach (var itemCustomization in item.DistributionOrderPositionCustomizations)
{
if (itemCustomization.CustomizationVariantID != Guid.Empty)
{
ORM_ORD_DIS_DistributionOrder_Position_Customization customization = new ORM_ORD_DIS_DistributionOrder_Position_Customization();
customization.ORD_DIS_DistributionOrder_Position_CustomizationID = itemCustomization.DistributionOrderPositionCustomizationID;
customization.Tenant_RefID = securityTicket.TenantID;
customization.DistributionOrder_Position_RefID = position.ORD_DIS_DistributionOrder_PositionID;
customization.CustomizationVariant_Name = itemCustomization.CustomizationVariantName;
customization.Customization_Variant_RefID = itemCustomization.CustomizationVariantID;
customization.Customization_Name = itemCustomization.CustomizationName;
customization.Save(Connection, Transaction);
}
}
}
}
header.InternallyCharged_TotalNetPriceValue += position.InternallyCharged_TotalNetPriceValue;
}
header.Save(Connection, Transaction);
foreach (var item in Parameter.Documents)
{
ORM_DOC_Document document = new ORM_DOC_Document();
document.Alias = item.Alias;
document.PrimaryType = item.PrimaryType;
document.DOC_DocumentID = item.DocumentID;
document.Creation_Timestamp = DateTime.Now;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_ORD_DIS_DistributionOrder_Header_Document orderDocument = new ORM_ORD_DIS_DistributionOrder_Header_Document();
orderDocument.Creation_Timestamp = DateTime.Now;
orderDocument.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
orderDocument.Document_RefID = document.DOC_DocumentID;
orderDocument.ORD_DIS_DistributionOrder_Header_DocumentID = Guid.NewGuid();
orderDocument.Tenant_RefID = securityTicket.TenantID;
orderDocument.Save(Connection, Transaction);
}
ORM_USR_Account account = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = securityTicket.AccountID,
IsDeleted = false
}).FirstOrDefault();
ORM_ORD_DIS_DistributionOrder_Header_History history = new ORM_ORD_DIS_DistributionOrder_Header_History();
history.Comment = Parameter.UniversalContactDetails.Comment;
history.Creation_Timestamp = DateTime.Now;
history.DistributionOrder_Header_RefID = header.ORD_DIS_DistributionOrder_HeaderID;
history.IsCreated = true;
history.ORD_DIS_DistributionOrder_Header_HistoryID = Guid.NewGuid();
history.Tenant_RefID = securityTicket.TenantID;
history.TriggeredBy_BusinessParticipant_RefID = account != null ? account.BusinessParticipant_RefID : Guid.Empty;
history.Save(Connection, Transaction);
returnValue.Result.DistributionOrderHeaderID = header.ORD_DIS_DistributionOrder_HeaderID;
returnValue.Result.DistributionOrderNumber = header.DistributionOrderNumber;
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_SA_1614 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var languageQuery = new ORM_CMN_Language.Query();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
var languages = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery);
var product = new ORM_CMN_PRO_Product();
if (Parameter.ArticleID == Guid.Empty)
{
#region ORM_CMN_PRO_Product
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.ProductITL = Guid.NewGuid().ToString();
product.IsProduct_Article = true;
product.IsProductAvailableForOrdering = true;
product.IsImportedFromExternalCatalog = false;
product.Product_Name = new Dict(ORM_CMN_PRO_Product.TableName);
product.Product_Description = new Dict(ORM_CMN_PRO_Product.TableName);
product.PackageInfo_RefID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.IsDeleted = Parameter.IsDeleted;
#region Product picture
if (Parameter.Image != null && Parameter.Image.Document_ID != Guid.Empty)
{
ORM_DOC_Structure_Header structureHeader = new ORM_DOC_Structure_Header();
structureHeader.Label = "Product picture";
structureHeader.Tenant_RefID = securityTicket.TenantID;
structureHeader.Save(Connection, Transaction);
ORM_DOC_Structure structure = new ORM_DOC_Structure();
structure.Label = "Product picture";
structure.Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.DOC_DocumentID = Parameter.Image.Document_ID;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = structureHeader.DOC_Structure_HeaderID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.Revision = 1;
documentRevision.IsLocked = false;
documentRevision.IsLastRevision = true;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.File_Name = Parameter.Image.File_Name;
documentRevision.File_Description = Parameter.Image.File_Description;
documentRevision.File_SourceLocation = Parameter.Image.File_Source_Location;
documentRevision.File_ServerLocation = Parameter.Image.File_Server_Location;
documentRevision.File_MIMEType = Parameter.Image.File_MimeType;
documentRevision.File_Extension = Parameter.Image.File_Extension;
documentRevision.File_Size_Bytes = Parameter.Image.File_Size_Bytes;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
//add relation for product picture with product
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
}
#endregion
product.Save(Connection, Transaction);
#endregion
}
else
{
product.Load(Connection, Transaction, Parameter.ArticleID);
#region Product picture
if (Parameter.Image != null && Parameter.Image.Document_ID != Guid.Empty)
{
ORM_DOC_Structure_Header structureHeader = new ORM_DOC_Structure_Header();
structureHeader.Label = "Product picture";
structureHeader.Tenant_RefID = securityTicket.TenantID;
structureHeader.Save(Connection, Transaction);
ORM_DOC_Structure structure = new ORM_DOC_Structure();
structure.Label = "Product picture";
structure.Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.DOC_DocumentID = Parameter.Image.Document_ID;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = structureHeader.DOC_Structure_HeaderID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.Revision = 1;
documentRevision.IsLocked = false;
documentRevision.IsLastRevision = true;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.File_Name = Parameter.Image.File_Name;
documentRevision.File_Description = Parameter.Image.File_Description;
documentRevision.File_SourceLocation = Parameter.Image.File_Source_Location;
documentRevision.File_ServerLocation = Parameter.Image.File_Server_Location;
documentRevision.File_MIMEType = Parameter.Image.File_MimeType;
documentRevision.File_Extension = Parameter.Image.File_Extension;
documentRevision.File_Size_Bytes = Parameter.Image.File_Size_Bytes;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
//add relation for product picture with product
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
}
else
{
// if (Parameter.Image.IsForDeleting) if product image has to be deleted
}
#endregion
}
#region ORM_CMN_PRO_Product
product.Product_Number = Parameter.ProductNumber;
foreach (var language in languages)
{
product.Product_Name.UpdateEntry(language.CMN_LanguageID, Parameter.ArticleName);
product.Product_Description.UpdateEntry(language.CMN_LanguageID, Parameter.Description);
}
product.ProductType_RefID = Guid.Empty;
product.IsPlaceholderArticle = Parameter.IsDummy;
product.ProductSuccessor_RefID = Guid.Empty;
product.IsDeleted = Parameter.IsDeleted;
product.Save(Connection, Transaction);
#endregion
//#region ORM_CMN_PRO_Product_2_ProductCode
//var product2CodeQuery = new ORM_CMN_PRO_Product_2_ProductCode.Query();
//product2CodeQuery.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
//product2CodeQuery.Tenant_RefID = securityTicket.TenantID;
//product2CodeQuery.IsDeleted = false;
//var productCodeAssignment = ORM_CMN_PRO_Product_2_ProductCode.Query.Search(Connection, Transaction, product2CodeQuery).SingleOrDefault();
//if (productCodeAssignment == null)
//{
// #region ORM_CMN_PRO_ProductCode
#region Variant
//Create default varient
var defaultVarient = new ORM_CMN_PRO_Product_Variant();
defaultVarient.CMN_PRO_Product_VariantID = Guid.NewGuid();
defaultVarient.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
defaultVarient.IsStandardProductVariant = true;
defaultVarient.Tenant_RefID = securityTicket.TenantID;
defaultVarient.VariantName = new Dict(ORM_CMN_PRO_Product_Variant.TableName);
foreach (var language in languages)
{
defaultVarient.VariantName.UpdateEntry(language.CMN_LanguageID, String.Empty);
}
defaultVarient.Save(Connection, Transaction);
#endregion
returnValue.Result = product.CMN_PRO_ProductID;
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L3VA_SVfP_1019 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Base();
if (Parameter == null)
{
returnValue.ErrorMessage = "Parameter is null or there is no product variant defined";
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
if (Parameter.Variants == null && Parameter.Dimensions == null && Parameter.DimensionValues == null)
{
returnValue.ErrorMessage = "Variants, Dimensions and Dimension Values are not defined";
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
if (Parameter.Variants.Length == 0 && Parameter.Dimensions.Length == 0 && Parameter.DimensionValues.Length == 0)
{
returnValue.ErrorMessage = "Variants, Dimensions and Dimension Values are not defined";
returnValue.Status = FR_Status.Error_Internal;
return(returnValue);
}
#region Variants Create/Update
foreach (var variant in Parameter.Variants)
{
bool createNewVariant = false;
ORM_CMN_PRO_Product_Variant variantToCreateUpdate = new ORM_CMN_PRO_Product_Variant();
FR_Base vLoad = variantToCreateUpdate.Load(Connection, Transaction, variant.CMN_PRO_Product_VariantID);
if (vLoad.Status != FR_Status.Success || variantToCreateUpdate.CMN_PRO_Product_VariantID == Guid.Empty)
{
createNewVariant = true;
}
if (createNewVariant)
{
variantToCreateUpdate.CMN_PRO_Product_VariantID = variant.CMN_PRO_Product_VariantID;
variantToCreateUpdate.CMN_PRO_Product_RefID = Parameter.ProductID;
variantToCreateUpdate.Creation_Timestamp = DateTime.Now;
variantToCreateUpdate.Tenant_RefID = securityTicket.TenantID;
variantToCreateUpdate.ProductVariantITL = "";
variantToCreateUpdate.ProductVariant_DocumentationStructure_RefID = Guid.Empty;
variantToCreateUpdate.VariantName = variant.VariantName;
variantToCreateUpdate.IsDeleted = false;
}
variantToCreateUpdate.IsImportedFromExternalCatalog = variant.IsImportedFromExternalCatalog;
variantToCreateUpdate.IsObsolete = variant.IsObsolete;
variantToCreateUpdate.IsProductAvailableForOrdering = variant.IsProductAvailableForOrdering;
variantToCreateUpdate.IsStandardProductVariant = variant.IsStandardProductVariant;
variantToCreateUpdate.Modification_Timestamp = DateTime.Now;
variantToCreateUpdate.Save(Connection, Transaction);
}
#endregion
#region Dimensions Create/Update
foreach (var dimension in Parameter.Dimensions)
{
bool createNewDimension = false;
ORM_CMN_PRO_Dimension dimensionToCreateUpdate = new ORM_CMN_PRO_Dimension();
FR_Base dLoad = dimensionToCreateUpdate.Load(Connection, Transaction, dimension.CMN_PRO_DimensionID);
if (dLoad.Status != FR_Status.Success || dimensionToCreateUpdate.CMN_PRO_DimensionID == Guid.Empty)
{
createNewDimension = true;
}
if (createNewDimension)
{
dimensionToCreateUpdate.CMN_PRO_DimensionID = dimension.CMN_PRO_DimensionID;
dimensionToCreateUpdate.Abbreviation = dimension.Abbreviation;
dimensionToCreateUpdate.Creation_Timestamp = DateTime.Now;
dimensionToCreateUpdate.DimensionName = dimension.DimensionName;
dimensionToCreateUpdate.IsDeleted = false;
dimensionToCreateUpdate.IsDimensionTemplate = false;
dimensionToCreateUpdate.Product_RefID = Parameter.ProductID;
dimensionToCreateUpdate.Tenant_RefID = securityTicket.TenantID;
}
dimensionToCreateUpdate.OrderSequence = dimension.OrderSequence;
dimensionToCreateUpdate.Modification_Timestamp = DateTime.Now;
dimensionToCreateUpdate.Save(Connection, Transaction);
}
#endregion
#region Dimension Values Create/Update
foreach (var dimensionValue in Parameter.DimensionValues)
{
bool createNewDimensionValue = false;
ORM_CMN_PRO_Dimension_Value dimensionValueToCreateUpdate = new ORM_CMN_PRO_Dimension_Value();
FR_Base dvLoad = dimensionValueToCreateUpdate.Load(Connection, Transaction, dimensionValue.CMN_PRO_Dimension_ValueID);
if (dvLoad.Status != FR_Status.Success || dimensionValueToCreateUpdate.CMN_PRO_Dimension_ValueID == Guid.Empty)
{
createNewDimensionValue = true;
}
if (createNewDimensionValue)
{
dimensionValueToCreateUpdate.CMN_PRO_Dimension_ValueID = dimensionValue.CMN_PRO_Dimension_ValueID;
dimensionValueToCreateUpdate.Creation_Timestamp = DateTime.Now;
dimensionValueToCreateUpdate.Dimensions_RefID = dimensionValue.Dimension_RefID;
dimensionValueToCreateUpdate.DimensionValue_Text = dimensionValue.DimensionValue_Text;
dimensionValueToCreateUpdate.IsDeleted = false;
dimensionValueToCreateUpdate.Tenant_RefID = securityTicket.TenantID;
}
dimensionValueToCreateUpdate.Modification_Timestamp = DateTime.Now;
dimensionValueToCreateUpdate.OrderSequence = dimensionValue.OrderSequence;
dimensionValueToCreateUpdate.Save(Connection, Transaction);
}
#endregion
#region Assignments
foreach (var variant in Parameter.Variants)
{
foreach (var dimensionValue in Parameter.DimensionValues)
{
if ((variant.DimensionValue1_RefID == dimensionValue.CMN_PRO_Dimension_ValueID) || (variant.DimensionValue2_RefID == dimensionValue.CMN_PRO_Dimension_ValueID))
{
bool assignmentExists = ORM_CMN_PRO_Variant_DimensionValue.Query.Exists(Connection, Transaction, new ORM_CMN_PRO_Variant_DimensionValue.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
DimensionValue_RefID = dimensionValue.CMN_PRO_Dimension_ValueID,
ProductVariant_RefID = variant.CMN_PRO_Product_VariantID
});
if (!assignmentExists)
{
ORM_CMN_PRO_Variant_DimensionValue assignment = new ORM_CMN_PRO_Variant_DimensionValue();
assignment.CMN_PRO_Variant_DimensionValueID = Guid.NewGuid();
assignment.Creation_Timestamp = DateTime.Now;
assignment.DimensionValue_RefID = dimensionValue.CMN_PRO_Dimension_ValueID;
assignment.IsDeleted = false;
assignment.Modification_Timestamp = DateTime.Now;
assignment.ProductVariant_RefID = variant.CMN_PRO_Product_VariantID;
assignment.Tenant_RefID = securityTicket.TenantID;
assignment.Save(Connection, Transaction);
}
}
}
}
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5AS_SAP_1515 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Base();
var defaultLanguages = ORM_CMN_Language.Query.Search(Connection, Transaction, new ORM_CMN_Language.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
List <P_L3AS_SAVP_0004> parameterVendorProduct = new List <P_L3AS_SAVP_0004>();
List <P_L3AS_SAVV_0040> parameterVendorVariants = new List <P_L3AS_SAVV_0040>();
#region ImportCatalogProducts
foreach (var productFromCatalog in Parameter.Products.Where(x => !string.IsNullOrEmpty(x.ProductITL)).ToList())
{
P_L5PR_IPfC_1648 importProductFromCatalogParameter = new P_L5PR_IPfC_1648();
importProductFromCatalogParameter.Product = new ProductsForImport();
importProductFromCatalogParameter.Product.CatalogITL = productFromCatalog.CatalogITL;
importProductFromCatalogParameter.Product.Code = productFromCatalog.Code;
importProductFromCatalogParameter.Product.Custom = productFromCatalog.Custom;
importProductFromCatalogParameter.Product.Description = productFromCatalog.Description;
importProductFromCatalogParameter.Product.Name = productFromCatalog.Name;
importProductFromCatalogParameter.Product.LongName = productFromCatalog.LongName;
importProductFromCatalogParameter.Product.ProductITL = productFromCatalog.ProductITL;
importProductFromCatalogParameter.Product.Variants = new List <Variant>();
foreach (var variant in productFromCatalog.Variants)
{
importProductFromCatalogParameter.Product.Variants.Add(variant);
}
importProductFromCatalogParameter.Product.Customizations = new List <Customization>();
if (productFromCatalog.Customizations != null)
{
foreach (var customization in productFromCatalog.Customizations)
{
importProductFromCatalogParameter.Product.Customizations.Add(customization);
}
}
importProductFromCatalogParameter.Product.Vat = productFromCatalog.Vat;
Guid productID = cls_Import_Product_from_Catalog.Invoke(Connection, Transaction, importProductFromCatalogParameter, securityTicket).Result;
Parameter.Products.Where(x => x.ProductITL == productFromCatalog.ProductITL).ToList().ForEach(x => x.LocalProductID = productID);
}
#endregion import
foreach (var parameterProduct in Parameter.Products)
{
ORM_CMN_PRO_Product productDB = new ORM_CMN_PRO_Product();
#region loadProduct
productDB.Load(Connection, Transaction, parameterProduct.LocalProductID);
Guid originalProductId = productDB.CMN_PRO_ProductID;
#endregion
P_L3AS_GNoPiAfP_1512 parameterAssortmentProductExists = new P_L3AS_GNoPiAfP_1512();
parameterAssortmentProductExists.AssortmentID = Parameter.AssortmentID;
parameterAssortmentProductExists.ProductRefID = originalProductId;
int numberOfProductsInAssortment = cls_Get_Number_of_Products_in_Assortment_for_ProductID.Invoke(Connection, Transaction, parameterAssortmentProductExists, securityTicket).Result.NumberOfProducts;
if (numberOfProductsInAssortment == 0)
{
#region SaveProductCopy
ORM_CMN_PRO_Product productCopyToCreate = new ORM_CMN_PRO_Product();
productCopyToCreate.CMN_PRO_ProductID = Guid.NewGuid();
productCopyToCreate.ProductITL = string.Empty;
productCopyToCreate.IsProduct_Article = true;
productCopyToCreate.IsProductAvailableForOrdering = true;
productCopyToCreate.IsImportedFromExternalCatalog = false;
productCopyToCreate.IsProductForInternalDistributionOnly = true;
productCopyToCreate.Product_Name = new Dict(ORM_CMN_PRO_Product.TableName);
productCopyToCreate.Product_Description = new Dict(ORM_CMN_PRO_Product.TableName);
productCopyToCreate.PackageInfo_RefID = Guid.NewGuid();
productCopyToCreate.Creation_Timestamp = DateTime.Now;
productCopyToCreate.Tenant_RefID = securityTicket.TenantID;
productCopyToCreate.IsDeleted = false;
productCopyToCreate.Save(Connection, Transaction);
productCopyToCreate.Product_Number = productDB.Product_Number;
foreach (var lang in defaultLanguages)
{
productCopyToCreate.Product_Name.UpdateEntry(lang.CMN_LanguageID, productDB.Product_Name.Contents.FirstOrDefault().Content);
productCopyToCreate.Product_Description.UpdateEntry(lang.CMN_LanguageID, productDB.Product_Description.Contents.FirstOrDefault().Content);
}
productCopyToCreate.ProductType_RefID = Guid.Empty;
productCopyToCreate.ProductSuccessor_RefID = Guid.Empty;
productCopyToCreate.IsDeleted = false;
var productDocumentStructureRefID = Guid.NewGuid();
if (productDB.Product_DocumentationStructure_RefID != Guid.Empty)
{
productCopyToCreate.Product_DocumentationStructure_RefID = productDocumentStructureRefID;
}
productCopyToCreate.Save(Connection, Transaction);
#endregion
#region copyPicture
if (productDB.Product_DocumentationStructure_RefID != Guid.Empty)
{
var documentStructureHeaders = ORM_DOC_Structure_Header.Query.Search(Connection, Transaction, new ORM_DOC_Structure_Header.Query {
DOC_Structure_HeaderID = productDB.Product_DocumentationStructure_RefID
});
if (documentStructureHeaders != null && documentStructureHeaders.Count() > 0)
{
var documentStructureHeader = documentStructureHeaders.First();
ORM_DOC_Structure_Header docStructureHeaderToCreate = new ORM_DOC_Structure_Header();
docStructureHeaderToCreate.DOC_Structure_HeaderID = productDocumentStructureRefID;
docStructureHeaderToCreate.IsDeleted = false;
docStructureHeaderToCreate.Label = documentStructureHeader.Label;
docStructureHeaderToCreate.Tenant_RefID = securityTicket.TenantID;
docStructureHeaderToCreate.Save(Connection, Transaction);
var documentStructures = ORM_DOC_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Structure.Query
{
Structure_Header_RefID = documentStructureHeader.DOC_Structure_HeaderID
});
var documentStructureID = Guid.NewGuid();
if (documentStructures != null && documentStructures.Count() > 0)
{
var documentStructure = documentStructures.First();
ORM_DOC_Structure structureToCreate = new ORM_DOC_Structure();
structureToCreate.Label = "Product picture";
structureToCreate.DOC_StructureID = documentStructureID;
structureToCreate.Structure_Header_RefID = docStructureHeaderToCreate.DOC_Structure_HeaderID;
structureToCreate.CreatedBy_Account_RefID = securityTicket.AccountID;
structureToCreate.Tenant_RefID = securityTicket.TenantID;
structureToCreate.Save(Connection, Transaction);
var document2DocumentStructures = ORM_DOC_Document_2_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Document_2_Structure.Query
{
Structure_RefID = documentStructure.DOC_StructureID
});
if (document2DocumentStructures != null && document2DocumentStructures.Count() > 0)
{
var document2DocumentStructure = document2DocumentStructures.First();
var documentService = InfrastructureFactory.CreateDocumentService();
var webClient = new WebClient();
var imageBytes = webClient.DownloadData(documentService.GenerateDownloadLink(document2DocumentStructure.Document_RefID));
var documentID = documentService.UploadDocument(imageBytes, productCopyToCreate.Product_Number, securityTicket.SessionTicket, null, null);
ORM_DOC_Document documentToCreate = new ORM_DOC_Document();
documentToCreate.DOC_DocumentID = documentID;
documentToCreate.Tenant_RefID = securityTicket.TenantID;
documentToCreate.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructureToSave = new ORM_DOC_Document_2_Structure();
documentStructureToSave.Document_RefID = documentToCreate.DOC_DocumentID;
documentStructureToSave.Structure_RefID = structureToCreate.DOC_StructureID;
documentStructureToSave.StructureHeader_RefID = docStructureHeaderToCreate.DOC_Structure_HeaderID;
documentStructureToSave.Tenant_RefID = securityTicket.TenantID;
documentStructureToSave.Save(Connection, Transaction);
}
}
}
}
#endregion
var dimensionsDb = ORM_CMN_PRO_Dimension.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Dimension.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Product_RefID = originalProductId
});
List <ORM_CMN_PRO_Dimension_Value> dimensionValuesToCreate = new List <ORM_CMN_PRO_Dimension_Value>();
#region SaveDimensions
foreach (var dimensionDb in dimensionsDb)
{
var dimensionName = dimensionDb.DimensionName;
var dimensionID = dimensionDb.CMN_PRO_DimensionID;
ORM_CMN_PRO_Dimension dimensionCopyToCreate = new ORM_CMN_PRO_Dimension();
dimensionCopyToCreate.CMN_PRO_DimensionID = Guid.NewGuid();
dimensionCopyToCreate.Creation_Timestamp = DateTime.Now;
dimensionCopyToCreate.DimensionName = new Dict(ORM_CMN_PRO_Dimension.TableName);
dimensionCopyToCreate.IsDeleted = false;
dimensionCopyToCreate.IsDimensionTemplate = false;
dimensionCopyToCreate.Product_RefID = productCopyToCreate.CMN_PRO_ProductID;
dimensionCopyToCreate.Tenant_RefID = securityTicket.TenantID;
dimensionCopyToCreate.OrderSequence = dimensionDb.OrderSequence;
dimensionCopyToCreate.Modification_Timestamp = DateTime.Now;
dimensionCopyToCreate.Save(Connection, Transaction);
foreach (var lang in defaultLanguages)
{
dimensionCopyToCreate.DimensionName.UpdateEntry(lang.CMN_LanguageID, dimensionName.Contents.FirstOrDefault().Content);
}
dimensionCopyToCreate.Save(Connection, Transaction);
var dimensionValuesDb = ORM_CMN_PRO_Dimension_Value.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Dimension_Value.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
Dimensions_RefID = dimensionID
});
dimensionValuesDb.ForEach(x => x.Dimensions_RefID = dimensionCopyToCreate.CMN_PRO_DimensionID);
dimensionValuesToCreate.AddRange(dimensionValuesDb);
}
#endregion
var productVariantsDb = ORM_CMN_PRO_Product_Variant.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product_Variant.Query
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
CMN_PRO_Product_RefID = originalProductId
});
#region AssortmentProductSave
ORM_CMN_PRO_ASS_AssortmentProduct assortmentProductToCreate = new ORM_CMN_PRO_ASS_AssortmentProduct();
assortmentProductToCreate.CMN_PRO_ASS_AssortmentProductID = Guid.NewGuid();
assortmentProductToCreate.Ext_CMN_PRO_Product_RefID = productCopyToCreate.CMN_PRO_ProductID;
assortmentProductToCreate.IsDeleted = false;
assortmentProductToCreate.Tenant_RefID = securityTicket.TenantID;
assortmentProductToCreate.Save(Connection, Transaction);
#endregion
#region Assortment Vendor Product Save
P_L3AS_SAVP_0004 parameterVendorProductItem = new P_L3AS_SAVP_0004();
parameterVendorProductItem.AssortmentProductID = assortmentProductToCreate.CMN_PRO_ASS_AssortmentProductID;
parameterVendorProductItem.ProductRefID = originalProductId;
parameterVendorProduct.Add(parameterVendorProductItem);
ORM_CMN_PRO_ASS_AssortmentProduct_VendorProduct assortmentVendorProductToCreate = new ORM_CMN_PRO_ASS_AssortmentProduct_VendorProduct();
#endregion
#region Assortment2Assortment Product save
ORM_CMN_PRO_ASS_Assortment_2_AssortmentProduct assortmentToAssortmentProductToCreate = new ORM_CMN_PRO_ASS_Assortment_2_AssortmentProduct();
assortmentToAssortmentProductToCreate.AssignmentID = Guid.NewGuid();
assortmentToAssortmentProductToCreate.CMN_PRO_ASS_Assortment_Product_RefID = assortmentProductToCreate.CMN_PRO_ASS_AssortmentProductID;
assortmentToAssortmentProductToCreate.CMN_PRO_ASS_Assortment_RefID = Parameter.AssortmentID;
assortmentToAssortmentProductToCreate.IsDeleted = false;
assortmentToAssortmentProductToCreate.Tenant_RefID = securityTicket.TenantID;
assortmentToAssortmentProductToCreate.Save(Connection, Transaction);
#endregion
List <ORM_CMN_PRO_Variant_DimensionValue> variantDimensionValueAssignmentToCreate = new List <ORM_CMN_PRO_Variant_DimensionValue>();
foreach (var productVariantDb in productVariantsDb)
{
#region ProductVariant Save
ORM_CMN_PRO_ASS_DistributionPrice distributionPriceToCreate = new ORM_CMN_PRO_ASS_DistributionPrice();
distributionPriceToCreate.CMN_PRO_ASS_DistributionPriceID = Guid.NewGuid();
distributionPriceToCreate.IsDeleted = false;
distributionPriceToCreate.Tenant_RefID = securityTicket.TenantID;
distributionPriceToCreate.Save(Connection, Transaction);
ORM_CMN_PRO_Product_Variant productVariantToCreate = new ORM_CMN_PRO_Product_Variant();
productVariantToCreate.CMN_PRO_Product_VariantID = Guid.NewGuid();
productVariantToCreate.CMN_PRO_Product_RefID = productCopyToCreate.CMN_PRO_ProductID;
productVariantToCreate.Creation_Timestamp = DateTime.Now;
productVariantToCreate.Tenant_RefID = securityTicket.TenantID;
productVariantToCreate.ProductVariantITL = "";
productVariantToCreate.ProductVariant_DocumentationStructure_RefID = Guid.Empty;
productVariantToCreate.VariantName = new Dict(ORM_CMN_PRO_Product_Variant.TableName);
productVariantToCreate.IsDeleted = false;
productVariantToCreate.IsStandardProductVariant = productVariantDb.IsStandardProductVariant;
productVariantToCreate.IsImportedFromExternalCatalog = false;
productVariantToCreate.Modification_Timestamp = DateTime.Now;
productVariantToCreate.Save(Connection, Transaction);
foreach (var lang in defaultLanguages)
{
productVariantToCreate.VariantName.UpdateEntry(lang.CMN_LanguageID, productVariantDb.VariantName.Contents.FirstOrDefault().Content);
}
productVariantToCreate.Save(Connection, Transaction);
#endregion
#region dimensionValuesAssignemnt
var assignmentExists = ORM_CMN_PRO_Variant_DimensionValue.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Variant_DimensionValue.Query
{
Tenant_RefID = securityTicket.TenantID,
ProductVariant_RefID = productVariantDb.CMN_PRO_Product_VariantID
});
foreach (var variantAssignment in assignmentExists)
{
variantAssignment.IsDeleted = false;
variantAssignment.ProductVariant_RefID = productVariantToCreate.CMN_PRO_Product_VariantID;
variantAssignment.Tenant_RefID = securityTicket.TenantID;
variantDimensionValueAssignmentToCreate.Add(variantAssignment);
}
#endregion
#region AddVariantToAssortment
ORM_CMN_PRO_ASS_AssortmentVariant assortmentVariantToCreate = new ORM_CMN_PRO_ASS_AssortmentVariant();
assortmentVariantToCreate.CMN_PRO_ASS_AssortmentVariantID = Guid.NewGuid();
assortmentVariantToCreate.Ext_CMN_PRO_Product_Variant_RefID = productVariantToCreate.CMN_PRO_Product_VariantID;
assortmentVariantToCreate.IsDeleted = false;
assortmentVariantToCreate.DistributionPrice_RefID = distributionPriceToCreate.CMN_PRO_ASS_DistributionPriceID;
assortmentVariantToCreate.Tenant_RefID = securityTicket.TenantID;
assortmentVariantToCreate.Save(Connection, Transaction);
#endregion
P_L3AS_SAVV_0040 parameterVendorVariantItem = new P_L3AS_SAVV_0040();
parameterVendorVariantItem.AssortmentVariantID = assortmentVariantToCreate.CMN_PRO_ASS_AssortmentVariantID;
parameterVendorVariantItem.ProductVariantID = productVariantDb.CMN_PRO_Product_VariantID;
parameterVendorVariantItem.OrderSequence = 1;
parameterVendorVariantItem.IsDefaultVendorVariant = true;
parameterVendorVariants.Add(parameterVendorVariantItem);
}
#region SaveDimensionValuesAndAssignment
foreach (var dimensionValueToCreate in dimensionValuesToCreate)
{
var valueName = dimensionValueToCreate.DimensionValue_Text;
var valueID = dimensionValueToCreate.CMN_PRO_Dimension_ValueID;
ORM_CMN_PRO_Dimension_Value dimensionValueToCreateUpdate = new ORM_CMN_PRO_Dimension_Value();
dimensionValueToCreateUpdate.CMN_PRO_Dimension_ValueID = Guid.NewGuid();
dimensionValueToCreateUpdate.Creation_Timestamp = DateTime.Now;
dimensionValueToCreateUpdate.DimensionValue_Text = new Dict(ORM_CMN_PRO_Dimension_Value.TableName);
dimensionValueToCreateUpdate.Dimensions_RefID = dimensionValueToCreate.Dimensions_RefID;
dimensionValueToCreateUpdate.IsDeleted = false;
dimensionValueToCreateUpdate.Tenant_RefID = securityTicket.TenantID;
dimensionValueToCreateUpdate.Modification_Timestamp = DateTime.Now;
dimensionValueToCreateUpdate.OrderSequence = dimensionValueToCreate.OrderSequence;
dimensionValueToCreateUpdate.Save(Connection, Transaction);
foreach (var lang in defaultLanguages)
{
dimensionValueToCreateUpdate.DimensionValue_Text.UpdateEntry(lang.CMN_LanguageID, valueName.Contents.FirstOrDefault().Content);
}
dimensionValueToCreateUpdate.Save(Connection, Transaction);
var assignments = variantDimensionValueAssignmentToCreate.Where(x => x.DimensionValue_RefID == valueID).ToList();
foreach (var assignment in assignments)
{
ORM_CMN_PRO_Variant_DimensionValue assignmentToSave = new ORM_CMN_PRO_Variant_DimensionValue();
assignmentToSave.CMN_PRO_Variant_DimensionValueID = Guid.NewGuid();
assignmentToSave.Creation_Timestamp = DateTime.Now;
assignmentToSave.DimensionValue_RefID = dimensionValueToCreateUpdate.CMN_PRO_Dimension_ValueID;
assignmentToSave.IsDeleted = false;
assignmentToSave.Modification_Timestamp = DateTime.Now;
assignmentToSave.ProductVariant_RefID = assignment.ProductVariant_RefID;
assignmentToSave.Tenant_RefID = securityTicket.TenantID;
assignmentToSave.Save(Connection, Transaction);
}
}
#endregion
}
}
cls_Save_Assortment_Vendor_Products.Invoke(Connection, Transaction, parameterVendorProduct.ToArray(), securityTicket);
cls_Save_Assortment_Vendor_Variants.Invoke(Connection, Transaction, parameterVendorVariants.ToArray(), securityTicket);
return(returnValue);
#endregion UserCode
}
