void ShowTooTip()
{
Point location = new Point(this.Width + 5, 50);
IntellisenseItem item = lbItellisense.SelectedItem as IntellisenseItem;
if (item == null)
{
return;
}
//string tp = IntelliSense.GetToolTipItem( item.ToolTip );
//toolTip.Show( tp , this, location);
OnToolTipChanged(item.ToolTip);
}
public IntellisenseItem[] GetIntelliSense(string prefixUri)
{
IntellisenseItem[] result;
if (prefixUri.IndexOf('?') == -1)
{
result = ResourcesIntellisense(prefixUri);
}
else
{
result = OperationIntellisense(prefixUri);
}
if ((result == null || result.Length == 0) &&
!prefixUri.EndsWith("/"))
{
if (prefixUri.IndexOf('?') == -1)
{
result = new IntellisenseItem[] { new IntellisenseItem("?", DSType.End), new IntellisenseItem("/", DSType.End) }
}
;
else
{
result = new IntellisenseItem[] { new IntellisenseItem("&", DSType.End) }
};
}
return(result);
}
#region Helper Method
#region Resource Intellisense
IntellisenseItem[] ResourcesIntellisense(string prefix)
{
string[] resources = prefix.Split('/');
int resIndexLast = resources.Length - 1;
#region EntitySet | EntitySet()
if (resources.Length == 1)
{
Debug.WriteLine(prefix);
return(EntitySetsIntellisense(prefix));
}
#endregion
#region Entity(Key)/ Property | NavigationProperties
if (prefix.Trim().EndsWith(")/") || resources[resIndexLast - 1].EndsWith(")"))
{
Entity et = EntityIntellisense(resources[resIndexLast - 1]);
if (et != null)
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
result.AddRange(PropertiesIntellisense(et, resources[resIndexLast]));
result.AddRange(NavPropertiesIntellisense(et, resources[resIndexLast]));
return(result.ToArray());
}
}
#endregion
#region Entity(Key)/Property/$value
if (resources.Length >= 3)
{
if (resIndexLast >= 2 && resources[resIndexLast - 2].EndsWith(")"))
{
Entity et = EntityIntellisense(resources[resIndexLast - 2]);
if (et != null && et.Properties.ContainsKey(resources[resIndexLast - 1]))
{
return(new IntellisenseItem[1] {
new IntellisenseItem("$value", DSType.Operation)
});
}
}
}
#endregion
return(null);
}
IntellisenseItem[] EntitySetsIntellisense(string prefix)
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
if (prefix.StartsWith("$") || string.IsNullOrEmpty(prefix))
{
result.Add(
new IntellisenseItem
{
Text = "$metadata",
Type = DSType.Operation,
ToolTip = "Get the metadata of ADO.NET Data Service."
});
}
foreach (var item in Model.model.EntitySets.Values)
{
if (item.Name.StartsWith(prefix, StringComparison.CurrentCultureIgnoreCase))
{
if (item.Name == prefix && !prefix.EndsWith("/"))
{
result.Add(new IntellisenseItem("(", DSType.End));
result.Add(new IntellisenseItem("/", DSType.End));
result.Add(new IntellisenseItem("?", DSType.End));
}
else
{
result.Add(
new IntellisenseItem
{
Text = item.Name,
Type = DSType.EntitySet,
Element = item,
ToolTip = "This item is EntitySet"
});
}
//result.Add(
// new IntellisenseItem
// {
// Text = item.Name + "(",
// Type = DSType.Entity,
// Element = item,
// ToolTip = BuildEntityFindMethod(item.Entity)
// });
}
}
return(result.ToArray());
}
Entity EntityIntellisense(string token)
{
foreach (var item in Model.model.EntitySets.Values)
{
if (token.StartsWith(item.Name, StringComparison.CurrentCultureIgnoreCase))
{
if (token.EndsWith(")", StringComparison.CurrentCultureIgnoreCase))
{
return(item.Entity);
}
}
}
return(null);
}
IntellisenseItem[] PropertiesIntellisense(Entity et, string prefix)
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
if (et == null)
{
return(result.ToArray());
}
foreach (var p in et.Properties.Keys)
{
if (p.StartsWith(prefix, StringComparison.CurrentCultureIgnoreCase))
{
if (p == prefix)
{
result.Insert(0, new IntellisenseItem("/", DSType.End));
result.Insert(0, new IntellisenseItem("?", DSType.End));
}
else
{
result.Add(
new IntellisenseItem
{
Text = p,
Element = et,
Type = DSType.Property,
ToolTip = BuildPropertyToolTip(et, p)
});
}
}
}
return(result.ToArray());
}
IntellisenseItem[] NavPropertiesIntellisense(Entity et, string prefix)
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
if (et == null)
{
return(result.ToArray());
}
foreach (var n in et.NavigationProperties.Keys)
{
if (n.StartsWith(prefix, StringComparison.CurrentCultureIgnoreCase))
{
if (n == prefix)
{
result.Insert(0, new IntellisenseItem("/", DSType.End));
result.Insert(0, new IntellisenseItem("?", DSType.End));
}
else
{
result.Add(
new IntellisenseItem
{
Text = n,
Element = et,
Type = DSType.NavigationProperty,
ToolTip = "Navigation Property"
});
}
//result.Add(
// new IntellisenseItem
// {
// Text = n + "(",
// Element = et,
// Type = DSType.NavigationProperty,
// ToolTip = BuildEntityFindMethod( et.NavigationProperties[n] )
// });
}
}
return(result.ToArray());
}
#endregion
#region Sentence
IntellisenseItem[] OperationIntellisense(string prefix)
{
#region Init Fields
string resources = prefix.Split('?').First();
string serfix = prefix.Split('?').Last();
bool IsEntitySet = true;
string lastResource = resources.Split('/').Last();
string lastExp = serfix.Split('&').Last();
string lastOperation = lastExp.Split('=').First();
EntitySet es = null;
Entity et = null;
if (lastResource.IndexOf('(') != -1)
{
lastResource = lastResource.Substring(0, lastResource.IndexOf('('));
IsEntitySet = false;
}
if (Model.model.EntitySets.ContainsKey(lastResource))
{
es = Model.model.EntitySets[lastResource];
}
if (es != null)
{
et = es.Entity;
}
#endregion
List <IntellisenseItem> result = new List <IntellisenseItem>();
#region $expand
if ("$expand=".StartsWith(lastOperation, StringComparison.CurrentCultureIgnoreCase))
{
string serfixExpand = lastExp.Split(',').Last();
string navProp = serfixExpand.Split('=').Last().Trim();
if (lastExp.Split('=').First() == "$expand")
{
if (et.NavigationProperties.ContainsKey(navProp))
{
result.Add(new IntellisenseItem(",", DSType.End));
result.Add(new IntellisenseItem("&", DSType.End));
}
else
{
result.AddRange(NavPropertiesIntellisense(et, navProp));
}
}
else
{
result.Add(new IntellisenseItem("$expand=", DSType.Operation, "The $expand= option allows you to embed one or more sets of related entities in the results."));
}
}
#endregion
#region $top
if (IsEntitySet && "$top=".StartsWith(lastExp, StringComparison.CurrentCultureIgnoreCase) && lastExp.Trim() != "$top=")
{
result.Add(new IntellisenseItem("$top=", DSType.Operation, "Restrict the maximum number of entities to be returned."));
}
#endregion
#region $skip
if (IsEntitySet && "$skip=".StartsWith(lastExp, StringComparison.CurrentCultureIgnoreCase) && lastExp.Trim() != "$skip=")
{
result.Add(new IntellisenseItem("$skip=", DSType.Operation, "Skip the number of rows given in this parameter when returning results."));
}
#endregion
#region $orderby
if (IsEntitySet && "$orderby=".StartsWith(lastOperation, StringComparison.CurrentCultureIgnoreCase))
{
if (lastExp.Trim().StartsWith("$orderby="))
{
string prop = lastExp.Split('=').Last();
if (et.Properties.ContainsKey(prop.Trim()) && prop.EndsWith(" "))
{
result.Add(new IntellisenseItem("desc", DSType.Operation, "Sort the results by the criteria given in this value."));
}
result.AddRange(PropertiesIntellisense(et, lastExp.Split('=').Last()));
}
else
{
result.Add(new IntellisenseItem("$orderby=", DSType.Operation, "Sort the results by the criteria given in this value."));
}
}
#endregion
#region $filter
if (IsEntitySet && "$filter=".StartsWith(lastExp, StringComparison.CurrentCultureIgnoreCase) &&
"$filter=" != lastExp)
{
result.Add(new IntellisenseItem("$filter=", DSType.Operation, "Restrict the entities returned from a query by applying the expression specified\n in this operator to the entity set identified by the last segment of the URI path."));
}
if (IsEntitySet && lastExp.StartsWith("$filter=", StringComparison.CurrentCultureIgnoreCase))
{
IntellisenseItem[] f = FilterIntellisense(lastResource, lastExp.Split('=').Last(), et);
if (f != null)
{
result.AddRange(f);
}
}
#endregion
return(result.ToArray());
}
IntellisenseItem[] FilterIntellisense(string lastResource, string exp, Entity et)
{
string rightExp = null;
string op = null;
string leftExp = null;
#region Init Fields
exp = exp.TrimStart();
if (exp.IndexOf(" ") == -1)
{
leftExp = exp;
op = string.Empty;
rightExp = null;
}
else
{
leftExp = exp.Substring(0, exp.IndexOf(" "));
if (exp.IndexOf(" ", leftExp.Length + 1) != -1)
{
int lengthOp = exp.IndexOf(" ", leftExp.Length + 1) - leftExp.Length + 1;
op = exp.Substring(leftExp.Length, lengthOp);
if (op.Length >= 2)
{
if (leftExp.Length + op.Length < exp.Length)
{
rightExp = exp.Substring(leftExp.Length + op.Length, exp.Length - leftExp.Length - op.Length);
}
}
}
}
#endregion
string[] tokens = exp.Split(' ');
// Left side of expression
if (string.IsNullOrEmpty(op) && !exp.EndsWith(" "))
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
if (leftExp.IndexOf('/') != -1)
{
string[] t = leftExp.Split('/');
string res = t[t.Length - 2].Split('=').Last();
Entity etsub = et.NavigationProperties[res];
result.AddRange(PropertiesIntellisense(etsub, t.Last()));
result.AddRange(NavPropertiesIntellisense(etsub, t.Last()));
}
else
{
result.AddRange(PropertiesIntellisense(et, exp.Trim()));
result.AddRange(NavPropertiesIntellisense(et, exp.Trim()));
result.AddRange(Expression.BoolFunc);
}
return(result.ToArray());
}
// The operation
if (string.IsNullOrEmpty(op) && exp.EndsWith(" "))
{
return(Expression.LogicalOperators);
}
// Right side of expression
if (!string.IsNullOrEmpty(op) && exp.EndsWith(" "))
{
string type = null;
// Field
if (et.Properties.ContainsKey(leftExp))
{
List <IntellisenseItem> result = new List <IntellisenseItem>();
type = et.Properties[leftExp].NameType.Split('.').Last();
result.AddRange(Expression.Funcs(type).ToArray());
result.AddRange(from x in et.Properties.Values
where x.NameType.Split('.').Last() == type
select new IntellisenseItem(x.Name, DSType.Property));
return(result.ToArray());
}
}
return(null);
}
#endregion
#region ToolTip Methods
string BuildEntityFindMethod(Entity et)
{
if (et == null)
{
return(string.Empty);
}
string result = et.Name;
string[] keys = et.Keys.Keys.ToArray();
result += "( ";
for (int i = 0; i < keys.Length; i++)
{
result += et.Properties[keys[i]].NameType.Split('.').Last() + " " + keys[i] + ", ";
}
result = result.Substring(0, result.LastIndexOf(','));
result += " )";
return(result);
}
string BuildPropertyToolTip(Entity et, string property)
{
return
(string.Format("This item is property of {0} Entity.\n{1} type of {2}. ",
et.Name, property, et.Properties[property].NameType.Split('.').Last()));
}
#endregion
#endregion
}