public ImpRecord(Logger l)
{
logger = l;
transactionNumber = string.Empty;
transactionDate = new DateOnly(logger);//Handel Dato
status = ' ';
customerNumber = string.Empty;
transactionType = string.Empty;
settlementDate = new DateOnly(logger);//Valør Dato
accountNumber = string.Empty;
idCode = string.Empty;
depotNumber = string.Empty;
amount = new DecimalNumber(12, 12, false, logger); //Stk
exchangeRate = new DecimalNumber(9, 9, true, logger); //kurs / beløb
currenciesCross = string.Empty;
currenciesRate = new DecimalNumber(9, 9, false, logger); //Valutakurs
yeildTax = new DecimalNumber(12, 7, true, logger); //Valutakurs
interest = new DecimalNumber(12, 7, true, logger); //Vedh. Renter
kurtage = new DecimalNumber(9, 3, true, logger); //Kurtage
cost = new DecimalNumber(9, 3, true, logger); //Diverse omkostninger
cuponTax = new DecimalNumber(9, 3, true, logger); //Kuponskat
counterPart = string.Empty;
nota = ' ';
name = string.Empty;
time = string.Empty;
projectNumber = string.Empty;
unknown = string.Empty;
tekst = string.Empty;
art = new DecimalNumber(12, 11, false, logger); //art
saldiValuer = new DecimalNumber(12, 6, true, logger); //saldiValuer
}
public int Process(ref string emailBody, ref bool debugLevel, ref bool success, string fileName, string folder)
{
numberOfSupoerPortRecords = 0;
logger.Write(" Nykrdit format");
string counterPart = "NY";
if (folder.ToLower().Contains("handelsbanken"))
{
counterPart = "HA";
}
// Removing qoutes
if (lines[0].IndexOf("\"") == 0)
{
for (int k = 1; k < lines.Length; k++)
{
lines[k] = lines[k].Substring(1, lines[k].Length - 2);
}
}
int ks = 0;
int ub = 0;
int ud = 0;
int an = 0;
int db = 0;
int kb = 0;
int dk = 0;
ImpRecord uBImpRecord = null;
if (lines.Length > 2)
{
for (int k = 1; k < lines.Length - 1; k++)
{
string[] fields = lines[k].Split(';');
if (debugLevel)
{
logger.WriteFields(fields);
}
if (lines[k].IndexOf("KS;") == 0)
{
ks++;
ImpRecord impRecord = new ImpRecord(logger);
if (fields.Length < 35)
{
emailBody += Environment.NewLine + "Nykredit KS record " + ks + " has too few fields";
logger.Write(" KS record too few fields");
}
else
{
if (fields[20].CompareTo("ORDRE") == 0)
{
continue;
}
impRecord.setTransactionType(fields[10]); // Salg
impRecord.setDepotNumber(fields[1]);
impRecord.setAccountNumber(fields[2]);
impRecord.setIdCode(fields[4].TrimEnd());
// impRecord.setTransactionNumber(fields[5]); use SuperPorts
impRecord.setTransactionDate(fields[13]);
impRecord.setSettlementDate(fields[14]);
if (fields[6][0] == 'P') // PENDING
{
impRecord.setStatus('O');
}
else if (fields[6][0] == 'S') // SETTLED
{
impRecord.setStatus('N');
}
else // CANCELLED
{
impRecord.setStatus('D');
}
if (fields[10] == "S")
{
impRecord.setTransactionType("K");
}
else if (fields[10] == "B")
{
impRecord.setTransactionType("S");
}
else
{
logger.Write(" KS unknown transaction type" + fields[10]);
}
impRecord.setCurrenciesCross(fields[11] + "/" + fields[12]);
impRecord.setCurrenciesRate(fields[15]);
impRecord.setAmount(fields[16]);
impRecord.setPrice(fields[17]);
impRecord.setCost("-" + fields[22]);
impRecord.setKurtage("-" + fields[21]);
impRecord.setNota('N');
impRecord.setCounterPart(counterPart); // Nykredit
impRecord.setUnknown("000000737632.00000000000");
numberOfSupoerPortRecords++;
impRecord.writeKoebSalgAktier(fileName);
}
}
else if (lines[k].IndexOf("UB;") == 0)
{
ub++;
//ImpRecord impRecord = new ImpRecord(logger);
if (uBImpRecord == null)
{
uBImpRecord = new ImpRecord(logger);
}
else if (uBImpRecord.getDepotNumber().TrimStart().CompareTo(fields[1].TrimEnd()) == 0 &&
uBImpRecord.getIdCode().TrimStart().CompareTo(fields[23].TrimEnd()) == 0)
{
// handle extra tax record
DecimalNumber yeildTax = new DecimalNumber(12, 7, true, logger);
yeildTax.setDecimalNumber("-" + fields[18]);
// set if not set
if (!uBImpRecord.yieldTaxSet())
{
uBImpRecord.setYieldTax("-" + fields[18]);
}
else
{
// set if bigger than value
if (uBImpRecord.getYieldTax().CompareTo(yeildTax.getDecimalNumber()) < 0)
{
uBImpRecord.setYieldTax("-" + fields[18]);
}
}
continue;
}
else
{
numberOfSupoerPortRecords++;
uBImpRecord.writeUdbytteAktier(fileName);
uBImpRecord = new ImpRecord(logger);
}
if (fields.Length < 23)
{
emailBody += Environment.NewLine + "Nykredit UB record " + ub + " has too few fields";
logger.Write(" UB record too few fields");
}
else
{
uBImpRecord.setDepotNumber(fields[1]);
uBImpRecord.setAccountNumber(fields[2]);
uBImpRecord.setIdCode(fields[23].TrimEnd());
// impRecord.setTransactionNumber(fields[4].Substring(0, fields[4].Length < 8 ? fields[4].Length : 8)); use SuperPorts
if (fields[5][0] == 'N' || fields[5][0] == 'A') // NEW // AMENDED
{
uBImpRecord.setStatus('N');
}
else // CANCELLED
{
uBImpRecord.setStatus('D');
}
if (fields[7] == "A")
{
uBImpRecord.setTransactionType("U");
}
else if (fields[7] == "K")
{
uBImpRecord.setTransactionType("KR");
}
else
{
logger.Write(" UB unknown transaction type" + fields[10]);
}
uBImpRecord.setCurrenciesCross(fields[8] + "/" + fields[9]);
uBImpRecord.setTransactionDate(fields[11]); // has to be same as valør dato!
uBImpRecord.setSettlementDate(fields[11]);
uBImpRecord.setCurrenciesRate(fields[12]);
//impRecord.setAmount(fields[21]);
uBImpRecord.setPrice(fields[15]);
uBImpRecord.setCost(fields[19]);
uBImpRecord.setNota('N');
/*numberOfSupoerPortRecords++;
* uBImpRecord.writeUdbytteAktier(fileName);
* uBImpRecord = null;*/
}
}
else if (lines[1].IndexOf("UD;") == 0)
{
ud++;
}
else if (lines[1].IndexOf("AN;") == 0)
{
an++;
}
else if (lines[1].IndexOf("DB;") == 0)
{
db++;
}
else if (lines[1].IndexOf("KB;") == 0)
{
kb++;
}
else if (lines[1].IndexOf("DK;") == 0)
{
dk++;
}
else if (lines[k] == String.Empty)
{
}
else
{
success = false;
logger.Write(" Ukendt fil format, " + lines[k]);
}
}
if (uBImpRecord != null)
{
numberOfSupoerPortRecords++;
uBImpRecord.writeUdbytteAktier(fileName);
uBImpRecord = null;
}
if (ks > 0)
{
logger.Write(" Depotbevægelser : " + ks);
}
if (ub > 0)
{
logger.Write(" Udbytte, Aktier og obligationer : " + ub);
}
if (ud > 0)
{
logger.Write(" Udtrukne obligationer : " + ud);
}
if (an > 0)
{
logger.Write(" Kontobevægelse : " + an);
}
if (db > 0)
{
logger.Write(" Depotbeholdninger : " + db);
}
if (kb > 0)
{
logger.Write(" Kontantbeholdninger : " + kb);
}
if (dk > 0)
{
logger.Write(" Relationer mellem depoter og konti : " + dk);
}
}
else
{
if (lines.Length == 2 && lines[1].IndexOf("TAIL;") == 0)
{
logger.Write(" Filen indeholder ingen rcords");
}
else
{
success = false;
logger.Write(" Ukendt fil format");
}
}
return(numberOfSupoerPortRecords);
}