//Ищем связанные NA. в случае нахождения модуля - проверяем связь с локацией и сохраняем Location_Id
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> SubChild(Guid G)
{
try
{
EnterpriseManagementObject EMO = null;
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> rel = null; //new EnterpriseManagementRelationshipObject<EnterpriseManagementObject>();
var T_objects = emg.EntityObjects.GetRelationshipObjectsWhereSource <EnterpriseManagementObject>(G, relNetworkAdapterHasChildNetworkAdapter, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj in T_objects)
{
rel = relobj;
EMO = relobj.TargetObject;
}
if (EMO.IsInstanceOf(classModule))
{
var G_objects = emg.EntityObjects.GetRelationshipObjectsWhereTarget <EnterpriseManagementObject>(EMO.Id, relLocationContainsConfigItem, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> confobj in G_objects)
{
Location_Id = confobj.SourceObject.Id;
}
}
return(rel);
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("SubChild procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
}
//Ищем связанные NA. в случае нахождения модуля - проверяем связь с локацией и сохраняем Location_Id
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> Get_Relationship(Guid G)
{
//try
//{
EnterpriseManagementObject EMO = null;
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> rel = null; //new EnterpriseManagementRelationshipObject<EnterpriseManagementObject>();
var T_objects = emg.EntityObjects.GetRelationshipObjectsWhereTarget <EnterpriseManagementObject>(G, relChildNetworkAdapterRefParentNetworkAdapter, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj in T_objects)
{
rel = relobj;
EMO = relobj.SourceObject;
}
if (classModule != null && EMO != null)
{
if (EMO.IsInstanceOf(classModule))
{
var G_objects = emg.EntityObjects.GetRelationshipObjectsWhereSource <EnterpriseManagementObject>(EMO.Id, relConfigItemRefLocation, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> confobj in G_objects)
{
Location_Id = confobj.TargetObject.Id;
}
}
}
return(rel);
//}
//catch (Exception ex)
//{
// System.Windows.MessageBox.Show("Get_Relationship procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
// return null;
//}
}
public static EnterpriseManagementRelationshipObject <EnterpriseManagementObject> GetSingleRelationship(EnterpriseManagementGroup emg, ManagementPackRelationship classRelationship, Guid Id, bool IdObjectIsSource)
{
try
{
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relObject = null;
if (IdObjectIsSource)
{
var items = emg.EntityObjects.GetRelationshipObjectsWhereSource <EnterpriseManagementObject>(Id, classRelationship, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> rel in items)
{
relObject = rel;
}
}
else
{
var items = emg.EntityObjects.GetRelationshipObjectsWhereTarget <EnterpriseManagementObject>(Id, classRelationship, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> rel in items)
{
relObject = rel;
}
}
return(relObject);
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("_Rel procedure error : " + ex.Message, "Service Manager");
return(null);
}
}
ObservableCollection <TreeViewItem> BuildCollection(TreeViewItem TVI)
{
//try
//{
if (TVI == null)
{
System.Windows.MessageBox.Show("TVI is null");
}
TreeViewItem newItem = new TreeViewItem();
TreeViewItem newItemCabel = new TreeViewItem();
ObservableCollection <TreeViewItem> Col = new ObservableCollection <TreeViewItem>();
Col.Add(TVI);
Guid G = (Guid)TVI.Tag;
bool t = true;
while (t == true)
{
//newItem = SubChild(G);
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj = SubChild(G);
if (relobj != null)
{
newItemCabel = new TreeViewItem();
newItemCabel.Header = "Cable.Footage:" + relobj[relNetworkAdapterHasChildNetworkAdapter, "ParentFootage"].Value + ":" + relobj[relNetworkAdapterHasChildNetworkAdapter, "ParentFootage"].Value;
newItemCabel.Tag = "Cabel";//relobj.TargetObject.Id;
Col.Add(newItemCabel);
newItem = new TreeViewItem();
newItem.Header = relobj.TargetObject.FullName;
newItem.Tag = relobj.TargetObject.Id;
Col.Add(newItem);
G = (Guid)newItem.Tag;
}
else
{
t = false;
}
}
return(Col);
//сортировка не нужна т.к. связь один к одному
//}
// catch (Exception ex)
// {
// System.Windows.MessageBox.Show("BuildCollection procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
// return null;
// }
}
ObservableCollection <TreeViewItem> BuildCollection(TreeViewItem TVI)
{
//try
//{
TreeViewItem newItem = new TreeViewItem();
TreeViewItem newItemCabel = new TreeViewItem();
ObservableCollection <TreeViewItem> Col = new ObservableCollection <TreeViewItem>();
Col.Add(TVI);
Guid NA_Id = (Guid)TVI.Tag;
bool t = true;
while (t == true)
{
//newItem = SubChild(G);
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj = Get_Relationship(NA_Id);
if (relobj != null)
{
newItemCabel = new TreeViewItem();
newItemCabel.Header = "Cable.Footage:" + relobj[relChildNetworkAdapterRefParentNetworkAdapter, "ParentFootage"].Value + ":" + relobj[relChildNetworkAdapterRefParentNetworkAdapter, "ParentFootage"].Value;
newItemCabel.Tag = relobj.Id;
Col.Add(newItemCabel);
newItem = new TreeViewItem();
newItem.Header = relobj.SourceObject.FullName;
newItem.Tag = relobj.SourceObject.Id;
Col.Add(newItem);
//LogFile.Write(String.Format("Debug. relobj.SourceObject.FullName {0}", relobj.SourceObject.FullName), false);
NA_Id = (Guid)newItem.Tag;
}
else
{
t = false;
}
}
return(Col);
//сортировка не нужна т.к. связь один к одному
//}
// catch (Exception ex)
// {
// System.Windows.MessageBox.Show("BuildCollection procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
// return null;
// }
}
static EnterpriseManagementRelationshipObject <EnterpriseManagementObject> SubChild(Guid G)
{
try
{
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> rel = null; //new EnterpriseManagementRelationshipObject<EnterpriseManagementObject>();
var T_objects = emg.EntityObjects.GetRelationshipObjectsWhereSource <EnterpriseManagementObject>(G, relNetworkAdapterHasChildNetworkAdapter, DerivedClassTraversalDepth.None, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj in T_objects)
{
rel = relobj;
}
return(rel);
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("SubChild procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
return(null);
}
}
ObservableCollection <TreeViewItem> BuildCollection(TreeViewItem ParentTVI)
{
//try
//{
TreeViewItem newItem = new TreeViewItem();
TreeViewItem newItemCabel = new TreeViewItem();
ObservableCollection <TreeViewItem> Col = new ObservableCollection <TreeViewItem>();
Col.Add(ParentTVI);
Guid NA_Id = (Guid)ParentTVI.Tag;
bool t = true;
while (t == true)
{
//newItem = SubChild(G);
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relobj = Get_Relationship(NA_Id);
if (relobj != null)
{
newItemCabel = new TreeViewItem();
newItemCabel.Header = "Cable.Footage:" + relobj[relChildNetworkAdapterRefParentNetworkAdapter, "ParentFootage"].Value + ":" + relobj[relChildNetworkAdapterRefParentNetworkAdapter, "ChildFootage"].Value;
newItemCabel.Tag = relobj.Id;
Col.Add(newItemCabel);
newItem = new TreeViewItem();
newItem.Header = relobj.SourceObject.FullName;
newItem.Tag = relobj.SourceObject.Id;
Col.Add(newItem);
//Set Objects
if (classNodePort != null)
{
if (relobj.SourceObject.IsInstanceOf(classModule))
{
emo_Module = relobj.SourceObject;
}
else if (relobj.SourceObject.IsInstanceOf(classNAPort))
{
if (emo_PPP1 == null)
{
emo_PPP1 = relobj.SourceObject;
}
else
{
emo_PPP2 = relobj.SourceObject;
}
}
else if (relobj.SourceObject.IsInstanceOf(classNodePort))
{
emo_NodePort = relobj.SourceObject; // логике этот вариант никогда не наступит
}
}
if (relobj.SourceObject.IsInstanceOf(classDeviceNA) || relobj.SourceObject.IsInstanceOf(classComputerNA))
{
emo_ClientNA = relobj.SourceObject;
}
//LogFile.Write(String.Format("Debug. relobj.SourceObject.FullName {0}", relobj.SourceObject.FullName), false);
NA_Id = (Guid)newItem.Tag;
}
else
{
t = false;
}
}
return(Col);
//сортировка не нужна т.к. связь один к одному
//}
// catch (Exception ex)
// {
// System.Windows.MessageBox.Show("BuildCollection procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
// return null;
// }
}
//execute the Workflow to Notify the Assigned User
protected override ActivityExecutionStatus Execute(ActivityExecutionContext TTUExecutionContext)
{
//since workflows only run on the workflow server, we can safely
//connect and execute against the localhost
EnterpriseManagementGroup emg = new EnterpriseManagementGroup("localhost");
//Get the classes we need to work with
/*
* get-scsmclass -name "System.WorkItem.TroubleTicket.AnalystCommentLog" | select name, id
* get-scsmclass -name "System.WorkItem.TroubleTicket.UserCommentLog" | select name, id
* get-scsmrelationshipclass -name "System.WorkItem.TroubleTicketHasAnalystComment" | select name, id
* https://github.com/SMLets/SMLets/blob/55f1bac3bc7a7011a461b24f6d7787ba89fe2624/SMLets.Shared/Code/EntityTypes.cs#L120
* https://github.com/SMLets/SMLets/blob/55f1bac3bc7a7011a461b24f6d7787ba89fe2624/SMLets.Shared/Code/EntityTypes.cs#L161
*/
ManagementPackClass UserCommentClass = emg.EntityTypes.GetClass(new Guid("a3d4e16f-5e8a-18ba-9198-d9815194c986"));
ManagementPackClass UserClass = emg.EntityTypes.GetClass(new Guid("943d298f-d79a-7a29-a335-8833e582d252"));
ManagementPackClass LocalizationClass = emg.EntityTypes.GetClass(new Guid("efa8bbd3-3fa4-2f37-d0d5-7a6bf53be7c8"));
ManagementPackRelationship TroubleTicketHasUserCommentRelClass = emg.EntityTypes.GetRelationshipClass(new Guid("ce423786-16dd-da9c-fb7b-21ab5189e12b"));
ManagementPackRelationship AssignedUserRelClass = emg.EntityTypes.GetRelationshipClass(new Guid("15e577a3-6bf9-6713-4eac-ba5a5b7c4722"));
ManagementPackRelationship UserHasPreferenceRelClass = emg.EntityTypes.GetRelationshipClass(new Guid("649e37ab-bf89-8617-94f6-d4d041a05171"));
//Get the Template GUID from the Translate MP
EnterpriseManagementObject emoAdminSetting = emg.EntityObjects.GetObject <EnterpriseManagementObject>(new Guid("49a053e7-6080-e211-fd79-ca3607eecce7"), ObjectQueryOptions.Default);
string templateID = emoAdminSetting[null, "TroubleTicketUserCommentTemplate"].Value.ToString();
bool isAzureTranslateEnabled;
try { isAzureTranslateEnabled = Boolean.Parse(emoAdminSetting[null, "EnableAzureTranslate"].ToString()); }
catch { isAzureTranslateEnabled = false; }
//get the objects we'll need to work with starting with...
//Comment object, the string/guid is an incoming parameter from the management pack
//$commentObject = Get-SCSMObject -id "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
Guid CommentGuid = new Guid(this.InstanceIds[0].ToString());
EnterpriseManagementObject CommentObject = emg.EntityObjects.GetObject <EnterpriseManagementObject>(CommentGuid, ObjectQueryOptions.Default);
//Comment and Work Item relationship object
//Using SMLets' Get-SCSMRelationshipObject -ByTarget parameter: https://github.com/SMLets/SMLets/blob/55f1bac3bc7a7011a461b24f6d7787ba89fe2624/SMLets.Shared/Code/EntityObjects.cs#L1853
//$WorkItemActionLogRelObject = Get-SCSMRelationshipObject -ByTarget $commentObject | ?{$_.relationshipid -eq "835a64cd-7d41-10eb-e5e4-365ea2efc2ea"}
IList <EnterpriseManagementRelationshipObject <EnterpriseManagementObject> > CommentWorkItemRelObjects = emg.EntityObjects.GetRelationshipObjectsWhereTarget <EnterpriseManagementObject>(CommentObject.Id, ObjectQueryOptions.Default);
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> WorkItemActionLogRelObject = null;
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relObject in CommentWorkItemRelObjects)
{
//if the relationship object has an ID that is the TroubleTicketHasUserCommentRelClass, then update the variable above with it
if (relObject.RelationshipId.ToString() == TroubleTicketHasUserCommentRelClass.Id.ToString())
{
//we now have the relationship object that contains the Comment and the Work Item
WorkItemActionLogRelObject = relObject;
break;
}
}
//if the WorkItemActionLogRelObject is empty, we have a Service Request
//end this workflow and let the other carry out
if (WorkItemActionLogRelObject == null)
{
return(base.Execute(TTUExecutionContext));
}
//Work Item object
//Get-SCSMObject -id $WorkItemActionLogRelObject.SourceObject.Id
EnterpriseManagementObject WorkItem = emg.EntityObjects.GetObject <EnterpriseManagementObject>(WorkItemActionLogRelObject.SourceObject.Id, ObjectQueryOptions.Default);
//Assigned User relationship object
IList <EnterpriseManagementRelationshipObject <EnterpriseManagementObject> > WorkItemRelUsers = emg.EntityObjects.GetRelationshipObjectsWhereSource <EnterpriseManagementObject>(WorkItem.Id, TraversalDepth.Recursive, ObjectQueryOptions.Default);
EnterpriseManagementObject AssignedUser = null;
foreach (EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relObject in WorkItemRelUsers)
{
//if the relationship object has an ID that is the Assigned User and it isn't an old (isDeleted) user, then update the variable above with it
if ((relObject.RelationshipId == AssignedUserRelClass.Id) && (relObject.IsDeleted == false))
{
//we now have the relationship object that contains the Assigned User
AssignedUser = relObject.TargetObject;
break;
}
}
//if the Assigned User exists, try and retrieve their Locale
if (AssignedUser != null)
{
//Try to retrieve the Assigned User's Locale
//Affected User's Preference relationship objects
//https://github.com/SMLets/SMLets/blob/55f1bac3bc7a7011a461b24f6d7787ba89fe2624/SMLets.Shared/Code/EntityObjects.cs#L2775
//Get-SCSMRelatedObject -SMObject AffectedUser
EnterpriseManagementObject AssignedUserLocale = null;
//get the Assigned User's locale
IList <EnterpriseManagementObject> AssignedUserPreferences = emg.EntityObjects.GetRelatedObjects <EnterpriseManagementObject>(AssignedUser.Id, TraversalDepth.OneLevel, ObjectQueryOptions.Default);
foreach (EnterpriseManagementObject preference in AssignedUserPreferences)
{
if (preference.GetClasses()[0].Name == "System.UserPreference.Localization")
{
AssignedUserLocale = preference;
break;
}
}
//check if the Assigned User has a defined Locale, if they do and Azure Translate is enabled we can go ahead with a comparison.
if ((AssignedUserLocale != null) && (isAzureTranslateEnabled))
{
//get the Assigned User's locale
string AssignedUserLocaleCode = AssignedUserLocale[(ManagementPackType)LocalizationClass, "LocaleID"].Value.ToString();
//get the Assigned User's language code
//PowerShell equivalent:
//[System.Globalization.Cultureinfo]::GetCultureInfo(LocaleCode).TwoLetterISOLanguageName
string AssignedUserLangCode = System.Globalization.CultureInfo.GetCultureInfo(int.Parse(AssignedUserLocaleCode)).TwoLetterISOLanguageName.ToString().ToLower();
//now we need determine the language of the comment that was left
//first, grab the Comment object and it's actual comment that was left
//second, grab the person who entered the comment
string CommentText = CommentObject[(ManagementPackType)UserCommentClass, "Comment"].Value.ToString();
string EnteredBy = CommentObject[(ManagementPackType)UserCommentClass, "EnteredBy"].Value.ToString();
int CommentFirstSentencePeriod = CommentText.IndexOf(".");
//use a period to try to find the end of the first sentence to save on Azure spend
//second, make the call to the Azure Translate class in this project to Detect the language code of the comment
AzureCognitiveServicesTranslate languageManipulation = new AzureCognitiveServicesTranslate();
string CommentLangCode = null;
string CommentLangDetectSample = null;
int CommentLangDetectSamplePeriodIndex = CommentText.IndexOf(".");
try
{
CommentLangDetectSample = CommentText.Substring(0, CommentLangDetectSamplePeriodIndex);
}
catch
{
CommentLangDetectSample = CommentText;
}
if (CommentLangDetectSample.Length > 1)
{
CommentLangCode = languageManipulation.LanguageDetect(emg, CommentLangDetectSample);
}
else
{
CommentLangCode = languageManipulation.LanguageDetect(emg, CommentText);
}
//if the detected Comment Language is different than that of the Assigned User then...
//translate, leave the translated comment on the Action Log, notify on the new translated entry
//this if statement would compare as seen below:
//if ("en" != "es")
if (CommentLangCode != AssignedUserLangCode)
{
//different languages
//translate with Azure
string translatedComment = languageManipulation.LanguageTranslate(emg, CommentLangCode, AssignedUserLangCode, CommentText);
//create a New translated User Comment via projection/function from Rob Ford on TechNet
//https://social.technet.microsoft.com/Forums/WINDOWS/en-US/1f06e71c-00f4-4cf7-9f7e-a9a78b4b907c/creating-action-log-entry-for-incident-via-sdk-in-c?forum=customization
AddActionLogEntry newComment = new AddActionLogEntry();
string newCommentGuid = newComment.AddToActionLog(emg, WorkItem, translatedComment, EnteredBy, "UserCommentLog");
//notify on the new comment using the recently created comment's guid instead of the one that came in from the workflow parameter
NotifyUser notification = new NotifyUser();
notification.SendNotification(this.SubscriptionId, this.DataItems, newCommentGuid, new String[] { templateID }, new String[] { AssignedUser.Id.ToString() }, TTUExecutionContext);
}
else
{
//same language
//notify on the original comment
NotifyUser notification = new NotifyUser();
notification.SendNotification(this.SubscriptionId, this.DataItems, this.InstanceIds[0].ToString(), new String[] { templateID }, new String[] { AssignedUser.Id.ToString() }, TTUExecutionContext);
}
}
else
{
//the Affected user doesn't have a locale or Azure Translate isn't enabled, just notify them
//notify the User
NotifyUser notification = new NotifyUser();
notification.SendNotification(this.SubscriptionId, this.DataItems, this.InstanceIds[0].ToString(), new String[] { templateID }, new String[] { AssignedUser.Id.ToString() }, TTUExecutionContext);
}
}
else
{
//the assigned user doesn't exist, so there isn't anyone to notify
}
return(base.Execute(TTUExecutionContext));
}
private void UIItem_MouseRightButtonUp(object sender, MouseButtonEventArgs e)
{
try
{
Point currentPosition = e.GetPosition(this.Map as UIElement);
MovingUI.ReleaseMouseCapture();
isDragging = false;
//RoomMoving = false;
if (MovingUI != RoomUI)
{
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relloc = _Rel.GetSingleRelationship(emg, relConfigItemRefLocation, MovingUI.ModuleId, true);
relloc[relConfigItemRefLocation, "X"].Value = (int)currentPosition.X - (int)currentUIPosition.X;
relloc[relConfigItemRefLocation, "Y"].Value = (int)currentPosition.Y - (int)currentUIPosition.Y;
relloc.Commit();
}
else
{
TreeViewItem SelectedItem = (TreeViewItem)ModulesTreeView.SelectedItem;
Guid RoomId = (Guid)SelectedItem.Tag;
EnterpriseManagementRelationshipObject <EnterpriseManagementObject> relloc = _Rel.GetSingleRelationship(emg, relLoctoLoc, RoomId, false);
relloc[relLoctoLoc, "X"].Value = (int)currentPosition.X - (int)currentUIPosition.X;
relloc[relLoctoLoc, "Y"].Value = (int)currentPosition.Y - (int)currentUIPosition.Y;
relloc.Commit();
}
Canvas.SetLeft(MovingUI, (int)currentPosition.X - (int)currentUIPosition.X);
Canvas.SetTop(MovingUI, (int)currentPosition.Y - (int)currentUIPosition.Y);
MovingUI.RenderTransform = null;
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("UIItem_MouseRightButtonUp procedure error : " + ex.Message, "Service Manager", MessageBoxButton.OK, MessageBoxImage.Error);
//this.Close();
}
}