public void ThemNVBanThuoc(eNVBanThuoc nvMoi)
{
NVBanThuocs temp = new NVBanThuocs();
temp.MaNhanVien = nvMoi.MaNhanVien;
temp.NgayLamViec = nvMoi.NgayLamViec;
temp.CaLamViec = nvMoi.CaLamViec;
qt.NVBanThuocs.InsertOnSubmit(temp);
qt.SubmitChanges();
}
public List <eNVBanThuoc> LayThongTinNhanVienBanThuoc()
{
var dsNVBanThuoc = qt.NVBanThuocs
.Join(qt.NhanViens, bt => bt.MaNhanVien, nv => nv.MaNhanVien, (bt, nv) => new { bt, nv }).ToList();
List <eNVBanThuoc> dsnvbt = new List <eNVBanThuoc>();
foreach (var item in dsNVBanThuoc)
{
eNVBanThuoc nv = new eNVBanThuoc();
nv.MaNhanVien = item.bt.MaNhanVien;
nv.TenNhanVien = item.nv.TenNhanVien;
nv.SDT = item.nv.SDT;
nv.DiaChi = item.nv.DiaChi;
nv.Email = item.nv.Email;
nv.CaLamViec = item.bt.CaLamViec;
nv.GioiTinh = item.nv.GioiTinh;
nv.NgayLamViec = item.bt.NgayLamViec;
nv.TinhTrang = item.nv.TinhTrang;
dsnvbt.Add(nv);
}
return(dsnvbt);
}
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);
}
}
