void loadListNV()
{
loadALLNhanVien();
img = new ImageList();
lstvNhanVien.View = View.LargeIcon;
lstvNhanVien.LargeImageList = img;
img.ImageSize = new Size(120, 120);
img.ColorDepth = ColorDepth.Depth32Bit;
foreach (DataRow row in ds.Tables["NhanVien"].Rows)
{
ClassNhanVien nhanvien = new ClassNhanVien()
{
MaNV = row[0].ToString(), HoTen = row[3].ToString(), ChucVu = row[1].ToString(), GioiTinh = row[4].ToString(), Hinh = row[2].ToString(), LuongCB = decimal.Parse(row[8].ToString()), NgaySinh = row[5].ToString(), SDT = row[7].ToString(), NgayVaoLam = row[6].ToString()
};
//string ha = row[2].ToString();
dsnhanvien.Add(nhanvien);
string dgdan = @"..\\..\\Hinh\\NhanVien\\" + nhanvien.Hinh;
ListViewItem item = new ListViewItem();
item.Text = nhanvien.HoTen;
item.ImageIndex = img.Images.Add(Image.FromFile(dgdan), Color.Transparent);
item.Name = nhanvien.MaNV;
lstvNhanVien.Items.Add(item);
}
}
private void lstvNhanVien_Click_1(object sender, EventArgs e)
{
loadALLNhanVien();
string ma = lstvNhanVien.SelectedItems[0].Name;
ClassNhanVien nhanvienDuocChon = dsnhanvien.Single(m => m.MaNV == ma);
txt_MaNV.Text = nhanvienDuocChon.MaNV;
txt_LuongCB.Text = nhanvienDuocChon.LuongCB.ToString();
maskedtxt_NgaySinh.Text = nhanvienDuocChon.NgaySinh;
maskedTxt_NgayVaoLam.Text = nhanvienDuocChon.NgayVaoLam;
txt_SDT.Text = nhanvienDuocChon.SDT;
txt_TenNV.Text = nhanvienDuocChon.HoTen;
if (nhanvienDuocChon.GioiTinh == "Nam")
{
rdoBT_Nam.Checked = true;
rdoBT_Nu.Checked = false;
}
else
{
rdoBT_Nam.Checked = false;
rdoBT_Nu.Checked = true;
}
if (nhanvienDuocChon.ChucVu == "Quản lí")
{
cbo_ChucVu.SelectedIndex = 1;
}
else
{
cbo_ChucVu.SelectedIndex = 0;
}
picNV.Image = Image.FromFile("..\\..\\Hinh\\NhanVien\\" + nhanvienDuocChon.Hinh);
}
private void addbtn_Click(object sender, EventArgs e)
{
bool check = false;
if (KiemTraErr(check) == true)
{
return;
}
ClassNhanVien nvien = NhanVienController.GetNV(this.cbbManv.Text.Trim());
foreach (var cvg in nvien.listCVLam.ToList())
{
nvien.listCVLam.Remove(cvg);
}
foreach (var cvx in nvien.listCVXong.ToList())
{
nvien.listCVXong.Remove(cvx);
}
string displaycvGiao = "";
string displaycvHoanThanh = "";
for (int i = 0; i < listBoxG.Items.Count; i++)
{
displaycvGiao = displaycvGiao + this.listBoxG.Items + " ";
ClassCongViec cv = CongViecController.GetCV(this.listBoxG.Items[i].ToString());
nvien.listCVLam.Add(cv);
//nvien.MaDA = cv.listDA.ToList()[0].ToString() + " " + nvien.MaDA;
}
for (int j = 0; j < listBoxX.Items.Count; j++)
{
displaycvHoanThanh = displaycvHoanThanh + this.listBoxX.Items + " ";
nvien.listCVXong.Add(CongViecController.GetCV(this.listBoxX.Items[j].ToString()));
}
string mada = "";
foreach (var i in this.checkedListBox1.CheckedItems)
{
mada = mada + i.ToString() + " ";
}
nvien.MaDA = mada;
if (NhanVienController.UpdateNvien(nvien) == false)
{
MessageBox.Show("Loi them cong viec", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
ClearControls();
}
public void AddRows(DataGridView dgvHangHoa, DataGridViewComboBoxCell comboBoxCell)
{
dgvHangHoa.DataSource = null;
ClassNhanVien NVNew2 = new ClassNhanVien();
lstNhanVien.Add(NVNew2);
dgvHangHoa.DataSource = lstNhanVien;
comboBoxCell.DataSource = lstChucVu;
}
public static bool UpdateNvien(ClassNhanVien nvien)
{
try
{
using (var _context = new DBManageContext())
{
var dbnv = (from nv in _context.tbNhanVien.Include("listCVLam").Include("listCVXong")
where nv.MaNV == nvien.MaNV
select nv).Single();
foreach (var cvgiao in dbnv.listCVLam.ToList())
{
dbnv.listCVLam.Remove(cvgiao);
}
foreach (var cvxong in dbnv.listCVXong.ToList())
{
dbnv.listCVXong.Remove(cvxong);
}
foreach (var permistask in nvien.listCVLam)
{
var dbcv = (from cv in _context.tbCongViec
where cv.MaCV == permistask.MaCV
select cv).Single();
dbnv.listCVLam.Add(dbcv);
}
foreach (var finistask in nvien.listCVXong)
{
var dbcv = (from cv in _context.tbCongViec
where cv.MaCV == finistask.MaCV
select cv).Single();
dbnv.listCVXong.Add(dbcv);
}
dbnv.TienDo = dbnv.listCVXong.Count.ToString() + '/' + dbnv.listCVLam.Count.ToString();
dbnv.Luong = 1000000 * dbnv.listCVXong.Count;
dbnv.MaDA = nvien.MaDA;
_context.tbNhanVien.AddOrUpdate(dbnv);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public static bool AddNV(ClassNhanVien nv)
{
try
{
using (var _context = new DBManageContext())
{
_context.tbNhanVien.Add(nv);
_context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
private void addbtn_Click(object sender, EventArgs e)
{
//kiem man nhan vien da ton tai chua
if (NhanVienController.GetNV(this.txtmanv.Text.Trim()) != null)
{
return;
}
bool check = false;
if (KiemTraErr(check) == true)
{
return;
}
ClassNhanVien nv = new ClassNhanVien();
nv.MaNV = this.txtmanv.Text.Trim();
nv.TenNV = this.txtTenNv.Text.Trim();
if (this.checkFemale.Checked == true)
{
nv.GioiTinh = "Nu";
}
else
{
nv.GioiTinh = "Nam";
}
nv.SDT = this.txtsdt.Text.Trim();
nv.NgaySinh = this.Ngaysinhpicker.Value;
nv.MaChucVu = this.cbbChucVu.Text.Trim();
nv.Email = this.txtemail.Text.Trim();
nv.DiaChi = this.txtDiachi.Text.Trim();
//add xuong csdl
if (NhanVienController.AddNV(nv) == false)
{
MessageBox.Show("Loi khi them nhan vien", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ClearControls();
ShowData();
}
private void editbtn_Click(object sender, EventArgs e)
{
bool check = false;
if (KiemTraErr(check) == true)
{
return;
}
ClassNhanVien nv = new ClassNhanVien();
nv.MaNV = this.txtmanv.Text.Trim();
nv.TenNV = this.txtTenNv.Text.Trim();
if (this.checkFemale.Checked == true)
{
nv.GioiTinh = "Nu";
}
else
{
nv.GioiTinh = "Nam";
}
nv.SDT = this.txtsdt.Text.Trim();
nv.NgaySinh = this.Ngaysinhpicker.Value;
nv.MaChucVu = this.cbbChucVu.Text.Trim();
nv.Email = this.txtemail.Text.Trim();
nv.DiaChi = this.txtDiachi.Text.Trim();
if (NhanVienController.UpdateNV(nv) == false)
{
MessageBox.Show("Loi khi sua nhan vien", "Loi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ShowData();
ClearControls();
}
