public async Task <SelectAgent> AddSelectAgentAsync(SelectAgent selectAgent)
        {
            _uow.SelectAgents.Add(selectAgent);
            await _uow.SaveChangesAsync().ConfigureAwait(false);

            return(selectAgent);
        }
        public async Task <SelectAgent> UpdateSelectAgentAsync(SelectAgent selectAgent)
        {
            //    var cmd = $"EXEC SelectAgent_Update @SelectAgentId = {selectAgent.SelectAgentId}," +
            //$" @SelectAgentTitle = N'{selectAgent.SelectAgentTitle}'";
            //    await _uow.Database.ExecuteSqlCommandAsync(cmd).ConfigureAwait(false);
            _uow.Entry(selectAgent).State = EntityState.Modified;
            await _uow.SaveChangesAsync().ConfigureAwait(false);

            return(selectAgent);
        }