private void frmHopDong_Load(object sender, EventArgs e)
{
BindingSource soureTB = new BindingSource();
soureTB.DataSource = ConnectDatabase.getAllHopDong();
dgvHienThi.DataSource = soureTB;
}
private void btnDN_Click(object sender, EventArgs e)
{
try
{
// conn.Open();
string tk = txtDanhNhap.Text;
string mk = txtMatKhau.Text;
if (ConnectDatabase.Login(tk, mk))
{
MessageBox.Show("Đăng nhập thành công", "Thông báo", MessageBoxButtons.OK);
this.Hide();
Program.usernamelogin = tk;
Program.frMain_main = new frmMain();
Program.frMain_main.Show();
}
else
{
MessageBox.Show("Đăng nhập không thành công");
}
}
catch (Exception)
{
MessageBox.Show("Đăng nhập lỗi");
}
}
private void btnThemCV_Click(object sender, EventArgs e)
{
PhanCong_ViTri temp = new PhanCong_ViTri(txtMaNV.Text, txtMaVT.Text);
ConnectDatabase.SuaViTri_NhanVien(temp);
dgvPCVT.DataSource = ConnectDatabase.PhanCongViTri();
}
private void btnThemNV_Click(object sender, EventArgs e)
{
NhanVien temp = new NhanVien(txtMaNV.Text, txtTenNV.Text, txtBangCap.Text, txtGT.Text, dateNS.Value, txtDC.Text, txtMaPB.Text, txtCMT.Text, txtSDT.Text, txtDT.Text, txtTG.Text);
ConnectDatabase.ThemNhanVien(temp);
dgvThemNV.DataSource = ConnectDatabase.getAllNhanVien();
}
private void btnThemPB_Click(object sender, EventArgs e)
{
//try
//{
// if (!db.KiemTra(txtMaPB.Text, "select MaPB from PhongBan"))
// {
// PhongBan temp = new PhongBan(txtMaPB.Text, txtTenPB.Text, txtDiaChi.Text, txtmaTP.Text, txtTenTp.Text);
// ConnectDatabase.ThemPhongBan(temp);
// load();
// }
// else
// {
// MessageBox.Show("Mã phòng này đã tòn tại bạn có thể thử mã phòng khác", "Trùng mã phòng", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// }
//}
//catch
//{
// MessageBox.Show("Dữ liệu đầu vào không đúng");
//}
PhongBan temp = new PhongBan(txtMaPB.Text, txtTenPB.Text, txtDiaChi.Text, txtmaTP.Text, txtTenTp.Text);
ConnectDatabase.ThemPhongBan(temp);
load();
}
private void btnThuong_Click(object sender, EventArgs e)
{
Luong temp = new Luong(txtMaNV.Text, txtLuong.Text, txtLuongThuong.Text, txtGhichu.Text, txtSNTC.Text, txtTongLuong.Text);
ConnectDatabase.SuaLuong_NV(temp);
dgvLuong_pb.DataSource = ConnectDatabase.GetAllLuong_NV();
}
private void chenBang()
{
BindingSource soureTB = new BindingSource();
soureTB.DataSource = ConnectDatabase.getAllNhanVien();
dgwTotal.DataSource = soureTB;
}
private void btnSuaPB_Click(object sender, EventArgs e)
{
PhongBan temp = new PhongBan(txtMPB.Text, txtTenPB.Text, txtdiadiem.Text, txtmaTP.Text, txtTenTP.Text);
ConnectDatabase.SuaPhongBan(temp);
dgvPhongBan.DataSource = ConnectDatabase.getAllPhongBan();
}
private void btnSuaCV_Click(object sender, EventArgs e)
{
ChucVu temp = new ChucVu(txtMaCV.Text, txtTenCV.Text);
ConnectDatabase.SuaChucVu(temp);
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
}
private void btnXoaCV_Click(object sender, EventArgs e)
{
ViTri temp = new ViTri(txtMaVT.Text, txtTenVT.Text);
ConnectDatabase.XoaViTri(temp);
dgvVT.DataSource = ConnectDatabase.getAllViTri();
}
private void chenBang()
{
BindingSource soureTB = new BindingSource();
soureTB.DataSource = ConnectDatabase.DSNV();
dgwTotal.DataSource = soureTB;
}
private void frmPhanCong_ViTri_Load(object sender, EventArgs e)
{
this.txtTenVT.Enabled = false;
this.txtTenNV.Enabled = false;
this.dgvPCVT.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvPCVT.DataSource = ConnectDatabase.PhanCongViTri();
}
private void btnXoa_Click(object sender, EventArgs e)
{
NhanVien temp = new NhanVien(txtMaNV.Text, txtTenNV.Text, txtBangCap.Text, txtGT.Text, dateNS.Value, txtDC.Text, txtMaPB.Text, txtCMT.Text, txtSDT.Text, txtDT.Text, txtTG.Text);
ConnectDatabase.XoaNhanVien(temp);
dgvNhanVien.DataSource = ConnectDatabase.getAllNhanVien();
MessageBox.Show("Xóa nhân viên thành công!!");
}
private void btnXoaPB_Click(object sender, EventArgs e)
{
PhongBan temp = new PhongBan(txtMPB.Text, txtTenPB.Text, txtdiadiem.Text, txtmaTP.Text, txtTenTP.Text);
ConnectDatabase.XoaPhongBan(temp);
dgvPhongBan.DataSource = ConnectDatabase.getAllPhongBan();
MessageBox.Show("Xóa Phòng Ban Thành Công!!!");
}
private void btnThemCV_Click_2(object sender, EventArgs e)
{
ChucVu temp = new ChucVu(txtMCV.Text, txtTCV.Text);
ConnectDatabase.ThemChucVu(temp);
dgvThemCV.DataSource = ConnectDatabase.getAllChucVu();
}
private void btnXoaCV_Click(object sender, EventArgs e)
{
ChucVu temp = new ChucVu(txtMaCV.Text, txtTenCV.Text);
ConnectDatabase.XoaChucVu(temp);
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
MessageBox.Show("Xóa Thành Công Chức Vụ!!!");
}
private void btnSuaCV_Click(object sender, EventArgs e)
{
ChucVu temp = new ChucVu(txtTenCV.Text, txtMaCV.Text);
ConnectDatabase.SuaChucVu(temp);
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
MessageBox.Show("Sửa chức vụ thành công!!");
}
private void btnThemCV_Click(object sender, EventArgs e)
{
ViTri temp = new ViTri(txtMaVT.Text, txtTenVT.Text);
if (ConnectDatabase.checkViTri(temp.Mavt) == 1)
{
MessageBox.Show("Mã vị trí đã tồn tại. Xin mời nhập mã khác!!!");
return;
}
ConnectDatabase.ThemViTri(temp);
dgvVT.DataSource = ConnectDatabase.getAllViTri();
}
private void btnThemCV_Click_2(object sender, EventArgs e)
{
ChucVu temp = new ChucVu(txtMCV.Text, txtTCV.Text);
if (ConnectDatabase.checkPhongBan(temp.Macv) == 1)
{
MessageBox.Show("Mã chức vụ đã tồn tại. Xin mời nhập lại!!!");
return;
}
ConnectDatabase.ThemChucVu(temp);
dgvThemCV.DataSource = ConnectDatabase.getAllChucVu();
load();
}
private void btnThemNV_Click(object sender, EventArgs e)
{
NhanVien temp = new NhanVien(txtMaNV.Text, txtTenNV.Text, txtBangCap.Text, txtGT.Text, dateNS.Value, txtDC.Text, txtMaPB.Text, txtCMT.Text, txtSDT.Text, txtDT.Text, txtTG.Text);
{
if (ConnectDatabase.checkNhanVien(temp.Manv) == 1)
{
MessageBox.Show("Mã nhân viên đã tồn tại. Xin mời nhập lại!!!");
return;
}
ConnectDatabase.ThemNhanVien(temp);
dgvThemNV.DataSource = ConnectDatabase.getAllNhanVien();
load();
}
}
private void btnThemPB_Click(object sender, EventArgs e)
{
PhongBan temp = new PhongBan(txtMaPB.Text, txtTenPB.Text, txtDiaChi.Text, txtmaTP.Text, txtTenTp.Text);
{
if (ConnectDatabase.checkPhongBan(temp.Mapb) == 1)
{
MessageBox.Show("Mã phòng ban đã tồn tại. Xin mời nhập lại!!!");
return;
}
ConnectDatabase.ThemPhongBan(temp);
dgvThemPB.DataSource = ConnectDatabase.getAllPhongBan();
load();
}
}
static void Main()
{
ConnectDatabase.ConnectDB();
// Application.Run(new HSNV());
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new FormDangNhap());
// Application.Run(new frmChucVu());
//Application.Run(new FrmDanhMuc());
// Application.Run(new frmThemPB());
// Application.Run(new frmPhongBan());
//Application.Run(new frmLuong_CaNhan());
//Application.Run(new frmHopDong());
//Application.Run(new frmLuong_PB());
// Application.Run(new frmNhanVien());
// Application.Run(new frmMain());
}
private void btnLuu_Click_1(object sender, EventArgs e)
{
status.ForeColor = Color.Red;
if (ConnectDatabase.Login(txtTenDN.Text, txtmatkhaucu.Text) == false)
{
status.Text = "Sai mật khẩu!!";
return;
}
if (txtmatkhaumoi.Text != txtnhaplaimatkhaumoi.Text)
{
status.Text = "Mật khẩu nhập lại không trùng khớp !!";
return;
}
ConnectDatabase.thayDoiMatKhau(txtTenDN.Text, txtmatkhaumoi.Text);
status.ForeColor = Color.Blue;
status.Text = "Đã đổi mật khẩu!";
}
private void tbnSua_Click(object sender, EventArgs e)
{
if (btnTV.Enabled == false)
{
this.tbnThem.Enabled = false;
this.tbnXoa.Enabled = false;
this.tbnGiaHan.Enabled = false;
enableInput();
btnTV.Enabled = true;
txtMaHD.ReadOnly = true;
}
else
{
HopDong temp = new HopDong(txtMaHD.Text, txtTenHD.Text, txtMaNV.Text, dateBD.Value, dateKT.Value);
ConnectDatabase.SuaHopDong(temp);
dgvHienThi.DataSource = ConnectDatabase.getAllHopDong();
}
}
private void tbnXoa_Click(object sender, EventArgs e)
{
if (btnTV.Enabled == false)
{
this.tbnThem.Enabled = false;
this.tbnSua.Enabled = false;
this.tbnGiaHan.Enabled = false;
//enableInput();
disableInput();
btnTV.Enabled = true;
//txtMaHD.ReadOnly = true;
}
else
{
HopDong temp = new HopDong(txtMaHD.Text, txtTenHD.Text, txtMaNV.Text, dateBD.Value, dateKT.Value);
ConnectDatabase.XoaHopDong(temp);
MessageBox.Show("Xóa hợp đồng thành công!!");
dgvHienThi.DataSource = ConnectDatabase.getAllHopDong();
}
}
private void dgvCV_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
this.dgvCV.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
}
private void frmChucVu_Load(object sender, EventArgs e)
{
this.dgvCV.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
}
private void btnHienThi_Click(object sender, EventArgs e)
{
dgvCV.DataSource = ConnectDatabase.getAllChucVu();
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
dgvCV.DataSource = ConnectDatabase.TimKiemChucVu(txtTimKiem.Text);
}
private void btnHienThi_Click(object sender, EventArgs e)
{
dgvThemNV.DataSource = ConnectDatabase.getAllNhanVien();
}
