//Xóa thông tin cá nhân private void btnXoa_Click(object sender, EventArgs e) { TTCaNhanDTO ttCaNhan = new TTCaNhanDTO(); ttCaNhan._MaNV = Convert.ToInt32(txtMaNV.Text); ttCaNhan._HoTen = txtHoTen.Text; ttCaNhan._GioiTinh = comboBox_GioiTinh.Text; ttCaNhan._HocVan = comboBoxHocVan.Text; ttCaNhan._HocHam = comboBoxHocHam.Text; ttCaNhan._GhiChu = txtGhiChu.Text; ttCaNhan._QueQuan = txtQueQuan.Text; ttCaNhan._DanToc = txtDanToc.Text; ttCaNhan._SoCMND = Convert.ToInt32(txtCMND.Text); ttCaNhan._SĐT = Convert.ToInt32(txtSDT.Text); ttCaNhan._TonGiao = txtTonGiao.Text; ttCaNhan._TTHonNhan = txtTTHonNhan.Text; ttCaNhan._NoiCap = txtNoiCap.Text; ttCaNhan._NgaySinh = Convert.ToDateTime(dateTimePicker_NgaySinh.Text); ttCaNhan._NgayCap = Convert.ToDateTime(dateTimePicker_NgayCap.Text); if (MessageBox.Show("Bạn có muốn xóa không", "Xóa dữ liệu", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { string delete = tTCaNhanBLL.DeleteTTCaNhan(ttCaNhan); kn.thucthiketnoi(delete); dataGridView_TTCaNhan.Refresh(); dataGridView_TTCaNhan.DataSource = tTCaNhanBLL.getAllTTCaNhan(); dataGridView_TTCaNhan.Show(); MessageBox.Show("Xóa thành công"); } }
//Sửa thông tin cá nhân private void btnSua_Click(object sender, EventArgs e) { TTCaNhanDTO ttCaNhan = new TTCaNhanDTO(); try { ttCaNhan._MaNV = Convert.ToInt32(txtMaNV.Text); ttCaNhan._HoTen = txtHoTen.Text; ttCaNhan._GioiTinh = comboBox_GioiTinh.Text; ttCaNhan._HocVan = comboBoxHocVan.Text; ttCaNhan._HocHam = comboBoxHocHam.Text; ttCaNhan._GhiChu = txtGhiChu.Text; ttCaNhan._QueQuan = txtQueQuan.Text; ttCaNhan._DanToc = txtDanToc.Text; ttCaNhan._SoCMND = Convert.ToInt32(txtCMND.Text); ttCaNhan._SĐT = Convert.ToInt32(txtSDT.Text); ttCaNhan._TonGiao = txtTonGiao.Text; ttCaNhan._TTHonNhan = txtTTHonNhan.Text; ttCaNhan._NoiCap = txtNoiCap.Text; ttCaNhan._NgaySinh = Convert.ToDateTime(dateTimePicker_NgaySinh.Text); ttCaNhan._NgayCap = Convert.ToDateTime(dateTimePicker_NgayCap.Text); string update = tTCaNhanBLL.UpdateTTCaNhan(ttCaNhan); kn.thucthiketnoi(update); dataGridView_TTCaNhan.Refresh(); dataGridView_TTCaNhan.DataSource = tTCaNhanBLL.getAllTTCaNhan(); dataGridView_TTCaNhan.Show(); MessageBox.Show("Sửa thành công"); } catch { MessageBox.Show("Dữ liệu đầu vào không đúng"); } }
///-------------------------------------SỦA //Sửa thông tin cá nhân public string UpdateTTCaNhan(TTCaNhanDTO ttCaNhan) { string Query = "Update TTCaNhan set HoTen=N'" + ttCaNhan._HoTen + "', NgaySinh='" + ttCaNhan._NgaySinh.ToShortDateString() + "'," + "GioiTinh= N'" + ttCaNhan._GioiTinh + "', QueQuan= N'" + ttCaNhan._QueQuan + "',TTHonNhan=N'" + ttCaNhan._TTHonNhan + "',SoCMND='" + ttCaNhan._SoCMND + "'," + "NgayCap='" + ttCaNhan._NgayCap.ToShortDateString() + "',NoiCap=N'" + ttCaNhan._NoiCap + "',SĐT='" + ttCaNhan._SĐT + "',DanToc=N'" + ttCaNhan._DanToc + "',TonGiao=N'" + ttCaNhan._TonGiao + "'," + "HocVan=N'" + ttCaNhan._HocVan + "',HocHam=N'" + ttCaNhan._HocHam + "',GhiChu=N'" + ttCaNhan._GhiChu + "' where MaNV='" + ttCaNhan._MaNV + "'"; return(Query); }
///-------------------------------------THÊM //Thêm Thông tin cá nhân public string InsertTTCaNhan(TTCaNhanDTO ttCaNhan) { string Query = "Insert into TTCaNhan(MaNV, HoTen, NgaySinh,GioiTinh,QueQuan,TTHonNhan,SoCMND, NgayCap,NoiCap,SĐT, DanToc, TonGiao, HocVan, HocHam,GhiChu) " + "values('" + ttCaNhan._MaNV + "', N'" + ttCaNhan._HoTen + "', '" + ttCaNhan._NgaySinh + "'" + ",N'" + ttCaNhan._GioiTinh + "',N'" + ttCaNhan._QueQuan + "',N'" + ttCaNhan._TTHonNhan + "'" + ",'" + ttCaNhan._SoCMND + "','" + ttCaNhan._NgayCap + "',N'" + ttCaNhan._NoiCap + "','" + ttCaNhan._SĐT + "',N'" + ttCaNhan._DanToc + "'" + ",N'" + ttCaNhan._TonGiao + "',N'" + ttCaNhan._HocVan + "',N'" + ttCaNhan._HocHam + "',N'" + ttCaNhan._GhiChu + "')"; return(Query); }
//Thêm thông tin cá nhân private void buttonThem_Click(object sender, EventArgs e) { try { TTCaNhanDTO ttCaNhan = new TTCaNhanDTO(); ttCaNhan._MaNV = Convert.ToInt32(txtMaNV.Text); ttCaNhan._HoTen = txtHoTen.Text; ttCaNhan._QueQuan = txtQueQuan.Text; ttCaNhan._SoCMND = Convert.ToInt32(txtCMND.Text); ttCaNhan._SĐT = Convert.ToInt32(txtSDT.Text); ttCaNhan._TonGiao = txtTonGiao.Text; ttCaNhan._TTHonNhan = txtTTHonNhan.Text; ttCaNhan._NoiCap = txtNoiCap.Text; ttCaNhan._NgaySinh = Convert.ToDateTime(dateTimePicker_NgaySinh.Text); ttCaNhan._NgayCap = Convert.ToDateTime(dateTimePicker_NgayCap.Text); ttCaNhan._GioiTinh = comboBox_GioiTinh.Text; ttCaNhan._HocHam = comboBoxHocHam.Text; ttCaNhan._HocVan = comboBoxHocVan.Text; ttCaNhan._GhiChu = txtGhiChu.Text; ttCaNhan._DanToc = txtDanToc.Text; if (txtMaNV.Text != "" && txtHoTen.Text != "" && txtQueQuan.Text != "" && txtCMND.Text != "" && txtSDT.Text != "" && txtTonGiao.Text != "" && txtTTHonNhan.Text != "" && txtNoiCap.Text != "" && dateTimePicker_NgaySinh.Text != "" && dateTimePicker_NgayCap.Text != "") { string check = tTCaNhanBLL.InsertTTCaNhan(ttCaNhan); // string check = ttCaNhan.InsertPB(phongBanDTO); kn.thucthiketnoi(check); dataGridView_TTCaNhan.Refresh(); dataGridView_TTCaNhan.DataSource = tTCaNhanBLL.getAllTTCaNhan(); dataGridView_TTCaNhan.Show(); MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Các trường không được để trống"); } } catch (Exception ex) { MessageBox.Show("Thêm bị lỗi ! " + ex.Message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
//Xóa public string DeleteTTCaNhan(TTCaNhanDTO ttcanhan) { return(tt.DeleteTTCaNhan(ttcanhan)); }
//Sửa public string UpdateTTCaNhan(TTCaNhanDTO ttCaNhan) { return(tt.UpdateTTCaNhan(ttCaNhan)); }
//Thêm public string InsertTTCaNhan(TTCaNhanDTO ttCaNhan) { return(tt.InsertTTCaNhan(ttCaNhan)); }
///-------------------------------------XÓA //Xóa phòng thông tin cá nhân public string DeleteTTCaNhan(TTCaNhanDTO ttcanhan) { string Query = "delete TTCaNhan where MaNV='" + ttcanhan._MaNV + "'"; return(Query); }