public JsonResult SearchingComment(int SearchingForID, SearchingForVM modelObj) { JsonResult result = new JsonResult(); if (ModelState.IsValid) { using (db) { try { UserAccount activeUserObj = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); modelObj.CommentSearching.UserID = activeUserObj.UserID; modelObj.CommentSearching.SearchingForID = SearchingForID; db.CommentSearchings.Add(modelObj.CommentSearching); db.SaveChanges(); ModelState.Clear(); TempData["Success"] = "Commented!!!"; result.Data = new { Success = true }; } catch (Exception ex) { result.Data = new { Success = false, Message = ex.Message }; } } } return(result); }
public ActionResult SearchingForDetails(int SearchingForID) { var model = new SearchingForVM(); model.UserAccount = db.UserSearchingFors.Where(e => e.SearchingForID == SearchingForID).Select(e => e.UserAccount).FirstOrDefault(); model.SearchingFors = db.SearchingFors.Where(e => e.SearchingForID == SearchingForID).ToList(); model.UserSearchingFors = db.UserSearchingFors; model.CommentSearchings = db.CommentSearchings.Where(e => e.SearchingForID == SearchingForID).OrderByDescending(e => e.CommentedOn).ToList(); if (model == null) { return(HttpNotFound()); } UserAccount listedByUsr = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); if (User.Identity.IsAuthenticated) { bool wishListObj = db.WishListSearchings.Any(x => x.SearchingForID == SearchingForID && x.WishListedBy == listedByUsr.UserID); bool bookingObj = db.BookingSearchings.Any(x => x.SearchingForID == SearchingForID && x.BookedBy == listedByUsr.UserID); if (wishListObj == true) { ViewBag.WishListSuccess = true; } else { ViewBag.WishListSuccess = false; } if (bookingObj == true) { ViewBag.BookingSuccess = true; } else { ViewBag.BookingSuccess = false; } } return(View(model)); }
public ActionResult CommentSearchingFors(int?pageNo) { var model = new SearchingForVM(); //To Find userid UserAccount usr = db.UserAccounts.Where(u => u.UserName.Equals(User.Identity.Name.ToString())).FirstOrDefault(); if (usr != null) { var searchObj = db.CommentSearchings.Where(e => e.UserID == usr.UserID).Select(e => e.SearchingFor).Distinct().AsEnumerable(); int count = searchObj.Count(); pageNo = pageNo ?? 1; var skipCount = (pageNo.Value - 1) * pageSize; searchObj = searchObj.OrderByDescending(x => x.SearchingForID).Skip(skipCount).Take(pageSize); model.Pager = new Pager(count, pageNo, pageSize); model.SearchingFors = searchObj; } return(PartialView(model)); }