public async Task AddPost(Post post)
{
using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString))
{
context.Posts.Add(post);
await context.SaveChangesAsync();
}
}
public async Task AddComment(Comment comment)
{
using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString))
{
context.Comments.Add(comment);
await context.SaveChangesAsync();
}
}
/// <inheritdoc />
public async Task <OrderDto> GetAsync(long id)
{
using (var context = RepositoryContextFactory.CreateDbContext()) {
var result = await GetQueryableOrders(context, true).SingleOrDefaultAsync(e => e.Id == id);
return(result);
}
}
public RepositoryContext CreateDbContext(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
var config = builder.Build();
var connectionString = config.GetConnectionString("DefaultConnection");
var repositoryFactory = new RepositoryContextFactory();
return(repositoryFactory.CreateDbContext(connectionString));
}
public async Task DeleteComment(int commentId)
{
using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString))
{
var coomment = new Comment()
{
CommentId = commentId
};
context.Comments.Remove(coomment);
await context.SaveChangesAsync();
}
}
public async Task DeletePost(int postId)
{
using (var context = RepositoryContextFactory.CreateDbContext(ConnectionString))
{
var post = new Post()
{
PostId = postId
};
context.Posts.Remove(post);
await context.SaveChangesAsync();
}
}
public RepositoryContext CreateDbContext(string[] args)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
var config = builder.Build();
//вытаскиваем строку подключения из конфига
var connectionString = config.GetConnectionString("DefaultConnection");
var repositoryFactory = new RepositoryContextFactory();
//создаем и возвращаем DBContext
return(repositoryFactory.CreateDbContext(connectionString));
}
