public void ArchiveTheDocument(string documentName, string documentPath, string user) { DocumentRepository documentRepository = new DocumentRepository(); Guid guid; // Create and display the value of two GUIDs. guid = Guid.NewGuid(); string newDocumentName = guid.ToString() + ".pdf"; //1. Change the name of the document //2. Insert into database //3. Move the document to the archieve ArchivedDocument archiveDocument = new ArchivedDocument(); archiveDocument.OldDocumentName = documentName; archiveDocument.OldDocumentPath = documentPath; archiveDocument.NewdocumentName = newDocumentName; archiveDocument.NewDocumentPath = System.Configuration.ConfigurationManager.AppSettings["archieveDocumentPath"] + newDocumentName; archiveDocument.DocumentUser = user; archiveDocument.DateCreated = DateTime.Now; documentRepository.ArchieveDocument(archiveDocument); File.Copy(archiveDocument.OldDocumentPath, archiveDocument.NewDocumentPath); }
public void ArchieveDocument(ArchivedDocument archivedDocument) { using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { try { string query = "INSERT INTO [DocumentArchive]" + " (" + "[OldDocumentName]" + " ,[NewdocumentName]" + " ,[OldDocumentPath]" + " ,[NewDocumentPath]" + " ,[DocumentUser]" + " ,[DateCreated]" + " )" + " VALUES" + " (" + " @OldDocumentName,@NewdocumentName,@OldDocumentPath,@NewDocumentPath,@DocumentUser,@DateCreated" + ")"; db.Execute(query, new { @OldDocumentName = archivedDocument.OldDocumentName, @NewdocumentName = archivedDocument.NewdocumentName, @OldDocumentPath = archivedDocument.OldDocumentPath, @NewDocumentPath = archivedDocument.NewDocumentPath, @DocumentUser = archivedDocument.DocumentUser, @DateCreated = archivedDocument.DateCreated }); } catch (Exception er) { Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); } } }