/// <summary>
/// Generate sql script to create assembly
/// </summary>
/// <param name="clrAssembly"></param>
/// <param name="permissionSet">sql server permission set</param>
/// <returns></returns>
public static string CreateSqlFromAssemblyDll(Assembly clrAssembly, PermissionSetType permissionSet)
{
const string sqlTemplate = @"
-- Create assembly '{0}' from dll
CREATE ASSEMBLY [{0}]
AUTHORIZATION [dbo]
FROM 0x{2}
WITH PERMISSION_SET = {1};
";
StringBuilder bytes = new StringBuilder();
using (FileStream dll = File.OpenRead(clrAssembly.Location))
{
int @byte;
while ((@byte = dll.ReadByte()) >= 0)
{
bytes.AppendFormat("{0:X2}", @byte);
}
}
string sql = string.Format(sqlTemplate, clrAssembly.GetName().Name, permissionSet, bytes);
return(sql);
}
/// <summary>
/// generate sql from an assembly dll with all functions with attribute SqlFunction
/// </summary>
/// <param name="clrAssembly">assembly object</param>
/// <param name="permissionSet">sql server permission set</param>
/// <returns>sql script</returns>
public static string CreateFunctionsFromAssembly(Assembly clrAssembly, PermissionSetType permissionSet)
{
const string sqlTemplate = @"
ALTER DATABASE ProlexNet SET TRUSTWORTHY ON
-- Delete all functions from assembly '{0}'
DECLARE @sql NVARCHAR(MAX)
SET @sql = 'DROP FUNCTION ' + STUFF(
(
SELECT
', ' + assembly_method
FROM
sys.assembly_modules
WHERE
assembly_id IN (SELECT assembly_id FROM sys.assemblies WHERE name = '{0}')
FOR XML PATH('')
), 1, 1, '')
IF @sql IS NOT NULL EXEC sp_executesql @sql
GO
-- Delete existing assembly '{0}' if necessary
IF EXISTS(SELECT 1 FROM sys.assemblies WHERE name = '{0}')
DROP ASSEMBLY {0};
GO
{1}
GO
-- Create all functions from assembly '{0}'
";
string assemblyName = clrAssembly.GetName().Name;
StringBuilder sql = new StringBuilder();
sql.AppendFormat(sqlTemplate, assemblyName, CreateSqlFromAssemblyDll(clrAssembly, permissionSet));
foreach (Type classInfo in clrAssembly.GetTypes())
{
foreach (MethodInfo methodInfo in classInfo.GetMethods(BindingFlags.Static | BindingFlags.Public | BindingFlags.DeclaredOnly))
{
if (Attribute.IsDefined(methodInfo, typeof(SqlFunctionAttribute)))
{
StringBuilder methodParameters = new StringBuilder();
bool firstParameter = true;
foreach (ParameterInfo paramInfo in methodInfo.GetParameters())
{
if (firstParameter)
{
firstParameter = false;
}
else
{
methodParameters.Append(", ");
}
methodParameters.AppendFormat(@"@{0} {1}", paramInfo.Name, ConvertClrTypeToSql(paramInfo.ParameterType));
}
string returnType = ConvertClrTypeToSql(methodInfo.ReturnParameter.ParameterType);
string methodName = methodInfo.Name;
string className = (classInfo.Namespace == null ? "" : classInfo.Namespace + ".") + classInfo.Name;
string externalName = $@"{assemblyName}.[{className}].{methodName}";
sql.AppendFormat(@"CREATE FUNCTION {0}({1}) RETURNS {2} AS EXTERNAL NAME {3};", methodName, methodParameters, returnType, externalName)
.Append("\nGO\n");
}
}
}
//sql.AppendLine("ALTER DATABASE ProlexNet SET TRUSTWORTHY OFF");
return(sql.ToString());
}
public void MSOXWSFOLD_S08_TC01_AllOperationsWithAllOptionalElements()
{
#region Configure SOAP header
this.ConfigureSOAPHeader();
#endregion
#region Create new folders in the inbox folder.
// CreateFolder request.
CreateFolderType createFolderRequest = this.GetCreateFolderRequest(
DistinguishedFolderIdNameType.inbox.ToString(),
new string[] { "Custom Folder1", "Custom Folder2", "Custom Folder3", "Custom Folder4" },
new string[] { "IPF.MyCustomFolderClass", "IPF.Appointment", "IPF.Contact", "IPF.Task" },
null);
// Set ExtendedProperty defined in BaseFolderType.
PathToExtendedFieldType publishInAddressBook = new PathToExtendedFieldType();
// A hexadecimal tag of the extended property.
publishInAddressBook.PropertyTag = "0x671E";
publishInAddressBook.PropertyType = MapiPropertyTypeType.Boolean;
ExtendedPropertyType pubAddressbook = new ExtendedPropertyType();
pubAddressbook.ExtendedFieldURI = publishInAddressBook;
pubAddressbook.Item = "1";
ExtendedPropertyType[] extendedProperties = new ExtendedPropertyType[1];
extendedProperties[0] = pubAddressbook;
createFolderRequest.Folders[0].ExtendedProperty = extendedProperties;
createFolderRequest.Folders[1].ExtendedProperty = extendedProperties;
createFolderRequest.Folders[2].ExtendedProperty = extendedProperties;
createFolderRequest.Folders[3].ExtendedProperty = extendedProperties;
// Define a permissionSet with all optional elements
PermissionSetType permissionSet = new PermissionSetType();
permissionSet.Permissions = new PermissionType[1];
permissionSet.Permissions[0] = new PermissionType();
permissionSet.Permissions[0].ReadItems = new PermissionReadAccessType();
permissionSet.Permissions[0].ReadItems = PermissionReadAccessType.FullDetails;
permissionSet.Permissions[0].ReadItemsSpecified = true;
permissionSet.Permissions[0].CanCreateItems = true;
permissionSet.Permissions[0].CanCreateItemsSpecified = true;
permissionSet.Permissions[0].CanCreateSubFolders = true;
permissionSet.Permissions[0].CanCreateSubFoldersSpecified = true;
permissionSet.Permissions[0].IsFolderVisible = true;
permissionSet.Permissions[0].IsFolderVisibleSpecified = true;
permissionSet.Permissions[0].IsFolderContact = true;
permissionSet.Permissions[0].IsFolderContactSpecified = true;
permissionSet.Permissions[0].IsFolderOwner = true;
permissionSet.Permissions[0].IsFolderOwnerSpecified = true;
permissionSet.Permissions[0].IsFolderContact = true;
permissionSet.Permissions[0].IsFolderContactSpecified = true;
permissionSet.Permissions[0].EditItems = new PermissionActionType();
permissionSet.Permissions[0].EditItems = PermissionActionType.All;
permissionSet.Permissions[0].EditItemsSpecified = true;
permissionSet.Permissions[0].DeleteItems = new PermissionActionType();
permissionSet.Permissions[0].DeleteItems = PermissionActionType.All;
permissionSet.Permissions[0].DeleteItemsSpecified = true;
permissionSet.Permissions[0].PermissionLevel = new PermissionLevelType();
permissionSet.Permissions[0].PermissionLevel = PermissionLevelType.Custom;
permissionSet.Permissions[0].UserId = new UserIdType();
permissionSet.Permissions[0].UserId.PrimarySmtpAddress = Common.GetConfigurationPropertyValue("User2Name", this.Site) + "@" + Common.GetConfigurationPropertyValue("Domain", this.Site);
// Set PermissionSet for FolderType folder.
((FolderType)createFolderRequest.Folders[0]).PermissionSet = permissionSet;
// Set PermissionSet for ContactsType folder.
((ContactsFolderType)createFolderRequest.Folders[2]).PermissionSet = permissionSet;
// Set PermissionSet for TasksFolderType folder.
((TasksFolderType)createFolderRequest.Folders[3]).PermissionSet = permissionSet;
// Create a new folder.
CreateFolderResponseType createFolderResponse = this.FOLDAdapter.CreateFolder(createFolderRequest);
// Check the response.
Common.CheckOperationSuccess(createFolderResponse, 4, this.Site);
// Folder ids.
FolderIdType[] folderIds = new FolderIdType[createFolderResponse.ResponseMessages.Items.Length];
for (int index = 0; index < createFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, createFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder should be created successfully!");
// Save folder ids.
folderIds[index] = ((FolderInfoResponseMessageType)createFolderResponse.ResponseMessages.Items[index]).Folders[0].FolderId;
// Save the new created folder's folder id.
this.NewCreatedFolderIds.Add(folderIds[index]);
}
#endregion
#region Create a managedfolder
CreateManagedFolderRequestType createManagedFolderRequest = this.GetCreateManagedFolderRequest(Common.GetConfigurationPropertyValue("ManagedFolderName1", this.Site));
// Add an email address into request.
EmailAddressType mailBox = new EmailAddressType()
{
EmailAddress = Common.GetConfigurationPropertyValue("User1Name", this.Site) + "@" + Common.GetConfigurationPropertyValue("Domain", this.Site)
};
createManagedFolderRequest.Mailbox = mailBox;
// Create the specified managed folder.
CreateManagedFolderResponseType createManagedFolderResponse = this.FOLDAdapter.CreateManagedFolder(createManagedFolderRequest);
// Check the response.
Common.CheckOperationSuccess(createManagedFolderResponse, 1, this.Site);
// Save the new created managed folder's folder id.
FolderIdType newFolderId = ((FolderInfoResponseMessageType)createManagedFolderResponse.ResponseMessages.Items[0]).Folders[0].FolderId;
this.NewCreatedFolderIds.Add(newFolderId);
#endregion
#region Get the new created folders
// GetFolder request.
GetFolderType getCreatedFolderRequest = this.GetGetFolderRequest(DefaultShapeNamesType.AllProperties, folderIds);
// Get the new created folder.
GetFolderResponseType getCreatedFolderResponse = this.FOLDAdapter.GetFolder(getCreatedFolderRequest);
// Check the response.
Common.CheckOperationSuccess(getCreatedFolderResponse, 4, this.Site);
for (int index = 0; index < getCreatedFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, getCreatedFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder information should be returned!");
}
#endregion
#region Update the new created folders
// UpdateFolder request.
UpdateFolderType updateFolderRequest = this.GetUpdateFolderRequest(
new string[] { "Folder", "CalendarFolder", "ContactsFolder", "TasksFolder" },
new string[] { "SetFolderField", "SetFolderField", "SetFolderField", "SetFolderField" },
folderIds);
// Update the folders' properties.
UpdateFolderResponseType updateFolderResponse = this.FOLDAdapter.UpdateFolder(updateFolderRequest);
// Check the response.
Common.CheckOperationSuccess(updateFolderResponse, 4, this.Site);
for (int index = 0; index < updateFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, updateFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder should be updated successfully!");
}
#endregion
#region Copy the updated folders to "drafts" folder
// Copy the folders into "drafts" folder
CopyFolderType copyFolderRequest = this.GetCopyFolderRequest(DistinguishedFolderIdNameType.drafts.ToString(), folderIds);
// Copy the folders.
CopyFolderResponseType copyFolderResponse = this.FOLDAdapter.CopyFolder(copyFolderRequest);
// Check the response.
Common.CheckOperationSuccess(copyFolderResponse, 4, this.Site);
// Copied Folders' id.
FolderIdType[] copiedFolderIds = new FolderIdType[copyFolderResponse.ResponseMessages.Items.Length];
for (int index = 0; index < copyFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, copyFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder should be updated successfully!");
// Variable to save the folders.
copiedFolderIds[index] = ((FolderInfoResponseMessageType)copyFolderResponse.ResponseMessages.Items[index]).Folders[0].FolderId;
// Save the copied folders' folder id.
this.NewCreatedFolderIds.Add(copiedFolderIds[index]);
}
#endregion
#region Move the updated folders to "deleteditems" folder
// MoveFolder request.
MoveFolderType moveFolderRequest = new MoveFolderType();
// Set the request's folderId field.
moveFolderRequest.FolderIds = folderIds;
// Set the request's destFolderId field.
DistinguishedFolderIdType toFolderId = new DistinguishedFolderIdType();
toFolderId.Id = DistinguishedFolderIdNameType.deleteditems;
moveFolderRequest.ToFolderId = new TargetFolderIdType();
moveFolderRequest.ToFolderId.Item = toFolderId;
// Move the specified folders.
MoveFolderResponseType moveFolderResponse = this.FOLDAdapter.MoveFolder(moveFolderRequest);
// Check the response.
Common.CheckOperationSuccess(moveFolderResponse, 4, this.Site);
for (int index = 0; index < moveFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, moveFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder should be updated successfully!");
}
#endregion
#region Delete all folders
// All folder ids.
FolderIdType[] allFolderIds = new FolderIdType[folderIds.Length + copiedFolderIds.Length];
for (int index = 0; index < allFolderIds.Length / 2; index++)
{
allFolderIds[index] = folderIds[index];
allFolderIds[index + folderIds.Length] = copiedFolderIds[index];
}
// DeleteFolder request.
DeleteFolderType deleteFolderRequest = this.GetDeleteFolderRequest(DisposalType.HardDelete, allFolderIds);
// Delete the specified folder.
DeleteFolderResponseType deleteFolderResponse = this.FOLDAdapter.DeleteFolder(deleteFolderRequest);
// Check the response.
Common.CheckOperationSuccess(deleteFolderResponse, 8, this.Site);
for (int index = 0; index < deleteFolderResponse.ResponseMessages.Items.Length; index++)
{
Site.Assert.AreEqual <ResponseClassType>(ResponseClassType.Success, deleteFolderResponse.ResponseMessages.Items[index].ResponseClass, "Folder should be updated successfully!");
}
#endregion
}
public void MSOXWSFOLD_S06_TC04_UpdateFolderWithDeleteFolderFieldType()
{
#region Create a new folder in the inbox folder
// Configure permission set.
PermissionSetType permissionSet = new PermissionSetType();
permissionSet.Permissions = new PermissionType[1];
permissionSet.Permissions[0] = new PermissionType();
permissionSet.Permissions[0].CanCreateSubFolders = true;
permissionSet.Permissions[0].CanCreateSubFoldersSpecified = true;
permissionSet.Permissions[0].IsFolderOwner = true;
permissionSet.Permissions[0].IsFolderOwnerSpecified = true;
permissionSet.Permissions[0].PermissionLevel = new PermissionLevelType();
permissionSet.Permissions[0].PermissionLevel = PermissionLevelType.Custom;
permissionSet.Permissions[0].UserId = new UserIdType();
permissionSet.Permissions[0].UserId.PrimarySmtpAddress = Common.GetConfigurationPropertyValue("User2Name", this.Site) + "@" + Common.GetConfigurationPropertyValue("Domain", this.Site);
// CreateFolder request.
CreateFolderType createFolderRequest = this.GetCreateFolderRequest(DistinguishedFolderIdNameType.inbox.ToString(), new string[] { "Custom Folder" }, new string[] { "IPF.MyCustomFolderClass" }, new PermissionSetType[] { permissionSet });
// Create a new folder.
CreateFolderResponseType createFolderResponse = this.FOLDAdapter.CreateFolder(createFolderRequest);
// Check the response.
Common.CheckOperationSuccess(createFolderResponse, 1, this.Site);
// Save the new created folder's folder id.
FolderIdType newFolderId = ((FolderInfoResponseMessageType)createFolderResponse.ResponseMessages.Items[0]).Folders[0].FolderId;
this.NewCreatedFolderIds.Add(newFolderId);
#endregion
#region Update Folder Operation.
// UpdateFolder request to delete folder permission value.
UpdateFolderType updateFolderRequest = this.GetUpdateFolderRequest("Folder", "DeleteFolderField", newFolderId);
// Update the specific folder's properties.
UpdateFolderResponseType updateFolderResponse = this.FOLDAdapter.UpdateFolder(updateFolderRequest);
// Check the response.
Common.CheckOperationSuccess(updateFolderResponse, 1, this.Site);
#endregion
#region Switch user
this.SwitchUser(Common.GetConfigurationPropertyValue("User2Name", this.Site), Common.GetConfigurationPropertyValue("User2Password", this.Site), Common.GetConfigurationPropertyValue("Domain", this.Site));
#endregion
#region Create a subfolder under the folder created in step 1 with User2's credential
// CreateFolder request.
CreateFolderType createFolderInSharedMailboxRequest = this.GetCreateFolderRequest(newFolderId.Id, new string[] { "Custom Folder" }, new string[] { "IPF.MyCustomFolderClass" }, null);
// Create a new folder.
CreateFolderResponseType createFolderInSharedMailboxResponse = this.FOLDAdapter.CreateFolder(createFolderInSharedMailboxRequest);
// Check the length.
Site.Assert.AreEqual <int>(
1,
createFolderInSharedMailboxResponse.ResponseMessages.Items.GetLength(0),
"Expected Item Count: {0}, Actual Item Count: {1}",
1,
createFolderInSharedMailboxResponse.ResponseMessages.Items.GetLength(0));
// Permission have been deleted so create operation should be failed.
bool isPermissionDeleted = createFolderInSharedMailboxResponse.ResponseMessages.Items[0].ResponseClass.Equals(ResponseClassType.Error);
#endregion
// Add the debug information
this.Site.Log.Add(LogEntryKind.Debug, "Verify MS-OXWSFOLD_R583");
// Verify MS-OXWSFOLD requirement: MS-OXWSFOLD_R583
// One permission set which set in CreateFolder is deleted when calling UpdateFolder.
this.Site.CaptureRequirementIfIsTrue(
isPermissionDeleted,
583,
@"[In t:DeleteFolderFieldType Complex Type]The DeleteFolderFieldType complex type represents an UpdateFolder operation to delete a property from a folder.");
// Add the debug information
this.Site.Log.Add(LogEntryKind.Debug, "Verify MS-OXWSFOLD_R5261");
// Verify MS-OXWSFOLD requirement: MS-OXWSFOLD_R5261
this.Site.CaptureRequirementIfIsTrue(
isPermissionDeleted,
5261,
@"[In t:NonEmptyArrayOfFolderChangeDescriptionsType Complex Type]DeleteFolderField represents an UpdateFolder operation to delete a property from a folder.");
}
