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