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