public void Get_All_Files_Test() { IFileRepository repository = new FileRepository(testDBContext); int userId = 1; string postStatus = FileStatus.Posted.ToString(); Func<File, bool> filter = file => file.CreatedBy == userId && (file.Status.Equals(postStatus, StringComparison.InvariantCulture) || file.isDeleted == null || file.isDeleted == false); var fileList = repository.GetFiles(filter); Assert.IsNotNull(fileList); Assert.AreEqual(fileList.Count(), 2); Assert.AreEqual(fileList.ToList()[0].FileId, 1); Assert.AreEqual(fileList.ToList()[1].FileId, 2); Assert.AreEqual(fileList.ToList()[0].Name, "Document One"); Assert.AreEqual(fileList.ToList()[1].Name, "Document Two"); }
public void Get_File_By_FileId_Test() { IFileRepository repository = new FileRepository(testDBContext); var file = repository.GetItem(1, 1); Assert.IsNotNull(file); Assert.AreEqual(file.FileId, 1); Assert.AreEqual(file.Name, "Document One"); // Assert.AreEqual(file.BlobId, "blobId"); Assert.AreEqual(file.Citation, "Citation 1"); Assert.AreEqual(file.CreatedBy, 1); Assert.AreEqual(file.Description, "Document 1"); Assert.AreEqual(file.Identifier, "asdahgsdfsghadfsghad"); Assert.AreEqual(file.isDeleted, false); Assert.AreEqual(file.MimeType, "Mime type 1"); Assert.AreEqual(file.ModifiedBy, 1); Assert.IsNotNull(file.Repository); Assert.AreEqual(file.RepositoryId, 1); Assert.AreEqual(file.Size, 20.90); Assert.AreEqual(file.Status, "Uploaded"); Assert.AreEqual(file.Title, "Document 1"); }
private void AddFile(File fileToAdd) { IFileRepository repository = new FileRepository(testDBContext); repository.AddFile(fileToAdd); testDBContext.Commit(); }
public void Update_File_With_FileData_Null_Test() { IFileRepository repository = new FileRepository(testDBContext); var file = repository.GetItem(1, 1); file.BlobId = "TestBlobid"; file.Citation = "Updated Citation"; file.Description = "Updated description"; file.FileMetadataFields = null; file.FileColumns = null; file.FileQualityChecks = null; repository.UpdateFile(file); testDBContext.Commit(); var updatedFile = repository.GetItem(1, 1); Assert.AreEqual(updatedFile.BlobId, "TestBlobid"); Assert.AreEqual(updatedFile.Citation, "Updated Citation"); Assert.AreEqual(updatedFile.Description, "Updated description"); Assert.IsNull(file.FileMetadataFields); Assert.IsNull(file.FileColumns); Assert.IsNull(file.FileQualityChecks); }
public void Save_File_NullColumnUnit_DataTest() { IFileRepository repository = new FileRepository(testDBContext); var file = repository.GetItem(1, 1); file.FileColumns = new List<FileColumn>(); var newFilecolumn1 = new FileColumn() { FileColumnTypeId = 1, FileColumnUnitId = null, EntityName = "entityName", EntityDescription = "entityDesc", Description = "Description" }; var newFilecolumn2 = new FileColumn() { FileColumnTypeId = 1, FileColumnUnitId = 1, EntityName = "entityName1", EntityDescription = "entityDesc1", Description = "Description1" }; var newFilecolumn3 = new FileColumn() { FileColumnTypeId = 1, FileColumnUnitId = 1, EntityName = "entityName2", EntityDescription = "entityDesc2", Description = "Description2" }; file.FileColumns.Add(newFilecolumn1); file.FileColumns.Add(newFilecolumn2); file.FileColumns.Add(newFilecolumn3); testDBContext.Commit(); var fileColumns = GetFileColumns(file.FileId); Assert.AreEqual(3, fileColumns.Count); Assert.AreEqual(newFilecolumn1.EntityName, fileColumns[0].EntityName); Assert.AreEqual(newFilecolumn1.EntityDescription, fileColumns[0].EntityDescription); Assert.AreEqual(newFilecolumn1.Description, fileColumns[0].Description); Assert.AreEqual(newFilecolumn1.FileColumnUnitId, fileColumns[0].FileColumnUnitId); Assert.AreEqual(newFilecolumn1.FileColumnTypeId, fileColumns[0].FileColumnTypeId); Assert.AreEqual(newFilecolumn2.EntityName, fileColumns[1].EntityName); Assert.AreEqual(newFilecolumn2.EntityDescription, fileColumns[1].EntityDescription); Assert.AreEqual(newFilecolumn2.Description, fileColumns[1].Description); Assert.AreEqual(newFilecolumn2.FileColumnUnitId, fileColumns[1].FileColumnUnitId); Assert.AreEqual(newFilecolumn2.FileColumnTypeId, fileColumns[1].FileColumnTypeId); Assert.AreEqual(newFilecolumn3.EntityName, fileColumns[2].EntityName); Assert.AreEqual(newFilecolumn3.EntityDescription, fileColumns[2].EntityDescription); Assert.AreEqual(newFilecolumn3.Description, fileColumns[2].Description); Assert.AreEqual(newFilecolumn3.FileColumnUnitId, fileColumns[2].FileColumnUnitId); Assert.AreEqual(newFilecolumn3.FileColumnTypeId, fileColumns[2].FileColumnTypeId); var columnTypeList = GetFileColumnTypes(); //only one column type should be there, one more dummy row was added Assert.AreEqual(1, columnTypeList.Count()); var columnsUnitsList = GetFileColumnUnits(); Assert.AreEqual(1, columnsUnitsList.Count()); testDBContext.Commit(); }
public void Save_File_Data() { IFileRepository repository = new FileRepository(testDBContext); var file = repository.GetItem(1, 1); file.FileColumns = new List<FileColumn>(); var newFilecolumn = new FileColumn() { FileColumnTypeId = 1, FileColumnUnitId = 1, EntityName = "entityName", EntityDescription = "entityDesc", Description = "Description" }; file.FileColumns.Add(newFilecolumn); testDBContext.Commit(); var fileColumns = GetFileColumns(file.FileId); Assert.AreEqual(1, fileColumns.Count); Assert.AreEqual(newFilecolumn.EntityName, fileColumns[0].EntityName); Assert.AreEqual(newFilecolumn.EntityDescription, fileColumns[0].EntityDescription); Assert.AreEqual(newFilecolumn.Description, fileColumns[0].Description); Assert.AreEqual(newFilecolumn.FileColumnUnitId, fileColumns[0].FileColumnUnitId); Assert.AreEqual(newFilecolumn.FileColumnTypeId, fileColumns[0].FileColumnTypeId); var columnTypeList = GetFileColumnTypes(); //only one column type should be there, one more dummy row was added Assert.AreEqual(1, columnTypeList.Count()); var columnsUnitsList = GetFileColumnUnits(); Assert.AreEqual(1, columnsUnitsList.Count()); testDBContext.Commit(); }
public void Remove_Mentioned_File_Permenently_Test() { IFileRepository repository = new FileRepository(testDBContext); var result = repository.DeleteFile(1, "Posted"); testDBContext.Commit(); Assert.IsNotNull(result); int userId = 1; string postStatus = FileStatus.Posted.ToString(); Func<File, bool> filter = file => file.CreatedBy == userId && (file.Status.Equals(postStatus, StringComparison.InvariantCulture) || file.isDeleted == null || file.isDeleted == false); var fileList = repository.GetFiles(filter); Assert.AreEqual(fileList.Count(), 1); Assert.AreEqual(fileList.ToList()[0].FileId, 2); Assert.AreEqual(fileList.ToList()[0].Name, "Document Two"); }