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 site_workers CreateSiteWorker(int microtingUId, sites site, workers worker) { site_workers site_workers = new site_workers(); site_workers.created_at = DateTime.Now; site_workers.microting_uid = microtingUId; site_workers.updated_at = DateTime.Now; site_workers.version = 63; site_workers.site = site; site_workers.site_id = site.id; site_workers.worker = worker; site_workers.worker_id = worker.id; site_workers.workflow_state = Constants.WorkflowStates.Created; DbContext.site_workers.Add(site_workers); DbContext.SaveChanges(); return(site_workers); }
public async Task <site_workers> CreateSiteWorker(int microtingUId, sites site, workers worker) { site_workers site_workers = new site_workers(); site_workers.CreatedAt = DateTime.UtcNow; site_workers.MicrotingUid = microtingUId; site_workers.UpdatedAt = DateTime.UtcNow; site_workers.Version = 63; site_workers.Site = site; site_workers.SiteId = site.Id; site_workers.Worker = worker; site_workers.WorkerId = worker.Id; site_workers.WorkflowState = Constants.WorkflowStates.Created; dbContext.site_workers.Add(site_workers); await dbContext.SaveChangesAsync().ConfigureAwait(false); return(site_workers); }
[Test]//Using Communicatorn needs httpMock public async Task Core_Site_SiteUpdate_returnsTrue() { // Arrange // Arrange #region site string siteName = Guid.NewGuid().ToString(); int siteMicrotingUid = 1; // This needs to be 1 for our tests to pass through the FakeHttp // TODO: Improve the test for supporting random id. sites site = await testHelpers.CreateSite(siteName, siteMicrotingUid); SiteNameDto siteName_Dto = new SiteNameDto((int)site.MicrotingUid, site.Name, site.CreatedAt, site.UpdatedAt); #endregion #region worker string email = Guid.NewGuid().ToString(); string firstName = Guid.NewGuid().ToString(); string lastName = Guid.NewGuid().ToString(); //int workerMicrotingUid = await testHelpers.GetRandomInt(); int workerMicrotingUid = 1; // This needs to be 1 for our tests to pass through the FakeHttp // TODO: Improve the test for supporting random id. workers worker = await testHelpers.CreateWorker(email, firstName, lastName, workerMicrotingUid); #endregion #region site_worker site_workers site_worker = await testHelpers.CreateSiteWorker(1, site, worker); #endregion #region unit units unit = await testHelpers.CreateUnit(1, 1, site, 1); #endregion var match = await sut.SiteUpdate((int)site.MicrotingUid, site.Name, firstName, lastName, email); // Assert Assert.True(match); }
[Test]//Using Communicatorn needs httpMock public void Core_Site_SiteDelete_ReturnsTrue() { //Arrance #region site string siteName = Guid.NewGuid().ToString(); int siteMicrotingUid = 1; // This needs to be 1 for our tests to pass through the FakeHttp // TODO: Improve the test for supporting random id. sites site = testHelpers.CreateSite(siteName, siteMicrotingUid); SiteName_Dto siteName_Dto = new SiteName_Dto((int)site.microting_uid, site.name, site.created_at, site.updated_at); #endregion #region worker string email = Guid.NewGuid().ToString(); string firstName = Guid.NewGuid().ToString(); string lastName = Guid.NewGuid().ToString(); //int workerMicrotingUid = testHelpers.GetRandomInt(); int workerMicrotingUid = 1; // This needs to be 1 for our tests to pass through the FakeHttp // TODO: Improve the test for supporting random id. workers worker = testHelpers.CreateWorker(email, firstName, lastName, workerMicrotingUid); #endregion #region site_worker site_workers site_worker = testHelpers.CreateSiteWorker(1, site, worker); #endregion #region unit units unit = testHelpers.CreateUnit(1, 1, site, 1); #endregion //Act var match = sut.SiteDelete((int)site.microting_uid); //Assert Assert.True(match); //#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 void SQL_Site_SiteUpdate_UpdatesSite() { // Arrance #region Arrance #region Checklist DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists Cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0); #endregion #region SubCheckList check_lists Cl2 = testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, 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 == "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 == "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 == "comment").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field6 fields f6 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 86, 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 #region field7 fields f7 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 87, 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 #region field8 fields f8 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 88, 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 #region field9 fields f9 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 89, 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 #region field10 fields f10 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 90, 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 sites #region Site1 sites site1 = testHelpers.CreateSite("SiteName1", 88); #endregion #region Site2 sites site2 = testHelpers.CreateSite("SiteName2", 89); #endregion #region Site3 sites site3 = testHelpers.CreateSite("SiteName3", 90); #endregion #region Site4 sites site4 = testHelpers.CreateSite("SiteName4", 91); #endregion #region Site5 sites site5 = testHelpers.CreateSite("SiteName5", 92); #endregion #region Site6 sites site6 = testHelpers.CreateSite("SiteName6", 93); #endregion #region Site7 sites site7 = testHelpers.CreateSite("SiteName7", 94); #endregion #region Site8 sites site8 = testHelpers.CreateSite("SiteName8", 95); #endregion #region Site9 sites site9 = testHelpers.CreateSite("SiteName9", 96); #endregion #region Site10 sites site10 = testHelpers.CreateSite("SiteName10", 97); #endregion #endregion #region units units unit = testHelpers.CreateUnit(48, 49, site1, 348); #endregion #region site_workers site_workers site_workers = testHelpers.CreateSiteWorker(55, site1, worker); #endregion #endregion // Act var match = sut.SiteUpdate((int)site1.microting_uid, site1.name); // Assert Assert.True(match); }
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_Unit_UnitUpdate_UpdatesUnit() { // Arrance #region Arrance #region Checklist DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists Cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0); #endregion #region SubCheckList check_lists Cl2 = await testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, 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 == "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 == "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 == "comment").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field6 fields f6 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 86, 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 #region field7 fields f7 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 87, 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 #region field8 fields f8 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 88, 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 #region field9 fields f9 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 89, 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 #region field10 fields f10 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 90, 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 Workers #region worker1 workers worker1 = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region worker2 workers worker2 = await testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44); #endregion #region worker3 workers worker3 = await testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22); #endregion #region worker4 workers worker4 = await testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23); #endregion #region worker5 workers worker5 = await testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24); #endregion #region worker6 workers worker6 = await testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25); #endregion #region worker7 workers worker7 = await testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26); #endregion #region worker8 workers worker8 = await testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27); #endregion #region worker9 workers worker9 = await testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28); #endregion #region worker10 workers worker10 = await testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29); #endregion #endregion #region sites #region Site1 sites site1 = await testHelpers.CreateSite("SiteName1", 88); #endregion #region Site2 sites site2 = await testHelpers.CreateSite("SiteName2", 89); #endregion #region Site3 sites site3 = await testHelpers.CreateSite("SiteName3", 90); #endregion #region Site4 sites site4 = await testHelpers.CreateSite("SiteName4", 91); #endregion #region Site5 sites site5 = await testHelpers.CreateSite("SiteName5", 92); #endregion #region Site6 sites site6 = await testHelpers.CreateSite("SiteName6", 93); #endregion #region Site7 sites site7 = await testHelpers.CreateSite("SiteName7", 94); #endregion #region Site8 sites site8 = await testHelpers.CreateSite("SiteName8", 95); #endregion #region Site9 sites site9 = await testHelpers.CreateSite("SiteName9", 96); #endregion #region Site10 sites site10 = await testHelpers.CreateSite("SiteName10", 97); #endregion #endregion #region units #region Unit1 units unit1 = await testHelpers.CreateUnit(48, 49, site1, 348); #endregion #region Unit2 units unit2 = await testHelpers.CreateUnit(2, 55, site2, 349); #endregion #region Unit3 units unit3 = await testHelpers.CreateUnit(3, 51, site3, 350); #endregion #region Unit4 units unit4 = await testHelpers.CreateUnit(4, 52, site4, 351); #endregion #region Unit5 units unit5 = await testHelpers.CreateUnit(5, 6, site5, 352); #endregion #region Unit6 units unit6 = await testHelpers.CreateUnit(6, 85, site6, 353); #endregion #region Unit7 units unit7 = await testHelpers.CreateUnit(7, 62, site7, 354); #endregion #region Unit8 units unit8 = await testHelpers.CreateUnit(8, 96, site8, 355); #endregion #region Unit9 units unit9 = await testHelpers.CreateUnit(9, 69, site9, 356); #endregion #region Unit10 units unit10 = await testHelpers.CreateUnit(10, 100, site10, 357); #endregion #endregion #region site_workers site_workers site_workers = await testHelpers.CreateSiteWorker(55, site1, worker1); #endregion #endregion // Act var match = await sut.UnitUpdate((int)unit1.MicrotingUid, (int)unit1.CustomerNo, (int)unit1.OtpCode, (int)unit1.SiteId); // Assert Assert.True(match); }
public void SQL_Worker_WorkerUpdate_UpdatesWorker() { // Arrance #region Arrance #region Checklist DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists Cl1 = testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0); #endregion #region SubCheckList check_lists Cl2 = testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, 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 == "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 == "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 == "comment").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field6 fields f6 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 86, 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 #region field7 fields f7 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 87, 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 #region field8 fields f8 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 88, 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 #region field9 fields f9 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 89, 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 #region field10 fields f10 = testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 90, 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 Workers #region worker1 workers worker1 = testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region worker2 workers worker2 = testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44); #endregion #region worker3 workers worker3 = testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22); #endregion #region worker4 workers worker4 = testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23); #endregion #region worker5 workers worker5 = testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24); #endregion #region worker6 workers worker6 = testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25); #endregion #region worker7 workers worker7 = testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26); #endregion #region worker8 workers worker8 = testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27); #endregion #region worker9 workers worker9 = testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28); #endregion #region worker10 workers worker10 = testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29); #endregion #endregion #region sites #region Site1 sites site1 = testHelpers.CreateSite("SiteName1", 88); #endregion #region Site2 sites site2 = testHelpers.CreateSite("SiteName2", 89); #endregion #region Site3 sites site3 = testHelpers.CreateSite("SiteName3", 90); #endregion #region Site4 sites site4 = testHelpers.CreateSite("SiteName4", 91); #endregion #region Site5 sites site5 = testHelpers.CreateSite("SiteName5", 92); #endregion #region Site6 sites site6 = testHelpers.CreateSite("SiteName6", 93); #endregion #region Site7 sites site7 = testHelpers.CreateSite("SiteName7", 94); #endregion #region Site8 sites site8 = testHelpers.CreateSite("SiteName8", 95); #endregion #region Site9 sites site9 = testHelpers.CreateSite("SiteName9", 96); #endregion #region Site10 sites site10 = testHelpers.CreateSite("SiteName10", 97); #endregion #endregion #region units units unit = testHelpers.CreateUnit(48, 49, site1, 348); #endregion #region site_workers site_workers site_workers = testHelpers.CreateSiteWorker(55, site1, worker1); #endregion #endregion // Act var match = sut.WorkerUpdate(worker1.microting_uid, worker1.first_name, worker1.last_name, worker1.email); // Assert Assert.True(match); }
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 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"); }
public async Task SiteWorkers_Create_DoesCreate() { // Arrange Random rnd = new Random(); sites site = new sites { Name = Guid.NewGuid().ToString(), MicrotingUid = rnd.Next(1, 255) }; await site.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); site_workers siteWorker = new site_workers { MicrotingUid = rnd.Next(1, 255), SiteId = site.Id, WorkerId = worker.Id }; //Act await siteWorker.Create(dbContext).ConfigureAwait(false); List <site_workers> siteWorkers = dbContext.site_workers.AsNoTracking().ToList(); List <site_worker_versions> siteWorkerVersions = dbContext.site_worker_versions.AsNoTracking().ToList(); Assert.NotNull(siteWorkers); Assert.NotNull(siteWorkerVersions); Assert.AreEqual(1, siteWorkers.Count()); Assert.AreEqual(1, siteWorkerVersions.Count()); Assert.AreEqual(siteWorker.CreatedAt.ToString(), siteWorkers[0].CreatedAt.ToString()); Assert.AreEqual(siteWorker.Version, siteWorkers[0].Version); // Assert.AreEqual(siteWorker.UpdatedAt.ToString(), siteWorkers[0].UpdatedAt.ToString()); Assert.AreEqual(siteWorkers[0].WorkflowState, Constants.WorkflowStates.Created); Assert.AreEqual(siteWorker.Id, siteWorkers[0].Id); Assert.AreEqual(siteWorker.MicrotingUid, siteWorkers[0].MicrotingUid); Assert.AreEqual(siteWorker.SiteId, site.Id); Assert.AreEqual(siteWorker.WorkerId, worker.Id); //Versions Assert.AreEqual(siteWorker.CreatedAt.ToString(), siteWorkerVersions[0].CreatedAt.ToString()); Assert.AreEqual(1, siteWorkerVersions[0].Version); // Assert.AreEqual(siteWorker.UpdatedAt.ToString(), siteWorkerVersions[0].UpdatedAt.ToString()); Assert.AreEqual(siteWorkerVersions[0].WorkflowState, Constants.WorkflowStates.Created); Assert.AreEqual(siteWorker.Id, siteWorkerVersions[0].SiteWorkerId); Assert.AreEqual(siteWorker.MicrotingUid, siteWorkerVersions[0].MicrotingUid); Assert.AreEqual(site.Id, siteWorkerVersions[0].SiteId); Assert.AreEqual(worker.Id, siteWorkerVersions[0].WorkerId); }
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 Core_Site_SiteRead_ReturnsFullSite() { //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 subtemplates #region SubTemplate1 check_lists cl2 = testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl3 = testHelpers.CreateSubTemplate("A.2", "D.2", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl4 = testHelpers.CreateSubTemplate("A.3", "D.3", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl5 = testHelpers.CreateSubTemplate("A.4", "D.4", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl6 = testHelpers.CreateSubTemplate("A.5", "D.5", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl7 = testHelpers.CreateSubTemplate("A.6", "D.6", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl8 = testHelpers.CreateSubTemplate("A.7", "D.7", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl9 = testHelpers.CreateSubTemplate("A.8", "D.8", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl10 = testHelpers.CreateSubTemplate("A.9", "D.9", "CheckList", 1, 1, cl1); #endregion #region SubTemplate1 check_lists cl11 = testHelpers.CreateSubTemplate("A.10", "D.10", "CheckList", 1, 1, cl1); #endregion #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 == "comment").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 #region field6 fields f6 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 86, 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 #region field7 fields f7 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 87, 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 #region field8 fields f8 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 88, 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 #region field9 fields f9 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 89, 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 #region field10 fields f10 = testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", 90, 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 //Act var match = sut.SiteRead((int)site.microting_uid); //Assert Assert.NotNull(match); Assert.AreEqual(match.SiteId, site.microting_uid); Assert.AreEqual(match.SiteName, site.name); }
public async Task Core_Site_SiteReadAll_ReturnsSites() { // Arrange // #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 subtemplates // #region SubTemplate1 // check_lists cl2 = await testHelpers.CreateSubTemplate("A.1", "D.1", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl3 = await testHelpers.CreateSubTemplate("A.2", "D.2", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl4 = await testHelpers.CreateSubTemplate("A.3", "D.3", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl5 = await testHelpers.CreateSubTemplate("A.4", "D.4", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl6 = await testHelpers.CreateSubTemplate("A.5", "D.5", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl7 = await testHelpers.CreateSubTemplate("A.6", "D.6", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl8 = await testHelpers.CreateSubTemplate("A.7", "D.7", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl9 = await testHelpers.CreateSubTemplate("A.8", "D.8", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl10 = await testHelpers.CreateSubTemplate("A.9", "D.9", "CheckList", 1, 1, cl1); // // // #endregion // // #region SubTemplate1 // check_lists cl11 = await testHelpers.CreateSubTemplate("A.10", "D.10", "CheckList", 1, 1, cl1); // // // #endregion // #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 == "comment").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 // // #region field6 // // fields f6 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", // 86, 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 // // #region field7 // // fields f7 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", // 87, 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 // // #region field8 // // fields f8 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", // 88, 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 // // #region field9 // // fields f9 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", // 89, 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 // // #region field10 // // fields f10 = await testHelpers.CreateField(0, "barcode", cl2, "ffe4e4", "custom", null, "", "picture Description", // 90, 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 // Act var matchNotRemoved = await sut.SiteReadAll(false); var matchInclRemoved = await sut.SiteReadAll(true); // Assert Assert.NotNull(matchInclRemoved); Assert.NotNull(matchNotRemoved); Assert.AreEqual(matchInclRemoved.Count, 1); Assert.AreEqual(matchNotRemoved.Count, 1); }
public string CreateMultiPictureXMLResult(bool create) { if (create) { sites site = testHelpers.CreateSite("TestSite1", 12334); units unit = testHelpers.CreateUnit(20934, 234234, site, 24234); workers worker = testHelpers.CreateWorker("*****@*****.**", "John", "Doe", 2342341); site_workers sw = testHelpers.CreateSiteWorker(242345, site, worker); DateTime cl1_ca = DateTime.Now; DateTime cl1_ua = DateTime.Now; check_lists cl1 = testHelpers.CreateTemplate(cl1_ca, cl1_ua, "MultiPictureXMLResult", "MultiPictureXMLResult_Description", "", "", 0, 0); check_lists cl2 = testHelpers.CreateSubTemplate("Sub1", "Sub1Description", "", 0, 0, cl1); fields f1 = testHelpers.CreateField(0, "", cl2, Constants.FieldColors.Blue, "", null, "", "PictureDescription", 0, 0, testHelpers.DbContext.field_types.Where(x => x.field_type == "picture").First(), 0, 0, 0, 0, "Take picture", 0, 0, "", "", 0, 0, "", 0, 0, 0, 0, "", 0); check_list_sites cls = testHelpers.CreateCheckListSite(cl1, cl1_ca, site, cl1_ua, 0, Constants.WorkflowStates.Created, "MultiPictureTestInMultipleChecks"); //returnXML = ; return("MultiPictureTestInMultipleChecks"); } else { sites site = testHelpers.DbContext.sites.First(); units unit = testHelpers.DbContext.units.First(); workers worker = testHelpers.DbContext.workers.First(); check_lists cl1 = testHelpers.DbContext.check_lists.ToList()[0]; check_lists cl2 = testHelpers.DbContext.check_lists.ToList()[1]; fields f1 = testHelpers.DbContext.fields.First(); #region return xml return($@"<?xml version='1.0' encoding='UTF-8'?> <Response> <Value type='success'>MultiPictureTestInMultipleChecks</Value> <Checks> <Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:29:21 +0200' unit_id='{unit.microting_uid}' id='7'> <ElementList> <Id>{cl2.id}</Id> <Status>approved</Status> <DataItemList> <DataItem> <Id>{f1.id}</Id> <Geolocation> <Latitude></Latitude> <Longitude></Longitude> <Altitude></Altitude> <Heading></Heading> <Accuracy></Accuracy> <Date></Date> </Geolocation> <Value></Value> <Extension>.jpeg</Extension> <URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL> </DataItem> </DataItemList> <ExtraDataItemList></ExtraDataItemList> </ElementList> </Check> <Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:29:52 +0200' unit_id='{unit.microting_uid}' id='12'> <ElementList> <Id>{cl2.id}</Id> <Status>approved</Status> <DataItemList> <DataItem> <Id>{f1.id}</Id> <Geolocation> <Latitude></Latitude> <Longitude></Longitude> <Altitude></Altitude> <Heading></Heading> <Accuracy></Accuracy> <Date></Date> </Geolocation> <Value></Value> <Extension>.jpeg</Extension> <URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL> </DataItem> <DataItem> <Id>{f1.id}</Id> <Geolocation> <Latitude></Latitude> <Longitude></Longitude> <Altitude></Altitude> <Heading></Heading> <Accuracy></Accuracy> <Date></Date> </Geolocation> <Value></Value> <Extension>.jpeg</Extension> <URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL> </DataItem> </DataItemList> <ExtraDataItemList></ExtraDataItemList> </ElementList> </Check> <Check worker='John Doe' worker_id='{worker.microting_uid}' date='2018-04-25 14:39:43 +0200' unit_id='{unit.microting_uid}' id='17'> <ElementList> <Id>{cl2.id}</Id> <Status>approved</Status> <DataItemList> <DataItem> <Id>{f1.id}</Id> <Geolocation> <Latitude></Latitude> <Longitude></Longitude> <Altitude></Altitude> <Heading></Heading> <Accuracy></Accuracy> <Date></Date> </Geolocation> <Value></Value> <Extension>.jpeg</Extension> <URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL> </DataItem> <DataItem> <Id>{f1.id}</Id> <Geolocation> <Latitude></Latitude> <Longitude></Longitude> <Altitude></Altitude> <Heading></Heading> <Accuracy></Accuracy> <Date></Date> </Geolocation> <Value></Value> <Extension>.jpeg</Extension> <URL>https://www.microting.com/wp-content/themes/Artificial-Reason-WP/img/close.png</URL> </DataItem> </DataItemList> <ExtraDataItemList></ExtraDataItemList> </ElementList> </Check> </Checks> </Response>".Replace("'", "\"")); #endregion } }
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 async Task SQL_Worker_WorkerGetAll_ReturnsAllWorkers() { // Arrance #region Arrance #region Checklist DateTime cl1_Ca = DateTime.Now; DateTime cl1_Ua = DateTime.Now; check_lists Cl1 = await testHelpers.CreateTemplate(cl1_Ca, cl1_Ua, "A1", "D1", "caseType1", "WhereItIs", 1, 0); #endregion #region SubCheckList check_lists Cl2 = await testHelpers.CreateSubTemplate("A2", "D2", "caseType2", 2, 0, 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 == "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 == "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 == "comment").First(), 1, 0, 1, 0, "Picture", 1, 69, "69", "1", 0, 1, null, 0, 1, 0, 0, "", 1); #endregion #region field6 fields f6 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 86, 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 #region field7 fields f7 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 87, 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 #region field8 fields f8 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 88, 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 #region field9 fields f9 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 89, 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 #region field10 fields f10 = await testHelpers.CreateField(0, "barcode", Cl2, "ffe4e4", "custom", null, "", "picture Description", 90, 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 Workers #region worker1 workers worker1 = await testHelpers.CreateWorker("*****@*****.**", "Arne", "Jensen", 21); #endregion #region worker2 workers worker2 = await testHelpers.CreateWorker("*****@*****.**", "Lasse", "Johansen", 44); #endregion #region worker3 workers worker3 = await testHelpers.CreateWorker("*****@*****.**", "Svend", "Jensen", 22); #endregion #region worker4 workers worker4 = await testHelpers.CreateWorker("*****@*****.**", "Bjarne", "Nielsen", 23); #endregion #region worker5 workers worker5 = await testHelpers.CreateWorker("*****@*****.**", "Ib", "Hansen", 24); #endregion #region worker6 workers worker6 = await testHelpers.CreateWorker("*****@*****.**", "Hozan", "Aziz", 25); #endregion #region worker7 workers worker7 = await testHelpers.CreateWorker("*****@*****.**", "Nicolai", "Peders", 26); #endregion #region worker8 workers worker8 = await testHelpers.CreateWorker("*****@*****.**", "Amin", "Safari", 27); #endregion #region worker9 workers worker9 = await testHelpers.CreateWorker("*****@*****.**", "Leo", "Rebaz", 28); #endregion #region worker10 workers worker10 = await testHelpers.CreateWorker("*****@*****.**", "Stig", "Berthelsen", 29); #endregion #endregion #region sites #region Site1 sites site1 = await testHelpers.CreateSite("SiteName1", 88); #endregion #region Site2 sites site2 = await testHelpers.CreateSite("SiteName2", 89); #endregion #region Site3 sites site3 = await testHelpers.CreateSite("SiteName3", 90); #endregion #region Site4 sites site4 = await testHelpers.CreateSite("SiteName4", 91); #endregion #region Site5 sites site5 = await testHelpers.CreateSite("SiteName5", 92); #endregion #region Site6 sites site6 = await testHelpers.CreateSite("SiteName6", 93); #endregion #region Site7 sites site7 = await testHelpers.CreateSite("SiteName7", 94); #endregion #region Site8 sites site8 = await testHelpers.CreateSite("SiteName8", 95); #endregion #region Site9 sites site9 = await testHelpers.CreateSite("SiteName9", 96); #endregion #region Site10 sites site10 = await testHelpers.CreateSite("SiteName10", 97); #endregion #endregion #region units units unit = await testHelpers.CreateUnit(48, 49, site1, 348); #endregion #region site_workers site_workers site_workers = await testHelpers.CreateSiteWorker(55, site1, worker1); #endregion #endregion // Act var getAllCreatedWorkers = await sut.WorkerGetAll(Constants.WorkflowStates.Created, 0, 1); var getAllRemovedWorkers = await sut.WorkerGetAll(Constants.WorkflowStates.Removed, 0, 1); // Assert Assert.AreEqual(10, getAllCreatedWorkers.Count()); Assert.AreEqual(0, getAllRemovedWorkers.Count()); Assert.AreEqual(worker1.FirstName, getAllCreatedWorkers[0].FirstName); Assert.AreEqual(worker2.FirstName, getAllCreatedWorkers[1].FirstName); Assert.AreEqual(worker3.FirstName, getAllCreatedWorkers[2].FirstName); Assert.AreEqual(worker4.FirstName, getAllCreatedWorkers[3].FirstName); Assert.AreEqual(worker5.FirstName, getAllCreatedWorkers[4].FirstName); Assert.AreEqual(worker6.FirstName, getAllCreatedWorkers[5].FirstName); Assert.AreEqual(worker7.FirstName, getAllCreatedWorkers[6].FirstName); Assert.AreEqual(worker8.FirstName, getAllCreatedWorkers[7].FirstName); Assert.AreEqual(worker9.FirstName, getAllCreatedWorkers[8].FirstName); Assert.AreEqual(worker10.FirstName, getAllCreatedWorkers[9].FirstName); Assert.AreEqual(worker1.LastName, getAllCreatedWorkers[0].LastName); Assert.AreEqual(worker2.LastName, getAllCreatedWorkers[1].LastName); Assert.AreEqual(worker3.LastName, getAllCreatedWorkers[2].LastName); Assert.AreEqual(worker4.LastName, getAllCreatedWorkers[3].LastName); Assert.AreEqual(worker5.LastName, getAllCreatedWorkers[4].LastName); Assert.AreEqual(worker6.LastName, getAllCreatedWorkers[5].LastName); Assert.AreEqual(worker7.LastName, getAllCreatedWorkers[6].LastName); Assert.AreEqual(worker8.LastName, getAllCreatedWorkers[7].LastName); Assert.AreEqual(worker9.LastName, getAllCreatedWorkers[8].LastName); Assert.AreEqual(worker10.LastName, getAllCreatedWorkers[9].LastName); }