Exemplos de Cuyahoga.Modules.ECommerce.Util SpHandler.AddInParameter em C# (CSharp)

Exemplo n.º 1

Arquivo: CatalogueUrlHelper.cs Projeto: xcrash/cuyahogacontrib-Cuyahoga.Modules.ECommerce

        public virtual int GetECommerceSectionId(int siteId) {
            int sectionId = 0;
            try {
                using (SpHandler sph = new SpHandler("getECommerceSectionId")) {

                    sph.AddInParameter("siteId", DbType.Int32, 1, siteId);
                    sph.ExecuteReader();

                    while (sph.DataReader.Read()) {
                        sectionId = Convert.ToInt32(sph.DataReader["sectionID"]);
                    }
                }
            } catch (Exception e) {
                LogManager.GetLogger(GetType()).Error(e);
            }

            return sectionId;
        }