Ir para conteúdo

rtavix

Members
  • Total de itens

    120
  • Registro em

  • Última visita

Reputação

0 Comum

Sobre rtavix

  1. rtavix

    Connection request timed out" string

    Amigos, boa tarde! Estou recebendo a seguinte mensagem de erro: Mensagem "Solicitação de conexão tem tempo limite". + OracleLogicalTransaction {Oracle.ManagedDataAccess.Client.OracleLogicalTransaction} Oracle.ManagedDataAccess.Client.OracleLogicalTransaction. Fonte: seqüência de caracteres "Oracle Data Provider para .NET, Driver gerenciado". ($ exception) .StackTrace: em OracleInternal.ConnectionPool.PoolManager`3.Get (ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, CriteriaCtx CriteriaCtx, Cadeia affinityInstanceName, Boolean bForceMatch) em OracleInternal.ConnectionPool.OraclePoolManager.Get (ConnectionString csWithNewPassword, Boolean bGetForApp, CriteriaCtx criteriaCtx, String affinityInstanceName, Boolean bForceMatch) em OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get (ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString protectedPassword, SecureString protectedProxyPassword, em NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare () em NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords (Dialect dialect, IConnectionHelper connectionHelper) em NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update (ISessionFactory sessionFactory) em NHibernate.Impl.SessionFactoryImpl. .ctor (Configuração cfg, mapeamento IMapping, configurações Settings, ouvintes EventListeners) em NHibernate.Cfg.Configuration.BuildSessionFactory () em SDPJDominio.DataAccess.NhibernateHelper.HelpThreading () na D: \ Repositório SVN \ SDP \ SDPJ \ filiais \ SDPJ-V3.1.0 \ SDPJ-102 \ SDPJDominio \ DataAccess \ NhibernateHelper.cs : linha 41 em SDPJView.ImportacaoProcessoView.ImportacaoProcesso. <> c__DisplayClass20_0. <ProcessamentoTabela> b__0 (Dados do objeto) na D: \ Repositório SVN \ SDP \ SDPJ \ ramais \ SDPJ-V3.1.0 \ SDPJ-102 \ SDPJView \ ImportacaoProcessoView \ ImportacaoProcesso .aspx.cs: linha 209 em System.Threading.Tasks.Task.InnerInvoke () em System.Threading.Tasks.Task.Execute () DataAccess, NhibernateHelp: using System; using System.Collections.Generic; using System.Linq; using System.Text; using NHibernate.Mapping.Attributes; using NHibernate.Cfg; using NHibernate; using System.IO; using NHibernate.Context; using System.Reflection; using Oracle.ManagedDataAccess.Client; namespace SDPJDominio.DataAccess { public class NhibernateHelper { private ISessionFactory sessionFactory; public static ISession GetSession () { if (! CurrentSessionContext.HasBind (Instance.GetSessionFactory ())) CurrentSessionContext.Bind (Instance.GetSessionFactory (). OpenSession ()); return Instance.GetSessionFactory (). GetCurrentSession (); } public static ISessionFactory HelpThreading () { MemoryStream stream = new System.IO.MemoryStream (); HbmSerializer.Default.Validate = true; //HbmSerializer.Default.Serialize(stream, AppDomain.CurrentDomain.GetAssemblies () .Where (w => w.FullName.Contains ("SDPJDomain").) FirstOrDefault ()); HbmSerializer.Default.Serialize (stream, System.Reflection.Assembly.GetExecutingAssembly ()); stream.Position = 0; Configuration configuration = new Configuration (); configuration.Configure (); configuration.SetProperty ("connection.connection_string", ConfigNhibernate.getConfig ()); configuration.SetProperty ("current_session_context_class", "thread_static"); configuration.AddInputStream (stream); stream.Close (); Instance.sessionFactory = configuration.BuildSessionFactory (); return Instance.sessionFactory; } public NhibernateHelper () { MemoryStream stream = new System.IO.MemoryStream (); HbmSerializer.Default.Validate = true; HbmSerializer.Default.Serialize (stream, System.Reflection.Assembly.GetExecutingAssembly ()); stream.Position = 0; Configuration configuration = new Configuration (); configuration.Configure (); configuration.SetProperty ("connection.connection_string", ConfigNhibernate.getConfig ()); // add this line configuration.AddInputStream (stream); stream.Close (); sessionFactory = configuration.BuildSessionFactory (); } public static ISessionFactory SessionFactory { get {return Instance.sessionFactory; } } private ISessionFactory GetSessionFactory () { return sessionFactory; } public static NhibernateHelper Instance { get { return CreateSessionGenerator. } } public static ISession OpenSession () { return Instance.GetSessionFactory (). OpenSession (); } public static void ReloadSession (object obj) { SessionRefresh (obj); } public static ISession SessionCurrent { get { if (! CurrentSessionContext.HasBind (Instance.GetSessionFactory ())) return null; return Instance.GetSessionFactory (). GetCurrentSession (); } } class CreateSessionKey { internal static readonly NhibernateHelperSession Manager = new NhibernateHelper (); } } } line: 209 Action <object> processing = (data) => { NHibernate.Context.ThreadStaticSessionContext.Bind (NhibernateHelper.HelpThreading ().OpenSession ()); } WebConfig: <?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <section name="extnet" type="Ext.Net.GlobalConfig" requirePermission="false" /> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <section name="SDPJView.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </sectionGroup> <sectionGroup name="businessObjects"> <sectionGroup name="crystalReports"> <section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" /> <section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" /> </sectionGroup> </sectionGroup> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </configSections> <extnet theme="Gray" /> <location path="Content/temp"> <system.web> <authorization> <allow users="?" /> </authorization> </system.web> </location> <location path="Content/css"> <system.web> <authorization> <allow users="?" /> </authorization> </system.web> </location> <location path="Content/img_SDPJ"> <system.web> <authorization> <allow users="?" /> </authorization> </system.web> </location> <location path="Autenticacao"> <system.web> <authorization> <allow users="?" /> </authorization> </system.web> </location> <appSettings> <add key="CodigoSistema" value="SDPJ" /> <add key="CodigoModulo" value="INTRANET" /> <add key="CrystalImageCleaner-AutoStart" value="true" /> <add key="CrystalImageCleaner-Sleep" value="60000" /> <add key="CrystalImageCleaner-Age" value="120000" /> </appSettings> <connectionStrings> <add name="ADConnectionString" connectionString="LDAP://net.sefaz.es.gov.br" /> <add name="ConnectionString" connectionString="DATA SOURCE=DAPP;PASSWORD=A#$##$$;USER ID=APL_SDP" providerName="Oracle.DataAccess.Client" /> </connectionStrings> <businessObjects> <crystalReports> <rptBuildProvider> <add embedRptInResource="true" /> </rptBuildProvider> <crystalReportViewer> <add key="ResourceUri" value="../../aspnet_client/system_web/4_0_30319/crystalreportviewers13" /> </crystalReportViewer> </crystalReports> </businessObjects> <system.web> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <siteMap defaultProvider="XmlSiteMapProvider" enabled="true"> <providers> <add name="XmlSiteMapProvider" description="Default SiteMap provider" type="System.Web.XmlSiteMapProvider" siteMapFile="~/Content/Navigation.sitemap" securityTrimmingEnabled="true" /> </providers> </siteMap> <compilation debug="true"> <assemblies> <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" /> <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /> <add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> <add assembly="CrystalDecisions.ReportSource, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> <add assembly="CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> <add assembly="CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> </assemblies> </compilation> <globalization fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8" culture="pt-br" /> <!--<globalization enableClientBasedCulture="false" requestEncoding="utf-8" responseEncoding="utf-8" fileEncoding="iso-8859-1" responseHeaderEncoding="utf-8" resourceProviderFactoryType="string" enableBestFitResponseEncoding="true" culture="pt-BR" uiCulture="pt-BR"/>--> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authorization> <deny users="?" /> </authorization> <authentication mode="Forms"> <forms loginUrl="~/Autenticacao/Login.aspx" timeout="20" defaultUrl="~/Default.aspx" slidingExpiration="true" /> </authentication> <sessionState timeout="10" /> <machineKey validationKey="C50B3C89CB21F4F1422FF158A5B42D0E8DB8CB5CDA1742572A487D9401E3400267682B202B746511891C1BAF47F8D25C07F6C39A104696DB51F17C529AD3CABE" decryptionKey="8A9BE8FD67AF6979E7D20198CFEA50DD3D3799C77AF2B72F" validation="SHA1" /> <membership defaultProvider="SDPJMembershipProvider"> <providers> <clear /> <add name="SDPJMembershipProvider" type="SDPJView.Seguranca.SDPJMembershipProvider" connectionStringName="ADConnectionString" writeExceptionsToEventLog="false" applicationName="/SDPJView" /> </providers> </membership> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors> --> <customErrors mode="Off" /> <!--<pages validateRequest="false" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>--> <pages controlRenderingCompatibilityVersion="4.0" clientIDMode="AutoID"> <controls> <add assembly="Ext.Net" namespace="Ext.Net" tagPrefix="ext" /> </controls> </pages> <httpHandlers> <add path="*/ext.axd" verb="*" type="Ext.Net.ResourceHandler" validate="false" /> <add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" /> </httpHandlers> <httpModules> <add name="DirectRequestModule" type="Ext.Net.DirectRequestModule, Ext.Net" /> </httpModules> <httpRuntime maxRequestLength="102400" /> </system.web> <!-- The system.webServer section is required for running ASP.NET AJAX under Internet Information Services 7.0. It is not necessary for previous version of IIS. --> <system.webServer> <httpErrors errorMode="Detailed" /> <asp scriptErrorSentToBrowser="true" /> <validation validateIntegratedModeConfiguration="false" /> <modules runAllManagedModulesForAllRequests="true"> <add name="DirectRequestModule" preCondition="managedHandler" type="Ext.Net.DirectRequestModule, Ext.Net" /> </modules> <handlers accessPolicy="Read, Execute, Script"> <add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" /> <add name="DirectRequestHandler" verb="*" path="*/ext.axd" preCondition="integratedMode" type="Ext.Net.ResourceHandler" /> <add name="AboMapperCustom-9501872-V4" path="*.axd" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="AboMapperCustom-9501871-V4.0" path="*.aspx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="AboMapperCustom-9501870-V4.0" path="*.asmx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="AboMapperCustom-9501869-V4.0" path="*.ashx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="AboMapperCustom-9501868-V4.0" path="*.ascx" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="AboMapperCustom-9501867-V4.0" path="*.asax" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="ScriptResource" path="ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" resourceType="Unspecified" requireAccess="Script" preCondition="integratedMode" /> </handlers> </system.webServer> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="AjaxControlToolkit" publicKeyToken="28f01b0e84b6d53e" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-3.0.30930.28736" newVersion="4.1.50508.0" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" /> <bindingRedirect oldVersion="1.0.0.0-4.5.10" newVersion="4.5.11" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="Ext.Net.Utilities" publicKeyToken="2c34ac34702a3c23" /> <bindingRedirect oldVersion="0.0.0.0-2.2.0" newVersion="2.2.1" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="Transformer.NET" publicKeyToken="e274d618e7c603a7" /> <bindingRedirect oldVersion="0.0.0.0-2.1.0" newVersion="2.1.1" /> </dependentAssembly> <dependentAssembly> <publisherPolicy apply="no" /> <assemblyIdentity name="Oracle.ManagedDataAccess" publicKeyToken="89b483f429c47342" culture="neutral" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="CrystalDecisions.CrystalReports.Engine" publicKeyToken="692fbea5521e1304" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-13.0.2000.0" newVersion="13.0.2000.0" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="CrystalDecisions.Shared" publicKeyToken="692fbea5521e1304" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-13.0.3500.0" newVersion="13.0.3500.0" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="CrystalDecisions.ReportSource" publicKeyToken="692fbea5521e1304" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-13.0.2000.0" newVersion="13.0.2000.0" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="NHibernate" publicKeyToken="aa95f207798dfdb4" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-4.1.0.4000" newVersion="4.1.0.4000" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="Iesi.Collections" publicKeyToken="aa95f207798dfdb4" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" /> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="Castle.Core" publicKeyToken="407dd0808d44fbdc" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-1.1.0.0" newVersion="1.1.0.0" /> </dependentAssembly> </assemblyBinding> </runtime> <system.serviceModel> <bindings> <basicHttpBinding> <binding name="IntegrationWSBindingP" closeTimeout="00:10:50" openTimeout="00:10:05" receiveTimeout="00:10:05" sendTimeout="00:10:05" maxReceivedMessageSize="10000000"> <security mode="Transport" /> </binding> <binding name="IntegrationWSBindingH" closeTimeout="00:10:50" openTimeout="00:10:05" receiveTimeout="00:10:05" sendTimeout="00:10:05" maxReceivedMessageSize="10000000" /> </basicHttpBinding> </bindings> <client> <endpoint address="https://portalinternet.banestes.com.br/br.com.banestes.djw.integration.server/IntegrationWSPort" binding="basicHttpBinding" bindingConfiguration="IntegrationWSBindingP" contract="IntegracaoBanestesProducao.IntegrationWS" name="IntegrationWSPort" /> <endpoint address="http://portalinternet.h.banestes.com.br/br.com.banestes.djw.integration.server/IntegrationWSPort" binding="basicHttpBinding" bindingConfiguration="IntegrationWSBindingH" contract="IntegracaoBanestesHomologacao.IntegrationWS" name="IntegrationWSPort1" /> </client> <serviceHostingEnvironment aspNetCompatibilityEnabled="true" /> <standardEndpoints> <webScriptEndpoint> <standardEndpoint name="" crossDomainScriptAccessEnabled="true" /> </webScriptEndpoint> </standardEndpoints> </system.serviceModel> </configuration>
  2. rtavix

    Dúvida com carácter especiais.

    quintelab, tenho esse método que faço para outros campos, porém não consigo fazer funcionar para o campo CEP. private void VerificacaoPreliminar(IEnumerable<DataRow> dados) { int i = 4; bool importado = false; foreach (var linha in dados) { i++; //Verifica se nenhuma planilha com o numSEP informado já não foi importada if (!linha.ItemArray[17].ToString().Equals("")) { if (aplProcessoInteressado.listaProcInterPorCodSep(decimal.Parse(linha.ItemArray[17].ToString())).Count != 0) { importado = true; break; } } else { log.Append("A célula S referente a linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (!importado) { //Validação de campos obrigatórios if (linha.ItemArray[0].ToString().Equals("")) { log.Append("A célula A linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[6].ToString().Equals("")) { log.Append("A célula G linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[7].ToString().Equals("")) { log.Append("A célula H linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } } } } Pode me ajudar por gentileza?
  3. rtavix

    gerenciamento de threads, controle de dados

    Alguém poderia me ajudar por gentileza?
  4. rtavix

    Pegar o último Numero de uma coluna Excel

    Boa Tarde Pessoal, tenho uma consulta de processo judicial e gravação do mesmo dentro do método da thread. Gostaria de saber se existe a possibilidade de pegar pelo ultimo numero do processo judicial em ordem? Índice 2. Coluna C NUMERO JUDICIAL 000021367.2017.8.08.0048 000638185.2017.8.08.0048 001049737.2017.8.08.0048 001133917.2017.8.08.0048 001542883.2017.8.08.0048 001929402.2017.8.08.0048 002028223.2017.8.08.0048 002149042.2017.8.08.0048 002257733.2017.8.08.0048 002330052.2017.8.08.0048 003441427.2016.8.08.0014 002186638.2015.8.08.0035 000169323.2014.8.08.0004 000462858.2013.8.08.0008 000719472.2016.8.08.0008 000437297.2013.8.08.0014 000073242.2016.8.08.0027 000418944.2014.8.08.0030 001558009.2017.8.08.0024 001751436.2016.8.08.0024 002317848.2016.8.08.0024 003026033.2016.8.08.0024 Meu código: private System.Threading.Tasks.Task ProcessamentoTabela(IEnumerable<DataRow> dadosparam, int i, Usuario usuarioLogado) { //usuarioLogado = aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login); i = 4; i++; Action<object> processamento = (dados) => { /*if (NHibernate.Context.ThreadStaticSessionContext.HasBind(NhibernateHelper.SessionFactory.))*/ NHibernate.Context.ThreadStaticSessionContext.Bind(NhibernateHelper.HelpThreading().OpenSession()); //Tentativa de ordenação por linha dentro do foreach direto no método da thread. //foreach (var linha in ((IEnumerable<DataRow>)dados).OrderBy(linha => linha["indice"])) foreach (var linha in (IEnumerable<DataRow>)dados) { List<Processo> listaProcessoExistente = new List<Processo>(); Processo processo = null; Interessado interessado = new Interessado(); //busca o processo pelo nº judicial anterior ou atual if (!linha.ItemArray[1].ToString().Equals("")) processo = aplProcesso.consultar---ProcessoER(linha.ItemArray[1].ToString()); if (processo == null) { if (!linha.ItemArray[2].ToString().Equals("")) processo = aplProcesso.consultar---ProcessoER(linha.ItemArray[2].ToString()); processo = aplProcesso.consultar---ProcessoER(linha.ItemArray[2].ToString().OrderBy()); } //busca o interessado por cpf/cnpj if (linha.ItemArray[7].ToString().Length == 14) interessado = aplInteressado.ConsultarPorCPF(AuxiliarCPF_CNPJ.DesformataCPF(linha.ItemArray[7].ToString())); if (linha.ItemArray[7].ToString().Length == 18) interessado = aplInteressado.ConsultarPorCPF(AuxiliarCPF_CNPJ.DesformataCNPJ(linha.ItemArray[7].ToString())); if (processo != null) { //se o processo não for nulo busco todos procinter relacionados a ele List<ProcessoInteressado> listaprocinter = aplProcessoInteressado.consultarPorIdProcesso(processo.Codigo); if (listaprocinter.Exists(o => o.Interessado == interessado)) log.Append("O interessado informado na linha " + (linha["indice"]) + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); //log.Append("O interessado " + processo.Interessado.Nome + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); // log.Append("O interessado " + processo.Interessado.Nome + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); setProcInter(processo, interessado, linha, i); } else { //Novo Processo - 6.3 processo = new Processo(); processo.Interessado = interessado; processo.NumProcessoJudicial = linha.ItemArray[2].ToString().Trim(); processo.RenunciaCredito = "N"; processo.Situacao = new AplSituacao().ConsultarPorId(1); processo.HonorarioDativo = "S"; processo.Reclamado = new AplReclamado().buscaItem(2); processo.TipoDocumento = new AplTipoDocumento().buscaItem(4); processo.TipoProcesso = "O"; if (linha.ItemArray[5].ToString().Contains("juizado")) processo.Tribunal = new AplTribunal().buscaItem(71); else processo.Tribunal = new AplTribunal().buscaItem(3); processo.NaturezaDespeza = new AplNaturezadeDespesa().buscaItem(3); VaraExecucao vara = new VaraExecucao(); if (!linha.ItemArray[3].ToString().Equals("") && !linha.ItemArray[5].ToString().Equals("")) { List<VaraExecucao> listaVaraComarca = aplVaraExecucao.Consultar---omeVaraNomeComarca(linha.ItemArray[5].ToString().Trim(), linha.ItemArray[3].ToString().Trim()); if (listaVaraComarca.Count != 0) { if (linha.ItemArray[4].ToString().Equals("")) { vara = listaVaraComarca.Find(o => o.NumeroVara == null); } else { vara = listaVaraComarca.Find(o => o.NumeroVara == int.Parse(linha.ItemArray[4].ToString().Trim())); } } } if (vara != null && vara.Codigo != 0) { processo.VaraExecucao = vara; } aplProcesso.gravar(processo); //aplLog.LogarAtividade(aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login), "Importação do processo de número judicial: " + processo.NumProcessoJudicial aplLog.LogarAtividade(usuarioLogado, "Importação do processo de número judicial: " + processo.NumProcessoJudicial + ". Interessado: " + processo.Interessado.Nome + " - " + processo.Interessado.CPF_CNPJ + ". Tribunal " + processo.Tribunal.NomeTribunal + ".", DateTime.Now); //log.Append("O processo " + processo.NumProcessoJudicial + " informado na linha " + (i + 1) + " foi cadastrado com sucesso. <br>"); setProcInter(processo, interessado, linha, i); } }//Fim Foreach //ClientScript.RegisterStartupScript(Page.GetType(), "Carregando...", "<script>document.getElementById('progresso').style.width = '60%';</script>"); logimportacao.Visible = true; loglbl.Text = log.ToString(); //ClientScript.RegisterStartupScript(Page.GetType(), "Carregando...", "<script>document.getElementById('progresso').style.width = '100%';</script>"); ClientScript.RegisterStartupScript(typeof(string), "Alerta", "<script>alert('Arquivo importado com sucesso. Verifique o log na tela. ')</script>"); }; ISession sessao = ThreadStaticSessionContext.Unbind(NhibernateHelper.HelpThreading()); if (sessao != null) { if (sessao.Transaction != null && sessao.Transaction.IsActive) { sessao.Transaction.Rollback(); } else { sessao.Flush(); } sessao.Close(); } //Tarefas baseadas de forma assíncrona System.Threading.Tasks.Task tarefa_executar = new System.Threading.Tasks.Task(processamento, dadosparam); return tarefa_executar; }
  5. rtavix

    gerenciamento de threads, controle de dados

    Estou com dúvidas de como fazer um controle de uma thread, eu tenho um sistema de importação, onde importo minhas planilhas para a base dados, porém utilizo threads pois possuo muitos registros, funciona! Porém eu gostaria de saber como eu faço para pegar o ultimo numero do processo judicial, e tipo todo processo judicial que terminar com o numero 0 eu pego e insiro somente os processos terminados com o numero 0, e todos terminados com 1 e 2 e assim por diante dentro da thread para ter uma controle? Esse é meu método de importar: protected void importar_Click(object sender, EventArgs e) { usuarioLogado = aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login); log.Clear(); //Stopwatch relogio = new Stopwatch(); //relogio.Start(); DataTable Dados = new DataTable(); //Verifica se um arquivo foi selecionado if (selecionarArquivo.HasFile) { //Valida a extensão do arquivo: if (Path.GetExtension(selecionarArquivo.FileName) != ".xlsx" && Path.GetExtension(selecionarArquivo.FileName) != ".xls") ClientScript.RegisterStartupScript(typeof(string), "Erro", "<script>alert('Somente arquivos em excel')</script>"); else { if (selecionarArquivo.FileContent != null) { string Excel = AppDomain.CurrentDomain.BaseDirectory + selecionarArquivo.FileName; selecionarArquivo.SaveAs(Excel); Dados = DadosExcel(Excel); //Tentavia de ordenação através da coluna. //System.Data.DataView view = Dados.DefaultView; //view.Sort = "G ASC"; //Tentativa 2 de ordenação pegando pelos dados. //string strSort = "NOME ASC"; //System.Data.DataView dtview = new System.Data.DataView(Dados); //dtview.Sort = strSort; //DataTable dtsorted = dtview.ToTable(); //Tentaiva 3 //Dados.DefaultView.Sort = "G Asc"; //string[] nomeInteressado = new string[Dados.Rows.Count]; //for (int i = 0; i < Dados.Rows.Count; i++) //{ // nomeInteressado[i] = Dados.Rows[i]["G"].ToString(); //} //Array.Sort(nomeInteressado); //for (int i = 1; i < Dados.Rows.Count; i++) //{ // Dados.Rows[i]["G"] = nomeInteressado[i]; //} //Tentativa pela ordenação usando o IOrderedEnumerable, não funcionou. //IOrderedEnumerable<DataRow> resultado; //resultado = Dados.Select().OrderBy(d => d["NOME"]); //Tentativa invalida //Dados.DefaultView.Sort = "A Asc"; //var dataparam = Dados.AsEnumerable().OrderBy(linha => linha.Field<int>("indice")); //Dados.Columns.Add("NUMERO JUDICIAL", typeof(string)); //Dados.Rows.Add(16, "0022350-77.2016.8.08.0048"); //Dados.Rows.Add(76, "0021704-78.2016.8.08.0012"); //Dados.Rows.Add(13, "0009360-20.2017.8.08.0048"); //Dados.Rows.Add(14, "0017555-91.2017.8.08.0048"); //Dados.Rows.Add(73, "0031279-52.2012.8.08.0012"); //Dados.Rows.Add(15, "0017734-93.2015.8.08.0048"); //Dados.Rows.Add(111, "0015570-97.2015.8.08.0035"); //var dataparam = Dados.AsEnumerable().OrderBy(linha => linha.Field<int>("indice")); //foreach (var item in dataparam) //{ // string text = ""; // foreach (var clm in item.ItemArray) // text += string.Format("{0}\t " + " _ ", clm); // Response.Write(text + "<br/>"); //} Dados.Columns.Add("indice", typeof(int)); int i = 1; foreach (DataRow linha in Dados.Rows) { linha["indice"] = i; i++; } var registrosValidos = ((DataTable)Dados).Rows.OfType<DataRow>().Skip(5); //Elimina a última linha registrosValidos = registrosValidos.Take(registrosValidos.Count() - 1); //ler de 100 em 100 regisros int quantidade_por_pagina = 100; int total_de_paginas; //Conta os registros válidos int qtd_total_registros = registrosValidos.Count(); //Realiza o calculo matemáticos para total de paginas. total_de_paginas = (int)Math.Ceiling((double)qtd_total_registros / quantidade_por_pagina); if (registrosValidos.Count() > 0) { bool layoutValido = VerificaLayout(Dados); if (!layoutValido) ClientScript.RegisterStartupScript(typeof(string), "Erro", "<script>alert('Layout do arquivo fora do padrão definido para importação.')</script>"); else { //Validação básica necessária para importação. PS: NumLinhas-1 porque o arquivo tem a última linha com total, que é inútil à importação. VerificacaoPreliminar(registrosValidos); //Inicio da rotina de repetição para leitura de todas as linhas, iniciando na célula B6 if (!arquivoInvalidado) { this.ValidaDuplicidadeInteressado(); //Criando as tarefas paralelas List<System.Threading.Tasks.Task> TarefasParalelas = new List<System.Threading.Tasks.Task>(); for (int j = 0; j < total_de_paginas; j++) { var pagina = j; //leio as 100 linhas var linhasPorPagina = registrosValidos.Skip(pagina * quantidade_por_pagina).Take(quantidade_por_pagina); //Quebrando em 10 threads, vou quebrar a lista com a extenção criada abaixo var data_rows_divididos = linhasPorPagina.SplitList(10); foreach (var linhasDivididas in data_rows_divididos) { //ADICIONO A MINHA LISTA DE TAREFAS PARALELAS TarefasParalelas.Add(ProcessamentoTabela(linhasDivididas, j, usuarioLogado)); } } //INICIOS AS TAREFAS PARALELAS foreach (var tarefa in TarefasParalelas) tarefa.Start(); // AGORA ESPERO TODAS TAREFAS CONCLUIREM System.Threading.Tasks.Task.WaitAll(TarefasParalelas.ToArray()); // ClientScript.RegisterStartupScript(Page.GetType(), "Carregando...", "<script>document.getElementById('progresso').style.width = '60%';</script>"); } if (listaGravarProcInter.Count != 0) { foreach (ProcessoInteressado item in listaGravarProcInter) { aplProcessoInteressado.salvar(item); } } if (listaLogsAuditoria.Count != 0) { foreach (var item in listaLogsAuditoria) { aplLog.LogarAtividade(usuarioLogado, item, DateTime.Now); //aplLog.LogarAtividade(aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login), item, DateTime.Now); } } else { logimportacao.Visible = true; loglbl.Text = log.ToString(); ClientScript.RegisterStartupScript(typeof(string), "Erro", "<script>alert('Arquivo não importado. Verifique o log de erros na tela. ')</script>"); } } } } } } //Tempo de importação. //relogio.Stop(); //Debug.WriteLine("#############" + relogio.Elapsed.ToString()); } E aqui é meu método da Thread: private System.Threading.Tasks.Task ProcessamentoTabela(IEnumerable<DataRow> dadosparam, int i, Usuario usuarioLogado) { //usuarioLogado = aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login); i = 4; i++; Action<object> processamento = (dados) => { /*if (NHibernate.Context.ThreadStaticSessionContext.HasBind(NhibernateHelper.SessionFactory.))*/ NHibernate.Context.ThreadStaticSessionContext.Bind(NhibernateHelper.HelpThreading().OpenSession()); //Tentativa de ordenação por linha dentro do foreach direto no método da thread. //foreach (var linha in ((IEnumerable<DataRow>)dados).OrderBy(linha => linha["indice"])) foreach (var linha in (IEnumerable<DataRow>)dados) { List<Processo> listaProcessoExistente = new List<Processo>(); Processo processo = null; Interessado interessado = new Interessado(); //busca o processo pelo nº judicial anterior ou atual if (!linha.ItemArray[1].ToString().Equals("")) processo = aplProcesso.consultar---ProcessoER(linha.ItemArray[1].ToString()); if (processo == null) { if (!linha.ItemArray[2].ToString().Equals("")) processo = aplProcesso.consultar---ProcessoER(linha.ItemArray[2].ToString()); } //busca o interessado por cpf/cnpj if (linha.ItemArray[7].ToString().Length == 14) interessado = aplInteressado.ConsultarPorCPF(AuxiliarCPF_CNPJ.DesformataCPF(linha.ItemArray[7].ToString())); if (linha.ItemArray[7].ToString().Length == 18) interessado = aplInteressado.ConsultarPorCPF(AuxiliarCPF_CNPJ.DesformataCNPJ(linha.ItemArray[7].ToString())); if (processo != null) { //se o processo não for nulo busco todos procinter relacionados a ele List<ProcessoInteressado> listaprocinter = aplProcessoInteressado.consultarPorIdProcesso(processo.Codigo); if (listaprocinter.Exists(o => o.Interessado == interessado)) log.Append("O interessado informado na linha " + (linha["indice"]) + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); //log.Append("O interessado " + processo.Interessado.Nome + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); // log.Append("O interessado " + processo.Interessado.Nome + " foi adicionado novamente ao processo " + processo.NumProcessoJudicial + " <br>"); setProcInter(processo, interessado, linha, i); } else { //Novo Processo - 6.3 processo = new Processo(); processo.Interessado = interessado; processo.NumProcessoJudicial = linha.ItemArray[2].ToString().Trim(); processo.RenunciaCredito = "N"; processo.Situacao = new AplSituacao().ConsultarPorId(1); processo.HonorarioDativo = "S"; processo.Reclamado = new AplReclamado().buscaItem(2); processo.TipoDocumento = new AplTipoDocumento().buscaItem(4); processo.TipoProcesso = "O"; if (linha.ItemArray[5].ToString().Contains("juizado")) processo.Tribunal = new AplTribunal().buscaItem(71); else processo.Tribunal = new AplTribunal().buscaItem(3); processo.NaturezaDespeza = new AplNaturezadeDespesa().buscaItem(3); VaraExecucao vara = new VaraExecucao(); if (!linha.ItemArray[3].ToString().Equals("") && !linha.ItemArray[5].ToString().Equals("")) { List<VaraExecucao> listaVaraComarca = aplVaraExecucao.Consultar---omeVaraNomeComarca(linha.ItemArray[5].ToString().Trim(), linha.ItemArray[3].ToString().Trim()); if (listaVaraComarca.Count != 0) { if (linha.ItemArray[4].ToString().Equals("")) { vara = listaVaraComarca.Find(o => o.NumeroVara == null); } else { vara = listaVaraComarca.Find(o => o.NumeroVara == int.Parse(linha.ItemArray[4].ToString().Trim())); } } } if (vara != null && vara.Codigo != 0) { processo.VaraExecucao = vara; } aplProcesso.gravar(processo); //aplLog.LogarAtividade(aplUsuario.buscaPorLogin(ObterUsuarioAutenticado().Login), "Importação do processo de número judicial: " + processo.NumProcessoJudicial aplLog.LogarAtividade(usuarioLogado, "Importação do processo de número judicial: " + processo.NumProcessoJudicial + ". Interessado: " + processo.Interessado.Nome + " - " + processo.Interessado.CPF_CNPJ + ". Tribunal " + processo.Tribunal.NomeTribunal + ".", DateTime.Now); //log.Append("O processo " + processo.NumProcessoJudicial + " informado na linha " + (i + 1) + " foi cadastrado com sucesso. <br>"); setProcInter(processo, interessado, linha, i); } }//Fim Foreach //ClientScript.RegisterStartupScript(Page.GetType(), "Carregando...", "<script>document.getElementById('progresso').style.width = '60%';</script>"); logimportacao.Visible = true; loglbl.Text = log.ToString(); //ClientScript.RegisterStartupScript(Page.GetType(), "Carregando...", "<script>document.getElementById('progresso').style.width = '100%';</script>"); ClientScript.RegisterStartupScript(typeof(string), "Alerta", "<script>alert('Arquivo importado com sucesso. Verifique o log na tela. ')</script>"); }; ISession sessao = ThreadStaticSessionContext.Unbind(NhibernateHelper.HelpThreading()); if (sessao != null) { if (sessao.Transaction != null && sessao.Transaction.IsActive) { sessao.Transaction.Rollback(); } else { sessao.Flush(); } sessao.Close(); } //Tarefas baseadas de forma assíncrona System.Threading.Tasks.Task tarefa_executar = new System.Threading.Tasks.Task(processamento, dadosparam); return tarefa_executar; } Como eu poderia ter esse controle? Coluna C é aonde está meus processos judicial, no meu sistema indice 0 é igual a coluna 1, indice 1 é igual a coluna 2, indice 2 é igual a coluna 3(local do processo). Como poderia esta controlando isso?
  6. rtavix

    gerenciamento de threads, controle de dados

    Pessoal, estou abrindo este tópicos, pois possuo uma aplicação que utiliza threads e tarefas paralelas, porém me sugiram certas duvidas com relação a utilização da mesmas. Recebi uma demanda que terei que pegar cada numeração de processo terminado em 1, 2, 3, 4, 5, 6, 7, 8, 9 e 0 e jogar em cada thread, minha dúvida é como fazer isso e se existe essa possibilidade. Tenho o seguintes numero de processo na minha planilha excel: 000543725.2013.8.08.0048 000229990.2015.8.08.0012 000222070.2010.8.08.0050 000269650.2014.8.08.0024 000246219.2016.8.08.0050 000406798.2017.8.08.0006 000252934.2016.8.08.0001 E assim por diante, não sei como o processador iria se comportar nesse caso, se pensarmos direitinho seria parecido como uma ordenação de dados.
  7. rtavix

    [Resolvido] A enumeração não gerou resultados

    Obrigado amigo, tópico me ajudou.
  8. Pessoal, estou com o seguinte problema, ao executar minha aplicação o mesmo me retorna o erro do provedor de acesso do office, acho que é algo assim. Porém entrei em outros tópicos relacionado a este problema, segui algumas sugestão de alterar as configuração da minha solution em configuration Menager e fui em Active solution platform coloquei a opção de X86 em em Project na aba PlatFrom também alterei para x64, entretanto, também não funcionou ao compilar. Vale lembrar que também instalei o drive para tentar corrigir o problema, também não funcionou. Segue meu código: private DataTable DadosExcel(string caminho) { Char aspas = '"'; //OleDbConnection conexao = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="" + caminho + "";Extended Properties='Excel 12.0;HDR=No;IMEX=1';"); string Conexao = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + caminho + ";" + "Extended Properties=" + aspas + "Excel 12.0;HDR=No;IMEX=1" + aspas; System.Data.OleDb.OleDbConnection Cn = new System.Data.OleDb.OleDbConnection(); Cn.ConnectionString = Conexao; Cn.Open(); object[] Restricoes = { null, null, null, "TABLE" }; DataTable DTSchema = Cn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, Restricoes); if (DTSchema.Rows.Count > 0) { string Sheet = DTSchema.Rows[0]["TABLE_NAME"].ToString(); OleDbCommand Comando = new OleDbCommand("SELECT * FROM [" + Sheet + "]", Cn); DataTable Dados = new DataTable(); System.Data.OleDb.OleDbDataAdapter DA = new System.Data.OleDb.OleDbDataAdapter(Comando); DA.Fill(Dados); Cn.Close(); return Dados; } return null; } Alguém por gentileza tem alguma ideia do que pode ser feito?
  9. rtavix

    [Resolvido] A enumeração não gerou resultados

    Testei aqui amigo, está dando essa mensagem de erro: Oracle.ManagedDataAccess.Client.OracleException HResult=0x80004005 Message=ORA-00923: palavra-chave FROM não localizada onde esperada Source=Oracle Data Provider for .NET, Managed Driver StackTrace: at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader() at ImportComprovante.DB.ExecutaComandoComRetorno(String strQuery) in C:\Users\robson.amaral\source\repos\ImportComprovante\ImportComprovante\ImportComprovante\DB.cs:line 39 at ImportComprovante.LeituraTxt.CodBarraJaInserido(String CodBarra) in C:\Users\robson.amaral\source\repos\ImportComprovante\ImportComprovante\ImportComprovante\LeituraTxt.cs:line 237 at ImportComprovante.LeituraTxt.ProcessaArquivo(String FullPathFile, String FileName) in C:\Users\robson.amaral\source\repos\ImportComprovante\ImportComprovante\ImportComprovante\LeituraTxt.cs:line 193 at ImportComprovante.LeituraTxt.VerificarHorario() in C:\Users\robson.amaral\source\repos\ImportComprovante\ImportComprovante\ImportComprovante\LeituraTxt.cs:line 52 at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
  10. rtavix

    [Resolvido] A enumeração não gerou resultados

    Opa Quintelab, valeu pela sugestão colega, eu vou testar aqui e te retorno validando.
  11. rtavix

    [Resolvido] A enumeração não gerou resultados

    Não estou conseguindo ler os valores retornado do banco de dados oracle. Esse é o meu método GetCodProcInter: private static string GetCodProcInter(string CodBarra) { using (DB db = new DB()) { //string SQL = string.Format(@"SELECT T0.COD_PROC_INTER FROM sdpj_proc_inter T0 WHERE T0.COD_BARRAS_BANESTES = {0}", CodBarra); string SQL = string.Format(@"SELECT count(T0.COD_COMP_BANESTES) FROM SDPJ_COMP_BANESTES T0 WHERE T0.COD_COMP_BANESTES = '{0}'", CodBarra); var dados = db.ExecutaComandoComRetorno(SQL); if(dados.Read()) { return dados["COD_PROC_INTER"].ToString(); } } return ""; } Aqui eu tenho a classe para acessar o Banco de dados: using System; using System.Configuration; using System.Data.SqlClient; using Oracle.ManagedDataAccess.Client; namespace ImportComprovante { public class DB : IDisposable { private readonly OracleConnection conexao; public DB() { conexao = new OracleConnection(@"Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = ex01dev-scan.net.seg.com.br)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = DAPP)));User Id=Teste;Password=Teste123"); conexao.Open(); } public void ExecutaComando(string strQuery) { var cmdComando = new OracleCommand { CommandText = strQuery, CommandType = System.Data.CommandType.Text, Connection = conexao }; cmdComando.ExecuteNonQuery(); } public OracleDataReader ExecutaComandoComRetorno(string strQuery) { var cmdComando = new OracleCommand { CommandText = strQuery, CommandType = System.Data.CommandType.Text, Connection = conexao }; return cmdComando.ExecuteReader(); } public void Dispose() { if (conexao.State == System.Data.ConnectionState.Open) conexao.Close(); } } } Busco o código e barra e em seguida verifico se existe na base de dados, caso não exista eu insiro, e se não estiver disponível na tabela, eu adiciono no log do serviço a mensagem informando e acompanhado do numero do código de barras: //Busca Código de Barra string CodProcInter = GetCodProcInter(CodBarra); if (!string.IsNullOrEmpty(CodProcInter)) { if(!CodBarraJaInserido(CodBarra)) { //Insere Código de Barra bool inserido = InsereDadosBanco(CodProcInter, CodBarra, DtAgendamento, VlrDocumento, Protocolo, Registro, Emissao); } else { //Código de Barra já Inserido InsertLog("\n Já Existe -> " + CodBarra); } } else { //Código de Barra não esta disponível na tabela -> sdpj_proc_inter Mover = false; InsertLog("\n Cód. Barra Não disponível -> " + CodBarra); } Porém estou com problema nessa linha: return dados["COD_PROC_INTER"].ToString(); Ao verificar, é apresentado a seguinte mensagem: a enumeração não gerou resultados
  12. Estou recendo essa mensagem de erro ao tentar compilar minha aplicação. Alguém poderia me orientar uma forma de resolver esse problema? Mensagem de erro: HibernateException: The IDbCommand and IDbConnection implementation in the assembly Oracle.DataAccess could not be found. Ensure that the assembly Oracle.DataAccess is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly. Classe nhibernateHelper: using System; using System.Collections.Generic; using System.Linq; using System.Text; using NHibernate.Mapping.Attributes; using NHibernate.Cfg; using NHibernate; using System.IO; using NHibernate.Context; namespace SDPJDominio.DataAccess { public class NhibernateHelper { private readonly ISessionFactory sessionFactory; public static ISession GetSessao() { return Instancia.GetSessionFactory().GetCurrentSession(); } private NhibernateHelper() { MemoryStream stream = new System.IO.MemoryStream(); HbmSerializer.Default.Validate = true; HbmSerializer.Default.Serialize(stream, System.Reflection.Assembly.GetExecutingAssembly()); stream.Position = 0; Configuration configuracao = new Configuration(); //configuracao = ConfigNhibernate.getConfig(configuracao); configuracao.Configure(); configuracao.SetProperty("connection.connection_string", ConfigNhibernate.getConfig()); //add essa linha configuracao.AddInputStream(stream); stream.Close(); sessionFactory = configuracao.BuildSessionFactory(); } public static ISessionFactory SessionFactory { get { return Instancia.sessionFactory; } } private ISessionFactory GetSessionFactory() { return sessionFactory; } public static NhibernateHelper Instancia { get { return CriarGerenciadorDeSessao.gerenciadorDeSessao; } } public static ISession AbrirSessao() { return Instancia.GetSessionFactory().OpenSession(); } public static void RecarregarSessao(object obj) { SessaoCorrente.Refresh(obj); } public static ISession SessaoCorrente { get { return Instancia.GetSessionFactory().GetCurrentSession(); } } class CriarGerenciadorDeSessao { internal static readonly NhibernateHelper gerenciadorDeSessao = new NhibernateHelper(); } } } Mensagem referente ao StackTrace: Name Value Type StackTrace " em SDPJDominio.DataAccess.NhibernateHelper.get_SessionFactory() na D:\\Repositório SVN\\SDP\\SDPJ\\branches\\SDPJ-v6.0.0\\SDPJDominio\\DataAccess\\NhibernateHelper.cs:linha 39" string
  13. Pessoal, estou com o seguinte desafio, eu migrei de versão do visual studio 2010 para visual studio 2017 Profissional version 15.7.3, entretanto, ao compilar minha aplicação web, a mesma abre o navegador chrome e fecha em seguida do nada, no vs 2010 funcionava, agora nessa versão acontece isso, se alguém saber como resolver, ficarei muitíssimo grato. esse é o link: desenvlocal.sefaz.es.gov.br:1476/Default.aspx //Meu arquivo config <?xml version="1.0" encoding="UTF-8"?> <!-- IIS configuration sections. For schema documentation, see %IIS_BIN%\config\schema\IIS_schema.xml. Please make a backup of this file before making any changes to it. NOTE: The following environment variables are available to be used within this file and are understood by the IIS Express. %IIS_USER_HOME% - The IIS Express home directory for the user %IIS_SITES_HOME% - The default home directory for sites %IIS_BIN% - The location of the IIS Express binaries %SYSTEMDRIVE% - The drive letter of %IIS_BIN% --> <configuration> <!-- The <configSections> section controls the registration of sections. Section is the basic unit of deployment, locking, searching and containment for configuration settings. Every section belongs to one section group. A section group is a container of logically-related sections. Sections cannot be nested. Section groups may be nested. <section name="" [Required, Collection Key] [XML name of the section] allowDefinition="Everywhere" [MachineOnly|MachineToApplication|AppHostOnly|Everywhere] [Level where it can be set] overrideModeDefault="Allow" [Allow|Deny] [Default delegation mode] allowLocation="true" [true|false] [Allowed in location tags] /> The recommended way to unlock sections is by using a location tag: <location path="Default Web Site" overrideMode="Allow"> <system.webServer> <asp /> </system.webServer> </location> --> <configSections> <sectionGroup name="system.applicationHost"> <section name="applicationPools" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="configHistory" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="customMetadata" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="listenerAdapters" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="log" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="serviceAutoStartProviders" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="sites" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="webLimits" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> </sectionGroup> <sectionGroup name="system.webServer"> <section name="asp" overrideModeDefault="Deny" /> <section name="caching" overrideModeDefault="Allow" /> <section name="cgi" overrideModeDefault="Deny" /> <section name="defaultDocument" overrideModeDefault="Allow" /> <section name="directoryBrowse" overrideModeDefault="Allow" /> <section name="fastCgi" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="globalModules" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="handlers" overrideModeDefault="Deny" /> <section name="httpCompression" overrideModeDefault="Allow" /> <section name="httpErrors" overrideModeDefault="Allow" /> <section name="httpLogging" overrideModeDefault="Deny" /> <section name="httpProtocol" overrideModeDefault="Allow" /> <section name="httpRedirect" overrideModeDefault="Allow" /> <section name="httpTracing" overrideModeDefault="Deny" /> <section name="isapiFilters" allowDefinition="MachineToApplication" overrideModeDefault="Deny" /> <section name="modules" allowDefinition="MachineToApplication" overrideModeDefault="Deny" /> <section name="applicationInitialization" allowDefinition="MachineToApplication" overrideModeDefault="Allow" /> <section name="odbcLogging" overrideModeDefault="Deny" /> <sectionGroup name="security"> <section name="access" overrideModeDefault="Deny" /> <section name="applicationDependencies" overrideModeDefault="Deny" /> <sectionGroup name="authentication"> <section name="anonymousAuthentication" overrideModeDefault="Deny" /> <section name="basicAuthentication" overrideModeDefault="Deny" /> <section name="clientCertificateMappingAuthentication" overrideModeDefault="Deny" /> <section name="digestAuthentication" overrideModeDefault="Deny" /> <section name="iisClientCertificateMappingAuthentication" overrideModeDefault="Deny" /> <section name="windowsAuthentication" overrideModeDefault="Deny" /> </sectionGroup> <section name="authorization" overrideModeDefault="Allow" /> <section name="ipSecurity" overrideModeDefault="Deny" /> <section name="dynamicIpSecurity" overrideModeDefault="Deny" /> <section name="isapiCgiRestriction" allowDefinition="AppHostOnly" overrideModeDefault="Deny" /> <section name="requestFiltering" overrideModeDefault="Allow" /> </sectionGroup> <section name="serverRuntime" overrideModeDefault="Deny" /> <section name="serverSideInclude" overrideModeDefault="Deny" /> <section name="staticContent" overrideModeDefault="Allow" /> <sectionGroup name="tracing"> <section name="traceFailedRequests" overrideModeDefault="Allow" /> <section name="traceProviderDefinitions" overrideModeDefault="Deny" /> </sectionGroup> <section name="urlCompression" overrideModeDefault="Allow" /> <section name="validation" overrideModeDefault="Allow" /> <sectionGroup name="webdav"> <section name="globalSettings" overrideModeDefault="Deny" /> <section name="authoring" overrideModeDefault="Deny" /> <section name="authoringRules" overrideModeDefault="Deny" /> </sectionGroup> <sectionGroup name="rewrite"> <section name="allowedServerVariables" overrideModeDefault="Deny" /> <section name="rules" overrideModeDefault="Allow" /> <section name="outboundRules" overrideModeDefault="Allow" /> <section name="globalRules" overrideModeDefault="Deny" allowDefinition="AppHostOnly" /> <section name="providers" overrideModeDefault="Allow" /> <section name="rewriteMaps" overrideModeDefault="Allow" /> </sectionGroup> <section name="webSocket" overrideModeDefault="Deny" /> <section name="aspNetCore" overrideModeDefault="Allow" /></sectionGroup> </configSections> <configProtectedData> <providers> <add name="IISWASOnlyRsaProvider" type="" description="Uses RsaCryptoServiceProvider to encrypt and decrypt" keyContainerName="iisWasKey" cspProviderName="" useMachineContainer="true" useOAEP="false" /> <add name="AesProvider" type="Microsoft.ApplicationHost.AesProtectedConfigurationProvider" description="Uses an AES session key to encrypt and decrypt" keyContainerName="iisConfigurationKey" cspProviderName="" useOAEP="false" useMachineContainer="true" sessionKey="AQIAAA5mAAAApAAAKmFQvWHDEETRz8l2bjZlRxIkwcqTFaCUnCLljn3Q1OkesrhEO9YyLyx4bUhsj1/DyShAv7OAFFhXlrlomaornnk5PLeyO4lIXxaiT33yOFUUgxDx4GSaygkqghVV0tO5yQ/XguUBp2juMfZyztnsNa4pLcz7ZNZQ6p4yn9hxwNs=" /> <add name="IISWASOnlyAesProvider" type="Microsoft.ApplicationHost.AesProtectedConfigurationProvider" description="Uses an AES session key to encrypt and decrypt" keyContainerName="iisWasKey" cspProviderName="" useOAEP="false" useMachineContainer="true" sessionKey="AQIAAA5mAAAApAAA4WoiRJ8KHwzAG8AgejPxEOO4/2Vhkolbwo/8gZeNdUDSD36m55hWv4uC9tr/MlKdnwRLL0NhT50Gccyftqz5xTZ0dg5FtvQhTw/he1NwexTKbV+I4Zrd+sZUqHZTsr7JiEr6OHGXL70qoISW5G2m9U8wKT3caPiDPNj2aAaYPLo=" /> </providers> </configProtectedData> <system.applicationHost> <applicationPools> <add name="Clr4IntegratedAppPool" managedRuntimeVersion="v4.0" managedPipelineMode="Integrated" CLRConfigFile="%IIS_USER_HOME%\config\aspnet.config" autoStart="true" /> <add name="Clr4ClassicAppPool" managedRuntimeVersion="v4.0" managedPipelineMode="Classic" CLRConfigFile="%IIS_USER_HOME%\config\aspnet.config" autoStart="true" /> <add name="Clr2IntegratedAppPool" managedRuntimeVersion="v2.0" managedPipelineMode="Integrated" CLRConfigFile="%IIS_USER_HOME%\config\aspnet.config" autoStart="true" /> <add name="Clr2ClassicAppPool" managedRuntimeVersion="v2.0" managedPipelineMode="Classic" CLRConfigFile="%IIS_USER_HOME%\config\aspnet.config" autoStart="true" /> <add name="UnmanagedClassicAppPool" managedRuntimeVersion="" managedPipelineMode="Classic" autoStart="true" /> <applicationPoolDefaults managedRuntimeLoader="v4.0"> <processModel /> </applicationPoolDefaults> </applicationPools> <!-- The <listenerAdapters> section defines the protocols with which the Windows Process Activation Service (WAS) binds. --> <listenerAdapters> <add name="http" /> </listenerAdapters> <sites> <site name="WebSite1" id="1" serverAutoStart="true"> <application path="/"> <virtualDirectory path="/" physicalPath="%IIS_SITES_HOME%\WebSite1" /> </application> <bindings> <binding protocol="http" bindingInformation=":8080:localhost" /> </bindings> </site> <site name="SDPJView" id="2"> <application path="/" applicationPool="Clr4IntegratedAppPool"> <virtualDirectory path="/" physicalPath="D:\Repositório SVN\SDP\SDPJ\branches\SDPJ-v6.0.0\SDPJView" /> </application> <bindings> <binding protocol="http" bindingInformation="*:1476:localhost" /> </bindings> </site> <siteDefaults> <logFile logFormat="W3C" directory="%IIS_USER_HOME%\Logs" /> <traceFailedRequestsLogging directory="%IIS_USER_HOME%\TraceLogFiles" enabled="true" maxLogFileSizeKB="1024" /> </siteDefaults> <applicationDefaults applicationPool="Clr4IntegratedAppPool" /> <virtualDirectoryDefaults allowSubDirConfig="true" /> </sites> <webLimits /> </system.applicationHost> <system.webServer> <serverRuntime /> <asp scriptErrorSentToBrowser="true"> <cache diskTemplateCacheDirectory="%TEMP%\iisexpress\ASP Compiled Templates" /> <limits /> </asp> <caching enabled="true" enableKernelCache="true"> </caching> <cgi /> <defaultDocument enabled="true"> <files> <add value="Default.htm" /> <add value="Default.asp" /> <add value="index.htm" /> <add value="index.html" /> <add value="iisstart.htm" /> <add value="default.aspx" /> </files> </defaultDocument> <directoryBrowse enabled="false" /> <fastCgi /> <!-- The <globalModules> section defines all native-code modules. To enable a module, specify it in the <modules> section. --> <globalModules> <add name="HttpLoggingModule" image="%IIS_BIN%\loghttp.dll" /> <add name="UriCacheModule" image="%IIS_BIN%\cachuri.dll" /> <!-- <add name="FileCacheModule" image="%IIS_BIN%\cachfile.dll" /> --> <add name="TokenCacheModule" image="%IIS_BIN%\cachtokn.dll" /> <!-- <add name="HttpCacheModule" image="%IIS_BIN%\cachhttp.dll" /> --> <add name="DynamicCompressionModule" image="%IIS_BIN%\compdyn.dll" /> <add name="StaticCompressionModule" image="%IIS_BIN%\compstat.dll" /> <add name="DefaultDocumentModule" image="%IIS_BIN%\defdoc.dll" /> <add name="DirectoryListingModule" image="%IIS_BIN%\dirlist.dll" /> <add name="ProtocolSupportModule" image="%IIS_BIN%\protsup.dll" /> <add name="HttpRedirectionModule" image="%IIS_BIN%\redirect.dll" /> <add name="ServerSideIncludeModule" image="%IIS_BIN%\iis_ssi.dll" /> <add name="StaticFileModule" image="%IIS_BIN%\static.dll" /> <add name="AnonymousAuthenticationModule" image="%IIS_BIN%\authanon.dll" /> <add name="CertificateMappingAuthenticationModule" image="%IIS_BIN%\authcert.dll" /> <add name="UrlAuthorizationModule" image="%IIS_BIN%\urlauthz.dll" /> <add name="BasicAuthenticationModule" image="%IIS_BIN%\authbas.dll" /> <add name="WindowsAuthenticationModule" image="%IIS_BIN%\authsspi.dll" /> <!-- <add name="DigestAuthenticationModule" image="%IIS_BIN%\authmd5.dll" /> --> <add name="IISCertificateMappingAuthenticationModule" image="%IIS_BIN%\authmap.dll" /> <add name="IpRestrictionModule" image="%IIS_BIN%\iprestr.dll" /> <add name="DynamicIpRestrictionModule" image="%IIS_BIN%\diprestr.dll" /> <add name="RequestFilteringModule" image="%IIS_BIN%\modrqflt.dll" /> <add name="CustomLoggingModule" image="%IIS_BIN%\logcust.dll" /> <add name="CustomErrorModule" image="%IIS_BIN%\custerr.dll" /> <!-- <add name="TracingModule" image="%IIS_BIN%\iisetw.dll" /> --> <add name="FailedRequestsTracingModule" image="%IIS_BIN%\iisfreb.dll" /> <add name="RequestMonitorModule" image="%IIS_BIN%\iisreqs.dll" /> <add name="IsapiModule" image="%IIS_BIN%\isapi.dll" /> <add name="IsapiFilterModule" image="%IIS_BIN%\filter.dll" /> <add name="CgiModule" image="%IIS_BIN%\cgi.dll" /> <add name="FastCgiModule" image="%IIS_BIN%\iisfcgi.dll" /> <!-- <add name="WebDAVModule" image="%IIS_BIN%\webdav.dll" /> --> <add name="RewriteModule" image="%IIS_BIN%\rewrite.dll" /> <add name="ConfigurationValidationModule" image="%IIS_BIN%\validcfg.dll" /> <add name="WebSocketModule" image="%IIS_BIN%\iiswsock.dll" /> <add name="WebMatrixSupportModule" image="%IIS_BIN%\webmatrixsup.dll" /> <add name="ManagedEngine" image="%windir%\Microsoft.NET\Framework\v2.0.50727\webengine.dll" preCondition="integratedMode,runtimeVersionv2.0,bitness32" /> <add name="ManagedEngine64" image="%windir%\Microsoft.NET\Framework64\v2.0.50727\webengine.dll" preCondition="integratedMode,runtimeVersionv2.0,bitness64" /> <add name="ManagedEngineV4.0_32bit" image="%windir%\Microsoft.NET\Framework\v4.0.30319\webengine4.dll" preCondition="integratedMode,runtimeVersionv4.0,bitness32" /> <add name="ManagedEngineV4.0_64bit" image="%windir%\Microsoft.NET\Framework64\v4.0.30319\webengine4.dll" preCondition="integratedMode,runtimeVersionv4.0,bitness64" /> <add name="ApplicationInitializationModule" image="%IIS_BIN%\warmup.dll" /> <add name="AspNetCoreModule" image="%IIS_BIN%\aspnetcore.dll" /> </globalModules> <httpCompression directory="%TEMP%\iisexpress\IIS Temporary Compressed Files"> <scheme name="gzip" dll="%IIS_BIN%\gzip.dll" /> <dynamicTypes> <add mimeType="text/*" enabled="true" /> <add mimeType="message/*" enabled="true" /> <add mimeType="application/javascript" enabled="true" /> <add mimeType="application/atom+xml" enabled="true" /> <add mimeType="application/xaml+xml" enabled="true" /> <add mimeType="*/*" enabled="false" /> </dynamicTypes> <staticTypes> <add mimeType="text/*" enabled="true" /> <add mimeType="message/*" enabled="true" /> <add mimeType="image/svg+xml" enabled="true" /> <add mimeType="application/javascript" enabled="true" /> <add mimeType="application/atom+xml" enabled="true" /> <add mimeType="application/xaml+xml" enabled="true" /> <add mimeType="*/*" enabled="false" /> </staticTypes> </httpCompression> <httpErrors lockAttributes="allowAbsolutePathsWhenDelegated,defaultPath"> <error statusCode="401" prefixLanguageFilePath="%IIS_BIN%\custerr" path="401.htm" /> <error statusCode="403" prefixLanguageFilePath="%IIS_BIN%\custerr" path="403.htm" /> <error statusCode="404" prefixLanguageFilePath="%IIS_BIN%\custerr" path="404.htm" /> <error statusCode="405" prefixLanguageFilePath="%IIS_BIN%\custerr" path="405.htm" /> <error statusCode="406" prefixLanguageFilePath="%IIS_BIN%\custerr" path="406.htm" /> <error statusCode="412" prefixLanguageFilePath="%IIS_BIN%\custerr" path="412.htm" /> <error statusCode="500" prefixLanguageFilePath="%IIS_BIN%\custerr" path="500.htm" /> <error statusCode="501" prefixLanguageFilePath="%IIS_BIN%\custerr" path="501.htm" /> <error statusCode="502" prefixLanguageFilePath="%IIS_BIN%\custerr" path="502.htm" /> </httpErrors> <httpLogging dontLog="false" /> <httpProtocol> <customHeaders> <clear /> <add name="X-Powered-By" value="ASP.NET" /> </customHeaders> <redirectHeaders> <clear /> </redirectHeaders> </httpProtocol> <httpRedirect enabled="false" /> <httpTracing> </httpTracing> <isapiFilters> <filter name="ASP.Net_2.0.50727-64" path="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll" enableCache="true" preCondition="bitness64,runtimeVersionv2.0" /> <filter name="ASP.Net_2.0.50727.0" path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll" enableCache="true" preCondition="bitness32,runtimeVersionv2.0" /> <filter name="ASP.Net_2.0_for_v1.1" path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll" enableCache="true" preCondition="runtimeVersionv1.1" /> <filter name="ASP.Net_4.0_32bit" path="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" enableCache="true" preCondition="bitness32,runtimeVersionv4.0" /> <filter name="ASP.Net_4.0_64bit" path="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_filter.dll" enableCache="true" preCondition="bitness64,runtimeVersionv4.0" /> </isapiFilters> <odbcLogging /> <security> <access sslFlags="None" /> <applicationDependencies> <application name="Active Server Pages" groupId="ASP" /> </applicationDependencies> <authentication> <anonymousAuthentication enabled="true" userName="" /> <basicAuthentication enabled="false" /> <clientCertificateMappingAuthentication enabled="false" /> <digestAuthentication enabled="false" /> <iisClientCertificateMappingAuthentication enabled="false"> </iisClientCertificateMappingAuthentication> <windowsAuthentication enabled="false"> <providers> <add value="Negotiate" /> <add value="NTLM" /> </providers> </windowsAuthentication> </authentication> <authorization> <add accessType="Allow" users="*" /> </authorization> <ipSecurity allowUnlisted="true" /> <isapiCgiRestriction notListedIsapisAllowed="true" notListedCgisAllowed="true"> <add path="%windir%\Microsoft.NET\Framework64\v4.0.30319\webengine4.dll" allowed="true" groupId="ASP.NET_v4.0" description="ASP.NET_v4.0" /> <add path="%windir%\Microsoft.NET\Framework\v4.0.30319\webengine4.dll" allowed="true" groupId="ASP.NET_v4.0" description="ASP.NET_v4.0" /> <add path="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" allowed="true" groupId="ASP.NET v2.0.50727" description="ASP.NET v2.0.50727" /> <add path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" allowed="true" groupId="ASP.NET v2.0.50727" description="ASP.NET v2.0.50727" /> </isapiCgiRestriction> <requestFiltering> <fileExtensions allowUnlisted="true" applyToWebDAV="true"> <add fileExtension=".asa" allowed="false" /> <add fileExtension=".asax" allowed="false" /> <add fileExtension=".ascx" allowed="false" /> <add fileExtension=".master" allowed="false" /> <add fileExtension=".skin" allowed="false" /> <add fileExtension=".browser" allowed="false" /> <add fileExtension=".sitemap" allowed="false" /> <add fileExtension=".config" allowed="false" /> <add fileExtension=".cs" allowed="false" /> <add fileExtension=".csproj" allowed="false" /> <add fileExtension=".vb" allowed="false" /> <add fileExtension=".vbproj" allowed="false" /> <add fileExtension=".webinfo" allowed="false" /> <add fileExtension=".licx" allowed="false" /> <add fileExtension=".resx" allowed="false" /> <add fileExtension=".resources" allowed="false" /> <add fileExtension=".mdb" allowed="false" /> <add fileExtension=".vjsproj" allowed="false" /> <add fileExtension=".java" allowed="false" /> <add fileExtension=".jsl" allowed="false" /> <add fileExtension=".ldb" allowed="false" /> <add fileExtension=".dsdgm" allowed="false" /> <add fileExtension=".ssdgm" allowed="false" /> <add fileExtension=".lsad" allowed="false" /> <add fileExtension=".ssmap" allowed="false" /> <add fileExtension=".cd" allowed="false" /> <add fileExtension=".dsprototype" allowed="false" /> <add fileExtension=".lsaprototype" allowed="false" /> <add fileExtension=".sdm" allowed="false" /> <add fileExtension=".sdmDocument" allowed="false" /> <add fileExtension=".mdf" allowed="false" /> <add fileExtension=".ldf" allowed="false" /> <add fileExtension=".ad" allowed="false" /> <add fileExtension=".dd" allowed="false" /> <add fileExtension=".ldd" allowed="false" /> <add fileExtension=".sd" allowed="false" /> <add fileExtension=".adprototype" allowed="false" /> <add fileExtension=".lddprototype" allowed="false" /> <add fileExtension=".exclude" allowed="false" /> <add fileExtension=".refresh" allowed="false" /> <add fileExtension=".compiled" allowed="false" /> <add fileExtension=".msgx" allowed="false" /> <add fileExtension=".vsdisco" allowed="false" /> <add fileExtension=".rules" allowed="false" /> </fileExtensions> <verbs allowUnlisted="true" applyToWebDAV="true" /> <hiddenSegments applyToWebDAV="true"> <add segment="web.config" /> <add segment="bin" /> <add segment="App_code" /> <add segment="App_GlobalResources" /> <add segment="App_LocalResources" /> <add segment="App_WebReferences" /> <add segment="App_Data" /> <add segment="App_Browsers" /> </hiddenSegments> </requestFiltering> </security> <serverSideInclude ssiExecDisable="false" /> <staticContent lockAttributes="isDocFooterFileName"> <mimeMap fileExtension=".323" mimeType="text/h323" /> <mimeMap fileExtension=".3g2" mimeType="video/3gpp2" /> <mimeMap fileExtension=".3gp2" mimeType="video/3gpp2" /> <mimeMap fileExtension=".3gp" mimeType="video/3gpp" /> <mimeMap fileExtension=".3gpp" mimeType="video/3gpp" /> <mimeMap fileExtension=".aac" mimeType="audio/aac" /> <mimeMap fileExtension=".aaf" mimeType="application/octet-stream" /> <mimeMap fileExtension=".aca" mimeType="application/octet-stream" /> <mimeMap fileExtension=".accdb" mimeType="application/msaccess" /> <mimeMap fileExtension=".accde" mimeType="application/msaccess" /> <mimeMap fileExtension=".accdt" mimeType="application/msaccess" /> <mimeMap fileExtension=".acx" mimeType="application/internet-property-stream" /> <mimeMap fileExtension=".adt" mimeType="audio/vnd.dlna.adts" /> <mimeMap fileExtension=".adts" mimeType="audio/vnd.dlna.adts" /> <mimeMap fileExtension=".afm" mimeType="application/octet-stream" /> <mimeMap fileExtension=".ai" mimeType="application/postscript" /> <mimeMap fileExtension=".aif" mimeType="audio/x-aiff" /> <mimeMap fileExtension=".aifc" mimeType="audio/aiff" /> <mimeMap fileExtension=".aiff" mimeType="audio/aiff" /> <mimeMap fileExtension=".appcache" mimeType="text/cache-manifest" /> <mimeMap fileExtension=".application" mimeType="application/x-ms-application" /> <mimeMap fileExtension=".art" mimeType="image/x-jg" /> <mimeMap fileExtension=".asd" mimeType="application/octet-stream" /> <mimeMap fileExtension=".asf" mimeType="video/x-ms-asf" /> <mimeMap fileExtension=".asi" mimeType="application/octet-stream" /> <mimeMap fileExtension=".asm" mimeType="text/plain" /> <mimeMap fileExtension=".asr" mimeType="video/x-ms-asf" /> <mimeMap fileExtension=".asx" mimeType="video/x-ms-asf" /> <mimeMap fileExtension=".atom" mimeType="application/atom+xml" /> <mimeMap fileExtension=".au" mimeType="audio/basic" /> <mimeMap fileExtension=".avi" mimeType="video/msvideo" /> <mimeMap fileExtension=".axs" mimeType="application/olescript" /> <mimeMap fileExtension=".bas" mimeType="text/plain" /> <mimeMap fileExtension=".bcpio" mimeType="application/x-bcpio" /> <mimeMap fileExtension=".bin" mimeType="application/octet-stream" /> <mimeMap fileExtension=".bmp" mimeType="image/bmp" /> <mimeMap fileExtension=".c" mimeType="text/plain" /> <mimeMap fileExtension=".cab" mimeType="application/vnd.ms-cab-compressed" /> <mimeMap fileExtension=".calx" mimeType="application/vnd.ms-office.calx" /> <mimeMap fileExtension=".cat" mimeType="application/vnd.ms-pki.seccat" /> <mimeMap fileExtension=".cdf" mimeType="application/x-cdf" /> <mimeMap fileExtension=".chm" mimeType="application/octet-stream" /> <mimeMap fileExtension=".class" mimeType="application/x-java-applet" /> <mimeMap fileExtension=".clp" mimeType="application/x-msclip" /> <mimeMap fileExtension=".cmx" mimeType="image/x-cmx" /> <mimeMap fileExtension=".cnf" mimeType="text/plain" /> <mimeMap fileExtension=".cod" mimeType="image/cis-cod" /> <mimeMap fileExtension=".cpio" mimeType="application/x-cpio" /> <mimeMap fileExtension=".cpp" mimeType="text/plain" /> <mimeMap fileExtension=".crd" mimeType="application/x-mscardfile" /> <mimeMap fileExtension=".crl" mimeType="application/pkix-crl" /> <mimeMap fileExtension=".crt" mimeType="application/x-x509-ca-cert" /> <mimeMap fileExtension=".csh" mimeType="application/x-csh" /> <mimeMap fileExtension=".css" mimeType="text/css" /> <mimeMap fileExtension=".csv" mimeType="application/octet-stream" /> <mimeMap fileExtension=".cur" mimeType="application/octet-stream" /> <mimeMap fileExtension=".dcr" mimeType="application/x-director" /> <mimeMap fileExtension=".deploy" mimeType="application/octet-stream" /> <mimeMap fileExtension=".der" mimeType="application/x-x509-ca-cert" /> <mimeMap fileExtension=".dib" mimeType="image/bmp" /> <mimeMap fileExtension=".dir" mimeType="application/x-director" /> <mimeMap fileExtension=".disco" mimeType="text/xml" /> <mimeMap fileExtension=".dll" mimeType="application/x-msdownload" /> <mimeMap fileExtension=".dll.config" mimeType="text/xml" /> <mimeMap fileExtension=".dlm" mimeType="text/dlm" /> <mimeMap fileExtension=".doc" mimeType="application/msword" /> <mimeMap fileExtension=".docm" mimeType="application/vnd.ms-word.document.macroEnabled.12" /> <mimeMap fileExtension=".docx" mimeType="application/vnd.openxmlformats-officedocument.wordprocessingml.document" /> <mimeMap fileExtension=".dot" mimeType="application/msword" /> <mimeMap fileExtension=".dotm" mimeType="application/vnd.ms-word.template.macroEnabled.12" /> <mimeMap fileExtension=".dotx" mimeType="application/vnd.openxmlformats-officedocument.wordprocessingml.template" /> <mimeMap fileExtension=".dsp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".dtd" mimeType="text/xml" /> <mimeMap fileExtension=".dvi" mimeType="application/x-dvi" /> <mimeMap fileExtension=".dvr-ms" mimeType="video/x-ms-dvr" /> <mimeMap fileExtension=".dwf" mimeType="drawing/x-dwf" /> <mimeMap fileExtension=".dwp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".dxr" mimeType="application/x-director" /> <mimeMap fileExtension=".eml" mimeType="message/rfc822" /> <mimeMap fileExtension=".emz" mimeType="application/octet-stream" /> <mimeMap fileExtension=".eot" mimeType="application/vnd.ms-fontobject" /> <mimeMap fileExtension=".eps" mimeType="application/postscript" /> <mimeMap fileExtension=".etx" mimeType="text/x-setext" /> <mimeMap fileExtension=".evy" mimeType="application/envoy" /> <mimeMap fileExtension=".exe" mimeType="application/octet-stream" /> <mimeMap fileExtension=".exe.config" mimeType="text/xml" /> <mimeMap fileExtension=".fdf" mimeType="application/vnd.fdf" /> <mimeMap fileExtension=".fif" mimeType="application/fractals" /> <mimeMap fileExtension=".fla" mimeType="application/octet-stream" /> <mimeMap fileExtension=".flr" mimeType="x-world/x-vrml" /> <mimeMap fileExtension=".flv" mimeType="video/x-flv" /> <mimeMap fileExtension=".gif" mimeType="image/gif" /> <mimeMap fileExtension=".gtar" mimeType="application/x-gtar" /> <mimeMap fileExtension=".gz" mimeType="application/x-gzip" /> <mimeMap fileExtension=".h" mimeType="text/plain" /> <mimeMap fileExtension=".hdf" mimeType="application/x-hdf" /> <mimeMap fileExtension=".hdml" mimeType="text/x-hdml" /> <mimeMap fileExtension=".hhc" mimeType="application/x-oleobject" /> <mimeMap fileExtension=".hhk" mimeType="application/octet-stream" /> <mimeMap fileExtension=".hhp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".hlp" mimeType="application/winhlp" /> <mimeMap fileExtension=".hqx" mimeType="application/mac-binhex40" /> <mimeMap fileExtension=".hta" mimeType="application/hta" /> <mimeMap fileExtension=".htc" mimeType="text/x-component" /> <mimeMap fileExtension=".htm" mimeType="text/html" /> <mimeMap fileExtension=".html" mimeType="text/html" /> <mimeMap fileExtension=".htt" mimeType="text/webviewhtml" /> <mimeMap fileExtension=".hxt" mimeType="text/html" /> <mimeMap fileExtension=".ico" mimeType="image/x-icon" /> <mimeMap fileExtension=".ics" mimeType="text/calendar" /> <mimeMap fileExtension=".ief" mimeType="image/ief" /> <mimeMap fileExtension=".iii" mimeType="application/x-iphone" /> <mimeMap fileExtension=".inf" mimeType="application/octet-stream" /> <mimeMap fileExtension=".ins" mimeType="application/x-internet-signup" /> <mimeMap fileExtension=".isp" mimeType="application/x-internet-signup" /> <mimeMap fileExtension=".IVF" mimeType="video/x-ivf" /> <mimeMap fileExtension=".jar" mimeType="application/java-archive" /> <mimeMap fileExtension=".java" mimeType="application/octet-stream" /> <mimeMap fileExtension=".jck" mimeType="application/liquidmotion" /> <mimeMap fileExtension=".jcz" mimeType="application/liquidmotion" /> <mimeMap fileExtension=".jfif" mimeType="image/pjpeg" /> <mimeMap fileExtension=".jpb" mimeType="application/octet-stream" /> <mimeMap fileExtension=".jpe" mimeType="image/jpeg" /> <mimeMap fileExtension=".jpeg" mimeType="image/jpeg" /> <mimeMap fileExtension=".jpg" mimeType="image/jpeg" /> <mimeMap fileExtension=".js" mimeType="application/javascript" /> <mimeMap fileExtension=".json" mimeType="application/json" /> <mimeMap fileExtension=".jsonld" mimeType="application/ld+json" /> <mimeMap fileExtension=".jsx" mimeType="text/jscript" /> <mimeMap fileExtension=".latex" mimeType="application/x-latex" /> <mimeMap fileExtension=".less" mimeType="text/css" /> <mimeMap fileExtension=".lit" mimeType="application/x-ms-reader" /> <mimeMap fileExtension=".lpk" mimeType="application/octet-stream" /> <mimeMap fileExtension=".lsf" mimeType="video/x-la-asf" /> <mimeMap fileExtension=".lsx" mimeType="video/x-la-asf" /> <mimeMap fileExtension=".lzh" mimeType="application/octet-stream" /> <mimeMap fileExtension=".m13" mimeType="application/x-msmediaview" /> <mimeMap fileExtension=".m14" mimeType="application/x-msmediaview" /> <mimeMap fileExtension=".m1v" mimeType="video/mpeg" /> <mimeMap fileExtension=".m2ts" mimeType="video/vnd.dlna.mpeg-tts" /> <mimeMap fileExtension=".m3u" mimeType="audio/x-mpegurl" /> <mimeMap fileExtension=".m4a" mimeType="audio/mp4" /> <mimeMap fileExtension=".m4v" mimeType="video/mp4" /> <mimeMap fileExtension=".man" mimeType="application/x-troff-man" /> <mimeMap fileExtension=".manifest" mimeType="application/x-ms-manifest" /> <mimeMap fileExtension=".map" mimeType="text/plain" /> <mimeMap fileExtension=".mdb" mimeType="application/x-msaccess" /> <mimeMap fileExtension=".mdp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".me" mimeType="application/x-troff-me" /> <mimeMap fileExtension=".mht" mimeType="message/rfc822" /> <mimeMap fileExtension=".mhtml" mimeType="message/rfc822" /> <mimeMap fileExtension=".mid" mimeType="audio/mid" /> <mimeMap fileExtension=".midi" mimeType="audio/mid" /> <mimeMap fileExtension=".mix" mimeType="application/octet-stream" /> <mimeMap fileExtension=".mmf" mimeType="application/x-smaf" /> <mimeMap fileExtension=".mno" mimeType="text/xml" /> <mimeMap fileExtension=".mny" mimeType="application/x-msmoney" /> <mimeMap fileExtension=".mov" mimeType="video/quicktime" /> <mimeMap fileExtension=".movie" mimeType="video/x-sgi-movie" /> <mimeMap fileExtension=".mp2" mimeType="video/mpeg" /> <mimeMap fileExtension=".mp3" mimeType="audio/mpeg" /> <mimeMap fileExtension=".mp4" mimeType="video/mp4" /> <mimeMap fileExtension=".mp4v" mimeType="video/mp4" /> <mimeMap fileExtension=".mpa" mimeType="video/mpeg" /> <mimeMap fileExtension=".mpe" mimeType="video/mpeg" /> <mimeMap fileExtension=".mpeg" mimeType="video/mpeg" /> <mimeMap fileExtension=".mpg" mimeType="video/mpeg" /> <mimeMap fileExtension=".mpp" mimeType="application/vnd.ms-project" /> <mimeMap fileExtension=".mpv2" mimeType="video/mpeg" /> <mimeMap fileExtension=".ms" mimeType="application/x-troff-ms" /> <mimeMap fileExtension=".msi" mimeType="application/octet-stream" /> <mimeMap fileExtension=".mso" mimeType="application/octet-stream" /> <mimeMap fileExtension=".mvb" mimeType="application/x-msmediaview" /> <mimeMap fileExtension=".mvc" mimeType="application/x-miva-compiled" /> <mimeMap fileExtension=".nc" mimeType="application/x-netcdf" /> <mimeMap fileExtension=".nsc" mimeType="video/x-ms-asf" /> <mimeMap fileExtension=".nws" mimeType="message/rfc822" /> <mimeMap fileExtension=".ocx" mimeType="application/octet-stream" /> <mimeMap fileExtension=".oda" mimeType="application/oda" /> <mimeMap fileExtension=".odc" mimeType="text/x-ms-odc" /> <mimeMap fileExtension=".ods" mimeType="application/oleobject" /> <mimeMap fileExtension=".oga" mimeType="audio/ogg" /> <mimeMap fileExtension=".ogg" mimeType="video/ogg" /> <mimeMap fileExtension=".ogv" mimeType="video/ogg" /> <mimeMap fileExtension=".one" mimeType="application/onenote" /> <mimeMap fileExtension=".onea" mimeType="application/onenote" /> <mimeMap fileExtension=".onetoc" mimeType="application/onenote" /> <mimeMap fileExtension=".onetoc2" mimeType="application/onenote" /> <mimeMap fileExtension=".onetmp" mimeType="application/onenote" /> <mimeMap fileExtension=".onepkg" mimeType="application/onenote" /> <mimeMap fileExtension=".osdx" mimeType="application/opensearchdescription+xml" /> <mimeMap fileExtension=".otf" mimeType="font/otf" /> <mimeMap fileExtension=".p10" mimeType="application/pkcs10" /> <mimeMap fileExtension=".p12" mimeType="application/x-pkcs12" /> <mimeMap fileExtension=".p7b" mimeType="application/x-pkcs7-certificates" /> <mimeMap fileExtension=".p7c" mimeType="application/pkcs7-mime" /> <mimeMap fileExtension=".p7m" mimeType="application/pkcs7-mime" /> <mimeMap fileExtension=".p7r" mimeType="application/x-pkcs7-certreqresp" /> <mimeMap fileExtension=".p7s" mimeType="application/pkcs7-signature" /> <mimeMap fileExtension=".pbm" mimeType="image/x-portable-bitmap" /> <mimeMap fileExtension=".pcx" mimeType="application/octet-stream" /> <mimeMap fileExtension=".pcz" mimeType="application/octet-stream" /> <mimeMap fileExtension=".pdf" mimeType="application/pdf" /> <mimeMap fileExtension=".pfb" mimeType="application/octet-stream" /> <mimeMap fileExtension=".pfm" mimeType="application/octet-stream" /> <mimeMap fileExtension=".pfx" mimeType="application/x-pkcs12" /> <mimeMap fileExtension=".pgm" mimeType="image/x-portable-graymap" /> <mimeMap fileExtension=".pko" mimeType="application/vnd.ms-pki.pko" /> <mimeMap fileExtension=".pma" mimeType="application/x-perfmon" /> <mimeMap fileExtension=".pmc" mimeType="application/x-perfmon" /> <mimeMap fileExtension=".pml" mimeType="application/x-perfmon" /> <mimeMap fileExtension=".pmr" mimeType="application/x-perfmon" /> <mimeMap fileExtension=".pmw" mimeType="application/x-perfmon" /> <mimeMap fileExtension=".png" mimeType="image/png" /> <mimeMap fileExtension=".pnm" mimeType="image/x-portable-anymap" /> <mimeMap fileExtension=".pnz" mimeType="image/png" /> <mimeMap fileExtension=".pot" mimeType="application/vnd.ms-powerpoint" /> <mimeMap fileExtension=".potm" mimeType="application/vnd.ms-powerpoint.template.macroEnabled.12" /> <mimeMap fileExtension=".potx" mimeType="application/vnd.openxmlformats-officedocument.presentationml.template" /> <mimeMap fileExtension=".ppam" mimeType="application/vnd.ms-powerpoint.addin.macroEnabled.12" /> <mimeMap fileExtension=".ppm" mimeType="image/x-portable-pixmap" /> <mimeMap fileExtension=".pps" mimeType="application/vnd.ms-powerpoint" /> <mimeMap fileExtension=".ppsm" mimeType="application/vnd.ms-powerpoint.slideshow.macroEnabled.12" /> <mimeMap fileExtension=".ppsx" mimeType="application/vnd.openxmlformats-officedocument.presentationml.slideshow" /> <mimeMap fileExtension=".ppt" mimeType="application/vnd.ms-powerpoint" /> <mimeMap fileExtension=".pptm" mimeType="application/vnd.ms-powerpoint.presentation.macroEnabled.12" /> <mimeMap fileExtension=".pptx" mimeType="application/vnd.openxmlformats-officedocument.presentationml.presentation" /> <mimeMap fileExtension=".prf" mimeType="application/pics-rules" /> <mimeMap fileExtension=".prm" mimeType="application/octet-stream" /> <mimeMap fileExtension=".prx" mimeType="application/octet-stream" /> <mimeMap fileExtension=".ps" mimeType="application/postscript" /> <mimeMap fileExtension=".psd" mimeType="application/octet-stream" /> <mimeMap fileExtension=".psm" mimeType="application/octet-stream" /> <mimeMap fileExtension=".psp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".pub" mimeType="application/x-mspublisher" /> <mimeMap fileExtension=".qt" mimeType="video/quicktime" /> <mimeMap fileExtension=".qtl" mimeType="application/x-quicktimeplayer" /> <mimeMap fileExtension=".qxd" mimeType="application/octet-stream" /> <mimeMap fileExtension=".ra" mimeType="audio/x-pn-realaudio" /> <mimeMap fileExtension=".ram" mimeType="audio/x-pn-realaudio" /> <mimeMap fileExtension=".rar" mimeType="application/octet-stream" /> <mimeMap fileExtension=".ras" mimeType="image/x-cmu-raster" /> <mimeMap fileExtension=".rf" mimeType="image/vnd.rn-realflash" /> <mimeMap fileExtension=".rgb" mimeType="image/x-rgb" /> <mimeMap fileExtension=".rm" mimeType="application/vnd.rn-realmedia" /> <mimeMap fileExtension=".rmi" mimeType="audio/mid" /> <mimeMap fileExtension=".roff" mimeType="application/x-troff" /> <mimeMap fileExtension=".rpm" mimeType="audio/x-pn-realaudio-plugin" /> <mimeMap fileExtension=".rtf" mimeType="application/rtf" /> <mimeMap fileExtension=".rtx" mimeType="text/richtext" /> <mimeMap fileExtension=".scd" mimeType="application/x-msschedule" /> <mimeMap fileExtension=".sct" mimeType="text/scriptlet" /> <mimeMap fileExtension=".sea" mimeType="application/octet-stream" /> <mimeMap fileExtension=".setpay" mimeType="application/set-payment-initiation" /> <mimeMap fileExtension=".setreg" mimeType="application/set-registration-initiation" /> <mimeMap fileExtension=".sgml" mimeType="text/sgml" /> <mimeMap fileExtension=".sh" mimeType="application/x-sh" /> <mimeMap fileExtension=".shar" mimeType="application/x-shar" /> <mimeMap fileExtension=".sit" mimeType="application/x-stuffit" /> <mimeMap fileExtension=".sldm" mimeType="application/vnd.ms-powerpoint.slide.macroEnabled.12" /> <mimeMap fileExtension=".sldx" mimeType="application/vnd.openxmlformats-officedocument.presentationml.slide" /> <mimeMap fileExtension=".smd" mimeType="audio/x-smd" /> <mimeMap fileExtension=".smi" mimeType="application/octet-stream" /> <mimeMap fileExtension=".smx" mimeType="audio/x-smd" /> <mimeMap fileExtension=".smz" mimeType="audio/x-smd" /> <mimeMap fileExtension=".snd" mimeType="audio/basic" /> <mimeMap fileExtension=".snp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".spc" mimeType="application/x-pkcs7-certificates" /> <mimeMap fileExtension=".spl" mimeType="application/futuresplash" /> <mimeMap fileExtension=".spx" mimeType="audio/ogg" /> <mimeMap fileExtension=".src" mimeType="application/x-wais-source" /> <mimeMap fileExtension=".ssm" mimeType="application/streamingmedia" /> <mimeMap fileExtension=".sst" mimeType="application/vnd.ms-pki.certstore" /> <mimeMap fileExtension=".stl" mimeType="application/vnd.ms-pki.stl" /> <mimeMap fileExtension=".sv4cpio" mimeType="application/x-sv4cpio" /> <mimeMap fileExtension=".sv4crc" mimeType="application/x-sv4crc" /> <mimeMap fileExtension=".svg" mimeType="image/svg+xml" /> <mimeMap fileExtension=".svgz" mimeType="image/svg+xml" /> <mimeMap fileExtension=".swf" mimeType="application/x-shockwave-flash" /> <mimeMap fileExtension=".t" mimeType="application/x-troff" /> <mimeMap fileExtension=".tar" mimeType="application/x-tar" /> <mimeMap fileExtension=".tcl" mimeType="application/x-tcl" /> <mimeMap fileExtension=".tex" mimeType="application/x-tex" /> <mimeMap fileExtension=".texi" mimeType="application/x-texinfo" /> <mimeMap fileExtension=".texinfo" mimeType="application/x-texinfo" /> <mimeMap fileExtension=".tgz" mimeType="application/x-compressed" /> <mimeMap fileExtension=".thmx" mimeType="application/vnd.ms-officetheme" /> <mimeMap fileExtension=".thn" mimeType="application/octet-stream" /> <mimeMap fileExtension=".tif" mimeType="image/tiff" /> <mimeMap fileExtension=".tiff" mimeType="image/tiff" /> <mimeMap fileExtension=".toc" mimeType="application/octet-stream" /> <mimeMap fileExtension=".tr" mimeType="application/x-troff" /> <mimeMap fileExtension=".trm" mimeType="application/x-msterminal" /> <mimeMap fileExtension=".ts" mimeType="video/vnd.dlna.mpeg-tts" /> <mimeMap fileExtension=".tsv" mimeType="text/tab-separated-values" /> <mimeMap fileExtension=".ttf" mimeType="application/octet-stream" /> <mimeMap fileExtension=".tts" mimeType="video/vnd.dlna.mpeg-tts" /> <mimeMap fileExtension=".txt" mimeType="text/plain" /> <mimeMap fileExtension=".u32" mimeType="application/octet-stream" /> <mimeMap fileExtension=".uls" mimeType="text/iuls" /> <mimeMap fileExtension=".ustar" mimeType="application/x-ustar" /> <mimeMap fileExtension=".vbs" mimeType="text/vbscript" /> <mimeMap fileExtension=".vcf" mimeType="text/x-vcard" /> <mimeMap fileExtension=".vcs" mimeType="text/plain" /> <mimeMap fileExtension=".vdx" mimeType="application/vnd.ms-visio.viewer" /> <mimeMap fileExtension=".vml" mimeType="text/xml" /> <mimeMap fileExtension=".vsd" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".vss" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".vst" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".vsto" mimeType="application/x-ms-vsto" /> <mimeMap fileExtension=".vsw" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".vsx" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".vtx" mimeType="application/vnd.visio" /> <mimeMap fileExtension=".wav" mimeType="audio/wav" /> <mimeMap fileExtension=".wax" mimeType="audio/x-ms-wax" /> <mimeMap fileExtension=".wbmp" mimeType="image/vnd.wap.wbmp" /> <mimeMap fileExtension=".wcm" mimeType="application/vnd.ms-works" /> <mimeMap fileExtension=".wdb" mimeType="application/vnd.ms-works" /> <mimeMap fileExtension=".webm" mimeType="video/webm" /> <mimeMap fileExtension=".wks" mimeType="application/vnd.ms-works" /> <mimeMap fileExtension=".wm" mimeType="video/x-ms-wm" /> <mimeMap fileExtension=".wma" mimeType="audio/x-ms-wma" /> <mimeMap fileExtension=".wmd" mimeType="application/x-ms-wmd" /> <mimeMap fileExtension=".wmf" mimeType="application/x-msmetafile" /> <mimeMap fileExtension=".wml" mimeType="text/vnd.wap.wml" /> <mimeMap fileExtension=".wmlc" mimeType="application/vnd.wap.wmlc" /> <mimeMap fileExtension=".wmls" mimeType="text/vnd.wap.wmlscript" /> <mimeMap fileExtension=".wmlsc" mimeType="application/vnd.wap.wmlscriptc" /> <mimeMap fileExtension=".wmp" mimeType="video/x-ms-wmp" /> <mimeMap fileExtension=".wmv" mimeType="video/x-ms-wmv" /> <mimeMap fileExtension=".wmx" mimeType="video/x-ms-wmx" /> <mimeMap fileExtension=".wmz" mimeType="application/x-ms-wmz" /> <mimeMap fileExtension=".woff" mimeType="font/x-woff" /> <mimeMap fileExtension=".woff2" mimeType="application/font-woff2" /> <mimeMap fileExtension=".wps" mimeType="application/vnd.ms-works" /> <mimeMap fileExtension=".wri" mimeType="application/x-mswrite" /> <mimeMap fileExtension=".wrl" mimeType="x-world/x-vrml" /> <mimeMap fileExtension=".wrz" mimeType="x-world/x-vrml" /> <mimeMap fileExtension=".wsdl" mimeType="text/xml" /> <mimeMap fileExtension=".wtv" mimeType="video/x-ms-wtv" /> <mimeMap fileExtension=".wvx" mimeType="video/x-ms-wvx" /> <mimeMap fileExtension=".x" mimeType="application/directx" /> <mimeMap fileExtension=".xaf" mimeType="x-world/x-vrml" /> <mimeMap fileExtension=".xaml" mimeType="application/xaml+xml" /> <mimeMap fileExtension=".xap" mimeType="application/x-silverlight-app" /> <mimeMap fileExtension=".xbap" mimeType="application/x-ms-xbap" /> <mimeMap fileExtension=".xbm" mimeType="image/x-xbitmap" /> <mimeMap fileExtension=".xdr" mimeType="text/plain" /> <mimeMap fileExtension=".xht" mimeType="application/xhtml+xml" /> <mimeMap fileExtension=".xhtml" mimeType="application/xhtml+xml" /> <mimeMap fileExtension=".xla" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xlam" mimeType="application/vnd.ms-excel.addin.macroEnabled.12" /> <mimeMap fileExtension=".xlc" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xlm" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xls" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xlsb" mimeType="application/vnd.ms-excel.sheet.binary.macroEnabled.12" /> <mimeMap fileExtension=".xlsm" mimeType="application/vnd.ms-excel.sheet.macroEnabled.12" /> <mimeMap fileExtension=".xlsx" mimeType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" /> <mimeMap fileExtension=".xlt" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xltm" mimeType="application/vnd.ms-excel.template.macroEnabled.12" /> <mimeMap fileExtension=".xltx" mimeType="application/vnd.openxmlformats-officedocument.spreadsheetml.template" /> <mimeMap fileExtension=".xlw" mimeType="application/vnd.ms-excel" /> <mimeMap fileExtension=".xml" mimeType="text/xml" /> <mimeMap fileExtension=".xof" mimeType="x-world/x-vrml" /> <mimeMap fileExtension=".xpm" mimeType="image/x-xpixmap" /> <mimeMap fileExtension=".xps" mimeType="application/vnd.ms-xpsdocument" /> <mimeMap fileExtension=".xsd" mimeType="text/xml" /> <mimeMap fileExtension=".xsf" mimeType="text/xml" /> <mimeMap fileExtension=".xsl" mimeType="text/xml" /> <mimeMap fileExtension=".xslt" mimeType="text/xml" /> <mimeMap fileExtension=".xsn" mimeType="application/octet-stream" /> <mimeMap fileExtension=".xtp" mimeType="application/octet-stream" /> <mimeMap fileExtension=".xwd" mimeType="image/x-xwindowdump" /> <mimeMap fileExtension=".z" mimeType="application/x-compress" /> <mimeMap fileExtension=".zip" mimeType="application/x-zip-compressed" /> </staticContent> <tracing> <traceProviderDefinitions> <add name="WWW Server" guid="{3a2a4e84-4c21-4981-ae10-3fda0d9b0f83}"> <areas> <clear /> <add name="Authentication" value="2" /> <add name="Security" value="4" /> <add name="Filter" value="8" /> <add name="StaticFile" value="16" /> <add name="CGI" value="32" /> <add name="Compression" value="64" /> <add name="Cache" value="128" /> <add name="RequestNotifications" value="256" /> <add name="Module" value="512" /> <add name="Rewrite" value="1024" /> <add name="FastCGI" value="4096" /> <add name="WebSocket" value="16384" /> </areas> </add> <add name="ASP" guid="{06b94d9a-b15e-456e-a4ef-37c984a2cb4b}"> <areas> <clear /> </areas> </add> <add name="ISAPI Extension" guid="{a1c2040e-8840-4c31-ba11-9871031a19ea}"> <areas> <clear /> </areas> </add> <add name="ASPNET" guid="{AFF081FE-0247-4275-9C4E-021F3DC1DA35}"> <areas> <add name="Infrastructure" value="1" /> <add name="Module" value="2" /> <add name="Page" value="4" /> <add name="AppServices" value="8" /> </areas> </add> </traceProviderDefinitions> <traceFailedRequests> <add path="*"> <traceAreas> <add provider="ASP" verbosity="Verbose" /> <add provider="ASPNET" areas="Infrastructure,Module,Page,AppServices" verbosity="Verbose" /> <add provider="ISAPI Extension" verbosity="Verbose" /> <add provider="WWW Server" areas="Authentication,Security,Filter,StaticFile,CGI,Compression,Cache,RequestNotifications,Module,Rewrite,WebSocket" verbosity="Verbose" /> </traceAreas> <failureDefinitions statusCodes="200-999" /> </add> </traceFailedRequests> </tracing> <urlCompression /> <validation /> <webdav> <globalSettings> <propertyStores> <add name="webdav_simple_prop" image="%IIS_BIN%\webdav_simple_prop.dll" image32="%IIS_BIN%\webdav_simple_prop.dll" /> </propertyStores> <lockStores> <add name="webdav_simple_lock" image="%IIS_BIN%\webdav_simple_lock.dll" image32="%IIS_BIN%\webdav_simple_lock.dll" /> </lockStores> </globalSettings> <authoring> <locks enabled="true" lockStore="webdav_simple_lock" /> </authoring> <authoringRules /> </webdav> <webSocket /> <applicationInitialization /> </system.webServer> <location path="" overrideMode="Allow"> <system.webServer> <modules> <add name="IsapiFilterModule" lockItem="true" /> <add name="BasicAuthenticationModule" lockItem="true" /> <add name="IsapiModule" lockItem="true" /> <add name="HttpLoggingModule" lockItem="true" /> <!-- <add name="HttpCacheModule" lockItem="true" /> --> <add name="DynamicCompressionModule" lockItem="true" /> <add name="StaticCompressionModule" lockItem="true" /> <add name="DefaultDocumentModule" lockItem="true" /> <add name="DirectoryListingModule" lockItem="true" /> <add name="ProtocolSupportModule" lockItem="true" /> <add name="HttpRedirectionModule" lockItem="true" /> <add name="ServerSideIncludeModule" lockItem="true" /> <add name="StaticFileModule" lockItem="true" /> <add name="AnonymousAuthenticationModule" lockItem="true" /> <add name="CertificateMappingAuthenticationModule" lockItem="true" /> <add name="UrlAuthorizationModule" lockItem="true" /> <add name="WindowsAuthenticationModule" lockItem="true" /> <!-- <add name="DigestAuthenticationModule" lockItem="true" /> --> <add name="IISCertificateMappingAuthenticationModule" lockItem="true" /> <add name="WebMatrixSupportModule" lockItem="true" /> <add name="IpRestrictionModule" lockItem="true" /> <add name="DynamicIpRestrictionModule" lockItem="true" /> <add name="RequestFilteringModule" lockItem="true" /> <add name="CustomLoggingModule" lockItem="true" /> <add name="CustomErrorModule" lockItem="true" /> <add name="FailedRequestsTracingModule" lockItem="true" /> <add name="CgiModule" lockItem="true" /> <add name="FastCgiModule" lockItem="true" /> <!-- <add name="WebDAVModule" /> --> <add name="RewriteModule" /> <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" preCondition="managedHandler" /> <add name="Session" type="System.Web.SessionState.SessionStateModule" preCondition="managedHandler" /> <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" preCondition="managedHandler" /> <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" preCondition="managedHandler" /> <add name="DefaultAuthentication" type="System.Web.Security.DefaultAuthenticationModule" preCondition="managedHandler" /> <add name="RoleManager" type="System.Web.Security.RoleManagerModule" preCondition="managedHandler" /> <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" preCondition="managedHandler" /> <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" preCondition="managedHandler" /> <add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" preCondition="managedHandler" /> <add name="Profile" type="System.Web.Profile.ProfileModule" preCondition="managedHandler" /> <add name="UrlMappingsModule" type="System.Web.UrlMappingsModule" preCondition="managedHandler" /> <add name="ConfigurationValidationModule" lockItem="true" /> <add name="WebSocketModule" lockItem="true" /> <add name="ServiceModel-4.0" type="System.ServiceModel.Activation.ServiceHttpModule,System.ServiceModel.Activation,Version=4.0.0.0,Culture=neutral,PublicKeyToken=31bf3856ad364e35" preCondition="managedHandler,runtimeVersionv4.0" /> <add name="UrlRoutingModule-4.0" type="System.Web.Routing.UrlRoutingModule" preCondition="managedHandler,runtimeVersionv4.0" /> <add name="ScriptModule-4.0" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="managedHandler,runtimeVersionv4.0" /> <add name="ServiceModel" type="System.ServiceModel.Activation.HttpModule, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="managedHandler,runtimeVersionv2.0" /> <add name="ApplicationInitializationModule" lockItem="true" /> <add name="AspNetCoreModule" lockItem="true" /> </modules> <handlers accessPolicy="Read, Script"> <!-- <add name="WebDAV" path="*" verb="PROPFIND,PROPPATCH,MKCOL,PUT,COPY,DELETE,MOVE,LOCK,UNLOCK" modules="WebDAVModule" resourceType="Unspecified" requireAccess="None" /> --> <add name="AXD-ISAPI-4.0_64bit" path="*.axd" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="PageHandlerFactory-ISAPI-4.0_64bit" path="*.aspx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="SimpleHandlerFactory-ISAPI-4.0_64bit" path="*.ashx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="WebServiceHandlerFactory-ISAPI-4.0_64bit" path="*.asmx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-rem-ISAPI-4.0_64bit" path="*.rem" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-soap-ISAPI-4.0_64bit" path="*.soap" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="svc-ISAPI-4.0_64bit" path="*.svc" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" /> <add name="rules-ISAPI-4.0_64bit" path="*.rules" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" /> <add name="xoml-ISAPI-4.0_64bit" path="*.xoml" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" /> <add name="xamlx-ISAPI-4.0_64bit" path="*.xamlx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" /> <add name="aspq-ISAPI-4.0_64bit" path="*.aspq" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="cshtm-ISAPI-4.0_64bit" path="*.cshtm" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="cshtml-ISAPI-4.0_64bit" path="*.cshtml" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="vbhtm-ISAPI-4.0_64bit" path="*.vbhtm" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="vbhtml-ISAPI-4.0_64bit" path="*.vbhtml" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="svc-Integrated" path="*.svc" verb="*" type="System.ServiceModel.Activation.HttpHandler, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="svc-ISAPI-2.0" path="*.svc" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" /> <add name="xoml-Integrated" path="*.xoml" verb="*" type="System.ServiceModel.Activation.HttpHandler, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="xoml-ISAPI-2.0" path="*.xoml" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" /> <add name="rules-Integrated" path="*.rules" verb="*" type="System.ServiceModel.Activation.HttpHandler, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="rules-ISAPI-2.0" path="*.rules" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" /> <add name="AXD-ISAPI-4.0_32bit" path="*.axd" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="PageHandlerFactory-ISAPI-4.0_32bit" path="*.aspx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="SimpleHandlerFactory-ISAPI-4.0_32bit" path="*.ashx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="WebServiceHandlerFactory-ISAPI-4.0_32bit" path="*.asmx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-rem-ISAPI-4.0_32bit" path="*.rem" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-soap-ISAPI-4.0_32bit" path="*.soap" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="svc-ISAPI-4.0_32bit" path="*.svc" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="rules-ISAPI-4.0_32bit" path="*.rules" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="xoml-ISAPI-4.0_32bit" path="*.xoml" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="xamlx-ISAPI-4.0_32bit" path="*.xamlx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" /> <add name="aspq-ISAPI-4.0_32bit" path="*.aspq" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="cshtm-ISAPI-4.0_32bit" path="*.cshtm" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="cshtml-ISAPI-4.0_32bit" path="*.cshtml" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="vbhtm-ISAPI-4.0_32bit" path="*.vbhtm" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="vbhtml-ISAPI-4.0_32bit" path="*.vbhtml" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="TraceHandler-Integrated-4.0" path="trace.axd" verb="GET,HEAD,POST,DEBUG" type="System.Web.Handlers.TraceHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="WebAdminHandler-Integrated-4.0" path="WebAdmin.axd" verb="GET,DEBUG" type="System.Web.Handlers.WebAdminHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="AssemblyResourceLoader-Integrated-4.0" path="WebResource.axd" verb="GET,DEBUG" type="System.Web.Handlers.AssemblyResourceLoader" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="PageHandlerFactory-Integrated-4.0" path="*.aspx" verb="GET,HEAD,POST,DEBUG" type="System.Web.UI.PageHandlerFactory" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="SimpleHandlerFactory-Integrated-4.0" path="*.ashx" verb="GET,HEAD,POST,DEBUG" type="System.Web.UI.SimpleHandlerFactory" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="WebServiceHandlerFactory-Integrated-4.0" path="*.asmx" verb="GET,HEAD,POST,DEBUG" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="HttpRemotingHandlerFactory-rem-Integrated-4.0" path="*.rem" verb="GET,HEAD,POST,DEBUG" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory, System.Runtime.Remoting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="HttpRemotingHandlerFactory-soap-Integrated-4.0" path="*.soap" verb="GET,HEAD,POST,DEBUG" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory, System.Runtime.Remoting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="svc-Integrated-4.0" path="*.svc" verb="*" type="System.ServiceModel.Activation.ServiceHttpHandlerFactory, System.ServiceModel.Activation, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="rules-Integrated-4.0" path="*.rules" verb="*" type="System.ServiceModel.Activation.ServiceHttpHandlerFactory, System.ServiceModel.Activation, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="xoml-Integrated-4.0" path="*.xoml" verb="*" type="System.ServiceModel.Activation.ServiceHttpHandlerFactory, System.ServiceModel.Activation, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="xamlx-Integrated-4.0" path="*.xamlx" verb="GET,HEAD,POST,DEBUG" type="System.Xaml.Hosting.XamlHttpHandlerFactory, System.Xaml.Hosting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="aspq-Integrated-4.0" path="*.aspq" verb="GET,HEAD,POST,DEBUG" type="System.Web.HttpForbiddenHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="cshtm-Integrated-4.0" path="*.cshtm" verb="GET,HEAD,POST,DEBUG" type="System.Web.HttpForbiddenHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="cshtml-Integrated-4.0" path="*.cshtml" verb="GET,HEAD,POST,DEBUG" type="System.Web.HttpForbiddenHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="vbhtm-Integrated-4.0" path="*.vbhtm" verb="GET,HEAD,POST,DEBUG" type="System.Web.HttpForbiddenHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="vbhtml-Integrated-4.0" path="*.vbhtml" verb="GET,HEAD,POST,DEBUG" type="System.Web.HttpForbiddenHandler" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="ScriptHandlerFactoryAppServices-Integrated-4.0" path="*_AppService.axd" verb="*" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="ScriptResourceIntegrated-4.0" path="*ScriptResource.axd" verb="GET,HEAD" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" preCondition="integratedMode,runtimeVersionv4.0" /> <add name="ASPClassic" path="*.asp" verb="GET,HEAD,POST" modules="IsapiModule" scriptProcessor="%IIS_BIN%\asp.dll" resourceType="File" /> <add name="SecurityCertificate" path="*.cer" verb="GET,HEAD,POST" modules="IsapiModule" scriptProcessor="%IIS_BIN%\asp.dll" resourceType="File" /> <add name="ISAPI-dll" path="*.dll" verb="*" modules="IsapiModule" resourceType="File" requireAccess="Execute" allowPathInfo="true" /> <add name="TraceHandler-Integrated" path="trace.axd" verb="GET,HEAD,POST,DEBUG" type="System.Web.Handlers.TraceHandler" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="WebAdminHandler-Integrated" path="WebAdmin.axd" verb="GET,DEBUG" type="System.Web.Handlers.WebAdminHandler" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="AssemblyResourceLoader-Integrated" path="WebResource.axd" verb="GET,DEBUG" type="System.Web.Handlers.AssemblyResourceLoader" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="PageHandlerFactory-Integrated" path="*.aspx" verb="GET,HEAD,POST,DEBUG" type="System.Web.UI.PageHandlerFactory" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="SimpleHandlerFactory-Integrated" path="*.ashx" verb="GET,HEAD,POST,DEBUG" type="System.Web.UI.SimpleHandlerFactory" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="WebServiceHandlerFactory-Integrated" path="*.asmx" verb="GET,HEAD,POST,DEBUG" type="System.Web.Services.Protocols.WebServiceHandlerFactory,System.Web.Services,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="HttpRemotingHandlerFactory-rem-Integrated" path="*.rem" verb="GET,HEAD,POST,DEBUG" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory,System.Runtime.Remoting,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="HttpRemotingHandlerFactory-soap-Integrated" path="*.soap" verb="GET,HEAD,POST,DEBUG" type="System.Runtime.Remoting.Channels.Http.HttpRemotingHandlerFactory,System.Runtime.Remoting,Version=2.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089" preCondition="integratedMode,runtimeVersionv2.0" /> <add name="AXD-ISAPI-2.0" path="*.axd" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="PageHandlerFactory-ISAPI-2.0" path="*.aspx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="SimpleHandlerFactory-ISAPI-2.0" path="*.ashx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="WebServiceHandlerFactory-ISAPI-2.0" path="*.asmx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-rem-ISAPI-2.0" path="*.rem" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-soap-ISAPI-2.0" path="*.soap" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness32" responseBufferLimit="0" /> <add name="svc-ISAPI-2.0-64" path="*.svc" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" /> <add name="AXD-ISAPI-2.0-64" path="*.axd" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="PageHandlerFactory-ISAPI-2.0-64" path="*.aspx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="SimpleHandlerFactory-ISAPI-2.0-64" path="*.ashx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="WebServiceHandlerFactory-ISAPI-2.0-64" path="*.asmx" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-rem-ISAPI-2.0-64" path="*.rem" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="HttpRemotingHandlerFactory-soap-ISAPI-2.0-64" path="*.soap" verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" responseBufferLimit="0" /> <add name="rules-64-ISAPI-2.0" path="*.rules" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" /> <add name="xoml-64-ISAPI-2.0" path="*.xoml" verb="*" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v2.0.50727\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv2.0,bitness64" /> <add name="CGI-exe" path="*.exe" verb="*" modules="CgiModule" resourceType="File" requireAccess="Execute" allowPathInfo="true" /> <add name="SSINC-stm" path="*.stm" verb="GET,HEAD,POST" modules="ServerSideIncludeModule" resourceType="File" /> <add name="SSINC-shtm" path="*.shtm" verb="GET,HEAD,POST" modules="ServerSideIncludeModule" resourceType="File" /> <add name="SSINC-shtml" path="*.shtml" verb="GET,HEAD,POST" modules="ServerSideIncludeModule" resourceType="File" /> <add name="TRACEVerbHandler" path="*" verb="TRACE" modules="ProtocolSupportModule" requireAccess="None" /> <add name="OPTIONSVerbHandler" path="*" verb="OPTIONS" modules="ProtocolSupportModule" requireAccess="None" /> <add name="ExtensionlessUrl-ISAPI-4.0_32bit" path="*." verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness32" responseBufferLimit="0" /> <add name="ExtensionlessUrlHandler-ISAPI-4.0_64bit" path="*." verb="GET,HEAD,POST,DEBUG" modules="IsapiModule" scriptProcessor="%windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll" preCondition="classicMode,runtimeVersionv4.0,bitness64" responseBufferLimit="0" /> <add name="ExtensionlessUrl-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" responseBufferLimit="0" /> <add name="StaticFile" path="*" verb="*" modules="StaticFileModule,DefaultDocumentModule,DirectoryListingModule" resourceType="Either" requireAccess="Read" /> </handlers> </system.webServer> </location> </configuration>
  14. Opa Quintelab, então brother, eu tenho esse código: private void VerificacaoPreliminar(IEnumerable<DataRow> dados) { int i = 4; bool importado = false; foreach (var linha in dados) { i++; //Verifica se nenhuma planilha com o numSEP informado já não foi importada if (!linha.ItemArray[17].ToString().Equals("")) { if (aplProcessoInteressado.listaProcInterPorCodSep(decimal.Parse(linha.ItemArray[17].ToString())).Count != 0) { importado = true; break; } } else { log.Append("A célula S referente a linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (!importado) { //Validação de campos obrigatórios if (linha.ItemArray[0].ToString().Equals("")) { log.Append("A célula A linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[6].ToString().Equals("")) { log.Append("A célula G linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[7].ToString().Equals("")) { log.Append("A célula H linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[14].ToString().Equals("")) { log.Append("A célula O linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } //Valida se pelo menos uma das colunas de NumProcesso está preenchida if (linha.ItemArray[1].ToString() == "" && linha.ItemArray[2].ToString() == "") { log.Append("A célula B linha " + (linha["indice"]) + " e / ou célula C referente a linha " + (linha["indice"]) + " devem estar preenchidas. <br>"); arquivoInvalidado = true; } //Valida se campo DataSep e Data de recebimento na oriegem encontram- se preenchidos if (linha.ItemArray[18].ToString().Equals("")) { log.Append("A célula S linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[19].ToString().Equals("")) { log.Append("A célula T linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } //Valida se a vara e comarca estão preenchidas no arquivo if (linha.ItemArray[3].ToString().Equals("")) { log.Append("A célula D referente a linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } if (linha.ItemArray[5].ToString().Equals("")) { log.Append("A célula F referente a linha " + (linha["indice"]) + " deve ser preenchida. <br>"); arquivoInvalidado = true; } //Valida a consistencia da vara, comarca e numvara. if (!linha.ItemArray[3].ToString().Equals("") && !linha.ItemArray[5].ToString().Equals("")) { List<VaraExecucao> listaVaraComarca = aplVaraExecucao.Consultar---omeVaraNomeComarca(linha.ItemArray[5].ToString().Trim(), linha.ItemArray[3].ToString().Trim()); if (listaVaraComarca.Count == 0) { log.Append("No sistema não existe vara de execução associada a comarca informada na linha " + (linha["indice"]) + ". Favor corrigir o sistema. <br>"); arquivoInvalidado = true; } else { VaraExecucao vara = new VaraExecucao(); if (linha.ItemArray[4].ToString().Equals("")) { vara = listaVaraComarca.Find(o => o.NumeroVara == null); } else { vara = listaVaraComarca.Find(o => o.NumeroVara == int.Parse(linha.ItemArray[4].ToString().Trim())); } if (vara == null || vara.Codigo == 0) { log.Append("O número da vara informado na célula E referente a linha " + (linha["indice"]) + " não corresponde a vara e comarca informada. Favor corrigir o sistema ou a planilha. <br>"); arquivoInvalidado = true; } } } if (listaInteressadoArq.Count != 0) { if (!listaInteressadoArq.Exists(o => o.Nome.Equals(linha.ItemArray[6].ToString().ToUpper()))) listaInteressadoArq.Add(this.setInteressado(linha, i)); else //apenas para verificar os dados do interessado informados na planilha setInteressado(linha, i); } else listaInteressadoArq.Add(this.setInteressado(linha, i)); //setInteressado(linha, i); } } if (importado) { log.Append("Uma planilha com o Nº SEP informado já foi importada. <br>"); arquivoInvalidado = true; } } Nesse código acima, eu gostaria de aplicar essa função de validar total de caracteres digitado em cada linha referente a este campo (coluna) da planilha excel e a ideia é já que possuo uma maneira de pegar o indice da linha, pegar e criar um log e enviar para o usuário, informando o nome da cédula e linha e a quantidade de caracter. É meio doido isso, mas a usuário me solicitou isso. Nesse outro código eu tenho o método onde eu verifico o layout da planilha excel. private bool VerificaLayout(DataTable dt) { if (!dt.Rows[4].ItemArray[0].Equals("Data de Requisição do Pgto")) return false; if (!dt.Rows[4].ItemArray[1].Equals("NUMERO PROCESSO ANTERIOR")) return false; if (!dt.Rows[4].ItemArray[2].Equals("NUMERO JUDICIAL")) return false; if (!dt.Rows[4].ItemArray[3].Equals("COMARCA")) return false; if (!dt.Rows[4].ItemArray[4].Equals("VARA")) return false; if (!dt.Rows[4].ItemArray[5].Equals("VARANOME")) return false; if (!dt.Rows[4].ItemArray[6].Equals("NOME")) return false; if (!dt.Rows[4].ItemArray[7].Equals("CPF")) return false; if (!dt.Rows[4].ItemArray[8].Equals("DEENDERECO")) return false; if (!dt.Rows[4].ItemArray[9].Equals("NUENDERECO")) return false; if (!dt.Rows[4].ItemArray[10].Equals("DECOMPLEMENTO")) return false; if (!dt.Rows[4].ItemArray[11].Equals("DEBAIRRO")) return false; if (!dt.Rows[4].ItemArray[12].Equals("NUCEP")) return false; if (!dt.Rows[4].ItemArray[13].Equals("NMMUNICIPIO")) return false; if (!dt.Rows[4].ItemArray[14].Equals("BRUTO")) return false; if (!dt.Rows[4].ItemArray[15].Equals("IRPF")) return false; if (!dt.Rows[4].ItemArray[16].Equals("LIQUIDO")) return false; if (!dt.Rows[4].ItemArray[17].Equals("Nº SEP")) return false; if (!dt.Rows[4].ItemArray[18].Equals("DATA SEP")) return false; if (!dt.Rows[4].ItemArray[19].Equals("DATA DE RECEBIMENTO NA ORIGEM")) return false; return true; } Você teria alguma ideia do que eu poderia esta fazendo? Irei olhar teu tópico e avaliar, mas aceito sugestões amigo. valeu até o momento.
  15. Tenho uma planilha com certos dados, e nessa planilha tenho a coluna M chamada NUCEP, eu preciso validar a quantidade de carácter antes de realizar minha importação, alguém poderia me sugerir uma forma de como fazer isso?
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.