public List<Transaction> ConvertRecords(Stream s)
{
List<Transaction> xacts = new List<Transaction>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null) {
if (fields[0] == "TRANSACTION DATE")
continue;
Transaction xact = new Transaction();
try {
xact.Date = DateTime.ParseExact(fields[0], "mm/dd/yy", null);
xact.PostedDate = DateTime.ParseExact(fields[1], "mm/dd/yy", null);
xact.Payee = fields[2].Trim();
xact.Code = fields[3].Trim();
xact.Amount = Convert.ToDecimal(fields[4].Trim());
if (xact.Code.Length == 0)
xact.Code = null;
xacts.Add(xact);
}
catch (System.FormatException) {}
}
}
return xacts;
}
public List<Posting> ConvertRecords(Stream s)
{
List<Posting> posts = new List<Posting>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null) {
if (fields[0] == "POSTING DATE")
continue;
Posting post = new Posting();
post.Date = DateTime.ParseEpost(fields[0], "mm/dd/yy", null);
post.PostedDate = DateTime.ParseEpost(fields[1], "mm/dd/yy", null);
post.Payee = fields[2].Trim();
post.Code = fields[3].Trim();
post.Amount = Convert.ToDecimal(fields[4].Trim());
if (post.Code.Length == 0)
post.Code = null;
posts.Add(post);
}
}
return posts;
}
public List <Posting> ConvertRecords(Stream s)
{
List <Posting> posts = new List <Posting>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null)
{
if (fields[0] == "POSTING DATE")
{
continue;
}
Posting post = new Posting();
post.Date = DateTime.ParseEpost(fields[0], "mm/dd/yy", null);
post.PostedDate = DateTime.ParseEpost(fields[1], "mm/dd/yy", null);
post.Payee = fields[2].Trim();
post.Code = fields[3].Trim();
post.Amount = Convert.ToDecimal(fields[4].Trim());
if (post.Code.Length == 0)
{
post.Code = null;
}
posts.Add(post);
}
}
return(posts);
}
public List <Transaction> ConvertRecords(Stream s)
{
List <Transaction> xacts = new List <Transaction>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null)
{
Transaction xact = new Transaction();
xact.Date = DateTime.ParseExact(fields[0], "m/dd/yyyy", null);
xact.Payee = fields[2].Trim();
xact.Code = fields[3].Trim();
xact.Amount = -Convert.ToDecimal(fields[4].Trim());
if (xact.Code.Length == 0)
{
xact.Code = null;
}
xacts.Add(xact);
}
}
return(xacts);
}
public List <Transaction> ConvertRecords(Stream s)
{
List <Transaction> xacts = new List <Transaction>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null)
{
if (fields[0] == "TRANSACTION DATE")
{
continue;
}
Transaction xact = new Transaction();
try {
xact.Date = DateTime.ParseExact(fields[0], "mm/dd/yy", null);
xact.PostedDate = DateTime.ParseExact(fields[1], "mm/dd/yy", null);
xact.Payee = fields[2].Trim();
xact.Code = fields[3].Trim();
xact.Amount = Convert.ToDecimal(fields[4].Trim());
if (xact.Code.Length == 0)
{
xact.Code = null;
}
xacts.Add(xact);
}
catch (System.FormatException) {}
}
}
return(xacts);
}
public List<Transaction> ConvertRecords(Stream s)
{
List<Transaction> xacts = new List<Transaction>();
using (CSVReader.CSVReader csv = new CSVReader.CSVReader(s)) {
string[] fields;
while ((fields = csv.GetCSVLine()) != null) {
Transaction xact = new Transaction();
xact.Date = DateTime.ParseExact(fields[0], "m/dd/yyyy", null);
xact.Payee = fields[2].Trim();
xact.Code = fields[3].Trim();
xact.Amount = - Convert.ToDecimal(fields[4].Trim());
if (xact.Code.Length == 0)
xact.Code = null;
xacts.Add(xact);
}
}
return xacts;
}
