public void UpdateUserRoles(SecurityModels.UpdateUserRolesRequest updateUserRolesRequest)
{
try
{
using (SqlConnection con = new SqlConnection(securityConnectionString))
{
using (SqlCommand cmd = new SqlCommand("UpdateUserRoles", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = updateUserRolesRequest.id;
cmd.Parameters.Add("@Roles", SqlDbType.VarChar).Value = updateUserRolesRequest.roles;
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}
catch
{
throw;
}
}
public IActionResult UpdateUserRoles([FromBody] SecurityModels.UpdateUserRolesRequest updateUserRolesRequest)
{
securityInventoryRepo.UpdateUserRoles(updateUserRolesRequest);
return(StatusCode(StatusCodes.Status200OK, ""));
}