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