public async Task <List <StateFromTableDto> > GetTableStates(int tableId)
{
var stateTableLinks = await _dbContext.StateTables.Where(st => st.TableId == tableId)
.Include(st => st.State)
.ToListAsync();
return(stateTableLinks.Select(link => StateFromTableDto.Map(link))
.ToList());
}
public async Task <StateFromTableDto> AddStateToTable(StateFromTableDto dto)
{
var(stateTable, state) = StateFromTableDto.Map(dto);
state.Id = 0;
using (TransactionScope ts = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
await _dbContext.AddAsync(state);
await _dbContext.SaveChangesAsync();
stateTable.StateId = state.Id;
await _dbContext.AddAsync(stateTable);
await _dbContext.SaveChangesAsync();
ts.Complete();
}
return(StateFromTableDto.Map(stateTable));
}
public async Task <IActionResult> Update([FromBody] StateFromTableDto dto)
{
await _stateService.Update(dto);
return(Ok());
}
public async Task Update(StateFromTableDto dto)
{
}
public async Task <IActionResult> AddState([FromBody] StateFromTableDto dto)
{
var stateFromTableDto = await _stateService.AddStateToTable(dto);
return(Ok(stateFromTableDto));
}
