//page navigation start private void adminPanelToolStripMenuItem_Click_1(object sender, EventArgs e) { adPanel ad = new adPanel(); ad.Show(); this.Hide(); }
private void btnLogin_Click(object sender, EventArgs e) { string id = txtId.Text; if (string.IsNullOrEmpty(id)) { MessageBox.Show("ID required"); txtId.Focus(); return; } string password = txtPass.Text; if (string.IsNullOrEmpty(password)) { MessageBox.Show("Password required"); txtPass.Focus(); return; } if (password.Length < 8) { MessageBox.Show("minimum 8 character required"); txtPass.Focus(); return; } string query = "select * from Users where id = '" + txtId.Text + "' and pass='******'"; DataTable dt = DataAccess.GetData(query); if (dt == null) { return; } if (dt.Rows.Count != 1) { MessageBox.Show("Invalid Username Or Password"); return; } string uType = dt.Rows[0]["uType"].ToString(); if (uType == "admin") { adPanel ad = new adPanel(txtId.Text); User.userId = txtId.Text; query = "select * from Users where id=" + txtId.Text + ""; dt = DataAccess.GetData(query); User.userName = dt.Rows[0]["name"].ToString(); ad.Show(); this.Hide(); } else if (uType == "teacher") { t_DashBoard tDash = new t_DashBoard(txtId.Text); User.userId = txtId.Text; query = "select Users.id,[name],pass,dob,[address],teacherNum,teacherEmail,salary.salary,allowance " + "from salary,Users where Users.id=" + txtId.Text + " and salary.s_id= Users.id"; dt = DataAccess.GetData(query); User.userName = dt.Rows[0]["name"].ToString(); User.u_pass = dt.Rows[0]["pass"].ToString(); User.u_dob = dt.Rows[0]["dob"].ToString(); User.u_address = dt.Rows[0]["address"].ToString(); User.t_Num = dt.Rows[0]["teacherNum"].ToString(); User.t_Email = dt.Rows[0]["teacherEmail"].ToString(); User.t_salary = dt.Rows[0]["salary"].ToString(); User.t_allowance = dt.Rows[0]["allowance"].ToString(); tDash.Show(); this.Hide(); } else if (uType == "student") { } else { MessageBox.Show("Invalid Users!!"); return; } }