xp-dev.com Git - CPE_learningsite/blob - CPE/CPE.App/CPE.App.NotifyService/App.config

   1 <?xml version="1.0" encoding="utf-8"?>
   2
   3 <configuration>
   4   <configSections>
   5     <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
   6   </configSections>
   7   <startup>
   8     <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
   9   </startup>
  10   <connectionStrings>
  11     <add name="CPE.Data" connectionString="Data Source=localhost;Initial Catalog=webcpe_reporting;Persist Security Info=True;User ID=sa;Password=intesolver"
  12       providerName="System.Data.SqlClient" />
  13     <add name="CPE.App.NotifyConsole.Properties.Settings.webcpe_reportingConnectionString"
  14       connectionString="Data Source=localhost;Initial Catalog=webcpe_reporting;Integrated Security=True"
  15       providerName="System.Data.SqlClient" />
  16   </connectionStrings>
  17   <appSettings>
  18     <add key="NotifyFilePath" value="C:\Bitbucket\InteSolv\cpe-learningsite\CPE\CPE.App\CPE.App.NotifyConsole\bin\Debug\CPE.App.NotifyConsole.exe" />
  19     <add key="Debugging" value="false"/>
  20     <add key="ServiceInterval" value="60000"/>
  21   </appSettings>
  22   <log4net>
  23     <root>
  24       <level value="ALL" />
  25       <appender-ref ref="RollingFileAppender" />
  26       <appender-ref ref="ColoredConsoleAppender" />
  27       <appender-ref ref="SqlAppender" />
  28     </root>
  29     <appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
  30       <file value="rolling.log" />
  31       <appendToFile value="true" />
  32       <rollingStyle value="Size" />
  33       <maxSizeRollBackups value="5" />
  34       <maximumFileSize value="10MB" />
  35       <staticLogFileName value="true" />
  36       <layout type="log4net.Layout.PatternLayout">
  37         <conversionPattern value="[%date][%level]%message%newline" />
  38       </layout>
  39     </appender>
  40     <appender name="ColoredConsoleAppender" type="log4net.Appender.ColoredConsoleAppender">
  41       <mapping>
  42         <level value="WARN" />
  43         <foreColor value="Yellow" />
  44       </mapping>
  45       <mapping>
  46         <level value="ERROR" />
  47         <foreColor value="Red" />
  48         <backColor value="White" />
  49       </mapping>
  50       <mapping>
  51         <level value="FATAL" />
  52         <foreColor value="White" />
  53         <backColor value="Red" />
  54       </mapping>
  55       <mapping>
  56         <level value="INFO" />
  57         <foreColor value="Cyan" />
  58       </mapping>
  59       <mapping>
  60         <level value="DEBUG" />
  61         <foreColor value="Green" />
  62       </mapping>
  63       <layout type="log4net.Layout.PatternLayout">
  64         <conversionPattern value="[%date][%level]%message%newline" />
  65       </layout>
  66     </appender>
  67     <appender name="SqlAppender" type="log4net.Appender.AdoNetAppender">
  68       <bufferSize value="1" />
  69       <connectionType
  70         value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  71       <connectionString
  72         value="Data Source=localhost;Initial Catalog=webcpe_reporting;Persist Security Info=True;User ID=sa;Password=intesolver" />
  73       <commandText
  74         value="EXEC [AddNotifyLog] @log_date, @thread, @log_level, @logger, @message, @exception" />
  75       <parameter>
  76         <parameterName value="@log_date" />
  77         <dbType value="DateTime" />
  78         <layout type="log4net.Layout.RawTimeStampLayout" />
  79       </parameter>
  80       <parameter>
  81         <parameterName value="@thread" />
  82         <dbType value="String" />
  83         <size value="255" />
  84         <layout type="log4net.Layout.PatternLayout">
  85           <conversionPattern value="%thread" />
  86         </layout>
  87       </parameter>
  88       <parameter>
  89         <parameterName value="@log_level" />
  90         <dbType value="String" />
  91         <size value="50" />
  92         <layout type="log4net.Layout.PatternLayout">
  93           <conversionPattern value="%level" />
  94         </layout>
  95       </parameter>
  96       <parameter>
  97         <parameterName value="@logger" />
  98         <dbType value="String" />
  99         <size value="255" />
 100         <layout type="log4net.Layout.PatternLayout">
 101           <conversionPattern value="%logger" />
 102         </layout>
 103       </parameter>
 104       <parameter>
 105         <parameterName value="@message" />
 106         <dbType value="String" />
 107         <size value="4000" />
 108         <layout type="log4net.Layout.PatternLayout">
 109           <conversionPattern value="%message" />
 110         </layout>
 111       </parameter>
 112       <parameter>
 113         <parameterName value="@exception" />
 114         <dbType value="String" />
 115         <size value="2000" />
 116         <layout type="log4net.Layout.ExceptionLayout" />
 117       </parameter>
 118     </appender>
 119   </log4net>
 120 </configuration>