public async Task GetAsync_SelectingByPredicate_ReturnTheItemAsync()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityName = "Copenhagen";
var id = Guid.NewGuid();
using (var db = new DansBankDbContext(fackDatabaseBuilder))
{
db.Municipalities.Add(new Municipality {
Id = id, Name = municipalityName
});
db.SaveChanges();
}
var municipalityRepository = new MunicipalityRepository(new DansBankDbContext(fackDatabaseBuilder));
// Act
var municipality = await municipalityRepository.GetAsync(m => m.Name.ToLower() == municipalityName.ToLower());
// Assert
municipality.Should().NotBeNull();
municipality.Name.Should().Be(municipalityName);
}
public void GetRandom_Test()
{
var municipalities = new[]
{
new Municipality {
MunicipalityId = "1", Name = "Municipality name 1", DistrictName = "District name 1"
},
new Municipality {
MunicipalityId = "2", Name = "Municipality name 2", DistrictName = "District name 2"
},
new Municipality {
MunicipalityId = "3", Name = "Municipality name 3", DistrictName = "District name 3"
},
new Municipality {
MunicipalityId = "4", Name = "Municipality name 4", DistrictName = "District name 4"
},
new Municipality {
MunicipalityId = "5", Name = "Municipality name 5", DistrictName = "District name 5"
},
};
var storage = MemoryDataStorage.FromData(municipalities);
var repository = new MunicipalityRepository(storage);
var result = repository.GetRandom();
Assert.IsNotNull(result);
}
public async Task Exist_ByGivingAnExistingMunicipalityName_ReturnTrueAsync()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityName = "Copenhagen";
var id = Guid.NewGuid();
using (var db = new DansBankDbContext(fackDatabaseBuilder))
{
db.Municipalities.Add(new Municipality {
Id = id, Name = municipalityName
});
db.SaveChanges();
}
var municipalityRepository = new MunicipalityRepository(new DansBankDbContext(fackDatabaseBuilder));
// Act
var sameString = await municipalityRepository.Exist(municipalityName);
var caseSensivity = await municipalityRepository.Exist(municipalityName.ToUpper());
// Assert
sameString.Should().BeTrue();
caseSensivity.Should().BeTrue();
}
private IEnumerable <Municipality> FindMunicipalitiesByNameWithDiscrict(string municipalityName)
{
if (municipalityName == null)
{
return(new Municipality[0]);
}
IQuery <Municipality> query;
if (municipalityName.Contains(","))
{
var parts = municipalityName.Split(',');
query = new QueryMunicipalityByNameAndDistrict
{
Name = parts[0],
District = parts[1]
};
}
else
{
query = new QueryMunicipalityByName
{
Name = municipalityName
};
}
return(MunicipalityRepository.FindAll(query));
}
public void GetByCode_NoCodeTest()
{
var storage = MemoryDataStorage.FromData(new Municipality[0]);
var repository = new MunicipalityRepository(storage);
repository.GetByCode("XXX");
}
public UnitOfWork(CovidContext context)
{
_context = context;
Citizens = new CitizenRepository(_context);
Municipalities = new MunicipalityRepository(_context);
//Courses = new CourseRepository(_context);
//Authors = new AuthorRepository(_context);
}
public UnitOfWork(CovidContext context)
{
_context = context;
Citizens = new CitizenRepository(_context);
Municipalities = new MunicipalityRepository(_context);
TestCenters = new TestCenterRepository(_context);
TestCenterManagements = new TestCenterManagementRepository(_context);
TestDates = new TestDateRepository(_context);
Locations = new LocationRepository(_context);
//Courses = new CourseRepository(_context);
//Authors = new AuthorRepository(_context);
}
public async Task GetWithDetails_IncludeDetails()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityName = "Copenhagen";
using (var db = new DansBankDbContext(fackDatabaseBuilder))
{
var id = Guid.NewGuid();
var m = new Municipality {
Id = id, Name = municipalityName, TaxRules = new List <TaxRule>()
};
var tr = new TaxRule {
Name = "Yearly", Percentage = 0.2F, Priority = 1
};
var periods = new List <Period>
{
new Period {
From = DateTime.Today, To = DateTime.Today.AddDays(1)
},
new Period {
From = DateTime.Today.AddDays(2), To = DateTime.Today.AddDays(5)
}
};
tr.Periods = periods;
m.TaxRules.Add(tr);
db.Municipalities.Add(m);
db.SaveChanges();
}
var municipalityRepository = new MunicipalityRepository(new DansBankDbContext(fackDatabaseBuilder));
// Act
var municipality = await municipalityRepository.GetWithDetails("Copenhagen");
// Assert
municipality.Should().NotBeNull();
municipality.TaxRules.Should().NotBeNullOrEmpty();
municipality.TaxRules.Should().HaveCount(1);
var taxRule = municipality.TaxRules.First();
taxRule.Periods.Should().NotBeNullOrEmpty();
taxRule.Periods.Should().HaveCount(2);
}
public static IServiceCollection UseFileRepositories(this IServiceCollection services, string path)
{
var municipalityDataStorage = new FileDataStorage <Municipality>(path);
var municipalityRepository = new MunicipalityRepository(municipalityDataStorage);
var populationFrameDataStorage = new FileDataStorage <PopulationFrame>(path);
var populationFrameRepository = new PopulationFrameRepository(populationFrameDataStorage);
services.AddSingleton(typeof(IMunicipalityRepository), municipalityRepository);
services.AddSingleton(typeof(IPopulationFrameRepository), populationFrameRepository);
return(services);
}
private MunicipalityPopulationProgressModel CreateModelByMunicipality(Municipality municipality)
{
var populationProgress = PopulationFrameRepository.FindAll(new QueryPopulationFrameByMunicipalityCode {
Code = municipality.MunicipalityId
});
var closest = MunicipalityRepository.GetClosests(municipality.Longitude, municipality.Latitude);
return(new MunicipalityPopulationProgressModel
{
Municipality = municipality,
PopulationProgress = populationProgress.OrderByDescending(d => d.Year).ToArray(),
ClosestMunicipalities = closest.Skip(1).ToArray()
});
}
public UnitOfWork(DataContext dataContext)
{
_dataContext = dataContext;
BranchRepository = new BranchRepository(dataContext);
AddressRepository = new AddressRepository(dataContext);
BankAccountRepository = new BankAccountRepository(dataContext);
DepartmentRepository = new DepartmentRepository(dataContext);
MunicipalityRepository = new MunicipalityRepository(dataContext);
PositionRepository = new PositionRepository(dataContext);
RegionRepository = new RegionRepository(dataContext);
SettlementRepository = new SettlementRepository(dataContext);
BasePositionStaffEntityRepositorty = new BasePositionStaffEntityRepository(dataContext);
PositionsAndDepartmentRepository = new PositionsAndDepartmentRepository(dataContext);
}
public void GetByCode_Test()
{
var municipality = new Municipality
{
MunicipalityId = "TEST",
Name = "Municipality name",
DistrictName = "District name"
};
var storage = MemoryDataStorage.FromData(municipality);
var repository = new MunicipalityRepository(storage);
var result = repository.GetByCode("TEST");
Assert.AreEqual(municipality, result);
}
public void FindAll_Test()
{
var municipality = new Municipality
{
MunicipalityId = "TEST",
Name = "Municipality name",
DistrictName = "District name"
};
var storage = MemoryDataStorage.FromData(municipality);
var repository = new MunicipalityRepository(storage);
var returned = repository.FindAll().Single();
Assert.AreEqual(municipality, returned);
}
public async Task ReplaceAll_Test()
{
var municipality = new Municipality
{
MunicipalityId = "TEST",
Name = "Municipality name",
DistrictName = "District name"
};
var storage = MemoryDataStorage.FromData(municipality);
var repository = new MunicipalityRepository(storage);
await repository.ReplaceAllAsync(new[] { municipality });
Assert.IsNotNull(repository.GetByCode(municipality.MunicipalityId));
}
public void Exists_QueryTest()
{
var municipality = new Municipality
{
MunicipalityId = "TEST",
Name = "Municipality name",
DistrictName = "District name"
};
var storage = MemoryDataStorage.FromData(municipality);
var repository = new MunicipalityRepository(storage);
var result = repository.FindAll(new QueryMunicipalityByCode {
Code = "TEST"
}).Single();
Assert.AreEqual(municipality, result);
}
public void Exists_Test()
{
var municipalities = new Municipality[]
{
new Municipality {
MunicipalityId = "TEST", Name = "Municipality name", DistrictName = "District name"
},
};
var storage = MemoryDataStorage.FromData(municipalities);
var repository = new MunicipalityRepository(storage);
var result = repository.Exists(new QueryMunicipalityByCode {
Code = "TEST"
});
Assert.IsTrue(result);
}
public void Add_Manucipality()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityName = "Copenhagen";
var municipalityName2 = "Copenhagen2";
var db = new DansBankDbContext(fackDatabaseBuilder);
var municipalityRepository = new MunicipalityRepository(db);
var mId = Guid.NewGuid();
var municipality = new Municipality {
Name = municipalityName
};
var municipality2 = new Municipality {
Id = mId, Name = municipalityName2
};
// Act
var id = municipalityRepository.Add(municipality);
var id2 = municipalityRepository.Add(municipality2);
Municipality m = null;
Municipality m2 = null;
using (var db2 = new DansBankDbContext(fackDatabaseBuilder))
{
m = db2.Municipalities.Find(id);
m2 = db2.Municipalities.Find(id2);
}
// Assert
id.Should().NotBe(mId);
id2.Should().Be(mId);
db.Entry(municipality).State.Should().Be(EntityState.Added);
db.Entry(municipality2).State.Should().Be(EntityState.Added);
db.Municipalities.Local.Should().HaveCount(2);
m.Should().Be(null);
m2.Should().Be(null);
}
public async Task GetList_ByProvideingPagination_FilterMunicipalitis()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityNames = new List <string>()
{
"Copenhagen", "Aarhus", "Aalborg", "Odense", "Esbjerg"
};
using (var db = new DansBankDbContext(fackDatabaseBuilder))
{
foreach (var municipalityName in municipalityNames)
{
var id = Guid.NewGuid();
db.Municipalities.Add(new Municipality {
Id = id, Name = municipalityName
});
db.SaveChanges();
}
}
var municipalityRepository = new MunicipalityRepository(new DansBankDbContext(fackDatabaseBuilder));
// Act
var municipalities = await municipalityRepository
.GetListAsync(new Pagination { PageNumber = 1, PageSize = 2 });
// Assert
municipalities.Should().NotBeNull();
municipalities.Should().NotBeEmpty();
municipalities.Should().HaveCount(2);
municipalities.Select(m => m.Name).SequenceEqual(new List <string> {
"Aalborg", "Aarhus"
}).Should().BeTrue();
}
public async Task GetList_NotProvideingPaginationAndCondition_WouldReturnAllMunicipalitis()
{
// Arrange
var fackDatabaseBuilder = new FackDataBaseBuildHelper();
var context = new DansBankDbContext(fackDatabaseBuilder);
context.Database.EnsureCreated();
var municipalityNames = new List <string>()
{
"Copenhagen", "Aarhus", "Aalborg", "Odense", "Esbjerg"
};
using (var db = new DansBankDbContext(fackDatabaseBuilder))
{
foreach (var municipalityName in municipalityNames)
{
var id = Guid.NewGuid();
db.Municipalities.Add(new Municipality {
Id = id, Name = municipalityName
});
db.SaveChanges();
}
}
var municipalityRepository = new MunicipalityRepository(new DansBankDbContext(fackDatabaseBuilder));
// Act
var municipalities = await municipalityRepository.GetListAsync();
// Assert
municipalities.Should().NotBeNull();
municipalities.Should().NotBeEmpty();
municipalities.Should().HaveCount(5);
}
private MunicipalityPopulationProgressModel CreateModelByCode(string code)
{
var municipality = MunicipalityRepository.GetByCode(code);
return(CreateModelByMunicipality(municipality));
}
private MunicipalityPopulationProgressModel CreateRandomModel()
{
var municipality = MunicipalityRepository.GetRandom();
return(CreateModelByMunicipality(municipality));
}
public async Task <Guid> Add(Municipality municipality)
{
var dto = Mapper.Map <Repositories.Entities.Municipality>(municipality);
return(await MunicipalityRepository.Add(dto));
}
public async Task AddBulk(IEnumerable <Municipality> municipalities)
{
var dto = municipalities.Select(Mapper.Map <Repositories.Entities.Municipality>);
await MunicipalityRepository.AddBulk(dto);
}
public async Task Update(Municipality municipality)
{
var dto = Mapper.Map <Repositories.Entities.Municipality>(municipality);
await MunicipalityRepository.Update(dto);
}
public async Task <Municipality> Get(Guid uuid)
{
return(Mapper.Map <Municipality>(await MunicipalityRepository.Get(uuid)));
}
public async Task <Municipality> Get(string name)
{
return(Mapper.Map <Municipality>(await MunicipalityRepository.Get(name)));
}
public async Task <List <Municipality> > List()
{
return((await MunicipalityRepository.List()).Select(Mapper.Map <Municipality>).ToList());
}
