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); }