// 08-22-2011 Scott
public SectionFilterCollection GetEffFilters(ScFilterList scFilterList)
{
SectionFilterCollection sectionFilters = new SectionFilterCollection();
sectionFilters.Add(new SectionFilter("Offense Eff", this.GetOffenseEffFilter(scFilterList)));
sectionFilters.Add(new SectionFilter("Offense Run Eff", this.GetRunOffenseEffFilter(scFilterList)));
sectionFilters.Add(new SectionFilter("Offense Pass Eff", this.GetPassOffenseEffFilter(scFilterList)));
sectionFilters.Add(new SectionFilter("Defense Eff", this.GetDefenseEffFilter(scFilterList)));
sectionFilters.Add(new SectionFilter("Defense Run Eff", this.GetRunDefenseEffFilter(scFilterList)));
sectionFilters.Add(new SectionFilter("Defense Pass Eff", this.GetPassDefenseEffFilter(scFilterList)));
return(sectionFilters);
}
public DBFilter GetOffenseEffFilter(ScFilterList scFilterList)
{
DBFilter runFilter = this.GetRunOffenseEffFilter(scFilterList);
DBFilter passFilter = this.GetPassOffenseEffFilter(scFilterList);
DBFilter effoffenseFilter = DBFilter.AttachedTwoFilterWithOr(runFilter, passFilter);
effoffenseFilter.IsCustomFilter = true; //2010-11-1 12:11:46@Simon Add this Code
effoffenseFilter.Name = "OffenseEFF"; //2009-4-29 12:11:46@Simon Add this Code
return(effoffenseFilter);
}
public static SectionFilterCollection GetCustomFilters(ScFilterList scFilterList, SectionFilterCollection scFilters)
{
//2009-5-1 13:33:26@Simon Add this Code
if (scFilters == null)
{
return(scFilters);
}
if (scFilterList == null || scFilterList.ScFilters.Count == 0)
{
return(scFilters);
}
AdvFilterConvertor convert = new AdvFilterConvertor();
SectionFilterCollection newscfFilters = new SectionFilterCollection();
foreach (SectionFilter scFilter in scFilters)
{
if (scFilter == null)
{
return(scFilters);
}
ScAFilter scAfilter = scFilterList.GetFilter(scFilter.FilterName);
SectionFilter secFilter = new SectionFilter();
if (scAfilter != null && scFilter.Filter.Name != string.Empty)
{
if (!scFilter.Filter.IsCustomFilter)
{
secFilter = convert.GetReportFilter(scAfilter);
}
else
{
secFilter.Apply(scFilter);
}
}
else
{
secFilter.Apply(scFilter);
}
newscfFilters.Add(secFilter);
}
return(newscfFilters);
}
public SectionFilterCollection GetAllCustomReportFilters(ScFilterList scFilterList)
{
SectionFilterCollection sectionFilters = new SectionFilterCollection();
foreach (ScAFilter scFilter in scFilterList.ScFilters)
{
if (scFilter.ReportScType > 0 && scFilter.ReportScType < 5)
{
continue;
}
sectionFilters.Add(this.GetReportFilter(scFilter));
}
return(sectionFilters);
}
public SectionFilterCollection GetReportFilters(ScFilterList scFilterList)
{
SectionFilterCollection sectionFilters = new SectionFilterCollection();
foreach (ScAFilter scFilter in scFilterList.ScFilters)
{
sectionFilters.Add(this.GetReportFilter(scFilter));
}
#region Run/Pass Off/Def filters
//DBFilter filter = this.GetRunOffenseEffFilter(scFilterList);
//SectionFilter scFilter = new SectionFilter(filter);
//scFilter.FilterName = filter.Name;
//sectionFilters.Add(scFilter);
//filter = this.GetPassOffenseEffFilter(scFilterList);
//scFilter = new SectionFilter(filter);
//scFilter.FilterName = filter.Name;
//sectionFilters.Add(scFilter);
//filter = this.GetRunDefenseEffFilter(scFilterList);
//scFilter = new SectionFilter(filter);
//scFilter.FilterName = filter.Name;
//sectionFilters.Add(scFilter);
//filter = this.GetPassDefenseEffFilter(scFilterList);
//scFilter = new SectionFilter(filter);
//scFilter.FilterName = filter.Name;
//sectionFilters.Add(scFilter);
#endregion
return(sectionFilters);
}
public DBFilter GetPassOffenseEffFilter(ScFilterList scFilterList)
{
DBFilter EffFilter = new DBFilter();
foreach (ScAFilter scFilter in scFilterList.ScFilters)
{
if (scFilter.ReportScType != 20 || !(scFilter.Name.EndsWith("-PASSEFF-O")))
{
continue;
}
for (int i = 0; i < scFilter.Elements.Count; i++)
{
ScFilterElement element = scFilter.Elements[i];
Webb.Data.DBCondition condition = new Webb.Data.DBCondition();
condition.ColumnName = element.Field;
condition.Value = element.Value;
condition.FilterType = GetFilterOper(element.Oper);
condition.FollowedOperand = this.GetFilterOpr(element.Opr);
if (i == scFilter.Elements.Count - 1)
{
condition.FollowedOperand = FilterOperands.Or;
}
condition.IgnoreCase = true;
EffFilter.Add(condition);
}
EffFilter.PlayAfter = scFilter.PlayAfter == 1;
}
EffFilter.IsCustomFilter = true; //2010-11-1 12:11:46@Simon Add this Code
EffFilter.Name = "PassOffenseEFF"; //2009-4-29 12:11:46@Simon Add this Code
return(EffFilter);
}
public SectionFilterCollection GetReportFilters(ScFilterList scFilterList, ReportScType reportScType)
{
SectionFilterCollection sectionFilters = new SectionFilterCollection();
foreach (ScAFilter scFilter in scFilterList.ScFilters)
{
if (Enum.GetName(typeof(ReportScType), scFilter.ReportScType) == reportScType.ToString())
{
if ((!scFilter.Name.EndsWith("-O") && !scFilter.Name.EndsWith("-D")) && scFilter.ReportScType != 10 && scFilter.ReportScType != 11) //crazy //scFilter.ReportScType!=9
{
continue;
}
sectionFilters.Add(this.GetReportFilter(scFilter));
}
}
return(sectionFilters);
}
public static DBFilter GetAdvFilter(ScFilterList scFilterList, DBFilter Oldfilter)
{
AdvFilterConvertor convert = new AdvFilterConvertor();
if (Oldfilter == null || Oldfilter.Name == string.Empty)
{
return(Oldfilter);
}
if (scFilterList == null || scFilterList.ScFilters.Count == 0)
{
return(Oldfilter);
}
if (Oldfilter.IsCustomFilter)
{
return(convert.UpdateEffFilter(scFilterList, Oldfilter));
}
ScAFilter scAfilter = scFilterList.GetFilter(Oldfilter.Name);
if (scAfilter == null)
{
return(Oldfilter);
}
SectionFilter scFilter = convert.GetReportFilter(scAfilter);
if (scFilter.Filter != null)
{
return(scFilter.Filter.Copy());
}
return(Oldfilter);
}
public DBFilter UpdateEffFilter(ScFilterList scFilterList, DBFilter filter)
{
if (filter == null)
{
return(null);
}
if (filter.Name == "OffenseEFF")
{
DBFilter offensiveFilter = GetOffenseEffFilter(scFilterList);
if (offensiveFilter != null && offensiveFilter.Count > 0)
{
return(offensiveFilter);
}
}
else if (filter.Name == "RunOffenseEFF")
{
DBFilter runOffenseEFFFilter = GetRunOffenseEffFilter(scFilterList);
if (runOffenseEFFFilter != null && runOffenseEFFFilter.Count > 0)
{
return(runOffenseEFFFilter);
}
}
else if (filter.Name == "PassOffenseEFF")
{
DBFilter passOffenseEFFFilter = GetPassOffenseEffFilter(scFilterList);
if (passOffenseEFFFilter != null && passOffenseEFFFilter.Count > 0)
{
return(passOffenseEFFFilter);
}
}
else if (filter.Name == "DefenseEFF")
{
DBFilter defensiveFilter = GetDefenseEffFilter(scFilterList);
if (defensiveFilter != null && defensiveFilter.Count > 0)
{
return(defensiveFilter);
}
}
else if (filter.Name == "RunDefenseEFF")
{
DBFilter rundefensiveFilter = GetRunDefenseEffFilter(scFilterList);
if (rundefensiveFilter != null && rundefensiveFilter.Count > 0)
{
return(rundefensiveFilter);
}
}
else if (filter.Name == "PassDefenseEFF")
{
DBFilter passdefensiveFilter = GetPassDefenseEffFilter(scFilterList);
if (passdefensiveFilter != null && passdefensiveFilter.Count > 0)
{
return(passdefensiveFilter);
}
}
return(filter);
}
