public FrmCaEdit(CaLamViec ca)
{
InitializeComponent();
current = ca;
spnGioBatDau.Text = ca.GioBatDau.Hours.ToString();
spnPhutBatDau.Text = ca.GioBatDau.Minutes.ToString();
spnGioKetThuc.Text = ca.GioKetThuc.Hours.ToString();
spnPhutKetThuc.Text = ca.GioKetThuc.Minutes.ToString();
}
public static CODE_RESULT_RETURN Update(CaLamViec c)
{
using (var db = DBContext.GetContext()) {
var trung = db.CaLamViec.FirstOrDefault(ca => (ca.GioBatDau > c.GioBatDau && ca.GioBatDau < c.GioKetThuc)
||
(ca.GioKetThuc > c.GioBatDau && ca.GioKetThuc < c.GioKetThuc));
if (trung != null)
return CODE_RESULT_RETURN.MaTrung;
var c1 = db.CaLamViec.Find(c.MaCa);
if (c1 != null) {
c1.GioBatDau = c.GioBatDau;
c1.GioKetThuc = c.GioKetThuc;
db.SaveChanges();
return CODE_RESULT_RETURN.ThanhCong;
}
return CODE_RESULT_RETURN.ThatBai;
}
}
internal static List<HistoryNhanVien> GetToDay(int maPhong = -1, bool isCheckin = true, CaLamViec caHienTai = null)
{
using (var db = DBContext.GetContext())
{
var start = DateTimeUtil.StartOfDay(DateTime.Now);
var end = DateTimeUtil.EndOfDay(DateTime.Now);
var data = db.HistoryNhanVien.Include(h => h.NhanVien.PhongTap).Include(h=>h.Ca).Where(h => h.ThoiGian >= start
&& h.ThoiGian <= end
&& h.IsCheckin == isCheckin
);
if (maPhong != -1)
{
data = data.Where(d => d.NhanVien.PhongTap.MaPhongTap == maPhong);
}
return data.ToList();
}
}