示例#1
0
        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));
        }
示例#2
0
        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));
        }
示例#5
0
        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));
        }
示例#6
0
        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));
        }