public ICompletionData[] GenerateCompletionData(string fileName, TextArea textArea, char charTyped)
{
if (SqlServerData == null)
{
SqlServerData = new SQLServer(ConnectioString);
SqlServerData.Initialize();
}
List <SQLServer_Object> Back;
Back = SqlServerData.FilterByType(Info);
if (Vars != null && Vars.Count > 0 && Info == FilteringTypeValues.Variables)
{
List <Variables> VarsBack = Vars.FindAll(N => N.Text.ToLower().StartsWith(FilterCad.ToLower()));
if (VarsBack == null || VarsBack.Count == 0)
{
_IsEmpty = true;
}
else
{
_IsEmpty = false;
}
VarsBack.Sort(ICompletionDataCompare);
return(VarsBack.ToArray());
}
if (Childs != null && Childs.Count > 0 && Info == FilteringTypeValues.Childs)
{
List <SQLServer_Object> ChildsBack = Childs.FindAll(N => N.Text.ToLower().StartsWith(FilterCad.ToLower()));
if (ChildsBack == null || ChildsBack.Count == 0)
{
_IsEmpty = true;
}
else
{
_IsEmpty = false;
}
ChildsBack.Sort(ICompletionDataCompare);
return(ChildsBack.ToArray());
}
//switch (Info)
//{
// case FilteringTypeValues.Tables:
// Back = SqlServerData.FilterByType(FilteringTypeValues.Tables);
// break;
// case FilteringTypeValues.Views:
// Back = SqlServerData.FilterByType(FilteringTypeValues.Views);
// break;
// case FilteringTypeValues.Sps:
// Back = SqlServerData.FilterByType(FilteringTypeValues.Sps);
// break;
// case FilteringTypeValues.Code:
// Back = SqlServerData.FilterByType(FilteringTypeValues.ViewsAndSPs);
// break;
// case FilteringTypeValues.Fields:
// Back = SqlServerData.FilterByType(FilteringTypeValues.Fields);
// break;
// case FilteringTypeValues.All:
// Back = SqlServerData.FilterByType(FilteringTypeValues.All);
// break;
// default:
// Back = new List<CompletionData>();
// break;
//}
Back = Back.FindAll(N => N.Text.ToLower().StartsWith(FilterCad.ToLower()));
if (Back == null || Back.Count == 0)
{
_IsEmpty = true;
}
else
{
_IsEmpty = false;
}
Back.Sort(ICompletionDataCompare);
return(Back.ToArray());
}
