/// <summary>
/// Inserts a new path map record
/// </summary>
/// <param name="pathMap">
/// The path map to insert
/// </param>
/// <returns>
/// The inserted path map, including the generated primary key
/// </returns>
public PathMap InsertPathMap(PathMap pathMap)
{
Execute(
"INSERT INTO PathMap (" +
"SessionID, " +
"NodeID, " +
"Path) " +
"VALUES (@p0, @p1, @p2);",
pathMap.Session.ID,
pathMap.NodeID,
pathMap.Path
);
pathMap.ID = GetLastRowID();
return pathMap;
}
/// <summary>
/// Updates an existing path map record
/// </summary>
/// <param name="pathMap">
/// The path map to update
/// </param>
/// <returns>
/// The updated path map record
/// </returns>
public PathMap UpdatePathMap(PathMap pathMap)
{
Execute(
"UPDATE PathMap SET " +
"SessionID = @p1, " +
"NodeID = @p2, " +
"Path = @p3 " +
"WHERE ID = @p0;",
pathMap.ID,
pathMap.Session.ID,
pathMap.NodeID,
pathMap.Path
);
return pathMap;
}
/// <summary>
/// Deletes an existing path map
/// </summary>
/// <param name="pathMap">
/// The path map to delete
/// </param>
public void DeletePathMap(PathMap pathMap)
{
Execute(
"DELETE FROM PathMap WHERE ID = @p0;",
pathMap.ID
);
}
