public bool Create(NhanVien nv) { try { var them = new NhanVien { MaNV = nv.MaNV, MaChucVu = nv.MaChucVu, MaDonVi = nv.MaDonVi, HoTen = nv.HoTen, DanToc = nv.DanToc, GioiTinh = nv.GioiTinh, DiaChi = nv.DiaChi, HinhAnh = nv.HinhAnh, NgayBatDau = nv.NgayBatDau, NgayHuu = nv.NgayHuu, NgayNghi = nv.NgayNghi, NgaySinh = nv.NgaySinh, MaNgach = nv.MaNgach, CMND = nv.CMND }; db.NhanViens.Add(them); db.SaveChanges(); return(true); } catch (Exception ex) { Console.WriteLine("Lỗi: " + ex); return(false); } }
public bool suachuyenbac(LichSuChuyenBac lichsuchuyenbac) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { LichSuChuyenBac ls = csdl.LichSuChuyenBacs.SingleOrDefault(n => n.id == lichsuchuyenbac.id ); ls.MaHeSo = lichsuchuyenbac.MaHeSo; ls.NgayChuyen = lichsuchuyenbac.NgayChuyen; csdl.SaveChanges(); var nhanvien = from p in csdl.NhanViens where p.MaNV == lichsuchuyenbac.MaNV select p; foreach (NhanVien nv in nhanvien) { nv.MaHeSo = lichsuchuyenbac.MaHeSo; nv.MaNgach = lichsuchuyenbac.Mangach; } csdl.SaveChanges(); } catch { return false; } return true; }
//Thêm LS công tác public bool ThemLSCongTac(LichSuCongTac lsct) { try { entity.LichSuCongTacs.Add(lsct); entity.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
//Thêm ngạch lương public bool ThemNgachLuong(NgachLuong ngach) { try { entity.NgachLuongs.Add(ngach); entity.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
//Thêm hệ số lương public bool ThemHeSoLuong(HeSoLuongPhuCap heSo) { try { entity.HeSoLuongPhuCaps.Add(heSo); entity.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
private void btSua_Click(object sender, EventArgs e) { QuanLyLuongEntities db = new QuanLyLuongEntities(); string macv = dataGridView1.CurrentRow.Cells[1].Value.ToString(); if (suaten.Text != "" && suahs.Text != "") { _chucvu.MaChucVu = macv; _chucvu.TenChucVu = suaten.Text; _chucvu.HeSoCV = Convert.ToDouble(suahs.Text); if (_bizchucvu.BizTimKiem(_chucvu) == true) { MessageBox.Show("Sửa thành công"); } else { MessageBox.Show("Sửa thất bại"); } db.SaveChanges(); load(); } else { MessageBox.Show("Vui lòng chọn thông tin cần sửa!!"); } }
public bool ThemLoai(LoaiDonVi loaidonvi) { try { var them = new LoaiDonVi { MaLoai = loaidonvi.MaLoai, TenLoai = loaidonvi.TenLoai, MoTa = loaidonvi.MoTa }; _db.LoaiDonVis.Add(them); _db.SaveChanges(); return(true); } catch { return(false); } }
public bool themDonVi(DonVi donvi) { try { DonVi dv = new DonVi { MaDonVi = donvi.MaDonVi, TenDonVi = donvi.TenDonVi, MaLoai = donvi.MaLoai, DiaChi = donvi.DiaChi, DienThoai = donvi.DienThoai, NamThanhLap = donvi.NamThanhLap, ChucNang = donvi.ChucNang, NhiemVu = donvi.NhiemVu }; db.DonVis.Add(dv); db.SaveChanges(); return(true); } catch { return(false); } }
public bool themChucVu(ChucVu chucvu) { try { ChucVu cv = new ChucVu { MaChucVu = chucvu.MaChucVu, TenChucVu = chucvu.TenChucVu, HeSoCV = chucvu.HeSoCV }; db.ChucVus.Add(cv); db.SaveChanges(); } catch { return(false); } return(true); }
public bool Suachucvu(ChucVu chucvu) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { ChucVu cv = csdl.ChucVus.SingleOrDefault(n => n.MaChucVu == chucvu.MaChucVu); cv.TenChucVu = chucvu.TenChucVu; cv.HeSoCV = chucvu.HeSoCV; csdl.SaveChanges(); } catch { return(false); } return(true); }
public bool Suachucvu(ChucVu chucvu) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { ChucVu cv = csdl.ChucVus.SingleOrDefault(n => n.MaChucVu == chucvu.MaChucVu); cv.TenChucVu = chucvu.TenChucVu; cv.HeSoCV = chucvu.HeSoCV; csdl.SaveChanges(); } catch { return false; } return true; }
public bool Suadonvi(DonVi donvi) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { DonVi dv = csdl.DonVis.SingleOrDefault(n => n.MaDonVi == donvi.MaDonVi); dv.TenDonVi = donvi.TenDonVi; dv.MaLoai = donvi.MaLoai; dv.DienThoai = donvi.DienThoai; dv.DiaChi = donvi.DiaChi; dv.ChucNang = donvi.ChucNang; dv.NhiemVu = donvi.NhiemVu; dv.NamThanhLap = dv.NamThanhLap; csdl.SaveChanges(); } catch { return(false); } return(true); }
public bool Suadonvi(DonVi donvi) { QuanLyLuongEntities csdl = new QuanLyLuongEntities(); try { DonVi dv = csdl.DonVis.SingleOrDefault(n => n.MaDonVi == donvi.MaDonVi); dv.TenDonVi = donvi.TenDonVi; dv.MaLoai = donvi.MaLoai; dv.DienThoai = donvi.DienThoai; dv.DiaChi = donvi.DiaChi; dv.ChucNang = donvi.ChucNang; dv.NhiemVu = donvi.NhiemVu; dv.NamThanhLap = dv.NamThanhLap; csdl.SaveChanges(); } catch { return false; } return true; }
public bool TinhLuong(string Manv) { int countmanv = (from u in db.LuongThucTes where u.MaNV.Equals(Manv) select u).Count(); try { if (countmanv != 0) { double hesotinhluong; var result = db.NhanViens.FirstOrDefault(a => a.MaNV.Equals(Manv)); double xuatLuong; double luongCoBantruoc = double.Parse(db.LuongThucTes.Where(a => a.MaNV.Equals(Manv)).OrderByDescending(a => a.id).Select(a => a.LuongCoBan).FirstOrDefault().ToString()); string TrangThaiLuong; string maxmaheso = db.LichSuChuyenBacs.Where(a => a.MaNV.Equals(Manv)).OrderByDescending(a => a.id).Select(a => a.MaHeSo).FirstOrDefault(); string maxmahesotrongbangluong = db.LuongThucTes.Where(a => a.MaNV.Equals(Manv)).OrderByDescending(a => a.id).Select(a => a.MaHeSo).FirstOrDefault(); if (luongCoBantruoc == null) { luongCoBantruoc = 720000; } if (result != null) { var heso = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo.Equals(maxmaheso)); var hesochucvu = db.ChucVus.FirstOrDefault(a => a.MaChucVu.Equals(result.MaChucVu)); if (hesochucvu.HeSoCV != 0) { hesotinhluong = heso.HeSo + hesochucvu.HeSoCV; } else { hesotinhluong = heso.HeSo; } double LuongCoBan = 720000; var hesovuotkhung5 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0008" || a.MaHeSo == "HS0016" || a.MaHeSo == "HS0024" || a.MaHeSo == "HS0032"); double tinhhesovuotkhung5 = hesovuotkhung5.HeSo + 1; var hesovuotkhung7 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0038" || a.MaHeSo == "HS0046" || a.MaHeSo == "HS0054"); double tinhhesovuotkhung7 = hesovuotkhung7.HeSo + 1; var hesovuotkhung9 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0039" || a.MaHeSo == "HS0047" || a.MaHeSo == "HS0055"); double tinhhesovuotkhung9 = hesovuotkhung9.HeSo + 1; var hesovuotkhung11 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0040" || a.MaHeSo == "HS0048" || a.MaHeSo == "HS0056"); double tinhhesovuotkhung11 = hesovuotkhung11.HeSo + 1; if (maxmaheso == "HS0008" || maxmaheso == "HS0016" || maxmaheso == "HS0024" || maxmaheso == "HS0032") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung5; TrangThaiLuong = "Vượt khung 5"; } else if (maxmaheso == "HS0038" || maxmaheso == "HS0046" || maxmaheso == "HS0054") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung7; TrangThaiLuong = "Vượt khung 7"; } else if (maxmaheso == "HS0039" || maxmaheso == "HS0047" || maxmaheso == "HS0055") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung9; TrangThaiLuong = "Vượt khung 9"; } else if (maxmaheso == "HS0040" || maxmaheso == "HS0048" || maxmaheso == "HS0056") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung11; TrangThaiLuong = "Vượt khung 11"; } else { xuatLuong = hesotinhluong * LuongCoBan; TrangThaiLuong = "Không có gì"; } decimal floatLuongcoban = decimal.Parse(xuatLuong.ToString()); if (maxmaheso != maxmahesotrongbangluong) { var themvaoluong = new LuongThucTe { MaLuong = automaluong(), MaNV = result.MaNV, NgayLap = DateTime.Now, HeSoLuong = hesotinhluong, LuongCoBan = floatLuongcoban, LuongThucTe1 = floatLuongcoban, TrangThai = TrangThaiLuong, MaHeSo = maxmaheso }; db.LuongThucTes.Add(themvaoluong); db.SaveChanges(); } else { var capnhatngaythang = db.LuongThucTes.Where(a => a.MaNV.Equals(Manv)).OrderByDescending(a => a.id).FirstOrDefault(); capnhatngaythang.NgayLap = DateTime.Now; db.SaveChanges(); } } } else { double hesotinhluong; var result = db.NhanViens.FirstOrDefault(a => a.MaNV.Equals(Manv)); double xuatLuong; double luongCoBantruoc = 720000; string TrangThaiLuong; string maxmaheso = db.LichSuChuyenBacs.Where(a => a.MaNV.Equals(Manv)).OrderByDescending(a => a.id).Select(a => a.MaHeSo).FirstOrDefault(); if (result != null) { var heso = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo.Equals(maxmaheso)); var hesochucvu = db.ChucVus.FirstOrDefault(a => a.MaChucVu.Equals(result.MaChucVu)); if (hesochucvu.HeSoCV != 0) { hesotinhluong = heso.HeSo + hesochucvu.HeSoCV; } else { hesotinhluong = heso.HeSo; } double LuongCoBan = 720000; var hesovuotkhung5 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0008" || a.MaHeSo == "HS0016" || a.MaHeSo == "HS0024" || a.MaHeSo == "HS0032"); double tinhhesovuotkhung5 = hesovuotkhung5.HeSo + 1; var hesovuotkhung7 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0038" || a.MaHeSo == "HS0046" || a.MaHeSo == "HS0054"); double tinhhesovuotkhung7 = hesovuotkhung7.HeSo + 1; var hesovuotkhung9 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0039" || a.MaHeSo == "HS0047" || a.MaHeSo == "HS0055"); double tinhhesovuotkhung9 = hesovuotkhung9.HeSo + 1; var hesovuotkhung11 = db.HeSoLuongPhuCaps.FirstOrDefault(a => a.MaHeSo == "HS0040" || a.MaHeSo == "HS0048" || a.MaHeSo == "HS0056"); double tinhhesovuotkhung11 = hesovuotkhung11.HeSo + 1; if (maxmaheso == "HS0008" || maxmaheso == "HS0016" || maxmaheso == "HS0024" || maxmaheso == "HS0032") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung5; TrangThaiLuong = "Vượt khung 5"; } else if (maxmaheso == "HS0038" || maxmaheso == "HS0046" || maxmaheso == "HS0054") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung7; TrangThaiLuong = "Vượt khung 7"; } else if (maxmaheso == "HS0039" || maxmaheso == "HS0047" || maxmaheso == "HS0055") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung9; TrangThaiLuong = "Vượt khung 9"; } else if (maxmaheso == "HS0040" || maxmaheso == "HS0048" || maxmaheso == "HS0056") { xuatLuong = luongCoBantruoc * tinhhesovuotkhung11; TrangThaiLuong = "Vượt khung 11"; } else { xuatLuong = hesotinhluong * LuongCoBan; TrangThaiLuong = "Không có gì"; } decimal floatLuongcoban = decimal.Parse(xuatLuong.ToString()); var themvaoluong = new LuongThucTe { MaLuong = automaluong(), MaNV = result.MaNV, NgayLap = DateTime.Now, HeSoLuong = hesotinhluong, LuongCoBan = floatLuongcoban, LuongThucTe1 = floatLuongcoban, TrangThai = TrangThaiLuong, MaHeSo = maxmaheso }; db.LuongThucTes.Add(themvaoluong); db.SaveChanges(); } } return(true); } catch (Exception ex) { Console.WriteLine("Lỗi: " + ex); return(false); } }
public bool themchuyenbac(LichSuChuyenBac lichsuchuyenbac) { QuanLyLuongEntities db = new QuanLyLuongEntities(); try { LichSuChuyenBac lscb = new LichSuChuyenBac { MaNV = lichsuchuyenbac.MaNV, MaHeSo = lichsuchuyenbac.MaHeSo, Mangach = lichsuchuyenbac.Mangach, NgayChuyen = lichsuchuyenbac.NgayChuyen }; db.LichSuChuyenBacs.Add(lscb); db.SaveChanges(); var nhanvien = from p in db.NhanViens where p.MaNV == lichsuchuyenbac.MaNV select p; foreach (NhanVien nv in nhanvien) { nv.MaHeSo = lichsuchuyenbac.MaHeSo; nv.MaNgach = lichsuchuyenbac.Mangach; } db.SaveChanges(); } catch { return false; } return true; }