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