/// <summary>
/// Retrieves a list of sub-directories stored in the PhotosServer databse.
/// </summary>
/// <param name="token">A reference to the current directory browser session token object.</param>
/// <param name="virtualPath">The virtual path to the parent directory.</param>
/// <returns>A collection of PhotoDirectory objects</returns>
public PhotoDirectories GetDirectories(SessionToken token, string virtualPath)
{
IDbCommand cmd = GetCommand();
//cmd.CommandText = "SELECT ID, Name from tblDirectories where VirtualPath = ? " +
cmd.CommandText = "SELECT ID, Name from tblDirectories where VirtualPath = '" + virtualPath + "' AND IsDeleted <> 'Y' ORDER BY Name";
//cmd.Parameters.Add(CreateStringParam("VirtualPath", virtualPath));
PhotoDirectories results = new PhotoDirectories();
using (IDataReader reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
PhotoDirectory photoDir = new PhotoDirectory(token,
reader.GetInt32(0),
reader.GetString(1),
virtualPath);
results.Add(photoDir);
}
}
return(results);
}
public PhotoDirectories GetDirectories(SessionToken token, string virtualPath)
{
IDbCommand command = base.GetCommand();
command.CommandText = "SELECT ID, Name from tblDirectories where VirtualPath = ? ORDER BY Name";
command.Parameters.Add(base.CreateStringParam("VirtualPath", virtualPath));
PhotoDirectories directories = new PhotoDirectories();
using (IDataReader reader = command.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
PhotoDirectory photoDirectory = new PhotoDirectory(token, reader.GetInt32(0), reader.GetString(1), virtualPath);
directories.Add(photoDirectory);
}
}
return(directories);
}
public static PhotoDirectories GetDirectories(PhotoDirectory parent, SessionToken token, string path)
{
string virtualPath;
PhotoDirectoryDB ydb = new PhotoDirectoryDB(token.DBConnection);
if (!Directory.Exists(path))
{
path = path.Substring(token.PhotosRootFullPath.Length, path.Length - token.PhotosRootFullPath.Length);
string name = path.Substring(path.LastIndexOf(Path.DirectorySeparatorChar) + 1);
virtualPath = path.Substring(0, path.LastIndexOf(Path.DirectorySeparatorChar));
ydb.Delete(name, virtualPath);
return(new PhotoDirectories());
}
PhotoDirectories directories = ydb.GetDirectories(token, GetVirtualPath(token, path));
PhotoDirectories directories2 = (PhotoDirectories)directories.Clone();
DirectoryInfo[] infoArray = new DirectoryInfo(path).GetDirectories();
if (directories2.Count != infoArray.Length)
{
foreach (DirectoryInfo info2 in infoArray)
{
if (!info2.Name.Equals(ThumbnailUtilities.ThumbnailDirectory))
{
virtualPath = GetVirtualPath(token, info2.FullName);
if (!directories.Contains(virtualPath))
{
string text3 = virtualPath.Substring(0, (virtualPath.Length - info2.Name.Length) - 1);
PhotoDirectory photoDirectory = new PhotoDirectory(token, info2.Name, text3);
ydb.Insert(parent, photoDirectory);
directories.Add(photoDirectory);
}
directories2.Remove(virtualPath);
}
}
foreach (PhotoDirectory directory in directories2)
{
ydb.Delete(directory);
new PhotoDB(token.DBConnection).DeleteDirectoryPhotos(directory);
directories.Remove(directory);
}
}
return(directories);
}
/// <summary>
/// Returns the details of the sub-directories contained within a given path.
/// </summary>
/// <param name="parent">The parent directory, or null it at the root.</param>
/// <param name="token">A reference to the current directory browser session token object.</param>
/// <param name="path">The physical path of the directory in question.</param>
/// <returns>A collection of PhotoDirectory objects.</returns>
public static PhotoDirectories GetDirectories(PhotoDirectory parent, SessionToken token, string path)
{
PhotoDirectoryDB db = new PhotoDirectoryDB(token.DBConnection);
// If the directory doesn't exist then a directory must have been deleted
if (!Directory.Exists(path))
{
// extract out the name and virtual path from the full physical path
path = path.Substring(token.PhotosRootFullPath.Length,
path.Length - token.PhotosRootFullPath.Length);
string name = path.Substring(path.LastIndexOf(Path.DirectorySeparatorChar) + 1);
string virtualPath = path.Substring(0, path.LastIndexOf(Path.DirectorySeparatorChar));
db.Delete(name, virtualPath);
return(new PhotoDirectories());
}
else
{
// Get a list of directories from the database
PhotoDirectories results = db.GetDirectories(token, GetVirtualPath(token, path));
PhotoDirectories originalResults = (PhotoDirectories)results.Clone();
// Get a list of directories from the root path from the file system
DirectoryInfo dirInfo = new DirectoryInfo(path);
DirectoryInfo[] dirInfos = dirInfo.GetDirectories();
// Only need to update the database if the number of directories in the database are
// different to those on the file system.
// TODO: Currently won't detect changes in directory names. Ideas to enable this
// as still be fast?
if (originalResults.Count != dirInfos.Length)
{
foreach (DirectoryInfo dir in dirInfos)
{
// Ignore thumbnail directories
if (!dir.Name.Equals(ThumbnailUtilities.ThumbnailDirectory))
{
string virtualPath = GetVirtualPath(token, dir.FullName);
// Do we have a PhotoDirectory for this directory already? If not then we need to
// add it to the database
if (!results.Contains(virtualPath))
{
string parentVirtualPath = virtualPath.Substring(0, virtualPath.Length - dir.Name.Length - 1);
PhotoDirectory photoDirectory = new PhotoDirectory(token, dir.Name, parentVirtualPath);
// insert this directory into the database
db.Insert(parent, photoDirectory);
results.Add(photoDirectory);
}
originalResults.Remove(virtualPath);
}
}
// Are there any PhotoDirectory objects in the original result set that aren't in
// the list of directories from the file system? If so, delete 'em
foreach (PhotoDirectory photoDirectory in originalResults)
{
db.Delete(photoDirectory);
PhotoDB photoDB = new PhotoDB(token.DBConnection);
photoDB.DeleteDirectoryPhotos(photoDirectory);
results.Remove(photoDirectory);
}
}
return(results);
}
}
