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