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));
}
