public string GetFullPathInboundFax(string fax)
{
string fullPath = string.Empty;
List<InBoundFaxes> inBoundFaxesList = new List<InBoundFaxes>();
List<OutboundFaxDocument> outboundFaxDocumentList = new List<OutboundFaxDocument>();
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<InBoundFaxes>(query, new { @ActiveDirectoyUser = Utility.GetUserName() }).ToList();
for (int i = 0; i < inBoundFaxesList.Count; i++)
{
OutboundFaxDocument outboundFaxDocument = new OutboundFaxDocument();
string[] filePaths = Directory.GetFiles(inBoundFaxesList[i].Path);
if (filePaths.Length > 0)
{
for (int j = 0; j < filePaths.Length; j++)
{
string[] fileName = filePaths[j].Split('\\');
if (fileName[fileName.Length - 1] == fax)
{
return fullPath = inBoundFaxesList[i].Path + "\\" + fax;
}
}
}
}
return "";
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return "";
}
}
public List<OutboundFaxDocument> GetOutboundFaxes()
{
List<OutboundFaxDocument> outboundFaxDocumentList = new List<OutboundFaxDocument>();
OutboundFaxDocument outboundFaxDocument = new OutboundFaxDocument();
string[] filePaths = Directory.GetFiles(ConfigurationValues.OutboundFaxDirectory
+ "\\" + Utility.GetUserName());
for (int i = 0; i < filePaths.Length; i++)
{
string[] fileName = filePaths[i].Split('\\');
outboundFaxDocument = new OutboundFaxDocument();
outboundFaxDocument.ID = filePaths[i];
outboundFaxDocument.DocumentName = fileName[fileName.Length - 1];
outboundFaxDocumentList.Add(outboundFaxDocument);
}
return outboundFaxDocumentList;
}
public List<OutboundFaxDocument> GetOutboundFaxes()
{
List<OutboundFaxDocument> outboundFaxDocumentList = new List<OutboundFaxDocument>();
OutboundFaxDocument outboundFaxDocument = new OutboundFaxDocument();
string[] filePaths = Directory.GetFiles(ConfigurationValues.OutboundFaxDirectory
+ "\\" + Utility.GetUserName());
for (int i = 0; i < filePaths.Length; i++)
{
string[] fileName = filePaths[i].Split('\\');
outboundFaxDocument = new OutboundFaxDocument();
outboundFaxDocument.id = fileName[fileName.Length - 1];
outboundFaxDocument.text = fileName[fileName.Length - 1];
outboundFaxDocument.expanded = true;
outboundFaxDocument.spriteCssClass = "";
outboundFaxDocumentList.Add(outboundFaxDocument);
}
//JsonConvert.DeserializeObject<List<OutboundFaxDocument>>
return outboundFaxDocumentList;
//Movie m = JsonConvert.DeserializeObject<Movie>(json);
}
public void MoveFileToFolder(MoveFile moveFile)
{
//1. Move the file to the new folder
//2 Insert record giving folder that and name of document
moveFile.FileName = moveFile.FileName.Replace("\n","");
moveFile.FilePath = moveFile.FilePath.Replace("\n", "");
moveFile.Folder = moveFile.Folder.Replace("\n", "");
List<InBoundFaxes> inBoundFaxesList = new List<InBoundFaxes>();
List<OutboundFaxDocument> outboundFaxDocumentList = new List<OutboundFaxDocument>();
string name = string.Empty;
try
{
using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
const string query = "SELECT PostOfficeFoldersByUser.ActiveDirectoyUser,"
+ " PostOfficeFoldersByUser.Path,PostOfficeFoldersByUser.Name"
+ " FROM [PostOfficeFoldersByUser]"
//+ " INNER JOIN HoldFolders"
//+ " ON HoldFolders.ActiveDirectoyUser = PostOfficeFoldersByUser.ActiveDirectoyUser"
+ " where PostOfficeFoldersByUser.ActiveDirectoyUser = @ActiveDirectoyUser";
inBoundFaxesList = db.Query<InBoundFaxes>(query, new { @ActiveDirectoyUser = Utility.GetUserName() }).ToList();
for (int i = 0; i < inBoundFaxesList.Count; i++)
{
OutboundFaxDocument outboundFaxDocument = new OutboundFaxDocument();
string[] filePaths = Directory.GetFiles(inBoundFaxesList[i].Path);
if (filePaths.Length > 0)
{
for (int j = 0; j < filePaths.Length; j++)
{
string[] fileName = filePaths[j].Split('\\');
if (moveFile.FileName == fileName[fileName.Length - 1])
{
try
{
moveFile.ID = GetMoveFileId(moveFile.Folder, Utility.GetUserName(), moveFile.DocumentType);
moveFile.FilePath = System.Configuration.ConfigurationManager.AppSettings["holdFolder"] + Utility.GetUserName() + "\\" + moveFile.FileNewName;
System.IO.Directory.CreateDirectory(System.Configuration.ConfigurationManager.AppSettings["holdFolder"] + Utility.GetUserName());
AddFileToFolder(moveFile);
string s2 = System.Configuration.ConfigurationManager.AppSettings["holdFolder"] + "\\" + moveFile.FileName;
//moveFile.FileName = moveFile.FileName.Replace(" ", "_");
Logging.LogErrors(ConfigurationValues.ErrorLogPath, "Moving file from " + filePaths[j] + " to " + System.Configuration.ConfigurationManager.AppSettings["holdFolder"] + "\\" + moveFile.FileName);
File.Move(filePaths[j], moveFile.FilePath);
Logging.LogErrors(ConfigurationValues.ErrorLogPath, "File successfully moved");
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
}
}
}
}
}
}
catch (Exception er)
{
string s1 = er.ToString();
//return outboundFaxDocumentList;
}
}