public void Test_Country_Delete()
{
var country = new Country()
{
DetachedState = DetachedState.Added,
Capital = countryCapitalDelete,
ISO2 = countryISO2Delete,
ISO3 = countryISO3Delete,
ISOName = countryISONameDelete,
ISONumeric = countryISONumericDelete,
Name = countryNameDelete,
OfficialName = countryOfficialNameDelete,
OfficialNameLocal = countryOfficialNameLocalDelete
};
using (var entityManager = new CountriesEntityManager()) {
var continent = entityManager.Set <Continent>()
.Where(x => x.Name == continentName)
.Single();
country.Continent = continent;
var currency = entityManager.Set <Currency>()
.Where(x => x.Code == currencyCode)
.Single();
country.Currencies.Add(currency);
var validationResults = Get_Validation_Results(country);
Assert.AreEqual(expected: 0, actual: validationResults.Count);
entityManager.AddEntity <Country>(country);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var countryFromDb = entityManager.Set <Country>()
.Where(x => (x.Id == country.Id))
// need to include related entities
.Include(x => x.Currencies)
.Include(x => x.Continent)
.SingleOrDefault();
Assert.IsNotNull(countryFromDb);
entityManager.RemoveEntity <Country>(countryFromDb);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
countryFromDb = entityManager.Set <Country>()
.Where(x => (x.Id == country.Id))
.SingleOrDefault();
Assert.IsNull(countryFromDb);
}
}
public void Test_TimeZone_Delete()
{
var timeZone = new Countries.DomainModel.TimeZone()
{
DetachedState = DetachedState.Added,
TimeZoneAcronym = timeZoneAbbreviationDelete,
TimeZoneName = timeZoneNameDelete,
UTCOffset = timeZoneUTCOffsetDelete
};
var validationResults = Get_Validation_Results(timeZone);
Assert.AreEqual(expected: 0, actual: validationResults.Count);
using (var entityManager = new CountriesEntityManager()) {
entityManager.AddEntity <Countries.DomainModel.TimeZone>(timeZone);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var timeZoneFromDb = entityManager.Set <Countries.DomainModel.TimeZone>()
.Where(x => (x.Id == timeZone.Id))
.SingleOrDefault();
Assert.IsNotNull(timeZoneFromDb);
}
var timeZoneToDelete = new Countries.DomainModel.TimeZone()
{
DetachedState = DetachedState.Deleted,
Id = timeZone.Id,
RowVersion = timeZone.RowVersion
};
using (var entityManager = new CountriesEntityManager()) {
entityManager.RemoveEntity <Countries.DomainModel.TimeZone>(timeZoneToDelete);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var timeZoneFromDb = entityManager.Set <Countries.DomainModel.TimeZone>()
.Where(x => (x.Id == timeZone.Id))
.SingleOrDefault();
Assert.IsNull(timeZoneFromDb);
}
}
public void Test_Currency_Delete()
{
var currency = new Currency()
{
DetachedState = DetachedState.Added,
Code = currencyCodeDelete,
DecimalDigits = 2,
Name = currencyNameDelete
};
var validationResults = Get_Validation_Results(currency);
Assert.AreEqual(expected: 0, actual: validationResults.Count);
using (var entityManager = new CountriesEntityManager()) {
entityManager.AddEntity <Currency>(currency);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var currencyFromDb = entityManager.Set <Currency>()
.Where(x => (x.Id == currency.Id))
.SingleOrDefault();
Assert.IsNotNull(currencyFromDb);
}
var currencyToDelete = new Currency()
{
DetachedState = DetachedState.Deleted,
Id = currency.Id,
RowVersion = currency.RowVersion
};
using (var entityManager = new CountriesEntityManager()) {
entityManager.RemoveEntity <Currency>(currencyToDelete);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var currencyFromDb = entityManager.Set <Currency>()
.Where(x => (x.Id == currency.Id))
.SingleOrDefault();
Assert.IsNull(currencyFromDb);
}
}
public void Test_Continent_Delete()
{
var continent = new Continent()
{
DetachedState = DetachedState.Added,
Abbreviation = continentAbbreviationDelete,
Name = continentNameDelete
};
var validationResults = Get_Validation_Results(continent);
Assert.AreEqual(expected: 0, actual: validationResults.Count);
using (var entityManager = new CountriesEntityManager()) {
entityManager.AddEntity <Continent>(continent);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var continentFromDb = entityManager.Set <Continent>()
.Where(x => (x.Id == continent.Id))
.SingleOrDefault();
Assert.IsNotNull(continentFromDb);
}
var continentToDelete = new Continent()
{
DetachedState = DetachedState.Deleted, Id = continent.Id
};
using (var entityManager = new CountriesEntityManager()) {
entityManager.RemoveEntity <Continent>(continentToDelete);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var continentFromDb = entityManager.Set <Continent>()
.Where(x => (x.Id == continent.Id))
.SingleOrDefault();
Assert.IsNull(continentFromDb);
}
}
public void Test_CallingCode_Delete()
{
var callingCode = new CallingCode()
{
DetachedState = DetachedState.Added,
CallingCodeNumber = callingCodeNumberDelete
};
var validationResults = Get_Validation_Results(callingCode);
Assert.AreEqual(expected: 0, actual: validationResults.Count);
using (var entityManager = new CountriesEntityManager()) {
entityManager.AddEntity <CallingCode>(callingCode);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var callingCodeFromDb = entityManager.Set <CallingCode>()
.Where(x => (x.Id == callingCode.Id))
.SingleOrDefault();
Assert.IsNotNull(callingCodeFromDb);
}
var callingCodeToDelete = new CallingCode()
{
DetachedState = DetachedState.Deleted, Id = callingCode.Id
};
using (var entityManager = new CountriesEntityManager()) {
entityManager.RemoveEntity <CallingCode>(callingCodeToDelete);
int updateCount = entityManager.SaveChanges();
Assert.AreNotEqual(notExpected: 0, actual: updateCount);
}
using (var entityManager = new CountriesEntityManager()) {
var callingCodeFromDb = entityManager.Set <CallingCode>()
.Where(x => (x.Id == callingCode.Id))
.SingleOrDefault();
Assert.IsNull(callingCodeFromDb);
}
}
