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));
}
