public async Task <IActionResult> PutTpClients(Guid id, TpClients tpClients)
        {
            if (id != tpClients.ClntId)
            {
                return(BadRequest());
            }

            _context.Entry(tpClients).State = EntityState.Modified;

            try {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException) {
                if (!TpClientsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
        public async Task <ActionResult <TpClients> > PostTpClients(TpClients tpClients)
        {
            _context.TpClients.Add(tpClients);
            await _context.Database.ExecuteSqlRawAsync("tpsrv_logon", new SqlParameter("@Login", "sa"), new SqlParameter("@Password", "tillypad"));

            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetTpClients", new { id = tpClients.ClntId }, tpClients));
        }