private void button1_Click(object sender, EventArgs e) { BauCu form = new BauCu(user_name, pwd, ho_ten, ma_tv); form.Show(); }
private void login_btn_Click(object sender, EventArgs e) { string connectionString = @"Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-II7U9L8)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) );User Id = admin_ABC;password=123"; OracleConnection con = new OracleConnection(); con.ConnectionString = connectionString; OracleCommand command = new OracleCommand(); command.Connection = con; command.CommandText = "admin_abc.users_login"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new OracleParameter("para_username", OracleDbType.Varchar2, 32767)).Value = user_name.Text.Trim().ToUpper(); command.Parameters.Add(new OracleParameter("para_pass_word", OracleDbType.Varchar2, 32767)).Value = pwd.Text.Trim(); command.Parameters.Add("para_hoten", OracleDbType.Varchar2, 32767).Direction = ParameterDirection.Output; command.Parameters.Add("para_role", OracleDbType.Varchar2, 32767).Direction = ParameterDirection.Output; try { con.Open(); command.ExecuteNonQuery(); string hoten = command.Parameters["para_hoten"].Value.ToString(); string role = command.Parameters["para_role"].Value.ToString(); //Lấy dữ liệu mã thành viên OracleCommand getRoleList = new OracleCommand(); getRoleList.CommandText = "select owner_member from ADMIN_ABC.user_login where username = :user_name"; getRoleList.Parameters.Add(new OracleParameter("user_name", OracleDbType.Varchar2)).Value = user_name.Text.Trim(); getRoleList.Connection = con; getRoleList.CommandType = CommandType.Text; OracleDataReader dr = getRoleList.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); int ma_tv = Int32.Parse(dt.Rows[0]["owner_member"].ToString()); // MessageBox.Show(user_name.Text.Trim().ToUpper() + " and " + pwd.Text.Trim() + " and " + hoten + " and " + ma_tv); if (role == "BTC") { // MessageBox.Show("The role of this user is: " + role); Form1 form = new Form1(user_name.Text.Trim().ToUpper(), pwd.Text.Trim(), hoten, ma_tv); form.Show(); con.Close(); } if (role == "LDS") { OracleConnection con1 = new OracleConnection(); con1.ConnectionString = connectionString; con1.Open(); //Lấy dữ liệu cho table danh sách những người thuộc tổ lập danh sách người đi bầu, tổ theo dõi kết quả và tổ giám sát. OracleCommand getRoleList1 = new OracleCommand(); getRoleList1.CommandText = "select vt.dviphutrach from vaitro vt, user_login ul where ul.owner_member = vt.matv and ul.username = :user_name"; //+ user_name.Text.Trim(); getRoleList1.Parameters.Add(new OracleParameter("user_name", OracleDbType.Varchar2)).Value = user_name.Text.Trim(); getRoleList1.Connection = con1; getRoleList1.CommandType = CommandType.Text; OracleDataReader dr1 = getRoleList1.ExecuteReader(); DataTable dt1 = new DataTable(); dt1.Load(dr1); int view = Int32.Parse(dt1.Rows[0]["dviphutrach"].ToString()); ToLapDS form = new ToLapDS(user_name.Text.Trim().ToUpper(), pwd.Text.Trim(), hoten, view, ma_tv); form.Show(); } if (role == "THEODOI") { ToTheoDoiKQ form = new ToTheoDoiKQ(user_name.Text.Trim().ToUpper(), pwd.Text.Trim(), hoten, ma_tv); form.Show(); } if (role == "GIAMSAT") { ToGiamSat form = new ToGiamSat(user_name.Text.Trim().ToUpper(), pwd.Text.Trim(), hoten, ma_tv); form.Show(); } if (role == "THANHVIEN") { BauCu form = new BauCu(user_name.Text.Trim().ToUpper(), pwd.Text.Trim(), hoten, ma_tv); form.Show(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); //MessageBox.Show("Invalid username or password!"); } }