Beispiel #1
0
 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;
 }
Beispiel #2
0
 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;
 }
Beispiel #4
0
 /// <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();
 }
Beispiel #7
0
        /// <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();
            }
        }
Beispiel #8
0
 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;
 }
Beispiel #11
0
 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);
 }
Beispiel #12
0
 /// <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();
        }
Beispiel #14
0
        /// <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();
            }
        }
Beispiel #15
0
        /// <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;
 }
Beispiel #17
0
 /// <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;
 }
Beispiel #21
0
 // CONSTRUCTORS
 public PayAccruals()
 {
     Source   = Source.PayAccruals;
     Provider = Provider.SQLite;
     DbData   = new DataBuilder(Source, Provider);
     Table    = DbData.Table;
     Columns  = DbData.Columns;
 }
Beispiel #22
0
 /// <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();
 }
Beispiel #23
0
 /// <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;
 }
Beispiel #27
0
 /// <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();
 }
Beispiel #28
0
 /// <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();
 }
Beispiel #30
0
 /// <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();
 }