public List <MortageInfo> GetAllMortgages() { string filename = GetServerMapPath(); int mortgageString = 0, principal = 1, interest = 2, years = 3, monthlypayment = 4; var mortgageList = new List <MortageInfo>(); try { foreach (var line in File.ReadAllLines(filename)) { string[] items = line.Split(';'); var mortgageInfo = new MortageInfo(); mortgageInfo.MortgageString = items[mortgageString]; mortgageInfo.Principal = double.Parse(items[principal]); mortgageInfo.InterestRate = double.Parse(items[interest]); mortgageInfo.DurationYears = double.Parse(items[years]); mortgageInfo.MonthlyPayment = double.Parse(items[monthlypayment]); mortgageList.Add(mortgageInfo); } } catch (IOException ex) { Console.WriteLine(ex.Message); } return(mortgageList); }
public List <MortageInfo> GetAllMortgages() { var mortgageList = new List <MortageInfo>(); try { using (SqlConnection sqlConnection = new SqlConnection(this.ConnectionString)) { string sqlDeleteStatement = "select * from loandetails"; sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand(sqlDeleteStatement, sqlConnection)) { using (var dbReader = sqlCommand.ExecuteReader()) { while (dbReader.Read()) { var mortgageInfo = new MortageInfo() { Principal = (double)dbReader["Principal"], InterestRate = (double)dbReader["InterestRate"], DurationYears = (double)dbReader["DurationYears"], MonthlyPayment = (double)dbReader["MonthlyPayment"], MortgageString = dbReader["LoanDescription"].ToString() }; mortgageList.Add(mortgageInfo); } } } } return(mortgageList); } catch (Exception ex) { throw ex; } }