public static void AddFolder(Folder folder)
{
try
{
FileMangerDataProvider.AddFolder(folder);
}
catch (Exception)
{
throw;
}
}
public static void AddRootFolder(Folder folder)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", folder.PortalId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderPath", folder.FolderPath));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StorageLocation", folder.StorageLocation));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", folder.UniqueId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", folder.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", folder.IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", folder.AddedBy));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddRootFolder", ParaMeterCollection);
}
public static int AddFolderReturnFolderID(Folder folder)
{
try
{
return (FileMangerDataProvider.AddFolderReturnFolderID(folder));
}
catch (Exception)
{
throw;
}
}
public static int AddFolderReturnFolderID(Folder folder)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", folder.PortalId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ParentFolderID", folder.ParentID));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderPath", folder.FolderPath));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@StorageLocation", folder.StorageLocation));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", folder.UniqueId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", folder.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", folder.IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", folder.AddedBy));
SQLHandler sagesql = new SQLHandler();
int FolderID = sagesql.ExecuteNonQueryAsGivenType<int>("[usp_FileManagerAddFolderRetFolderID]", ParaMeterCollection, "@FolderID");
return FolderID;
}
public static void RecurseThroughDirectory(DirectoryInfo di,int folderId,int folderType)
{
FileInfo[] files = di.GetFiles();
foreach (FileInfo fi in files)
{
List<ATTFile> lstFile = FileManagerController.GetFiles(folderId);
bool exists = false;
int size = int.Parse(fi.Length.ToString());
if(Path.GetExtension(fi.Name)==".resources")
{
exists= lstFile.Exists(
delegate(ATTFile obj)
{
return (obj.FileName == Path.GetFileNameWithoutExtension(fi.Name) && obj.FolderId == folderId);
}
);
}
else
{
exists = lstFile.Exists(
delegate(ATTFile obj)
{
return (obj.FileName == fi.Name && obj.FolderId == folderId);
}
);
}
if(!exists)
{
//Add file to database
if (folderType == 1)
{
File.Move(fi.FullName,fi.FullName+".resources");
ATTFile fileObj = new ATTFile(fi.Name, FileManagerHelper.ReplaceBackSlash(GetFolderPath(di.FullName.Replace(absolutePath, ""))), folderId, UserName, Path.GetExtension(fi.Name.Replace(".resources", "")), PortalID, Guid.NewGuid(), Guid.NewGuid(),size, FileManagerHelper.ReturnExtension(Path.GetExtension(fi.Name.Replace(".resources", ""))), 1,folderType);
FileManagerController.AddFile(fileObj);
}
else
{ if(IsExtensionValid(Path.GetExtension(fi.Name)))
{
ATTFile fileObj = new ATTFile(fi.Name, FileManagerHelper.ReplaceBackSlash(GetFolderPath(di.FullName.Replace(absolutePath, ""))), folderId, UserName, Path.GetExtension(fi.Name), PortalID, Guid.NewGuid(), Guid.NewGuid(), int.Parse(fi.Length.ToString()), FileManagerHelper.ReturnExtension(Path.GetExtension(fi.Name)), 1, 0);
FileManagerController.AddFile(fileObj);
}
}
}
}
foreach (DirectoryInfo di_child in di.GetDirectories())
{
int newFolderId = 0;
int storageLocation = 0;
int index = lstFolders.FindIndex(
delegate (Folder obj)
{
return (obj.FolderPath == GetFolderPath(di_child.FullName));
}
);
if(index==-1)
{
//Add folder to the database and get the folderId into newFolderId
Folder folder = new Folder();
folder.PortalId = PortalID;
folder.FolderPath = FileManagerHelper.ReplaceBackSlash(GetFolderPath(di_child.FullName));
folder.StorageLocation = storageLocation;
folder.UniqueId = Guid.NewGuid();
folder.VersionGuid = Guid.NewGuid();
folder.IsActive = 1;
folder.AddedBy = UserName;
folder.IsRoot = false;
newFolderId = FileManagerController.AddFolderReturnFolderID(folder);
}
else if(index>-1)
{
newFolderId = lstFolders[index].FolderId;
storageLocation = lstFolders[index].StorageLocation;
}
RecurseThroughDirectory(di_child,newFolderId,storageLocation);
}
}
public static List<Folder> GetFolders()
{
List<Folder> lstFolders = new List<Folder>();
string StoredProcedureName = "usp_FileManagerGetFolders";
SqlDataReader SQLReader;
SQLHandler sagesql = new SQLHandler();
try
{
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName);
while (SQLReader.Read())
{
Folder obj = new Folder();
obj.FolderId = int.Parse(SQLReader["FolderId"].ToString());
obj.FolderPath = SQLReader["FolderPath"].ToString();
obj.StorageLocation = int.Parse(SQLReader["StorageLocation"].ToString());
lstFolders.Add(obj);
}
SQLReader.Dispose();
}
catch (Exception e)
{
throw e;
}
return lstFolders;
}
/// <summary>
/// Connects to database and obtains active root folders.
/// </summary>
/// <returns>List of Folder class containing FolderId,FolderPath,StorageLocation and IsActive.</returns>
public static List<Folder> GetActiveRootFolders()
{
List<Folder> lstFolders = new List<Folder>();
string StoredProcedureName = "usp_FileManagerGetActiveRootFolders";
SqlDataReader SQLReader = null;
try
{
SQLHandler sagesql = new SQLHandler();
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName);
while (SQLReader.Read())
{
Folder obj = new Folder();
obj.FolderId = int.Parse(SQLReader["FolderId"].ToString());
obj.FolderPath = SQLReader["FolderPath"].ToString();
obj.StorageLocation = int.Parse(SQLReader["StorageLocation"].ToString());
obj.IsEnabled = bool.Parse(SQLReader["IsActive"].ToString());
lstFolders.Add(obj);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (SQLReader != null)
{
SQLReader.Close();
}
}
return lstFolders;
}
protected void AddRootFolder(string path)
{
Folder folder = new Folder();
folder.PortalId = GetPortalID;
folder.FolderPath = path.Replace(BaseDir + "/", "");
folder.StorageLocation = 0;
folder.UniqueId = Guid.NewGuid();
folder.VersionGuid = Guid.NewGuid();
folder.IsActive = 1;
folder.AddedBy = GetUsername;
try
{
FileManagerController.AddRootFolder(folder);
CacheHelper.Clear("FileManagerRootFolders");
CacheHelper.Clear("FileManagerFolders");
GetRootFolders();
}
catch (Exception)
{
throw;
}
}
