Exemplo n.º 1
0
        public async Task <IActionResult> OnPostAsync()
        {
            if (!ModelState.IsValid)
            {
                return(Page());
            }

            _context.Attach(DataPoint).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!DataPointExists(DataPoint.TimeStamp))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(RedirectToPage("./Index"));
        }
        public async Task <IActionResult> OnPostAsync()
        {
            if (!ModelState.IsValid)
            {
                return(Page());
            }

            _context.Sensor.Add(Sensor);

            // added commands to unlock/lock permissions to set ID params
            //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Sensor ON");
            await _context.SaveChangesAsync();

            //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Sensor OFF");

            return(RedirectToPage("./Index"));
        }
Exemplo n.º 3
0
        public async Task <IActionResult> OnPostAsync(int?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            Sensor = await _context.Sensor.FindAsync(id);

            if (Sensor != null)
            {
                _context.Sensor.Remove(Sensor);
                await _context.SaveChangesAsync();
            }

            return(RedirectToPage("./Index"));
        }
        public async Task <IActionResult> OnPostAsync(DateTime?id)
        {
            if (id == null)
            {
                return(NotFound());
            }

            DataPoint = await _context.DataPoint.FindAsync(id);

            if (DataPoint != null)
            {
                _context.DataPoint.Remove(DataPoint);
                await _context.SaveChangesAsync();
            }

            return(RedirectToPage("./Index"));
        }
        public async Task <IActionResult> OnPostAsync()
        {
            if (!ModelState.IsValid)
            {
                return(Page());
            }

            _context.DataPoint.Add(DataPoint);

            // Finds the Sensor that matches the foreign key ID in the DataPoint
            var findSensorByID = _context.Sensor.Single(s => s.ID == DataPoint.ID);

            // Add DataPoint to the list of the sensor
            findSensorByID.DataPoints.Add(DataPoint);

            // added commands to unlock/lock permissions to set ID params
            //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.DataPoint ON");
            await _context.SaveChangesAsync();

            //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.DataPoint OFF");

            return(RedirectToPage("./Index"));
        }