public IActionResult AdminPost(int id) { ArtGalleryContext context = new ArtGalleryContext(); AdminPostViewModel PostVM = new AdminPostViewModel(); var post = context.Post.Where(A => A.PostId == id).FirstOrDefault(); var comments = context.Comment.Where(C => C.PostId == id).ToList(); var images = context.Image.Where(I => I.PostId == id).ToList(); var File = context.Files.Where(I => I.PostId == id).ToList(); var tags = context.PostTag.Include(T => T.Tag).Where(PT => PT.PostId == id).ToList(); var account = context.Account.Where(A => A.Id == post.AccountId).FirstOrDefault(); PostVM.Post = post; PostVM.ImageName = images.Where(I => I.IsPrimary == true).Select(I => I.ImageName).FirstOrDefault(); PostVM.Comments = comments; PostVM.Images = (IEnumerable <string>)images.Select(I => I.ImageName); PostVM.PostTags = (IEnumerable <PostTag>)tags; PostVM.FileName = (IEnumerable <string>)File.Select(F => F.FileName); PostVM.Account = account; var CurrentUserId = _userManager.GetUserId(User as ClaimsPrincipal); var AccountFirstName = context.Account.Where(A => A.Id == CurrentUserId).Select(A => A.FirstName).FirstOrDefault(); var ProfileImageName = context.ProfileImage.Where(PI => PI.AccountId == CurrentUserId).Select(PI => PI.ImageName).FirstOrDefault(); PostVM.FullName = AccountFirstName; PostVM.ProfilePicture = ProfileImageName; return(View(PostVM)); }
public PartialViewResult Search(String veri = "") { List <Post> filteredPosts = db.Posts.Where(x => x.Description.Contains(veri) || x.Title.Contains(veri)).ToList(); AdminPostViewModel apm = new AdminPostViewModel(); apm.Posts = filteredPosts; return(PartialView("SearchView", apm)); }
// GET: Home public ActionResult Index() { db.Database.Initialize(true); AdminPostViewModel apm = new AdminPostViewModel(); List <Post> post = db.Posts.OrderByDescending(x => x.PublishDate).ToList(); apm.Posts = post; return(View(apm)); }
public ActionResult Posts_Update([DataSourceRequest]DataSourceRequest request, AdminPostViewModel post) { if (this.ModelState.IsValid) { var entity = this.posts.GetById(post.Id); entity.Title = post.Title; entity.Content = post.Content; this.posts.Save(); } return this.Json(new[] { post }.ToDataSourceResult(request, this.ModelState)); }
public ActionResult AdminView() { //TODO// if (Session["Id"] != null) { String sessionId = Session["Id"].ToString(); int idd = Convert.ToInt32(sessionId); var currentAdmin = db.Admins.Where(x => x.Id == idd).SingleOrDefault(); AdminPostViewModel model = new AdminPostViewModel(); if (currentAdmin != null) { model.Posts = currentAdmin.Posts.ToList(); } return(View(model)); } return(RedirectToAction("SignIn", "Admin")); }
public ActionResult Posts_Update([DataSourceRequest] DataSourceRequest request, AdminPostViewModel post) { if (this.ModelState.IsValid) { var entity = this.posts.GetById(post.Id); entity.Title = post.Title; entity.Content = post.Content; this.posts.Save(); } return(this.Json(new[] { post }.ToDataSourceResult(request, this.ModelState))); }