public FbmsBudgetStageImportPayrecV3UnexpendedBalance(KeyValuePair <int, DataRow> keyValuePair) { var rowIndex = keyValuePair.Key; var dr = keyValuePair.Value; var columnNameToLetterDict = FbmsBudgetStageImportPayrecV3UnexpendedBalances.GetBudgetColumnNameToColumnLetterDictionary(); // Column - Business Area Key BusinessArea = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.BusinessAreaKey); // Column - FA Budget Activity Key FABudgetActivity = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.FaBudgetActivityKey); // Column - Functional Area Text FunctionalArea = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.FunctionalAreaText); // Column - Obligation Number Key ObligationNumber = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.ObligationNumberKey); // Column - Obligation Item Key ObligationItem = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.ObligationItemKey); // Column - Fund Key Fund = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.FundKey); // Column - WBS Element Key WbsElement = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.WbsElementKey); // Column - Funded Program (Really an alternate name for the Name of the WBS element. It's named this because of reporting engine limitations on Dorothy's side.) WbsElementDescription = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.FundedProgramKey); // Column - Budget Object Class Key BudgetObjectClass = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.BudgetObjectClassKey); // Column - Vendor Key Vendor = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.VendorKey); // Column - Vendor Key VendorName = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.VendorNameText); // Column - Posting Date (Per SPL) - Key PostingDatePerSpl = ExcelColumnHelper.GetDateTimeDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.PostingDatePerSplKey, ExcelColumnHelper.ExcelDateTimeCellType.SerialDateTimeValue); // Column - Unexpended Balance UnexpendedBalance = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsBudgetStageImportPayrecV3UnexpendedBalances.UnexpendedBalanceValue); }
public PnBudgetsStageImport(KeyValuePair <int, DataRow> keyValuePair) { var rowIndex = keyValuePair.Key; var dr = keyValuePair.Value; var columnNameToLetterDict = PnBudgetsStageImports.PnBudgets_GetBudgetColumnNameToColumnLetterDictionary(); FundedProgram = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.FundedProgram); FundType = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.FundType); Fund = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.Fund); FundsCenter = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.FundsCenter); FiscalYearPeriod = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.FiscalYearPeriod); CommitmentItem = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.CommitmentItem); FiDocNumber = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.FiDocNumber); Recoveries = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.Recoveries); CommittedButNotObligated = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.CommittedButNotObligated); TotalObligations = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.TotalObligations); TotalExpenditures = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.TotalExpenditures); UndeliveredOrders = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, PnBudgetsStageImports.UndeliveredOrders); }
public FbmsInvoiceStageImport(KeyValuePair <int, DataRow> keyValuePair) { var rowIndex = keyValuePair.Key; var dr = keyValuePair.Value; var columnNameToLetterDict = FbmsInvoiceStageImports.FbmsInvoice_GetInvoiceColumnNameToColumnLetterDictionary(); // Column - PO Number - Key PONumberKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.PurchaseOrderNumberKey); // Column - Purch Ord Line Itm - Key PurchOrdLineItmKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.PurchaseOrderLineItemKey); // Column - Reference - Key ReferenceKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.ReferenceKey); // Column - Vendor - Key VendorKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.VendorKey); // Column - Vendor - Text VendorText = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.VendorText); // Column - Fund - Key FundKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.FundKey); // Column - Funded Program - Key FundedProgramKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.FundedProgramKey); // Column - Wbs Element - Key WbsElementKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.WbsElementKey); // Column - Wbs Element - Text WbsElementText = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.WbsElementText); // Column - Budget Object Class - Key BudgetObjectClassKey = ExcelColumnHelper.GetStringDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.BudgetObjectClassKey); // Column - DebitAmount DebitAmount = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.DebitAmount); // Column - CreditAmount CreditAmount = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.CreditAmount); // Column - DebitCreditTotal DebitCreditTotal = ExcelColumnHelper.GetDoubleDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.DebitCreditTotal); // Column - Created On - Key CreatedOnKey = ExcelColumnHelper.GetDateTimeDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.CreatedOnKey, ExcelColumnHelper.ExcelDateTimeCellType.StringWithDateTime); // Column - Posting Date Key PostingDateKey = ExcelColumnHelper.GetDateTimeDataValueForColumnName(dr, rowIndex, columnNameToLetterDict, FbmsInvoiceStageImports.PostingDateKey, ExcelColumnHelper.ExcelDateTimeCellType.StringWithDateTime); }