public void Execute(IReportTaskRunContext taskContext)
{
var sqlContext = SqlContextProvider.DefaultInstance
.CreateContext(ConnectionString);
var parValues = new List <object>();
var actualQuery = taskContext.SetQueryParameters(parValues, Query);
sqlContext.UsingConnection(connectionContext =>
{
if (parValues.Count > 0)
{
connectionContext
.CreateSimple(new QueryOptions(TimeOut), $"{actualQuery}",
parValues.ToArray())
.UseReader(reader =>
{
var pack = packageBuilder.GetPackage(reader, GroupNumbers);
for (int i = 0; i < DataSetNames.Count; i++)
{
if (pack.DataSets.ElementAtOrDefault(i) != null)
{
pack.DataSets[i].Name = DataSetNames[i];
}
}
taskContext.Packages[Properties.PackageName] = pack;
});
}
else
{
connectionContext
.CreateSimple(new QueryOptions(TimeOut), $"{actualQuery}")
.UseReader(reader =>
{
var pack = packageBuilder.GetPackage(reader, GroupNumbers);
for (int i = 0; i < DataSetNames.Count; i++)
{
if (pack.DataSets.ElementAtOrDefault(i) != null)
{
pack.DataSets[i].Name = DataSetNames[i];
}
}
taskContext.Packages[Properties.PackageName] = pack;
});
}
});
}
public async Task <string> GetTasksList_HtmlPageAsync()
{
List <IReportTask> currentTasks;
lock (this)
currentTasks = tasks.ToList();
var tasksData = currentTasks.Select(task => new
{
task.Id,
task.Name,
task.Schedule?.Schedule,
Operations = string.Join("=>", task.Operations.Select(oper => oper.Properties.Name))
});
var pack = packageBuilder.GetPackage(tasksData);
return(await Task.Factory.StartNew(() =>
tableView.ExecuteHtml("Current tasks list", pack)));
}
public void Execute(IReportTaskRunContext taskContext)
{
var fullPath = Path.Combine(FileFolder == "Default folder" ? taskContext.DataFolderPath : FileFolder,
FileName);
var fi = new FileInfo(fullPath);
using (var pack = new ExcelPackage(fi))
{
var package = packageBuilder.GetPackage(pack, ExcelParameters, GroupNumbers);
taskContext.Packages[Properties.PackageName] = package;
}
}
private void Execute(IReportTaskRunContext taskContext)
{
var fullPath = Path.Combine(FileFolder == "Default folder" ? taskContext.DataFolderPath : FileFolder,
FileName);
var fi = new FileInfo(fullPath);
using var pack = new ExcelPackage(fi);
var package = packageBuilder.GetPackage(pack, ExcelParameters, GroupNumbers);
if (SendVoidPackageError && !package.DataSets.Any())
{
throw new InvalidDataException("No datasets obtaned during import");
}
taskContext.Packages[Properties.PackageName] = package;
}
protected virtual void FillPackage(DbDataReader reader, IReportTaskRunContext taskContext)
{
var pack = packageBuilder.GetPackage(reader, GroupNumbers);
if (SendVoidPackageError && !pack.DataSets.Any())
{
throw new InvalidDataException("No datasets obtaned during import");
}
for (int i = 0; i < DataSetNames.Count; i++)
{
if (pack.DataSets.ElementAtOrDefault(i) != null)
{
pack.DataSets[i].Name = DataSetNames[i];
}
}
taskContext.Packages[Properties.PackageName] = pack;
}
public void Execute(IReportTaskRunContext taskContext)
{
var fullPath = Path.Combine(FileFolder == "Default folder" ? taskContext.DataFolderPath :
FileFolder, FileName);
using (var textReader =
File.OpenText(fullPath))
{
using (var csvReader = new CsvReader(textReader))
{
csvReader.Configuration.Delimiter = Delimiter;
var pack = packageBuilder.GetPackage(csvReader, GroupNumbers);
pack.DataSets.First().Name = DataSetName;
taskContext.Packages[Properties.PackageName] = pack;
}
}
}
private void Execute(IReportTaskRunContext taskContext)
{
var fullPath = Path.Combine(FileFolder == "Default folder" ? taskContext.DataFolderPath : FileFolder,
FileName);
using var textReader = File.OpenText(fullPath);
using var csvReader = new CsvReader(textReader);
csvReader.Configuration.Delimiter = Delimiter;
var pack = packageBuilder.GetPackage(csvReader, GroupNumbers);
if (SendVoidPackageError && !pack.DataSets.Any())
{
throw new InvalidDataException("No datasets obtaned during import");
}
if (!string.IsNullOrEmpty(DataSetName))
{
pack.DataSets.First().Name = DataSetName;
}
taskContext.Packages[Properties.PackageName] = pack;
}