public IActionResult PutStatu(int id, [FromBody] Order model) { if (model == null || model.Id != id) { return(BadRequest()); } var item = _context.orders.Find(id); if (item == null) { return(NotFound()); } item.Statu = model.Statu; _context.SaveChanges(); return(Ok(item)); }
public async Task <ActionResult <Student> > PostStudent(Student student) { _context.Student.Add(student); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Student ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Student OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetStudent", new { id = student.Id }, student)); }
public async Task <ActionResult <AltUnit> > PostAltUnit(AltUnit alt) { _context.altUnits.Add(alt); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.altUnits ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.altUnits OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetAltUnit", new { id = alt.Id }, alt)); }
public async Task <ActionResult <Item> > PostItem(Item item) { _context.items.Add(item); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.items ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.items OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetItems", new { id = item.Id }, item)); }
public async Task <ActionResult <MainUnit> > PostMainUnit(MainUnit mainUnit) { _context.mainUnits.Add(mainUnit); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.mainUnits ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.mainUnits OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetMainUnits", new { id = mainUnit.Id }, mainUnit)); }
public async Task <ActionResult <Client> > PostClient(Client client) { _context.clients.Add(client); _context.Database.OpenConnection(); try { _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.clients ON"); _context.SaveChanges(); _context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.clients OFF"); } finally { _context.Database.CloseConnection(); } await _context.SaveChangesAsync(); return(CreatedAtAction("GetClient", new { id = client.Id }, client)); }