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