private void btnTiepTanThem_Click(object sender, EventArgs e)
{
OracleDataProvider.conn.Open();
OracleCommand cmdIn = new OracleCommand("qlbv.add_benhnhan", OracleDataProvider.conn);
cmdIn.Parameters.Clear();
cmdIn.CommandType = CommandType.StoredProcedure;
cmdIn.Parameters.Add(new OracleParameter("name_bn", tbxTiepTanTenBN.Text));
cmdIn.Parameters.Add(new OracleParameter("add_bn", tbxTiepTanDiaChi.Text));
cmdIn.Parameters.Add(new OracleParameter("phone", tbxTiepTanDT.Text));
int t = (radioBtnTiepTanNam.Checked == true ? 1 : 0);
cmdIn.Parameters.Add(new OracleParameter("phai1", t.ToString()));
cmdIn.Parameters.Add(new OracleParameter("datens", dateTimePickerNgSinh.Value.ToString("MM-dd-yy")));
cmdIn.Parameters.Add(new OracleParameter("ic", tbxTiepTanCMND.Text));
cmdIn.Parameters.Add("idbn", OracleDbType.Varchar2, 1000).Direction = ParameterDirection.Output;
cmdIn.Parameters["idbn"].Size = 255;
int ret = cmdIn.ExecuteNonQuery();
txbDieuPhoiMaBN.Text = cmdIn.Parameters["idbn"].Value.ToString();
if (ret == -1)
{
MessageBox.Show("Them thanh cong!");
}
OracleDataProvider.DisConnect();
OracleDataProvider.conn.Open();
string sql = "select * from QLBV.BENHNHAN ORDER BY MABN DESC";
DataTable dt = OracleDataProvider.GetDataTable(sql);
dataGridViewTiepTanTTBN.DataSource = dt;
}
private void btnUserAlterOK_Click(object sender, EventArgs e)
{
OracleDataProvider.Connect(connect);
string sql = null;
if (cbxUserAlterRoleCu.Text != "")
{
sql = "revoke " + cbxUserAlterRoleCu.Text + " from " + cbxUserAlter.SelectedItem.ToString();
// sql += "; grant " + cbxUserAlterRoleMoi.SelectedItem.ToString() + " to " + cbxUserAlter.SelectedItem.ToString()+";";
OracleCommand cmd = new OracleCommand(sql, OracleDataProvider.conn);
int ret = cmd.ExecuteNonQuery();
}
cbxUserAlterRoleCu.Text = "";
//OracleDataProvider.conn.Open();
sql = "grant " + cbxUserAlterRoleMoi.SelectedItem.ToString() + " to " + cbxUserAlter.SelectedItem.ToString();
OracleCommand cmd1 = new OracleCommand(sql, OracleDataProvider.conn);
int ret1 = cmd1.ExecuteNonQuery();
OracleDataProvider.DisConnect();
}
private void btnAddRoleOK_Click(object sender, EventArgs e)
{
string role = "select role from dba_roles where common = " + "\'NO\' AND role = '" + txbAddRole.Text + "'";
OracleDataProvider.Connect(fLogin.cn);
DataTable dt = OracleDataProvider.GetDataTable(role);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Đã tồn tại rồi !");
}
else
{
OracleDataProvider.conn.Open();
String queryRevoke = "CREATE ROLE " + txbAddRole.Text;
OracleCommand cmdRevoke = new OracleCommand(queryRevoke, OracleDataProvider.conn);
int ret = cmdRevoke.ExecuteNonQuery();
if (ret == -1)
{
MessageBox.Show("Thêm Role thành công!");
}
}
OracleDataProvider.DisConnect();
}
private void btnUserDeleteOK_Click(object sender, EventArgs e)
{
string username = null;
if (cbxUserDelete.SelectedIndex != -1)
{
username = cbxUserDelete.SelectedItem.ToString();
}
OracleDataProvider.Connect(fLogin.cn);
string dlItem = "drop user " + username;
if (checkBoxUserDeleteCascade.Checked == true)
{
dlItem += " " + checkBoxUserDeleteCascade.Text;
}
OracleCommand cmd = new OracleCommand(dlItem, OracleDataProvider.conn);
int ret = cmd.ExecuteNonQuery();
if (ret == -1)
{
MessageBox.Show("Đã xóa user thành công!");
}
OracleDataProvider.DisConnect();
}
private void fQLChuyenMon_FormClosing(object sender, FormClosingEventArgs e)
{
OracleDataProvider.DisConnect();
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
username = txbUsername.Text;
password = txbPassword.Text;
string connect = OracleDataProvider.stringConnection("10.211.55.4", 1521, "orcl3", username, password);
try
{
OracleDataProvider.Connect(connect);
cn = connect;
if (username.Equals("QLBV"))
{
var frm = new fAdmin();
this.Hide();
frm.ShowDialog();
this.Show();
OracleDataProvider.DisConnect();
}
else
{
string sql = "select DISTINCT ROLE from role_tab_privs";
DataTable dt = OracleDataProvider.GetDataTable(sql);
if (dt.Rows[0][0].ToString().Equals("BV_BS"))
{
var frm = new fBacSi();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_TTDP"))
{
var frm = new fTiepTanDieuPhoi();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_NVKT"))
{
var frm = new fKeToan();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_QLCM"))
{
var frm = new fQLChuyenMon();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_KTV"))
{
var frm = new fKyThuatVien();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_QLTV"))
{
var frm = new fQLTaiVu();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_QLTNNS"))
{
var frm = new fQLTaiNguyenNhanSu();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_NVTV"))
{
var frm = new fTaiVu();
this.Hide();
frm.ShowDialog();
this.Show();
}
if (dt.Rows[0][0].ToString().Equals("BV_NVBT"))
{
var frm = new fBanThuoc();
this.Hide();
frm.ShowDialog();
this.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//if (txbUsername.Text == "admin" && txbPassword.Text == "admin")
//{
// fAdmin f = new fAdmin();
// this.Hide();
// f.ShowDialog();
// this.Show();
//}
//else
//{
// MessageBox.Show("Sai mật khẩu hoặc password !", "Login error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
}