public static TopicMasterVM GetNotes(int TopicID) { TopicMasterVM tpm = new TopicMasterVM(); tpm.newComment = new TopicNoteCommentVM(); using (QuizContext cntxt = new QuizContext()) { var topic = cntxt.TopicMasters.Find(TopicID); if (topic != null) { tpm.TopicName = topic.TopicName; tpm.TopicDescription = topic.TopicDescription; tpm.TopicMasterId = topic.TopicMasterId; } tpm.TopicNoteVMs = new List <TopicNoteVM>(); var q = cntxt.TopicNotes.Where(u => u.TopicMasterId == TopicID).ToList(); if (q != null) { if (q.Count > 0) { foreach (var element in q) { TopicNoteVM tpnotes = new TopicNoteVM(); tpnotes.TopicNoteId = element.TopicNoteId; tpnotes.NoteTittle = element.NoteTittle; tpnotes.NoteDesc = element.NoteDesc; tpnotes.AddedBy = element.AddedBy; tpnotes.AddedDate = element.AddedDate; var comments = cntxt.TopicNoteComments.Where(u => u.TopicNoteId == tpnotes.TopicNoteId).ToList(); tpnotes.TopicNoteCommentVMs = new List <TopicNoteCommentVM>(); if (comments != null) { if (comments.Count > 0) { foreach (var comment in comments) { TopicNoteCommentVM tpnotescomment = new TopicNoteCommentVM(); tpnotescomment.TopicNoteCommentId = comment.TopicNoteCommentId; tpnotescomment.TopicNoteCommentDesc = comment.TopicNoteCommentDesc; tpnotescomment.AddedDate = comment.AddedDate; tpnotescomment.AddedBy = comment.AddedBy; tpnotes.TopicNoteCommentVMs.Add(tpnotescomment); } } } tpm.TopicNoteVMs.Add(tpnotes); } } } } return(tpm); }
public static List <TopicNoteCommentVM> AddComment(TopicNoteCommentVM topicNoteCommentVM) { List <TopicNoteCommentVM> mycomments = new List <TopicNoteCommentVM>(); using (QuizContext cntxt = new QuizContext()) { TopicNoteComment tpcomment = new TopicNoteComment(); tpcomment.TopicNoteId = topicNoteCommentVM.TopicNoteCommentId; tpcomment.TopicNoteCommentDesc = topicNoteCommentVM.TopicNoteCommentDesc; tpcomment.AddedDate = DateTime.Now; tpcomment.AddedBy = topicNoteCommentVM.AddedBy; cntxt.TopicNoteComments.Add(tpcomment); cntxt.SaveChanges(); var comments = cntxt.TopicNoteComments.Where(u => u.TopicNoteId == topicNoteCommentVM.TopicNoteId).ToList(); if (comments != null) { if (comments.Count > 0) { foreach (var comment in comments) { TopicNoteCommentVM tpnotescomment = new TopicNoteCommentVM(); tpnotescomment.TopicNoteCommentId = comment.TopicNoteCommentId; tpnotescomment.TopicNoteCommentDesc = comment.TopicNoteCommentDesc; tpnotescomment.AddedDate = comment.AddedDate; tpnotescomment.AddedBy = comment.AddedBy; mycomments.Add(tpnotescomment); } } } } return(mycomments); }
public List <TopicNoteCommentVM> Post(TopicNoteCommentVM topicNoteCommentVM) { return(TopicNotesRepo.AddComment(topicNoteCommentVM)); }