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()); }