public OperationResult AddPostOfficeFolders(List<FaxFolders> faxFoldersList)
{
FaxFolders faxFoldersFullInformation = new FaxFolders();
DeleteCurrentList(Utility.GetUserName());
OperationResult operationResult = new OperationResult();
for (int i = 0; i < faxFoldersList.Count; i++)
{
faxFoldersFullInformation = GetFaxingData(faxFoldersList[i].FriendlyName);
try
{
string query = "INSERT INTO [PostOfficeFoldersByUser]"
+ " ("
+ " [ActiveDirectoyUser]"
+ " ,[Path]"
+ " ,[Name]"
+ " )"
+ " VALUES"
+ " ("
+ "@ActiveDirectoyUser,@Path,@Name"
+ " )";
{
using (SqlConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
int rowsAffectd = db.Execute(query, new
{
@ActiveDirectoyUser = Utility.GetUserName(),
@Path = faxFoldersFullInformation.NewPath,
@Name = faxFoldersFullInformation.FriendlyName
}
);
}
}
}
catch (Exception er)
{
operationResult.Success = false;
operationResult.AddMessage(er.Message);
return operationResult;
}
}
operationResult.Success = true;
operationResult.ErrorMessage = "None";
return operationResult;
}
public List<FaxFolders> GetFaxFolders()
{
List<FaxFolders> faxFolderList = new List<FaxFolders>();
List<FaxFolders> faxFolderList2 = new List<FaxFolders>();
FaxFolders faxFolder = new FaxFolders();
faxFolder.ID = 0;
faxFolder.FriendlyName = "Select Folder";
faxFolder.PhoneNumber = string.Empty;
faxFolder.NewPath = string.Empty;
faxFolderList2.Add(faxFolder);
try
{
string query = "SELECT [ID],[FriendlyName],[NewPath]"
+ " FROM [PostOfficeFolders]"
+ " order by [FriendlyName]";
using (SqlConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
faxFolderList = db.Query<FaxFolders>(query).ToList();
for (int i = 0; i < faxFolderList.Count; i++)
{
faxFolderList2.Add(faxFolderList[i]);
}
return faxFolderList2;
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return faxFolderList2;
}
}
private FaxFolders GetFaxingData(string friendlyName)
{
FaxFolders faxFolders = new FaxFolders();
try
{
using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
string query = "SELECT [ID],[FriendlyName],[NewPath]"
+ " FROM [PostOfficeFolders]"
+ " where [FriendlyName] = @FriendlyName";
faxFolders = db.Query<FaxFolders>(query, new { @FriendlyName = friendlyName }).Single();
return faxFolders;
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return faxFolders;
}
}
public void SendFileToAnotherUser(FaxFolders sendFileToAnotherUser)
{
//1. Move the file to the new folder
//2 Insert record giving folder that and name of document
string s1 = string.Empty;
CurrentDocument currentdocument = new CurrentDocument();
List<OutboundFaxDocument> outboundFaxDocumentList = new List<OutboundFaxDocument>();
DocumentRepository documentRepository = new DocumentRepository();
ArchiveDocument archiveDocument = new ArchiveDocument();
try {
using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
const string query = "SELECT [ID],[ActiveDirectoyUser],[CurrentDocumentPathXOD],[CurrentDocumentPathPDF]"
+ " ,[PathToDocument],[CurrentAnnotation],[CurrentListOfDocuments]"
+ " FROM [CurrentDocument]"
+ " where [ActiveDirectoyUser] = @ActiveDirectoyUser";
currentdocument = db.Query<CurrentDocument>(query, new { @ActiveDirectoyUser = Utility.GetUserName() }).Single();
//File.Move(currentdocument.CurrentDocumentPathPDF, sendFileToAnotherUser.NewPath + "\\" + currentdocumentName[currentdocumentName.Length - 1]);
string[] filestoDelete = currentdocument.CurrentListOfDocuments.Split('~');
for (int i = 0; i < filestoDelete.Length - 1; i++)
{
string[] currentDocumentName = filestoDelete[i].Split('\\');
archiveDocument.ArchiveTheDocument(currentDocumentName[currentDocumentName.Length - 1], filestoDelete[i], Utility.GetUserName());
File.Move(filestoDelete[i], sendFileToAnotherUser.NewPath + "\\" + currentDocumentName[currentDocumentName.Length - 1]);
try
{
documentRepository.DeleteDocumentThatIsInAInFolder(filestoDelete[i], Utility.GetUserName());
try
{
File.Delete(filestoDelete[i]);
}
catch { }
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
}
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
}
}
