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