/// <summary> /// Delete An Exam Using the ExamTemplateID /// </summary> /// <param name="ExamTID">The ExamTemplateID of the exam to be deleted</param> public void DeleteExam(string ExamTID) { EAD.ExamTemplate removedExam = new EAD.ExamTemplate(); try { foreach (var item in db.ExamTemplate) //Gets the Exam which will be needed so it can be removed { if (item.ExamTemplateID.Equals(ExamTID)) { removedExam = item; } } foreach (var item in db.ExamTemplateQuestions) //Removes all references to the Exam in the database { if (item.ExamTemplateID == ExamTID) { db.ExamTemplateQuestions.Remove(item); //Delete from Junction Table } } db.ExamTemplate.Remove(removedExam); // removes the ExamTemplate from the ExamTemplate table. db.SaveChanges(); } catch (Exception ex) { //TODO } }
/// <summary> /// This Method adds a brand new exam to the database. The Parameters passed in defines the new values in the database /// </summary> /// <param name="exName">The name of the Exam</param> /// <param name="exTID">The Exam Template ID</param> /// <param name="ExamType">The Exam Type</param> public void AddNewExam(string exName, string exTID, string ExamType) { EAD.ExamTemplate newExt = new EAD.ExamTemplate(); newExt.ExamTemplateName = exName; newExt.ExamTemplateID = exTID; newExt.ExamTypeID = db.ExamType.Where(x => x.ExamTypeName == ExamType).Select(x => x.PKID).First(); // newExt.CreatedDate = DateTime.Now; //generates the current DateTime try { db.ExamTemplate.Add(newExt); // adds the new exam template to the database db.SaveChanges(); } catch (Exception ex) { // to do } }