public byte[] AsPortableDocumentBytes()
{
var buffer = new MemoryStream();
var sw = Stopwatch.StartNew();
using (var stream = ReportDocument.ExportToStream(ExportFormatType.PortableDocFormat))
stream.CopyTo(buffer);
sw.Stop();
SboAddonTracker.TrackEvent("RenderReport", new Dictionary <string, string> {
["ReportName"] = ReportDocument.Name
}, new Dictionary <string, double> {
["Duration"] = sw.ElapsedMilliseconds
});
return(buffer.ToArray());
}
public static void ExecuteQueryEx(this DataTable dataTable, string query, params object[] args)
{
var inQuery = String.Format(query, args);
try
{
Logger.Trace("Executing query on datatable: {0}", inQuery);
var sw = Stopwatch.StartNew();
dataTable.ExecuteQuery(inQuery);
sw.Stop();
SboAddonTracker.TrackEvent("Query", metrics: new Dictionary <string, double> {
["RecordCount"] = dataTable.Rows.Count, ["Duration"] = sw.ElapsedMilliseconds
});
}
catch (Exception e)
{
Logger.Error(e, "Error executing query: " + inQuery);
throw;
}
}
public Task <bool> Run(ScheduledTask task, IProgress <SboJobProgress> progress = null, bool force = false)
{
Task <bool> returnTask = Task.FromResult(false);
try
{
SboTransaction.Start();
var lockResult = SboDistributedLock.GetLock($"SboTaskScheduler.{task.Name}");
if (lockResult != 0)
{
SboTransaction.Rollback();
return(returnTask);
}
var lastOccurrence = SboAddon.Instance.Settings.GetValueOrDefault <DateTime?>("taskscheduler.lastoccurrence." + task.Name);
var nextOccurrence = SboAddon.Instance.Settings.GetValueOrDefault <DateTime?>("taskscheduler.nextoccurrence." + task.Name);
var synchronicity = task.IsAsync ? "asynchronous" : "synchronous";
Logger.Trace(
$"Checking if task {task.Name} is applicable, last occurrence {lastOccurrence} - next occurrence {nextOccurrence}");
if (force || !nextOccurrence.HasValue || nextOccurrence.Value < DateTime.Now)
{
// Set new values
lastOccurrence = DateTime.Now;
nextOccurrence = task.Schedule.GetNextOccurrence(lastOccurrence.Value);
SboAddon.Instance.Settings.SetValue("taskscheduler.lastoccurrence." + task.Name, lastOccurrence.Value);
SboAddon.Instance.Settings.SetValue("taskscheduler.nextoccurrence." + task.Name, nextOccurrence.Value);
SboTransaction.Commit();
// Run task
var cancellationToken = CancellationToken.None;
var task1 = task;
var progressObject = progress;
returnTask = Task.Factory.StartNew(async() =>
{
Logger.Info($@"Running {synchronicity} task {task.Name}.");
var stopwatch = Stopwatch.StartNew();
try
{
task.Action?.Invoke(progressObject);
if (task.AsyncAction != null)
{
await task.AsyncAction(progressObject);
}
}
catch (Exception e)
{
Logger.Error(e, $"Unhandled exception occurred running scheduled task {task.Name}");
}
stopwatch.Stop();
Logger.Info(
$"Completed task {task1.Name} in {stopwatch.Elapsed}. Next occurrence {nextOccurrence}");
SboAddonTracker.TrackEvent("ScheduledTaskRun", new Dictionary <string, string> {
["TaskName"] = task1.Name
},
new Dictionary <string, double> {
["Duration"] = stopwatch.ElapsedMilliseconds
});
return(true);
}, cancellationToken, TaskCreationOptions.None,
task.IsAsync ? TaskScheduler.Default : SboAddon.Instance.UiTaskScheduler).Unwrap();
}
else if (SboAddon.Instance.Company.InTransaction)
{
SboTransaction.Commit();
}
task.LastOccurrence = lastOccurrence;
}
catch (Exception e)
{
Logger.Error(e, "Unhandled exception occurred running scheduled tasks");
try { SboTransaction.Rollback(); } catch (Exception) { }
}
return(returnTask);
}