public PRC(Dictionary <string, object> data) : this()
{
Parameter = data;
DbData = new DataBuilder(Source.PRC, Parameter);
Table = DbData.Table;
Columns = DbData.Columns;
Data = DbData.Data;
ID = int.Parse(Data["ID"].ToString());
BudgetLevel = Data["BudgetLevel"].ToString();
RPIO = Data["RPIO"].ToString();
AH = Data["AH"].ToString();
BFY = Data["BFY"].ToString();
Fund = new Fund(Data["FundCode"].ToString(), Data["BFY"].ToString());
Org = new Org(Data["Org"].ToString());
RC = new RC(Data["RC"].ToString());
Account = new Account(Provider.SQLite, BFY, Fund.Code, Data["Code"].ToString());
Code = Account.Code;
BOC = new BOC(Data["BOC"].ToString());
Amount = decimal.Parse(Data["Amount"].ToString());
ProgramProjectCode = Account.ProgramProjectCode;
ProgramProjectName = Account.ProgramProjectName;
ProgramArea = Account.ProgramArea;
NPM = Account.NPM;
NpmCode = Account.NpmCode;
Goal = Account.Goal;
GoalName = Account.GoalName;
Objective = Account.Objective;
ObjectiveName = Account.ObjectiveName;
}
public TravelObligations(Provider provider, Dictionary <string, object> param)
{
Source = Source.TravelObligations;
Provider = provider;
DbData = new DataBuilder(Source, Provider, param);
Table = DbData.Table;
Columns = DbData.Columns;
Data = DbData.Data;
ID = int.Parse(Data["ID"].ToString());
RPIO = Data["RPIO"].ToString();
BFY = Data["BFY"].ToString();
AH = Data["AH"].ToString();
AllowanceHolderName = Data["AllowanceHolderName"].ToString();
RC = Data["RC"].ToString();
DivisionName = Data["DivisionName"].ToString();
Org = Data["Org"].ToString();
OrgName = Data["OrgName"].ToString();
Code = Data["Code"].ToString();
FOC = Data["FOC"].ToString();
FocName = Data["FocName"].ToString();
ProgramProjectCode = Data["ProgramProjectCode"].ToString();
ProgramProjectName = Data["ProgramProjectName"].ToString();
TravelBeginDate = Data["TravelBeginDate"].ToString();
TravelEndDate = Data["TravelEndDate"].ToString();
TravelType = Data["TravelType"].ToString();
TravelerName = Data["TravelerName"].ToString();
DCN = Data["DCN"].ToString();
OpenCommitments = decimal.Parse(Data["OpenCommitments"].ToString());
Obligations = decimal.Parse(Data["Obligations"].ToString());
ULO = decimal.Parse(Data["ULO "].ToString());
}
public WorkCode(Provider provider = Provider.SQLite) : this()
{
Provider = provider;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
/// <summary>
/// Initializes a new instance of the <see cref = "Purchase"/> class.
/// </summary>
/// <param name = "query" >
/// </param>
public Purchase(IQuery query)
: base(query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.PurchaseId);
NpmCode = new Element(Record, Field.NpmCode);
DocumentType = new Element(Record, Field.DocumentType);
PurchaseRequest = new Element(Record, Field.PurchaseRequest);
DocumentPrefix = new Element(Record, Field.DocumentPrefix);
DCN = new Element(Record, Field.DCN);
ObligatingDocumentNumber = new Element(Record, Field.ObligatingDocumentNumber);
AgreementNumber = new Element(Record, Field.ReimbursableAgreementNumber);
GrantNumber = new Element(Record, Field.GrantNumber);
ProgramProjectCode = new Element(Record, Field.ProgramProjectCode);
SiteProjectCode = new Element(Record, Field.SiteProjectCode);
System = new Element(Record, Field.System);
FocCode = new Element(Record, Field.FocCode);
FocName = new Element(Record, Field.FocName);
TransactionNumber = new Element(Record, Field.TransactionNumber);
OriginalActionDate = new Time(Record, EventDate.OriginalActionDate);
Commitments = new Amount(Record, Numeric.Commitments);
OpenCommitments = new Amount(Record, Numeric.OpenCommitments);
Obligations = new Amount(Record, Numeric.Obligations);
ULO = new Amount(Record, Numeric.ULO);
Deobligations = new Amount(Record, Numeric.Deobligations);
Expenditures = new Amount(Record, Numeric.Expenditures);
Data = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "PayrollObligation"/> class.
/// </summary>
/// <param name = "query" >
/// </param>
public PayrollObligation(IQuery query)
: base(query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.PayrollObligationId);
RpioCode = new Element(Record, Field.RpioCode);
FundCode = new Element(Record, Field.FundCode);
AhCode = new Element(Record, Field.AhCode);
OrgCode = new Element(Record, Field.OrgCode);
RcCode = new Element(Record, Field.RcCode);
AccountCode = new Element(Record, Field.AccountCode);
ProgramProjectCode = new Element(Record, Field.ProgramProjectCode);
HrOrgCode = new Element(Record, Field.HrOrgCode);
WorkCode = new Element(Record, Field.WorkCode);
FocCode = new Element(Record, Field.FocCode);
PayPeriod = new Element(Record, Field.PayPeriod);
Amount = new Amount(Record, Numeric.Amount);
Hours = new Amount(Record, Numeric.Hours);
AllocationPercentage = new Amount(Record, Numeric.AllocationPercentage);
AnnualBaseHours = new Amount(Record, Numeric.AnnualBaseHours);
AnnualBasePaid = new Amount(Record, Numeric.AnnualBasePaid);
CumulativeBenefits = new Amount(Record, Numeric.CumulativeBenefits);
AnnualOtherHours = new Amount(Record, Numeric.AnnualOtherHours);
AnnualOtherPaid = new Amount(Record, Numeric.AnnualOtherPaid);
AnnualOvertimeHours = new Amount(Record, Numeric.AnnualOvertimePaid);
AnnualOvertimePaid = new Amount(Record, Numeric.AnnualOvertimePaid);
Data = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "HumanResourceData"/> class.
/// </summary>
/// <param name = "query" >
/// The query.
/// </param>
public HumanResourceData(IQuery query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.WorkforceDataId);
EmployeeNumber = new Element(Record, Field.EmployeeNumber);
FirstName = new Element(Record, Field.FirstName);
LastName = new Element(Record, Field.LastName);
Status = new Element(Record, Field.Status);
JobTitle = new Element(Record, Field.JobTitle);
OccupationalSeries = new Element(Record, Field.OccupationalSeries);
HumanResourceOrganizationCode = new Element(Record, Field.HumanResourceOrganizationCode);
HumanResourceOrganizationName = new Element(Record, Field.HumanResourceOrganizationName);
Grade = new Element(Record, Field.Grade);
Step = new Element(Record, Field.Step);
AppointmentAuthority = new Element(Record, Field.AppointmentAuthority);
AppointmentType = new Element(Record, Field.AppointmentType);
BargainingUnit = new Element(Record, Field.BargainingUnit);
RetirementPlan = new Element(Record, Field.RetirementPlan);
HireDate = new Time(Record, EventDate.HireDate);
ServiceDate = new Time(Record, EventDate.ServiceDate);
WigiDueDate = new Time(Record, EventDate.WigiDueDate);
GradeEntryDate = new Time(Record, EventDate.GradeEntryDate);
StepEntryDate = new Time(Record, EventDate.StepEntryDate);
CompensationRate = new Amount(Record, Numeric.CompensationRate);
Args = Record.ToDictionary();
}
/// <summary>
/// Populates the filter items.
/// </summary>
/// <param name="colname">The colname.</param>
/// <param name="data">The data.</param>
/// <param name="control">The control.</param>
/// <param name="label">The label.</param>
internal void PopulateFilterItems(Field colname, DataBuilder data, VisualComboBox control, Label label)
{
try
{
control.Tag = colname.ToString();
if (control.Items.Count > 0)
{
control.Items.Clear();
}
if (label.Visible == false)
{
label.Visible = true;
label.Text = control.Tag.ToString();
}
string[] items = ProgramElements[colname.ToString()];
foreach (string i in items)
{
control.Items.Add(i);
}
}
catch (Exception ex)
{
new Error(ex).ShowDialog();
}
}
public Transfer(Provider provider, Dictionary <string, object> p) : this()
{
Provider = provider;
Input = p;
DbData = new DataBuilder(Source, Provider, Input);
Table = DbData.Table;
Columns = DbData.Columns;
Data = DbData.Data;
TransId = int.Parse(Data["ID"].ToString());
BudgetLevel = Data["BudgetLevel"].ToString();
DocType = Data["DocType"].ToString();
RPIO = Data["RPIO"].ToString();
Org = new Org(Data["Org"].ToString());
RC = new RC(Data["RC"].ToString());
BFY = Data["BFY"].ToString();
Fund = new Fund(Data["FundCode"].ToString(), BFY);
TCN = Data["TCN"].ToString();
Qtr = Data["Qtr"].ToString();
Date = Data["Date"].ToString();
Code = Data["Code"].ToString();
Account = new Account(Provider.SQLite, BFY, Fund.Code, Code);
FundCode = Account.FundCode;
NpmCode = Account.NPM;
FromTo = Data["FromTo"].ToString();
BOC = new BOC(Data["BOC"].ToString());
Amount = decimal.Parse(Data["Amount"].ToString());
}
public Utilization(Provider provider, IDictionary <string, object> param)
{
Source = Source.Utilization;
Provider = provider;
Input = param;
DbData = new DataBuilder(Source, Provider, Input);
Table = DbData.Table;
Columns = DbData.Columns;
Data = DbData.Data;
ID = int.Parse(Data["ID"].ToString());
RPIO = Data["RPIO "].ToString();
BFY = Data["BFY"].ToString();
Fund = new Fund(Data["FundCode"].ToString(), BFY);
AH = Data["AH"].ToString();
Org = new Org(Data["Org"].ToString());
RC = new RC(Data["RC"].ToString());
ProgramProjectCode = Data["ProgramProjectCode"].ToString();
BOC = new BOC(Data["BOC"].ToString());
FOC = Data["FOC"].ToString();
FocName = Data["FocName"].ToString();
Authority = decimal.Parse(Data["Authority"].ToString());
Budgeted = decimal.Parse(Data["Budgeted"].ToString());
Posted = decimal.Parse(Data["Posted"].ToString());
CarryIn = decimal.Parse(Data["CarryIn"].ToString());
CarryOut = decimal.Parse(Data["CarryOut"].ToString());
Commitments = decimal.Parse(Data["Commitments"].ToString());
OpenCommitments = decimal.Parse(Data["OpenCommitments"].ToString());
Obligations = decimal.Parse(Data["Obligations"].ToString());
ULO = decimal.Parse(Data["ULO"].ToString());
}
/// <summary>
/// Initializes a new instance of the <see cref="Programs"/> class.
/// </summary>
public Programs()
{
Source = Source.Programs;
Provider = Provider.SQLite;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
}
public Account(Provider provider, string bfy, string fund, string code) : this()
{
Code = code;
Provider = provider;
ProgramProjectCode = Code.Substring(4, 2);
Parameter = GetAccountParameter(bfy, fund, code);
DbData = new DataBuilder(Source.Accounts, provider, Parameter);
Table = DbData.Table;
Columns = DbData.Columns;
Data = DbData.Data;
ID = int.Parse(Data["ID"].ToString());
Code = Data["Code"].ToString();
Goal = Code.Substring(0, 1);
Objective = Code.Substring(1, 2);
NpmCode = Code.Substring(3, 1);
Org = Data["Org"].ToString();
BFY = Data["BFY"].ToString();
FundCode = Data["FundCode"].ToString();
ProgramProjectName = Data["ProgramProjectName"].ToString();
NPM = Table.Rows[0]["NPM"].ToString();
ObjectiveName = Table.Rows[0]["ObjectiveName"].ToString();
GoalName = Table.Rows[0]["GoalName"].ToString();
ProgramArea = Table.Rows[0]["ProgramArea"].ToString();
ProgramAreaName = Table.Rows[0]["ProgramAreaName"].ToString();
Parameter = GetAccountParameter(BFY, FundCode, Code);
}
/// <summary>
/// Initializes a new instance of the
/// <see>
/// <cref>
/// RegionalAuthority
/// </cref>
/// </see>
/// class.
/// </summary>
/// <param name = "query" >
/// The query.
/// </param>
public RegionalAuthority(IQuery query)
: base(query)
{
Record = new DataBuilder(query)?.GetRecord();
BudgetFiscalYear = new BudgetFiscalYear(Record.GetField(Field.BFY));
Data = Record?.ToDictionary();
}
public DivisionAuthority(Source source)
{
Source = source;
DbData = new DataBuilder(Source);
Filter = (table, col, filter) => DataBuilder.Filter(table, col, filter);
R6 = DbData.GetDataSet(Source);
Table = DbData.Table;
Data = DbData.Data;
ProgramElements = DbData.ProgramElements;
BFY = GetFiscalYears(ProgramElements["BFY"]);
RC = ProgramElements["RC"].AsEnumerable().Select(s => s).First();
Metric = new PrcMetric(DbData);
if (ProgramElements["BOC"].Contains("17"))
{
FTE = GetFTE(Table);
}
Fund = GetFunds();
Authority = Filter(Table, Field.BFY, BFY[1].Date.Year.ToString());
CarryOver = Filter(Table, Field.BFY, BFY[0].Date.Year.ToString());
Awards = GetAwards();
Overtime = GetOverTime();
BCN = new ControlNumber(new Dictionary <string, object> {
["DivisionName"] = Source.ToString()
});
ControlNumber = BCN.ToString();
}
/// <summary>
/// Populates the filter items.
/// </summary>
/// <param name="colname">The colname.</param>
/// <param name="data">The data.</param>
/// <param name="control">The control.</param>
/// <param name="label">The label.</param>
internal void PopulateFilterItems(string colname, DataBuilder data, VisualComboBox control, Label label)
{
try
{
if (control.Items.Count > 0)
{
control.Items.Clear();
}
if (label.Visible == false)
{
label.Visible = true;
}
string[] filters = data.ProgramElements[colname];
control.Tag = colname;
foreach (string i in filters)
{
control.Items.Add(i);
}
}
catch (Exception ex)
{
new Error(ex).ShowDialog();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="BudgetChart"/> class.
/// </summary>
/// <param name="chart">The chart<see cref="ChartControl"/></param>
/// <param name="data">The data<see cref="DataBuilder"/></param>
/// <param name="filter">The filter<see cref="Field"/></param>
/// <param name="value">The value<see cref="Stat"/></param>
/// <param name="type">The type<see cref="ChartSeriesType"/></param>
public BudgetChart(ChartControl chart, DataBuilder data, Field filter, Stat value, ChartSeriesType type)
{
Chart = chart;
DbData = data;
Source = data.Source;
Value = value;
SeriesType = type;
ConfigurePrimaryAxisLabels(Chart);
if (Chart.Series != null)
{
Chart.Series.Clear();
}
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();
Metric = new PrcMetric(DbData);
DataMetrics = Metric.GetChartMetrics(Table, filter);
CurrentYearMetrics = Metric.GetChartMetrics(CurrentYear, filter);
CarryOverMetrics = Metric.GetChartMetrics(CarryOver, filter);
DataSeries = GetSeriesTotals(GetMeasure(DataMetrics, Value), type);
DataSeries.Type = type;
CurrentYearSeries = GetSeriesTotals(GetMeasure(CurrentYearMetrics, Value), type);
CurrentYearSeries.Type = type;
CurrentYearSeries.Text = "Current Year";
CarryOverSeries = GetSeriesTotals(GetMeasure(CarryOverMetrics, Value), type);
CarryOverSeries.Type = type;
CarryOverSeries.Text = "Carry Over";
ConfigureSeries(CurrentYearSeries, Value);
ConfigureSeries(CarryOverSeries, Value);
Configure3DMode(Chart);
ConfigurePrimaryAxisLabels(Chart);
Chart.ShowLegend = true;
ConfigureLegend(Chart);
}
public ProgramObligations()
{
Source = Source.ProgramObligations;
Provider = Provider.SQLite;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
/// <summary>
/// Initializes a new instance of the <see cref="ExcelDocument"/> class.
/// </summary>
/// <param name="source">The source<see cref="Source"/></param>
public ExcelDocument(Source source)
{
Source = source;
Provider = Provider.SQLite;
Excel = Excel.Budget;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
}
public Utilization(Source source = Source.Utilization, Provider provider = Provider.SQLite)
{
Source = source;
Provider = provider;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
/// <summary>
/// Initializes a new instance of the <see cref = "Organization"/> class.
/// </summary>
/// <param name = "query" >
/// The query.
/// </param>
public Organization(IQuery query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.OrganizationId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Data = Record?.ToDictionary();
}
public Obligation(Source source, Provider provider, Dictionary <string, object> param)
{
Source = source;
Provider = provider;
DbData = new DataBuilder(source, provider, param);
Table = DbData.Table;
Data = DbData.Data;
}
// CONSTRUCTORS
public PayAccruals()
{
Source = Source.PayAccruals;
Provider = Provider.SQLite;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
/// <summary>
/// Initializes a new instance of the <see cref = "FinanceObjectClass"/> class.
/// </summary>
/// <param name = "foccode" >
/// The foccode.
/// </param>
public FinanceObjectClass(string foccode)
{
Record = new DataBuilder(Source, GetArgs(foccode))?.GetRecord();
ID = new Key(Record, PrimaryKey.FinanceObjectClassId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Args = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "TimeOff"/> class.
/// </summary>
/// <param name = "query" >
/// The query.
/// </param>
public TimeOff(IQuery query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.TimeOffId);
FundCode = new Element(Record, Field.FundCode);
Amount = new Amount(Record, Numeric.Amount);
Data = Record?.ToDictionary();
}
public Division()
{
Source = Source.Divisions;
Provider = Provider.SQLite;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
public Obligation(Source source, Provider provider = Provider.SQLite)
{
Source = source;
Provider = provider;
DbData = new DataBuilder(source, provider);
Table = DbData.Table;
Data = DbData.Data;
}
public Division(Source source, Provider provider = Provider.SQLite) : this()
{
Source = source;
Provider = provider;
DbData = new DataBuilder(Source, Provider);
Table = DbData.Table;
Columns = DbData.Columns;
}
/// <summary>
/// Initializes a new instance of the <see cref = "Objective"/> class.
/// </summary>
/// <param name = "code" >
/// The code.
/// </param>
public Objective(string code)
{
Record = new DataBuilder(Source, SetArgs(code))?.GetRecord();
ID = new Key(Record, PrimaryKey.ObjectiveId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Data = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "AllowanceHolder"/> class.
/// </summary>
/// <param name = "ahcode" >
/// The ahcode.
/// </param>
public AllowanceHolder(string ahcode)
{
Record = new DataBuilder(Source, SetArgs(ahcode))?.GetRecord();
ID = new Key(Record, PrimaryKey.AllowanceHolderId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Data = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "Organization"/> class.
/// </summary>
/// <param name = "org" >
/// The org.
/// </param>
public Organization(string org)
{
Record = new DataBuilder(Source, GetArgs(org))?.GetRecord();
ID = new Key(Record, PrimaryKey.OrganizationId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Data = Record?.ToDictionary();
}
/// <summary>
/// Initializes a new instance of the <see cref = "AllowanceHolder"/> class.
/// </summary>
/// <param name = "query" >
/// The query.
/// </param>
public AllowanceHolder(IQuery query)
{
Record = new DataBuilder(query)?.GetRecord();
ID = new Key(Record, PrimaryKey.AllowanceHolderId);
Name = new Element(Record, Field.Name);
Code = new Element(Record, Field.Code);
Data = Record?.ToDictionary();
}
