public SQLSCCProvider(List <SQLServer_Object> Childs, List <Variables> Vars, SQLServer SqlServerData, ImageList imageList, string FilterCad, FilteringTypeValues Info, int StartOffset)
{
this.SqlServerData = SqlServerData;
this.imageList = imageList;
this.FilterCad = FilterCad;
this.Info = Info;
this.StartOffset = StartOffset;
this.Vars = Vars;
this.Childs = Childs;
}
public List <SQLServer_Object> FilterByType(FilteringTypeValues Type)
{
List <SQLServer_Object> Back = new List <SQLServer_Object>();
switch (Type)
{
case FilteringTypeValues.Tables:
if (Tables != null && Tables.Count > 0)
{
Back.AddRange(Tables.ToArray());
}
break;
case FilteringTypeValues.Views:
if (Views != null && Views.Count > 0)
{
Back.AddRange(Views.ToArray());
}
break;
case FilteringTypeValues.Sps:
if (Sps != null && Sps.Count > 0)
{
Back.AddRange(Sps.ToArray());
}
break;
case FilteringTypeValues.Code:
if (Views != null && Views.Count > 0)
{
Back.AddRange(Views.ToArray());
}
if (Sps != null && Sps.Count > 0)
{
Back.AddRange(Sps.ToArray());
}
break;
case FilteringTypeValues.Fields:
if (Tables != null && Tables.Count > 0)
{
Back.AddRange(Tables.ToArray());
}
if (Views != null && Views.Count > 0)
{
Back.AddRange(Views.ToArray());
}
break;
case FilteringTypeValues.Variables:
case FilteringTypeValues.Snippets:
;
break;
case FilteringTypeValues.All:
default:
if (Tables != null && Tables.Count > 0)
{
Back.AddRange(Tables.ToArray());
}
if (Views != null && Views.Count > 0)
{
Back.AddRange(Views.ToArray());
}
if (Sps != null && Sps.Count > 0)
{
Back.AddRange(Sps.ToArray());
}
break;
}
return(Back);
}
