public async Task <IActionResult> PutTpOrders(Guid id, TpOrders tpOrders) { if (id != tpOrders.OrdrId) { return(BadRequest()); } _context.Entry(tpOrders).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TpOrdersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <TpOrders> > PostTpOrders(TpOrders tpOrders) { _context.TpOrders.Add(tpOrders); await _context.Database.ExecuteSqlRawAsync("tpsrv_logon", new SqlParameter("@Login", "sa"), new SqlParameter("@Password", "tillypad")); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTpOrders", new { id = tpOrders.OrdrId }, tpOrders)); }