public int[] GetArrayClassIDByStudentID(int studentID)
{
List <StudentDetail> listSD = new SoftwareTechnologyDBContext().StudentDetails.Where(x => x.StudentID == studentID).ToList();
int[] classIDArray = new int[listSD.Count()];
for (int i = 0; i < listSD.Count(); i++)
{
classIDArray[i] = listSD[i].ClassID;
}
return(classIDArray);
}
public void ChangeStatusClass()
{
if (new SoftwareTechnologyDBContext().OpenRegisters.ToList().Count() != 0)
{
if (DateTime.Now > new ModifyOpenRegister().GetDayEndClassRegisterByStatus(3))
{
List <Class> list = new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 1 && x.ClassTypeID == 1).ToList();
if (list.Count() != 0)
{
for (int i = 0; i < list.Count(); i++)
{
UpdateStatus(list[i].ID, 2);
}
}
}
}
}
public List <ListStudent> GetListByTeacherID(int teacherID)
{
List <Class> listClass = new SoftwareTechnologyDBContext().Classes.Where(x => x.TeacherID == teacherID).ToList();
int[] classIDArray = new int[listClass.Count()];
for (int i = 0; i < listClass.Count; i++)
{
classIDArray[i] = listClass[i].ID;
}
List <ListStudent> list = new SoftwareTechnologyDBContext().StudentDetails.Where(x => classIDArray.Contains(x.ClassID)).Select(x => new ListStudent {
classID = x.ClassID, studentID = x.StudentID, studentName = x.Student.Name, country = x.Student.Country, birth = x.Student.Birth, gender = x.Student.Gender
}).ToList();
return(list);
}
public void ChangeStatusIfClassReEnd()
{
if (new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 3).ToList().Count() == 0)
{
//
}
else
{
List <Class> listClass = new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 3).ToList();
for (int i = 0; i < listClass.Count(); i++)
{
if (DateTime.Now > listClass[i].DayEnd)
{
UpdateStatus(listClass[i].ID, 5);
}
}
}
}
public void ChangeStatusIfTeacherNotReceive()
{
if (new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 2 && x.ClassTypeID == 2).ToList().Count() == 0)
{
//
}
else
{
List <Class> listClass = new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 2 && x.ClassTypeID == 2).ToList();
for (int i = 0; i < listClass.Count(); i++)
{
if (DateTime.Now > listClass[i].DayStart.Value.AddDays(14) && listClass[i].TeacherID == 0)
{
UpdateStatus(listClass[i].ID, 4);
}
}
}
}
public void ChangeStatusClassRe()
{
if (new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 1 && x.ClassTypeID == 2).ToList().Count() == 0)
{
//
}
else
{
List <Class> listClass = new SoftwareTechnologyDBContext().Classes.Where(x => x.StatusID == 1 && x.ClassTypeID == 2).ToList();
for (int i = 0; i < listClass.Count(); i++)
{
if (DateTime.Now > listClass[i].DayStart.Value.AddDays(7) && listClass[i].NumberOfStudent >= 15)
{
UpdateStatus(listClass[i].ID, 2);
}
else if (DateTime.Now > listClass[i].DayStart.Value.AddDays(7) && listClass[i].NumberOfStudent < 15)
{
UpdateStatus(listClass[i].ID, 4);
}
}
}
}