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);
}
