public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
ownersRepository = new OwnersRepository(con);
}
public IHttpActionResult Get(bool includes)
{
using (var repository = new OwnersRepository())
{
return(Ok(repository.GetCollection(includes)));
}
}
// Business Logic pass through code to Select an Owner by ID
public OwnersEntity SelectOwnerById(int id)
{
try
{
OwnersEntity returnedEntity;
using (var repository = new OwnersRepository())
{
returnedEntity = repository.SelectById(id);
if (returnedEntity != null)
{
// Business Calculation function called from here
returnedEntity.PetYears = GetPetYears(returnedEntity.PetAge);
}
}
return(returnedEntity);
}
catch (Exception ex)
{
//Log exception error
_loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true);
throw new Exception("BusinessLogic:OwnersBusiness::SelectOwnerById::Error occured.", ex);
}
}
// Business Logic pass through code to Select all Owners
public List <OwnersEntity> SelectAllOwners()
{
var returnedEntities = new List <OwnersEntity>();
try
{
using (var repository = new OwnersRepository())
{
// HERE A CALCULATION CAN BE ADDED AS A COLUMN IN SelectAll function
foreach (var entity in repository.SelectAll())
{
entity.PetYears = GetPetYears(entity.PetAge);
returnedEntities.Add(entity);
}
}
return(returnedEntities);
}
catch (Exception ex)
{
//Log exception error
_loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true);
throw new Exception("BusinessLogic:OwnersBusiness::SelectAllOwners::Error occured.", ex);
}
}
public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
regionsRepository = new RegionsRepository(con);
countriesRepository = new CountriesRepository(con);
manufacturersRepository = new ManufacturersRepository(con);
carsRepository = new CarsRepository(con);
carValidation = new CarValidation(con);
ownerCarsRepository = new OwnerCarsRepository(con);
ownersRepository = new OwnersRepository(con);
regionsRepository.Save(Region1);
regionsRepository.Save(Region2);
regionsRepository.Save(Region3);
regionsRepository.Flush();
countriesRepository.Save(Country1);
countriesRepository.Save(Country2);
countriesRepository.Save(Country3);
countriesRepository.Save(Country4);
countriesRepository.Save(Country5);
countriesRepository.Flush();
manufacturersRepository.Save(Manufacturer1);
manufacturersRepository.Save(Manufacturer2);
manufacturersRepository.Save(Manufacturer3);
manufacturersRepository.Save(Manufacturer4);
manufacturersRepository.Save(Manufacturer5);
manufacturersRepository.Save(Manufacturer6);
manufacturersRepository.Save(Manufacturer7);
manufacturersRepository.Save(Manufacturer8);
manufacturersRepository.Save(Manufacturer9);
manufacturersRepository.Flush();
carsRepository.Save(Car1);
carsRepository.Save(Car2);
carsRepository.Save(Car3);
carsRepository.Save(Car4);
carsRepository.Save(Car5);
carsRepository.Save(Car6);
carsRepository.Save(Car7);
carsRepository.Save(Car8);
carsRepository.Save(Car9);
carsRepository.Save(Car10);
carsRepository.Save(Car11);
carsRepository.Save(Car12);
carsRepository.Save(Car13);
carsRepository.Save(Car14);
carsRepository.Save(Car15);
carsRepository.Flush();
ownersRepository.SaveAndFlush(Owner2);
ownerCarsRepository.SaveAndFlush(OwnerCar2);
}
public IHttpActionResult DeleteAllData()
{
using (var repository = new OwnersRepository())
{
repository.DeleteAll();
}
return(Ok("Database cleared"));
}
public void GetAll_WhenInvoked_ReturnsAllOwnersWithPets()
{
var petsContext = new PetsContext
{
Owners = new List <Owner>
{
new Owner
{
Name = "Bob",
Gender = "Male",
Age = 23,
Pets = new List <Pet>
{
new Pet
{
Name = "Garfield",
Type = "Cat"
},
new Pet
{
Name = "Fido",
Type = "Dog"
}
}
},
new Owner
{
Name = "Jennifer",
Gender = "Female",
Age = 18,
Pets = new List <Pet>
{
new Pet
{
Name = "Garfield",
Type = "Cat"
}
}
},
new Owner
{
Name = "Fred",
Gender = "Male",
Age = 40,
Pets = null
}
}
};
var repository = new OwnersRepository(new LoggerFactory(), petsContext);
var result = repository.GetAll();
Assert.Equal(3, result.Count());
Assert.Equal(3, result.Where(o => o.Pets != null).SelectMany(x => x.Pets).Count());
}
public UnitOfWork(VehiclesPriceListAppContext context)
{
_context = context;
VehiclesPriceList = new VehiclesPriceListRepository(_context);
Menufacturers = new MenufacturersRepository(_context);
MenufactureringOrigin = new MenufactureringOriginRepository(_context);
VehicleOwners = new OwnersRepository(_context);
VehicleStatus = new StatusRepository(_context);
VehicleType = new TypeRepository(_context);
}
public static void TestFixtureSetup(TestContext context)
{
con = new NpgsqlConnection(cs);
con.Open();
ownersRepository = new OwnersRepository(con);
ownersService = new OwnersService(con);
ownersRepository.Save(Owner1);
ownersRepository.Save(Owner2);
ownersRepository.Save(Owner3);
ownersRepository.Flush();
}
public IHttpActionResult SeedData()
{
var owners = dataProvider.GetSampleData();
using (var repository = new OwnersRepository())
{
foreach (var owner in owners)
{
repository.Create(owner);
}
}
return(Ok("Data seeded"));
}
// Business Logic pass through code to Delete an Owner by ID
public bool DeleteOwnerById(int id)
{
try
{
using (var repository = new OwnersRepository())
{
return(repository.DeleteById(id));
}
}
catch (Exception ex)
{
//Log exception error
_loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true);
throw new Exception("BusinessLogic:OwnersBusiness::DeleteOwnerById::Error occured.", ex);
}
}
public IHttpActionResult GetById(int id, bool includes)
{
Owner owner = null;
using (var repository = new OwnersRepository())
{
owner = repository.GetById(id, includes);
}
if (owner != null)
{
return(Ok(owner));
}
else
{
return(NotFound());
}
}
// Business Logic pass through code to Update Owner
public bool UpdateOwner(OwnersEntity entity)
{
try
{
bool bOpDoneSuccessfully;
using (var repository = new OwnersRepository())
{
bOpDoneSuccessfully = repository.Update(entity);
}
return(bOpDoneSuccessfully);
}
catch (Exception ex)
{
//Log exception error
_loggingHandler.LogEntry(ExceptionHandler.GetExceptionMessageFormatted(ex), true);
throw new Exception("BusinessLogic:OwnersBusiness::UpdateOwner::Error occured.", ex);
}
}
/// <summary>Initializes a new instance of the <see cref="OwnerCarValidation"/> class.</summary>
/// <param name="npgsqlConnection">The NPGSQL connection.</param>
public OwnerCarValidation(NpgsqlConnection npgsqlConnection) : base(npgsqlConnection)
{
ownersRepository = new OwnersRepository(npgsqlConnection);
carsRepository = new CarsRepository(npgsqlConnection);
ownerCarsRepository = new OwnerCarsRepository(npgsqlConnection);
}
