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