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);
}
