private void WriteLog(SLogLevel logLevel, string sEventType, string sLogMessage, string sStackTrace) { string sql = @"INSERT INTO [dbo].[tblLog] (app_name, app_type, log_date, log_message, log_level, event_type, userid, user_machine_name) VALUES (@app_name,@app_type,@log_date,@log_message,@log_level,@event_type,@userid,@user_machine_name)"; using (SqlConnection cnn = new SqlConnection(SLogConfig.LogConnectionString)) { try { cnn.Open(); using (SqlCommand cmd = new SqlCommand(sql, cnn)) { cmd.Parameters.Add("@app_name", SqlDbType.NVarChar).Value = SLogConfig.ApplicationName; cmd.Parameters.Add("@app_type", SqlDbType.NVarChar).Value = SLogConfig.ApplicationType.ToString(); cmd.Parameters.Add("@log_date", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@log_message", SqlDbType.NVarChar).Value = sLogMessage; cmd.Parameters.Add("@log_level", SqlDbType.NVarChar).Value = logLevel.ToString(); cmd.Parameters.Add("@event_type", SqlDbType.NVarChar).Value = sEventType; cmd.Parameters.Add("@userid", SqlDbType.NVarChar).Value = SLogConfig.UserName; cmd.Parameters.Add("@user_machine_name", SqlDbType.NVarChar).Value = SLogConfig.MachineName; cmd.ExecuteNonQuery(); } } catch (Exception ex) { Console.WriteLine("ERROR:" + ex.Message); throw ex; } } }
public void Log(SLogLevel logLevel, string sEventType, string sMessageToLog, string sException) { WriteLog(logLevel, sEventType, sMessageToLog, sException); }