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."); }