Beispiel #1
0
        protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3D_SDT_1335 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
            });
            ORM_CMN_PRO_Dimension dimension = new ORM_CMN_PRO_Dimension();
            dimension.Load(Connection, Transaction, Parameter.CMN_PRO_DimensionID);

            if (dimension.CMN_PRO_DimensionID == null || dimension.CMN_PRO_DimensionID == Guid.Empty)
            {
                dimension.CMN_PRO_DimensionID = Parameter.CMN_PRO_DimensionID;
            }

            dimension.DimensionName       = new Dict(ORM_CMN_PRO_Dimension.TableName);
            dimension.IsDeleted           = false;
            dimension.IsDimensionTemplate = true;
            dimension.Tenant_RefID        = securityTicket.TenantID;
            dimension.Save(Connection, Transaction);
            foreach (var lang in defaultLanguages)
            {
                dimension.DimensionName.AddEntry(lang.CMN_LanguageID, Parameter.DimensionName);
            }

            var status = dimension.Save(Connection, Transaction);
            foreach (var dimensionValue in Parameter.DimensionValue)
            {
                ORM_CMN_PRO_Dimension_Value orm_dimensionValue = new ORM_CMN_PRO_Dimension_Value();
                orm_dimensionValue.Load(Connection, Transaction, dimensionValue.CMN_PRO_Dimension_ValueID);

                if (orm_dimensionValue == null || orm_dimensionValue.CMN_PRO_Dimension_ValueID == Guid.Empty)
                {
                    orm_dimensionValue.CMN_PRO_Dimension_ValueID = dimensionValue.CMN_PRO_Dimension_ValueID;
                }

                orm_dimensionValue.Dimensions_RefID    = dimension.CMN_PRO_DimensionID;
                orm_dimensionValue.DimensionValue_Text = new Dict(ORM_CMN_PRO_Dimension.TableName);
                orm_dimensionValue.OrderSequence       = dimensionValue.OrderSequence;
                orm_dimensionValue.IsDeleted           = dimensionValue.IsDeleted;
                orm_dimensionValue.Tenant_RefID        = securityTicket.TenantID;
                orm_dimensionValue.Save(Connection, Transaction);
                foreach (var lang in defaultLanguages)
                {
                    orm_dimensionValue.DimensionValue_Text.AddEntry(lang.CMN_LanguageID, dimensionValue.DimensionValue_Text);
                }
                status = orm_dimensionValue.Save(Connection, Transaction);
            }
            if (status.Status == FR_Status.Success)
            {
                returnValue.Result = dimension.CMN_PRO_DimensionID;
            }
            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
        }