public override async Task <Screen?> FindAsync(params object[] id)
{
if (!(id[0] is int))
{
return(null);
}
return(ScreenMapper.MapFromDomain(await RepositoryDbSet.AsNoTracking().FirstOrDefaultAsync(screen => screen.Id == (int)id[0])));
}
public async Task <IEnumerable <Event> > GetAllFutureEventsAsync(DateTime currentTime)
{
return(await RepositoryDbSet
.AsNoTracking()
.Where(e => e.EndDateTime.Date >= currentTime.Date || e.ShowEndDateTime.Date >= currentTime.Date)
.OrderBy(e => e.StartTime).ThenBy(e => e.EndDateTime)
.Select(e => EventMapper.MapFromDomain(e))
.ToListAsync());
}
public async Task <Product> FindProductInfoAsync(int id)
{
var product = await RepositoryDbContext.Set <Domain.Product>().FindAsync(id);
RepositoryDbContext.Entry(product).State = EntityState.Detached;
return(ProductMapper.MapFromDomain(await RepositoryDbSet.AsNoTracking().Where(a => a.Id == product.Id)
.Include(aa => aa.ProductName).ThenInclude(t => t.Translations)
.Include(s => s.Shop)
.Include(m => m.Manufacturer)
.FirstOrDefaultAsync()));
}
public async Task <AppUsersScreen?> GetScreenForUserAsync(string userId)
{
if (!Guid.TryParse(userId, out var userGuid))
{
return(null);
}
return(AppUsersScreenMapper.MapFromDomain(await RepositoryDbSet
.AsNoTracking()
.Include(s => s.Screen)
.FirstOrDefaultAsync(s => s.AppUserId.Equals(userGuid))));
}
public override async Task <Product> FindAsync(params object[] id)
{
var product = await RepositoryDbContext.Set <Domain.Product>().FindAsync(id);
RepositoryDbContext.Entry(product).State = EntityState.Detached;
return(ProductMapper.MapFromDomain(await RepositoryDbSet.AsNoTracking().Where(a => a.Id == product.Id)
.Include(aa => aa.ProductName).ThenInclude(t => t.Translations)
.Include(aa => aa.Length).ThenInclude(t => t.Translations)
.Include(aa => aa.Weight).ThenInclude(t => t.Translations)
.Include(aa => aa.ManuFacturerItemCode).ThenInclude(t => t.Translations)
.Include(aa => aa.ShopCode).ThenInclude(t => t.Translations)
.Include(p => p.Inventory).ThenInclude(i => i.Description).ThenInclude(t => t.Translations)
.Include(m => m.Manufacturer).ThenInclude(mm => mm.ManuFacturerName).ThenInclude(t => t.Translations)
.Include(m => m.Manufacturer).ThenInclude(mm => mm.Aadress).ThenInclude(t => t.Translations)
.Include(m => m.Manufacturer).ThenInclude(mm => mm.PhoneNumber).ThenInclude(t => t.Translations)
.Include(a => a.Shop).ThenInclude(aa => aa.ShopName).ThenInclude(t => t.Translations)
.Include(a => a.Shop).ThenInclude(aa => aa.ShopAddress).ThenInclude(t => t.Translations)
.Include(a => a.Shop).ThenInclude(aa => aa.ShopContact).ThenInclude(t => t.Translations)
.Include(a => a.Shop).ThenInclude(aa => aa.ShopContact2).ThenInclude(t => t.Translations)
.Include(a => a.Comments).ThenInclude(aa => aa.CommentBody).ThenInclude(t => t.Translations)
.Include(a => a.Comments).ThenInclude(aa => aa.CommentTitle).ThenInclude(t => t.Translations)
.FirstOrDefaultAsync()));
}
public async Task <Subject> FindBySubjectNameAndCodeAsync(string name, string code)
{
return(SubjectMapper.MapFromDomain(await RepositoryDbSet
.AsNoTracking()
.FirstOrDefaultAsync(s => s.SubjectName == name && s.SubjectCode == code)));
}
public async Task <Screen> GetFirstAndActiveScreenAsync()
{
return(ScreenMapper.MapFromDomain(await RepositoryDbSet.AsNoTracking().FirstOrDefaultAsync(s => s.IsActive)));
}
public async Task <Teacher> FindTeacherByNameAndRoleAsync(string name, string?role)
{
return(TeacherMapper.MapFromDomain(await RepositoryDbSet
.AsNoTracking()
.FirstOrDefaultAsync(t => t.FullName.Equals(name) && t.Role == role)));
}
public async Task <SubjectInSchedule> FindByUniqueIdentifierAsync(string uniqueId)
{
return(SubjectInScheduleMapper.MapFromDomain(await RepositoryDbSet
.AsNoTracking()
.FirstOrDefaultAsync(s => s.UniqueIdentifier.Equals(uniqueId))));
}
