public ActionResult Student(Account account)
{
var StudentsDal = new StudentsDal();
var username = account.ID;
var StudentsUser = (from x in StudentsDal.Students where x.ID.Equals(username) select x).ToList <Student>();
var StudentCourseDal = new StudentCourseDal();
var studentCourseObj = (from x in StudentCourseDal.StudentCourses where x.StudentID.Equals(username) select x).ToList <StudentCourse>();
var CoursesDal = new CoursesDal();
List <Courses> CourseDetail = new List <Courses>();
Courses t = new Courses();
foreach (StudentCourse y in studentCourseObj)
{
t = (from x in CoursesDal.Courses where x.CourseName.Equals(y.CourseName) select x).FirstOrDefault <Courses>();
CourseDetail.Add(t);
}
Student student = new Student()
{
ID = account.ID,
FirstName = StudentsUser[0].FirstName,
LastName = StudentsUser[0].LastName,
};
StudentViewModel studentViewModel = new StudentViewModel()
{
student = student,
courses = CourseDetail,
studentCourses = studentCourseObj
};
return(View(studentViewModel));
}
public ActionResult Faculty(Account account)
{
string id = account.ID;
faculy_id = id;
var LecturerDal = new LecturerDal();
var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>();
var FacultyDal = new FacultyDal();
var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(id) select x).ToList <Faculty>();
var CourseDal = new CoursesDal();
var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>();
var StudentsDal = new StudentsDal();
var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>();
Faculty faculty = new Faculty()
{
ID = account.ID,
FirstName = FacultyObj[0].FirstName,
LastName = FacultyObj[0].LastName
};
FacultyViewModel facultyViewModel = new FacultyViewModel()
{
faculty = faculty,
Coursesdata = CourseObj,
Studentsdata = StudentsObj,
LecturersData = LecturerObj
};
return(View(facultyViewModel));
}
public ActionResult EditStudent(string id, string course, FormCollection collection)//---> gets course name, delete the row of it and add new row with changes from the faculty
{
DateTime now = DateTime.Now;
StudentsDal dal = new StudentsDal();
ExamsDal dalEx = new ExamsDal();
Students sd = dal.students.Find(id, course);
List <Exams> ex = (from x in dalEx.exams
where x.CourseId.Contains(sd.CourseName)
select x).ToList <Exams>();
foreach (Exams e in ex)
{
DateTime MoedADate = DateTime.Parse(e.MoedADate);
DateTime MoedBDate = DateTime.Parse(e.MoedBDate);
int resultA = DateTime.Compare(MoedADate, now.Date);
if (resultA > 0)
{
return(RedirectToAction("ErrorPageAddGrade"));
}
int resultB = DateTime.Compare(MoedBDate, now.Date);
if (resultB > 0)
{
return(RedirectToAction("ErrorPageAddGrade"));
}
}
dal.students.Remove(sd);
dal.SaveChanges();
Students stud = new Students()
{
FirstName = collection["FirstName"],
LastName = collection["LastName"],
Id = collection["Id"],
CourseName = collection["CourseName"],
GradeMoedA = collection["GradeMoedA"],
GradeMoedB = collection["GradeMoedB"],
FinalGrade = collection["FinalGrade"]
};
if (ModelState.IsValid)
{
try
{
(from s in dal.students
where s.Id == id
select s).ToList();
dal.students.Add(stud);
dal.SaveChanges();
}
catch (Exception)
{
TempData["error"] = "The course already exist!\n"; // print error message
return(View());
}
}
return(View("Home"));
}
public JsonResult Get()
{
if ((string)Session["Power"] != "1")
{
return(Json("0"));
}
return(Json(StudentsDal.List(), JsonRequestBehavior.AllowGet));
}
public JsonResult Add(Students s)
{
if ((string)Session["Power"] != "1")
{
return(Json("0"));
}
StudentsDal.Add(s);
return(Json(StudentsDal.List()));
}
public JsonResult Edit(Students s)
{
if ((string)Session["Power"] != "1")
{
return(Json("0"));
}
StudentsDal.Edit(s, s.Id);
return(Json(StudentsDal.List()));
}
public JsonResult Delete(int id)
{
if ((string)Session["Power"] != "1")
{
return(Json("0"));
}
StudentsDal.Del(id);
return(Json(StudentsDal.List()));
}
public ActionResult EditGrade(string id, string course)//---> gets course id and name and return all the info about it
{
StudentsDal dalS = new StudentsDal();
List <Students> objStudents = (from x in dalS.students
where x.Id.Contains(id) && x.CourseName.Contains(course)
select x).ToList <Students>();
Students svm = new Students();
svm = objStudents[0];
return(View(svm));
}
public ActionResult StudentToCourse(string StudentID, string CourseName)
{
var LecturerDal = new LecturerDal();
var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>();
var StudentCourseDal = new StudentCourseDal();
var FacultyDal = new FacultyDal();
var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>();
var CourseDal = new CoursesDal();
var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>();
var StudentsDal = new StudentsDal();
var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>();
Faculty faculty = new Faculty()
{
ID = faculy_id,
FirstName = FacultyObj[0].FirstName,
LastName = FacultyObj[0].LastName
};
FacultyViewModel facultyViewModel = new FacultyViewModel()
{
faculty = faculty,
Coursesdata = CourseObj,
Studentsdata = StudentsObj,
LecturersData = LecturerObj
};
StudentCourse sc = new StudentCourse()
{
CourseName = CourseName,
StudentID = StudentID,
};
if (StudentCourseDal.StudentCourses.Find(sc.StudentID, sc.CourseName) == null)
{
StudentCourseDal.StudentCourses.Add(sc);
StudentCourseDal.SaveChanges();
}
else
{
ViewBag.ErrorMessage2 = "This student is already assigned to this course!";
return(View("Faculty", facultyViewModel));
}
return(View("Faculty", facultyViewModel));
}
public Boolean login(Students students)
{
StudentsDal studentsHelp = new StudentsDal();
return(studentsHelp.login(students));
}
public ActionResult ChangeLecturer(string CourseName, string LectID)
{
var LecturerDal = new LecturerDal();
var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>();
var FacultyDal = new FacultyDal();
var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>();
var CourseDal = new CoursesDal();
var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>();
var StudentsDal = new StudentsDal();
var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>();
Faculty faculty = new Faculty()
{
ID = faculy_id,
FirstName = FacultyObj[0].FirstName,
LastName = FacultyObj[0].LastName
};
FacultyViewModel facultyViewModel = new FacultyViewModel()
{
faculty = faculty,
Coursesdata = CourseObj,
Studentsdata = StudentsObj,
LecturersData = LecturerObj
};
var CourseObj3 = (from x in CourseDal.Courses where x.LectID.Equals(LectID) select x).ToList <Courses>();
var CourseObj2 = (from x in CourseDal.Courses where x.CourseName.Equals(CourseName) select x).First <Courses>();
if (CourseObj2.LectID != LectID && CourseObj2 != null)
{
Courses c = new Courses()
{
CourseName = CourseObj2.CourseName,
Classroom = CourseObj2.Classroom,
Day = CourseObj2.Day,
Hour = CourseObj2.Hour,
MoedA = CourseObj2.MoedA,
MoedB = CourseObj2.MoedB,
LectID = LectID
};
int cnt = 0;
foreach (Courses c_2 in CourseObj3)
{
if (c_2.Day == c.Day && c_2.Hour == c.Hour)
{
cnt++;
}
}
if (cnt == 0)
{
CourseDal.Courses.Remove(CourseObj2);
CourseDal.Courses.Add(c);
CourseDal.SaveChanges();
}
else
{
ViewBag.ErrorMessage3 = "The course lecturer is already registered at this time";
return(View("Faculty", facultyViewModel));
}
}
return(View("Faculty", facultyViewModel));
}
//按照学号查早值
public Students SelectId(Students students)
{
StudentsDal studentsDal = new StudentsDal();
return(studentsDal.SelectId(students));
}
public ActionResult EditCourse(string CourseName, string MoedA, string MoedB, string Day, string Hour, string Classroom)
{
var LecturerDal = new LecturerDal();
var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>();
var CourseDal = new CoursesDal();
var CourseObj2 = (from x in CourseDal.Courses where x.CourseName.Equals(CourseName) select x).First <Courses>();
var FacultyDal = new FacultyDal();
var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>();
var CoursesObj = (from x in CourseDal.Courses select x).ToList <Courses>();
var StudentsDal = new StudentsDal();
var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>();
Faculty faculty = new Faculty()
{
ID = faculy_id,
FirstName = FacultyObj[0].FirstName,
LastName = FacultyObj[0].LastName
};
FacultyViewModel facultyViewModel = new FacultyViewModel()
{
faculty = faculty,
Coursesdata = CoursesObj,
Studentsdata = StudentsObj,
LecturersData = LecturerObj
};
Courses CourseObj = new Courses()
{
CourseName = CourseName,
Day = Day,
Hour = Hour,
Classroom = Classroom,
MoedA = MoedA,
MoedB = MoedB,
LectID = CourseObj2.LectID
};
int cnt = 0;
foreach (Courses c in CourseDal.Courses)
{
if (c.Day == CourseObj.Day && c.Hour == CourseObj.Hour && c.Classroom == CourseObj.Classroom)
{
cnt++;
}
}
if (cnt == 1)
{
ViewBag.ErrorMessage = "The course lecturer is already registered at this time";
return(View("Faculty", facultyViewModel));
}
else
{
CourseDal.Courses.Remove(CourseObj2);
CourseDal.SaveChanges();
CourseDal.Courses.Add(CourseObj);
CourseDal.SaveChanges();
}
return(View("Faculty", facultyViewModel));
}
public int UpdateM(Students students)
{
StudentsDal studentsDal = new StudentsDal();
return(studentsDal.UpdateM(students));
}
public List <Students> GetTable()
{
StudentsDal studentsDal = new StudentsDal();
return(studentsDal.GetTable());
}
public ActionResult Edit(string id, FormCollection collection)//---> gets course id, delete the row of it and add new row with changes from the faculty
{
CoursesDal dalC = new CoursesDal();
StudentsDal dalS = new StudentsDal();
string x = collection["LecturerId"];
string day = collection["Day"];
string StartHour = collection["StartHour"];
string EndHour = collection["EndHour"];
//list of all the courses
List <Courses> CoursesObj = (from c in dalC.courses
select c).ToList <Courses>();
List <Courses> LecturersCourses = (from c in dalC.courses
where c.LecturerId.Contains(x)
select c).ToList <Courses>();
//----------check if the lecturer has another course in this time
foreach (Courses lect in LecturersCourses)
{
List <Courses> Crs = (from c in CoursesObj
where c.CourseId.Contains(lect.CourseId)
select c).ToList <Courses>();
//Courses crss = dal.courses.Find(obj.CourseName);
foreach (Courses c in Crs)
{
if (c.Day == day)
{
if (System.Convert.ToDecimal(c.StartHour) >= System.Convert.ToDecimal(StartHour) &&
System.Convert.ToDecimal(c.StartHour) <= System.Convert.ToDecimal(EndHour) ||
System.Convert.ToDecimal(c.EndHour) >= System.Convert.ToDecimal(StartHour) &&
System.Convert.ToDecimal(c.EndHour) <= System.Convert.ToDecimal(EndHour))
{
return(RedirectToAction("ErrorPageAddCourse"));
}
}
}
}
//----------End check
//----------check if there is a student with another course in this time
List <Students> studentsCourses = (from s in dalS.students
select s).ToList <Students>();
foreach (Students std in studentsCourses)
{
List <Courses> Crs = (from c in CoursesObj
where c.CourseId.Contains(std.CourseName)
select c).ToList <Courses>();
//Courses oneCourse = dalC.courses.Find(std.CourseName);
foreach (Courses c in Crs)
{
if (c.Day == day)
{
if (System.Convert.ToDecimal(c.StartHour) >= System.Convert.ToDecimal(StartHour) &&
System.Convert.ToDecimal(c.StartHour) <= System.Convert.ToDecimal(EndHour) ||
System.Convert.ToDecimal(c.EndHour) >= System.Convert.ToDecimal(StartHour) &&
System.Convert.ToDecimal(c.EndHour) <= System.Convert.ToDecimal(EndHour))
{
return(RedirectToAction("ErrorPageAddStud"));
}
}
}
}
//CoursesDal dal = new CoursesDal();
Courses cr = dalC.courses.Find(id);
dalC.courses.Remove(cr);
dalC.SaveChanges();
Courses course = new Courses()
{
CourseName = collection["CourseName"],
CourseId = collection["CourseId"],
LecturerId = collection["LecturerId"],
ClassRoom = collection["ClassRoom"],
Day = collection["Day"],
Hours = collection["Hours"],
StartHour = collection["StartHour"],
EndHour = collection["EndHour"]
};
if (ModelState.IsValid)
{
try
{
(from c in dalC.courses
where c.CourseName == id
select c).ToList();
dalC.courses.Add(course);
dalC.SaveChanges();
}
catch (Exception)
{
TempData["error"] = "The course already exist!\n"; // print error message
return(View());
}
}
return(View("Home"));
}
public int Add(Students students)
{
StudentsDal studentsHelp = new StudentsDal();
return(studentsHelp.Add(students));
}
public ActionResult AddStudents(Students obj)//send info to db
{
StudentsDal dal = new StudentsDal();
CoursesDal dalC = new CoursesDal();
//list of of the same student and his courses
List <Students> studentsCourses = (from s in dal.students
where s.Id.Contains(obj.Id)
select s).ToList <Students>();
//list of all the courses
List <Courses> CoursesObj = (from c in dalC.courses
select c).ToList <Courses>();
foreach (Students std in studentsCourses)
{
//only one course
List <Courses> Crs = (from c in CoursesObj
where c.CourseId.Contains(std.CourseName)
select c).ToList <Courses>();
Courses cr = dalC.courses.Find(obj.CourseName);
foreach (Courses c in Crs)
{
if (cr.Day == c.Day)
{
if (System.Convert.ToDecimal(cr.StartHour) >= System.Convert.ToDecimal(c.StartHour) &&
System.Convert.ToDecimal(cr.StartHour) <= System.Convert.ToDecimal(c.EndHour) ||
System.Convert.ToDecimal(cr.EndHour) >= System.Convert.ToDecimal(c.StartHour) &&
System.Convert.ToDecimal(cr.EndHour) <= System.Convert.ToDecimal(c.EndHour))
{
return(RedirectToAction("ErrorPageAddStud"));
}
}
}
}
Students students = new Students()
{
FirstName = obj.FirstName,
LastName = obj.LastName,
Id = obj.Id,
CourseName = obj.CourseName,
GradeMoedA = obj.GradeMoedA,
GradeMoedB = obj.GradeMoedB,
FinalGrade = obj.FinalGrade
};
//StudentsDal dal = new StudentsDal();
if (ModelState.IsValid)
{
try
{
dal.students.Add(obj);
dal.SaveChanges();
}
catch (Exception)
{
TempData["error"] = "The course already exist!\n"; // print error message
return(View());
}
}
return(RedirectToAction("Home"));
}
