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