public Expense ExtractExpenseData(string RawExpenseText)
{
var expense = new Expense();
try
{
//find each of the known xml tags. Note the <expense> tag which is parent to 2 other tags
//does not seem to be needed so its ignored
//field names are literals, could use reflection to get class field names and types
//or could be constants in the Expense class. leave as literals for now, may require refactoring later
valueParser.RawText = RawExpenseText;
expense.cost_centre = valueParser.ValueFinder("cost_centre", false);
expense.payment_method = valueParser.ValueFinder("payment_method", false);
expense.vendor = valueParser.ValueFinder("vendor", false);
expense.description = valueParser.ValueFinder("description", false);
// in the real world we might have to just use string for this field if the format isnt reliable
DateTime Date;
if (DateTime.TryParseExact(valueParser.ValueFinder("date", false),
"dddd dd MMMM yyyy", null, DateTimeStyles.None, out Date))
{
expense.date = Date;
}
else
{
expense.date = DateTime.MinValue;
}
expense.total = Decimal.Parse(valueParser.ValueFinder("total", true));
}
// any unclosed tag is a fatal error
catch (NoClosingTagException)
{
throw;
}
//only gets thrown if the field is mandatory
catch (NoOpeningTagException)
{
throw;
}
return(expense);
}
