private static PdfPremiumTransaction ExtractDataFromCsvLine(string csvLine) { var csvValues = csvLine.Split('|'); var newPremiumTransaction = new PdfPremiumTransaction { StatementContractNumber = csvValues[0], StatementDate = Convert.ToDateTime(csvValues[1]).ToString("yyyy-MM-dd"), StatementProducer = csvValues[2], DisbursementAmount = Convert.ToDecimal(csvValues[3]), PolicyProducer = csvValues[4], ProducerContractNumber = csvValues[5], PolicyNumber = csvValues[6], TransactionDate = Convert.ToDateTime(csvValues[7]).ToString("yyyy-MM-dd"), Amount = Convert.ToDecimal(csvValues[8]), ExcessAmount = Convert.ToDecimal(csvValues[9]), PaidToProducer = Convert.ToDecimal(csvValues[10]), PaidToBGA = Convert.ToDecimal(csvValues[11]), StagedDate = DateTime.Today.ToString("yyyy-MM-dd"), ImportDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd") }; if (csvValues.Length > 12) { newPremiumTransaction.EffectiveDate = Convert.ToDateTime(csvValues[12]).ToString("yyyy-MM-dd"); newPremiumTransaction.Insured = csvValues[13]; newPremiumTransaction.Product = csvValues[14]; newPremiumTransaction.IssueState = csvValues[15]; newPremiumTransaction.Mode = csvValues[16]; } else { newPremiumTransaction.EffectiveDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd"); newPremiumTransaction.Insured = string.Empty; newPremiumTransaction.Product = string.Empty; newPremiumTransaction.IssueState = string.Empty; newPremiumTransaction.Mode = string.Empty; } if (csvValues.Length > 17) { newPremiumTransaction.PaidToDate = Convert.ToDateTime(csvValues[17]).ToString("yyyy-MM-dd"); } else { newPremiumTransaction.PaidToDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd"); } return(newPremiumTransaction); }
private static PdfPremiumTransaction ExtractDepositFromCsvLine(string csvLine) { var csvValues = csvLine.Split('|'); var newPremiumTransaction = new PdfPremiumTransaction { StatementDate = Convert.ToDateTime(csvValues[0]).ToString("yyyy-MM-dd"), StatementProducer = csvValues[1], DisbursementAmount = Convert.ToDecimal(csvValues[2]), TransactionDate = DateTime.Today.ToString("yyyy-MM-dd"), EffectiveDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd"), PaidToDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd"), StagedDate = DateTime.Today.ToString("yyyy-MM-dd"), ImportDate = Convert.ToDateTime("01/01/1900").ToString("yyyy-MM-dd") }; return(newPremiumTransaction); }