public check_list_values CreateCheckListValue(cases aCase, check_lists checkList, string status, int?userId, int?version)
{
check_list_values CLV = new check_list_values();
CLV.case_id = aCase.id;
CLV.check_list_id = checkList.id;
CLV.created_at = DateTime.Now;
CLV.status = status;
CLV.updated_at = DateTime.Now;
CLV.user_id = userId;
CLV.version = version;
CLV.workflow_state = Constants.WorkflowStates.Created;
DbContext.check_list_values.Add(CLV);
DbContext.SaveChanges();
return(CLV);
}
public async Task <check_list_values> CreateCheckListValue(cases aCase, check_lists checkList, string status, int?userId, int?version)
{
check_list_values CLV = new check_list_values();
CLV.CaseId = aCase.Id;
CLV.CheckListId = checkList.Id;
CLV.CreatedAt = DateTime.UtcNow;
CLV.Status = status;
CLV.UpdatedAt = DateTime.UtcNow;
CLV.UserId = userId;
CLV.Version = version;
CLV.WorkflowState = Constants.WorkflowStates.Created;
dbContext.check_list_values.Add(CLV);
await dbContext.SaveChangesAsync().ConfigureAwait(false);
return(CLV);
}
public async Task SQL_Check_CheckRead_ReturnsReplyElement()
{
// 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 Field Values
#region fv1
field_values field_Values1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Values2 = await testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Values3 = await testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Values4 = await testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Values5 = await testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
ReplyElement match = await sut.CheckRead((int)aCase.MicrotingUid, (int)aCase.MicrotingCheckUid);
// Assert
#region Assert
Assert.AreEqual(1, match.ElementList.Count());
CheckListValue clv = (CheckListValue)match.ElementList[0];
Assert.AreEqual(5, clv.DataItemList.Count);
#region casts
Field _f1 = (Field)clv.DataItemList[0];
Field _f2 = (Field)clv.DataItemList[1];
Field _f3 = (Field)clv.DataItemList[2];
Field _f4 = (Field)clv.DataItemList[3];
Field _f5 = (Field)clv.DataItemList[4];
#endregion
#region Barcode
Assert.AreEqual(f1.BarcodeEnabled, 1);
Assert.AreEqual(f2.BarcodeEnabled, 1);
Assert.AreEqual(f3.BarcodeEnabled, 0);
Assert.AreEqual(f4.BarcodeEnabled, 1);
Assert.AreEqual(f5.BarcodeEnabled, 0);
Assert.AreEqual(f1.BarcodeType, "barcode");
Assert.AreEqual(f2.BarcodeType, "barcode");
Assert.AreEqual(f3.BarcodeType, "barcode");
Assert.AreEqual(f4.BarcodeType, "barcode");
Assert.AreEqual(f5.BarcodeType, "barcode");
#endregion
#region chckl_id
Assert.AreEqual(f1.CheckListId, cl2.Id);
Assert.AreEqual(f2.CheckListId, cl2.Id);
Assert.AreEqual(f3.CheckListId, cl2.Id);
Assert.AreEqual(f4.CheckListId, cl2.Id);
Assert.AreEqual(f5.CheckListId, cl2.Id);
#endregion
#region Color
Assert.AreEqual(f1.Color, _f1.FieldValues[0].Color);
Assert.AreEqual(f2.Color, _f2.FieldValues[0].Color);
Assert.AreEqual(f3.Color, _f3.FieldValues[0].Color);
Assert.AreEqual(f4.Color, _f4.FieldValues[0].Color);
Assert.AreEqual(f5.Color, _f5.FieldValues[0].Color);
#endregion
#region custom
// Assert.AreEqual(f1.custom, _f1.FieldValues[0].Id);
#endregion
#region Decimal_Count
Assert.AreEqual(f1.DecimalCount, null);
Assert.AreEqual(f2.DecimalCount, null);
Assert.AreEqual(f3.DecimalCount, 3);
Assert.AreEqual(f4.DecimalCount, null);
Assert.AreEqual(f5.DecimalCount, null);
#endregion
#region Default_value
Assert.AreEqual(f1.DefaultValue, "");
Assert.AreEqual(f2.DefaultValue, "");
Assert.AreEqual(f3.DefaultValue, "");
Assert.AreEqual(f4.DefaultValue, "");
Assert.AreEqual(f5.DefaultValue, "");
#endregion
#region Description
CDataValue f1desc = (CDataValue)_f1.Description;
CDataValue f2desc = (CDataValue)_f2.Description;
CDataValue f3desc = (CDataValue)_f3.Description;
CDataValue f4desc = (CDataValue)_f4.Description;
CDataValue f5desc = (CDataValue)_f5.Description;
Assert.AreEqual(f1.Description, f1desc.InderValue);
Assert.AreEqual(f2.Description, f2desc.InderValue);
Assert.AreEqual(f3.Description, f3desc.InderValue);
Assert.AreEqual(f4.Description, f4desc.InderValue);
Assert.AreEqual(f5.Description, f5desc.InderValue);
#endregion
#region Displayindex
Assert.AreEqual(f1.DisplayIndex, _f1.FieldValues[0].DisplayOrder);
Assert.AreEqual(f2.DisplayIndex, _f2.FieldValues[0].DisplayOrder);
Assert.AreEqual(f3.DisplayIndex, _f3.FieldValues[0].DisplayOrder);
Assert.AreEqual(f4.DisplayIndex, _f4.FieldValues[0].DisplayOrder);
Assert.AreEqual(f5.DisplayIndex, _f5.FieldValues[0].DisplayOrder);
#endregion
#region Dummy
Assert.AreEqual(f1.Dummy, 1);
Assert.AreEqual(f2.Dummy, 1);
Assert.AreEqual(f3.Dummy, 0);
Assert.AreEqual(f4.Dummy, 0);
Assert.AreEqual(f5.Dummy, 0);
#endregion
#region geolocation
#region enabled
Assert.AreEqual(f1.GeolocationEnabled, 0);
Assert.AreEqual(f2.GeolocationEnabled, 0);
Assert.AreEqual(f3.GeolocationEnabled, 0);
Assert.AreEqual(f4.GeolocationEnabled, 0);
Assert.AreEqual(f5.GeolocationEnabled, 1);
#endregion
#region forced
Assert.AreEqual(f1.GeolocationForced, 0);
Assert.AreEqual(f2.GeolocationForced, 1);
Assert.AreEqual(f3.GeolocationForced, 0);
Assert.AreEqual(f4.GeolocationForced, 0);
Assert.AreEqual(f5.GeolocationForced, 0);
#endregion
#region hidden
Assert.AreEqual(f1.GeolocationHidden, 1);
Assert.AreEqual(f2.GeolocationHidden, 0);
Assert.AreEqual(f3.GeolocationHidden, 1);
Assert.AreEqual(f4.GeolocationHidden, 1);
Assert.AreEqual(f5.GeolocationHidden, 1);
#endregion
#endregion
#region isNum
Assert.AreEqual(f1.IsNum, 0);
Assert.AreEqual(f2.IsNum, 0);
Assert.AreEqual(f3.IsNum, 0);
Assert.AreEqual(f4.IsNum, 0);
Assert.AreEqual(f5.IsNum, 0);
#endregion
#region Label
Assert.AreEqual(f1.Label, _f1.Label);
Assert.AreEqual(f2.Label, _f2.Label);
Assert.AreEqual(f3.Label, _f3.Label);
Assert.AreEqual(f4.Label, _f4.Label);
Assert.AreEqual(f5.Label, _f5.Label);
#endregion
#region Mandatory
Assert.AreEqual(f1.Mandatory, 1);
Assert.AreEqual(f2.Mandatory, 0);
Assert.AreEqual(f3.Mandatory, 1);
Assert.AreEqual(f4.Mandatory, 1);
Assert.AreEqual(f5.Mandatory, 1);
#endregion
#region maxLength
Assert.AreEqual(f1.MaxLength, 55);
Assert.AreEqual(f2.MaxLength, 5);
Assert.AreEqual(f3.MaxLength, 8);
Assert.AreEqual(f4.MaxLength, 666);
Assert.AreEqual(f5.MaxLength, 69);
#endregion
#region min/max_Value
#region max
Assert.AreEqual(f1.MaxValue, "55");
Assert.AreEqual(f2.MaxValue, "5");
Assert.AreEqual(f3.MaxValue, "4865");
Assert.AreEqual(f4.MaxValue, "41153");
Assert.AreEqual(f5.MaxValue, "69");
#endregion
#region min
Assert.AreEqual(f1.MinValue, "0");
Assert.AreEqual(f2.MinValue, "0");
Assert.AreEqual(f3.MinValue, "0");
Assert.AreEqual(f4.MinValue, "0");
Assert.AreEqual(f5.MinValue, "1");
#endregion
#endregion
#region Multi
Assert.AreEqual(f1.Multi, 0);
Assert.AreEqual(f2.Multi, 0);
Assert.AreEqual(f3.Multi, 0);
Assert.AreEqual(f4.Multi, 0);
Assert.AreEqual(f5.Multi, 0);
#endregion
#region Optional
Assert.AreEqual(f1.Optional, 0);
Assert.AreEqual(f2.Optional, 0);
Assert.AreEqual(f3.Optional, 1);
Assert.AreEqual(f4.Optional, 1);
Assert.AreEqual(f5.Optional, 1);
#endregion
#region Query_Type
Assert.AreEqual(f1.QueryType, null);
Assert.AreEqual(f2.QueryType, null);
Assert.AreEqual(f3.QueryType, null);
Assert.AreEqual(f4.QueryType, null);
Assert.AreEqual(f5.QueryType, null);
#endregion
#region Read_Only
Assert.AreEqual(f1.ReadOnly, 1);
Assert.AreEqual(f2.ReadOnly, 0);
Assert.AreEqual(f3.ReadOnly, 1);
Assert.AreEqual(f4.ReadOnly, 0);
Assert.AreEqual(f5.ReadOnly, 0);
#endregion
#region Selected
Assert.AreEqual(f1.Selected, 0);
Assert.AreEqual(f2.Selected, 0);
Assert.AreEqual(f3.Selected, 0);
Assert.AreEqual(f4.Selected, 1);
Assert.AreEqual(f5.Selected, 1);
#endregion
#region Split_Screen
Assert.AreEqual(f1.SplitScreen, 0);
Assert.AreEqual(f2.SplitScreen, 0);
Assert.AreEqual(f3.SplitScreen, 0);
Assert.AreEqual(f4.SplitScreen, 0);
Assert.AreEqual(f5.SplitScreen, 0);
#endregion
#region Stop_On_Save
Assert.AreEqual(f1.StopOnSave, 0);
Assert.AreEqual(f2.StopOnSave, 0);
Assert.AreEqual(f3.StopOnSave, 0);
Assert.AreEqual(f4.StopOnSave, 0);
Assert.AreEqual(f5.StopOnSave, 0);
#endregion
#region Unit_Name
Assert.AreEqual(f1.UnitName, "");
Assert.AreEqual(f2.UnitName, "");
Assert.AreEqual(f3.UnitName, "");
Assert.AreEqual(f4.UnitName, "");
Assert.AreEqual(f5.UnitName, "");
#endregion
#region Values
Assert.AreEqual(1, _f1.FieldValues.Count());
Assert.AreEqual(1, _f2.FieldValues.Count());
Assert.AreEqual(1, _f3.FieldValues.Count());
Assert.AreEqual(1, _f4.FieldValues.Count());
Assert.AreEqual(1, _f5.FieldValues.Count());
Assert.AreEqual(field_Values1.Value, _f1.FieldValues[0].Value);
Assert.AreEqual(field_Values2.Value, _f2.FieldValues[0].Value);
Assert.AreEqual(field_Values3.Value, _f3.FieldValues[0].Value);
Assert.AreEqual(field_Values4.Value, _f4.FieldValues[0].Value);
Assert.AreEqual(field_Values5.Value, _f5.FieldValues[0].Value);
#endregion
#region Version
Assert.AreEqual(f1.Version, 49);
Assert.AreEqual(f2.Version, 9);
Assert.AreEqual(f3.Version, 1);
Assert.AreEqual(f4.Version, 1);
Assert.AreEqual(f5.Version, 1);
#endregion
#endregion
}
public void SQL_Check_CheckRead_ReturnsReplyElement()
{
// 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 == "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 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").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 == "number").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 == "comment").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 == "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 = 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 Check List Values
check_list_values check_List_Values = testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Values1 = testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Values2 = testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Values3 = testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Values4 = testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Values5 = testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
ReplyElement match = sut.CheckRead(aCase.microting_uid, aCase.microting_check_uid);
// Assert
#region Assert
Assert.AreEqual(1, match.ElementList.Count());
CheckListValue clv = (CheckListValue)match.ElementList[0];
Assert.AreEqual(5, clv.DataItemList.Count);
#region casts
Field _f1 = (Field)clv.DataItemList[0];
Field _f2 = (Field)clv.DataItemList[1];
Field _f3 = (Field)clv.DataItemList[2];
Field _f4 = (Field)clv.DataItemList[3];
Field _f5 = (Field)clv.DataItemList[4];
#endregion
#region Barcode
Assert.AreEqual(f1.barcode_enabled, 1);
Assert.AreEqual(f2.barcode_enabled, 1);
Assert.AreEqual(f3.barcode_enabled, 0);
Assert.AreEqual(f4.barcode_enabled, 1);
Assert.AreEqual(f5.barcode_enabled, 0);
Assert.AreEqual(f1.barcode_type, "barcode");
Assert.AreEqual(f2.barcode_type, "barcode");
Assert.AreEqual(f3.barcode_type, "barcode");
Assert.AreEqual(f4.barcode_type, "barcode");
Assert.AreEqual(f5.barcode_type, "barcode");
#endregion
#region chckl_id
Assert.AreEqual(f1.check_list_id, cl2.id);
Assert.AreEqual(f2.check_list_id, cl2.id);
Assert.AreEqual(f3.check_list_id, cl2.id);
Assert.AreEqual(f4.check_list_id, cl2.id);
Assert.AreEqual(f5.check_list_id, cl2.id);
#endregion
#region Color
Assert.AreEqual(f1.color, _f1.FieldValues[0].Color);
Assert.AreEqual(f2.color, _f2.FieldValues[0].Color);
Assert.AreEqual(f3.color, _f3.FieldValues[0].Color);
Assert.AreEqual(f4.color, _f4.FieldValues[0].Color);
Assert.AreEqual(f5.color, _f5.FieldValues[0].Color);
#endregion
#region custom
// Assert.AreEqual(f1.custom, _f1.FieldValues[0].Id);
#endregion
#region Decimal_Count
Assert.AreEqual(f1.decimal_count, null);
Assert.AreEqual(f2.decimal_count, null);
Assert.AreEqual(f3.decimal_count, 3);
Assert.AreEqual(f4.decimal_count, null);
Assert.AreEqual(f5.decimal_count, null);
#endregion
#region Default_value
Assert.AreEqual(f1.default_value, "");
Assert.AreEqual(f2.default_value, "");
Assert.AreEqual(f3.default_value, "");
Assert.AreEqual(f4.default_value, "");
Assert.AreEqual(f5.default_value, "");
#endregion
#region Description
CDataValue f1desc = (CDataValue)_f1.Description;
CDataValue f2desc = (CDataValue)_f2.Description;
CDataValue f3desc = (CDataValue)_f3.Description;
CDataValue f4desc = (CDataValue)_f4.Description;
CDataValue f5desc = (CDataValue)_f5.Description;
Assert.AreEqual(f1.description, f1desc.InderValue);
Assert.AreEqual(f2.description, f2desc.InderValue);
Assert.AreEqual(f3.description, f3desc.InderValue);
Assert.AreEqual(f4.description, f4desc.InderValue);
Assert.AreEqual(f5.description, f5desc.InderValue);
#endregion
#region Displayindex
Assert.AreEqual(f1.display_index, _f1.FieldValues[0].DisplayOrder);
Assert.AreEqual(f2.display_index, _f2.FieldValues[0].DisplayOrder);
Assert.AreEqual(f3.display_index, _f3.FieldValues[0].DisplayOrder);
Assert.AreEqual(f4.display_index, _f4.FieldValues[0].DisplayOrder);
Assert.AreEqual(f5.display_index, _f5.FieldValues[0].DisplayOrder);
#endregion
#region Dummy
Assert.AreEqual(f1.dummy, 1);
Assert.AreEqual(f2.dummy, 1);
Assert.AreEqual(f3.dummy, 0);
Assert.AreEqual(f4.dummy, 0);
Assert.AreEqual(f5.dummy, 0);
#endregion
#region geolocation
#region enabled
Assert.AreEqual(f1.geolocation_enabled, 0);
Assert.AreEqual(f2.geolocation_enabled, 0);
Assert.AreEqual(f3.geolocation_enabled, 0);
Assert.AreEqual(f4.geolocation_enabled, 0);
Assert.AreEqual(f5.geolocation_enabled, 1);
#endregion
#region forced
Assert.AreEqual(f1.geolocation_forced, 0);
Assert.AreEqual(f2.geolocation_forced, 1);
Assert.AreEqual(f3.geolocation_forced, 0);
Assert.AreEqual(f4.geolocation_forced, 0);
Assert.AreEqual(f5.geolocation_forced, 0);
#endregion
#region hidden
Assert.AreEqual(f1.geolocation_hidden, 1);
Assert.AreEqual(f2.geolocation_hidden, 0);
Assert.AreEqual(f3.geolocation_hidden, 1);
Assert.AreEqual(f4.geolocation_hidden, 1);
Assert.AreEqual(f5.geolocation_hidden, 1);
#endregion
#endregion
#region isNum
Assert.AreEqual(f1.is_num, 0);
Assert.AreEqual(f2.is_num, 0);
Assert.AreEqual(f3.is_num, 0);
Assert.AreEqual(f4.is_num, 0);
Assert.AreEqual(f5.is_num, 0);
#endregion
#region Label
Assert.AreEqual(f1.label, _f1.Label);
Assert.AreEqual(f2.label, _f2.Label);
Assert.AreEqual(f3.label, _f3.Label);
Assert.AreEqual(f4.label, _f4.Label);
Assert.AreEqual(f5.label, _f5.Label);
#endregion
#region Mandatory
Assert.AreEqual(f1.mandatory, 1);
Assert.AreEqual(f2.mandatory, 0);
Assert.AreEqual(f3.mandatory, 1);
Assert.AreEqual(f4.mandatory, 1);
Assert.AreEqual(f5.mandatory, 1);
#endregion
#region maxLength
Assert.AreEqual(f1.max_length, 55);
Assert.AreEqual(f2.max_length, 5);
Assert.AreEqual(f3.max_length, 8);
Assert.AreEqual(f4.max_length, 666);
Assert.AreEqual(f5.max_length, 69);
#endregion
#region min/max_Value
#region max
Assert.AreEqual(f1.max_value, "55");
Assert.AreEqual(f2.max_value, "5");
Assert.AreEqual(f3.max_value, "4865");
Assert.AreEqual(f4.max_value, "41153");
Assert.AreEqual(f5.max_value, "69");
#endregion
#region min
Assert.AreEqual(f1.min_value, "0");
Assert.AreEqual(f2.min_value, "0");
Assert.AreEqual(f3.min_value, "0");
Assert.AreEqual(f4.min_value, "0");
Assert.AreEqual(f5.min_value, "1");
#endregion
#endregion
#region Multi
Assert.AreEqual(f1.multi, 0);
Assert.AreEqual(f2.multi, 0);
Assert.AreEqual(f3.multi, 0);
Assert.AreEqual(f4.multi, 0);
Assert.AreEqual(f5.multi, 0);
#endregion
#region Optional
Assert.AreEqual(f1.optional, 0);
Assert.AreEqual(f2.optional, 0);
Assert.AreEqual(f3.optional, 1);
Assert.AreEqual(f4.optional, 1);
Assert.AreEqual(f5.optional, 1);
#endregion
#region Query_Type
Assert.AreEqual(f1.query_type, null);
Assert.AreEqual(f2.query_type, null);
Assert.AreEqual(f3.query_type, null);
Assert.AreEqual(f4.query_type, null);
Assert.AreEqual(f5.query_type, null);
#endregion
#region Read_Only
Assert.AreEqual(f1.read_only, 1);
Assert.AreEqual(f2.read_only, 0);
Assert.AreEqual(f3.read_only, 1);
Assert.AreEqual(f4.read_only, 0);
Assert.AreEqual(f5.read_only, 0);
#endregion
#region Selected
Assert.AreEqual(f1.selected, 0);
Assert.AreEqual(f2.selected, 0);
Assert.AreEqual(f3.selected, 0);
Assert.AreEqual(f4.selected, 1);
Assert.AreEqual(f5.selected, 1);
#endregion
#region Split_Screen
Assert.AreEqual(f1.split_screen, 0);
Assert.AreEqual(f2.split_screen, 0);
Assert.AreEqual(f3.split_screen, 0);
Assert.AreEqual(f4.split_screen, 0);
Assert.AreEqual(f5.split_screen, 0);
#endregion
#region Stop_On_Save
Assert.AreEqual(f1.stop_on_save, 0);
Assert.AreEqual(f2.stop_on_save, 0);
Assert.AreEqual(f3.stop_on_save, 0);
Assert.AreEqual(f4.stop_on_save, 0);
Assert.AreEqual(f5.stop_on_save, 0);
#endregion
#region Unit_Name
Assert.AreEqual(f1.unit_name, "");
Assert.AreEqual(f2.unit_name, "");
Assert.AreEqual(f3.unit_name, "");
Assert.AreEqual(f4.unit_name, "");
Assert.AreEqual(f5.unit_name, "");
#endregion
#region Values
Assert.AreEqual(1, _f1.FieldValues.Count());
Assert.AreEqual(1, _f2.FieldValues.Count());
Assert.AreEqual(1, _f3.FieldValues.Count());
Assert.AreEqual(1, _f4.FieldValues.Count());
Assert.AreEqual(1, _f5.FieldValues.Count());
Assert.AreEqual(field_Values1.value, _f1.FieldValues[0].Value);
Assert.AreEqual(field_Values2.value, _f2.FieldValues[0].Value);
Assert.AreEqual(field_Values3.value, _f3.FieldValues[0].Value);
Assert.AreEqual(field_Values4.value, _f4.FieldValues[0].Value);
Assert.AreEqual(field_Values5.value, _f5.FieldValues[0].Value);
#endregion
#region Version
Assert.AreEqual(f1.version, 49);
Assert.AreEqual(f2.version, 9);
Assert.AreEqual(f3.version, 1);
Assert.AreEqual(f4.version, 1);
Assert.AreEqual(f5.version, 1);
#endregion
#endregion
}
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_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 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_FieldValueReadList_ReturnsList()
{
// 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 Field Values
#region fv1
field_values field_Value1 = await testHelpers.CreateFieldValue(aCase, cl2, f1, null, 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
List <FieldValue> match = await sut.FieldValueReadList(f1.Id, 5);
// Assert
Assert.AreEqual(field_Value1.Value, match[0].Value);
}
public async Task CheckListValues_Create_DoesCreate()
{
//Arrange
Random rnd = new Random();
short shortMinValue = Int16.MinValue;
short shortmaxValue = Int16.MaxValue;
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);
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);
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);
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);
check_list_values checkListValue = new check_list_values
{
Status = Guid.NewGuid().ToString(),
CaseId = theCase.Id,
CheckListId = checklist.Id
};
//Act
await checkListValue.Create(dbContext).ConfigureAwait(false);
List <check_list_values> checkListValues = dbContext.check_list_values.AsNoTracking().ToList();
List <check_list_value_versions> checkListValueVersions = dbContext.check_list_value_versions.AsNoTracking().ToList();
Assert.NotNull(checkListValues);
Assert.NotNull(checkListValueVersions);
Assert.AreEqual(1, checkListValues.Count());
Assert.AreEqual(1, checkListValueVersions.Count());
Assert.AreEqual(checkListValue.CreatedAt.ToString(), checkListValues[0].CreatedAt.ToString());
Assert.AreEqual(checkListValue.Version, checkListValues[0].Version);
// Assert.AreEqual(checkListValue.UpdatedAt.ToString(), checkListValues[0].UpdatedAt.ToString());
Assert.AreEqual(checkListValues[0].WorkflowState, Constants.WorkflowStates.Created);
Assert.AreEqual(checkListValue.Id, checkListValues[0].Id);
Assert.AreEqual(checkListValue.Status, checkListValues[0].Status);
Assert.AreEqual(checkListValue.CaseId, theCase.Id);
Assert.AreEqual(checkListValue.CheckListId, checklist.Id);
//Versions
Assert.AreEqual(checkListValue.CreatedAt.ToString(), checkListValueVersions[0].CreatedAt.ToString());
Assert.AreEqual(1, checkListValueVersions[0].Version);
// Assert.AreEqual(checkListValue.UpdatedAt.ToString(), checkListValueVersions[0].UpdatedAt.ToString());
Assert.AreEqual(checkListValueVersions[0].WorkflowState, Constants.WorkflowStates.Created);
Assert.AreEqual(checkListValue.Id, checkListValueVersions[0].Id);
Assert.AreEqual(checkListValue.Status, checkListValueVersions[0].Status);
Assert.AreEqual(theCase.Id, checkListValueVersions[0].CaseId);
Assert.AreEqual(checklist.Id, checkListValueVersions[0].CheckListId);
}
public void SQL_Check_FieldValueUpdate_UpdatesFieldValue()
{
// 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 == "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 = testHelpers.CreateField(1, "barcode", cl2, "f5eafa", "custom", null, "", "showPDf Description",
45, 1, DbContext.field_types.Where(x => x.field_type == "comment").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 == "number").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 == "comment").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 == "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 = 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 Check List Values
check_list_values check_List_Values = testHelpers.CreateCheckListValue(aCase, cl2, "completed", null, 865);
#endregion
#region Field Values
#region fv1
field_values field_Value1 = testHelpers.CreateFieldValue(aCase, cl2, f1, null, null, "tomt1", 61234, worker);
#endregion
#region fv2
field_values field_Value2 = testHelpers.CreateFieldValue(aCase, cl2, f2, null, null, "tomt2", 61234, worker);
#endregion
#region fv3
field_values field_Value3 = testHelpers.CreateFieldValue(aCase, cl2, f3, null, null, "tomt3", 61234, worker);
#endregion
#region fv4
field_values field_Value4 = testHelpers.CreateFieldValue(aCase, cl2, f4, null, null, "tomt4", 61234, worker);
#endregion
#region fv5
field_values field_Value5 = testHelpers.CreateFieldValue(aCase, cl2, f5, null, null, "tomt5", 61234, worker);
#endregion
#endregion
#endregion
// Act
sut.FieldValueUpdate(aCase.id, field_Value1.id, "udfyldt");
// Assert
var newValue = DbContext.field_values.AsNoTracking().SingleOrDefault(x => x.id == field_Value1.id);
Assert.AreEqual(newValue.value, "udfyldt");
}
