public void SQL_File_FileProcessed_isProcessed() { uploaded_data ud = new uploaded_data(); ud.local = 0; ud.workflow_state = Constants.WorkflowStates.PreCreated; ud.version = 1; DbContext.uploaded_data.Add(ud); DbContext.SaveChanges(); // Act sut.FileProcessed("url", "myChecksum", "myFileLocation", "myFileName", ud.id); List <uploaded_data> uploadedDataResult = DbContext.uploaded_data.AsNoTracking().ToList(); //var versionedMatches = DbContext.uploaded_data_versions.AsNoTracking().ToList(); TODO 05/01/2018 // Assert Assert.NotNull(uploadedDataResult); Assert.NotNull(ud); Assert.AreEqual(Constants.WorkflowStates.Created, uploadedDataResult[0].workflow_state); Assert.AreEqual(1, uploadedDataResult[0].local); Assert.AreEqual(2, uploadedDataResult[0].version); Assert.AreEqual("myChecksum", uploadedDataResult[0].checksum); Assert.AreEqual("myFileLocation", uploadedDataResult[0].file_location); Assert.AreEqual("myFileName", uploadedDataResult[0].file_name); Assert.AreEqual(ud.id, uploadedDataResult[0].id); }
public async Task SQL_File_FileProcessed_isProcessed() { uploaded_data ud = new uploaded_data { Local = 0, WorkflowState = Constants.WorkflowStates.PreCreated, Version = 1 }; dbContext.uploaded_data.Add(ud); await dbContext.SaveChangesAsync().ConfigureAwait(false); // Act await sut.FileProcessed("url", "myChecksum", "myFileLocation", "myFileName", ud.Id); List <uploaded_data> uploadedDataResult = dbContext.uploaded_data.AsNoTracking().ToList(); //var versionedMatches = DbContext.uploaded_data_versions.AsNoTracking().ToList(); TODO 05/01/2018 // Assert Assert.NotNull(uploadedDataResult); Assert.NotNull(ud); Assert.AreEqual(Constants.WorkflowStates.Created, uploadedDataResult[0].WorkflowState); Assert.AreEqual(1, uploadedDataResult[0].Local); Assert.AreEqual(2, uploadedDataResult[0].Version); Assert.AreEqual("myChecksum", uploadedDataResult[0].Checksum); Assert.AreEqual("myFileLocation", uploadedDataResult[0].FileLocation); Assert.AreEqual("myFileName", uploadedDataResult[0].FileName); Assert.AreEqual(ud.Id, uploadedDataResult[0].Id); }
public async Task SQL_File_FileRead_doesFileRead() { uploaded_data ud = new uploaded_data { Checksum = "checksum1", Extension = "extension", CurrentFile = "currentFile1", UploaderId = 223, UploaderType = "uploader_type", FileLocation = "file_location", FileName = "fileName", WorkflowState = Constants.WorkflowStates.PreCreated }; dbContext.uploaded_data.Add(ud); await dbContext.SaveChangesAsync().ConfigureAwait(false); // Act UploadedData Ud = await sut.FileRead(); // Assert Assert.NotNull(ud); Assert.NotNull(Ud); Assert.AreEqual(Ud.Checksum, ud.Checksum); Assert.AreEqual(Ud.Extension, ud.Extension); Assert.AreEqual(Ud.CurrentFile, ud.CurrentFile); Assert.AreEqual(Ud.UploaderId, ud.UploaderId); Assert.AreEqual(Ud.UploaderType, ud.UploaderType); Assert.AreEqual(Ud.FileLocation, ud.FileLocation); Assert.AreEqual(Ud.FileName, ud.FileName); Assert.AreEqual(Ud.Id, ud.Id); Assert.AreEqual(Constants.WorkflowStates.PreCreated, ud.WorkflowState); }
public async Task SQL_File_FileCaseFindMUId_doesFindMUId() { Random rnd = new Random(); sites site1 = await testHelpers.CreateSite("MySite", 22); DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "template1", "template_desc", "", "", 1, 1); string guid = Guid.NewGuid().ToString(); DateTime c1_ca = DateTime.Now.AddDays(-9); DateTime c1_da = DateTime.Now.AddDays(-8).AddHours(-12); DateTime c1_ua = DateTime.Now.AddDays(-8); workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); site_workers site_workers = await testHelpers.CreateSiteWorker(55, site1, worker); units unit = await testHelpers.CreateUnit(48, 49, site1, 348); string microtingUId = Guid.NewGuid().ToString(); string microtingCheckId = Guid.NewGuid().ToString(); cases aCase1 = await testHelpers.CreateCase("case1UId", cl1, c1_ca, "custom1", c1_da, worker, rnd.Next(1, 255), rnd.Next(1, 255), site1, 1, "caseType1", unit, c1_ua, 1, worker, Constants.WorkflowStates.Created); uploaded_data ud = new uploaded_data { Checksum = "checksum1", Extension = "extension", CurrentFile = "currentFile1", UploaderId = 223, UploaderType = "uploader_type", FileLocation = "url", FileName = "fileName" }; dbContext.uploaded_data.Add(ud); await dbContext.SaveChangesAsync().ConfigureAwait(false); field_values fVs = new field_values { UploadedDataId = ud.Id, CaseId = aCase1.Id }; dbContext.field_values.Add(fVs); await dbContext.SaveChangesAsync().ConfigureAwait(false); // Act await sut.FileCaseFindMUId("url"); Assert.NotNull(fVs); Assert.AreEqual(fVs.CaseId, aCase1.Id); }
public void SQL_File_FileCaseFindMUId_doesFindMUId() { sites site1 = testHelpers.CreateSite("MySite", 22); DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "template1", "template_desc", "", "", 1, 1); string guid = Guid.NewGuid().ToString(); DateTime c1_ca = DateTime.Now.AddDays(-9); DateTime c1_da = DateTime.Now.AddDays(-8).AddHours(-12); DateTime c1_ua = DateTime.Now.AddDays(-8); workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); site_workers site_workers = testHelpers.CreateSiteWorker(55, site1, worker); units unit = testHelpers.CreateUnit(48, 49, site1, 348); string microtingUId = Guid.NewGuid().ToString(); string microtingCheckId = Guid.NewGuid().ToString(); cases aCase1 = testHelpers.CreateCase("case1UId", cl1, c1_ca, "custom1", c1_da, worker, "microtingCheckUId1", "microtingUId1", site1, 1, "caseType1", unit, c1_ua, 1, worker, Constants.WorkflowStates.Created); uploaded_data ud = new uploaded_data(); ud.checksum = "checksum1"; ud.extension = "extension"; ud.current_file = "currentFile1"; ud.uploader_id = 223; ud.uploader_type = "uploader_type"; ud.file_location = "url"; ud.file_name = "fileName"; //ud.id = 111; DbContext.uploaded_data.Add(ud); DbContext.SaveChanges(); field_values fVs = new field_values(); fVs.uploaded_data_id = ud.id; fVs.case_id = aCase1.id; DbContext.field_values.Add(fVs); DbContext.SaveChanges(); //Act sut.FileCaseFindMUId("url"); Assert.NotNull(fVs); Assert.AreEqual(fVs.case_id, aCase1.id); }
public void SQL_File_GetUploadedData_doesGetUploadedData() { uploaded_data ud = new uploaded_data(); DbContext.uploaded_data.Add(ud); DbContext.SaveChanges(); sut.GetUploadedData(ud.id); List <uploaded_data> uploadedDataResult = DbContext.uploaded_data.AsNoTracking().ToList(); Assert.NotNull(ud); Assert.NotNull(uploadedDataResult); Assert.AreEqual(ud.id, uploadedDataResult[0].id); }
public async Task SQL_UploadedData_UploadedDataRead_DoesReturnOneUploadedDataClass() { // Arrance string checksum = ""; string extension = "jpg"; string currentFile = "Hello.jpg"; int uploaderId = 1; string fileLocation = @"c:\here"; string fileName = "Hello.jpg"; // Act uploaded_data dU = new uploaded_data { CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now, Extension = extension, UploaderId = uploaderId, UploaderType = Constants.UploaderTypes.System, WorkflowState = Constants.WorkflowStates.PreCreated, Version = 1, Local = 0, FileLocation = fileLocation, FileName = fileName, CurrentFile = currentFile, Checksum = checksum }; dbContext.uploaded_data.Add(dU); await dbContext.SaveChangesAsync().ConfigureAwait(false); uploaded_data ud = await sut.GetUploadedData(dU.Id); // Assert Assert.NotNull(ud); Assert.AreEqual(ud.Id, dU.Id); Assert.AreEqual(ud.Extension, dU.Extension); Assert.AreEqual(ud.UploaderId, dU.UploaderId); Assert.AreEqual(ud.UploaderType, dU.UploaderType); Assert.AreEqual(ud.WorkflowState, dU.WorkflowState); Assert.AreEqual(ud.Version, 1); Assert.AreEqual(ud.Local, 0); Assert.AreEqual(ud.FileLocation, dU.FileLocation); Assert.AreEqual(ud.FileName, dU.FileName); Assert.AreEqual(ud.CurrentFile, dU.CurrentFile); Assert.AreEqual(ud.Checksum, dU.Checksum); }
public async Task SQL_File_GetUploadedData_doesGetUploadedData() { uploaded_data ud = new uploaded_data(); dbContext.uploaded_data.Add(ud); await dbContext.SaveChangesAsync().ConfigureAwait(false); await sut.GetUploadedData(ud.Id); List <uploaded_data> uploadedDataResult = dbContext.uploaded_data.AsNoTracking().ToList(); Assert.NotNull(ud); Assert.NotNull(uploadedDataResult); Assert.AreEqual(ud.Id, uploadedDataResult[0].Id); }
public void SQL_UploadedData_UploadedDataRead_DoesReturnOneUploadedDataClass() { // Arrance string checksum = ""; string extension = "jpg"; string currentFile = "Hello.jpg"; int uploaderId = 1; string fileLocation = @"c:\here"; string fileName = "Hello.jpg"; // Act uploaded_data dU = new uploaded_data(); dU.created_at = DateTime.Now; dU.updated_at = DateTime.Now; dU.extension = extension; dU.uploader_id = uploaderId; dU.uploader_type = Constants.UploaderTypes.System; dU.workflow_state = Constants.WorkflowStates.PreCreated; dU.version = 1; dU.local = 0; dU.file_location = fileLocation; dU.file_name = fileName; dU.current_file = currentFile; dU.checksum = checksum; DbContext.uploaded_data.Add(dU); DbContext.SaveChanges(); uploaded_data ud = sut.GetUploadedData(dU.id); // Assert Assert.NotNull(ud); Assert.AreEqual(ud.id, dU.id); Assert.AreEqual(ud.extension, dU.extension); Assert.AreEqual(ud.uploader_id, dU.uploader_id); Assert.AreEqual(ud.uploader_type, dU.uploader_type); Assert.AreEqual(ud.workflow_state, dU.workflow_state); Assert.AreEqual(ud.version, 1); Assert.AreEqual(ud.local, 0); Assert.AreEqual(ud.file_location, dU.file_location); Assert.AreEqual(ud.file_name, dU.file_name); Assert.AreEqual(ud.current_file, dU.current_file); Assert.AreEqual(ud.checksum, dU.checksum); }
#pragma warning disable 1998 public async Task Handle(TranscriptionCompleted message) { try { field_values fv = await sqlController.GetFieldValueByTranscriptionId(message.MicrotringUUID); JToken result = await communicator.SpeechToText(message.MicrotringUUID); await sqlController.FieldValueUpdate((int)fv.CaseId, (int)fv.Id, result["text"].ToString()); #region download file uploaded_data ud = await sqlController.GetUploaded_DataByTranscriptionId(message.MicrotringUUID); if (ud.FileName.Contains("3gp")) { log.LogStandard("TranscriptionCompletedHandler.Handle", "file_name contains 3gp"); string urlStr = sqlController.SettingRead(Settings.comSpeechToText).Result + "/download_file/" + message.MicrotringUUID + ".wav?token=" + sqlController.SettingRead(Settings.token); string fileLocationPicture = await sqlController.SettingRead(Settings.fileLocationPicture); using (var client = new System.Net.WebClient()) { try { log.LogStandard("TranscriptionCompletedHandler.Handle", "Trying to download file from : " + urlStr); client.DownloadFile(urlStr, fileLocationPicture + ud.FileName.Replace(".3gp", ".wav")); await core.PutFileToStorageSystem(fileLocationPicture + ud.FileName.Replace(".3gp", ".wav"), ud.FileName.Replace("3gp", "wav")); } catch (Exception ex) { throw new Exception("Downloading and creating fil locally failed.", ex); } } } #endregion await sqlController.NotificationUpdate(message.notificationUId, message.MicrotringUUID, Constants.WorkflowStates.Processed, "", ""); log.LogStandard("TranscriptionCompletedHandler.Handle", "Transcription with id " + message.MicrotringUUID + " has been transcribed"); } catch (Exception ex) { await sqlController.NotificationUpdate(message.notificationUId, message.MicrotringUUID, Constants.WorkflowStates.NotFound, ex.Message, ex.StackTrace.ToString()); } }
public void SQL_File_DeleteFile_doesFileGetDeleted() { uploaded_data ud = new uploaded_data(); ud.workflow_state = Constants.WorkflowStates.Created; ud.version = 1; DbContext.uploaded_data.Add(ud); DbContext.SaveChanges(); //Act sut.DeleteFile(ud.id); List <uploaded_data> uploadedDataResult = DbContext.uploaded_data.AsNoTracking().ToList(); //Assert Assert.NotNull(ud); Assert.NotNull(uploadedDataResult); Assert.AreEqual(Constants.WorkflowStates.Removed, uploadedDataResult[0].workflow_state); Assert.AreEqual(2, uploadedDataResult[0].version); Assert.AreEqual(ud.id, uploadedDataResult[0].id); }
public async Task SQL_File_DeleteFile_doesFileGetDeleted() { uploaded_data ud = new uploaded_data { WorkflowState = Constants.WorkflowStates.Created, Version = 1 }; dbContext.uploaded_data.Add(ud); await dbContext.SaveChangesAsync().ConfigureAwait(false); // Act await sut.DeleteFile(ud.Id); List <uploaded_data> uploadedDataResult = dbContext.uploaded_data.AsNoTracking().ToList(); // Assert Assert.NotNull(ud); Assert.NotNull(uploadedDataResult); Assert.AreEqual(Constants.WorkflowStates.Removed, uploadedDataResult[0].WorkflowState); Assert.AreEqual(2, uploadedDataResult[0].Version); Assert.AreEqual(ud.Id, uploadedDataResult[0].Id); }
public uploaded_data CreateUploadedData(string checkSum, string currentFile, string extension, string fileLocation, string fileName, short?local, workers worker, string uploaderType, int version, bool createPhysicalFile) { uploaded_data UD = new uploaded_data(); UD.checksum = checkSum; UD.created_at = DateTime.Now; UD.current_file = currentFile; UD.expiration_date = DateTime.Now.AddYears(1); UD.extension = extension; UD.file_location = fileLocation; UD.file_name = fileName; UD.local = local; UD.updated_at = DateTime.Now; UD.uploader_id = worker.id; UD.uploader_type = uploaderType; UD.version = version; UD.workflow_state = Constants.WorkflowStates.Created; DbContext.uploaded_data.Add(UD); DbContext.SaveChanges(); string path = System.IO.Path.Combine(fileLocation, fileName); if (createPhysicalFile) { System.IO.Directory.CreateDirectory(fileLocation); if (!System.IO.File.Exists(path)) { using (System.IO.FileStream fs = System.IO.File.Create(path)) { for (byte i = 0; i < 100; i++) { fs.WriteByte(i); } } } } return(UD); }
public async Task <uploaded_data> CreateUploadedData(string checkSum, string currentFile, string extension, string fileLocation, string fileName, short?local, workers worker, string uploaderType, int version, bool createPhysicalFile) { uploaded_data UD = new uploaded_data(); UD.Checksum = checkSum; UD.CreatedAt = DateTime.UtcNow; UD.CurrentFile = currentFile; UD.ExpirationDate = DateTime.Now.AddYears(1); UD.Extension = extension; UD.FileLocation = fileLocation; UD.FileName = fileName; UD.Local = local; UD.UpdatedAt = DateTime.UtcNow; UD.UploaderId = worker.Id; UD.UploaderType = uploaderType; UD.Version = version; UD.WorkflowState = Constants.WorkflowStates.Created; dbContext.uploaded_data.Add(UD); await dbContext.SaveChangesAsync().ConfigureAwait(false); string path = System.IO.Path.Combine(fileLocation, fileName); if (createPhysicalFile) { System.IO.Directory.CreateDirectory(fileLocation); if (!System.IO.File.Exists(path)) { using (System.IO.FileStream fs = System.IO.File.Create(path)) { for (byte i = 0; i < 100; i++) { fs.WriteByte(i); } } } } return(UD); }
public uploaded_data CreateUploadedData(string checkSum, string currentFile, string extension, string fileLocation, string fileName, short?local, workers worker, string uploaderType, int version) { uploaded_data UD = new uploaded_data(); UD.checksum = checkSum; UD.created_at = DateTime.Now; UD.current_file = currentFile; UD.expiration_date = DateTime.Now.AddYears(1); UD.extension = extension; UD.file_location = fileLocation; UD.file_name = fileName; UD.local = local; UD.updated_at = DateTime.Now; UD.uploader_id = worker.id; UD.uploader_type = uploaderType; UD.version = version; UD.workflow_state = Constants.WorkflowStates.Created; DbContext.uploaded_data.Add(UD); DbContext.SaveChanges(); return(UD); }
public void SQL_File_FileRead_doesFileRead() { uploaded_data ud = new uploaded_data(); ud.checksum = "checksum1"; ud.extension = "extension"; ud.current_file = "currentFile1"; ud.uploader_id = 223; ud.uploader_type = "uploader_type"; ud.file_location = "file_location"; ud.file_name = "fileName"; //ud.id = 111; ud.workflow_state = Constants.WorkflowStates.PreCreated; DbContext.uploaded_data.Add(ud); DbContext.SaveChanges(); // Act UploadedData Ud = sut.FileRead(); // Assert Assert.NotNull(ud); Assert.NotNull(Ud); Assert.AreEqual(Ud.Checksum, ud.checksum); Assert.AreEqual(Ud.Extension, ud.extension); Assert.AreEqual(Ud.CurrentFile, ud.current_file); Assert.AreEqual(Ud.UploaderId, ud.uploader_id); Assert.AreEqual(Ud.UploaderType, ud.uploader_type); Assert.AreEqual(Ud.FileLocation, ud.file_location); Assert.AreEqual(Ud.FileName, ud.file_name); Assert.AreEqual(Ud.Id, ud.id); Assert.AreEqual(Constants.WorkflowStates.PreCreated, ud.workflow_state); }
public async Task FieldValues_Delete_DoesSetWorkflowStateToRemoved() { short shortMinValue = Int16.MinValue; short shortmaxValue = Int16.MaxValue; Random rnd = new Random(); bool randomBool = rnd.Next(0, 2) > 0; sites site = new sites { Name = Guid.NewGuid().ToString(), MicrotingUid = rnd.Next(1, 255) }; await site.Create(dbContext).ConfigureAwait(false); units unit = new units { CustomerNo = rnd.Next(1, 255), MicrotingUid = rnd.Next(1, 255), OtpCode = rnd.Next(1, 255), SiteId = site.Id }; await unit.Create(dbContext).ConfigureAwait(false); check_lists checklist = new check_lists { Color = Guid.NewGuid().ToString(), Custom = Guid.NewGuid().ToString(), Description = Guid.NewGuid().ToString(), Field1 = rnd.Next(1, 255), Field2 = rnd.Next(1, 255), Field4 = rnd.Next(1, 255), Field5 = rnd.Next(1, 255), Field6 = rnd.Next(1, 255), Field7 = rnd.Next(1, 255), Field8 = rnd.Next(1, 255), Field9 = rnd.Next(1, 255), Field10 = rnd.Next(1, 255), Label = Guid.NewGuid().ToString(), Repeated = rnd.Next(1, 255), ApprovalEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), CaseType = Guid.NewGuid().ToString(), DisplayIndex = rnd.Next(1, 255), DownloadEntities = (short)rnd.Next(shortMinValue, shortmaxValue), FastNavigation = (short)rnd.Next(shortMinValue, shortmaxValue), FolderName = Guid.NewGuid().ToString(), ManualSync = (short)rnd.Next(shortMinValue, shortmaxValue), MultiApproval = (short)rnd.Next(shortMinValue, shortmaxValue), OriginalId = Guid.NewGuid().ToString(), ReviewEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), DocxExportEnabled = randomBool, DoneButtonEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), ExtraFieldsEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), JasperExportEnabled = randomBool, QuickSyncEnabled = (short)rnd.Next(shortMinValue, shortmaxValue) }; await checklist.Create(dbContext).ConfigureAwait(false); entity_groups entityGroup = new entity_groups { Name = Guid.NewGuid().ToString(), Type = Guid.NewGuid().ToString(), MicrotingUid = Guid.NewGuid().ToString() }; await entityGroup.Create(dbContext).ConfigureAwait(false); field_types fieldType = new field_types { Description = Guid.NewGuid().ToString(), FieldType = Guid.NewGuid().ToString() }; await fieldType.Create(dbContext).ConfigureAwait(false); fields field = new fields { Color = Guid.NewGuid().ToString(), Custom = Guid.NewGuid().ToString(), Description = Guid.NewGuid().ToString(), Dummy = (short)rnd.Next(shortMinValue, shortmaxValue), Label = Guid.NewGuid().ToString(), Mandatory = (short)rnd.Next(shortMinValue, shortmaxValue), Multi = rnd.Next(1, 255), Optional = (short)rnd.Next(shortMinValue, shortmaxValue), Selected = (short)rnd.Next(shortMinValue, shortmaxValue), BarcodeEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), BarcodeType = Guid.NewGuid().ToString(), DecimalCount = rnd.Next(1, 255), DefaultValue = Guid.NewGuid().ToString(), DisplayIndex = rnd.Next(1, 255), GeolocationEnabled = (short)rnd.Next(shortMinValue, shortmaxValue), GeolocationForced = (short)rnd.Next(shortMinValue, shortmaxValue), GeolocationHidden = (short)rnd.Next(shortMinValue, shortmaxValue), IsNum = (short)rnd.Next(shortMinValue, shortmaxValue), MaxLength = rnd.Next(1, 255), MaxValue = Guid.NewGuid().ToString(), MinValue = Guid.NewGuid().ToString(), OriginalId = Guid.NewGuid().ToString(), QueryType = Guid.NewGuid().ToString(), ReadOnly = (short)rnd.Next(shortMinValue, shortmaxValue), SplitScreen = (short)rnd.Next(shortMinValue, shortmaxValue), UnitName = Guid.NewGuid().ToString(), StopOnSave = (short)rnd.Next(shortMinValue, shortmaxValue), KeyValuePairList = Guid.NewGuid().ToString(), CheckListId = checklist.Id, EntityGroupId = entityGroup.Id, FieldTypeId = fieldType.Id }; await field.Create(dbContext).ConfigureAwait(false); workers worker = new workers { Email = Guid.NewGuid().ToString(), FirstName = Guid.NewGuid().ToString(), LastName = Guid.NewGuid().ToString(), MicrotingUid = rnd.Next(1, 255) }; await worker.Create(dbContext).ConfigureAwait(false); cases theCase = new cases { Custom = Guid.NewGuid().ToString(), Status = rnd.Next(1, 255), Type = Guid.NewGuid().ToString(), CaseUid = Guid.NewGuid().ToString(), DoneAt = DateTime.Now, FieldValue1 = Guid.NewGuid().ToString(), FieldValue2 = Guid.NewGuid().ToString(), FieldValue3 = Guid.NewGuid().ToString(), FieldValue4 = Guid.NewGuid().ToString(), FieldValue5 = Guid.NewGuid().ToString(), FieldValue6 = Guid.NewGuid().ToString(), FieldValue7 = Guid.NewGuid().ToString(), FieldValue8 = Guid.NewGuid().ToString(), FieldValue9 = Guid.NewGuid().ToString(), FieldValue10 = Guid.NewGuid().ToString(), MicrotingUid = rnd.Next(shortMinValue, shortmaxValue), SiteId = site.Id, UnitId = unit.Id, WorkerId = worker.Id, CheckListId = checklist.Id, MicrotingCheckUid = rnd.Next(shortMinValue, shortmaxValue) }; await theCase.Create(dbContext).ConfigureAwait(false); uploaded_data uploadedData = new uploaded_data { Checksum = Guid.NewGuid().ToString(), Extension = Guid.NewGuid().ToString(), Local = (short)rnd.Next(shortMinValue, shortmaxValue), CurrentFile = Guid.NewGuid().ToString(), ExpirationDate = DateTime.Now, FileLocation = Guid.NewGuid().ToString(), FileName = Guid.NewGuid().ToString(), TranscriptionId = rnd.Next(1, 255), UploaderId = rnd.Next(1, 255), UploaderType = Guid.NewGuid().ToString() }; await uploadedData.Create(dbContext).ConfigureAwait(false); field_values fieldValue = new field_values { Accuracy = Guid.NewGuid().ToString(), Altitude = Guid.NewGuid().ToString(), Date = DateTime.Now, Heading = Guid.NewGuid().ToString(), Latitude = Guid.NewGuid().ToString(), Longitude = Guid.NewGuid().ToString(), Value = Guid.NewGuid().ToString(), CaseId = theCase.Id, DoneAt = DateTime.Now, FieldId = field.Id, WorkerId = worker.Id, CheckListId = checklist.Id, UploadedDataId = uploadedData.Id }; await fieldValue.Create(dbContext).ConfigureAwait(false); //Act DateTime?oldUpdatedAt = fieldValue.UpdatedAt; await fieldValue.Delete(dbContext); List <field_values> fieldValues = dbContext.field_values.AsNoTracking().ToList(); List <field_value_versions> fieldValueVersions = dbContext.field_value_versions.AsNoTracking().ToList(); Assert.NotNull(fieldValues); Assert.NotNull(fieldValueVersions); Assert.AreEqual(1, fieldValues.Count()); Assert.AreEqual(2, fieldValueVersions.Count()); Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValues[0].CreatedAt.ToString()); Assert.AreEqual(fieldValue.Version, fieldValues[0].Version); // Assert.AreEqual(fieldValue.UpdatedAt.ToString(), fieldValues[0].UpdatedAt.ToString()); Assert.AreEqual(fieldValues[0].WorkflowState, Constants.WorkflowStates.Removed); Assert.AreEqual(fieldValue.Id, fieldValues[0].Id); Assert.AreEqual(fieldValue.Accuracy, fieldValues[0].Accuracy); Assert.AreEqual(fieldValue.Date.ToString(), fieldValues[0].Date.ToString()); Assert.AreEqual(fieldValue.Heading, fieldValues[0].Heading); Assert.AreEqual(fieldValue.Latitude, fieldValues[0].Latitude); Assert.AreEqual(fieldValue.Longitude, fieldValues[0].Longitude); Assert.AreEqual(fieldValue.Value, fieldValues[0].Value); Assert.AreEqual(fieldValue.CaseId, theCase.Id); Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValues[0].DoneAt.ToString()); Assert.AreEqual(fieldValue.FieldId, field.Id); Assert.AreEqual(fieldValue.WorkerId, worker.Id); Assert.AreEqual(fieldValue.CheckListId, checklist.Id); Assert.AreEqual(fieldValue.UploadedDataId, uploadedData.Id); //Old Version Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValueVersions[0].CreatedAt.ToString()); Assert.AreEqual(1, fieldValueVersions[0].Version); // Assert.AreEqual(oldUpdatedAt.ToString(), fieldValueVersions[0].UpdatedAt.ToString()); Assert.AreEqual(fieldValueVersions[0].WorkflowState, Constants.WorkflowStates.Created); Assert.AreEqual(fieldValue.Id, fieldValueVersions[0].FieldId); Assert.AreEqual(fieldValue.Accuracy, fieldValueVersions[0].Accuracy); Assert.AreEqual(fieldValue.Date.ToString(), fieldValueVersions[0].Date.ToString()); Assert.AreEqual(fieldValue.Heading, fieldValueVersions[0].Heading); Assert.AreEqual(fieldValue.Latitude, fieldValueVersions[0].Latitude); Assert.AreEqual(fieldValue.Longitude, fieldValueVersions[0].Longitude); Assert.AreEqual(fieldValue.Value, fieldValueVersions[0].Value); Assert.AreEqual(theCase.Id, fieldValueVersions[0].CaseId); Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValueVersions[0].DoneAt.ToString()); Assert.AreEqual(field.Id, fieldValueVersions[0].FieldId); Assert.AreEqual(worker.Id, fieldValueVersions[0].WorkerId); Assert.AreEqual(checklist.Id, fieldValueVersions[0].CheckListId); Assert.AreEqual(uploadedData.Id, fieldValueVersions[0].UploadedDataId); //New Version Assert.AreEqual(fieldValue.CreatedAt.ToString(), fieldValueVersions[1].CreatedAt.ToString()); Assert.AreEqual(2, fieldValueVersions[1].Version); // Assert.AreEqual(fieldValue.UpdatedAt.ToString(), fieldValueVersions[1].UpdatedAt.ToString()); Assert.AreEqual(fieldValueVersions[1].WorkflowState, Constants.WorkflowStates.Removed); Assert.AreEqual(fieldValue.Id, fieldValueVersions[1].FieldId); Assert.AreEqual(fieldValue.Accuracy, fieldValueVersions[1].Accuracy); Assert.AreEqual(fieldValue.Date.ToString(), fieldValueVersions[1].Date.ToString()); Assert.AreEqual(fieldValue.Heading, fieldValueVersions[1].Heading); Assert.AreEqual(fieldValue.Latitude, fieldValueVersions[1].Latitude); Assert.AreEqual(fieldValue.Longitude, fieldValueVersions[1].Longitude); Assert.AreEqual(fieldValue.Value, fieldValueVersions[1].Value); Assert.AreEqual(theCase.Id, fieldValueVersions[1].CaseId); Assert.AreEqual(fieldValue.DoneAt.ToString(), fieldValueVersions[1].DoneAt.ToString()); Assert.AreEqual(field.Id, fieldValueVersions[1].FieldId); Assert.AreEqual(worker.Id, fieldValueVersions[1].WorkerId); Assert.AreEqual(checklist.Id, fieldValueVersions[1].CheckListId); Assert.AreEqual(uploadedData.Id, fieldValueVersions[1].UploadedDataId); }
public void SQL_Check_CheckListValueStatusRead_ReturnsCheckListValuesStatus() { // Arrance #region Arrance #region Template1 DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1); #endregion #region SubTemplate1 check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1); #endregion #region Fields #region field1 fields f1 = testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description", 5, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0, 0, 0, "", 49); #endregion #region field2 fields f2 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description", 45, 1, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 1, 0, 0, "ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9); #endregion #region field3 fields f3 = testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description", 83, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1); #endregion #region field4 fields f4 = testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description", 84, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 1, 0, "Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field5 fields f5 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 85, 0, DbContext.field_types.Where(x => x.field_type == "picture").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #endregion #region Worker workers worker = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region site sites site = testHelpers.CreateSite("SiteName", 88); #endregion #region units units unit = testHelpers.CreateUnit(48, 49, site, 348); #endregion #region site_workers site_workers site_workers = testHelpers.CreateSiteWorker(55, site, worker); #endregion #region Case1 cases aCase = testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now, worker, "microtingCheckUId", "microtingUId", site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created); #endregion #region UploadedData #region ud1 uploaded_data ud1 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File1", 1, worker, "local", 55, false); #endregion #region ud2 uploaded_data ud2 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File2", 1, worker, "local", 55, false); #endregion #region ud3 uploaded_data ud3 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File3", 1, worker, "local", 55, false); #endregion #region ud4 uploaded_data ud4 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File4", 1, worker, "local", 55, false); #endregion #region ud5 uploaded_data ud5 = testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File5", 1, worker, "local", 55, false); #endregion #endregion #region Check List Values check_list_values check_List_Values = testHelpers.CreateCheckListValue(aCase, cl2, "checked", null, 865); #endregion #region Field Values #region fv1 field_values field_Value1 = testHelpers.CreateFieldValue(aCase, cl2, f1, ud1.id, null, "tomt1", 61234, worker); #endregion #region fv2 field_values field_Value2 = testHelpers.CreateFieldValue(aCase, cl2, f2, ud2.id, null, "tomt2", 61234, worker); #endregion #region fv3 field_values field_Value3 = testHelpers.CreateFieldValue(aCase, cl2, f3, ud3.id, null, "tomt3", 61234, worker); #endregion #region fv4 field_values field_Value4 = testHelpers.CreateFieldValue(aCase, cl2, f4, ud4.id, null, "tomt4", 61234, worker); #endregion #region fv5 field_values field_Value5 = testHelpers.CreateFieldValue(aCase, cl2, f5, ud5.id, null, "tomt5", 61234, worker); #endregion #endregion #endregion // Act var match = sut.CheckListValueStatusRead(aCase.id, cl2.id); // Assert Assert.AreEqual(check_List_Values.status, "checked"); }
public async Task SQL_Check_FieldValueRead_ReturnsAnswer() { // Arrance #region Arrance Random rnd = new Random(); #region Template1 DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1); #endregion #region SubTemplate1 check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1); #endregion #region Fields #region field1 fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description", 5, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0, 0, 0, "", 49); #endregion #region field2 fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description", 45, 1, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 1, 0, 0, "ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9); #endregion #region field3 fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description", 83, 0, dbContext.field_types.Where(x => x.FieldType == "number").First(), 0, 0, 1, 0, "Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1); #endregion #region field4 fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description", 84, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 0, 0, 1, 0, "Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field5 fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 85, 0, dbContext.field_types.Where(x => x.FieldType == "comment").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #endregion #region Worker workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region site sites site = await testHelpers.CreateSite("SiteName", 88); #endregion #region units units unit = await testHelpers.CreateUnit(48, 49, site, 348); #endregion #region site_workers site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker); #endregion #region Case1 cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now, worker, rnd.Next(1, 255), rnd.Next(1, 255), site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created); #endregion #region Check List Values check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865); #endregion #region UploadedData uploaded_data ud = await testHelpers.CreateUploadedData("checksum", "File1", "no", "mappe", "File1", 1, worker, "local", 55, false); #endregion #region Field Values #region fv1 field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, ud.Id, null, "tomt1", 61234, worker); #endregion #region fv2 field_values field_Value2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker); #endregion #region fv3 field_values field_Value3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker); #endregion #region fv4 field_values field_Value4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker); #endregion #region fv5 field_values field_Value5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker); #endregion #endregion #endregion // Act var match = await sut.FieldValueRead(field_Value1, false); // Assert #region Assert Assert.True(match is FieldValue); Assert.AreEqual(field_Value1.Accuracy, match.Accuracy); Assert.AreEqual(field_Value1.Altitude, match.Altitude); // Assert.AreEqual(field_Value1.case_id, match.case_id); // Assert.AreEqual(field_Value1.check_list, match.check_list); // Assert.AreEqual(field_Value1.check_list_duplicate_id, match.check_list_duplicate_id); // Assert.AreEqual(field_Value1.check_list_id, match.check_list_id); // Assert.AreEqual(field_Value1.created_at, match.created_at); Assert.AreEqual(field_Value1.Date, match.Date); // Assert.AreEqual(field_Value1.done_at, match.done_at); Assert.AreEqual(field_Value1.Field, f1); Assert.AreEqual(field_Value1.FieldId, match.FieldId); Assert.AreEqual(field_Value1.Heading, match.Heading); Assert.AreEqual(field_Value1.Id, match.Id); Assert.AreEqual(field_Value1.Latitude, match.Latitude); Assert.AreEqual(field_Value1.Longitude, match.Longitude); // Assert.AreEqual(field_Value1.updated_at, match.updated_at); // Assert.AreEqual("mappeFile1", match.UploadedData); Assert.AreEqual(field_Value1.UploadedData.Checksum, match.UploadedDataObj.Checksum); Assert.AreEqual(field_Value1.UploadedData.CurrentFile, match.UploadedDataObj.CurrentFile); Assert.AreEqual(field_Value1.UploadedData.Extension, match.UploadedDataObj.Extension); Assert.AreEqual(field_Value1.UploadedData.FileLocation, match.UploadedDataObj.FileLocation); Assert.AreEqual(field_Value1.UploadedData.FileName, match.UploadedDataObj.FileName); Assert.AreEqual(field_Value1.UploadedData.Id, match.UploadedDataObj.Id); Assert.AreEqual(field_Value1.UploadedData.UploaderId, match.UploadedDataObj.UploaderId); Assert.AreEqual(field_Value1.UploadedData.UploaderType, match.UploadedDataObj.UploaderType); // Assert.AreEqual(field_Value1.user_id, match.user_id); Assert.AreEqual(field_Value1.Value, match.Value); // Assert.AreEqual(field_Value1.version, match.version); // Assert.AreEqual(field_Value1.worker, match.worker); // Assert.AreEqual(field_Value1.workflow_state, match.workflow_state); #endregion }
public async Task SQL_Check_CheckListValueStatusUpdate_UpdatesCheckListValues() { // Arrance #region Arrance Random rnd = new Random(); #region Template1 DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A", "D", "CheckList", "Template1FolderName", 1, 1); #endregion #region SubTemplate1 check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1); #endregion #region Fields #region field1 fields f1 = await testHelpers.CreateField(1, "barcode", cl2, "e2f4fb", "custom", null, "", "Comment field description", 5, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Comment field", 1, 55, "55", "0", 0, 0, null, 1, 0, 0, 0, "", 49); #endregion #region field2 fields f2 = await testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description", 45, 1, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 1, 0, 0, "ShowPdf", 0, 5, "5", "0", 0, 0, null, 0, 0, 0, 0, "", 9); #endregion #region field3 fields f3 = await testHelpers.CreateField(0, "barcode", cl2, "f0f8db", "custom", 3, "", "Number Field Description", 83, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Numberfield", 1, 8, "4865", "0", 0, 1, null, 1, 0, 0, 0, "", 1); #endregion #region field4 fields f4 = await testHelpers.CreateField(1, "barcode", cl2, "fff6df", "custom", null, "", "date Description", 84, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 0, 0, 1, 0, "Date", 1, 666, "41153", "0", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field5 fields f5 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 85, 0, dbContext.field_types.Where(x => x.FieldType == "picture").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #endregion #region Worker workers worker = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region site sites site = await testHelpers.CreateSite("SiteName", 88); #endregion #region units units unit = await testHelpers.CreateUnit(48, 49, site, 348); #endregion #region site_workers site_workers site_workers = await testHelpers.CreateSiteWorker(55, site, worker); #endregion #region Case1 cases aCase = await testHelpers.CreateCase("caseUId", cl1, DateTime.Now, "custom", DateTime.Now, worker, rnd.Next(1, 255), rnd.Next(1, 255), site, 66, "caseType", unit, DateTime.Now, 1, worker, Constants.WorkflowStates.Created); #endregion #region UploadedData #region ud1 uploaded_data ud1 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File1", 1, worker, "local", 55, false); #endregion #region ud2 uploaded_data ud2 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File2", 1, worker, "local", 55, false); #endregion #region ud3 uploaded_data ud3 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File3", 1, worker, "local", 55, false); #endregion #region ud4 uploaded_data ud4 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File4", 1, worker, "local", 55, false); #endregion #region ud5 uploaded_data ud5 = await testHelpers.CreateUploadedData("checksum", "File1", "no", "hjgjghjhg", "File5", 1, worker, "local", 55, false); #endregion #endregion #region Check List Values check_list_values check_List_Values = await testHelpers.CreateCheckListValue(aCase, cl2, "checked", null, 865); #endregion #region Field Values #region fv1 field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, ud1.Id, null, "tomt1", 61234, worker); #endregion #region fv2 field_values field_Value2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, ud2.Id, null, "tomt2", 61234, worker); #endregion #region fv3 field_values field_Value3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, ud3.Id, null, "tomt3", 61234, worker); #endregion #region fv4 field_values field_Value4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, ud4.Id, null, "tomt4", 61234, worker); #endregion #region fv5 field_values field_Value5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, ud5.Id, null, "tomt5", 61234, worker); #endregion #endregion #endregion // Act await sut.CheckListValueStatusUpdate(aCase.Id, cl2.Id, "not_approved"); // Assert var newValue = await dbContext.check_list_values.AsNoTracking().SingleOrDefaultAsync(x => x.Id == check_List_Values.Id); Assert.AreEqual(newValue.Status, "not_approved"); }
public async Task UploadedData_Update_DoesUpdate() { //Arrange Random rnd = new Random(); short minValue = Int16.MinValue; short maxValue = Int16.MaxValue; uploaded_data uploadedData = new uploaded_data { Checksum = Guid.NewGuid().ToString(), Extension = Guid.NewGuid().ToString(), Local = (short)rnd.Next(minValue, maxValue), CurrentFile = Guid.NewGuid().ToString(), ExpirationDate = DateTime.Now, FileLocation = Guid.NewGuid().ToString(), FileName = Guid.NewGuid().ToString(), TranscriptionId = rnd.Next(1, 255), UploaderId = rnd.Next(1, 255), UploaderType = Guid.NewGuid().ToString() }; await uploadedData.Create(dbContext).ConfigureAwait(false); //Act DateTime?oldUpdatedAt = uploadedData.UpdatedAt; string oldCheckSum = uploadedData.Checksum; string oldExtension = uploadedData.Extension; short oldLocal = (short)uploadedData.Local; string oldCurrentFile = uploadedData.CurrentFile; DateTime?oldExpirationDate = uploadedData.ExpirationDate; string oldFileLocation = uploadedData.FileLocation; string oldFileName = uploadedData.FileName; int? oldTranscriptionId = uploadedData.TranscriptionId; int? oldUploaderId = uploadedData.UploaderId; string oldUploaderType = uploadedData.UploaderType; uploadedData.Checksum = Guid.NewGuid().ToString(); uploadedData.Extension = Guid.NewGuid().ToString(); uploadedData.Local = (short)rnd.Next(minValue, maxValue); uploadedData.CurrentFile = Guid.NewGuid().ToString(); uploadedData.ExpirationDate = DateTime.Now; uploadedData.FileLocation = Guid.NewGuid().ToString(); uploadedData.FileName = Guid.NewGuid().ToString(); uploadedData.TranscriptionId = rnd.Next(1, 255); uploadedData.UploaderId = rnd.Next(1, 255); uploadedData.UploaderType = Guid.NewGuid().ToString(); await uploadedData.Update(dbContext).ConfigureAwait(false); List <uploaded_data> uploadedDatas = dbContext.uploaded_data.AsNoTracking().ToList(); List <uploaded_data_versions> uploadedDataVersions = dbContext.uploaded_data_versions.AsNoTracking().ToList(); //Assert Assert.NotNull(uploadedDatas); Assert.NotNull(uploadedDataVersions); Assert.AreEqual(1, uploadedDatas.Count()); Assert.AreEqual(2, uploadedDataVersions.Count()); Assert.AreEqual(uploadedData.CreatedAt.ToString(), uploadedDatas[0].CreatedAt.ToString()); Assert.AreEqual(uploadedData.Version, uploadedDatas[0].Version); // Assert.AreEqual(uploadedData.UpdatedAt.ToString(), uploadedDatas[0].UpdatedAt.ToString()); Assert.AreEqual(uploadedData.Checksum, uploadedDatas[0].Checksum); Assert.AreEqual(uploadedData.Extension, uploadedDatas[0].Extension); Assert.AreEqual(uploadedData.Local, uploadedDatas[0].Local); Assert.AreEqual(uploadedData.CurrentFile, uploadedDatas[0].CurrentFile); Assert.AreEqual(uploadedData.ExpirationDate.ToString(), uploadedDatas[0].ExpirationDate.ToString()); Assert.AreEqual(uploadedData.FileLocation, uploadedDatas[0].FileLocation); Assert.AreEqual(uploadedData.FileName, uploadedDatas[0].FileName); Assert.AreEqual(uploadedData.TranscriptionId, uploadedDatas[0].TranscriptionId); Assert.AreEqual(uploadedData.UploaderId, uploadedDatas[0].UploaderId); Assert.AreEqual(uploadedData.UploaderType, uploadedDatas[0].UploaderType); //Version 1 Old Version Assert.AreEqual(uploadedData.CreatedAt.ToString(), uploadedDataVersions[0].CreatedAt.ToString()); Assert.AreEqual(1, uploadedDataVersions[0].Version); // Assert.AreEqual(oldUpdatedAt.ToString(), uploadedDataVersions[0].UpdatedAt.ToString()); Assert.AreEqual(oldCheckSum, uploadedDataVersions[0].Checksum); Assert.AreEqual(oldExtension, uploadedDataVersions[0].Extension); Assert.AreEqual(oldLocal, uploadedDataVersions[0].Local); Assert.AreEqual(oldCurrentFile, uploadedDataVersions[0].CurrentFile); Assert.AreEqual(oldExpirationDate.ToString(), uploadedDataVersions[0].ExpirationDate.ToString()); Assert.AreEqual(oldFileLocation, uploadedDataVersions[0].FileLocation); Assert.AreEqual(oldFileName, uploadedDataVersions[0].FileName); Assert.AreEqual(oldTranscriptionId, uploadedDataVersions[0].TranscriptionId); Assert.AreEqual(oldUploaderId, uploadedDataVersions[0].UploaderId); Assert.AreEqual(oldUploaderType, uploadedDataVersions[0].UploaderType); //Version 2 Updated Version Assert.AreEqual(uploadedData.CreatedAt.ToString(), uploadedDataVersions[1].CreatedAt.ToString()); Assert.AreEqual(2, uploadedDataVersions[1].Version); // Assert.AreEqual(uploadedData.UpdatedAt.ToString(), uploadedDataVersions[1].UpdatedAt.ToString()); Assert.AreEqual(uploadedData.Checksum, uploadedDataVersions[1].Checksum); Assert.AreEqual(uploadedData.Extension, uploadedDataVersions[1].Extension); Assert.AreEqual(uploadedData.Local, uploadedDataVersions[1].Local); Assert.AreEqual(uploadedData.CurrentFile, uploadedDataVersions[1].CurrentFile); Assert.AreEqual(uploadedData.ExpirationDate.ToString(), uploadedDataVersions[1].ExpirationDate.ToString()); Assert.AreEqual(uploadedData.FileLocation, uploadedDataVersions[1].FileLocation); Assert.AreEqual(uploadedData.FileName, uploadedDataVersions[1].FileName); Assert.AreEqual(uploadedData.TranscriptionId, uploadedDataVersions[1].TranscriptionId); Assert.AreEqual(uploadedData.UploaderId, uploadedDataVersions[1].UploaderId); Assert.AreEqual(uploadedData.UploaderType, uploadedDataVersions[1].UploaderType); }
public async Task UploadedData_Create_DoesCreate() { //Arrange Random rnd = new Random(); short minValue = Int16.MinValue; short maxValue = Int16.MaxValue; uploaded_data uploadedData = new uploaded_data { Checksum = Guid.NewGuid().ToString(), Extension = Guid.NewGuid().ToString(), Local = (short)rnd.Next(minValue, maxValue), CurrentFile = Guid.NewGuid().ToString(), ExpirationDate = DateTime.Now, FileLocation = Guid.NewGuid().ToString(), FileName = Guid.NewGuid().ToString(), TranscriptionId = rnd.Next(1, 255), UploaderId = rnd.Next(1, 255), UploaderType = Guid.NewGuid().ToString() }; //Act await uploadedData.Create(dbContext).ConfigureAwait(false); List <uploaded_data> uploadedDatas = dbContext.uploaded_data.AsNoTracking().ToList(); List <uploaded_data_versions> uploadedDataVersions = dbContext.uploaded_data_versions.AsNoTracking().ToList(); //Assert Assert.NotNull(uploadedDatas); Assert.NotNull(uploadedDataVersions); Assert.AreEqual(1, uploadedDatas.Count()); Assert.AreEqual(1, uploadedDataVersions.Count()); Assert.AreEqual(uploadedData.CreatedAt.ToString(), uploadedDatas[0].CreatedAt.ToString()); Assert.AreEqual(uploadedData.Version, uploadedDatas[0].Version); // Assert.AreEqual(uploadedData.UpdatedAt.ToString(), uploadedDatas[0].UpdatedAt.ToString()); Assert.AreEqual(uploadedDatas[0].WorkflowState, Constants.WorkflowStates.Created); Assert.AreEqual(uploadedData.Checksum, uploadedDatas[0].Checksum); Assert.AreEqual(uploadedData.Extension, uploadedDatas[0].Extension); Assert.AreEqual(uploadedData.Local, uploadedDatas[0].Local); Assert.AreEqual(uploadedData.CurrentFile, uploadedDatas[0].CurrentFile); Assert.AreEqual(uploadedData.ExpirationDate.ToString(), uploadedDatas[0].ExpirationDate.ToString()); Assert.AreEqual(uploadedData.FileLocation, uploadedDatas[0].FileLocation); Assert.AreEqual(uploadedData.FileName, uploadedDatas[0].FileName); Assert.AreEqual(uploadedData.TranscriptionId, uploadedDatas[0].TranscriptionId); Assert.AreEqual(uploadedData.UploaderId, uploadedDatas[0].UploaderId); Assert.AreEqual(uploadedData.UploaderType, uploadedDatas[0].UploaderType); //Versions Assert.AreEqual(uploadedData.CreatedAt.ToString(), uploadedDataVersions[0].CreatedAt.ToString()); Assert.AreEqual(uploadedData.Version, uploadedDataVersions[0].Version); // Assert.AreEqual(uploadedData.UpdatedAt.ToString(), uploadedDataVersions[0].UpdatedAt.ToString()); Assert.AreEqual(uploadedDataVersions[0].WorkflowState, Constants.WorkflowStates.Created); Assert.AreEqual(uploadedData.Checksum, uploadedDataVersions[0].Checksum); Assert.AreEqual(uploadedData.Extension, uploadedDataVersions[0].Extension); Assert.AreEqual(uploadedData.Local, uploadedDataVersions[0].Local); Assert.AreEqual(uploadedData.CurrentFile, uploadedDataVersions[0].CurrentFile); Assert.AreEqual(uploadedData.ExpirationDate.ToString(), uploadedDataVersions[0].ExpirationDate.ToString()); Assert.AreEqual(uploadedData.FileLocation, uploadedDataVersions[0].FileLocation); Assert.AreEqual(uploadedData.FileName, uploadedDataVersions[0].FileName); Assert.AreEqual(uploadedData.UploaderId, uploadedDataVersions[0].UploaderId); Assert.AreEqual(uploadedData.UploaderType, uploadedDataVersions[0].UploaderType); Assert.AreEqual(uploadedData.TranscriptionId, uploadedDataVersions[0].TranscriptionId); }