private void TestButton_Click(object sender, EventArgs e)
{
var p = new Dictionary <string, object> {
["Name"] = Source.ToString()
};
var divsion = new Division(p);
var authority = new DivisionAuthority(Source);
new Message("Test Complete").Show();
}
public PrcMetric(DataBuilder data)
{
DbData = data;
Table = DbData.Table;
CarryOver = DbData.Table.AsEnumerable().Where(p => p.Field <string>("BFY").Equals("2018")).Select(p => p).CopyToDataTable();
CurrentYear = DbData.Table.AsEnumerable().Where(p => p.Field <string>("BFY").Equals("2019")).Select(p => p).CopyToDataTable();
ProgramElements = DbData.ProgramElements;
Total = GetTotals(Table);
CarryOverTotal = GetTotals(CarryOver);
CurrentYearTotal = GetTotals(CurrentYear);
Count = Table.Rows.Count;
CarryOverCount = CarryOver.Rows.Count;
CurrentYearCount = CurrentYear.Rows.Count;
Metrics = GetMetrics(Table);
CarryOverMetrics = GetMetrics(CarryOver);
CurrentYearMetrics = GetMetrics(CurrentYear);
FundTotals = GetDataTotals(Table, Field.FundName);
FundMetrics = GetMetrics(Table, Field.FundName);
BocTotals = GetDataTotals(Table, Field.BocName);
BocMetrics = GetMetrics(Table, Field.BocName);
NpmTotals = GetDataTotals(Table, Field.NPM);
NpmMetrics = GetMetrics(Table, Field.NPM);
ProgramProjectTotals = GetDataTotals(Table, Field.ProgramProjectCode);
ProgramProjectMetrics = GetMetrics(Table, Field.ProgramProjectCode);
ProgramAreaTotals = GetDataTotals(Table, Field.ProgramArea);
ProgramAreaMetrics = GetMetrics(Table, Field.ProgramArea);
GoalTotals = GetDataTotals(Table, Field.GoalName);
GoalMetrics = GetMetrics(Table, Field.GoalName);
ObjectiveTotals = GetDataTotals(Table, Field.ObjectiveName);
ObjectiveMetrics = GetMetrics(Table, Field.ObjectiveName);
if (DbData.Source == Source.DivisionAccounts &&
DbData.Input == null)
{
DivisionTotals = GetDataTotals(Table, Field.RC);
DivisionMetrics = GetMetrics(Table, Field.RC);
}
if (DbData.Source == Source.PRC)
{
DataTable table = new DivisionAuthority().Table;
DivisionTotals = GetDataTotals(table, Field.RC);
DivisionMetrics = GetMetrics(table, Field.RC);
}
}
public PrcMetric(DataTable data, Field column, string filter)
{
Table = data;
CarryOver = Info.FilterRows(Table, column, filter).AsEnumerable()
.Where(p => p.Field <string>("BFY").Equals("2018"))
.Select(p => p).CopyToDataTable();
CurrentYear = Info.FilterRows(Table, column, filter).AsEnumerable()
.Where(p => p.Field <string>("BFY").Equals("2019"))
.Select(p => p).CopyToDataTable();
ProgramElements = GetProgramElements(Table);
Total = GetTotals(Table);
CarryOverTotal = GetTotals(CarryOver);
CurrentYearTotal = GetTotals(CurrentYear);
Count = Table.Rows.Count;
CarryOverCount = CarryOver.Rows.Count;
CurrentYearCount = CurrentYear.Rows.Count;
Average = GetAverage(Table);
Metrics = GetMetrics(Table);
FundTotals = GetDataTotals(Table, Field.FundName);
FundMetrics = GetMetrics(Table, Field.FundName);
BocTotals = GetDataTotals(Table, Field.BocName);
BocMetrics = GetMetrics(Table, Field.BocName);
NpmTotals = GetDataTotals(Table, Field.NPM);
NpmMetrics = GetMetrics(Table, Field.NPM);
ProgramProjectTotals = GetDataTotals(Table, Field.ProgramProjectCode);
ProgramProjectMetrics = GetMetrics(Table, Field.ProgramProjectCode);
ProgramAreaTotals = GetDataTotals(Table, Field.ProgramArea);
ProgramAreaMetrics = GetMetrics(Table, Field.ProgramArea);
GoalTotals = GetDataTotals(Table, Field.GoalName);
GoalMetrics = GetMetrics(Table, Field.GoalName);
ObjectiveTotals = GetDataTotals(Table, Field.ObjectiveName);
ObjectiveMetrics = GetMetrics(Table, Field.ObjectiveName);
if (DbData.Source == Source.DivisionAccounts)
{
DivisionTotals = GetDataTotals(DbData.Table, Field.RC);
DivisionMetrics = GetMetrics(DbData.Table, Field.RC);
}
else
{
DataTable table = new DivisionAuthority().Table;
DivisionTotals = GetDataTotals(table, Field.RC);
DivisionMetrics = GetMetrics(table, Field.RC);
}
}
