public ActionResult CommentReply(int CommentHeadId, string UserComment) { var id = User.Identity.GetUserId(); int count = db.AspnetComments.Count(); AspnetComment commentobj = new AspnetComment(); if (count == 0) { commentobj.ParentCommentId = null; commentobj.Comment = UserComment; commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction(); commentobj.HeadId = CommentHeadId; commentobj.CreatedBy = id; db.AspnetComments.Add(commentobj); db.SaveChanges(); } else { int LastId = db.AspnetComments.OrderByDescending(o => o.Id).FirstOrDefault().Id; commentobj.ParentCommentId = LastId; commentobj.Comment = UserComment; commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction(); commentobj.HeadId = CommentHeadId; commentobj.CreatedBy = id; db.AspnetComments.Add(commentobj); db.SaveChanges(); } return(Json("", JsonRequestBehavior.AllowGet)); }
public ActionResult CommentReply(int CommentHeadId, string UserComment) { var id = User.Identity.GetUserId(); int count = db.AspnetComments.Count(); AspnetComment commentobj = new AspnetComment(); if (count == 0) { commentobj.ParentCommentId = null; commentobj.Comment = UserComment; commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction(); commentobj.HeadId = CommentHeadId; commentobj.CreatedBy = id; db.AspnetComments.Add(commentobj); db.SaveChanges(); } else { int LastId = db.AspnetComments.OrderByDescending(o => o.Id).FirstOrDefault().Id; commentobj.ParentCommentId = LastId; commentobj.Comment = UserComment; commentobj.CreationDate = GetLocalDateTime.GetLocalDateTimeFunction(); commentobj.HeadId = CommentHeadId; commentobj.CreatedBy = id; db.AspnetComments.Add(commentobj); db.SaveChanges(); } var UserNameLog = User.Identity.Name; AspNetUser currentUser = db.AspNetUsers.First(x => x.UserName == UserNameLog); var UserId = User.Identity.GetUserId(); var UserName = db.AspNetUsers.Where(x => x.Id == UserId).FirstOrDefault().Name; var NotificationObj = new AspNetNotification(); NotificationObj.Description = "Teacher " + UserName + " Replied"; NotificationObj.Subject = "Reply To Student Comment"; NotificationObj.SenderID = UserId; NotificationObj.Time = GetLocalDateTime.GetLocalDateTimeFunction(); NotificationObj.Url = "/StudentCourses/CommentsPage1/" + CommentHeadId; db.AspNetNotifications.Add(NotificationObj); db.SaveChanges(); //int? LessonID = db.AspnetComment_Head.Where(x => x.Id == CommentHeadId).FirstOrDefault().LessonId; //int? TopicId = db.AspnetLessons.Where(x => x.Id == LessonID).FirstOrDefault().TopicId; //int? SubjectId = db.AspnetSubjectTopics.Where(x => x.Id == TopicId).FirstOrDefault().SubjectId; //var AllStudents = db.Student_GenericSubjects.Where(x => x.GenericSubjectId == SubjectId).Select(x => x.StudentId); //var DistinctStudents = AllStudents.Distinct(); //foreach (var receiver in DistinctStudents) //{ var receiver = db.AspnetComment_Head.Where(x => x.Id == CommentHeadId).Select(x => x.CreatedBy).FirstOrDefault(); SEA_DatabaseEntities db2 = new SEA_DatabaseEntities(); var notificationRecieve = new AspNetNotification_User(); notificationRecieve.NotificationID = NotificationObj.Id; notificationRecieve.UserID = Convert.ToString(receiver); notificationRecieve.Seen = false; db2.AspNetNotification_User.Add(notificationRecieve); db2.SaveChanges(); // } return(Json("", JsonRequestBehavior.AllowGet)); }