public bool AddSkill(int courseId, SetAvailableCoursesDto mentordetails)
{
try
{
var course = context.Courses.Where(c => c.Id == courseId).SingleOrDefault();
var ifExists = context.AvailableCourses.Where(ac =>
ac.MentorEmail == mentordetails.Email && ac.CourseDetails == course).SingleOrDefault();
if (ifExists == null)
{
var skill = new AvailableCourses
{
CourseDetails = course,
MentorFname = mentordetails.FName,
MentorLname = mentordetails.LName,
MentorEmail = mentordetails.Email
};
context.AvailableCourses.Add(skill);
var result = context.SaveChanges();
if (result > 0)
{
return(true);
}
return(false);
}
return(false);
}
catch (Exception e)
{
throw;
}
}
public void Initialize(Person connectedPerson)
{
ConnectedPerson = connectedPerson;
ResetAll();
if (HasRequiredPermissions)
{
// Get the school data and use to it to populate this View Model's data
SchoolEntities schoolData = new SchoolEntities();
// Create a list of all the classes in the school
schoolData.Classes.ToList().ForEach(currClass => AvailableClasses.Add(currClass.classID, currClass.className));
AvailableHomeroomClasses.Add(FIELD_NOT_SET, "לא מוגדר");
schoolData.Classes.Where(currClass => currClass.Teachers.Count() == 0).ToList()
.ForEach(currClass => AvailableHomeroomClasses.Add(currClass.classID, currClass.className));
// Create a list of all the parents in the school
AvailableParents.Add(FIELD_NOT_SET, "לא מוגדר");
schoolData.Persons.Where(p => p.isParent).ToList()
.ForEach(parent => AvailableParents.Add(parent.personID, parent.firstName + " " + parent.lastName));
// Create a list of all the students in the school
schoolData.Persons.Where(p => p.isStudent).ToList()
.ForEach(student => AvailableStudents.Add(student.personID, student.firstName + " " + student.lastName));
// Create a list of all the courses in the school
schoolData.Courses.Where(course => course.isHomeroomTeacherOnly == false).ToList()
.ForEach(course => AvailableCoursesMustChoose.Add(course.courseID, course.courseName));
AvailableCourses.Add(FIELD_NOT_SET, "לא מוגדר");
AvailableCoursesMustChoose.ToList().ForEach(course => AvailableCourses.Add(course.Key, course.Value));
}
}
// Clears all the data in this View Model
private void ResetAll()
{
// Reset all of the lists
AvailableClasses.Clear();
AvailableParents.Clear();
AvailableStudents.Clear();
AvailableCourses.Clear();
AvailableCoursesMustChoose.Clear();
AvailableHomeroomClasses.Clear();
// Reset all properties
Username = "";
FirstName = "";
LastName = "";
Email = "";
Phone = "";
Birthdate = new DateTime();
IsNewStudent = false;
IsNewTeacher = false;
IsNewParent = false;
IsNewSecretary = false;
SelectedHomeroomClass = null;
SelectedParent = null;
SelectedStudent = null;
SelectedClass = null;
SelectedCourse1 = null;
SelectedCourse2 = null;
SelectedCourse3 = null;
SelectedCourse4 = null;
}
public ActionResult DeleteConfirmed(int id)
{
AvailableCourses availableCourses = db.AvailableCourses.Find(id);
db.AvailableCourses.Remove(availableCourses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Initialize(Person connectedPerson)
{
// Reset all information
ConnectedPerson = connectedPerson;
AvailableUserTypes.Clear();
AvailableUsers.Clear();
AvailableClasses.Clear();
AvailableParents.Clear();
AvailableStudents.Clear();
AvailableCourses.Clear();
AvailableCoursesMustChoose.Clear();
AvailableHomeroomClasses.Clear();
if (HasRequiredPermissions)
{
_schoolData = new SchoolEntities();
// Create a list of all the editable user types
if (!CanEditManagement)
{
AvailableUserTypes.AddRange(new List <string>()
{
Globals.USER_TYPE_STUDENT, Globals.USER_TYPE_TEACHERS, Globals.USER_TYPE_PARENTS
});
}
else
{
AvailableUserTypes.AddRange(new List <string>()
{
Globals.USER_TYPE_STUDENT, Globals.USER_TYPE_TEACHERS, Globals.USER_TYPE_PARENTS,
Globals.USER_TYPE_SECRETARIES, Globals.USER_TYPE_PRINCIPAL
});
}
SelectedUserType = AvailableUserTypes[0];
// Create a list of all the classes in the school
_schoolData.Classes.ToList().ForEach(currClass => AvailableClasses.Add(currClass.classID, currClass.className));
AvailableHomeroomClasses.Add(FIELD_NOT_SET, "לא מוגדר");
_schoolData.Classes.Where(currClass => currClass.Teachers.Count() == 0).ToList()
.ForEach(currClass => AvailableHomeroomClasses.Add(currClass.classID, currClass.className));
// Create a list of all the parents in the school
AvailableParents.Add(FIELD_NOT_SET, "לא מוגדר");
_schoolData.Persons.Where(p => p.isParent).ToList()
.ForEach(parent => AvailableParents.Add(parent.personID, parent.firstName + " " + parent.lastName));
// Create a list of all the students in the school
_schoolData.Persons.Where(p => p.isStudent).ToList()
.ForEach(student => AvailableStudents.Add(student.personID, student.firstName + " " + student.lastName));
// Create a list of all the courses in the school
_schoolData.Courses.Where(course => course.isHomeroomTeacherOnly == false).ToList()
.ForEach(course => AvailableCoursesMustChoose.Add(course.courseID, course.courseName));
AvailableCourses.Add(FIELD_NOT_SET, "לא מוגדר");
AvailableCoursesMustChoose.ToList().ForEach(course => AvailableCourses.Add(course.Key, course.Value));
}
}
public ActionResult SearchAndRegister(AvailableCourses model, int?id)
{
if (id == 0)
{
RedirectToAction("Search");
}
Students user = new StudentsController().QueryStudentID(User.Identity.GetUserId());
var taken = from s in db.Registrations
where s.StudentID == user.StudentID
select s.AvailableCourseID;
var NotTaken = from s in db.AvailableCourses.OrderByDescending(x => x.SemesterYear.Years.Year).ThenBy(x => x.SemesterYear.SemesterID).ThenBy(x => x.Courses.Departments.DepartmentName).ThenBy(x => x.Courses.CourseNumber)
where !taken.Contains(s.AvailalbeCourseID) && s.Courses.DepartmentID == id
select s;
var search = (from s in NotTaken
select s);
if (model.CourseID != 0)
{
search = (from s in search
where (model.CourseID == s.CourseID)
select s);
}
if (model.SemesterYearID != 0)
{
search = (from s in search
where (model.SemesterYearID == s.SemesterYearID)
select s);
}
var SemesterYear = (from s in db.SemesterYear.OrderByDescending(x => x.Years.Year).ThenByDescending(x => x.SemesterID).AsEnumerable()
select new SelectListItem
{
Text = s.SemesterYearName,
Value = s.SemesterYearID.ToString()
}).ToList();
var Course = (from s in db.Courses.OrderBy(x => x.Departments.Abbreviation).ThenBy(x => x.CourseNumber).AsEnumerable()
where s.DepartmentID == id
select new SelectListItem
{
Text = s.CourseName,
Value = s.CourseID.ToString()
}).ToList();
ViewBag.SemesterYearID = new SelectList(SemesterYear, "Value", "Text");
ViewBag.CourseID = new SelectList(Course, "Value", "Text");
ViewData["Course"] = search.OrderByDescending(x => x.SemesterYear.Years.Year).ThenByDescending(x => x.SemesterYear.SemesterID).ThenBy(x => x.Courses.Departments.DepartmentName).ThenBy(x => x.Courses.CourseNumber);
return(View());
}
public ActionResult RegisterStudent(int id)
{
Registrations reg = new Registrations();
Students user = new StudentsController().QueryStudentID(User.Identity.GetUserId());
AvailableCourses course = db.AvailableCourses.Find(id);
reg.AvailableCourseID = id;
reg.StudentID = user.StudentID;
db.Registrations.Add(reg);
db.SaveChanges();
return(RedirectToAction("Search"));
}
public ActionResult Index1(AvailableCourses model, int?id)
{
if (id == 0)
{
RedirectToAction("Index");
}
var search = (from s in db.AvailableCourses
select s);
if (model.CourseID != 0)
{
search = (from s in search
where (model.CourseID == s.CourseID)
select s);
}
if (model.SemesterYearID != 0)
{
search = (from s in search
where (model.SemesterYearID == s.SemesterYearID)
select s);
}
var SemesterYear = (from s in db.SemesterYear.OrderByDescending(x => x.Years.Year).ThenByDescending(x => x.SemesterID).AsEnumerable()
select new SelectListItem
{
Text = s.SemesterYearName,
Value = s.SemesterYearID.ToString()
}).ToList();
var Course = (from s in db.Courses.OrderBy(x => x.Departments.Abbreviation).ThenBy(x => x.CourseNumber).AsEnumerable()
where s.DepartmentID == id
select new SelectListItem
{
Text = s.CourseName,
Value = s.CourseID.ToString()
}).ToList();
ViewBag.SemesterYearID = new SelectList(SemesterYear, "Value", "Text");
ViewBag.CourseID = new SelectList(Course, "Value", "Text");
var availableCourses = db.AvailableCourses.Include(a => a.Buildings).Include(a => a.Courses).Include(a => a.Days).Include(a => a.Professors).Include(a => a.SemesterYear).Include(a => a.Times);
ViewBag.Courses = (from s in search
where s.Courses.DepartmentID == id
select s).OrderByDescending(x => x.SemesterYear.Years.Year).ThenBy(x => x.SemesterYear.SemesterID).ThenBy(x => x.Courses.Departments.DepartmentName).ToList();
return(View());
}
public ActionResult RegisterStudent(int?id)
{
if (User.Identity.IsAuthenticated && id != null)
{
AvailableCourses Course = db.AvailableCourses.Find(id);
return(View(Course));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AvailableCourses availableCourses = db.AvailableCourses.Find(id);
if (availableCourses == null)
{
return(HttpNotFound());
}
return(View(availableCourses));
}
public ActionResult Edit([Bind(Include = "AvailalbeCourseID,CourseID,Section,CRN,TimeID,DayID,BuildingID,ProfessorID,SemesterYearID,RoomNumber")] AvailableCourses availableCourses)
{
if (ModelState.IsValid)
{
db.Entry(availableCourses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BuildingID = new SelectList(db.Buildings, "BuildingID", "Abbreviaion", availableCourses.BuildingID);
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", availableCourses.CourseID);
ViewBag.DayID = new SelectList(db.Days, "DaysID", "Day", availableCourses.DayID);
ViewBag.ProfessorID = new SelectList(db.Professors, "ProfessorID", "LastName", availableCourses.ProfessorID);
ViewBag.SemesterYearID = new SelectList(db.SemesterYear, "SemesterYearID", "SemesterYearName", availableCourses.SemesterYearID);
ViewBag.TimeID = new SelectList(db.Times, "TimeID", "Times1", availableCourses.TimeID);
return(View(availableCourses));
}
public LearnableEditor(List <CourseModel> courseList, LearnableModel word)
{
InitializeComponent();
this.DataContext = this;
Word = new LearnableModel {
LearnableID = word.LearnableID,
CourseID = word.CourseID,
English = word.English,
Hungarian = word.Hungarian,
WordClass = word.WordClass,
PictureUrl = word.PictureUrl
};
AvailableCourses = courseList.Select(c => new CourseModel {
CourseID = c.CourseID,
Name = c.Name
}).ToList();
SelectedCourse = AvailableCourses.Single(c => c.CourseID == Word.CourseID);
}
public ActionResult Index(AvailableCourses model)
{
if (model.Courses.DepartmentID != 0)
{
return(RedirectToAction("Index1", new { id = model.Courses.DepartmentID }));
}
else
{
var availableCourses = db.AvailableCourses.Include(a => a.Buildings).Include(a => a.Courses).Include(a => a.Days).Include(a => a.Professors).Include(a => a.SemesterYear).Include(a => a.Times);
ViewBag.Courses = availableCourses.ToList();
ViewBag.Departments = from s in db.Departments
select new SelectListItem
{
Text = s.DepartmentName,
Value = s.DepartmentID.ToString()
};
return(View());
}
}
public ActionResult CopyAvailableSubjectsPartial([ModelBinder(typeof(DevExpressEditorsBinder))]
AvailableCourses item,
[ModelBinder(typeof(DevExpressEditorsBinder))]
bool?isPost)
{
if (item == null)
{
return(PartialView(item));
}
var availableCourses = unitOfWork.AvailableCoursesRepo
.Fetch(m => m.SchoolYearId == item.SchoolYearId && m.AvailableSubjects.Any()).ToList();
ViewBag.AvailableCourses = availableCourses;
if (isPost == true)
{
foreach (var i in unitOfWork.AvailableSubjectsRepo.Get(x =>
x.AvailableCourseId == item.AvailableCourseId))
{
var course = unitOfWork.AvailableCoursesRepo.Find(m => m.Id == item.DestinationAvailableCourseId);
i.SubjectCode = new IdHelpers().GenerateSubjectCode(course.Id);
var schedulesHelper = new SchedulesHelper();
var availableSuject = new Models.AvailableSubjects()
{
AvailableCourseId = item.DestinationAvailableCourseId,
Schedule = i.Schedule,
SubjectCode = i.SubjectCode,
SubjectId = i.SubjectId,
TeacherId = i.TeacherId,
};
schedulesHelper.GenerateSchedule(availableSuject);
unitOfWork.AvailableSubjectsRepo.Insert(availableSuject);
unitOfWork.Save();
}
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
return(PartialView(item));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AvailableCourses availableCourses = db.AvailableCourses.Find(id);
if (availableCourses == null)
{
return(HttpNotFound());
}
ViewBag.BuildingID = new SelectList(db.Buildings, "BuildingID", "Abbreviaion", availableCourses.BuildingID);
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", availableCourses.CourseID);
ViewBag.DayID = new SelectList(db.Days, "DaysID", "Day", availableCourses.DayID);
ViewBag.ProfessorID = new SelectList(db.Professors, "ProfessorID", "LastName", availableCourses.ProfessorID);
ViewBag.SemesterYearID = new SelectList(db.SemesterYear, "SemesterYearID", "SemesterYearName", availableCourses.SemesterYearID);
ViewBag.TimeID = new SelectList(db.Times, "TimeID", "Times1", availableCourses.TimeID);
return(View(availableCourses));
}
public LearnableEditor(List <CourseModel> courseList, CourseModel selectedCourse)
{
InitializeComponent();
this.DataContext = this;
Word = new LearnableModel();
AvailableCourses = courseList.Select(c => new CourseModel
{
CourseID = c.CourseID,
Name = c.Name
}).ToList();
if (selectedCourse == null)
{
SelectedCourse = null;
}
else
{
SelectedCourse = AvailableCourses.Single(c => c.CourseID == selectedCourse.CourseID);
}
}
public ActionResult Search(AvailableCourses model)
{
if (model.Courses.DepartmentID != 0)
{
return(RedirectToAction("SearchAndRegister", new { id = model.Courses.DepartmentID }));
}
else
{
if (User.Identity.IsAuthenticated)
{
Students user = new StudentsController().QueryStudentID(User.Identity.GetUserId());
var taken = from s in db.Registrations
where s.StudentID == user.StudentID
select s.AvailableCourseID;
var Courses = from s in db.AvailableCourses.OrderByDescending(x => x.SemesterYear.Years.Year).ThenByDescending(x => x.SemesterYear.SemesterID).ThenBy(x => x.Courses.Departments.DepartmentName).ThenBy(x => x.Courses.CourseNumber)
where !taken.Contains(s.AvailalbeCourseID)
select s;
var Department = (from s in db.Departments
select new SelectListItem
{
Text = s.DepartmentName,
Value = s.DepartmentID.ToString()
}).ToList();
ViewBag.Departments = Department;
ViewData["Course"] = Courses.ToList();
return(View());
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
}
/// <summary>
/// Assistant method that clears all the ViewModel properties
/// </summary>
private void ResetData()
{
AvailableSearchChoices.Clear();
LessonsTableData.Clear();
AvailableClasses.Clear();
AvailableCourses.Clear();
AvailableTeachers.Clear();
AvailableRooms.Clear();
SelectedLesson = null;
SelectedSearchChoice = NOT_ASSIGNED;
SelectedTeacher = NOT_ASSIGNED;
SelectedClass = NOT_ASSIGNED;
LessonFirstDay = NOT_ASSIGNED;
LessonSecondDay = NOT_ASSIGNED;
LessonThirdDay = NOT_ASSIGNED;
LessonFourthDay = NOT_ASSIGNED;
LessonFirstHour = NOT_ASSIGNED;
LessonSecondHour = NOT_ASSIGNED;
LessonThirdHour = NOT_ASSIGNED;
LessonFourthHour = NOT_ASSIGNED;
}
public void Initialize(Person connectedPerson)
{
ConnectedPerson = connectedPerson;
ResetData();
// Create the lists of possible classes, courses, teachers
_schoolData.Classes.ToList().ForEach(schoolClass => AvailableClasses.Add(schoolClass.classID, schoolClass.className));
_schoolData.Courses.ToList().ForEach(course => AvailableCourses.Add(course.courseID, course.courseName));
_schoolData.Teachers.Where(teacher => !teacher.Person.User.isDisabled).ToList()
.ForEach(teacher => AvailableTeachers.Add(teacher.teacherID, teacher.Person.firstName + " " + teacher.Person.lastName));
// Initialize the rooms list. Note that a room is optional and therefore has a NOT_ASSIGNED option
AvailableRooms.Add(NOT_ASSIGNED, "ללא");
_schoolData.Rooms.ToList().ForEach(room => AvailableRooms.Add(room.roomID, room.roomName));
SearchingByClass = true;
// For some reason, after re-initializing this view, the selections are not updated properly in the view unless called again
OnPropertyChanged("SelectedClass");
OnPropertyChanged("SelectedCourse");
OnPropertyChanged("SelectedTeacher");
OnPropertyChanged("SelectedRoom");
}
