public void CleanStorageTest() { // Add some records to all collections var app = new Application {Title = "App1"}; app = Provider.CreateApplicaton(app); var person = new Person {Login = "******", Title = "User Clever"}; person = Provider.CreatePerson(person); var module = new Module {AppId = app.Id, Title = "Module1"}; module = Provider.CreateModule(module); var subModule = new SubModule {ModuleId = module.Id, Title = "SubModule1"}; subModule = Provider.CreateSubModule(subModule); var release = new Release {AppId = app.Id, Title = "Release1"}; release = Provider.CreateRelease(release); var revision = new Revision { AppId = app.Id, BugNumber = 10, Rev = 1, Date = DateTime.Now, Type = BugType.Bug, FoundReleaseId = release.Id, TargetReleaseId = release.Id, Severity = BugSeverity.Critical, Priority = 1, Status = BugStatus.Open, ContributorId = person.Id, ModuleId = module.Id, SubModuleId = subModule.Id, Summary = "Summary text" }; Provider.CreateRevision(revision); // Check that everything is added to storage Assert.AreNotEqual(0, Provider.GetApplications().Length); Assert.AreNotEqual(0, Provider.GetModules(app.Id).Length); Assert.AreNotEqual(0, Provider.GetSubModules(module.Id).Length); Assert.AreNotEqual(0, Provider.GetStaff().Length); // Assert.AreNotEqual(0, Provider.GetBugs().Length); Assert.AreNotEqual(0, Provider.GetRevisions(10).Length); // Assert.AreNotEqual(0, Provider.GetReleases().Length); // Clean storage Provider.CleanStorage(); // And check that it is cleared Assert.AreEqual(0, Provider.GetApplications().Length); Assert.AreEqual(0, Provider.GetModules(app.Id).Length); Assert.AreEqual(0, Provider.GetSubModules(module.Id).Length); Assert.AreEqual(0, Provider.GetStaff().Length); // Assert.AreEqual(0, Provider.GetBugs().Length); Assert.AreEqual(0, Provider.GetRevisions(10).Length); // Assert.AreEqual(0, Provider.GetReleases().Length); }
private void OnTargetReleasesListBox_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { if (appsListBox.SelectedIndex != -1) { Application app = (Application)appsListBox.SelectedValue; // Request all releases Release[] releases = m_provider.GetReleases(app.Id); // And show targetReleasesListBox.ItemsSource = releases; targetReleasesListBox.DisplayMemberPath = "Title"; } }
/// <summary> /// Returns application by ID. /// </summary> public DTO.Application GetApplication(int appId) { EDM.Application appEDM; using (DbManager db = new DbManager()) { appEDM = db.SetCommand( @"SELECT * FROM Applications WHERE app_id = @AppId", db.InputParameter("@AppId", appId)). ExecuteObject <EDM.Application>(); } // Copy EDMs to DTOs DTO.Application appDTO = s_appCopier.Copy(appEDM); return(appDTO); }
//////////////////////////////////////////////////////////////// /// <summary> /// Creates new application. /// </summary> public DTO.Application CreateApplicaton(DTO.Application appDTO) { // Map DTO to EDM EDM.Application appEDM = s_appCopier.Copy(appDTO); // Insert application using (DbManager db = new DbManager()) { db.SetCommand( @" INSERT INTO Applications (app_title) VALUES (@app_title) SELECT Cast(SCOPE_IDENTITY() as int) app_id", db.CreateParameters(appEDM, new[] { "app_id" }, null, null)). ExecuteObject(appEDM); } // Map EDM to DTO appDTO = s_appCopier.Copy(appEDM); return(appDTO); }
public void CreateApplicatonTest() { const string appTitle = "TestApp"; var app = new Application {Title = appTitle}; Application actual = Provider.CreateApplicaton(app); Assert.IsNotNull(actual); Assert.AreNotEqual(0, actual.Id); Assert.AreEqual(appTitle, actual.Title); }
public void GetSubModulesTest() { const string title1 = "SubModule1"; const string title2 = "SubModule2"; const string title3 = "SubModule3"; var app = new Application { Title = "App1" }; app = Provider.CreateApplicaton(app); var module1 = new Module { AppId = app.Id, Title = "Module1" }; module1 = Provider.CreateModule(module1); var module2 = new Module { AppId = app.Id, Title = "Module2" }; module2 = Provider.CreateModule(module2); Provider.CreateSubModule( new SubModule { ModuleId = module1.Id, Title = title1 }); Provider.CreateSubModule( new SubModule { ModuleId = module1.Id, Title = title2 }); Provider.CreateSubModule( new SubModule { ModuleId = module2.Id, Title = title2 }); Provider.CreateSubModule( new SubModule { ModuleId = module2.Id, Title = title3 }); var actual = Provider.GetSubModules(module2.Id); Assert.IsNotNull(actual); Assert.AreEqual(2, actual.Length); Assert.AreNotEqual(0, actual[0].Id); Assert.AreEqual(module2.Id, actual[0].ModuleId); Assert.AreEqual(title2, actual[0].Title); Assert.AreNotEqual(0, actual[1].Id); Assert.AreEqual(module2.Id, actual[1].ModuleId); Assert.AreEqual(title3, actual[1].Title); }
public void GetRevisionsTest() { // Add some records to all collections var app = new Application { Title = "App1" }; app = Provider.CreateApplicaton(app); var contributor = new Person { Login = "******", Title = "Contributor" }; contributor = Provider.CreatePerson(contributor); var leader = new Person { Login = "******", Title = "Leader" }; leader = Provider.CreatePerson(leader); var dev = new Person { Login = "******", Title = "Developer" }; dev = Provider.CreatePerson(dev); var tester = new Person { Login = "******", Title = "QM" }; tester = Provider.CreatePerson(tester); var module = new Module { AppId = app.Id, Title = "Module1" }; module = Provider.CreateModule(module); var subModule = new SubModule { ModuleId = module.Id, Title = "SubModule1" }; subModule = Provider.CreateSubModule(subModule); var release = new Release { AppId = app.Id, Title = "Release1" }; release = Provider.CreateRelease(release); var revision1 = Provider.CreateRevision( new Revision { AppId = app.Id, BugNumber = 10, Rev = 1, Date = DateTime.Now, Type = BugType.Bug, FoundReleaseId = release.Id, TargetReleaseId = release.Id, Severity = BugSeverity.Critical, Priority = 1, Status = BugStatus.Open, ContributorId = contributor.Id, ModuleId = module.Id, SubModuleId = subModule.Id, Summary = "Summary text" }); var revision2 = Provider.CreateRevision( new Revision { AppId = app.Id, BugNumber = 10, Rev = 2, Date = DateTime.Now.Date, Type = BugType.Bug, FoundReleaseId = release.Id, TargetReleaseId = release.Id, Severity = BugSeverity.Critical, Priority = 1, Status = BugStatus.Verified, ContributorId = contributor.Id, TeamLeaderId = leader.Id, DeveloperId = dev.Id, TesterId = tester.Id, ModuleId = module.Id, SubModuleId = subModule.Id, Summary = "Summary text 2" }); Provider.CreateRevision( new Revision { AppId = app.Id, BugNumber = 12, Rev = 1, Date = DateTime.Now.Date, Type = BugType.Bug, Status = BugStatus.Open, ContributorId = contributor.Id, Summary = "Summary text 2" }); var revisions = Provider.GetRevisions(10); Assert.IsNotNull(revisions); Assert.AreEqual(2, revisions.Length); Assert.AreEqual(revision1, revisions[0]); Assert.AreEqual(revision2, revisions[1]); }
public void GetReleasesTest() { var app = new Application {Title = "App1"}; app = Provider.CreateApplicaton(app); Release release1 = Provider.CreateRelease(new Release {AppId = app.Id, Title = "Release1"}); Release release2 = Provider.CreateRelease(new Release {AppId = app.Id, Title = "Release2"}); Release[] actual = Provider.GetReleases(app.Id); Assert.IsNotNull(actual); Assert.AreEqual(2, actual.Length); Assert.AreNotEqual(0, actual[0].Id); Assert.AreEqual(release1.Title, actual[0].Title); Assert.AreNotEqual(0, actual[1].Id); Assert.AreEqual(release2.Title, actual[1].Title); }
public void GetModulesTest() { var app1 = new Application {Title = "App1"}; app1 = Provider.CreateApplicaton(app1); Provider.CreateModule(new Module {AppId = app1.Id, Title = "Module1"}); Provider.CreateModule(new Module {AppId = app1.Id, Title = "Module2"}); var app2 = new Application {Title = "App2"}; app2 = Provider.CreateApplicaton(app2); Module module3 = Provider.CreateModule(new Module {AppId = app2.Id, Title = "Module1"}); Module module4 = Provider.CreateModule(new Module {AppId = app2.Id, Title = "Module4"}); Module[] actual = Provider.GetModules(app2.Id); Assert.IsNotNull(actual); Assert.AreEqual(2, actual.Length); Assert.AreNotEqual(0, actual[0].Id); Assert.AreEqual(app2.Id, actual[0].AppId); Assert.AreEqual(module3.Title, actual[0].Title); Assert.AreNotEqual(0, actual[1].Id); Assert.AreEqual(app2.Id, actual[1].AppId); Assert.AreEqual(module4.Title, actual[1].Title); }
public void GetApplicationsTest() { const string appTitle1 = "TestApp1"; const string appTitle2 = "TestApp2"; // Create application var app1 = new Application {Title = appTitle1}; app1 = Provider.CreateApplicaton(app1); var app2 = new Application {Title = appTitle2}; app2 = Provider.CreateApplicaton(app2); Application[] actual = Provider.GetApplications(); Assert.IsNotNull(actual); Assert.AreEqual(2, actual.Length); Assert.IsNotNull(actual[0]); Assert.IsNotNull(actual[1]); Assert.AreEqual(appTitle1, actual[0].Title); Assert.AreEqual(app1.Id, actual[0].Id); Assert.AreEqual(appTitle2, actual[1].Title); Assert.AreEqual(app2.Id, actual[1].Id); }
public void CreateSubModuleTest() { const string title = "SubModule1"; var app = new Application { Title = "App1" }; app = Provider.CreateApplicaton(app); var module = new Module { AppId = app.Id, Title = "Module1" }; module = Provider.CreateModule(module); var subModule = new SubModule { ModuleId = module.Id, Title = title }; var actual = Provider.CreateSubModule(subModule); Assert.IsNotNull(actual); Assert.AreNotEqual(0, actual.Id); Assert.AreEqual(module.Id, actual.ModuleId); Assert.AreEqual(title, actual.Title); }
public void CreateRevisionTest() { // Add some records to all collections var app = new Application { Title = "App1" }; app = Provider.CreateApplicaton(app); var contributor = new Person { Login = "******", Title = "Contributor" }; contributor = Provider.CreatePerson(contributor); var leader = new Person { Login = "******", Title = "Leader" }; leader = Provider.CreatePerson(leader); var dev = new Person { Login = "******", Title = "Developer" }; dev = Provider.CreatePerson(dev); var tester = new Person { Login = "******", Title = "QM" }; tester = Provider.CreatePerson(tester); var module = new Module { AppId = app.Id, Title = "Module1" }; module = Provider.CreateModule(module); var subModule = new SubModule { ModuleId = module.Id, Title = "SubModule1" }; subModule = Provider.CreateSubModule(subModule); var release = new Release { AppId = app.Id, Title = "Release1" }; release = Provider.CreateRelease(release); var revision1 = new Revision { AppId = app.Id, BugNumber = 10, Rev = 1, Date = DateTime.Now, Type = BugType.Bug, FoundReleaseId = release.Id, TargetReleaseId = release.Id, Severity = BugSeverity.Critical, Priority = 1, Status = BugStatus.Open, ContributorId = contributor.Id, ModuleId = module.Id, SubModuleId = subModule.Id, Summary = "Summary text" }; var actual1 = Provider.CreateRevision(revision1); Assert.IsNotNull(actual1); Assert.AreEqual(app.Id, actual1.AppId); Assert.AreEqual(10, actual1.BugNumber); Assert.AreEqual(1, actual1.Rev); Assert.AreEqual(revision1.Date, actual1.Date); Assert.AreEqual(BugType.Bug, actual1.Type); Assert.AreEqual(release.Id, actual1.FoundReleaseId); Assert.AreEqual(release.Id, actual1.TargetReleaseId); Assert.AreEqual(1, actual1.Priority); Assert.AreEqual(BugSeverity.Critical, actual1.Severity); Assert.AreEqual(BugStatus.Open, actual1.Status); Assert.AreEqual(contributor.Id, actual1.ContributorId); Assert.IsFalse(actual1.TeamLeaderId.HasValue); Assert.IsFalse(actual1.DeveloperId.HasValue); Assert.IsFalse(actual1.TesterId.HasValue); Assert.AreEqual(module.Id, actual1.ModuleId); Assert.AreEqual(subModule.Id, actual1.SubModuleId); Assert.AreEqual(revision1.Summary, actual1.Summary); var revision2 = new Revision { AppId = app.Id, BugNumber = 10, Rev = 2, Date = DateTime.Now, Type = BugType.Bug, FoundReleaseId = release.Id, TargetReleaseId = release.Id, Severity = BugSeverity.Critical, Priority = 1, Status = BugStatus.Verified, ContributorId = contributor.Id, TeamLeaderId = leader.Id, DeveloperId = dev.Id, TesterId = tester.Id, ModuleId = module.Id, SubModuleId = subModule.Id, Summary = "Summary text 2" }; var actual2 = Provider.CreateRevision(revision2); Assert.IsNotNull(actual2); Assert.AreEqual(app.Id, actual2.AppId); Assert.AreEqual(10, actual2.BugNumber); Assert.AreEqual(2, actual2.Rev); Assert.AreEqual(revision2.Date, actual2.Date); Assert.AreEqual(BugType.Bug, actual2.Type); Assert.AreEqual(release.Id, actual2.FoundReleaseId); Assert.AreEqual(release.Id, actual2.TargetReleaseId); Assert.AreEqual(1, actual2.Priority); Assert.AreEqual(BugSeverity.Critical, actual2.Severity); Assert.AreEqual(BugStatus.Verified, actual2.Status); Assert.AreEqual(contributor.Id, actual2.ContributorId); Assert.AreEqual(leader.Id, actual2.TeamLeaderId); Assert.AreEqual(dev.Id, actual2.DeveloperId); Assert.AreEqual(tester.Id, actual2.TesterId); Assert.AreEqual(module.Id, actual2.ModuleId); Assert.AreEqual(subModule.Id, actual2.SubModuleId); Assert.AreEqual(revision2.Summary, actual2.Summary); }
public void CreateReleaseTest() { var app = new Application {Title = "App1"}; app = Provider.CreateApplicaton(app); var release = new Release {AppId = app.Id, Title = "Release1"}; Release actual = Provider.CreateRelease(release); Assert.IsNotNull(actual); Assert.AreNotEqual(0, actual.Id); Assert.AreEqual(release.Title, actual.Title); }
public void CreateModuleTest() { var app = new Application {Title = "App1"}; app = Provider.CreateApplicaton(app); var module = new Module {AppId = app.Id, Title = "Module1"}; Module actual = Provider.CreateModule(module); Assert.IsNotNull(actual); Assert.AreNotEqual(0, actual.Id); Assert.AreEqual(module.AppId, actual.AppId); Assert.AreEqual(module.Title, actual.Title); }