public void GivenANewServiceOffering_WhenSaveChanges_ThenDatabaseContainsServiceOfferings()
{
Target.ServiceOfferings.Add(new ServiceOffering
{
Provider = new Provider
{
Name = "999999"
},
ServiceType = new ServiceType
{
Name = "999999"
},
Program = new Program
{
Name = "99999"
}
});
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.ServiceOfferings.SingleOrDefault(s => s.Provider.Name.Equals("999999") && s.ServiceType.Name.Equals("999999")));
}
}
public void WhenCreate_ThenGetInstance()
{
using (EducationDataContext actual = EducationDataContextFactory.Create(MockKernel))
{
Assert.IsNotNull(actual);
}
}
public void WhenInitialize_ThenExpectedPropertiesAreProtected()
{
var expected = new List <Property>
{
new Property {
EntityName = "SSD.Domain.Student", Name = "StudentKey"
},
new Property {
EntityName = "SSD.Domain.Student", Name = "ServiceRequests"
},
new Property {
EntityName = "SSD.Domain.Student", Name = "StudentAssignedOfferings"
},
new Property {
EntityName = "SSD.Domain.ServiceOffering", Name = "StudentAssignedOfferings"
}
};
ResetDatabase();
Target.Dispose();
Target = new EducationDataContext();
var actual = Target.Properties.Where(p => p.IsProtected).ToList();
Assert.IsTrue(expected.All(p => actual.Exists(a => a.Name == p.Name && a.EntityName == p.EntityName)));
Assert.IsFalse(actual.Any(a => !expected.Exists(p => p.Name == a.Name && p.EntityName == a.EntityName)));
}
public void GivenInjectedCache_WhenCreate_ThenContextCacheIsSet()
{
using (EducationDataContext actual = EducationDataContextFactory.Create(MockKernel))
{
MockConfigurator.AssertWasCalled(m => m.Configure(MockKernel, actual));
}
}
public void InitializeTest()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
Target = new AgreementManager(repositoryContainer);
}
public static void CleanupAssembly()
{
using (EducationDataContext context = new EducationDataContext())
{
context.Database.Delete();
}
}
public void InitializeTest()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
Target = new PrivateHealthFieldManager(repositoryContainer, MockRepository.GenerateMock<IBlobClient>(), new DataTableBinder(), new UserAuditor());
}
public void GivenANewServiceOffering_WhenSaveChanges_ThenDatabaseContainsServiceOfferings()
{
Target.ServiceOfferings.Add(new ServiceOffering
{
Provider = new Provider
{
Name = "999999"
},
ServiceType = new ServiceType
{
Name = "999999"
},
Program = new Program
{
Name = "99999"
}
});
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.ServiceOfferings.SingleOrDefault(s => s.Provider.Name.Equals("999999") && s.ServiceType.Name.Equals("999999")));
}
}
public static void InitializeAssembly(TestContext testContext)
{
using (EducationDataContext context = new EducationDataContext())
{
context.Database.Delete();
context.Database.Initialize(true);
}
}
public void TestInitialize()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
Target = new ServiceOfferingManager(repositoryContainer, new DataTableBinder());
User = new EducationSecurityPrincipal(new UserRepository(EducationContext).Items.Where(s => s.UserKey == "Bob").Include("UserRoles.Role").Single());
}
public void InitializeTest()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
ProviderManager manager = new ProviderManager(repositoryContainer, new DataTableBinder());
Target = new ProviderController(manager);
}
public void WhenCreate_ThenContextConnectionStringComesFromConfiguration()
{
string expected = ConfigurationManager.AppSettings["DatabaseConnectionString"];
using (EducationDataContext actual = EducationDataContextFactory.Create(MockKernel))
{
Assert.IsTrue(actual.Database.Connection.ConnectionString.Contains(expected)); // NOTE: Won't be equal because the connection is wrapped for caching/tracing
}
}
public void WhenConfigure_ThenDatabaseInitialized()
{
using (EducationDataContext actual = new EducationDataContext())
{
Target.Configure(MockKernel, actual);
Assert.IsTrue(actual.Database.Exists());
}
}
public static EducationDataContext Create(IKernel kernel)
{
lock (LockObject)
{
EducationDataContext instance = new EducationDataContext();
IDataContextConfigurator configurator = kernel.Resolve <IDataContextConfigurator>();
configurator.Configure(kernel, instance);
return(instance);
}
}
public void InitializeTest()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
ProviderManager providerManager = new ProviderManager(repositoryContainer, new DataTableBinder());
ProgramManager programManager = new ProgramManager(repositoryContainer, new DataTableBinder());
ServiceTypeManager serviceTypeManager = new ServiceTypeManager(repositoryContainer, new DataTableBinder());
Target = new PartnersController(providerManager, programManager, serviceTypeManager);
}
public static EducationDataContext Create(IKernel kernel)
{
lock (LockObject)
{
EducationDataContext instance = new EducationDataContext();
IDataContextConfigurator configurator = kernel.Resolve<IDataContextConfigurator>();
configurator.Configure(kernel, instance);
return instance;
}
}
public void GivenSingleSchoolId_WhenResetApprovals_ThenNewContextCanFindNoStudentsWithApprovedProviders()
{
Target.ResetApprovals(new[] { 1 });
Context.SaveChanges();
using (EducationDataContext assertContext = new EducationDataContext())
{
Assert.IsFalse(assertContext.Students.Where(s => s.SchoolId == 1 && s.ApprovedProviders.Count() > 0).Any());
}
}
public void GivenEnableTracingFalse_WhenConfigure_ThenContextTracingNotConfigured()
{
Target.EnableTracing = false;
using (EducationDataContext actual = new EducationDataContext())
{
Target.Configure(MockKernel, actual);
Assert.IsNull(actual.Log);
}
}
public void GivenAStudentQueryable_WhenIncludeClassesAndTeachers_ThenGetStudentsWithClassesWithATeacher()
{
List<Student> items = Target.Items.ToList();
Context = new EducationDataContext();
Target = new StudentRepository(Context);
List<Student> expanded = Target.Items.Include("Classes.Teacher").ToList();
Assert.IsTrue(items.Any(s => s.Classes.Count == 0));
Assert.IsTrue(expanded.Any(s => s.Classes.Count > 0));
Assert.IsTrue(expanded.Any(s => s.Classes.All(c => c.Teacher != null)));
}
public static void ForceDeleteEducationDatabase(string databaseName)
{
using (EducationDataContext context = new EducationDataContext())
{
if (context.Database.Exists())
{
string dropUsersCommand = string.Format("USE [master]; ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE", databaseName);
context.Database.ExecuteSqlCommand(dropUsersCommand);
context.Database.Delete();
}
}
}
public void WhenInitializeDatabase_ThenFulfillmentStatusesPopulated()
{
List <string> expected = new List <string> {
Statuses.Open, Statuses.Fulfilled, Statuses.Rejected
};
ResetDatabase();
Target.Dispose();
Target = new EducationDataContext();
var actual = Target.FulfillmentStatuses.Select(f => f.Name).ToList();
CollectionAssert.AreEquivalent(expected, actual);
}
public void GivenANewServiceType_WhenSaveChanges_ThenDatabaseContainsServiceType()
{
Target.ServiceTypes.Add(new ServiceType
{
Name = "Tester Service",
Description = "Tester Service Description"
});
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.ServiceTypes.SingleOrDefault(s => s.Name.Equals("Tester Service")));
}
}
public void GivenANewUserIsAdded_WhenSaveChanges_ThenDatabaseContainsUser()
{
string userKey = Guid.NewGuid().ToString();
Target.Users.Add(new User {
UserKey = userKey, FirstName = "Mr.", LastName = "Blah", DisplayName = "blah", EmailAddress = "*****@*****.**"
});
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.Users.SingleOrDefault(u => u.UserKey == userKey));
}
}
public void GivenEnableCachingFalse_WhenConfigure_ThenContextCachingNotConfigured()
{
ICache expected = MockRepository.GenerateMock <ICache>();
MockKernel.Expect(m => m.Resolve <ICache>()).Return(expected);
Target.EnableCaching = false;
using (EducationDataContext actual = new EducationDataContext())
{
Target.Configure(MockKernel, actual);
Assert.IsNull(actual.Cache);
Assert.AreEqual(CachingPolicy.NoCaching, actual.CachingPolicy);
}
}
public void GivenANewServiceType_WhenSaveChanges_ThenDatabaseContainsServiceType()
{
Target.ServiceTypes.Add(new ServiceType
{
Name = "Tester Service",
Description = "Tester Service Description"
});
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.ServiceTypes.SingleOrDefault(s => s.Name.Equals("Tester Service")));
}
}
public void GivenANewServiceType_WhenSaveChanges_ThenNewServiceTypeIsSaved()
{
ServiceType serviceType = new ServiceType
{
Name = "Bob",
Description = "Bob's Description",
};
Target.ServiceTypes.Add(serviceType);
Target.SaveChanges();
var secondaryClient = new EducationDataContext();
var actual = secondaryClient.ServiceTypes.Where(s => s.Name == "Bob").SingleOrDefault();
Assert.IsNotNull(actual);
}
public void GivenStudentAssignedOfferingIsActive_WhenGenerateEditViewModel_ThenAuditDataPopulated()
{
int entityId;
using (EducationDataContext setupContext = new EducationDataContext())
{
StudentAssignedOffering entity = setupContext.StudentAssignedOfferings.Single(a => a.LastModifyingUser != null);
entity.IsActive = true;
setupContext.SaveChanges();
entityId = entity.Id;
}
StudentServiceOfferingScheduleModel actual = Target.GenerateEditViewModel(User, entityId);
Assert.IsNotNull(actual.Audit.CreatedBy);
Assert.AreNotEqual(DateTime.MinValue, actual.Audit.CreateTime);
Assert.IsNotNull(actual.Audit.LastModifiedBy);
Assert.IsTrue(actual.Audit.LastModifyTime.HasValue);
}
public void GivenProviderProgramAssociationsWereMade_WhenEdit_ThenProviderHasSelectedPrograms()
{
try
{
EducationSecurityPrincipal user = new EducationSecurityPrincipal(new UserRepository(EducationContext).Items.Where(s => s.UserKey == "Bob").Include("UserRoles.Role").Single());
var expected = new int[] { 1, 2 };
var provider = EducationContext.Providers.First();
var viewModel = new ProviderModel { Id = provider.Id, Name = provider.Name, SelectedPrograms = expected, Address = provider.Address, Contact = provider.Contact, Website = provider.Website };
Target.Edit(user, viewModel);
using (EducationDataContext verificationContext = new EducationDataContext())
{
var actual = verificationContext.Providers.Include(p => p.ServiceOfferings).Single(p => p.Id == viewModel.Id).ServiceOfferings.Where(s => s.IsActive).Select(s => s.ProgramId).Distinct();
CollectionAssert.AreEquivalent(expected, actual.ToList());
}
}
finally
{
AssemblySetup.ForceDeleteEducationDatabase("SSD");
}
}
public void GivenProviderWithApprovingStudents_WhenDelete_ThenNoApprovedProviderMappingsToDeletedProvider()
{
int toDeleteId;
using (EducationDataContext setupContext = new EducationDataContext())
{
Provider temp = new Provider
{
Name = "blah blah blah",
IsActive = true,
ApprovingStudents = setupContext.Students.ToList()
};
foreach (Student student in temp.ApprovingStudents)
{
student.ApprovedProviders.Add(temp);
}
setupContext.Providers.Add(temp);
setupContext.SaveChanges();
toDeleteId = temp.Id;
}
Target.Delete(toDeleteId);
Assert.IsFalse(EducationContext.Students.Any(s => s.ApprovedProviders.Select(p => p.Id).Contains(toDeleteId)));
}
public void GivenANewServiceType_WhenSaveChanges_ThenNewServiceTypeIsSaved()
{
ServiceType serviceType = new ServiceType
{
Name = "Bob",
Description = "Bob's Description",
};
Target.ServiceTypes.Add(serviceType);
Target.SaveChanges();
var secondaryClient = new EducationDataContext();
var actual = secondaryClient.ServiceTypes.Where(s => s.Name == "Bob").SingleOrDefault();
Assert.IsNotNull(actual);
}
public void GivenValidViewModelHasSelectedProviders_WhenEdit_ThenProviderAssociationsChange()
{
try
{
EducationContext.Database.ExecuteSqlCommand("Update SSD.StudentAssignedOffering Set IsActive = 0");
var expected = new int[] { 1, 2 };
ProgramModel viewModel = new ProgramModel { Id = 2, Name = "something valid", SelectedProviders = expected, SelectedServiceTypes = new List<int> { 2 } };
Target.Edit(viewModel);
using (EducationDataContext assertContext = new EducationDataContext())
{
var actual = assertContext.Programs.Include("ServiceOfferings.Provider").Single(p => p.Id == viewModel.Id).ServiceOfferings.Where(s => s.IsActive).Select(s => s.Provider).Distinct();
CollectionAssert.AreEquivalent(expected, actual.Select(p => p.Id).ToList());
}
}
finally
{
AssemblySetup.ForceDeleteEducationDatabase("SSD");
}
}
public void TestInitialize()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
ScheduledServiceManager logicManager = new ScheduledServiceManager(repositoryContainer);
HttpContext context = new HttpContext(new HttpRequest("", "http://tempuri.org", ""), new HttpResponse(new StringWriter()));
User = new EducationSecurityPrincipal(new UserRepository(EducationContext).Items.Where(s => s.UserKey == "Bob").Single());
context.User = User;
Target = new ServiceController(logicManager);
ControllerContext controllerContext = new ControllerContext(new HttpContextWrapper(context), new RouteData(), Target);
Target.ControllerContext = controllerContext;
}
public void GivenProviderWithUserAssociations_WhenDelete_ThenNoUserAssociationsToDeletedProvider()
{
int toDeleteId;
using (EducationDataContext setupContext = new EducationDataContext())
{
Provider temp = new Provider
{
Name = "halb halb halb",
IsActive = true,
UserRoles = setupContext.UserRoles.Where(u => u.Role.Name == SecurityRoles.Provider).ToList()
};
foreach (UserRole userRole in temp.UserRoles)
{
userRole.Providers.Add(temp);
}
setupContext.Providers.Add(temp);
setupContext.SaveChanges();
toDeleteId = temp.Id;
}
Target.Delete(toDeleteId);
Assert.IsFalse(EducationContext.UserRoles.Any(u => u.Providers.Select(p => p.Id).Contains(toDeleteId)));
}
public void InitializeTest()
{
_TestTransaction = new TransactionScope();
Target = new EducationDataContext();
}
public void WhenDelete_ThenAssignedOfferingSetInactive()
{
Target.Delete(User, 3);
using (EducationDataContext verificationContext = new EducationDataContext())
{
StudentAssignedOffering actual = verificationContext.StudentAssignedOfferings.Find(3);
Assert.IsFalse(actual.IsActive);
}
}
public void GivenANewUserIsAdded_WhenSaveChanges_ThenDatabaseContainsUser()
{
string userKey = Guid.NewGuid().ToString();
Target.Users.Add(new User { UserKey = userKey, FirstName = "Mr.", LastName = "Blah", DisplayName = "blah", EmailAddress = "*****@*****.**" });
Target.SaveChanges();
using (EducationDataContext verifyContext = new EducationDataContext())
{
Assert.IsNotNull(verifyContext.Users.SingleOrDefault(u => u.UserKey == userKey));
}
}
public void InitializeTest()
{
Context = new EducationDataContext();
Target = new StudentRepository(Context);
}
public void InitializeTest()
{
EducationContext = new EducationDataContext();
Container = AssemblySetup.CreateWindsorContainer(EducationContext);
RepositoryContainer repositoryContainer = new RepositoryContainer(Container, EducationContext);
Target = new SchoolDistrictManager(repositoryContainer, new DataTableBinder(), new UserAuditor());
User = new EducationSecurityPrincipal(EducationContext.Users.Include("UserRoles.Role").Single(u => u.UserKey == "Bob"));
MockContext = MockHttpContextFactory.Create();
}
private static ServiceRequest CreateServiceRequestInDatabase(int creatingUserId, int priorityId)
{
using (EducationDataContext context = new EducationDataContext())
{
ServiceRequestFulfillment newServiceRequestFulfillment = new ServiceRequestFulfillment { FulfillmentStatusId = 1, Notes = "Test", CreatingUserId = 1 };
ServiceRequest newRequestToEdit = new ServiceRequest { CreatingUserId = creatingUserId, PriorityId = priorityId, ServiceTypeId = 1, StudentId = 6, SubjectId = 2, FulfillmentDetails = new List<ServiceRequestFulfillment> { newServiceRequestFulfillment } };
context.ServiceRequests.Add(newRequestToEdit);
context.SaveChanges();
return newRequestToEdit;
}
}
public void GivenViewModelHasStudentId_AndStudentAssignedOffering_WhenPopulateViewModel_ThenAssignedOfferingContainsFullName()
{
int studentId = EducationContext.Students.Where(s => s.StudentAssignedOfferings.Any()).Select(s => s.Id).First();
ServiceRequestModel viewModel = new ServiceRequestModel { StudentIds = new[] { studentId } };
Target.PopulateViewModel(viewModel);
using (EducationDataContext verificationContext = new EducationDataContext())
{
var expected = verificationContext.Students.Where(s => s.Id == studentId).Select(s => s.StudentAssignedOfferings.FirstOrDefault()).Select(a => new { Provider = a.ServiceOffering.Provider, Program = a.ServiceOffering.Program, ServiceType = a.ServiceOffering.ServiceType }).Single();
StringAssert.Contains(viewModel.AssignedOfferings.First().Text, expected.Program.Name);
StringAssert.Contains(viewModel.AssignedOfferings.First().Text, expected.Provider.Name);
StringAssert.Contains(viewModel.AssignedOfferings.First().Text, expected.ServiceType.Name);
}
}
public void InitializeTest()
{
_TestTransaction = new TransactionScope();
try
{
IRepositoryContainer educationContainer = MockRepository.GenerateMock<IRepositoryContainer>();
EducationDataContext = new EducationDataContext();
educationContainer.Expect(m => m.Obtain<IUserRepository>()).Return(new UserRepository(EducationDataContext));
educationContainer.Expect(m => m.Obtain<IEulaAgreementRepository>()).Return(new EulaAgreementRepository(EducationDataContext));
MockWindsorContainer = MockRepository.GenerateMock<IWindsorContainer>();
MockWindsorContainer.Expect(m => m.Resolve<IRepositoryContainer>()).Return(educationContainer);
AccountManager = new AccountManager(MockWindsorContainer, MockRepository.GenerateMock<IEmailConfirmationManager>(), new DataTableBinder(), new UserAuditor());
MockDependecyResolver = MockRepository.GenerateMock<IDependencyResolver>();
MockDependecyResolver.Expect(m => m.GetService(typeof(IAccountManager))).Return(AccountManager);
DependencyResolver.SetResolver(MockDependecyResolver);
}
catch (Exception)
{
_TestTransaction.Dispose();
_TestTransaction = null;
if (EducationDataContext != null)
{
EducationDataContext.Dispose();
EducationDataContext = null;
}
throw;
}
}
public void WhenInitializeDatabase_ThenFulfillmentStatusesPopulated()
{
List<string> expected = new List<string> { Statuses.Open, Statuses.Fulfilled, Statuses.Rejected };
ResetDatabase();
Target.Dispose();
Target = new EducationDataContext();
var actual = Target.FulfillmentStatuses.Select(f => f.Name).ToList();
CollectionAssert.AreEquivalent(expected, actual);
}
public void InitializeTest()
{
_TestTransaction = new TransactionScope();
Target = new EducationDataContext();
}
public void WhenInitialize_ThenExpectedPropertiesAreProtected()
{
var expected = new List<Property>
{
new Property { EntityName = "SSD.Domain.Student", Name = "StudentKey" },
new Property { EntityName = "SSD.Domain.Student", Name = "ServiceRequests" },
new Property { EntityName = "SSD.Domain.Student", Name = "StudentAssignedOfferings" },
new Property { EntityName = "SSD.Domain.ServiceOffering", Name = "StudentAssignedOfferings" }
};
ResetDatabase();
Target.Dispose();
Target = new EducationDataContext();
var actual = Target.Properties.Where(p => p.IsProtected).ToList();
Assert.IsTrue(expected.All(p => actual.Exists(a => a.Name == p.Name && a.EntityName == p.EntityName)));
Assert.IsFalse(actual.Any(a => !expected.Exists(p => p.Name == a.Name && p.EntityName == a.EntityName)));
}
