public bool chamCong(string idnhanvien, int idphancong, int status) { DateTime dateNow = DateTime.Now; DanhSachChamCong a = db.DanhSachChamCongs.Where(p => p.idNhanVien == idnhanvien && p.idPhanCong == idphancong && p.ngayChamcong == dateNow).SingleOrDefault(); if (a != null) { a.trangThaiChamCong = status; db.SubmitChanges(); return(true); } return(false); }
public bool chamCongNhanVienVang(string idNhanVien, string idCongTrinh) { CongTrinh congTrinh = db.CongTrinhs.FirstOrDefault(p => p.idCongTrinh == idCongTrinh); NhanVien nhanVien = db.NhanViens.FirstOrDefault(a => a.idNhanVien == idNhanVien); DanhSachChamCong danhSachChamCong = db.DanhSachChamCongs.FirstOrDefault(cc => cc.idNhanVien == idNhanVien && cc.idCongTrinh == idCongTrinh); if (danhSachChamCong == null) { DanhSachChamCong aaa = new DanhSachChamCong(); aaa.idNhanVien = nhanVien.idNhanVien; aaa.idCongTrinh = congTrinh.idCongTrinh; aaa.ngayChamcong = DateTime.Now; aaa.trangThaiChamCong = false; db.DanhSachChamCongs.InsertOnSubmit(aaa); db.SubmitChanges(); return(true); } return(false); }
public bool phanCongNhanVien(string idNhanVien, string idCongTrinh, string idCongViec, DateTime ngayBatDau, DateTime ngayKetThuc) { DanhSachCongViecCongTrinh a = db.DanhSachCongViecCongTrinhs.Where(p => p.idCongTrinh == idCongTrinh && p.idCongViec == idCongViec).SingleOrDefault(); DanhSachPhanCong aa = db.DanhSachPhanCongs.Where(p => p.idDSCongViecCongTrinh == a.id && p.idNhanVien == idNhanVien).SingleOrDefault(); if (aa == null) { DanhSachPhanCong aaa = new DanhSachPhanCong(); aaa.idDSCongViecCongTrinh = a.id; aaa.idNhanVien = idNhanVien; aaa.ngayPhanCong = DateTime.Now; aaa.ngayBatDau = (DateTime)ngayBatDau; aaa.ngayKetThuc = (DateTime)ngayKetThuc; db.DanhSachPhanCongs.InsertOnSubmit(aaa); db.SubmitChanges(); int kq = (int)ngayKetThuc.Subtract(ngayBatDau).TotalDays; DateTime ngayThucHienCongViec = ngayBatDau; for (int i = 0; i <= kq + 1; i++) { DanhSachChamCong bbb = new DanhSachChamCong(); bbb.idNhanVien = idNhanVien; bbb.idPhanCong = aaa.id; bbb.ngayChamcong = ngayThucHienCongViec; bbb.trangThaiChamCong = 0; db.DanhSachChamCongs.InsertOnSubmit(bbb); db.SubmitChanges(); ngayThucHienCongViec = ngayThucHienCongViec.AddDays(1); } return(true); } else { return(false); } }