public async Task <IActionResult> Edit(int id, [Bind("Id,SurgeryRoomDescription")] SurgeryRoom surgeryRoom)
{
if (id != surgeryRoom.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(surgeryRoom);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SurgeryRoomExists(surgeryRoom.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(surgeryRoom));
}
public IActionResult addRoom([FromBody] SurgeryRoom room )
{
try {
// executeSQL("SET FOREIGN_KEY_CHECKS=OFF;"); //disabling foreign key
Random random = new Random();
int id = random.Next(0, 1000);
string sqlQuery = "INSERT INTO medicine_info VALUES ( " +
(char)39 + id + (char)39 + "," +
(char)39 + room.name + (char)39 + "," +
(char)39 + room.rfid + (char)39 +
");";
executeSQL(sqlQuery);
// executeSQL("SET FOREIGN_KEY_CHECKS=ON;");
HttpContext.Response.StatusCode = 200;
var status = "Medication added successfully !!";
return Ok(status);
} catch (Exception e) {
HttpContext.Response.StatusCode = 400;
return Problem(
detail: e.StackTrace,
title: e.Message);
}
}
public async Task <IActionResult> Create([Bind("Id,SurgeryRoomDescription")] SurgeryRoom surgeryRoom)
{
if (ModelState.IsValid)
{
_context.Add(surgeryRoom);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(surgeryRoom));
}
