public virtual void Init()
{
WorkspaceService = new WorkspaceService(Constants.ApiToken);
var workspaces = WorkspaceService.List();
ClientService = new ClientService(Constants.ApiToken);
TaskService = new TaskService(Constants.ApiToken);
TagService = new TagService(Constants.ApiToken);
ProjectService = new ProjectService(Constants.ApiToken);
UserService = new UserService(Constants.ApiToken);
TimeEntryService = new TimeEntryService(Constants.ApiToken);
ReportService = new ReportService(Constants.ApiToken);
foreach (var workspace in workspaces)
{
var projects = WorkspaceService.Projects(workspace.Id.Value);
var tasks = WorkspaceService.Tasks(workspace.Id.Value);
var tags = WorkspaceService.Tags(workspace.Id.Value); // TODO
var users = WorkspaceService.Users(workspace.Id.Value); // TODO
var clients = WorkspaceService.Clients(workspace.Id.Value);
var rte = new TimeEntryParams { StartDate = DateTime.Now.AddYears(-1)};
var timeEntries = TimeEntryService.List(rte);
Assert.IsTrue(TimeEntryService.DeleteIfAny(timeEntries.Select(te => te.Id.Value).ToArray()));
Assert.IsTrue(ProjectService.DeleteIfAny(projects.Select(p => p.Id.Value).ToArray()));
Assert.IsTrue(TaskService.DeleteIfAny(tasks.Select(t => t.Id.Value).ToArray()));
Assert.IsTrue(ClientService.DeleteIfAny(clients.Select(c => c.Id.Value).ToArray()));
Assert.IsFalse(WorkspaceService.Projects(workspace.Id.Value).Any());
Assert.IsFalse(WorkspaceService.Tasks(workspace.Id.Value).Any());
Assert.IsFalse(WorkspaceService.Clients(workspace.Id.Value).Any());
Assert.IsFalse(TimeEntryService.List(rte).Any());
}
DefaultWorkspaceId = workspaces.First().Id.Value;
}
public void ProjectChanged(Workspace project)
{
_designerViewModel = null;
_workspaceService = null;
DiagramDrawer = null;
if (project.CurrentGraph != null)
{
LoadDiagram(project.CurrentGraph);
}
else
{
}
}
public void Test_Bulk_Import_With_Sequence_X_Table()
{
//arrange - prepare bulk destination table
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v100Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.00");
_testDataService.CreateScriptFile(Path.Combine(v100Directory, $"TestCsv.sql"), _testDataService.GetSqlForCreateBulkTable(TEST_DBOBJECTS.TestCsv));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsv).ShouldBeTrue();
//arrange - add new minor version with csv files
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
string v101Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.01");
//deliverately create csv files out of order
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsv.csv"), Path.Combine(v101Directory, "2.TestCsv.csv"));
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsv.csv"), Path.Combine(v101Directory, "1.TestCsv.csv"));
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsv.csv"), Path.Combine(v101Directory, "3.TestCsv.csv"));
//act
configuration.TargetVersion = "v1.01";
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsv).ShouldBeTrue();
var results = _testDataService.GetBulkTestData(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsv);
var testDataRows = new List <BulkTestDataRow>
{
new BulkTestDataRow {
FirstName = "Jack", LastName = "Poole", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Diana", LastName = "Churchill", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Rebecca", LastName = "Lyman", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Sam", LastName = "Macdonald", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Matt", LastName = "Paige", BirthDate = "1980-01-01"
},
};
results.Count.ShouldBe(15);
testDataRows.All(t => results.Exists(r =>
t.FirstName == r.FirstName &&
t.LastName == r.LastName &&
t.BirthDate == r.BirthDate
)).ShouldBeTrue();
}
public void Test_Bulk_Import_With_Utf8_Encoded_File()
{
//arrange - pre-create destination bulk tables
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v100Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.00");
_testDataService.CreateScriptFile(Path.Combine(v100Directory, $"TestCsvUtf8.sql"), _testDataService.GetSqlForCreateBulkTable(TEST_DBOBJECTS.TestCsvUtf8));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsvUtf8).ShouldBeTrue();
//arrange - add new version with csv files
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
string v101Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.01");
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsvUtf8.csv"), Path.Combine(v101Directory, "TestCsvUtf8.csv"));
//act - bulk load csv files
configuration.TargetVersion = "v1.01";
configuration.IsAutoCreateDatabase = true;
migrationService.Run();
//assert
var results = _testDataService.GetBulkTestData(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsvUtf8);
var testDataRows = new List <BulkTestDataRow>
{
new BulkTestDataRow {
FirstName = "Allan", LastName = "Søgaard", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Martin", LastName = "Bæk", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Gitte", LastName = "Jürgensen", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Maria", LastName = "Østergård", BirthDate = "1980-01-01"
},
new BulkTestDataRow {
FirstName = "Peter", LastName = "Langkjær", BirthDate = "1980-01-01"
},
};
results.Count.ShouldBe(5);
testDataRows.All(t => results.Exists(r =>
t.FirstName == r.FirstName &&
t.LastName == r.LastName &&
t.BirthDate == r.BirthDate
)).ShouldBeTrue();
}
public void Test_Bulk_Import_Mismatch_Columns_But_Nullable()
{
//arrange - pre-create destination bulk tables
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v100Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.00");
_testDataService.CreateScriptFile(Path.Combine(v100Directory, $"TestCsvMismatchColumn.sql"), _testDataService.GetSqlForCreateBulkTable(TEST_DBOBJECTS.TestCsvMismatchColumn));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsvMismatchColumn).ShouldBeTrue();
//arrange - add new version with csv files
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
string v101Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.01");
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsvMismatchColumn.csv"), Path.Combine(v101Directory, "TestCsvMismatchColumn.csv"));
//act - bulk load csv files
configuration.TargetVersion = "v1.01";
migrationService.Run();
var results = _testDataService.GetBulkTestData(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsvMismatchColumn);
var testDataRows = new List <BulkTestDataRow>
{
new BulkTestDataRow {
FirstName = "Jack", LastName = "Poole"
},
new BulkTestDataRow {
FirstName = "Diana", LastName = "Churchill"
},
new BulkTestDataRow {
FirstName = "Rebecca", LastName = "Lyman"
},
new BulkTestDataRow {
FirstName = "Sam", LastName = "Macdonald"
},
new BulkTestDataRow {
FirstName = "Matt", LastName = "Paige"
},
};
results.Count.ShouldBe(5);
testDataRows.All(t => results.Exists(r =>
t.FirstName == r.FirstName &&
t.LastName == r.LastName &&
string.IsNullOrEmpty(r.BirthDate)
)).ShouldBeTrue();
}
public CodeActionHandler(ILoggerFactory factory, AnalysisService analysisService, WorkspaceService workspaceService)
{
_logger = factory.CreateLogger <TextDocumentHandler>();
_analysisService = analysisService;
_workspaceService = workspaceService;
_registrationOptions = new CodeActionRegistrationOptions
{
DocumentSelector = LspUtils.PowerShellDocumentSelector,
CodeActionKinds = s_supportedCodeActions
};
}
internal QueryExecutionService(ConnectionService connService, WorkspaceService <SqlToolsSettings> workspaceService)
{
ConnectionService = connService;
WorkspaceService = workspaceService;
Settings = new SqlToolsSettings();
}
public ResourceGridRowViewModel(WorkspaceService workspace, ResourceId resourceId)
{
Workspace = workspace;
ResourceId = resourceId;
}
public MonoreportsDesignerControl()
{
Build();
dpi = Gdk.Screen.Default.Resolution;
Report startReport = new Report()
{
DataScript = @"
datasource = new [] {
new { Name=""Alfred"", Surname = ""Tarski"", Age = ""82"" },
new { Name=""Saul"", Surname = ""Kripke"", Age = ""70"" },
new { Name=""Gotlob"", Surname = ""Frege"", Age = ""85"" },
new { Name=""Kurt"", Surname = ""Gödel"", Age = ""72"" },
};
parameters.Add(""Title"",new { Title = ""The Logicans"", SubTitle = ""...and philosophers...""});
"
};
string template = @"
using System;
using System.Collections.Generic;
{0}
public sealed class GenerateDataSource {{
public object Generate()
{{
object datasource = null;
Dictionary<string,object> parameters = new Dictionary<string,object>();
{1}
return new object[] {{datasource,parameters}};
}}
}}
";
compilerService = new CompilerService(template);
workspaceService = new WorkspaceService(this, maindesignview1.DesignDrawingArea, maindesignview1.PreviewDrawingArea, mainPropertygrid, StatusBarLabel);
designService = new DesignService(workspaceService, compilerService, startReport);
toolBoxService = new ToolBoxService();
designService.ToolBoxService = toolBoxService;
maindesignview1.DesignService = designService;
maindesignview1.WorkSpaceService = workspaceService;
maindesignview1.Compiler = compilerService;
var reportRenderer = new ReportRenderer();
reportRenderer.RegisterRenderer(typeof(Controls.TextBlock), new TextBlockRenderer()
{
DPI = dpi
});
reportRenderer.RegisterRenderer(typeof(Controls.Line), new LineRenderer()
{
DPI = dpi
});
reportRenderer.RegisterRenderer(typeof(MonoReports.Model.Controls.Image), new ImageRenderer()
{
PixbufRepository = designService.PixbufRepository, DPI = dpi
});
SectionRenderer sr = new SectionRenderer()
{
DPI = dpi
};
reportRenderer.RegisterRenderer(typeof(Controls.ReportHeaderSection), sr);
reportRenderer.RegisterRenderer(typeof(Controls.ReportFooterSection), sr);
reportRenderer.RegisterRenderer(typeof(Controls.DetailSection), sr);
reportRenderer.RegisterRenderer(typeof(Controls.PageHeaderSection), sr);
reportRenderer.RegisterRenderer(typeof(Controls.PageFooterSection), sr);
maindesignview1.ReportRenderer = reportRenderer;
workspaceService.InvalidateDesignArea();
reportExplorer.DesignService = designService;
reportExplorer.Workspace = workspaceService;
toolBoxService.AddTool(new ZoomTool(designService));
toolBoxService.AddTool(new LineTool(designService));
toolBoxService.AddTool(new LineToolV(designService));
toolBoxService.AddTool(new LineToolH(designService));
toolBoxService.AddTool(new TextBlockTool(designService));
toolBoxService.AddTool(new SubreportTool(designService));
toolBoxService.AddTool(new SectionTool(designService));
toolBoxService.AddTool(new ImageTool(designService));
toolBoxService.AddTool(new RectTool(designService));
toolBoxService.BuildToolBar(mainToolbar);
ToolBarButton exportPdfToolButton = new ToolBarButton("pdf.png", "exportPdf", "export to pdf");
exportPdfToolButton.Clicked += delegate(object sender, EventArgs e) {
designService.ExportToPdf();
};
mainToolbar.Insert(exportPdfToolButton, 7);
mainPropertygrid.LoadMonoreportsExtensions();
}
public ReferencesHandler(ILoggerFactory factory, SymbolsService symbolsService, WorkspaceService workspaceService)
{
_logger = factory.CreateLogger <ReferencesHandler>();
_symbolsService = symbolsService;
_workspaceService = workspaceService;
}
public NavbarViewComponent(IRepository <Workspace> workspaceRepository)
{
this._workspaceRepository = workspaceRepository;
_workspaceService = new WorkspaceService(_workspaceRepository);
}
public DocumentRangeFormattingHandler(ILoggerFactory factory, AnalysisService analysisService, ConfigurationService configurationService, WorkspaceService workspaceService)
{
_logger = factory.CreateLogger <DocumentRangeFormattingHandler>();
_analysisService = analysisService;
_configurationService = configurationService;
_workspaceService = workspaceService;
}
