public async Task <IActionResult> DeleteRecertCycle(int id)
{
try
{
if (id <= 0)
{
return(StatusCode(400, "id is invalid"));
}
var RecertCycle = await _context.RecertCycleTable.FindAsync(id);
if (RecertCycle == null)
{
return(StatusCode(404));
}
_context.RecertCycleTable.Remove(RecertCycle);
await _context.SaveChangesAsync();
return(StatusCode(204));
}
catch (Exception ex)
{
_logger.LogDebug(ex.ToString());
return(StatusCode(500));
}
}
public async Task <ActionResult <PrivDTO> > AddPriv(PrivPostDTO priv)
{
try
{
var privExists = await _context.PrivTable.FindAsync(priv.PrivId);
if (privExists != null)
{
return(StatusCode(409, "The PrivId already exists")); // Conflict
}
var serviceExists = await _context.ServiceTable.FindAsync(priv.ServiceId);
if (serviceExists == null)
{
return(StatusCode(400, "The ServiceId does not exist"));
}
_context.PrivTable.Add(
new PrivTable
{
PrivId = priv.PrivId,
ServiceId = priv.ServiceId,
PermissionGroup = priv.PermissionGroup,
ServicePrivSummary = priv.ServicePrivSummary,
CredentialStorageMethod = priv.CredentialStorageMethod
}
);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetPriv), new { id = priv.PrivId }, priv));
}
catch (Exception ex)
{
_logger.LogDebug(ex.ToString());
return(StatusCode(500));
}
}
public async Task <ActionResult <ServiceDTO> > AddService(ServicePostDTO service)
{
try
{
var serviceExists = await _context.ServiceTable.FindAsync(service.ServiceId);
if (serviceExists != null)
{
return(StatusCode(409, "The ServiceId already exists"));
}
var roleExists = await _context.RoleTable.FindAsync(service.ServiceOwner_RoleId);
if (roleExists == null)
{
return(StatusCode(400, "The ServiceOwner_RoleId does not exist"));
}
_context.ServiceTable.Add(
new ServiceTable
{
ServiceId = service.ServiceId,
ServiceName = service.ServiceName,
ServiceDescription = service.ServiceDescription,
ServiceOwner_RoleId = service.ServiceOwner_RoleId
}
);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetService), new { id = service.ServiceId }, service));
}
catch (Exception ex)
{
_logger.LogDebug(ex.ToString());
return(StatusCode(500));
}
}
public async Task <ActionResult <UserDTO> > AddUser(UserPostDTO user)
{
try
{
var userExists = await _context.UserTable.FindAsync(user.UserId);
if (userExists != null)
{
return(StatusCode(409, "The UserId already exists"));
}
var roleExists = await _context.RoleTable.FindAsync(user.RoleId);
if (roleExists == null)
{
return(StatusCode(400, "The RoleId does not exist"));
}
_context.UserTable.Add(
new UserTable
{
UserId = user.UserId,
UserFullName = user.UserFullName,
RoleId = user.RoleId
}
);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogDebug(ex.ToString());
return(StatusCode(500));
}
return(CreatedAtAction(nameof(GetUser), new { id = user.UserId }, user));
}