public void CanSave() { int itemID = SaveAnItem("savedItem", null); Assert.AreNotEqual(0, itemID); using (repository) { ContentItem item = repository.Get(itemID); Assert.AreEqual(item.ID, itemID); repository.Delete(item); repository.Flush(); } }
public object Delete(int id) { var repo = new NHRepository <AcademicProgram>(); repo.Delete(id); return(0); }
public object Delete(int id) { var repo = new NHRepository <SchoolType>(); repo.Delete(id); return(0); }
public object Delete(int id) { var repo = new NHRepository <Address>(); repo.Delete(id); return(0); }
public object Delete(int id) { var repo = new NHRepository <Volunteer>(); repo.Delete(id); return(0); }
public object Delete(int id) { var repo = new NHRepository <Department>(); repo.Delete(id); return(0); }
public void Delete_Deletes_Record() { //Adding a dummy record. var newAddress = new Address { StreetAddress1 = "This record was inserted for deletion", City = "Fictional city", State = "LA", ZipCode = "12345" }; var newCustomer = new Customer { FirstName = ("John_DELETE_ME_" + DateTime.Now), LastName = ("Doe_DELETE_ME_" + DateTime.Now), Address = newAddress }; //Re-usable query to query for the matching record. var queryForCustomer = new Func <NHRepository <Customer>, Customer> (x => (from cust in x where cust.FirstName == newCustomer.FirstName && cust.LastName == newCustomer.LastName select cust).FirstOrDefault() ); using (var scope = new UnitOfWorkScope()) { var customerRepository = new NHRepository <Customer>(); var recordCheckResult = queryForCustomer(customerRepository); Assert.That(recordCheckResult, Is.Null); customerRepository.Add(newCustomer); scope.Commit(); } //Retrieve the record for deletion. using (var scope = new UnitOfWorkScope()) { var customerRepository = new NHRepository <Customer>(); var customerToDelete = queryForCustomer(customerRepository); Assert.That(customerToDelete, Is.Not.Null); customerRepository.Delete(customerToDelete); scope.Commit(); } //Ensure customer record is deleted. using (new UnitOfWorkScope()) { var customerRepository = new NHRepository <Customer>(); var recordCheckResult = queryForCustomer(customerRepository); Assert.That(recordCheckResult, Is.Null); } }
public void when_ambient_transaction_is_running_and_a_previous_scope_rollsback_new_scope_still_works() { using (var testData = new NHTestDataGenerator(Factory.OpenSession())) { testData.Batch(actions => actions.CreateCustomer()); string oldCustomerName; var newCustomerName = "NewCustomer" + new Random().Next(0, int.MaxValue); var newCustomer = new Customer { FirstName = newCustomerName, LastName = "Save", Address = new Address { StreetAddress1 = "This record was inserted via a test", City = "Fictional City", State = "LA", ZipCode = "00000" } }; using (var ambientScope = new TransactionScope()) { using (var firstUOW = new UnitOfWorkScope()) { var customer = new NHRepository <Customer>().First(); oldCustomerName = customer.FirstName; customer.FirstName = "Changed"; } //Rollback using (var secondUOW = new UnitOfWorkScope()) { new NHRepository <Customer>().Add(newCustomer); secondUOW.Commit(); } } using (var scope = new UnitOfWorkScope()) { var repository = new NHRepository <Customer>(); Assert.That(repository.First().FirstName, Is.EqualTo(oldCustomerName)); Assert.That(repository.Where(x => x.FirstName == newCustomerName).Count(), Is.GreaterThan(0)); repository.Attach(newCustomer); repository.Delete(newCustomer); scope.Commit(); } } }
public void Delete(Calculation calculation) { session.CreateQuery("DELETE FROM JobIndexPoint o WHERE o.CalculationId = :id") .SetParameter("id", calculation.Id) .ExecuteUpdate(); session.CreateQuery("DELETE FROM SummaryJobPositionPoint o WHERE o.CalculationId = :id") .SetParameter("id", calculation.Id) .ExecuteUpdate(); session.CreateQuery("DELETE FROM SummaryEmployeePoint o WHERE o.CalculationId = :id") .SetParameter("id", calculation.Id) .ExecuteUpdate(); session.CreateQuery("DELETE FROM SummaryCalculationPoint o WHERE o.CalculationId = :id") .SetParameter("id", calculation.Id) .ExecuteUpdate(); session.CreateQuery("DELETE FROM EmployeeCalculationException o WHERE o.CalculationId = :id") .SetParameter("id", calculation.Id) .ExecuteUpdate(); rep.Delete(calculation); }
public void Delete(JobPosition jobPostion) { rep.Delete(jobPostion); }
public void DeleteJob(Job job) { rep.Delete(job); }
public void Delete(Period period) { rep.Delete(period); }
public void Delete(Log log) { rep.Delete(log); }
public void Delete(Claim claim) { rep.Delete(claim); }
public void Delete(AbstractJobIndexId jobIndexId) { var abstractJobIndex = GetById(jobIndexId); rep.Delete(abstractJobIndex); }
public void Delete(Employee employee) { rep.Delete(employee); }
public void DeletePolicy(Policy policy) { rep.Delete(policy); }
public void Delete(AbstractUnitIndexId unitIndexId) { var abstractIndex = GetById(unitIndexId); rep.Delete(abstractIndex); }
public void Can_delete() { var customer = new Customer { FirstName = "John", LastName = "Doe", }; using (var scope = new UnitOfWorkScope()) { new NHRepository<Customer, int>().Add(customer); scope.Commit(); } Assert.IsTrue(customer.CustomerID > 0); using (var scope = new UnitOfWorkScope()) { var repository = new NHRepository<Customer, int>(); var savedCustomer = repository.Query.Where(x => x.CustomerID == customer.CustomerID).First(); repository.Delete(savedCustomer); scope.Commit(); } //Making sure customer is deleted using (var testData = new NHTestData(NHTestUtil.OrdersDomainFactory.OpenSession())) { Customer savedCustomer = null; testData.Batch(x => savedCustomer = x.GetCustomerById(customer.CustomerID)); Assert.IsNull(savedCustomer); } }
public void DeleteUnit(Unit unit) { rep.Delete(unit); }
public void when_ambient_transaction_is_running_and_a_previous_scope_rollsback_new_scope_still_works() { using (var testData = new NHTestDataGenerator(Factory.OpenSession())) { testData.Batch(actions => actions.CreateCustomer()); string oldCustomerName; var newCustomerName = "NewCustomer" + new Random().Next(0, int.MaxValue); var newCustomer = new Customer { FirstName = newCustomerName, LastName = "Save", Address = new Address { StreetAddress1 = "This record was inserted via a test", City = "Fictional City", State = "LA", ZipCode = "00000" } }; using (var ambientScope = new TransactionScope()) { using (var firstUOW = new UnitOfWorkScope()) { var customer = new NHRepository<Customer>().First(); oldCustomerName = customer.FirstName; customer.FirstName = "Changed"; } //Rollback using (var secondUOW = new UnitOfWorkScope()) { new NHRepository<Customer>().Add(newCustomer); secondUOW.Commit(); } } using (var scope = new UnitOfWorkScope()) { var repository = new NHRepository<Customer>(); Assert.That(repository.First().FirstName, Is.EqualTo(oldCustomerName)); Assert.That(repository.Where(x => x.FirstName == newCustomerName).Count(), Is.GreaterThan(0)); repository.Attach(newCustomer); repository.Delete(newCustomer); scope.Commit(); } } }
public void Delete_Deletes_Record() { //Adding a dummy record. var newAddress = new Address { StreetAddress1 = "This record was inserted for deletion", City = "Fictional city", State = "LA", ZipCode = "12345" }; var newCustomer = new Customer { FirstName = ("John_DELETE_ME_" + DateTime.Now), LastName = ("Doe_DELETE_ME_" + DateTime.Now), Address = newAddress }; //Re-usable query to query for the matching record. var queryForCustomer = new Func<NHRepository<Customer>, Customer> (x => (from cust in x where cust.FirstName == newCustomer.FirstName && cust.LastName == newCustomer.LastName select cust).FirstOrDefault() ); using (var scope = new UnitOfWorkScope()) { var customerRepository = new NHRepository<Customer>(); var recordCheckResult = queryForCustomer(customerRepository); Assert.That(recordCheckResult, Is.Null); customerRepository.Add(newCustomer); scope.Commit(); } //Retrieve the record for deletion. using (var scope = new UnitOfWorkScope()) { var customerRepository = new NHRepository<Customer>(); var customerToDelete = queryForCustomer(customerRepository); Assert.That(customerToDelete, Is.Not.Null); customerRepository.Delete(customerToDelete); scope.Commit(); } //Ensure customer record is deleted. using (new UnitOfWorkScope()) { var customerRepository = new NHRepository<Customer>(); var recordCheckResult = queryForCustomer(customerRepository); Assert.That(recordCheckResult, Is.Null); } }
public void NHRepositoryOperationsTest() { // IMPORTANT NOTE Never use Repository inside a UnitOfWork!!! // Never! The Curse of Deadlock will be upon you!!! //Instantiate var repLoc = new NHRepository<Location>(_sessionFactory); // CREATE = Save // populate the database var input = new List<IMeasure> { new SimpleMeasure("ReteA", 10U) }; var loc = _entitiesFactory.CreateLocation("Location1", input); loc.TotalTime = TimeVal; var input2 = new List<IMeasure> { new SimpleMeasure("ReteB", 50U), new SimpleMeasure("ReteC", 100U) }; var loc2 = _entitiesFactory.CreateLocation("Location2", input2); loc2.TotalTime = TimeVal1; //this saves everything else via cascading repLoc.Save(loc); repLoc.Save(loc2); // READ = Get and GetAll Location locA = null; IList<Location> locations = repLoc.GetAll(); Assert.AreEqual(locations.Count, 2); foreach (var location in locations) { //For a visual feedback Console.WriteLine(location.ToString()); if (location.Name == "Location1") { Assert.AreEqual(location.TotalTime, TimeVal); locA = location; } else if (location.Name == "Location2") { Assert.AreEqual(location.TotalTime, TimeVal1); } else { Log.Debug(location.Name); Assert.Fail("Location name not matching"); } } Assert.IsNotNull(locA); var locB = repLoc.Get(locA.Id); Assert.AreEqual(locB.Name, "Location1"); Assert.AreEqual(locB.TotalTime, TimeVal); var repNet = new NHRepository<Network>(_sessionFactory); var networks = repNet.GetAll(); Assert.AreEqual(networks.Count, 3); //Dirty Get (without waiting for transactions) var locDirty = repLoc.Get(locA.Id, dirty: true); Assert.AreEqual(locDirty.Name, "Location1"); Assert.AreEqual(locDirty.TotalTime, TimeVal); var locDirties = repLoc.GetAll(dirty: true); Assert.AreEqual(locDirties.Count, 2); foreach (var location in locDirties) { if (location.Name == "Location1") { Assert.AreEqual(location.TotalTime, TimeVal); } else if (location.Name == "Location2") { Assert.AreEqual(location.TotalTime, TimeVal1); } else { Log.Debug(location.Name); Assert.Fail("Location name not matching"); } } // UPDATE = Update // BEWARE OF DIRTY WRITES!!! THEY ARE STILL DIFFERENT TRANSACTIONS!!! Location locUpdated = locA; locUpdated.TotalTime = TimeVal2; repLoc.Update(locUpdated); Location tmp = repLoc.Get(locUpdated.Id); Assert.AreEqual(tmp.TotalTime, TimeVal2); // DELETE = Delete locations = repLoc.GetAll(); foreach (var location in locations) { repLoc.Delete(location); } //check cascading deletion locations = repLoc.GetAll(); Assert.AreEqual(locations.Count, 0); networks = repNet.GetAll(); Assert.AreEqual(networks.Count, 0); }
public void Delete(Party party) { rep.Delete(party); }
public void Delete(InquiryJobIndexPoint inquiryJobIndexPoint) { rep.Delete(inquiryJobIndexPoint); }
public void DeleteCustomField(CustomFieldType customField) { rep.Delete(customField); }