public void ParseBankRecords(string file)
{
List<BankRecord> records = new List<BankRecord>();
TextFieldParser parser = new TextFieldParser(file);
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
while (!parser.EndOfData)
{
try
{
using (var db = new BankTransactionsContext())
{
records.Add(createRecord(parser.ReadFields()));
}
}
catch (ArgumentException e)
{
// This record is either corrupt, or we've reached the end of the list: just continue on.
continue;
}
}
// Save the records and other info into the database.
using (var db = new BankTransactionsContext())
{
BankTransactionsUpload upload = new BankTransactionsUpload()
{
fileName = file,
filePath = System.IO.Path.Combine(ConfigurationManager.BaseLocation, "Uploaded/" + DateTime.Now.Ticks + "_" + System.IO.Path.GetFileName(file)),
user = "******",
bankRecord = records
};
db.SaveChanges();
}
parser.Close();
}
public void ParseBankRecords(string file)
{
List<BankRecord> records = new List<BankRecord>();
TextFieldParser parser = new TextFieldParser(file);
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");
parser.ReadFields();
while (!parser.EndOfData)
{
try
{
string[] fields = parser.ReadFields();
string mutationType = fields[4];
string nameDefinition = String.Empty;
string announcement = String.Empty;
string[] parts;
switch (mutationType)
{
case "BA":
parts = fields[8].Split(new string[] { " / " }, StringSplitOptions.None);
nameDefinition = parts.First();
announcement = parts.Last() + fields[1];
break;
case "GT":
case "OV":
default:
nameDefinition = fields[1];
announcement = fields[8];
break;
case "VZ":
case "IC":
case "DV":
nameDefinition = fields[8];
announcement = fields[1];
break;
case "GM":
// If there exist angle brackets in the second field, return the first two parts divided by those brackets
if (fields[1].Contains('>'))
{
parts = fields[1].Split(new string[] { ">" }, StringSplitOptions.None);
nameDefinition = String.Join(" ", new string[] { parts[0], parts[1] });
announcement = fields[1].Split(new string[] { ">" }, StringSplitOptions.None).Last() + fields[8];
}
else
{
parts = fields[8].Split(new string[] { " / " }, StringSplitOptions.None);
nameDefinition = parts.First();
announcement = parts.Last() + fields[1];
}
break;
}
BankRecord record = new BankRecord()
{
ExecutionDate = DateTime.Parse(fields[0], CultureInfo.CurrentCulture),
RequestDate = DateTime.Parse(fields[0], CultureInfo.CurrentCulture),
Name = nameDefinition,
BankNum = fields[2],
OtherBankNumber = fields[3],
Type = fields[5] == "Bij" ? BankRecord.TransactionType.CREDIT : BankRecord.TransactionType.DEBIT,
Amount = Double.Parse(fields[6]),
Description1 = announcement
};
records.Add(record);
}
catch (ArgumentException e)
{
// This record is either corrupt, or we've reached the end of the list: just continue on.
continue;
}
}
// Save the records and other info into the database.
using (var db = new BankTransactionsContext())
{
BankTransactionsUpload upload = new BankTransactionsUpload()
{
fileName = file,
filePath = System.IO.Path.Combine(ConfigurationManager.BaseLocation, "Uploaded/" + DateTime.Now.Ticks + "_" + System.IO.Path.GetFileName(file)),
user = "******",
bankRecord = records
};
db.SaveChanges();
}
parser.Close();
}