static OxfordLineItem ProcessRow(DataRow row)
{
/// only use rows with the code
/// (other rows are not data)
if (row[0].ToString() != CfgCode) return null;
OxfordLineItem lineItem = new OxfordLineItem();
// columns in order from 6 - 15
lineItem.GroupCode = row[6].ToString();
lineItem.GroupName = row[7].ToString();
lineItem.InvoicePeriod = row[8].ToString();
lineItem.AmountBilled = row.DecimalAt(9);
lineItem.PaymentReceived = row.DecimalOrNullAt(10);
lineItem.PercentOfPremium = row.DoubleOrNullAt(11);
lineItem.PEPM = row.IntAt(12);
lineItem.SubCountPEPM = row.IntOrNullAt(13, "N/A");
lineItem.CommissionAmount = row.DecimalOrNullAt(14);
lineItem.AmountDue = row.DecimalAt(15);
return lineItem;
}
private static HorizonLineItem ProcessRowExcel(DataRow row)
{
/// only use rows with the code
/// (other rows are not data)
if (row[0].ToString().Trim() != CfgCode) return null;
HorizonLineItem item = new HorizonLineItem();
// 0 - "COASTAL FINANCIAL GROUP"
// 1 - "005766"
item.GroupName = row.StringAt(2);
item.GroupNumber = row.StringAt(3);
item.Product = row.StringAt(4);
item.EffectiveDate = row.StringAt(5);
item.RenewalDate = row.StringAt(6);
item.InsuredPeriod = row.StringAt(7);
item.C_CodeOneHundredd = row.StringAt(8); // always "100"
item.C_CoastalCode = row.StringAt(9); // always "005766"
item.CommissionSchedule = row.StringAt(10);
item.C_TotalPremiumYTD = row.StringAt(11);
item.PremiumReceived = row.DecimalAt(12);
item.CommissionReceived = row.DecimalAt(13);
return item;
}
