protected void ButtonDelete_Click(object sender, EventArgs e) { MortgageLoggerSQL.DeleteAllRows(); }
protected void PopulateData() { GridViewHistory.DataSource = MortgageLoggerSQL.GetDataTable(); GridViewHistory.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { // If our interest rates are unpopulated if (DropDownListInterestRate.Items.Count is 0) { double[] percents = GeneratePercents(); foreach (double d in percents) { DropDownListInterestRate.Items.Add(d.ToString()); } } if (IsPostBack) { BulletedListProblems.Items.Clear(); double years = 0; double principal = 0; double interestrate = 0; // Try to get the years. if (RadioButtonListYears.SelectedItem != null) { // They've selected an 'other' year. if (RadioButtonListYears.SelectedItem.Value is "other") { try { years = Double.Parse(TextBoxYearsOther.Text); } catch (FormatException) { BulletedListProblems.Items.Add("Years is an invalid number."); } } else // They've selected a year from our radio buttons. { try { years = Double.Parse(RadioButtonListYears.SelectedItem.Value); } catch (FormatException) { BulletedListProblems.Items.Add("Years is an invalid number."); } } } else // They have not selected a radio button. { BulletedListProblems.Items.Add("No year selected."); } // Try to get the principal. try { principal = Double.Parse(TextBoxPrinciple.Text); } catch (FormatException) { BulletedListProblems.Items.Add("Principle is an invalid number."); } // Try to get the interest rate. try { interestrate = Double.Parse(DropDownListInterestRate.SelectedValue); } catch (FormatException) { BulletedListProblems.Items.Add("Interest rate is an invalid number."); } // If there are no problems if (BulletedListProblems.Items.Count is 0) { double res = MortgageLib.MonthlyPayment(principal, interestrate, years); // Seconds since UNIX epoch. int secs = (int)((DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds); MortgageLoggerSQL.TryCreateTables(); // Log a single mortgage. MortgageLoggerSQL.Log(new MortgageLogEntry(secs, principal, interestrate, years)); string str = res.ToString("n2"); str = "$" + str; TextBoxResult.Text = str; } else { TextBoxResult.Text = null; } } else // Not postback. { } }