private void Form1_Load(object sender, EventArgs e)
{
panel1.BackColor = Color.FromArgb(130, 11, 19, 43);
panel3.BackColor = Color.FromArgb(200, 11, 19, 43);
panel2.BackColor = Color.FromArgb(200, 28, 37, 65);
panel6.BackColor = Color.FromArgb(255, 39, 40, 56);
back.BackColor = Color.FromArgb(100, 139, 40, 56);
// display date & time
date.Text = DateTime.Now.ToString("dddd, dd MMMM yyyy");
panel2.Controls.Add(Dashboard.Instance);
Dashboard.Instance.Dock = DockStyle.Fill;
Dashboard.Instance.BringToFront();
// passing value from login;
con = new dbconfig();
con.query("select * from employee_acc where id ='" + identity.Text + "'");
DataRow row;
row = con.queryEx().Rows[0];
label4.Text = row[1].ToString().Trim() + " " + row[2].ToString().Trim();
label5.Text = row[15].ToString();
}
private void Send_message_Load(object sender, EventArgs e)
{
con = new dbconfig();
con.query("select * from employee_acc");
comboBox1.Items.Clear();
foreach (DataRow dr in con.queryEx().Rows)
{
comboBox1.Items.Add(dr[9].ToString());
}
}
private void Create_acc_Load(object sender, EventArgs e)
{
con = new dbconfig();
con.query("Select count(*) from create_acc");
DataRow row;
row = con.queryEx().Rows[0];
textBox4.Enabled = false;
int ac = 121122001 + Int32.Parse(row[0].ToString());
string Ac = Convert.ToString(ac);
textBox4.Text = Ac;
}
private void Login_page_Load(object sender, EventArgs e)
{
panel1.BackColor = Color.FromArgb(70, 205, 83, 52);
panel5.BackColor = Color.FromArgb(230, 0, 0, 0);
panel6.BackColor = Color.FromArgb(100, 0, 0, 0);
textBox1.SelectionStart = 0;
comboBox1.Items.Clear();
comboBox1.SelectedText = "Select type";
con = new dbconfig();
con.query("select * from employee_acc");
foreach (DataRow dr in con.queryEx().Rows)
{
comboBox1.Items.Add(dr[15].ToString());
}
}
