/// <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);
}