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