private void btnLogin_Click(object sender, EventArgs e) { string userName = txtUserName.Text; string password = txtPassword.Text; int role; if (txtUserName.Text.Trim() == "" || txtPassword.Text.Trim() == "") { MessageBox.Show("Please enter username and password!"); } mySet = new DataSet(); myCon = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=DBRemax;Integrated Security=True"); myCon.Open(); myCmd = new SqlCommand("SELECT * FROM Users WHERE UserName = '******' AND Password = '******'", myCon); myAdapter = new SqlDataAdapter(myCmd); myAdapter.Fill(mySet, "Users"); tabUsers = mySet.Tables["Users"]; if (tabUsers.Rows.Count > 0) { MessageBox.Show("Welcome back " + userName + " !"); this.Hide(); frmManagement fm = new frmManagement(); frmManageClient fmCl = new frmManageClient(); foreach (DataRow myRow in tabUsers.Rows) { fm.lblRoleId.Text = myRow["RoleId"].ToString(); fm.lblId.Text = myRow["EmployeeId"].ToString(); } role = Convert.ToInt32(tabUsers.Rows[0]["RoleId"]); switch (role) { case 0: fm.Show(); fm.btnManageEmployees.Hide(); fm.lblRoleId.Text = role.ToString(); break; case 1: fm.Show(); fm.lblRoleId.Text = role.ToString(); break; } } else { lblError.Text = "Incorrect UserName or Password!"; lblError.Visible = true; } }
private void btnManageClients_Click(object sender, EventArgs e) { frmManageClient fmCl = new frmManageClient(); fmCl.lblUser.Text = this.lblId.Text; fmCl.lblRoleId.Text = this.lblRoleId.Text; fmCl.Show(); //this.Hide(); //frmManageClient fmcl = new frmManageClient(); //fmcl.MdiParent = this; //fmcl.Show(); }