public async Task <Unit> Handle(SaveCommentCommand request, CancellationToken cancellationToken)
{
var comment = new ProjectComment(request.Content, request.IdProject, request.IdUser);
await dBContext.ProjectComments.AddAsync(comment);
await dBContext.SaveChangesAsync();
return(Unit.Value);
}
public async Task <Unit> Handle(CreateCommentCommand request, CancellationToken cancellationToken)
{
var comment = new ProjectComment(request.Content, request.IdProject, request.IdUser);
await _dbContext.ProjectComments.AddAsync(comment);
//Entity Framework
await _dbContext.SaveChangesAsync();
//Dapper
//using (var sqlConnection = new SqlConnection(_connectionString))
//{
// sqlConnection.Open();
// var sql = "INSERT INTO ProjectComments (Content, IdProject, IdUser, CreatedAt) VALUES (@content, @idproject, @iduser, @createdat)";
// sqlConnection.Execute(sql, new { content = comment.Content, idproject = comment.IdProject, iduser = comment.IdUser, createdat = comment.CreatedAt});
//}
return(Unit.Value);
}
public async Task SaveChanges()
{
await _dbContext.SaveChangesAsync();
}
public async Task AddAsync(Project project)
{
await _dbContext.Projects.AddAsync(project);
await _dbContext.SaveChangesAsync();
}
public async Task SaveAsyncProject(Project project)
{
await devFreelaDbContext.Projects.AddAsync(project);
await devFreelaDbContext.SaveChangesAsync();
}
public async Task AddUserAsync(User user)
{
await _dbContext.Users.AddAsync(user);
await _dbContext.SaveChangesAsync();
}
public async Task <int> CreateAsync(User user)
{
await _dbContext.Users.AddAsync(user);
return(await _dbContext.SaveChangesAsync());
}
public async Task CreateCommentAssync(ProjectComment comment)
{
await _dbContext.ProjectComments.AddAsync(comment);
await _dbContext.SaveChangesAsync();
}
public async Task Add(Skill skill)
{
await _dbContext.Skills.AddAsync(skill);
await _dbContext.SaveChangesAsync();
}
public async Task InserirAsync(Projeto projeto)
{
await _dbContext.Projetos.AddAsync(projeto);
await _dbContext.SaveChangesAsync();
}
public async Task InserirAsync(Usuario usuario)
{
await _dbContext.Usuarios.AddAsync(usuario);
await _dbContext.SaveChangesAsync();
}
public async Task Inactivate(User user)
{
user.Inactivate();
await _dbContext.SaveChangesAsync();
}
public async Task CreateUser(User user)
{
await devFreelaDbContext.Users.AddAsync(user);
await devFreelaDbContext.SaveChangesAsync();
}
public async Task Add(ProvidedService providedService)
{
await _dbContext.ProvidedServices.AddAsync(providedService);
await _dbContext.SaveChangesAsync();
}