private IList <DiscussionEntryReturnType> GetUserJoined(Expression <Func <DiscussionEntry, bool> > expression, Func <IQueryable <DiscussionEntryReturnType>, IQueryable <DiscussionEntryReturnType> > fun = null) { IQueryable <DiscussionEntryReturnType> v = RepositoryContext.Set <DiscussionEntry>().Where(expression).Join(RepositoryContext.Users, discussionEntry => discussionEntry.UserId, user => user.Id, (discussionEntry, user) => new DiscussionEntryReturnType() { Id = discussionEntry.Id, Topic = discussionEntry.Topic, Text = discussionEntry.Text, TimeStamp = discussionEntry.TimeStamp, Subgroup = discussionEntry.Subgroup, NormalGroup = discussionEntry.NormalGroup, UserId = discussionEntry.UserId, AnswerTo = discussionEntry.AnswerTo, File = discussionEntry.File, UserName = user.UserName, AnswerCount = RepositoryContext.DiscussionEntries.Count(uts => uts.AnswerTo == discussionEntry.Id) }).OrderBy(uts => uts.TimeStamp); if (fun != null) { v = fun(v); } return(v.ToList()); }
public IQueryable <T> FindAll(bool trackChanges) { return(!trackChanges? RepositoryContext.Set <T>() .AsNoTracking() : RepositoryContext.Set <T>()); }
public async Task <IEnumerable <Element> > GetAllElementsInDrawingAsync(Guid guid) { var elements = await RepositoryContext.Set <Element>() .Where(e => e.IdDrawing.Equals(guid) && !e.Status.Equals("Deleted")) .Include(e => e.ElementManagement) .ThenInclude(m => m.GeometryVersions).ToListAsync(); return(elements); }
public async Task <IEnumerable <ElementManagement> > GetAllInDrawingAsync(Guid drawing) { var eleManas = await RepositoryContext.Set <ElementManagement>() .Include(x => x.GeometryVersions) .Include(x => x.Elements) .Where(x => x.Elements.Any(e => e.IdDrawing.Equals(drawing))).ToListAsync(); return(eleManas); }
public async Task <IEnumerable <ElementManagement> > GetAllExeptAsync(Guid drawingExcept) { var eleManas = await RepositoryContext.Set <ElementManagement>() .Include(x => x.GeometryVersions) .Include(x => x.Elements) .ThenInclude(e => e.Drawing) .Where(x => x.Status.Equals("Normal") && !x.Elements.Any(e => e.IdDrawing.Equals(drawingExcept))).ToListAsync(); return(eleManas); }
public IQueryable <T> FindAll(bool trackChanges) => !trackChanges? RepositoryContext.Set <T>() .AsNoTracking() : // dont track the query when data change RepositoryContext.Set <T>();
public IQueryable <T> FindAll() => RepositoryContext.Set <T>();
public void Delete(T entity) { RepositoryContext.Set <T>().Remove(entity); }
public void Update(T entity) { RepositoryContext.Set <T>().Update(entity); }
public void Create <TDest>(TDest entity) where TDest : class { RepositoryContext.Set <TDest>().Add(entity); }
public async Task Create(T entity) => await RepositoryContext.Set <T>().AddAsync(entity);
public void Create(T entity) { context.Set <T>().Add(entity); }
public IQueryable <T> FindAll(bool trackChanges) => !trackChanges ? _repositoryContext.Set <T>() .AsNoTracking() : _repositoryContext.Set <T>();
public IQueryable <T> FindAll(bool trackChanges = false) => !trackChanges? RepositoryContext.Set <T>() .AsNoTracking() : RepositoryContext.Set <T>();
public async Task <IEnumerable <ElementManagement> > GetAllAsync() { var eleManas = await RepositoryContext.Set <ElementManagement>().Include(x => x.GeometryVersions).Include(x => x.Elements).ToListAsync(); return(eleManas); }
public async Task <string> GetUniqueId() { int countOfRows = await RepositoryContext.Set <T>().AsQueryable().CountAsync(); return(typeof(T).Name.ToUpper() + countOfRows); }
public async Task <long> NumOfRecord() { return(await RepositoryContext.Set <T>().AsQueryable().CountAsync()); }
public void Add(TEntity entity) { _dbContext.Set <TEntity>().Add(entity); }
public IQueryable <T> FindAll() { return(RepositoryContext.Set <T>().AsNoTracking()); }
public void Create(T entity) => RepositoryContext.Set <T>().Add(entity);
public IQueryable <T> FindByCondition(Expression <Func <T, bool> > expression) { return(RepositoryContext.Set <T>().Where(expression));//.AsNoTracking(); }