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; } } }