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));
}
