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