private async Task <bool> AddUserToFinancialInstrumentAsync(int finId, int userId) { var dbUser = await _dbContext.User.SingleOrDefaultAsync(x => x.Id == userId); var finInst = await _dbContext.FinancialInstrument.SingleOrDefaultAsync(x => x.Id == finId); if (dbUser == null || finInst == null) { return(false); } var exists = await _dbContext.FinancialInstrumentUser .SingleOrDefaultAsync(x => x.UserId == dbUser.Id && x.FinInstrumentId == finInst.Id); if (exists != null) { return(false); } var finUser = new FinancialInstrumentUser { FinInstrumentId = finId, UserId = userId }; await _dbContext.AddAsync(finUser); var result = await _dbContext.SaveChangesAsync(); return(result > 0); }
private void SeedFinancialInstrumentUsers() { var dbFinUser = new FinancialInstrumentUser { UserId = 1, FinInstrumentId = 1 }; _dbContext.FinancialInstrumentUser.Add(dbFinUser); _dbContext.SaveChanges(); }