/// <summary>
/// Are all relevant columns in this row blank?
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static bool RowIsBlank(DataRow dr)
{
var columnsToCheck = PnBudgetsStageImports.PnBudgets_GetBudgetColumnLetterToColumnNameDictionary().Keys.ToList();
var allColumnsBlank = columnsToCheck.All(col => String.IsNullOrWhiteSpace(dr[col].ToString()));
return(allColumnsBlank);
}
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);
}
