public List<InboundFaxDocument> GetHoldFolders(string folderType) { List<HoldFolders> holdFoldersList = new List<HoldFolders>(); InboundFaxDocument holdForTreeView = new InboundFaxDocument(); List<InboundFaxDocument> holdForTreeViewList = new List<InboundFaxDocument>(); try { using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { const string query = "SELECT [ID],[ActiveDirectoyUser],[FolderName]" + " FROM [HoldFolders]" + " where ActiveDirectoyUser = @ActiveDirectoyUser" + " and DocumentType = @DocumentType"; holdFoldersList = db.Query<HoldFolders>(query, new { @ActiveDirectoyUser = Utility.GetUserName(), @DocumentType = folderType }).ToList(); for(int i = 0; i< holdFoldersList.Count;i++) { holdForTreeView = new InboundFaxDocument(); holdForTreeView.id = holdFoldersList[i].ID.ToString(); holdForTreeView.HasChildren = true; holdForTreeView.DocumentName = holdFoldersList[i].FolderName; holdForTreeViewList.Add(holdForTreeView); } return holdForTreeViewList; } } catch (Exception er) { Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); return holdForTreeViewList; } }
public List<InboundFaxDocument> GetFilesInFolder(string holderFolderId) { List<HoldFolders> holdFoldersList = new List<HoldFolders>(); InboundFaxDocument holdForTreeView = new InboundFaxDocument(); List<InboundFaxDocument> holdForTreeViewList = new List<InboundFaxDocument>(); try { using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { const string query = "SELECT [ID],[HoldFolderID],[ActiveDirectoyUser],[FolderName],[FileName],[FilePath]" + " FROM [HoldFiles]" + " where HoldFolderID = @HoldFolderID"; holdFoldersList = db.Query<HoldFolders>(query, new { @HoldFolderID = holderFolderId }).ToList(); for (int i = 0; i < holdFoldersList.Count; i++) { holdForTreeView = new InboundFaxDocument(); holdForTreeView.FaxPath = holdFoldersList[i].FilePath; holdForTreeView.id = holdFoldersList[i].ID; holdForTreeView.expanded = true; holdForTreeView.DocumentName = holdFoldersList[i].FileName; holdForTreeViewList.Add(holdForTreeView); } return holdForTreeViewList; } } catch (Exception er) { Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); return holdForTreeViewList; } }
public List<InboundFaxDocument> GetInboundFaxList() { List<InboundFaxDocument> inBoundFaxesList = new List<InboundFaxDocument>(); List<InboundFaxDocument> inboundFaxDocumentList = new List<InboundFaxDocument>(); string name = string.Empty; try { using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { const string query = "SELECT [ID],[ActiveDirectoyUser],[Path],[Name]" + " FROM [PostOfficeFoldersByUser]" + " where [ActiveDirectoyUser] = @ActiveDirectoyUser"; inBoundFaxesList = db.Query<InboundFaxDocument>(query, new { @ActiveDirectoyUser = Utility.GetUserName() }).ToList(); for (int i = 0; i < inBoundFaxesList.Count; i++) { InboundFaxDocument inboundFaxDocument = new InboundFaxDocument(); string[] filePaths = Directory.GetFiles(inBoundFaxesList[i].Path); if (filePaths.Length > 0) { for (int j = 0; j < filePaths.Length; j++) { string[] fileName = filePaths[j].Split('\\'); inboundFaxDocument = new InboundFaxDocument(); inboundFaxDocument.id = filePaths[j]; inboundFaxDocument.DocumentName = fileName[fileName.Length - 1]; inboundFaxDocument.FaxPath = filePaths[j]; inboundFaxDocument.expanded = true; inboundFaxDocumentList.Add(inboundFaxDocument); } } } return inboundFaxDocumentList; } } catch (Exception er) { Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); return inboundFaxDocumentList; } }