public List <TOPIC> GetAllTopicOfStudentCourse(string user_id, string course_id) { C_USER student = db.C_USER.Where(x => x.ID == user_id).First(); COURSE course = student.COURSEs.Where(x => x.ID == course_id).First(); List <TOPIC> topics = course.TOPICs.Select(t => new TOPIC { ID = t.ID, TITLE = t.TITLE, DESCRIPTION = t.DESCRIPTION, COURSE_ID = t.COURSE_ID, DOCUMENTs = t.DOCUMENTs .Select(d => new DOCUMENT { ID = d.ID, TITLE = d.TITLE, DESCRIPTION = d.DESCRIPTION, LINK = d.LINK }) .ToList(), EVENTs = t.EVENTs .Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DESCRIPTION = e.DESCRIPTION, STARTDATE = e.STARTDATE, DEADLINE = e.DEADLINE }) .ToList() }).ToList(); return(topics); }
public C_USER GetStudentsByIDWithSubmit(string id, string event_id) { C_USER u = db.C_USER.First(x => x.ID == id); C_USER student = new C_USER() { ID = u.ID, FIRST_NAME = u.FIRST_NAME, MIDDLE_NAME = u.MIDDLE_NAME, LAST_NAME = u.LAST_NAME, SUBMITs = u.SUBMITs.Where(s => s.EVENT_ID == event_id) .Select(s => new SUBMIT { ID = s.ID, LINK = s.LINK, TIME = s.TIME, ASSESSMENT = new ASSESSMENT { SCORE = ((s.ASSESSMENT == null)? null : s.ASSESSMENT.SCORE), COMMENT = ((s.ASSESSMENT == null) ? null : s.ASSESSMENT.COMMENT) }, }).ToList() }; return(student); }
public List <COURSE> GetSubmitAssessmentByStuAndCourseAndSem(string user_id) { C_USER stu = db.C_USER.Where(u => u.ID == user_id).First(); //var model = stu.COURSEs.Where(x => x.ID == course_id).ToList(); //return model.Select(x => new COURSE List <COURSE> course = stu.COURSEs.Select(x => new COURSE { ID = x.ID, NAME = x.NAME, TOPICs = ((x.TOPICs.Count == 0) ? null : (x.TOPICs.Select(t => new TOPIC { EVENTs = ((t.EVENTs.Count() == 0) ? null : (t.EVENTs.Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DEADLINE = e.DEADLINE, SUBMITs = ((e.SUBMITs.FirstOrDefault(s => s.USER_ID == user_id) == null) ? null : (e.SUBMITs.Where(s => s.USER_ID == user_id) .Select(s => new SUBMIT { ID = s.ID, LINK = s.LINK, TIME = s.TIME, ASSESSMENT = new ASSESSMENT { SCORE = ((s.ASSESSMENT == null) ? null : s.ASSESSMENT.SCORE), COMMENT = ((s.ASSESSMENT == null) ? null : s.ASSESSMENT.COMMENT) } }).ToList())) }).ToList())) }).ToList())) }).ToList(); return(course); }
public List <COURSE> GetDeadlinebyStuAndCourseAndSem(string user_id) { C_USER stu = db.C_USER.Where(u => u.ID == user_id).First(); List <COURSE> courses = stu.COURSEs.Select(x => new COURSE { ID = x.ID, NAME = x.NAME, TOPICs = ((x.TOPICs.Count == 0) ? null : (x.TOPICs.Select(t => new TOPIC { EVENTs = ((t.EVENTs.Count() == 0) ? null : (t.EVENTs.Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DESCRIPTION = e.DESCRIPTION, DEADLINE = e.DEADLINE, SUBMITs = ((e.SUBMITs.FirstOrDefault(s => s.USER_ID == user_id) == null) ? null : (e.SUBMITs.Where(s => s.USER_ID == user_id) .Select(s => new SUBMIT { ID = s.ID }).ToList())) }).ToList())) }).ToList())) }).ToList(); return(courses); }
public ActionResult EditProfile() { Session session = Session[CommonConstants.SESSION] as Session; UserDAO userDao = new UserDAO(); C_USER user = userDao.GetUserByID(session.id_user); return(View(user)); }
// GET: Profile public ActionResult Index() { CommonFunc comf = new CommonFunc(); string user_id = comf.GetIdUserBySession(); UserDAO userDao = new UserDAO(); C_USER user = userDao.GetUserByID(user_id); return(View(user)); }
private void Bouton_Supprimer_Click(object sender, EventArgs e) { C_USER User_Remove = (C_USER)Liste_Box.SelectedItem; if (User_Remove != null) { Base.Les_Users.Remove(User_Remove); Bouton_Sauvegarder.Enabled = true; } }
public List <COURSE> GetCourseByStudentAndSemester(string student_id, string sem_id) { C_USER stu = db.C_USER.First(x => x.ID == student_id); return(stu.COURSEs.Where(c => c.SEMESTER_ID == sem_id).Select(c => new COURSE { ID = c.ID, NAME = c.NAME }).ToList()); }
public int Ajoute_User(C_USER P_User) { int Cle = P_User.Nom.GetHashCode(); try { Les_Users.Add(Cle, P_User); } catch (Exception) { Cle = -1; } return(Cle); }
private void Liste_Box_SelectedIndexChanged(object sender, EventArgs e) { C_USER User_Selectionne = Liste_Box.SelectedItem as C_USER; if (User_Selectionne != null) { Text_Box_Type.Text = User_Selectionne.Type; Text_Box_Nom.Text = User_Selectionne.Nom; Text_Box_ID.Text = User_Selectionne.ID.ToString(); Text_Box_Couleur.Text = User_Selectionne.Couleur.ToString(); Text_Box_Id_Groupe.Text = User_Selectionne.ID_Groupe.ToString(); } }
public List <COURSE> GetCourseByTeacherAndSemester(string teacher_id, string sem_id) { C_USER teacher = db.C_USER.First(x => x.ID == teacher_id); List <TEACH> teaches = teacher.TEACHES.Select(c => new TEACH { COURSE = c.COURSE }).ToList(); List <COURSE> courses = new List <COURSE>(); foreach (TEACH teach in teaches) { courses.Add(teach.COURSE); } return(courses); }
public C_USER GetUserByID(string id) { C_USER user = db.C_USER.First(u => u.ID == id); return(new C_USER { ID = user.ID, FIRST_NAME = user.FIRST_NAME, MIDDLE_NAME = user.MIDDLE_NAME, LAST_NAME = user.LAST_NAME, DoB = user.DoB, MAIL = user.MAIL, PHONE_NO = user.PHONE_NO, LASTVISITDATE = user.LASTVISITDATE, CLASS = new CLASS { ID = ((user.CLASS == null) ? null : user.CLASS.ID), NAME = ((user.CLASS == null) ? null : user.CLASS.NAME), MAJOR = ((user.CLASS == null) ? null : user.CLASS.MAJOR) }, FACULTY = new FACULTY { ID = user.FACULTY.ID, NAME = user.FACULTY.NAME }, ROLEs = user.ROLEs.Select(r => new ROLE { ID = r.ID, ROLE1 = r.ROLE1 }).ToList(), //learns COURSEs = ((user.COURSEs != null) ? user.COURSEs.Select(s => new COURSE { ID = s.ID, NAME = s.NAME }).ToList() : null), //teaches TEACHES = ((user.TEACHES != null) ? user.TEACHES.Select(s => new TEACH { COURSE = new COURSE { ID = s.COURSE_ID, NAME = s.COURSE.NAME } }).ToList() : null) }); }
private void Bouton_MAJ_Click(object sender, EventArgs e) { C_USER User_Selectionne = Liste_Box.SelectedItem as C_USER; if (User_Selectionne != null) { User_Selectionne.Couleur = Convert.ToInt32(Text_Box_Couleur.Text); User_Selectionne.ID_Groupe = Convert.ToInt32(Text_Box_Id_Groupe.Text); Bouton_Sauvegarder.Enabled = true; Text_Box_Nom.ReadOnly = true; Text_Box_Couleur.ReadOnly = true; Text_Box_Id_Groupe.ReadOnly = true; Check_Box_Ecriture.Checked = false; } }
public ActionResult StudentDetail(string studentID, string eventID) { UserDAO userDao = new UserDAO(); C_USER student = userDao.GetStudentsByIDWithSubmit(studentID, eventID); EventDAO eventDao = new EventDAO(); EVENT ev = eventDao.GetEventByID(eventID); AssessmentStudentDetailView model = new AssessmentStudentDetailView(); model.student = student; model.eVent = ev; return(View(model)); }
public bool updateteacher(C_USER teacher) { var model = db.C_USER.Find(teacher.ID); model.FIRST_NAME = teacher.FIRST_NAME; model.LAST_NAME = teacher.LAST_NAME; model.MIDDLE_NAME = teacher.MIDDLE_NAME; model.PHONE_NO = teacher.PHONE_NO; model.DoB = teacher.DoB; model.SEX = teacher.SEX; model.MAIL = teacher.MAIL; model.PASSWORD = teacher.PASSWORD; model.FACULTY_ID = teacher.FACULTY_ID; db.SaveChanges(); return(true); }
public bool UpdatePhoneEmail(string id_user, string phone, string email) { C_USER user = db.C_USER.First(x => x.ID == id_user); try { user.PHONE_NO = phone; user.MAIL = email; db.SaveChanges(); return(true); } catch { return(false); } }
public bool updatestudent(C_USER student) { var model = db.C_USER.Find(student.ID); model.FIRST_NAME = student.FIRST_NAME; model.LAST_NAME = student.LAST_NAME; model.MIDDLE_NAME = student.MIDDLE_NAME; model.PHONE_NO = student.PHONE_NO; model.DoB = student.DoB; model.SEX = student.SEX; model.MAIL = student.MAIL; model.PASSWORD = student.PASSWORD; model.FACULTY_ID = student.FACULTY_ID; model.CLASS_ID = student.CLASS_ID; db.SaveChanges(); return(true); }
private void Bouton_Ajouter_Click(object sender, EventArgs e) { C_USER Nouveau_Utilisateur = new C_USER(); Nouveau_Utilisateur.Nom = Text_Box_Nom_Ajouter.Text; Nouveau_Utilisateur.Type = Text_Box_Type_Ajouter.Text; Nouveau_Utilisateur.ID = Convert.ToInt32(Text_Box_Id_Ajouter.Text); Nouveau_Utilisateur.Couleur = Convert.ToInt32(Text_Box_Couleur_Ajouter.Text); Nouveau_Utilisateur.ID_Groupe = Convert.ToInt32(Text_Box_Id_Groupe_Ajouter.Text); Base.Les_Users.Add(Nouveau_Utilisateur); Bouton_Sauvegarder.Enabled = true; Text_Box_Nom_Ajouter.Clear(); Text_Box_Type_Ajouter.Clear(); Text_Box_Id_Ajouter.Clear(); Text_Box_Couleur_Ajouter.Clear(); Text_Box_Id_Groupe_Ajouter.Clear(); C_BASE.nbr_id = Base.Les_Users.Count() + 1; Text_Box_Id_Ajouter.Text = C_BASE.nbr_id.ToString(); }
public List <TOPIC> GetAllTopicOfTeacherCourse(string userId, string semId, string courseId) { //var topicsInSubTeachedByTeacher = db.C_USER.Where(x => x.ID == userId) // .Select(x => x.SUBJECTs1.Where(s => s.COURSE_ID == courseId && s.ID == subjectId) // .Select(s => s.TOPICs)).ToList(); C_USER teacher = db.C_USER.Where(u => u.ID == userId).First(); TEACH teach = teacher.TEACHES.Where(t => t.COURSE.ID == courseId).Select(t => new TEACH { COURSE = t.COURSE }).First(); List <TOPIC> topics = teach.COURSE.TOPICs.Select(t => new TOPIC { ID = t.ID, TITLE = t.TITLE, DESCRIPTION = t.DESCRIPTION, COURSE_ID = t.COURSE_ID, DOCUMENTs = t.DOCUMENTs .Select(d => new DOCUMENT { ID = d.ID, TITLE = d.TITLE, DESCRIPTION = d.DESCRIPTION, LINK = d.LINK }) .ToList(), EVENTs = t.EVENTs .Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DESCRIPTION = e.DESCRIPTION, STARTDATE = e.STARTDATE, DEADLINE = e.DEADLINE }) .ToList() }).ToList(); return(topics); }
public COURSE GetCourseWithEventAndSubmmit(string user_id, string course_id) { C_USER stu = db.C_USER.Where(u => u.ID == user_id).First(); COURSE course = stu.COURSEs.Where(x => x.ID == course_id).Select(x => new COURSE { ID = x.ID, NAME = x.NAME, C_USER = x.C_USER.Where(u => u.ID == user_id).Select(u => new C_USER { FIRST_NAME = u.FIRST_NAME, LAST_NAME = u.LAST_NAME, MIDDLE_NAME = u.MIDDLE_NAME }).ToList(), TOPICs = ((x.TOPICs.Count == 0) ? null : (x.TOPICs.Select(t => new TOPIC { EVENTs = ((t.EVENTs.Count() == 0) ? null : (t.EVENTs.Select(e => new EVENT { ID = e.ID, TITLE = e.TITLE, DEADLINE = e.DEADLINE, SUBMITs = ((e.SUBMITs.FirstOrDefault(s => s.USER_ID == user_id) == null) ? null : (e.SUBMITs.Where(s => s.USER_ID == user_id) .Select(s => new SUBMIT { ID = s.ID, LINK = s.LINK, TIME = s.TIME, ASSESSMENT = ((s.ASSESSMENT == null) ? null : new ASSESSMENT { SCORE = ((s.ASSESSMENT == null) ? null : s.ASSESSMENT.SCORE), COMMENT = ((s.ASSESSMENT == null) ? null : s.ASSESSMENT.COMMENT) }) }).ToList())) }).ToList())) }).ToList())) }).FirstOrDefault(); return(course); }
public JsonResult Save(C_USER infostudent) { bool status = false; string message = string.Empty; if (infostudent.ID != null) { try { var model = new InfoStudentDAO().updatestudent(infostudent); status = true; } catch (Exception ex) { status = false; message = ex.Message; } } return(Json(new { status = status, message = message })); }