/// <summary> /// Adds New subject to the database using SubjectName /// </summary> /// <param name="SubjectName">New Subject Name</param> public void AddSubject(string SubjectName) { EAD.Subject addedSubject = new EAD.Subject(); addedSubject.Subject_Name = SubjectName; try { db.Subject.Add(addedSubject); //adds object to database db.SaveChanges(); } catch (Exception ex) { //to do } }
/// <summary> /// This Method Deletes a subject /// </summary> /// <param name="SubjectName">The name of the Subject up for deletion</param> public void DeleteSubject(string SubjectName) { int subjectID = 0; EAD.Subject removedSubject = new EAD.Subject(); try { //Gets the subjectID which will be needed so it can be removed foreach (var item in db.Subject) { if (item.Subject_Name == SubjectName) { subjectID = item.Subject_ID; removedSubject = item; //keeps a reference to the subject that will be removed } } } catch (Exception ex) { // to do } try { //Removes all references to the subject in the database foreach (var item in db.Subject_Categories) //For each row in the Subject Categories Junction Table { if (item.Subject_ID == subjectID) { db.Subject_Categories.Remove(item); //Remove the row from the junction table } } } catch (Exception ex) { //to do } try { db.Subject.Remove(removedSubject); // removes the subject from the subtopic table. db.SaveChanges(); } catch (Exception ex) { //to do } }