/// <summary> /// Removes given record from the database. /// </summary> /// <param name="record"></param> /// <returns></returns> public async Task RemoveAsync(T record) { using (var companyDb = new CompanyDbContext()) { companyDb.Set <T>().Attach(record); companyDb.Set <T>().Remove(record); await companyDb.SaveChangesAsync().ConfigureAwait(false); } }
public void AddEmployeeToProject(EmployeeProjectDto dto) { log.Debug(GetById(dto.ProjectId).Name); context.Set <EmployeeProject>() .Add(new EmployeeProject { EmployeeId = dto.EmployeeId, Employee = context.Employee.Single(e => e.Id == dto.EmployeeId), ProjectId = dto.ProjectId, Project = GetById(dto.ProjectId) }); }
/// <summary> /// Removes given collection of records from the database. /// </summary> /// <param name="records"></param> /// <returns></returns> public async Task RemoveAsync(IEnumerable <T> records) { using (var companyDb = new CompanyDbContext()) { foreach (T record in records) { companyDb.Set <T>().Attach(record); } companyDb.Set <T>().RemoveRange(records); await companyDb.SaveChangesAsync().ConfigureAwait(false); } }
private static void SeedOffers(CompanyDbContext companyDb, out IEnumerable <Offer> offers) { if (employees == null || employees.Count() < 2) { throw new ArgumentNullException( "employees", "Run SeedCompanyEmployees() first and make sure at least two Employees are seeded."); } if (inquiries == null || inquiries.Count() == 0) { throw new ArgumentNullException( "offers", "Run SeedInquiries() first and make sure at least one Offer is seeded."); } var maria = employees.Skip(1).First(); var inquiry = inquiries.First(); var offer = Offer.Create("No html yet.", inquiry.Id, maria.Id); offer.Send(maria.Id); offers = new List <Offer>() { offer }; companyDb.Set <Offer>().AddRange(offers); }
/// <summary> /// Adds a collection of records to the database. /// </summary> /// <param name="records">An enumerable collection of records of given type.</param> /// <returns></returns> public async Task AddAsync(IEnumerable <T> records) { using (var companyDb = new CompanyDbContext()) { companyDb.Set <T>().AddRange(records); await companyDb.SaveChangesAsync().ConfigureAwait(false); } }
/// <summary> /// Returns all records of given type. /// </summary> /// <returns>An enumerable collection of records of given type.</returns> public async Task <IEnumerable <T> > GetAllRecordsAsync() { IEnumerable <T> collection; using (var companyDb = new CompanyDbContext()) { collection = await companyDb.Set <T>().ToListAsync().ConfigureAwait(false); } return(collection); }
public void Add(T entity) { DbContext.Set <T>().Add(entity); }
public async Task <ActionResult <IEnumerable <Model.Entity.Company> > > Get() { await _logger.Current().InfoAsync("test"); return(await _context.Set <Model.Entity.Company>().Include(t => t.Branches).ToListAsync()); }
public Task <bool> AnyAsync <T>(Expression <Func <T, bool> > predicate) where T : EntityBase { return(context.Set <T>().AnyAsync(predicate)); }
public void Add(TEntity entity) { dataContext.Set <TEntity>().Add(entity); }