private void button_Submit_Click(object sender, EventArgs e) { var services = new BLL(); var user_drop = new DanhSachUser(); user_drop.username = comboBox_ListRole.Text; ds = services.Drop_role(user_drop); MessageBox.Show("Drop role thành công", "*****THÔNG BÁO*****"); }
public DanhSachUser Drop_role_In_Database(DanhSachUser ds) { OracleConnection conn = Connect(); OracleCommand orc = new OracleCommand(); orc.Connection = conn; orc.CommandText = "sp_drop_role"; orc.Parameters.Add(new OracleParameter("username", OracleDbType.Varchar2)).Value = $"{ds.username}"; orc.CommandType = System.Data.CommandType.StoredProcedure; orc.ExecuteNonQuery(); conn.Close(); return(ds); }
public DanhSachUser Drop_user_In_Database(DanhSachUser ds) { OracleConnection conn = Connect(); OracleCommand orc = new OracleCommand(); orc.Connection = conn; // string s = @"''_ORACLE_SCRIPT''"; orc.CommandText = "sp_drop_user"; orc.Parameters.Add(new OracleParameter("username", OracleDbType.Varchar2)).Value = $"{ds.username}"; orc.CommandType = System.Data.CommandType.StoredProcedure; //$"begin execute sp_drop_user('{ds.username}'); end;"; orc.ExecuteNonQuery(); conn.Close(); return(ds); }
private void button_Submit_Click(object sender, EventArgs e) { var services = new BLL(); var role_create = new Entity_Object.DanhSachUser(); role_create.username = textBox_rolename.Text; var tontai = services.TonTaiRole(role_create.username); if (tontai) { MessageBox.Show("Role đã tồn tại"); return; } ds = services.Create_role(role_create); MessageBox.Show("Tạo role thành công", "*****THÔNG BÁO*****"); }
public DanhSachUser Drop_role(DanhSachUser danhsach) { var respon = new DAL(); return(respon.Drop_role_In_Database(danhsach)); }