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