public void InsertDocuments() { //Arrange var documentScanEngine = new DocumentScanEngine(); const int ID_ArchiveBooking1 = 84; const string DocumentPath1 = "novo"; const int ID_ArchiveBooking2 = 70; const string DocumentPath2 = "novo"; const int ID_ArchiveBooking3 = 98; const string DocumentPath3 = "novo"; List <DocumentScan> documents = new List <DocumentScan>(); List <DocumentScan> result = new List <DocumentScan>(); //Act DocumentScan document1 = new DocumentScan(100, ID_ArchiveBooking1, DocumentPath1); DocumentScan document2 = new DocumentScan(101, ID_ArchiveBooking2, DocumentPath2); DocumentScan document3 = new DocumentScan(102, ID_ArchiveBooking3, DocumentPath3); documents.Add(document1); documents.Add(document2); documents.Add(document3); documentScanEngine.InsertDocuments(documents); result = documentScanEngine.GetDocumentsByArchiveBooking(70); //Assert foreach (DocumentScan document in result) { Assert.Equal("novo", document.DocumentPath); } }
public List <DocumentScan> GetDocumentsByArchiveBooking(int id) { if (id == 0) { throw new IndexOutOfRangeException("No such document."); } List <DocumentScan> result = new List <DocumentScan>(); using (connection = new SqlConnection(connectionString)) { connection.Open(); string sql = "SELECT * FROM DocumentScan WHERE ID_ArchiveBooking = @id"; command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@id", id); using (reader = command.ExecuteReader()) { while (reader.Read()) { DocumentScan document = new DocumentScan(reader.GetInt32("ID_DocumentScan"), reader.GetInt32("ID_ArchiveBooking"), reader.GetString("DocumentPath")); result.Add(document); } } reader.Close(); command.Dispose(); connection.Close(); } return(result); }
public void UpdateDocumentScanByID(int id, DocumentScan document) { if (id == 0) { throw new IndexOutOfRangeException("No such document."); } if (document == null) { throw new IndexOutOfRangeException("Empty document."); } using (connection = new SqlConnection(connectionString)) { connection.Open(); using (adapter = new SqlDataAdapter()) { string sql = "UPDATE DocumentScan SET ID_ArchiveBooking = @archiveId, DocumentPath = @path WHERE ID_DocumentScan = @id"; command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@archiveId", document.ID_ArchiveBooking); command.Parameters.AddWithValue("@path", document.DocumentPath); command.Parameters.AddWithValue("@id", id); adapter.UpdateCommand = command; adapter.UpdateCommand.ExecuteNonQuery(); } command.Dispose(); connection.Close(); } }
public List <DocumentScan> GetDocuments() { List <DocumentScan> result = new List <DocumentScan>(); using (connection = new SqlConnection(connectionString)) { connection.Open(); string sql = "SELECT * FROM DocumentScan"; command = new SqlCommand(sql, connection); using (reader = command.ExecuteReader()) { while (reader.Read()) { DocumentScan document = new DocumentScan(reader.GetInt32("ID_DocumentScan"), reader.GetInt32("ID_ArchiveBooking"), reader.GetString("DocumentPath")); result.Add(document); } } reader.Close(); command.Dispose(); connection.Close(); } return(result); }
public void DeleteDocumentById() { //Arrange var documentScanEngine = new DocumentScanEngine(); //Act documentScanEngine.DeleteDocumentById(12); DocumentScan document = documentScanEngine.GetDocumentByID(12); //Assert Assert.Null(document.DocumentPath); }
public void GetDocumentByID() { //Arrange var documentScanEngine = new DocumentScanEngine(); //Act DocumentScan document = documentScanEngine.GetDocumentByID(28); //Assert Assert.Equal(70, document.ID_ArchiveBooking); Assert.Equal("novo", document.DocumentPath); }
public async Task IndexScannedDocument(string fileName, string content) { DocumentScan scan = new DocumentScan { Id = Guid.NewGuid().ToString(), FileName = fileName, Content = content, ScanDate = DateTime.Now, }; await _client.IndexAsync(scan, idx => idx.Index(_indexName)); }
public void DeleteDocumentByArchiveBooking() { //Arrange var documentScanEngine = new DocumentScanEngine(); //Act documentScanEngine.DeleteDocumentByArchiveBooking(69); DocumentScan document = documentScanEngine.GetDocumentByID(11); //Assert Assert.Null(document.DocumentPath); }
public void InsertDocument(DocumentScan document) { if (document == null) { throw new ArgumentNullException("Empty document."); } document.ID_DocumentScan = null; context.DocumentScans.Add(document); context.SaveChanges(); }
public void UpdateDocumentByID() { //Arrange var documentScanEngine = new DocumentScanEngine(); const int ID_ArchiveBooking = 70; const string DocumentPath = "updated"; //Act DocumentScan document = new DocumentScan(100, ID_ArchiveBooking, DocumentPath); documentScanEngine.UpdateDocumentScanByID(36, document); document = documentScanEngine.GetDocumentByID(36); //Assert Assert.Equal(DocumentPath, document.DocumentPath); }
public void DeleteDocumentByArchiveBooking(int id) { if (id == 0) { throw new ArgumentNullException("Invalid id."); } DocumentScan docScan = context.DocumentScans.Where(d => d.ID_ArchiveBooking == id).FirstOrDefault(); if (docScan == null) { //throw new ArgumentNullException("No document from that archive booking in db."); return; } context.DocumentScans.Remove(docScan); context.SaveChanges(); }
public void InsertDocument() { //Arrange var documentScanEngine = new DocumentScanEngine(); const int ID_ArchiveBooking = 70; const string DocumentPath = "novo"; //Act DocumentScan document = new DocumentScan(100, ID_ArchiveBooking, DocumentPath); documentScanEngine.InsertDocument(document); List <DocumentScan> documents = documentScanEngine.GetDocumentsByArchiveBooking(70); //Assert foreach (DocumentScan doc in documents) { Assert.Equal(DocumentPath, doc.DocumentPath); } }
public void UpdateDocumentScanByID(int id, DocumentScan document) { if (id == 0) { throw new ArgumentNullException("Invalid id."); } if (document == null) { throw new ArgumentNullException("Empty document."); } DocumentScan docScan = context.DocumentScans.Where(d => d.ID_DocumentScan == id).FirstOrDefault(); if (docScan == null) { //throw new NullReferenceException("No document with that id in the db."); return; } docScan.ID_ArchiveBooking = document.ID_ArchiveBooking; docScan.DocumentPath = document.DocumentPath; context.DocumentScans.Update(docScan); context.SaveChanges(); }
public void InsertDocument(DocumentScan document) { if (document == null) { throw new IndexOutOfRangeException("Empty document."); } using (connection = new SqlConnection(connectionString)) { connection.Open(); using (adapter = new SqlDataAdapter()) { string sql = "INSERT INTO DocumentScan(ID_ArchiveBooking, DocumentPath) VALUES(@id, @path)"; command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@id", document.ID_ArchiveBooking); command.Parameters.AddWithValue("@path", document.DocumentPath); adapter.InsertCommand = command; adapter.InsertCommand.ExecuteNonQuery(); } command.Dispose(); connection.Close(); } }