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