public Chart(double lv, double v, double hv, double lg, double g, double hg, double cv, double cg, CashFlow ob, Advanced ob2) { InitializeComponent(); low_value = lv; value = v; high_value = hv; low_growth = lg; growth = g; high_growth = hg; custom_value = cv; custom_growth = cg; previous = ob; previous2 = ob2; }
private void button2_Click(object sender, EventArgs e) { if (!double.TryParse(textBox1.Text, out cash[0])) { label9.Visible = true; } else { label9.Visible = false; } if (!double.TryParse(textBox2.Text, out cash[1])) { label10.Visible = true; } else { label10.Visible = false; } if (!double.TryParse(textBox3.Text, out cash[2])) { label11.Visible = true; } else { label11.Visible = false; } if (!double.TryParse(textBox4.Text, out cash[3])) { label12.Visible = true; } else { label12.Visible = false; } if (!double.TryParse(textBox5.Text, out cash[4])) { label13.Visible = true; } else { label13.Visible = false; } if (!double.TryParse(textBox6.Text, out custom_growth)) { label14.Visible = true; } else { custom_growth = custom_growth / 100; label14.Visible = false; } if (label9.Visible == true || label10.Visible == true || label11.Visible == true || label12.Visible == true || label13.Visible == true || label14.Visible == true) { label8.Visible = true; return; } else { discount_rate = riskfree + beta * (market - riskfree); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"SELECT * FROM FirmNormal WHERE @name = Firm", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); da = new SqlCeDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); cmd.ExecuteReader(); if (dt.Rows.Count != 0) { check = false; } if (check == true) { connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"INSERT INTO FirmNormal (Firm, Year1, Year2, Year3, Year4, Year5) VALUES (@name, @yr1, @yr2, @yr3, @yr4, @yr5)", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"INSERT INTO FirmLow (Firm, Year1, Year2, Year3, Year4, Year5) VALUES (@name, @yr1, @yr2, @yr3, @yr4, @yr5)", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"INSERT INTO FirmHigh (Firm, Year1, Year2, Year3, Year4, Year5) VALUES (@name, @yr1, @yr2, @yr3, @yr4, @yr5)", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"INSERT INTO FirmCustom (Firm, Year1, Year2, Year3, Year4, Year5, GrowthRate) VALUES (@name, @yr1, @yr2, @yr3, @yr4, @yr5, @growth)", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.Parameters.AddWithValue("@growth", custom_growth); cmd.ExecuteNonQuery(); } else { connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"UPDATE FirmNormal SET Year1 = @yr1, Year2 = @yr2, Year3 = @yr3, Year4 = @yr4, Year5 = @yr5 WHERE Firm = @name", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"UPDATE FirmLow SET Year1 = @yr1, Year2 = @yr2, Year3 = @yr3, Year4 = @yr4, Year5 = @yr5 WHERE Firm = @name", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"UPDATE FirmHigh SET Year1 = @yr1, Year2 = @yr2, Year3 = @yr3, Year4 = @yr4, Year5 = @yr5 WHERE Firm = @name", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.ExecuteNonQuery(); connect = new SqlCeConnection(database); connect.Open(); cmd = new SqlCeCommand(@"UPDATE FirmCustom SET Year1 = @yr1, Year2 = @yr2, Year3 = @yr3, Year4 = @yr4, Year5 = @yr5, GrowthRate = @growth WHERE Firm = @name", connect); cmd.Parameters.AddWithValue("@name", firm.Trim()); cmd.Parameters.AddWithValue("@yr1", cash[0]); cmd.Parameters.AddWithValue("@yr2", cash[1]); cmd.Parameters.AddWithValue("@yr3", cash[2]); cmd.Parameters.AddWithValue("@yr4", cash[3]); cmd.Parameters.AddWithValue("@yr5", cash[4]); cmd.Parameters.AddWithValue("@growth", custom_growth); cmd.ExecuteNonQuery(); } Advanced form = new Advanced(cash, growth, custom_growth, discount_rate, this, firm); Hide(); form.ShowDialog(); Show(); } }