private void deleteDependency(NpgsqlConnection conn, NpgsqlTransaction tran, String id)
{
DependencyDAO dependencyDAO = new DependencyDAO();
List <Dependency> dependencies = dependencyDAO.selectByElementID(id);
foreach (Dependency dependency in dependencies)
{
dependencyDAO.delete(conn, tran, dependency.element.getId(), dependency.dependencyElement.getId());
}
dependencies = dependencyDAO.selectByDependencyElementID(id);
foreach (Dependency dependency in dependencies)
{
dependencyDAO.delete(conn, tran, dependency.element.getId(), dependency.dependencyElement.getId());
}
}
private void updateDependencyID(NpgsqlConnection conn, NpgsqlTransaction tran, String originalID, String newID)
{
if (originalID.Equals(Element.getRoot().getId()))
{
return;
}
DependencyDAO dependencyDAO = new DependencyDAO();
List <Dependency> dependencies = dependencyDAO.selectByElementID(originalID);
foreach (Dependency dependency in dependencies)
{
dependencyDAO.update(
conn,
tran,
dependency.element.getId(),
dependency.dependencyElement.getId(),
newID,
dependency.dependencyElement.getId(),
dependency.dependencyTypeCreate,
dependency.dependencyTypeRead,
dependency.dependencyTypeUpdate,
dependency.dependencyTypeDelete,
dependency.remark);
}
dependencies = dependencyDAO.selectByDependencyElementID(originalID);
foreach (Dependency dependency in dependencies)
{
dependencyDAO.update(
conn,
tran,
dependency.element.getId(),
dependency.dependencyElement.getId(),
dependency.element.getId(),
newID,
dependency.dependencyTypeCreate,
dependency.dependencyTypeRead,
dependency.dependencyTypeUpdate,
dependency.dependencyTypeDelete,
dependency.remark);
}
}