public ActionResult Index(int?Id, int?page) { int pageSize = 3; int pageNumber = (page ?? 1); MessageReplyViewModel vm = new MessageReplyViewModel() { Contestants = db.Contestants.OrderByDescending(x => x.ID).Take(10).ToList(), Categories = db.Categories.ToList(), KnownTalents = db.KnownTalents.ToList(), Blogs = db.Blogs.ToList(), ChallengeVideos = db.ChallengeVideos.ToList() }; var count = db.Messages.Count(); decimal totalPages = count / (decimal)pageSize; ViewBag.TotalPages = Math.Ceiling(totalPages); vm.Messages = db.Messages .OrderByDescending(x => x.DatePosted).ToPagedList(pageNumber, pageSize); ViewBag.MessagesInOnePage = vm.Messages; ViewBag.PageNumber = pageNumber; if (Id != null) { var replies = db.Replies.Where(x => x.MessageId == Id.Value).OrderByDescending(x => x.ReplyDateTime).ToList(); if (replies != null) { foreach (var rep in replies) { MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply(); reply.ReplyVideo = rep.ReplyVideo; reply.MessageId = rep.MessageId; reply.Id = rep.Id; reply.ReplyMessage = rep.ReplyMessage; reply.ReplyDateTime = rep.ReplyDateTime; reply.MessageDetails = db.Messages.Where(x => x.Id == rep.MessageId).Select(s => s.MessageToPost).FirstOrDefault(); reply.ReplyFrom = rep.ReplyFrom; vm.Replies.Add(reply); } } else { vm.Replies.Add(null); } ViewBag.MessageId = Id.Value; } if (Request.IsAjaxRequest()) { //viewModel=your viewModel return(PartialView("_ChallengeSection", vm)); } else { return(View(vm)); } }
public ActionResult Index(int?Id, int?page, int?courseid) { int teacherid = Convert.ToInt32(Session["Student"]); int schoolid; int classid; //int courseid = Convert.ToInt32(TempData["course"]); var getteacherid = dbContext.Students.Find(teacherid); schoolid = getteacherid.School_Id; classid = getteacherid.Class_Id; int pageSize = 5; int pageNumber = (page ?? 1); MessageReplyViewModel vm = new MessageReplyViewModel(); var count = dbContext.Messages.Count(); decimal totalPages = count / (decimal)pageSize; ViewBag.TotalPages = Math.Ceiling(totalPages); vm.Messages = dbContext.Messages.Where(x => x.Class_Id == classid && x.SchoolId == schoolid && x.courseId == courseid).OrderBy(x => x.DatePosted).ToPagedList(pageNumber, pageSize); ViewBag.MessagesInOnePage = vm.Messages; ViewBag.PageNumber = pageNumber; if (Id != null) { var replies = dbContext.Replies.Where(x => x.MessageId == Id.Value).OrderByDescending(x => x.ReplyDateTime).ToList(); if (replies != null) { foreach (var rep in replies) { MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply(); reply.MessageId = rep.MessageId; reply.Id = rep.Id; reply.ReplyMessage = rep.ReplyMessage; reply.ReplyDateTime = rep.ReplyDateTime; reply.MessageDetails = dbContext.Messages.Where(x => x.Id == rep.MessageId).Select(s => s.MessageToPost).FirstOrDefault(); reply.ReplyFrom = rep.ReplyFrom; vm.Replies.Add(reply); } } else { vm.Replies.Add(null); } ViewBag.MessageId = Id.Value; } return(View(vm)); }
public ActionResult Index(int?Id, int?page, int?idTarea) { int pageSize = 5; int pageNumber = (page ?? 1); MessageReplyViewModel vm = new MessageReplyViewModel(); var count = dbContext.Messages.Count(); //NJB if (idTarea != null) { count = dbContext.Messages.Where(x => x.TareaID == idTarea.Value).Count(); } //NJB decimal totalPages = count / (decimal)pageSize; ViewBag.TotalPages = Math.Ceiling(totalPages); vm.Messages = dbContext.Messages.Where(x => x.TareaID == idTarea.Value) .OrderBy(x => x.DatePosted).ToPagedList(pageNumber, pageSize); ViewBag.MessagesInOnePage = vm.Messages; ViewBag.PageNumber = pageNumber; if (Id != null) { var replies = dbContext.Replies.Where(x => x.MessageId == Id.Value).OrderByDescending(x => x.ReplyDateTime).ToList(); if (replies != null) { foreach (var rep in replies) { MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply(); reply.MessageId = rep.MessageId; reply.Id = rep.Id; reply.ReplyMessage = rep.ReplyMessage; reply.ReplyDateTime = rep.ReplyDateTime; reply.MessageDetails = dbContext.Messages.Where(x => x.Id == rep.MessageId).Select(s => s.MessageToPost).FirstOrDefault(); reply.ReplyFrom = rep.ReplyFrom; vm.Replies.Add(reply); } } else { vm.Replies.Add(null); } ViewBag.MessageId = Id.Value; } //NJB-ID de la tarea ViewBag.idTarea = idTarea; ViewBag.Desc1 = dbContext.Tareas.Where(x => x.TareaID == idTarea).Select(s => s.TareaDescripcion).FirstOrDefault(); ViewBag.Desc2 = dbContext.Tareas.Where(x => x.TareaID == idTarea).Select(s => s.TareaDescripcion2).FirstOrDefault(); // return(View(vm)); }
public ActionResult MessagePassing(int?Id, int?page) { int pageSize = 5; int pageNumber = (page ?? 1); MessageReplyViewModel vm = new MessageReplyViewModel(); ReplyDAL replyDAL = new ReplyDAL(); MessageDAL queDAL = new MessageDAL(); var count = queDAL.MessagesDal.Count(); decimal totalPages = count / (decimal)pageSize; ViewBag.TotalPages = Math.Ceiling(totalPages); vm.Messages = queDAL.MessagesDal .OrderBy(x => x.DatePosted).ToPagedList(pageNumber, pageSize); ViewBag.MessagesInOnePage = vm.Messages; ViewBag.PageNumber = pageNumber; if (Id != null) { var replies = replyDAL.Replies.Where(x => x.MessageId == Id.Value).OrderByDescending(x => x.ReplyDateTime); if (replies != null) { foreach (var rep in replies) { /* MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply();*/ MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply(); reply.MessageId = rep.MessageId; reply.Id = rep.Id; reply.ReplyMessage = rep.ReplyMessage; reply.ReplyDateTime = rep.ReplyDateTime; reply.MessageDetails = vm.Messages.Where(x => x.Id == rep.MessageId).Select(s => s.MessageToPost).FirstOrDefault(); reply.ReplyFrom = rep.ReplyFrom; vm.Replies.Add(reply); } } else { vm.Replies.Add(null); } ViewBag.MessageId = Id.Value; } return(View(vm)); }