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