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