private void Button1_Click(object sender, EventArgs e) { connection = new SqlConnection(); command = new SqlCommand(); connection.ConnectionString = "server=.;initial catalog=MANAGER;integrated security=true"; command.Connection = connection; connection.Open(); SqlCommand cmd = new SqlCommand(" select ad_ID FROM Addmin Where ad_username=@ad_username and ad_password =@ad_password ", connection); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ad_username", textBox1.Text); cmd.Parameters.AddWithValue("@ad_password", textBox2.Text); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { this.Visible = false; Managment obj2 = new Managment(); obj2.ShowDialog(); } else { MessageBox.Show("invalid username or password.....try again"); } connection.Close(); }
private void Button3_Click(object sender, EventArgs e) { connection = new SqlConnection(); command = new SqlCommand(); connection.ConnectionString = "server=.;initial catalog=MANAGER;integrated security=true"; command.Connection = connection; connection.Open(); try { SqlCommand cmd = new SqlCommand("insert into Employee(em_username , em_password , em_fullname,task )values( @em_username , @em_password , @em_fullname,@task ) ", connection); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@em_username", textBox2.Text); cmd.Parameters.AddWithValue("em_fullname", textBox1.Text); cmd.Parameters.AddWithValue("@em_password ", textBox3.Text); cmd.Parameters.AddWithValue("@task ", textBox4.Text); int i = cmd.ExecuteNonQuery(); if (i > 0) { MessageBox.Show("account created seccessfuly"); SqlCommand cmd1 = new SqlCommand("select max(em_ID) from Employee", connection); SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read()) { MessageBox.Show("dear Employee ,your id is '" + dr1.GetInt32(0) + "' your registetration seccessfullt"); this.Hide(); Managment obj2 = new Managment(); obj2.ShowDialog(); } connection.Close(); } else { MessageBox.Show("account not created "); } connection.Close(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } }