public DateTime GetDayEndByStatusID(int StatusID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); OpenRegister or = db.OpenRegisters.SingleOrDefault(x => x.StatusID == StatusID); return((DateTime)or.DayEnd); }
public void Update(int ID) { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); OpenRegister or = db.OpenRegisters.SingleOrDefault(x => x.ID == ID); or.StatusID = 4; db.SaveChanges(); }
public bool CheckDayExpired(OpenRegister or) { DateTime dt = DateTime.Now; if (or.DayEnd < dt) { return(true); } else { return(false); } }
public void Insert() { SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext(); OpenRegister or = new OpenRegister(); DateTime dt = DateTime.Now; or.StatusID = 3; or.ID = GetNextID(); or.DayStart = dt; or.DayEndClassRegister = dt.AddDays(7); or.DayEnd = dt.AddDays(14); db.OpenRegisters.Add(or); db.SaveChanges(); }