public static bool CheckIfTestCreated(int idPerson) { using (var db = new FriendTestEntities()) { return(db.Test.Any(t => t.ID_Person == idPerson)); } }
public static bool CheckIfTestPassed(int idPerson, int idCreator) { using (var db = new FriendTestEntities()) { return(db.Result.Any(r => r.ID_PersonQuestioner == idCreator && r.ID_PersonRespondent == idPerson)); } }
public static void RemoveQuestion(Question que) { using (var db = new FriendTestEntities()) { int id = que.ID; var answers = from ans in db.Answer where ans.ID_question == id select ans; foreach (Answer item in answers) { db.Answer.Remove(item); } db.SaveChanges(); var quest = from q in db.Question where q.ID == id select q; foreach (Question q in quest) { db.Question.Remove(q); } db.SaveChanges(); } }