public IEnumerable <SiteModel> GetSites()
{
_context.Database.ExecuteSqlCommand("PRAGMA foreign_keys = ON");
var sites = _siteRepo.GetAll().ToList();
var mapper = new SiteMapper();
return(mapper.Map(sites));
}
public void AddSite(SiteModel site)
{
var repository = new Repository <SiteEntity>(_context);
var mapper = new SiteMapper();
var entity = mapper.Map(site);
_siteRepo.Add(entity);
_siteRepo.Save();
}
public void DeleteSite(SiteModel site)
{
var mapper = new SiteMapper();
var entity = mapper.Map(site);
var entityToDelete = _siteRepo.Get(entity.SiteId);
_context.Entry(entityToDelete).Collection(y => y.Customers).Load();
_context.Entry(entityToDelete).Collection(y => y.Supervisors).Load();
_siteRepo.Delete(entityToDelete);
_siteRepo.Save();
}
