public void SharepointListDesignerViewModelBase_SetSelectedSharepointServer_SetToServer_ShouldLoadLists()
{
//------------Setup for test--------------------------
var mockEnvironmentModel = new Mock <IServer>();
var mockResourceRepo = new Mock <IResourceRepository>();
var sharepointSource = new SharepointSource
{
ResourceName = "SharepointServer1",
ResourceID = Guid.NewGuid()
};
var sharepointSources = new List <SharepointSource> {
sharepointSource
};
mockResourceRepo.Setup(repository => repository.FindSourcesByType <SharepointSource>(It.IsAny <IServer>(), enSourceType.SharepointServerSource)).Returns(sharepointSources);
var sharepointListTo = new SharepointListTo
{
FullName = "Share List",
Fields = new List <ISharepointFieldTo>
{
new SharepointFieldTo
{
InternalName = "Field 1",
IsEditable = false,
Name = "Name 1",
IsRequired = false,
Type = SharepointFieldType.Text
}
}
};
var sharepointListTos = new List <SharepointListTo>
{
sharepointListTo
};
mockResourceRepo.Setup(repository => repository.GetSharepointLists(It.IsAny <SharepointSource>())).Returns(sharepointListTos);
mockEnvironmentModel.Setup(model => model.ResourceRepository).Returns(mockResourceRepo.Object);
var sharepointListDesignerViewModelBase = CreateSharepointListDesignerViewModel(mockEnvironmentModel);
//------------Execute Test---------------------------
sharepointListDesignerViewModelBase.SelectedSharepointServer = sharepointSource;
//------------Assert Results-------------------------
Assert.IsNotNull(sharepointListDesignerViewModelBase.SelectedSharepointServer);
Assert.IsNotNull(sharepointListDesignerViewModelBase.Lists);
Assert.AreEqual(2, sharepointListDesignerViewModelBase.Lists.Count);
Assert.AreEqual(sharepointListDesignerViewModelBase.GetSelectAList, sharepointListDesignerViewModelBase.Lists[0]);
Assert.AreEqual(sharepointListTo, sharepointListDesignerViewModelBase.Lists[1]);
}
public void SharepointListDesignerViewModelBase_RemoveFilterItem_ShouldRemoveFromCollection()
{
//------------Setup for test--------------------------
var mockEnvironmentModel = new Mock <IServer>();
var mockResourceRepo = new Mock <IResourceRepository>();
var sharepointSource = new SharepointSource
{
ResourceName = "SharepointServer1",
ResourceID = Guid.NewGuid()
};
var sharepointSources = new List <SharepointSource> {
sharepointSource
};
mockResourceRepo.Setup(repository => repository.FindSourcesByType <SharepointSource>(It.IsAny <IServer>(), enSourceType.SharepointServerSource)).Returns(sharepointSources);
var sharepointFieldTos = new List <ISharepointFieldTo>
{
new SharepointFieldTo
{
InternalName = "Field 1",
IsEditable = false,
Name = "Name 1",
IsRequired = false,
Type = SharepointFieldType.Text
}
};
var sharepointListTo = new SharepointListTo
{
FullName = "Share List",
Fields = sharepointFieldTos
};
var sharepointListTos = new List <SharepointListTo>
{
sharepointListTo
};
mockResourceRepo.Setup(repository => repository.GetSharepointLists(It.IsAny <SharepointSource>())).Returns(sharepointListTos);
mockResourceRepo.Setup(repository => repository.GetSharepointListFields(It.IsAny <ISharepointSource>(), It.IsAny <SharepointListTo>(), false)).Returns(sharepointFieldTos);
mockEnvironmentModel.Setup(model => model.ResourceRepository).Returns(mockResourceRepo.Object);
var sharepointReadListTos = new List <SharepointReadListTo>
{
new SharepointReadListTo("[[ShareList(*).Name1]]", "Name 1", "Field 1", SharepointFieldType.Text.ToString())
};
var modelItem = CreatePopulatedModelItem(sharepointSource.ResourceID, sharepointReadListTos, "Share List");
var sharepointListDesignerViewModelBase = new TestSharepointListDesignerViewModelBase(modelItem, new SynchronousAsyncWorker(), mockEnvironmentModel.Object, new Mock <IEventAggregator>().Object, false);
//------------Assert Precondtion---------------------
Assert.IsNotNull(sharepointListDesignerViewModelBase.SelectedSharepointServer);
Assert.IsNotNull(sharepointListDesignerViewModelBase.Lists);
Assert.AreEqual(1, sharepointListDesignerViewModelBase.Lists.Count);
Assert.IsNotNull(sharepointListDesignerViewModelBase.SelectedList);
Assert.IsNotNull(sharepointListDesignerViewModelBase.ListItems);
Assert.AreEqual(1, sharepointListDesignerViewModelBase.ListItems.Count);
Assert.AreEqual("Name 1", sharepointListDesignerViewModelBase.ListItems[0].FieldName);
Assert.AreEqual("Field 1", sharepointListDesignerViewModelBase.ListItems[0].InternalName);
Assert.AreEqual(SharepointFieldType.Text.ToString(), sharepointListDesignerViewModelBase.ListItems[0].Type);
Assert.IsFalse(sharepointListDesignerViewModelBase.ListItems[0].IsRequired);
Assert.AreEqual("[[ShareList(*).Name1]]", sharepointListDesignerViewModelBase.ListItems[0].VariableName);
Assert.AreEqual(2, sharepointListDesignerViewModelBase.ModelItemCollection.Count);
//------------Execute Test---------------------------
sharepointListDesignerViewModelBase.RemoveAt(1);
//------------Assert Results-------------------------
Assert.AreEqual(1, sharepointListDesignerViewModelBase.ModelItemCollection.Count);
}
public void SharepointListDesignerViewModelBase_SetSelectedList_SetToList_ShouldLoadFields()
{
//------------Setup for test--------------------------
var mockEnvironmentModel = new Mock <IServer>();
var mockResourceRepo = new Mock <IResourceRepository>();
var sharepointSource = new SharepointSource
{
ResourceName = "SharepointServer1",
ResourceID = Guid.NewGuid()
};
var sharepointSources = new List <SharepointSource> {
sharepointSource
};
mockResourceRepo.Setup(repository => repository.FindSourcesByType <SharepointSource>(It.IsAny <IServer>(), enSourceType.SharepointServerSource)).Returns(sharepointSources);
var sharepointFieldTos = new List <ISharepointFieldTo>
{
new SharepointFieldTo
{
InternalName = "Field 1",
IsEditable = false,
Name = "Name 1",
IsRequired = false,
Type = SharepointFieldType.Text
},
new SharepointFieldTo
{
InternalName = "fMyField",
IsEditable = false,
Name = "fMyField 1",
IsRequired = false,
Type = SharepointFieldType.Text
},
new SharepointFieldTo
{
InternalName = "1 Field Name",
IsEditable = false,
Name = "1 Field Name",
IsRequired = false,
Type = SharepointFieldType.Text
},
new SharepointFieldTo
{
InternalName = "_Field",
IsEditable = false,
Name = "_Field Name",
IsRequired = false,
Type = SharepointFieldType.Text
},
new SharepointFieldTo
{
InternalName = "_Field_",
IsEditable = false,
Name = "Field_Name_1",
IsRequired = false,
Type = SharepointFieldType.Text
}
};
var sharepointListTo = new SharepointListTo
{
FullName = "Share List",
Fields = sharepointFieldTos
};
var sharepointListTos = new List <SharepointListTo>
{
sharepointListTo
};
mockResourceRepo.Setup(repository => repository.GetSharepointLists(It.IsAny <SharepointSource>())).Returns(sharepointListTos);
mockResourceRepo.Setup(repository => repository.GetSharepointListFields(It.IsAny <ISharepointSource>(), It.IsAny <SharepointListTo>(), false)).Returns(sharepointFieldTos);
mockEnvironmentModel.Setup(model => model.ResourceRepository).Returns(mockResourceRepo.Object);
var sharepointListDesignerViewModelBase = CreateSharepointListDesignerViewModel(mockEnvironmentModel);
sharepointListDesignerViewModelBase.SelectedSharepointServer = sharepointSource;
//------------Assert Preconditions-------------------
Assert.IsNotNull(sharepointListDesignerViewModelBase.SelectedSharepointServer);
Assert.IsNotNull(sharepointListDesignerViewModelBase.Lists);
Assert.AreEqual(2, sharepointListDesignerViewModelBase.Lists.Count);
//------------Execute Test---------------------------
sharepointListDesignerViewModelBase.SelectedList = sharepointListTo;
//------------Assert Results-------------------------
Assert.IsNotNull(sharepointListDesignerViewModelBase.SelectedList);
Assert.IsNotNull(sharepointListDesignerViewModelBase.ListItems);
Assert.AreEqual(5, sharepointListDesignerViewModelBase.ListItems.Count);
Assert.AreEqual("Name 1", sharepointListDesignerViewModelBase.ListItems[0].FieldName);
Assert.AreEqual("Field 1", sharepointListDesignerViewModelBase.ListItems[0].InternalName);
Assert.AreEqual(SharepointFieldType.Text.ToString(), sharepointListDesignerViewModelBase.ListItems[0].Type);
Assert.IsFalse(sharepointListDesignerViewModelBase.ListItems[0].IsRequired);
Assert.AreEqual("[[ShareList(*).Name1]]", sharepointListDesignerViewModelBase.ListItems[0].VariableName);
Assert.AreEqual("[[ShareList(*).MyField1]]", sharepointListDesignerViewModelBase.ListItems[1].VariableName);
Assert.AreEqual("[[ShareList(*).x0031_FieldName]]", sharepointListDesignerViewModelBase.ListItems[2].VariableName);
Assert.AreEqual("[[ShareList(*).FieldName]]", sharepointListDesignerViewModelBase.ListItems[3].VariableName);
Assert.AreEqual("[[ShareList(*).Fiele_1]]", sharepointListDesignerViewModelBase.ListItems[4].VariableName);
}
List <ISharepointFieldTo> GetListFields(ISharepointSource source, SharepointListTo list)
{
var columns = _environmentModel.ResourceRepository.GetSharepointListFields(source, list, _loadOnlyEditableFields);
return(columns ?? new List <ISharepointFieldTo>());
}
static string GetListName(SharepointListTo table)
{
return(table == null ? null : table.FullName);
}
static string GetListName(SharepointListTo table)
{
return(table?.FullName);
}
public List <ISharepointFieldTo> GetSharepointListFields(ISharepointSource source, SharepointListTo list, bool onlyEditableFields)
{
var comController = new CommunicationController {
ServiceName = "GetSharepointListFields"
};
comController.AddPayloadArgument("SharepointServer", _serializer.Serialize(source));
comController.AddPayloadArgument("ListName", _serializer.Serialize(list.FullName));
comController.AddPayloadArgument("OnlyEditable", _serializer.Serialize(onlyEditableFields));
var fields = comController.ExecuteCommand <List <ISharepointFieldTo> >(_server.Connection, GlobalConstants.ServerWorkspaceID);
return(fields);
}
