public void Can_Save_LandRegistry()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var person = new PhysicalPerson("12345678901", "Ime", "Prezime");
landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LandRegistriesNHRepository landRegistriesNhRepository = new LandRegistriesNHRepository(SessionFactory);
// Act
LandRegistry fetchedLandRegistry;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(city);
session.Save(person);
session.Save(cadastre);
landRegistriesNhRepository.SaveOrUpdate(landRegistry);
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
fetchedLandRegistry =
landRegistriesNhRepository.GetByNumberOfCadastralParticle(cadastralParticle.NumberOfCadastralParticle);
tx.Commit();
}
}
// Assert
Assert.AreEqual(landRegistry, fetchedLandRegistry, "LandRegistries aren't equal");
Assert.IsTrue(fetchedLandRegistry.PartitionSpaces.Count == 1, "LandRegistry haven't exactly one partition space.");
}
public void Can_Read_Cadastre_From_DB()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Črnomerec", "335266", city);
CadastresNHRepository cadastresNhRepository = new CadastresNHRepository(SessionFactory);
// Act
Cadastre cadastreFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(city);
session.Save(cadastre);
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
cadastreFromDb = cadastresNhRepository.GetById(1);
tx.Commit();
}
}
// Assert
Assert.AreEqual(cadastreFromDb, cadastre, "Two Cadastre entities aren't equal.");
}
public void Can_Save_Person_With_Address_To_DB()
{
// Arrange
City zagreb = new City(10000, "Zagreb");
Person person = new PhysicalPerson("12345678901", "Ivo", "Ivic") {
Address = new Address("Ulica", "1A", zagreb)
};
PersonsNHRepository personsNhRepository = new PersonsNHRepository(SessionFactory);
// Act
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(zagreb);
personsNhRepository.SaveOrUpdate(person);
tx.Commit();
}
}
IList<Person> persons = null;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
persons = personsNhRepository.GetAll().ToList();
tx.Commit();
}
}
// Assert
Assert.IsTrue(persons.Contains(person), "PhysicalPerson doesn't exists in database.");
Assert.AreEqual(person.Address, persons[0].Address, "Two persons haven't the sam addresses.");
Assert.AreEqual(zagreb.Id, 1, "City isn't persisted to database.");
}
public void Can_Save_City_To_DB()
{
// Arrange
CitiesNHRepository cityNhRepository = null;
City city = new City(10000, "Zagreb");
// Act
City cityFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using(var tx = session.BeginTransaction()) {
session.Save(city);
//var res = session.CreateSQLQuery("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;")
// .AddScalar("name", NHibernateUtil.String)
// .List();
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
cityNhRepository = new CitiesNHRepository(SessionFactory);
cityFromDb = cityNhRepository.GetCityByPostalCode(10000);
tx.Commit();
}
}
// Assert
Assert.AreEqual(city, cityFromDb, "Two City entities aren't equal.");
}
public void Can_Save_Bill_To_Db()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var person = new PhysicalPerson("12345678901", "Ime", "Prezime") {
Address = new Address("Ulica", "1", city)
};
var partitionSpace = landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LegalPerson legalPerson = new LegalPerson("12345678902", "Ime") {
NumberOfBankAccount = "123456",
Address = new Address("Ulica", "2", city)
};
BuildingManager buildingManager = new BuildingManager(legalPerson);
Building building = new Building(buildingManager) {
LandRegistry = landRegistry
};
Bill bill = new Bill(legalPerson, building.Reserve, "opis plaćanja", 23) {
ReferenceNumber = "123"
};
bill.AddBillItem(new BillItem(1, 12.3m, "Opis"));
IBillsRepository billsRepository = new BillsNHRepository(SessionFactory);
// Act
using (var session = SessionFactory.OpenSession()) {
using (var transaction = session.BeginTransaction()) {
session.Save(city);
session.Save(person);
session.Save(legalPerson);
session.Save(cadastre);
session.Save(landRegistry);
session.Save(buildingManager);
session.Save(building);
billsRepository.SaveOrUpdate(bill);
transaction.Commit();
}
}
IList<Bill> billsFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var transaction = session.BeginTransaction()) {
billsFromDb = billsRepository.GetAll().ToList();
transaction.Commit();
}
}
// Assert
Assert.IsTrue(billsFromDb.Count == 1, "No Bill from database.");
}
public void Can_Save_Maintenance_To_DB()
{
// Arrange
var person = new PhysicalPerson("12345678901", "Ime", "Prezime");
MaintenanceRequest maintenanceRequest = new MaintenanceRequest(
person
, "Kvar na grijanju"
, "Grijanje ne radi"
, "Prvi kat, stan 2");
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var partitionSpace = landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LegalPerson legalPerson = new LegalPerson("12345678902", "Ime");
BuildingManager buildingManager = new BuildingManager(legalPerson);
Building building = new Building(buildingManager) {
LandRegistry = landRegistry
};
RepairService repairService = new RepairService("Popravak grijanja");
Maintenance maintenance = new Maintenance(maintenanceRequest, Urgency.Normal, repairService, building);
IMaintenancesRepository maintenancesRepository = new MaintenancesNHRepository(SessionFactory);
// Act
IList<Maintenance> maintenancesFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(person);
session.Save(city);
session.Save(legalPerson);
session.Save(cadastre);
session.Save(landRegistry);
session.Save(buildingManager);
session.Save(building);
session.Save(repairService);
maintenancesRepository.SaveOrUpdate(maintenance);
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
maintenancesFromDb = maintenancesRepository.GetAll().ToList();
tx.Commit();
}
}
// Assert
Assert.IsTrue(maintenancesFromDb.Count == 1, "No Maintenance from database.");
}
public void Can_Read_Reserve_From_Db()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var person = new PhysicalPerson("12345678901", "Ime", "Prezime");
var partitionSpace = landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LegalPerson legalPerson = new LegalPerson("12345678902", "Ime") {
NumberOfBankAccount = "12332213",
Address = new Address("dsa", "2", city)
};
BuildingManager buildingManager = new BuildingManager(legalPerson);
Building building = new Building(buildingManager) {
LandRegistry = landRegistry
};
Bill bill = new Bill(legalPerson, building.Reserve, "račun", 23) {
ReferenceNumber = "123"
};
building.Reserve.AddBillForPayment(bill);
// Act
using (var session = SessionFactory.OpenSession()) {
using (var transaction = session.BeginTransaction()) {
session.Save(city);
session.Save(cadastre);
session.Save(person);
session.Save(landRegistry);
session.Save(legalPerson);
session.Save(buildingManager);
session.Save(building);
transaction.Commit();
}
}
IReservesRepository reservesRepository = new ReservesNHRepository(SessionFactory);
IList<Reserve> reservesFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var transaction = session.BeginTransaction()) {
reservesFromDb = reservesRepository.GetAll().ToList();
transaction.Commit();
}
}
// Assert
Assert.IsTrue(reservesFromDb.Count == 1, "No Reserves from database.");
//Assert.IsTrue(reservesFromDb[0].ReserveBills.Count == 1);
}
/// <summary>
/// Konstruktor
/// </summary>
/// <param name="streetAddress">ulica</param>
/// <param name="streetAddressNumber">broj ulice</param>
/// <param name="city">grad</param>
public Address(string streetAddress, string streetAddressNumber, City city)
{
this.streetAddress = streetAddress;
this.streetAddressNumber = streetAddressNumber;
if(city == null) {
throw new BusinessRulesException("City can't be null.");
}
this.city = city;
}
public void Can_Save_AdminJobsVoting_To_DB()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var person = new PhysicalPerson("12345678901", "Ime", "Prezime");
var partitionSpace = landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LegalPerson legalPerson = new LegalPerson("12345678902", "Ime");
BuildingManager buildingManager = new BuildingManager(legalPerson);
Building building = new Building(buildingManager) {
LandRegistry = landRegistry
};
AdministrationJobsVoting administrationJobsVoting = new AdministrationJobsVoting(
AdministrationJobsType.Regular,
building,
"Subject",
"Description",
new DateTime(2011, 11, 11));
AdminJobsVotingsNHRepository adminJobsVotingsNhRepository = new AdminJobsVotingsNHRepository(SessionFactory);
// Act
AdministrationJobsVoting adminJobsVotingFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(city);
session.Save(person);
session.Save(legalPerson);
session.Save(cadastre);
session.Save(landRegistry);
session.Save(buildingManager);
session.Save(building);
adminJobsVotingsNhRepository.SaveOrUpdate(administrationJobsVoting);
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
adminJobsVotingFromDb = adminJobsVotingsNhRepository.GetById(administrationJobsVoting.Id);
tx.Commit();
}
}
// Assert
Assert.AreEqual(administrationJobsVoting, adminJobsVotingFromDb, "Two administration jobs voting entities aren't equal.");
}
public void Can_Save_Building_To_DB()
{
// Arrange
City city = new City(10000, "Zagreb");
Cadastre cadastre = new Cadastre("Trnje", "12345", city);
CadastralParticle cadastralParticle = new CadastralParticle(cadastre, "123", 23, "Opis");
LandRegistry landRegistry = new LandRegistry(cadastralParticle);
var person = new PhysicalPerson("12345678901", "Ime", "Prezime");
var partitionSpace = landRegistry.CreatePartitionSpace("123", 12, "Opis etaže", person);
LegalPerson legalPerson = new LegalPerson("12345678902", "Ime");
BuildingManager buildingManager = new BuildingManager(legalPerson);
Building building = new Building(buildingManager) {
LandRegistry = landRegistry
};
BuildingsNHRepository buildingsNhRepository = new BuildingsNHRepository(SessionFactory);
// Act
Building buildingFromDb = null;
using (var session = SessionFactory.OpenSession()) {
using (var tx = session.BeginTransaction()) {
session.Save(city);
session.Save(person);
session.Save(legalPerson);
session.Save(cadastre);
session.Save(landRegistry);
session.Save(buildingManager);
buildingsNhRepository.SaveOrUpdate(building);
tx.Commit();
}
using (var tx = session.BeginTransaction()) {
buildingFromDb = buildingsNhRepository.GetById(building.Id);
tx.Commit();
}
}
// Assert
Assert.AreEqual(building, buildingFromDb, "Two building entities aren't equal.");
}
