public async Task <Guid> AddAsync(TEntity entity)
{
var entry = await _todoAppDbContext.AddAsync(entity).ConfigureAwait(false);
await _todoAppDbContext.SaveChangesAsync().ConfigureAwait(false);
return((Guid)entry.Property("Id").CurrentValue);
}
public async void AddTaskAsync(string description, bool done)
{
var task = new TaskToDo()
{
Description = description, Done = done
};
dbContext.Tasks.Add(task);
await dbContext.SaveChangesAsync();
}
public async Task AddAsync(string description)
{
var item = new TodoItem()
{
Description = description,
CreatedDate = DateTime.UtcNow
};
dbContext.Add(item);
await dbContext.SaveChangesAsync();
}
private static async Task ResetTable <TEntity>(List <TEntity> entities) where TEntity : BaseEntity
{
IConfiguration configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.Development.json")
.Build();
var connectionString = configuration.GetConnectionString("MySqlConnectionTest");
var options = new DbContextOptionsBuilder <TodoAppDbContext>()
.UseMySql(connectionString).Options;
using (var context = new TodoAppDbContext(options))
{
await context.Database.MigrateAsync().ConfigureAwait(false);
var dbSet = context.Set <TEntity>();
var allEntities = await dbSet.ToListAsync().ConfigureAwait(false);
dbSet.RemoveRange(allEntities);
//await context.SaveChangesAsync().ConfigureAwait(false);
await dbSet.AddRangeAsync(entities).ConfigureAwait(false);
await context.SaveChangesAsync().ConfigureAwait(false);
}
}
public async static Task EnsureSeedData(this TodoAppDbContext dbContext)
{
if (dbContext.TodoItems.Any())
{
return;
}
await dbContext.AddRangeAsync(_todoItems);
await dbContext.SaveChangesAsync();
}
/// <summary>
/// Deletes entity
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <bool> Delete(int id)
{
using (TodoAppDbContext context = _contextFactory.CreateDbContext())
{
T entity = context.Set <T>().FirstOrDefault((e) => e.Id == id);
context.Set <T>().Remove(entity);
await context.SaveChangesAsync();
return(true);
}
}
/// <summary>
/// Updates entity
/// </summary>
/// <param name="id"></param>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <T> Update(int id, T entity)
{
using (TodoAppDbContext context = _contextFactory.CreateDbContext())
{
entity.Id = id;
context.Set <T>().Add(entity);
await context.SaveChangesAsync();
return(entity);
}
}
/// <summary>
/// Updates task
/// </summary>
/// <param name="id"></param>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <TaskModel> Update(int id, TaskModel entity)
{
using (TodoAppDbContext context = _contextFactory.CreateDbContext())
{
var editedEntity = context.Tasks.Where(e => e.Id == entity.Id).First();
context.Entry(editedEntity).CurrentValues.SetValues(entity);
await context.SaveChangesAsync();
return(entity);
}
}
public async Task Add(SubCategory entity)
{
await _context.AddAsync(entity);
await _context.SaveChangesAsync();
}
private Task SaveChanges()
{
return(_dbContext.SaveChangesAsync());
}
public async Task <bool> SaveChangesAsync()
{
return(await _context.SaveChangesAsync() > 0);
}