Esempio n. 1
0
        /// <summary>
        /// Execute
        /// </summary>
        /// <returns></returns>
        protected override bool Execute()
        {
            //Validation of parameters and user have been successful. We may now proceed to read from the database
            var adoProduct = new Product_ADO(Ado);

            //You can only create a product in the default Language
            DTO.LngIsoCode = Configuration_BSO.GetCustomConfig("language.iso.code");

            //Duplicate product names aren't allowed, so we check first
            if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode) || adoProduct.ExistsCode(DTO.PrcCode))
            {
                Response.error = Label.Get("error.duplicate");
                return(false);
            }

            //Create the Product - and retrieve the newly created Id
            int newId = adoProduct.Create(DTO, SamAccountName);

            if (newId == 0)
            {
                Response.error = Label.Get("error.create");
                return(false);
            }
            //We must create the search keywords for this new product
            Keyword_Product_BSO_Mandatory keyBso = new Keyword_Product_BSO_Mandatory();

            keyBso.Create(Ado, DTO, newId);

            Response.data = JSONRPC.success;

            return(true);
        }
Esempio n. 2
0
        /// <summary>
        ///  Execute
        /// </summary>
        /// <returns></returns>
        protected override bool Execute()
        {
            if (DTO.LngIsoCode == null)
            {
                DTO.LngIsoCode = Configuration_BSO.GetCustomConfig("language.iso.code");
            }

            var adoProduct = new Product_ADO(Ado);
            var list       = adoProduct.Read(DTO);

            Response.data = list;

            return(true);
        }
Esempio n. 3
0
        /// <summary>
        /// Execute
        /// </summary>
        /// <returns></returns>
        protected override bool Execute()
        {
            var adoProduct = new Product_ADO(Ado);

            //attempting to delete. The number of entities deleted are passed to the entitiesDeleted variable (this is 1 for a successful delete)
            int nDeleted = adoProduct.Delete(DTO, SamAccountName);

            Log.Instance.Debug("Delete operation finished in ADO");

            if (nDeleted == 0)
            {
                Log.Instance.Debug("No record found for delete request");
                Response.error = Label.Get("error.delete");
                return(false);
            }

            Response.data = JSONRPC.success;

            return(true);
        }
Esempio n. 4
0
        /// <summary>
        /// Execute
        /// </summary>
        /// <returns></returns>
        protected override bool Execute()
        {
            var adoProduct = new Product_ADO(Ado);

            int nUpdatedProductID = 0;

            //Check if the product exists

            if (!adoProduct.ExistsCode(DTO.PrcCode))
            {
                Response.error = Label.Get("error.update");
                return(false);
            }

            //Duplicate product names aren't allowed, so we check first
            if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode) || (adoProduct.ExistsCode(DTO.PrcCodeNew) && DTO.PrcCode != DTO.PrcCodeNew))
            {
                Response.error = Label.Get("error.duplicate");
                return(false);
            }

            //We must  delete all of the mandatory product keywords for the product
            Keyword_Product_BSO_Mandatory kpBso = new Keyword_Product_BSO_Mandatory();
            int nchanged = kpBso.Delete(Ado, DTO, true);

            if (nchanged == 0)
            {
                Log.Instance.Debug("Delete of keywords failed");
            }

            //Update and retrieve the number of updated rows
            if (DTO.LngIsoCode != Configuration_BSO.GetCustomConfig("language.iso.code"))
            {
                ProductLangauge_BSO productLanguageBso = new ProductLangauge_BSO();
                nUpdatedProductID = productLanguageBso.CreateOrUpdate(DTO, Ado);

                if (nUpdatedProductID == 0)
                {
                    Log.Instance.Debug("Update of ProductLanguage failed");
                    Response.error = Label.Get("error.update");
                    return(false);
                }
            }



            if (DTO.PrcCodeNew == null)
            {
                DTO.PrcCodeNew = DTO.PrcCode;
            }

            bool IsDefault = DTO.LngIsoCode == Configuration_BSO.GetCustomConfig("language.iso.code");

            nUpdatedProductID = adoProduct.Update(DTO, IsDefault, SamAccountName);

            if (nUpdatedProductID == 0)
            {
                Log.Instance.Debug("Update of Product failed");
                Response.error = Label.Get("error.update");
                return(false);
            }



            //Finally we must recreate the mandatory keywords in line with the updated product
            kpBso.Create(Ado, DTO, nUpdatedProductID);

            Response.data = JSONRPC.success;

            return(true);
        }
