public int EditClass(Class newClass) { User newInstructor = context.Users.SingleOrDefault(u => u.userName == newClass.Instructor); if (newInstructor != null) //if the given Instructor is a real user { context.Entry(newClass).State = System.Data.EntityState.Modified; // get the id of the class that was just inserted. int classID = (from n in context.Classes orderby n.ID descending select n.ID).FirstOrDefault(); int instructorID = newInstructor.id; // only add instructor if they aren't already the instructor. if (context.InstructorRosterEntries.SingleOrDefault(n => n.InstuctorID == instructorID && n.ClassID == classID) == null) AddInstructor(classID, instructorID); } var result = context.SaveChanges(); return result; }
public Class AddClass(string username, int courseid, string instructor, int sizelimit, DateTime startDate, DateTime endDate, string title, string description, string location, string openRegistration) { var newClass = new Class { CourseID = courseid, Instructor = instructor, SizeLimit = sizelimit, StartDate = startDate, EndDate = endDate, CreatedBy = username, CreatedOn = DateTime.Now, Title = title, Description = description, location = location }; newClass.CourseNumber = GetCourse(newClass.CourseID).CourseNumber; if (openRegistration.Equals("true,false")) newClass.OpenRegistration = true; if (title.Equals("")) newClass.Title = GetCourse(newClass.CourseID).Title; if (description.Equals("")) newClass.Description = GetCourse(newClass.CourseID).Description; if ((location.Equals("")) && (GetCourse(newClass.CourseID).SelfStudy == true)) newClass.location = "virtual"; User newInstructor = context.Users.SingleOrDefault(u => u.userName == instructor); if (newInstructor != null) //if the given Instructor is a real user { context.Classes.Add(newClass); context.SaveChanges(); // get the id of the class that was just inserted. int classID = (from n in context.Classes orderby n.ID descending select n.ID).FirstOrDefault(); int InstructorID = newInstructor.id; AddInstructor(classID, InstructorID); } return newClass; // will return null if the instructor's name was not found }
public void DeleteClass(Class rClass) { foreach (var student in rClass.roster.ToList()) { DropRoster(student); } foreach (var instructor in rClass.InstructorRosterEntries.ToList()) { DropInstructorRoster(instructor); } foreach (var ClassHour in rClass.ClassHours.ToList()) { DeleteClasshour(ClassHour); } foreach (var test in rClass.TestsInClasses.ToList()) { context.TestsInClasses.Remove(test); } context.Classes.Remove(rClass); }
//changes the value representing number of users enrolled in a class. For use when adding/dropping classes. public int AdjustCurrentEnrolled(int amount, Class thisClass) { thisClass.CurrentEnrolled = thisClass.CurrentEnrolled + amount; var result = context.SaveChanges(); return result; }
public ActionResult Edit(Class newClass) { var result = repository.EditClass(newClass); if (result > 0) TempData["message"] = string.Format("class with ID {0} has been saved.", newClass.ID); else TempData["message"] = string.Format("Unsuccessful procedure!"); return RedirectToAction("ClassList/" + Session["CourseID"]); }
private String getTest(Class Class) { String value; try { value = Class.TestsInClasses.First(i => i.ClassID >= 0).Test.Identifier.ToString(); } catch { value = "No Test"; } return value; }
private String getDropString(Class n) { String value; try{ if (n.TestsInClasses.Count > 0) { value = "<a href=\"Test/DropTest/" + n.ID.ToString() + "\">Drop Test</a>"; } else { value = ""; } }catch{ value = ""; } return value; }