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; }