public void ThemNVThongKe(eNVThongKe nvMoi) { NVThongKes temp = new NVThongKes(); temp.MaNhanVien = nvMoi.MaNhanVien; temp.NgayLamViec = nvMoi.NgayLamViec; qt.NVThongKes.InsertOnSubmit(temp); qt.SubmitChanges(); }
public List <eNVThongKe> LayThongTinNhanVienThongKe() { var dsNVThongKe = qt.NVThongKes .Join(qt.NhanViens, tk => tk.MaNhanVien, nv => nv.MaNhanVien, (tk, nv) => new { tk, nv }).ToList(); List <eNVThongKe> dsnvtk = new List <eNVThongKe>(); foreach (var item in dsNVThongKe) { eNVThongKe nv = new eNVThongKe(); nv.MaNhanVien = item.tk.MaNhanVien; nv.TenNhanVien = item.nv.TenNhanVien; nv.GioiTinh = item.nv.GioiTinh; nv.SDT = item.nv.SDT; nv.DiaChi = item.nv.DiaChi; nv.Email = item.nv.Email; nv.NgayLamViec = item.tk.NgayLamViec; nv.TinhTrang = item.nv.TinhTrang; dsnvtk.Add(nv); } return(dsnvtk); }
private void btnLuu_Click(object sender, EventArgs e) { try { CheckTxt(); if (isThem == true) { eNhanVien newNV = new eNhanVien(); eNVBanThuoc newNVBT = new eNVBanThuoc(); eNVThongKe newNVTK = new eNVThongKe(); newNV.MaNhanVien = txtMaNhanVien.Text; newNV.TenNhanVien = txtTenNhanVien.Text; newNV.SDT = txtSoDienThoai.Text; newNV.Email = txtEmail.Text; newNV.DiaChi = cbbThanhPho.Text; if (rdNam.Checked == true) { newNV.GioiTinh = "nam"; } else { newNV.GioiTinh = "nu"; } if (cbTinhTrang1.Checked == true) { newNV.TinhTrang = 1; } else { newNV.TinhTrang = 0; } nhanvienBLL.ThemNhanVien(newNV); if (cboLoaiNhanVien.SelectedIndex == 0)//Neu chon loai nhan vien la nhan vien ban thuoc { newNVBT.MaNhanVien = txtMaNhanVien.Text; newNVBT.CaLamViec = cboCaLamViec.Text; newNVBT.NgayLamViec = dtpNgay.Value; nhanvienBLL.ThemNVBanThuoc(newNVBT); tabpageQLNV.Enabled = true; tabpageQLNV.SelectedIndex = 0; } else { newNVTK.MaNhanVien = txtMaNhanVien.Text; newNVTK.NgayLamViec = dtpNgay.Value; nhanvienBLL.ThemNVThongKe(newNVTK); tabpageQLNV.Enabled = true; tabpageQLNV.SelectedIndex = 1; } MessageBox.Show("Them thanh cong"); EnableControl(false); isThem = false; btnThem.Text = "Them"; btnThem.BackColor = Color.DodgerBlue; btnSua.Enabled = true; btnLuu.Enabled = false; HienThiThongTinNhanVien(); } else { string mnv = txtMaNhanVien.Text; string tnv = txtTenNhanVien.Text; string sdt = txtSoDienThoai.Text; string email = txtEmail.Text; string dc = cbbThanhPho.Text; string gt; int tt; if (rdNam.Checked == true) { gt = "nam"; } else { gt = "nu"; } if (cbTinhTrang1.Checked == true) { tt = 1; } else { tt = 0; } nhanvienBLL.CapNhatThongTinNhanVien(mnv, tnv, gt, sdt, dc, email, tt); if (tabpageQLNV.SelectedIndex == 0) { string mnvBT, caLamViec; DateTime ngayLamViec; if (cboLoaiNhanVien.SelectedIndex == 0) { mnvBT = txtMaNhanVien.Text; caLamViec = cboCaLamViec.Text; ngayLamViec = dtpNgay.Value; nhanvienBLL.CapNhatThongTinNVBT(mnvBT, ngayLamViec, caLamViec); MessageBox.Show("Cap Nhat Thanh Cong"); EnableControl(false); isSua = false; btnSua.Text = "Sua"; btnSua.BackColor = Color.LimeGreen; btnThem.Enabled = true; btnLuu.Enabled = false; HienThiThongTinNhanVien(); tabpageQLNV.Enabled = true; } else { eNVThongKe newNVTK = new eNVThongKe(); mnvBT = newNVTK.MaNhanVien = txtMaNhanVien.Text; newNVTK.NgayLamViec = dtpNgay.Value; nhanvienBLL.XoaThongTinNVBT(mnvBT); nhanvienBLL.ThemNVThongKe(newNVTK); MessageBox.Show("Cap Nhat Thanh Cong"); EnableControl(false); isSua = false; btnSua.Text = "Sua"; btnSua.BackColor = Color.LimeGreen; btnThem.Enabled = true; btnLuu.Enabled = false; HienThiThongTinNhanVien(); tabpageQLNV.Enabled = true; } } else { string mnvTK, caLamViec; DateTime ngayLamViec; if (cboLoaiNhanVien.SelectedIndex == 1) { mnvTK = txtMaNhanVien.Text; ngayLamViec = dtpNgay.Value; nhanvienBLL.CapNhatThongTinNVTK(mnvTK, ngayLamViec); MessageBox.Show("Cap Nhat Thanh Cong"); EnableControl(false); isSua = false; btnSua.Text = "Sua"; btnSua.BackColor = Color.LimeGreen; btnThem.Enabled = true; btnLuu.Enabled = false; HienThiThongTinNhanVien(); tabpageQLNV.Enabled = true; } else { eNVBanThuoc newNVBT = new eNVBanThuoc(); mnvTK = newNVBT.MaNhanVien = txtMaNhanVien.Text; ngayLamViec = dtpNgay.Value; caLamViec = cboCaLamViec.Text; nhanvienBLL.XoaThongTinNVTK(mnvTK); nhanvienBLL.ThemNVBanThuoc(newNVBT); MessageBox.Show("Cap Nhat Thanh Cong"); EnableControl(false); isSua = false; btnSua.Text = "Sua"; btnSua.BackColor = Color.LimeGreen; btnThem.Enabled = true; btnLuu.Enabled = false; HienThiThongTinNhanVien(); tabpageQLNV.Enabled = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }