public IEnumerable<LineItem> XmlBillParse(string billpath)
{
XElement bill = XElement.Parse(billpath);
foreach (XElement line in bill.Elements("Breakdown_TotalCharges_Details xmlns:fo=\"http://www.w3.org/1999/XSL/Format\"").Elements("Breakdown_TotalCharges_Record"))
{
LineItem lineItem = new LineItem();
lineItem.Amount = Convert.ToDecimal(bill.Element("Breakdown_Total_Chrgs").Value);
lineItem.Description = bill.Element("Breakdown_TotalCharges_PhoneNumber").Value + bill.Element("Breakdown_TotalCharges_UserName").Value;
lineItem.Distribution = "";
yield return lineItem;
}
}
public IEnumerable<LineItem> CsvBillParse(string path)
{
var sr = new StreamReader(path);
var csvReader = new CsvReader(sr);
while (csvReader.Read())
{
if (csvReader.GetField("User_ID") != null && csvReader.GetField("User_ID") != "")
{
LineItem lineItem = new LineItem();
lineItem.Amount = Convert.ToDecimal(csvReader.GetField("Total_Current_Chgs").Substring(1));
lineItem.Description = csvReader.GetField("User_Name") + csvReader.GetField("Wireless Number");
lineItem.Distribution = CodeLookup(csvReader.GetField("User_ID"));
//lineItem.Distribution = csvReader.GetField("Cost_Center");
yield return lineItem;
}
}
}