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