private async void OfficeERL_TestGetOfficeERL()
        {
            var officeEditList = await OfficeERL.GetOfficeERL();

            Assert.NotNull(officeEditList);
            Assert.Equal(3, officeEditList.Count);
        }
        private async void OfficeERL_TestNewOfficeList()
        {
            var officeErl = await OfficeERL.NewOfficeERL();

            Assert.NotNull(officeErl);
            Assert.IsType <OfficeERL>(officeErl);
        }
        private async void OfficeERL_TestUpdateOfficesEntry()
        {
            const int idToUpdate = 1;

            var officeEditList = await OfficeERL.GetOfficeERL();

            var countBeforeUpdate = officeEditList.Count;
            var officeToUpdate    = officeEditList.First(a => a.Id == idToUpdate);

            officeToUpdate.Notes = "This was updated";

            var updatedList = await officeEditList.SaveAsync();

            Assert.Equal("This was updated", updatedList.First(a => a.Id == idToUpdate).Notes);
            Assert.Equal(countBeforeUpdate, updatedList.Count);
        }
        private async void OfficeERL_TestDeleteOfficesEntry()
        {
            var officeErl = await OfficeERL.GetOfficeERL();

            var listCount      = officeErl.Count;
            var officeToDelete = officeErl.First(et => et.Id == 99);

            // remove is deferred delete
            var isDeleted = officeErl.Remove(officeToDelete);

            var officeListAfterDelete = await officeErl.SaveAsync();

            Assert.NotNull(officeListAfterDelete);
            Assert.IsType <OfficeERL>(officeListAfterDelete);
            Assert.True(isDeleted);
            Assert.NotEqual(listCount, officeListAfterDelete.Count);
        }
        private async void OfficeERL_TestAddOfficesEntry()
        {
            var officeEditList = await OfficeERL.GetOfficeERL();

            var countBeforeAdd = officeEditList.Count;

            var officeToAdd = officeEditList.AddNew();

            officeToAdd.Term            = 1;
            officeToAdd.CalendarPeriod  = "annual";
            officeToAdd.Name            = "office name";
            officeToAdd.ChosenHow       = 2;
            officeToAdd.Appointer       = "members";
            officeToAdd.LastUpdatedBy   = "edm";
            officeToAdd.LastUpdatedDate = DateTime.Now;

            var updatedOfficesList = await officeEditList.SaveAsync();

            Assert.NotEqual(countBeforeAdd, updatedOfficesList.Count);
        }