public static DataTable GetFoldersAndFiles(int moduleId, int parentId)
{
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("filename", typeof(string));
dt.Columns.Add("OriginalFileName", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("size", typeof(int));
dt.Columns.Add("type", typeof(string));
dt.Columns.Add("DownloadCount", typeof(string));
dt.Columns.Add("modified", typeof(DateTime));
dt.Columns.Add("username", typeof(string));
DataRow dr;
using (IDataReader reader = GetSharedFolders(moduleId, parentId))
{
while (reader.Read())
{
dr = dt.NewRow();
dr["ID"] = reader["FolderID"].ToString() + "~folder";
dr["filename"] = reader["FolderName"];
dr["OriginalFileName"] = string.Empty;
dr["Description"] = string.Empty;
dr["size"] = reader["SizeInKB"].ToString();
dr["type"] = "0";
dr["DownloadCount"] = string.Empty;
dt.Rows.Add(dr);
}
}
using (IDataReader reader = SharedFile.GetSharedFiles(moduleId, parentId))
{
while (reader.Read())
{
dr = dt.NewRow();
dr["ID"] = reader["ItemID"].ToString() + "~file";
dr["filename"] = reader["FriendlyName"];
dr["OriginalFileName"] = reader["OriginalFileName"];
dr["Description"] = reader["Description"];
dr["size"] = reader["SizeInKB"].ToString();
dr["type"] = "1";
dr["modified"] = Convert.ToDateTime(reader["UploadDate"]);
dr["username"] = reader["UserName"].ToString();
dr["DownloadCount"] = reader["DownloadCount"].ToString();
dt.Rows.Add(dr);
}
}
dt.AcceptChanges();
return(dt);
}
public static FoldersAndFiles GetFoldersAndFilesModel(int moduleId, int parentId)
{
FoldersAndFiles foldersAndFiles = new FoldersAndFiles();
using (IDataReader reader = GetSharedFolders(moduleId, parentId))
{
while (reader.Read())
{
Folder newFolder = new Folder
{
ID = Convert.ToInt32(reader["FolderID"]),
ModuleID = Convert.ToInt32(reader["ModuleID"]),
Name = reader["FolderName"].ToString(),
ParentID = Convert.ToInt32(reader["ParentID"]),
ModuleGuid = new Guid(reader["ModuleGuid"].ToString()),
FolderGuid = new Guid(reader["FolderGuid"].ToString()),
ParentGuid = new Guid(reader["ParentGuid"].ToString()),
ViewRoles = reader["ViewRoles"].ToString()
};
foldersAndFiles.Folders.Add(newFolder);
}
}
using (IDataReader reader = SharedFile.GetSharedFiles(moduleId, parentId))
{
while (reader.Read())
{
File newFile = new File
{
ID = Convert.ToInt32(reader["ItemID"]),
ModuleID = Convert.ToInt32(reader["ModuleID"]),
UploadUserID = Convert.ToInt32(reader["UploadUserID"]),
Name = reader["FriendlyName"].ToString(),
OriginalFileName = reader["OriginalFileName"].ToString(),
ServerFileName = reader["ServerFileName"].ToString(),
SizeInKB = Convert.ToInt32(reader["SizeInKB"]),
UploadDate = Convert.ToDateTime(reader["UploadDate"]),
FolderID = Convert.ToInt32(reader["FolderID"]),
ItemGuid = new Guid(reader["ItemGuid"].ToString()),
ModuleGuid = new Guid(reader["ModuleGuid"].ToString()),
UserGuid = new Guid(reader["UserGuid"].ToString()),
FolderGuid = new Guid(reader["FolderGuid"].ToString()),
Description = reader["Description"].ToString(),
DownloadCount = Convert.ToInt32(reader["DownloadCount"]),
ViewRoles = reader["ViewRoles"].ToString()
};
foldersAndFiles.Files.Add(newFile);
}
}
return(foldersAndFiles);
}
