public bool xoaPhanCongCongViec(int idPhanCong)
{
DanhSachPhanCong a = db.DanhSachPhanCongs.Where(p => p.id == idPhanCong).SingleOrDefault();
if (a != null)
{
db.DanhSachPhanCongs.DeleteOnSubmit(a);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
public bool xoaPhanCongCongViec(int idPhanCong, string idNhanVien)
{
DanhSachPhanCong a = db.DanhSachPhanCongs.Where(p => p.id == idPhanCong && p.idNhanVien == idNhanVien).SingleOrDefault();
List <DanhSachChamCong> aa = db.DanhSachChamCongs.Where(p => p.idPhanCong == idPhanCong && p.idNhanVien == idNhanVien).ToList();
if (a != null)
{
db.DanhSachPhanCongs.DeleteOnSubmit(a);
foreach (DanhSachChamCong item in aa)
{
db.DanhSachChamCongs.DeleteOnSubmit(item);
}
db.SubmitChanges();
return(true);
}
else
{
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);
}
}
public bool phanCongNhanVien(string idNhanVien, string idCongTrinh, string idCongViec)
{
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;
db.DanhSachPhanCongs.InsertOnSubmit(aaa);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
