/// <summary>
/// Connects to database and add file for given object of ATTFile class.
/// </summary>
/// <param name="file">Object of ATTFile class.</param>
public static void AddFile(ATTFile file)
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@PortalId", file.PortalId));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UniqueId", file.UniqueId));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@VersionGuid", file.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@FileName", file.FileName));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Extension", file.Extension));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Size", file.Size));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@ContentType", file.ContentType));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Folder", file.Folder));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@FolderId", file.FolderId));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@IsActive", file.IsActive));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@AddedBy", file.AddedBy));
if (file.StorageLocation == 2)
{
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Content", file.Content));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddDatabaseFile", ParaMeterCollection);
}
else
{
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddFile", ParaMeterCollection);
}
}
public static List <ATTFile> SearchFiles(string SearchQuery)
{
List <ATTFile> lstFiles = new List <ATTFile>();
string StoredProcedureName = "usp_FileManagerSearchFiles";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SearchQuery", SearchQuery));
SqlDataReader SQLReader;
try
{
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName, ParaMeterCollection);
while (SQLReader.Read())
{
ATTFile obj = new ATTFile();
obj.FileId = int.Parse(SQLReader["FileId"].ToString());
obj.FileName = SQLReader["FileName"].ToString();
obj.Folder = SQLReader["Folder"].ToString();
obj.Extension = SQLReader["Extension"].ToString();
obj.Size = int.Parse(SQLReader["Size"].ToString());
obj.AddedOn = SQLReader["AddedOn"].ToString();
obj.Content = SQLReader["Content"] == DBNull.Value ? null : (byte[])SQLReader["Content"];
obj.StorageLocation = int.Parse(SQLReader["StorageLocation"].ToString());
lstFiles.Add(obj);
}
SQLReader.Dispose();
}
catch (Exception e)
{
throw e;
}
return(lstFiles);
}
public static void AddFile(ATTFile file)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalId", file.PortalId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@UniqueId", file.UniqueId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@VersionGuid", file.VersionGuid));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FileName", file.FileName));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Extension", file.Extension));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Size", file.Size));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@ContentType", file.ContentType));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Folder", file.Folder));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FolderId", file.FolderId));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsActive", file.IsActive));
ParaMeterCollection.Add(new KeyValuePair<string, object>("@AddedBy", file.AddedBy));
if (file.StorageLocation == 2)
{
ParaMeterCollection.Add(new KeyValuePair<string, object>("@Content", file.Content));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddDatabaseFile", ParaMeterCollection);
}
else
{
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_FileManagerAddFile", ParaMeterCollection);
}
}
public static void AddFile(ATTFile file)
{
try
{
FileMangerDataProvider.AddFile(file);
}
catch (Exception)
{
throw;
}
}
public static void AddFile(ATTFile file)
{
try
{
FileMangerDataProvider.AddFile(file);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Connects to database and obtains file details for given FileID.
/// </summary>
/// <param name="FileID">FileID</param>
/// <returns>List of ATTFile class containing file details.</returns>
public static ATTFile GetFileDetails(int FileID)
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@FileID", FileID));
SQLHandler sagesql = new SQLHandler();
ATTFile obj = new ATTFile();
obj = sagesql.ExecuteAsObject <ATTFile>("usp_FileManagerGetFileDetails", ParaMeterCollection);
return(obj);
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="file">file</param>
/// <param name="attributeString">attributeString</param>
/// <param name="mode">mode</param>
/// <returns>Return table column for desire class.</returns>
public static string AddInfoSpan(ATTFile file, string attributeString, int mode)
{
string html = "";
switch (mode)
{
case 2:
html = "<td><span class=\"info\">" + file.AddedOn + "||" + file.Size + "bytes" + "</span></span></td>";
break;
default:
html = "<td><span class=\"info\">" + file.AddedOn + "||" + file.Size + "bytes" + "||<span class=\"attr\">" + attributeString + "</span></span></td>";
break;
}
return(html);
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="filePath">filePath</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="permission">permission</param>
/// <param name="extension">extension</param>
/// <returns>Return table column for desire class.</returns>
public static string AddPopupLink(string filePath, int folderId, ATTFile file, string permission, string extension, string secureToken)
{
extension = string.Format("icon-{0}", extension);
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
//if (permission == "edit" || permission == "view")
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
//else
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"#\" rel=" + file.FileName + ">" + file.FileName + "</a></td>");
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
return("<td class='" + extension + "' width='30%'><a href=# class=\"download_link\"><span value=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" id=\"spnEditImage\">" + name + "</a></span></td>");
}
public static string AddDownloadLink(string filePath, int folderId, ATTFile file, string permission)
{
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
if (permission == "edit" || permission == "view")
{
return("<a class=\"download_link\" href=\"" + filePath + "FileID=" + file.FileId + "&FolderID=" + folderId + "\" rel=" + file.FileId + ">" + name + "</a>");
}
else
{
return("<a class=\"download_link\" href=\"#\" rel=" + file.FileId + ">" + file.FileName + "</a>");
}
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="filePath">filePath</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="permission">permission</param>
/// <param name="extension">extension</param>
/// <returns>Return table column for desire class.</returns>
public static string AddDownloadLink(string filePath, int folderId, ATTFile file, string permission, string extension, string secureToken)
{
extension = string.Format("ext_{0}", extension);
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
if (permission == "edit" || permission == "view")
{
return("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
}
else
{
return("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"#\" rel=" + file.FileName + ">" + file.FileName + "</a></td>");
}
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="filePath">filePath</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="permission">permission</param>
/// <param name="extension">extension</param>
/// <returns>Return table column for desire class.</returns>
public static string AddDownloadLink(string filePath, int folderId, ATTFile file, string permission, string extension)
{
extension = string.Format("ext_{0}", extension);
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
if (permission == "edit" || permission == "view")
return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
else
return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"#\" rel=" + file.FileName + ">" + file.FileName + "</a></td>");
}
public static string AddDownloadLink(string filePath, int folderId, ATTFile file, string permission)
{
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
if (permission == "edit" || permission == "view")
return ("<a class=\"download_link\" href=\"" + filePath + "FileID=" + file.FileId + "&FolderID=" + folderId + "\" rel=" + file.FileId + ">" + name + "</a>");
else
return ("<a class=\"download_link\" href=\"#\" rel=" + file.FileId + ">" + file.FileName + "</a>");
}
public static string RecurseThroughDirectory(DirectoryInfo dir, int folderId, int UserModuleID, ref StringBuilder sb)
{
foreach (FileInfo file in dir.GetFiles())
{
ATTFile obj = new ATTFile();
obj.PortalId = fb.GetPortalID;
obj.UniqueId = Guid.NewGuid();
obj.VersionGuid = Guid.NewGuid();
obj.FileName = file.Name;
obj.Extension = file.Extension;
obj.Size = int.Parse(file.Length.ToString());
obj.ContentType = FileManagerHelper.ReturnExtension(file.Extension);
obj.Folder = FileManagerHelper.ReplaceBackSlash(dir.FullName.Replace(HttpContext.Current.Request.PhysicalApplicationPath, ""));
obj.FolderId = folderId;
obj.IsActive = 1;
obj.StorageLocation = 0;
obj.AddedBy = fb.GetUsername;
try
{
if (FileManagerHelper.CheckForValidExtensions(UserModuleID, file.Extension.Replace(".", ""), fb.GetPortalID))
{
FileManagerController.AddFile(obj);
sb.Append("File ").Append("Extraction completed successfully");
}
else
{
sb.Append("File ").Append(file.Name).Append(" has invalid extension \n");
}
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
}
foreach (DirectoryInfo childDir in dir.GetDirectories())
{
Folder folder = new Folder();
folder.PortalId = fb.GetPortalID;
folder.ParentID = folderId;
folder.FolderPath = FileManagerHelper.ReplaceBackSlash(childDir.FullName.Replace(HttpContext.Current.Request.PhysicalApplicationPath, ""));
folder.StorageLocation = 0;
folder.UniqueId = Guid.NewGuid();
folder.VersionGuid = Guid.NewGuid();
folder.IsActive = 1;
folder.IsRoot = false;
folder.AddedBy = fb.GetUsername;
try
{
int FolderID = FileManagerController.AddFolderReturnFolderID(folder);
RecurseThroughDirectory(childDir, FolderID, UserModuleID, ref sb);
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
}
return sb.ToString();
}
public static int GetSearchCount(string SearchQuery, string userName, string FilePath, int portalID, int userModuleID, string secureToken)
{
List<ATTFile> lstFiles = new List<ATTFile>();
AuthenticateService objService = new AuthenticateService();
if (objService.IsPostAuthenticatedView(portalID, userModuleID, userName, secureToken))
{
if (FilePath == "/")
{
FilePath = HttpContext.Current.Server.MapPath("~/");
}
if (Directory.Exists(FilePath))
{
DirectoryInfo dirInfo = new DirectoryInfo(FilePath);
foreach (FileInfo file in dirInfo.GetFiles(SearchQuery + "*"))
{
ATTFile obj = new ATTFile();
obj.FileName = file.Name;
lstFiles.Add(obj);
}
}
}
return lstFiles.Count;
}
public static string GetFileList(string filePath, int folderId, int UserID, int IsSort, int CurrentPage, int PageSize, int portalID, string userName, int userModuleID, string secureToken)
{
StringBuilder sb = new StringBuilder();
AuthenticateService objService = new AuthenticateService();
if (objService.IsPostAuthenticatedView(portalID, userModuleID, userName, secureToken))
{
System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(filePath);
List<ATTFile> lstFiles = new List<ATTFile>();
if (filePath == "/")
{
filePath = HttpContext.Current.Server.MapPath("~/");
}
try
{
if (Directory.Exists(filePath))
{
DirectoryInfo dirInfo = new DirectoryInfo(filePath);
foreach (FileInfo file in dirInfo.GetFiles())
{
ATTFile obj = new ATTFile();
obj.FileName = file.Name;
obj.Folder = file.Directory.ToString();
obj.Size = int.Parse(file.Length.ToString());
obj.Extension = file.Extension;
lstFiles.Add(obj);
}
}
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
if (IsSort == 1)
{
SortList(ref lstFiles);
}
Dictionary<string, string> dictImages = GetImages();
if (lstFiles.Count > 0)
{
lstFiles = lstFiles.GetRange(GetStartRange(CurrentPage, PageSize), GetEndRange(CurrentPage, PageSize, lstFiles.Count));
///Get the dictionary of images used in buttons
sb.Append("<div class='sfGridwrapper'><table width='100%' cellspacing='0' cellpadding='0' class=\"jqueryFileTree\" id=\"fileList\">\n");
if (lstFiles.Count > 0 && HttpContext.Current.Session["SortDir"] == null || (string)HttpContext.Current.Session["SortDir"] == "asc")
{
sb.Append("<tr><th><span class='selectAll'><input type='checkbox' id='chkSelectAll'/></span></th><th><span class='fileName'>FileName <i class='icon-ascending-order' id='imgSort'></i></span></th><th><span class='fileInfo'>FileInfo</span></th><th class='sfEdit'></th><th class='sfEdit'></th><th class='sfEdit'></th></tr>");
}
else if (lstFiles.Count > 0 && (string)HttpContext.Current.Session["SortDir"] == "desc")
{
sb.Append("<tr><th><span class='selectAll'><input type='checkbox' id='chkSelectAll'/></span></th><th><span class='fileName'>FileName <i class='icon-descending-order' id='imgSort' ></i></span></th><th><span class='fileInfo'>FileInfo</span></th><th class='sfEdit'></th><th class='sfEdit'></th><th class='sfEdit'></th></tr>");
}
}
if (lstFiles.Count == 0)
{
sb.Append("<div class='sfEmptyrow'>No Files</div>");
}
string downloadPath = FileManagerHelper.ReplaceBackSlash(Path.Combine(HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority), GetRelativePath("Modules/FileManager/DownloadHandler.ashx?")));
// string urlPath = GetUrlPath(filePath);
string urlPath = GetPreviewUrlPath(filePath);
string absolutePath = FileManagerHelper.ReplaceBackSlash(Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath.ToString(), filePath));
int index = 0;
foreach (ATTFile fi in lstFiles)
{
string ext = "";
bool IsZip = false;
bool IsImg = false;
if (fi.Extension.Length > 1)
ext = fi.Extension.Substring(1).ToLower();
if (ext == "zip")
IsZip = true;
if (ext == "png" || ext == "gif" || ext == "jpg" || ext == "jpeg")
IsImg = true;
string checkId = "chk_" + fi.FileId;
try
{
FileManagerHelper.ConstructHTMLString(IsZip, IsImg, fi.StorageLocation, ext, urlPath + fi.FileName, Path.Combine(absolutePath, fi.FileName), downloadPath, checkId, folderId, fi, ref sb, "edit", dictImages, index);
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
index++;
}
sb.Append("</table></div>");
sb.Append("<div id='divBottomControl'>");
sb.Append("</div>");
}
return sb.ToString();
}
public static string SearchFiles(string SearchQuery, int CurrentPage, int PageSize, string FilePath, int portalID, string userName, int userModuleID, string secureToken)
{
StringBuilder sb = new StringBuilder();
AuthenticateService objService = new AuthenticateService();
if (objService.IsPostAuthenticatedView(portalID, userModuleID, userName, secureToken))
{
if (FilePath == "/")
{
FilePath = HttpContext.Current.Server.MapPath("~/");
}
List<ATTFile> lstFiles = new List<ATTFile>();
if (Directory.Exists(FilePath))
{
DirectoryInfo dirInfo = new DirectoryInfo(FilePath);
foreach (FileInfo file in dirInfo.GetFiles(SearchQuery + "*"))
{
ATTFile obj = new ATTFile();
obj.FileName = file.Name;
obj.Folder = file.Directory.ToString();
obj.Size = int.Parse(file.Length.ToString());
obj.Extension = file.Extension;
lstFiles.Add(obj);
}
}
Dictionary<string, string> dictImages = GetImages();
List<string> lstPermissions = FileManagerController.GetModulePermission(userModuleID, userName);
int UserPermissionKey = lstPermissions.Contains("EDIT") ? 1 : 0;
if (lstFiles.Count > 0)
lstFiles = lstFiles.GetRange(GetStartRange(CurrentPage, PageSize), GetEndRange(CurrentPage, PageSize, lstFiles.Count));
sb.Append("<div class='sfGridwrapper'><table width='100%' cellspacing='0' cellpadding='0' class=\"jqueryFileTree\" id=\"fileList\">\n");
if (lstFiles.Count > 0)
{
sb.Append("<tr><th><span class='selectAll'><input type='checkbox' id='chkSelectAll'/></span></th><th><span class='fileName'>FileName<img src=" + dictImages["Sort"].ToString() + "></span></th><th><span class='fileInfo'>FileInfo</span></th><th class='sfEdit'></th><th class='sfEdit'></th><th class='sfEdit'></th></tr>");
}
if (lstFiles.Count == 0)
{
sb.Append("<div class='sfEmptyrow'>No Files</div>");
}
string downloadPath = FileManagerHelper.ReplaceBackSlash(Path.Combine(HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority), GetRelativePath("Modules/FileManager/DownloadHandler.ashx?")));
if (UserPermissionKey == 1)
{
int index = 0;
foreach (ATTFile fi in lstFiles)
{
string ext = "";
//bool IsZip = false;
bool IsImg = false;
if (fi.Extension.Length > 1)
ext = fi.Extension.Substring(1).ToLower();
// if (ext == "zip")
// IsZip = true;
if (ext == "png" || ext == "gif" || ext == "jpg" || ext == "jpeg")
IsImg = true;
string checkId = "chk_" + fi.FileId;
try
{
FileManagerHelper.ConstructHTMLString(false, IsImg, fi.StorageLocation, ext, Path.Combine(GetUrlPath(fi.Folder), fi.FileName), Path.Combine(GetAbsolutePath(fi.Folder), fi.FileName), downloadPath, checkId, 0, fi, ref sb, "edit", dictImages, index);
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
index++;
}
}
else
{
int index = 0;
foreach (ATTFile fi in lstFiles)
{
string ext = "";
// bool IsZip = false;
bool IsImg = false;
if (fi.Extension.Length > 1)
ext = fi.Extension.Substring(1).ToLower();
//if (ext == "zip")
// IsZip = true;
if (ext == "png" || ext == "gif" || ext == "jpg" || ext == "jpeg")
IsImg = true;
string checkId = "chk_" + fi.FileId;
try
{
FileManagerHelper.ConstructHTMLString(false, IsImg, fi.StorageLocation, ext, Path.Combine(GetUrlPath(fi.Folder), fi.FileName), Path.Combine(GetAbsolutePath(fi.Folder), fi.FileName), downloadPath, checkId, 0, fi, ref sb, "view", dictImages, index);
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
index++;
}
}
sb.Append("</table>");
sb.Append("<div id='divPagerNav'></div>");
sb.Append("</div>");
}
return sb.ToString();
}
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 void AddFileToDatabase(string fileName, string extension, string folder, int folderId,bool isDatabase,int saveMode)
{
string newFileName = fileName;
if (saveMode == 1)
{
newFileName = fileName + ".resources";
}
FileInfo file = new FileInfo(GetAbsolutePath(folder+newFileName));
ATTFile obj = new ATTFile();
obj.PortalId = fb.GetPortalID;
obj.UniqueId = Guid.NewGuid();
obj.VersionGuid = Guid.NewGuid();
obj.FileName = fileName;
obj.Extension = extension;
obj.Size = int.Parse(file.Length.ToString());
obj.ContentType = FileManagerHelper.ReturnExtension(extension);
obj.Folder = folder;
obj.FolderId = folderId;
obj.IsActive = 1;
obj.StorageLocation = saveMode;
obj.AddedBy = fb.GetUsername;
if(isDatabase)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(GetAbsolutePath(folder+fileName));
obj.Content = _fileContent;
}
try
{
FileManagerController.AddFile(obj);
if (saveMode == 2)
{
file.Delete();
}
}
catch (Exception ex)
{
fb.ProcessException(ex);
}
}
/// <summary>
/// Creates a html string to be rendered based upon the dynamic conditions
/// </summary>
/// <param name="IsZip">IsZip</param>
/// <param name="IsImg">IsImg</param>
/// <param name="StorageLocation">StorageLocation</param>
/// <param name="ext">ext</param>
/// <param name="urlPath">urlPath</param>
/// <param name="absolutePath">absolutePath</param>
/// <param name="downloadPath">downloadPath</param>
/// <param name="checkId">checkId</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="sb">sb</param>
/// <param name="permission">permission</param>
/// <param name="dictImages">dictImages</param>
public static void ConstructHTMLString(bool IsZip, bool IsImg, int StorageLocation, string ext, string urlPath, string absolutePath, string downloadPath, string checkId, int folderId, ATTFile file, ref StringBuilder sb, string permission, Dictionary <string, string> dictImages, int index, string secureToken)
{
switch (StorageLocation)
{
case 0:
string attStr = FileManagerHelper.GetAttributeString(absolutePath);
if (IsZip)
{
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext, secureToken));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddExtractButton(Path.Combine(file.Folder, file.FileName), dictImages["Extract"].ToString(), permission));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
else
{
if (IsImg)
{
string imgpath = urlPath + file.Folder;
imgpath = Path.Combine(imgpath, file.FileName);
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
//sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddPopupLink(downloadPath, folderId, file, permission, ext, secureToken));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddPreviewButton(urlPath, dictImages["Preview"].ToString()));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
else
{
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
//sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddPopupLink(downloadPath, folderId, file, permission, ext, secureToken));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddBlankSpan());
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
}
break;
case 1:
string attStr1 = FileManagerHelper.GetAttributeString(absolutePath + ".resources");
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext, secureToken));
sb.Append(AddInfoSpan(file, attStr1, StorageLocation));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append(AddBlankSpan());
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append("</tr>");
break;
case 2:
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext, secureToken));
sb.Append(AddInfoSpan(file, "", StorageLocation));
sb.Append(AddBlankSpan());
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append("</li>");
break;
}
}
/// <summary>
/// Copy or Move the file to the fullToPath location
/// </summary>
/// <param name="filePath"></param>
/// <param name="fileId"></param>
/// <param name="toFolderId"></param>
/// <param name="toPath"></param>
/// <param name="action"></param>
/// <param name="mode"></param>
/// <param name="fullFilePath"></param>
/// <param name="fullFromPath"></param>
/// <param name="fullToPath"></param>
public static void TransferFile(string filePath, int fileId, int toFolderId, string toPath, int action, int mode, string fullFilePath, string fullFromPath, string fullToPath)
{
switch (mode)
{
case 1:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
string fileNameCopy = fileCopy.Name;
if (!File.Exists(Path.Combine(fullToPath, fileNameCopy)))
{
try
{
fileCopy.CopyTo(Path.Combine(fullToPath, fileNameCopy));
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(fullToPath + fileNameMove);
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 2:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
string fileNameCopy = fileCopy.Name;
/// Checking if file exists
if (!File.Exists(fullToPath + fileNameCopy + ".resources"))
{
try
{
fileCopy.CopyTo(fullToPath + fileNameCopy + ".resources");
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
string fileName = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(fullToPath + fileName + ".resources");
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 3:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
ATTFile objCopy = new ATTFile();
objCopy.FileName = fileCopy.Name;
objCopy.Folder = toPath;
objCopy.FolderId = toFolderId;
objCopy.AddedBy = "superuser";
objCopy.Extension = fileCopy.Extension;
objCopy.PortalId = 1;
objCopy.UniqueId = Guid.NewGuid();
objCopy.VersionGuid = Guid.NewGuid();
objCopy.Size = int.Parse(fileCopy.Length.ToString());
objCopy.ContentType = FileManagerHelper.ReturnExtension(fileCopy.Extension);
objCopy.IsActive = 1;
objCopy.StorageLocation = 2;
if (fileCopy.Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
objCopy.Content = _fileContent;
try
{
FileManagerController.AddFile(objCopy);
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
ATTFile objMove = new ATTFile();
objMove.FileName = fileMove.Name;
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
objMove.Extension = fileMove.Extension;
objMove.PortalId = 1;
objMove.UniqueId = Guid.NewGuid();
objMove.VersionGuid = Guid.NewGuid();
objMove.Size = int.Parse(fileMove.Length.ToString());
objMove.ContentType = FileManagerHelper.ReturnExtension(fileMove.Extension);
objMove.IsActive = 1;
objMove.StorageLocation = 2;
if (fileMove.Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
objMove.Content = _fileContent;
try
{
FileManagerController.AddFile(objMove);
fileMove.Delete();
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 4:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileNameCopy = "";
fileNameCopy = fileCopy.Name;
if (!File.Exists(Path.Combine(fullToPath, fileNameCopy.Replace(".resources", ""))))
{
try
{
fileCopy.CopyTo(Path.Combine(fullToPath, fileNameCopy.Replace(".resources", "")));
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath + ".resources");
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(Path.Combine(fullToPath, fileNameMove.Replace(".resources", "")));
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 5:
switch (action)
{
case 1:
FileInfo file11 = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileName11 = "";
fileName11 = filePath.Substring(filePath.LastIndexOf('/') + 1, filePath.Length - 1 - filePath.LastIndexOf('/'));
if (!File.Exists(fullToPath + fileName11 + ".resources"))
{
try
{
file11.CopyTo(fullToPath + fileName11 + ".resources");
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(Path.Combine(fullFilePath, fileNameMove + ".resources"));
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 6:
switch (action)
{
case 1:
FileInfo file12 = new FileInfo(fullFilePath + ".resources");
ATTFile obj12 = new ATTFile();
obj12.FileName = RemoveResourceExtension(file12.Name);
obj12.Folder = toPath;
obj12.FolderId = toFolderId;
obj12.AddedBy = "superuser";
obj12.Extension = file12.Extension;
obj12.PortalId = 1;
obj12.UniqueId = Guid.NewGuid();
obj12.VersionGuid = Guid.NewGuid();
obj12.Size = int.Parse(file12.Length.ToString());
obj12.ContentType = FileManagerHelper.ReturnExtension(file12.Extension);
obj12.IsActive = 1;
obj12.StorageLocation = 2;
if (new FileInfo(fullFilePath + ".resources").Exists)
{
File.Move(fullFilePath + ".resources", fullFilePath);
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
obj12.Content = _fileContent;
try
{
FileManagerController.AddFile(obj12);
File.Move(fullFilePath, fullFilePath + ".resources");
}
catch (Exception)
{
if (File.Exists(fullFilePath))
{
File.Move(fullFilePath, fullFilePath + ".resources");
}
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath + ".resources");
ATTFile objMove = new ATTFile();
objMove.FileName = RemoveResourceExtension(fileMove.Name);
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
objMove.Extension = fileMove.Extension;
objMove.PortalId = 1;
objMove.UniqueId = Guid.NewGuid();
objMove.VersionGuid = Guid.NewGuid();
objMove.Size = int.Parse(new FileInfo(fullFilePath + ".resources").Length.ToString());
objMove.ContentType = FileManagerHelper.ReturnExtension(fileMove.Extension);
objMove.IsActive = 1;
objMove.StorageLocation = 2;
if (new FileInfo(fullFilePath + ".resources").Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath + ".resources");
objMove.Content = _fileContent;
try
{
FileManagerController.AddFile(objMove);
File.Delete(fullFilePath + ".resources");
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 7:
switch (action)
{
case 1:
ATTFile obj20 = new ATTFile();
obj20 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj20.FileName);
if (!File.Exists(newFilePath))
{
FileManagerHelper.WriteBinaryFile(newFilePath, obj20.Content);
FileInfo file20 = new FileInfo(newFilePath);
ATTFile obj20New = new ATTFile(file20.Name, toPath, toFolderId, "superuser",
file20.Extension, 1, Guid.NewGuid(), Guid.NewGuid(),
int.Parse(file20.Length.ToString()),
FileManagerHelper.ReturnExtension(file20.Extension), 1, 0);
FileManagerController.AddFile(obj20New);
}
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileManagerHelper.WriteBinaryFile(newFilePath, objMove.Content);
FileInfo file20 = new FileInfo(newFilePath);
ATTFile obj20New = new ATTFile(file20.Name, toPath, toFolderId, "superuser", file20.Extension, 1, Guid.NewGuid(), Guid.NewGuid(), int.Parse(file20.Length.ToString()), FileManagerHelper.ReturnExtension(file20.Extension), 1, 0);
FileManagerController.AddFile(obj20New);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
case 8:
switch (action)
{
case 1:
ATTFile obj21 = new ATTFile();
obj21 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj21.FileName);
if (!File.Exists(newFilePath + ".resources"))
{
FileManagerHelper.WriteBinaryFile(newFilePath + ".resources", obj21.Content);
FileInfo file21 = new FileInfo(newFilePath + ".resources");
ATTFile obj21New = new ATTFile(file21.Name, toPath, toFolderId, "superuser",
file21.Extension, 1, Guid.NewGuid(), Guid.NewGuid(),
int.Parse(file21.Length.ToString()),
FileManagerHelper.ReturnExtension(file21.Extension), 1, 1);
FileManagerController.AddFile(obj21New);
}
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileManagerHelper.WriteBinaryFile(newFilePath + ".resources", objMove.Content);
FileInfo file21 = new FileInfo(newFilePath + ".resources");
ATTFile obj21New = new ATTFile(file21.Name.Replace(".resources", ""), toPath, toFolderId, "superuser", file21.Extension, 1, Guid.NewGuid(), Guid.NewGuid(), int.Parse(file21.Length.ToString()), FileManagerHelper.ReturnExtension(file21.Extension), 1, 1);
FileManagerController.AddFile(obj21New);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
case 9:
switch (action)
{
case 1:
ATTFile obj22 = new ATTFile();
obj22 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj22.FileName);
FileInfo file22 = new FileInfo(newFilePath);
obj22.Folder = toPath;
obj22.FolderId = toFolderId;
obj22.AddedBy = "superuser";
FileManagerController.AddFile(obj22);
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileInfo fileMove = new FileInfo(newFilePath);
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
FileManagerController.AddFile(objMove);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
}
}
/// <summary>
/// Copy or Move the file to the fullToPath location
/// </summary>
/// <param name="filePath"></param>
/// <param name="fileId"></param>
/// <param name="toFolderId"></param>
/// <param name="toPath"></param>
/// <param name="action"></param>
/// <param name="mode"></param>
/// <param name="fullFilePath"></param>
/// <param name="fullFromPath"></param>
/// <param name="fullToPath"></param>
public static void TransferFile(string filePath, int fileId, int toFolderId, string toPath, int action, int mode,string fullFilePath,string fullFromPath,string fullToPath)
{
switch (mode)
{
case 1:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
string fileNameCopy = fileCopy.Name;
if (!File.Exists(Path.Combine(fullToPath, fileNameCopy)))
{
try
{
fileCopy.CopyTo(Path.Combine(fullToPath, fileNameCopy));
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(fullToPath + fileNameMove);
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 2:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
string fileNameCopy = fileCopy.Name;
/// Checking if file exists
if (!File.Exists(fullToPath + fileNameCopy + ".resources"))
{
try
{
fileCopy.CopyTo(fullToPath + fileNameCopy+".resources");
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
string fileName = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(fullToPath + fileName+".resources");
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 3:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath);
ATTFile objCopy = new ATTFile();
objCopy.FileName = fileCopy.Name;
objCopy.Folder = toPath;
objCopy.FolderId = toFolderId;
objCopy.AddedBy = "superuser";
objCopy.Extension = fileCopy.Extension;
objCopy.PortalId = 1;
objCopy.UniqueId = Guid.NewGuid();
objCopy.VersionGuid = Guid.NewGuid();
objCopy.Size = int.Parse(fileCopy.Length.ToString());
objCopy.ContentType = FileManagerHelper.ReturnExtension(fileCopy.Extension);
objCopy.IsActive = 1;
objCopy.StorageLocation = 2;
if (fileCopy.Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
objCopy.Content = _fileContent;
try
{
FileManagerController.AddFile(objCopy);
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath);
ATTFile objMove = new ATTFile();
objMove.FileName = fileMove.Name;
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
objMove.Extension = fileMove.Extension;
objMove.PortalId = 1;
objMove.UniqueId = Guid.NewGuid();
objMove.VersionGuid = Guid.NewGuid();
objMove.Size = int.Parse(fileMove.Length.ToString());
objMove.ContentType = FileManagerHelper.ReturnExtension(fileMove.Extension);
objMove.IsActive = 1;
objMove.StorageLocation = 2;
if (fileMove.Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
objMove.Content = _fileContent;
try
{
FileManagerController.AddFile(objMove);
fileMove.Delete();
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 4:
switch (action)
{
case 1:
FileInfo fileCopy = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileNameCopy = "";
fileNameCopy = fileCopy.Name;
if (!File.Exists(Path.Combine(fullToPath, fileNameCopy.Replace(".resources", ""))))
{
try
{
fileCopy.CopyTo(Path.Combine(fullToPath,fileNameCopy.Replace(".resources","")));
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath + ".resources");
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(Path.Combine(fullToPath,fileNameMove.Replace(".resources","")));
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 5:
switch (action)
{
case 1:
FileInfo file11 = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileName11 = "";
fileName11 = filePath.Substring(filePath.LastIndexOf('/') + 1, filePath.Length - 1 - filePath.LastIndexOf('/'));
if (!File.Exists(fullToPath + fileName11 + ".resources"))
{
try
{
file11.CopyTo(fullToPath + fileName11 + ".resources");
FileManagerController.CopyFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath + ".resources");
/// Checking if file exists
string fileNameMove = fileMove.Name;
if (fileMove.Exists)
{
try
{
fileMove.MoveTo(Path.Combine(fullFilePath ,fileNameMove + ".resources"));
FileManagerController.MoveFile(fileId, toFolderId, toPath, Guid.NewGuid(), Guid.NewGuid());
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 6:
switch (action)
{
case 1:
FileInfo file12 = new FileInfo(fullFilePath+".resources");
ATTFile obj12 = new ATTFile();
obj12.FileName = RemoveResourceExtension(file12.Name);
obj12.Folder = toPath;
obj12.FolderId = toFolderId;
obj12.AddedBy = "superuser";
obj12.Extension = file12.Extension;
obj12.PortalId = 1;
obj12.UniqueId = Guid.NewGuid();
obj12.VersionGuid = Guid.NewGuid();
obj12.Size = int.Parse(file12.Length.ToString());
obj12.ContentType = FileManagerHelper.ReturnExtension(file12.Extension);
obj12.IsActive = 1;
obj12.StorageLocation = 2;
if (new FileInfo(fullFilePath + ".resources").Exists)
{
File.Move(fullFilePath + ".resources", fullFilePath);
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath);
obj12.Content = _fileContent;
try
{
FileManagerController.AddFile(obj12);
File.Move(fullFilePath, fullFilePath + ".resources");
}
catch (Exception)
{
if (File.Exists(fullFilePath))
{
File.Move(fullFilePath, fullFilePath + ".resources");
}
throw;
}
}
break;
case 2:
FileInfo fileMove = new FileInfo(fullFilePath+".resources");
ATTFile objMove = new ATTFile();
objMove.FileName = RemoveResourceExtension(fileMove.Name);
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
objMove.Extension = fileMove.Extension;
objMove.PortalId = 1;
objMove.UniqueId = Guid.NewGuid();
objMove.VersionGuid = Guid.NewGuid();
objMove.Size = int.Parse(new FileInfo(fullFilePath + ".resources").Length.ToString());
objMove.ContentType = FileManagerHelper.ReturnExtension(fileMove.Extension);
objMove.IsActive = 1;
objMove.StorageLocation = 2;
if (new FileInfo(fullFilePath + ".resources").Exists)
{
byte[] _fileContent = FileManagerHelper.FileToByteArray(fullFilePath+".resources");
objMove.Content = _fileContent;
try
{
FileManagerController.AddFile(objMove);
File.Delete(fullFilePath + ".resources");
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
}
break;
}
break;
case 7:
switch (action)
{
case 1:
ATTFile obj20 = new ATTFile();
obj20 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj20.FileName);
if (!File.Exists(newFilePath))
{
FileManagerHelper.WriteBinaryFile(newFilePath, obj20.Content);
FileInfo file20 = new FileInfo(newFilePath);
ATTFile obj20New = new ATTFile(file20.Name, toPath, toFolderId, "superuser",
file20.Extension, 1, Guid.NewGuid(), Guid.NewGuid(),
int.Parse(file20.Length.ToString()),
FileManagerHelper.ReturnExtension(file20.Extension), 1, 0);
FileManagerController.AddFile(obj20New);
}
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileManagerHelper.WriteBinaryFile(newFilePath, objMove.Content);
FileInfo file20 = new FileInfo(newFilePath);
ATTFile obj20New = new ATTFile(file20.Name, toPath, toFolderId, "superuser", file20.Extension, 1, Guid.NewGuid(), Guid.NewGuid(), int.Parse(file20.Length.ToString()), FileManagerHelper.ReturnExtension(file20.Extension), 1, 0);
FileManagerController.AddFile(obj20New);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
case 8:
switch (action)
{
case 1:
ATTFile obj21 = new ATTFile();
obj21 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj21.FileName);
if (!File.Exists(newFilePath + ".resources"))
{
FileManagerHelper.WriteBinaryFile(newFilePath + ".resources", obj21.Content);
FileInfo file21 = new FileInfo(newFilePath + ".resources");
ATTFile obj21New = new ATTFile(file21.Name, toPath, toFolderId, "superuser",
file21.Extension, 1, Guid.NewGuid(), Guid.NewGuid(),
int.Parse(file21.Length.ToString()),
FileManagerHelper.ReturnExtension(file21.Extension), 1, 1);
FileManagerController.AddFile(obj21New);
}
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileManagerHelper.WriteBinaryFile(newFilePath + ".resources", objMove.Content);
FileInfo file21 = new FileInfo(newFilePath + ".resources");
ATTFile obj21New = new ATTFile(file21.Name.Replace(".resources",""), toPath, toFolderId, "superuser", file21.Extension, 1, Guid.NewGuid(), Guid.NewGuid(), int.Parse(file21.Length.ToString()), FileManagerHelper.ReturnExtension(file21.Extension), 1, 1);
FileManagerController.AddFile(obj21New);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
case 9:
switch (action)
{
case 1:
ATTFile obj22 = new ATTFile();
obj22 = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, obj22.FileName);
FileInfo file22 = new FileInfo(newFilePath);
obj22.Folder = toPath;
obj22.FolderId = toFolderId;
obj22.AddedBy = "superuser";
FileManagerController.AddFile(obj22);
}
catch (Exception)
{
throw;
}
break;
case 2:
ATTFile objMove = new ATTFile();
objMove = FileManagerController.GetFileDetails(fileId);
try
{
string newFilePath = Path.Combine(fullToPath, objMove.FileName);
FileInfo fileMove = new FileInfo(newFilePath);
objMove.Folder = toPath;
objMove.FolderId = toFolderId;
objMove.AddedBy = "superuser";
FileManagerController.AddFile(objMove);
FileManagerController.DeleteFileFolder(0, fileId);
}
catch (Exception)
{
throw;
}
break;
}
break;
}
}
public static List<ATTFile> SearchFiles(string SearchQuery)
{
List<ATTFile> lstFiles = new List<ATTFile>();
string StoredProcedureName = "usp_FileManagerSearchFiles";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@SearchQuery", SearchQuery));
SqlDataReader SQLReader;
try
{
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName, ParaMeterCollection);
while (SQLReader.Read())
{
ATTFile obj = new ATTFile();
obj.FileId = int.Parse(SQLReader["FileId"].ToString());
obj.FileName = SQLReader["FileName"].ToString();
obj.Folder = SQLReader["Folder"].ToString();
obj.Extension = SQLReader["Extension"].ToString();
obj.Size = int.Parse(SQLReader["Size"].ToString());
obj.AddedOn = SQLReader["AddedOn"].ToString();
obj.Content = SQLReader["Content"] == DBNull.Value ? null : (byte[])SQLReader["Content"];
obj.StorageLocation = int.Parse(SQLReader["StorageLocation"].ToString());
lstFiles.Add(obj);
}
SQLReader.Dispose();
}
catch (Exception e)
{
throw e;
}
return lstFiles;
}
/// <summary>
/// Creates a html string to be rendered based upon the dynamic conditions
/// </summary>
/// <param name="IsZip">IsZip</param>
/// <param name="IsImg">IsImg</param>
/// <param name="StorageLocation">StorageLocation</param>
/// <param name="ext">ext</param>
/// <param name="urlPath">urlPath</param>
/// <param name="absolutePath">absolutePath</param>
/// <param name="downloadPath">downloadPath</param>
/// <param name="checkId">checkId</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="sb">sb</param>
/// <param name="permission">permission</param>
/// <param name="dictImages">dictImages</param>
public static void ConstructHTMLString(bool IsZip, bool IsImg, int StorageLocation, string ext, string urlPath, string absolutePath, string downloadPath, string checkId, int folderId, ATTFile file, ref StringBuilder sb, string permission, Dictionary<string, string> dictImages, int index)
{
switch (StorageLocation)
{
case 0:
string attStr = FileManagerHelper.GetAttributeString(absolutePath);
if (IsZip)
{
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddExtractButton(Path.Combine(file.Folder, file.FileName), dictImages["Extract"].ToString(), permission));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
else
{
if (IsImg)
{
string imgpath = urlPath + file.Folder;
imgpath = Path.Combine(imgpath, file.FileName);
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
//sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddPopupLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddPreviewButton(urlPath, dictImages["Preview"].ToString()));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
else
{
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
//sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddPopupLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddInfoSpan(file, attStr, StorageLocation));
sb.Append(AddBlankSpan());
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append("</tr>");
}
}
break;
case 1:
string attStr1 = FileManagerHelper.GetAttributeString(absolutePath + ".resources");
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddInfoSpan(file, attStr1, StorageLocation));
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append(AddBlankSpan());
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append("</tr>");
break;
case 2:
sb.Append(AddExtension(ext, index));
sb.Append(AddCheckBox(checkId));
sb.Append(AddDownloadLink(downloadPath, folderId, file, permission, ext));
sb.Append(AddInfoSpan(file, "", StorageLocation));
sb.Append(AddBlankSpan());
sb.Append(AddDeleteButton(Path.Combine(file.Folder, file.FileName), dictImages["Delete"].ToString(), permission));
sb.Append(AddEditButton(Path.Combine(file.Folder, file.FileName), dictImages["Edit"].ToString(), permission));
sb.Append("</li>");
break;
}
}
public static int GetSearchCount(string SearchQuery, int UserModuleID, string UserName, string FilePath)
{
if (FilePath == "/")
{
FilePath = HttpContext.Current.Server.MapPath("~/");
}
List<ATTFile> lstFiles = new List<ATTFile>();
if (Directory.Exists(FilePath))
{
DirectoryInfo dirInfo = new DirectoryInfo(FilePath);
foreach (FileInfo file in dirInfo.GetFiles(SearchQuery + "*"))
{
ATTFile obj = new ATTFile();
obj.FileName = file.Name;
lstFiles.Add(obj);
}
}
return lstFiles.Count;
}
public static ATTFile GetFileDetails(int FileID)
{
List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
ParaMeterCollection.Add(new KeyValuePair<string, object>("@FileID", FileID));
SQLHandler sagesql = new SQLHandler();
ATTFile obj = new ATTFile();
obj = sagesql.ExecuteAsObject<ATTFile>("usp_FileManagerGetFileDetails", ParaMeterCollection);
return obj;
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="filePath">filePath</param>
/// <param name="folderId">folderId</param>
/// <param name="file">file</param>
/// <param name="permission">permission</param>
/// <param name="extension">extension</param>
/// <returns>Return table column for desire class.</returns>
public static string AddPopupLink(string filePath, int folderId, ATTFile file, string permission, string extension)
{
extension = string.Format("icon-{0}", extension);
string name = file.FileName;
if (file.FileName.Length > 40)
{
name = file.FileName.Substring(0, 40) + "...";
}
//if (permission == "edit" || permission == "view")
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
//else
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"#\" rel=" + file.FileName + ">" + file.FileName + "</a></td>");
// return ("<td class='" + extension + "' width='30%'><a class=\"download_link\" href=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" rel=" + file.FileName + ">" + name + "</a></td>");
return ("<td class='" + extension + "' width='30%'><a href=# class=\"download_link\"><span value=\"" + filePath + "FileName=" + file.FileName + "&FolderName=" + file.Folder + "\" id=\"spnEditImage\">" + name + "</a></span></td>");
}
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);
}
}
/// <summary>
/// Return table column for desire class.
/// </summary>
/// <param name="file">file</param>
/// <param name="attributeString">attributeString</param>
/// <param name="mode">mode</param>
/// <returns>Return table column for desire class.</returns>
public static string AddInfoSpan(ATTFile file, string attributeString, int mode)
{
string html = "";
switch (mode)
{
case 2:
html = "<td><span class=\"info\">" + file.AddedOn + "||" + file.Size + "bytes" + "</span></span></td>";
break;
default:
html = "<td><span class=\"info\">" + file.AddedOn + "||" + file.Size + "bytes" + "||<span class=\"attr\">" + attributeString + "</span></span></td>";
break;
}
return html;
}
