private void reLoad()
{
panel1.Dock = DockStyle.Fill;
panel1.Anchor = AnchorStyles.Left;
panel2.Dock = DockStyle.Fill;
panel2.Anchor = AnchorStyles.Left;
panel1.Visible = true;
panel2.Visible = true;
panel1.Show();
panel2.Hide();
TopPerformers.DataSource = db.getTopPerformers();
DataTable dt10 = new DataTable();
DataTable curstocks = new DataTable();
curstocks.Columns.Add("Stock_Name");
curstocks.Columns.Add("stock_quantity");
dt10 = db.select_allstockhistory(account_id);
foreach (DataRow dr in dt10.Rows)
{
if (dr["sh_type"].ToString() == "BUY")
{
bool found = false;
foreach (DataRow dr2 in curstocks.Rows)
{
if (dr2[0].ToString() == dr["s_name"].ToString())
{
dr2["stock_quantity"] = decimal.Parse(dr2["stock_quantity"].ToString()) + decimal.Parse(dr["quantity"].ToString());
found = true;
break;
}
dr2.AcceptChanges();
}
if (!found)
{
curstocks.Rows.Add(dr["s_name"], dr["quantity"]);
}
}
if (dr["sh_type"].ToString() == "SELL")
{
foreach (DataRow dr2 in curstocks.Rows)
{
if (dr2[0].ToString() == dr["s_name"].ToString())
{
dr2["stock_quantity"] = (decimal.Parse(dr2["stock_quantity"].ToString()) - decimal.Parse(dr["quantity"].ToString()));
break;
}
dr2.AcceptChanges();
}
}
}
stocksview.DataSource = curstocks;
cdview.DataSource = db.select_allcd(account_id);
bondsview.DataSource = db.select_allbonds(account_id);
Cashview.DataSource = db.select_allcash(account_id);
currentcdview.DataSource = db.select_allcd(account_id);
currentbondview.DataSource = db.select_allbonds(account_id);
stockhistoryview.DataSource = db.select_allstockhistory(account_id);
historybondsview.DataSource = db.select_allbondshistory(account_id);
historyCDview.DataSource = db.select_allcdhistory(account_id);
cash.Text = db.select_cash(account_id);
netvalue.Text = db.getnetvalue(account_id);
DataTable dt4 = new DataTable();
dt4 = db.select_user(user_id);
usernametb.Text = dt4.Rows[0][0].ToString();
passwordtb.Text = dt4.Rows[0][1].ToString();
phonetb.Text = dt4.Rows[0][2].ToString();
emailtb.Text = dt4.Rows[0][3].ToString();
lnametb.Text = dt4.Rows[0][4].ToString();
fnametb.Text = dt4.Rows[0][5].ToString();
}