public AddressDetailModel Find(Guid addressId)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var address = directoryDbContext.Adresses
.FirstOrDefault(p => p.Id == addressId);
return(address == null ? null : _mapper.MapEntityToDetailModel(address));
}
}
public PersonDetailModel Find(Guid personId)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var person = directoryDbContext.Persons
.FirstOrDefault(p => p.Id == personId);
return(person == null ? null : _mapper.MapEntityToDetailModel(person));
}
}
public List <AddressDetailModel> GetAllByPerson(Guid personId)
{
using (var directoryDbContext = new DirectoryDbContext())
{
return(directoryDbContext.Adresses
.Where(a => a.Person.Id == personId)
.Select(_mapper.MapEntityToDetailModel)
.ToList());
}
}
public List <PersonDetailModel> GetAll()
{
using (var directoryDbContext = new DirectoryDbContext())
{
return(directoryDbContext.Persons
.Select(_mapper.MapEntityToDetailModel)
.OrderBy(p => p.FirstName)
.ToList());
}
}
public void Insert(PersonDetailModel person)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var entity = _mapper.MapDetailModelToEntity(person);
entity.Id = Guid.NewGuid();
directoryDbContext.Persons.Add(entity);
directoryDbContext.SaveChanges();
}
}
public void Insert(AddressDetailModel model)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var person = directoryDbContext.Persons.First(p => p.Id == model.PersonId);
var entity = _mapper.MapDetailModelToEntity(model, person);
entity.Id = Guid.NewGuid();
directoryDbContext.Adresses.Add(entity);
directoryDbContext.SaveChanges();
}
}
public void Update(AddressDetailModel address)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var entity = directoryDbContext.Adresses.First(p => p.Id == address.Id);
entity.City = address.City;
entity.Street = address.Street;
entity.ZipCode = address.ZipCode;
directoryDbContext.SaveChanges();
}
}
public void Update(PersonDetailModel person)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var entity = directoryDbContext.Persons.First(p => p.Id == person.Id);
entity.FirstName = person.FirstName;
entity.LastName = person.LastName;
entity.IN = person.IN;
entity.TIN = person.TIN;
directoryDbContext.SaveChanges();
}
}
public void Remove(Guid addressId, Guid personId)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var person = directoryDbContext.Persons.First(p => p.Id == personId);
var entity = new Address()
{
Id = addressId, Person = person
};
directoryDbContext.Adresses.Attach(entity);
directoryDbContext.Adresses.Remove(entity);
directoryDbContext.SaveChanges();
}
}
public void Remove(Guid personId)
{
using (var directoryDbContext = new DirectoryDbContext())
{
var addresses = directoryDbContext.Adresses.Where(a => a.Person.Id == personId).ToList();
var entity = new Person()
{
Id = personId, Adresses = addresses
};
directoryDbContext.Persons.Attach(entity);
directoryDbContext.Persons.Remove(entity);
directoryDbContext.SaveChanges();
}
}
public UserRepository(IRepositoryContext context, DirectoryDbContext database)
: base(context)
{
db = database;
}
public UserRepository(DirectoryDbContext a_dbContext) : base(a_dbContext)
{
}
public HealthRepository(IRepositoryContext context, DirectoryDbContext dbContext)
: base(context)
{
db = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public BaseRepository(DirectoryDbContext a_dbContext)
{
dbContext = a_dbContext;
}
