public string GetDayByID(int dayID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Day d = db.Days.SingleOrDefault(x => x.ID == dayID);
return(d.Name);
}
public string GetRoomByID(int roomID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Room r = db.Rooms.SingleOrDefault(x => x.ID == roomID);
return(r.Name);
}
public Teacher GetTeacherByUsername(string username)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Teacher tea = db.Teachers.SingleOrDefault(x => x.UserName == username);
return(tea);
}
public Account Select(string username)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Account acc = db.Accounts.SingleOrDefault(x => x.UserName == username);
return(acc);
}
public int GetPositionID(string username)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Account acc = db.Accounts.SingleOrDefault(x => x.UserName == username);
return(acc.PositionID);
}
public bool CheckStatus()
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
List <OpenRegister> list = db.OpenRegisters.ToList();
if (list.Count() != 0)
{
for (int i = 0; i < list.Count(); i++)
{
if (list[i].StatusID == 3)
{
if (CheckDayExpired(list[i]))
{
Update(list[i].ID);
return(true);
}
else
{
return(false);
}
}
}
}
return(true);
}
public DateTime GetDayEndByStatusID(int StatusID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
OpenRegister or = db.OpenRegisters.SingleOrDefault(x => x.StatusID == StatusID);
return((DateTime)or.DayEnd);
}
public string GetTimeByID(int timeID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Time t = db.Times.SingleOrDefault(x => x.ID == timeID);
return(t.Name);
}
public List <Course> GetListCourse()
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
DateTime dt = DateTime.Now;
return(db.Courses.Where(x => x.BeginYear == dt.Year || x.BeginYear == (dt.Year - 1) || x.BeginYear == (dt.Year - 2) || x.BeginYear == (dt.Year - 3)).ToList());
}
public List <Branch> GetListBranch()
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
List <Branch> list = db.Branches.Where(x => x.ID != 0).ToList();
return(list);
}
public void Update(string username, string password)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Account acc = db.Accounts.SingleOrDefault(x => x.UserName == username);
acc.PassWord = password;
db.SaveChanges();
}
public List <ListClass> GetListDayTimeByBranchID(int branchID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
return(db.Classes.Where(x => x.StatusID != 5 && x.BranchID == branchID).Select(x => new ListClass {
dayID = x.DayID, timeID = x.TimeID
}).ToList());
}
public List <ListClass> GetList()
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
return(db.Classes.Where(x => x.StatusID != 5 && x.ClassTypeID == 1).Select(x => new ListClass {
ID = x.ID, classTypeID = x.ClassTypeID, courseID = x.CourseID, branchID = x.BranchID, subjectID = x.SubjectID, dayID = x.DayID, timeID = x.TimeID, roomID = x.RoomID, teacherID = x.TeacherID, statusID = x.StatusID, numberOfStudent = (int)x.NumberOfStudent, dayStart = (DateTime)x.DayStart, dayEnd = (DateTime)x.DayEnd, classType = x.ClassType.Name, course = x.Course.Name, branch = x.Branch.Name, subject = x.Subject.Name, day = x.Day.Name, time = x.Time.Name, room = x.Room.Name, teacher = x.Teacher.Name, status = x.Status.Name
}).ToList());
}
public void UpdateStatus(int ClassID, int StatusID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID);
c.StatusID = StatusID;
db.SaveChanges();
}
public void Delete(int ClassID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID);
db.Classes.Remove(c);
db.SaveChanges();
}
public List <ListStudent> GetListForClass(int classID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
return(db.StudentDetails.Where(x => x.ClassID == 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());
}
public void Delete(int classID, int studentID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
StudentDetail sd = db.StudentDetails.SingleOrDefault(x => x.StudentID == studentID && x.ClassID == classID);
db.StudentDetails.Remove(sd);
db.SaveChanges();
}
public void Update(int ID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
OpenRegister or = db.OpenRegisters.SingleOrDefault(x => x.ID == ID);
or.StatusID = 4;
db.SaveChanges();
}
public List <ListClass> GetListScheduleByStudentID(int studentID, int branchID) // processing
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
int[] classIDArray = new ModifyStudentDetail().GetArrayClassIDByStudentID(studentID);
return(db.Classes.Where(x => classIDArray.Contains(x.ID)).Select(x => new ListClass {
ID = x.ID, classTypeID = x.ClassTypeID, courseID = x.CourseID, branchID = x.BranchID, subjectID = x.SubjectID, dayID = x.DayID, timeID = x.TimeID, roomID = x.RoomID, teacherID = x.TeacherID, statusID = x.StatusID, numberOfStudent = (int)x.NumberOfStudent, dayStart = (DateTime)x.DayStart, dayEnd = (DateTime)x.DayEnd, classType = x.ClassType.Name, course = x.Course.Name, branch = x.Branch.Name, subject = x.Subject.Name, day = x.Day.Name, time = x.Time.Name, room = x.Room.Name, teacher = x.Teacher.Name, status = x.Status.Name
}).ToList());
}
public int GetNextID()
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
List <Class> c = db.Classes.OrderByDescending(x => x.ID).Take(1).ToList();
if (c.Count() == 0)
{
return(1);
}
return(c[0].ID + 1);
}
public void Insert(int ID, string name, string username)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Admin a = new Admin();
a.ID = ID;
a.Name = name;
a.UserName = username;
db.Admins.Add(a);
db.SaveChanges();
}
public void Insert(string username, string password, int positionID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Account acc = new Account();
acc.UserName = username;
acc.PassWord = password;
acc.PositionID = positionID;
db.Accounts.Add(acc);
db.SaveChanges();
}
public void Update(int ClassID, int subjectID, int dayID, int timeID, int roomID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID);
c.SubjectID = subjectID;
c.DayID = dayID;
c.TimeID = timeID;
c.RoomID = roomID;
db.SaveChanges();
}
public void Insert(int classID, int studentID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
StudentDetail sd = new StudentDetail();
sd.ID = 0;
sd.ClassID = classID;
sd.StudentID = studentID;
db.StudentDetails.Add(sd);
db.SaveChanges();
}
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 bool CheckStatusDelete(int ClassID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Class c = db.Classes.SingleOrDefault(x => x.ID == ClassID);
if (c.StatusID == 2 || c.StatusID == 3)
{
return(false);
}
else
{
return(true);
}
}
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();
}
public bool Check(string username)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
Account acc = db.Accounts.SingleOrDefault(x => x.UserName == username);
if (acc != null)
{
return(true);
}
else
{
return(false);
}
}
public int GetCourseIDForYear(int year)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
List <Course> list = GetListCourse();
for (int i = 0; i < list.Count(); i++)
{
if (list[i].BeginYear == year)
{
return(list[i].ID);
}
}
return(0);
}
public bool CheckSameSchedule(int teacherID, int dayID, int timeID)
{
SoftwareTechnologyDBContext db = new SoftwareTechnologyDBContext();
List <Class> listClass = db.Classes.Where(x => x.TeacherID == teacherID).ToList();
for (int i = 0; i < listClass.Count(); i++)
{
if (listClass[i].DayID == dayID && listClass[i].TimeID == timeID && listClass[i].StatusID == 3)
{
return(false);
}
}
return(true);
}