Esempio n. 5
0
        /// <summary>
        /// Execute
        /// </summary>
        /// <returns></returns>
        protected override bool Execute()
        {
            var adoProduct = new Product_ADO(Ado);

            int nUpdatedProductID = 0;

            //Check if the product exists

            if (!adoProduct.ExistsCode(DTO.PrcCode))
            {
                Response.error = Label.Get("error.update");
                return(false);
            }

            //Duplicate product names aren't allowed, so we check first
            if (adoProduct.Exists(DTO.PrcValue, DTO.SbjCode)) //|| )
            {
                Response.error = Label.Get("error.duplicate");
                return(false);
            }

            if (DTO.PrcCodeNew != null)
            {
                if (adoProduct.ExistsCode(DTO.PrcCodeNew) && DTO.PrcCode != DTO.PrcCodeNew)
                {
                    Response.error = Label.Get("error.duplicate");
                    return(false);
                }
            }

            //We must  delete all of the mandatory product keywords for the product
            Keyword_Product_BSO_Mandatory kpBso = new Keyword_Product_BSO_Mandatory();
            int nchanged = kpBso.Delete(Ado, DTO, true);

            if (nchanged == 0)
            {
                Log.Instance.Debug("Delete of keywords failed");
            }

            //Update and retrieve the number of updated rows
            if (DTO.LngIsoCode != Configuration_BSO.GetCustomConfig(ConfigType.global, "language.iso.code"))
            {
                ProductLangauge_BSO productLanguageBso = new ProductLangauge_BSO();
                nUpdatedProductID = productLanguageBso.CreateOrUpdate(DTO, Ado);

                if (nUpdatedProductID == 0)
                {
                    Log.Instance.Debug("Update of ProductLanguage failed");
                    Response.error = Label.Get("error.update");
                    return(false);
                }
            }



            if (DTO.PrcCodeNew == null)
            {
                DTO.PrcCodeNew = DTO.PrcCode;
            }

            bool IsDefault = DTO.LngIsoCode == Configuration_BSO.GetCustomConfig(ConfigType.global, "language.iso.code");

            nUpdatedProductID = adoProduct.Update(DTO, IsDefault, SamAccountName);

            if (nUpdatedProductID == 0)
            {
                Log.Instance.Debug("Update of Product failed");
                Response.error = Label.Get("error.update");
                return(false);
            }



            //Finally we must recreate the mandatory keywords in line with the updated product
            kpBso.Create(Ado, DTO, nUpdatedProductID);

            //Flush the cache for search - it's now out of date
            MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_NAVIGATION_SEARCH);
            MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_NAVIGATION_READ);

            //Flush caches for each MtrCode affected by this change
            var mtrResult = adoProduct.GetMtrCodeListForProduct(DTO);

            if (mtrResult.hasData)
            {
                foreach (var mtrCode in mtrResult.data)
                {
                    MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_DATASET + mtrCode.MtrCode);
                    MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_METADATA + mtrCode.MtrCode);
                }
            }

            //Flush caches for each RlsCode affected by this change
            var rlsResult = adoProduct.GetRlsCodeListForProduct(DTO);

            if (rlsResult.hasData)

            {
                foreach (var rlsCode in rlsResult.data)
                {
                    MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_PRE_DATASET + rlsCode.RlsCode);
                    MemCacheD.CasRepositoryFlush(Resources.Constants.C_CAS_DATA_CUBE_READ_PRE_METADATA + rlsCode.RlsCode);
                }
            }

            Response.data = JSONRPC.success;

            return(true);
        }