public static void Log(string pServiceName, string pOperationName, string pParams = null, string pUserName = null)
{
LogTableAdapter logAdapter = new LogTableAdapter();
logAdapter.AddEntry(pServiceName, pOperationName, pParams, pUserName == null ? HttpContext.Current.User.Identity.Name : pUserName);
logAdapter.Dispose();
}
private void MNBRibbon_Load(object sender, RibbonUIEventArgs e)
{
_mnbService = new MNBArfolyamServiceSoapClient();
_operatorService = new OperatorService();
_logDatabaseDataSet = new LogDatabaseDataSet();
_logTableAdapter = new LogTableAdapter();
_logTableAdapter.Fill(_logDatabaseDataSet.Log);
_logBindingSource = new BindingSource();
}
public Logger()
{
logDataSet = new LogDataSet();
logDataSet.BeginInit();
logBindingSource = new BindingSource();
logBindingSource.DataSource = logDataSet.Log;
logTableAdapter = new LogTableAdapter();
logTableAdapter.Fill(logDataSet.Log);
logDataSet.EndInit();
}
public void InitDatabaseSchema()
{
var commands = new string[0];
using (var script = new System.IO.StreamReader(this.GetType().Assembly.GetManifestResourceStream(this.GetType().Assembly.GetName().Name + ".NLogger.sql")))
{
commands = script.ReadToEnd().Split(new string[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);
}
using (var adapter = new LogTableAdapter())
{
adapter.Connection.Open();
var cmd = adapter.Connection.CreateCommand();
foreach (var command in commands)
{
cmd.CommandText = command;
cmd.ExecuteNonQuery();
}
}
}
public List <LogItem> FindLogs(DateTime fromDate, DateTime toDate, string levelFilter, string loggerFilter, string messageFilter, string userFilter, string sessionFilter)
{
List <LogItem> logs = new List <LogItem>();
LogTableAdapter adapter = new LogTableAdapter();
NLogData.LogDataTable table = adapter.FindLogs(fromDate, toDate, levelFilter, loggerFilter, messageFilter, userFilter, sessionFilter);
if (table.Count > 0)
{
foreach (NLogData.LogRow row in table)
{
logs.Add(new LogItem()
{
Id = row.Id,
Logger = row.Logger,
Level = row.Level,
Message = row.Message,
SessionId = row.SessionId,
TimeStamp = row.TimeStamp,
User = row.User
});
}
}
return(logs);
}
public List <LogVO> LoadLogEntries(int min, int max)
{
List <LogVO> result = null;
try
{
AuthenticationService.CheckIfUSerIsAuthenticated();
LogService.Log("LogService", "LoadLogs", String.Format("Min:{0}; Max: {1}", min, max));
LogTableAdapter adapter = new LogTableAdapter();
result = new List <LogVO>();
ONyRDataSet.LogDataTable table = adapter.GetDataByRowNumber(min, max);
for (int i = 0; i < table.Count; ++i)
{
DateTime date;
try
{
date = table[i].Date;
}
catch (Exception)
{
date = DateTime.MinValue;
}
String sparams;
try
{
sparams = table[i].Params;
}
catch (Exception)
{
sparams = "";
}
String userName;
try
{
userName = table[i].UserName;
}
catch (Exception)
{
userName = "";
}
result.Add(new LogVO(table[i].ID, table[i].ServiceName, table[i].OperationName, sparams, userName, date));
}
adapter.Dispose();
}
catch (ONyRException e)
{
LogService.LogError(e.ErrorCode, e.StackTrace);
throw new FaultException <ONyRFaultException>(new ONyRFaultException((int)e.ErrorCode));
}
catch (Exception e)
{
LogService.LogError(ErrorCode.UnknownError, e.StackTrace, e.Message);
throw new FaultException <ONyRFaultException>(new ONyRFaultException((int)ErrorCode.UnknownError));
}
return(result);
}
