public void LoadDataSource()
{
EntityConnectionStringBuilder entityBuilder;
if (!CreateConnection(out entityBuilder))
{
return;
}
if (ItemsList != null)
{
ItemsList.Clear();
}
using (LoggerEntities context = new LoggerEntities(entityBuilder.ConnectionString))
{
try
{
ItemsList = new ObservableCollection <LogEntry>(context.LogEntries.OrderByDescending(l => l.id).ToList());
}
catch (Exception e)
{
logger.ErrorException("LoadDataSource", e);
MessageBox.Show(e.Message);
}
}
}
/// <summary>
/// Clears log at once
/// </summary>
public void ClearLog()
{
EntityConnectionStringBuilder entityBuilder;
if (!CreateConnection(out entityBuilder))
{
return;
}
using (LoggerEntities context = new LoggerEntities(entityBuilder.ConnectionString))
{
try
{
var list = new ObservableCollection <LogEntry>(context.LogEntries.ToList());
foreach (var logEntry in list)
{
context.DeleteObject(logEntry);
}
context.SaveChanges();
LoadDataSource();
}
catch (Exception e)
{
logger.ErrorException("LoadDataSource", e);
MessageBox.Show(e.Message);
}
}
}
