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);
}
public static List <FolderPermission> GetUserListForFolder(int FolderID)
{
List <FolderPermission> lstFolderPer = new List <FolderPermission>();
string StoredProcedureName = "usp_FileManagerGetUsersWithPermissions";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@FolderID", FolderID));
SqlDataReader SQLReader;
try
{
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName, ParaMeterCollection);
while (SQLReader.Read())
{
FolderPermission obj = new FolderPermission();
obj.UserID = int.Parse(SQLReader["UserID"].ToString());
obj.UserName = SQLReader["UserName"].ToString() ?? SQLReader["UserName"].ToString();
lstFolderPer.Add(obj);
}
SQLReader.Dispose();
}
catch (Exception e)
{
throw e;
}
return(lstFolderPer);
}
public static List <string> GetModulePermission(int UserModuleID, string UserName)
{
List <string> lstPermissions = new List <string>();
string StoredProcedureName = "usp_FileManagerGetModulePermission";
SQLHandler sagesql = new SQLHandler();
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@UserModuleID", UserModuleID));
ParaMeterCollection.Add(new KeyValuePair <string, object>("@Username", UserName));
SqlDataReader SQLReader;
try
{
SQLReader = sagesql.ExecuteAsDataReader(StoredProcedureName, ParaMeterCollection);
while (SQLReader.Read())
{
lstPermissions.Add(SQLReader["permissionkey"].ToString());
}
SQLReader.Dispose();
}
catch (Exception e)
{
throw e;
}
return(lstPermissions);
}
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);
}