// GET: web_activities/Details/5
public ActionResult Details(string id, int page = 1)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
destinationsViewModel model = new destinationsViewModel()
{
hotel = db.hotel.Where(m => m.hotel_id == id).FirstOrDefault(),
comment = db.comment.Where(m => m.tourism_id == id).OrderByDescending(m => m.comment_date).ToList(),
message = db.message.Where(m => m.tourism_id == id).OrderByDescending(m => m.msg_time).ToList(),
comment_emoji_details = db.comment_emoji_details.ToList(),
message_emoji_details = db.message_emoji_details.ToList(),
member_profile = db.member_profile.ToList(),
member = db.member.ToList(),
collections_detail = db.collections_detail.Where(m => m.tourism_id == id).ToList(),
};
if (model == null)
{
return(HttpNotFound());
}
ViewBag.tourismId = id;
List <spot> spot = db.spot.Where(m => m.district == model.hotel.district).OrderByDescending(m => m.spot_id).Take(3).ToList();
ViewBag.tourismId = id;
ViewBag.spot = spot;
return(View(model));
}
public PartialViewResult _CommentsForDestination(string tourismId, string[] comment_rating = null, string[] travel_partner = null, string[] travel_month = null, int page = 1)
{
int currentPage = page < 1 ? 1 : page;
List <comment> origin = db.comment.Where(m => m.tourism_id == tourismId).ToList();
destinationsViewModel model = new destinationsViewModel()
{
activity_list = db.activity.ToList(),
spot_list = db.spot.ToList(),
restaurant_list = db.restaurant.ToList(),
hotel_list = db.hotel.ToList(),
comment = db.comment.Where(m => m.tourism_id == tourismId && m.comment_status == true).ToList(),
message = db.message.Where(m => m.tourism_id == tourismId).ToList(),
comment_emoji_details = db.comment_emoji_details.ToList(),
message_emoji_details = db.message_emoji_details.ToList(),
member_profile = db.member_profile.ToList(),
member = db.member.ToList(),
};
List <comment> comments = new List <comment>();
foreach (var comment in origin.ToList())
{
comments.Add(comment);
}
if (comment_rating != null)
{
foreach (var comment in comments.ToList())
{
if (!comment_rating.Contains(comment.comment_rating.ToString()))
{
comments.Remove(comment);
}
}
}
if (travel_partner != null)
{
foreach (var comment in comments.ToList())
{
if (!travel_partner.Contains(comment.travel_partner))
{
comments.Remove(comment);
}
}
}
if (travel_month != null)
{
foreach (var comment in comments.ToList())
{
if (!travel_month.Contains(comment.travel_month))
{
comments.Remove(comment);
}
}
}
model.comment = comments;
ViewBag.tourismId = tourismId;
model.comment_page = model.comment.ToPagedList(currentPage, pageSize);
return(PartialView(model));
}
public PartialViewResult _CommentsForDestination(string tourismId, int page = 1)
{
int currentPage = page < 1 ? 1 : page;
destinationsViewModel model = new destinationsViewModel()
{
activity_list = db.activity.ToList(),
spot_list = db.spot.ToList(),
restaurant_list = db.restaurant.ToList(),
hotel_list = db.hotel.ToList(),
comment = db.comment.Where(m => m.tourism_id == tourismId && m.comment_status == true).OrderByDescending(m => m.comment_date).ToList(),
message = db.message.Where(m => m.tourism_id == tourismId).ToList(),
comment_emoji_details = db.comment_emoji_details.Where(m => m.tourism_id == tourismId).ToList(),
message_emoji_details = db.message_emoji_details.Where(m => m.tourism_id == tourismId).ToList(),
member_profile = db.member_profile.ToList(),
member = db.member.ToList(),
};
string firstChar = tourismId.Substring(0, 1);
switch (firstChar)
{
case "A":
model.activity = db.activity.Where(m => m.activity_id == tourismId).FirstOrDefault();
break;
case "H":
model.hotel = db.hotel.Where(m => m.hotel_id == tourismId).FirstOrDefault();
break;
case "R":
model.restaurant = db.restaurant.Where(m => m.restaurant_id == tourismId).FirstOrDefault();
break;
case "S":
model.spot = db.spot.Where(m => m.spot_id == tourismId).FirstOrDefault();
break;
default:
break;
}
model.comment_page = model.comment.ToPagedList(currentPage, pageSize);
ViewBag.tourismId = tourismId;
return(PartialView(model));
}
//個人評論
public PartialViewResult _CommentsFromMember(string memId, int page = 1)
{
ViewBag.memId = memId;
int currentPage = page < 1 ? 1 : page;
destinationsViewModel model = new destinationsViewModel()
{
comment = db.comment.Where(m => m.member_id == memId && m.comment_status == true).OrderByDescending(m => m.comment_date).ToList(),
message = db.message.Where(m => m.member_id == memId).ToList(),
comment_emoji_details = db.comment_emoji_details.ToList(),
message_emoji_details = db.message_emoji_details.ToList(),
member_profile = db.member_profile.Where(m => m.member_id == memId).ToList(),
member = db.member.Where(m => m.member_id == memId).ToList(),
hotel_list = db.hotel.ToList(),
activity_list = db.activity.ToList(),
spot_list = db.spot.ToList(),
restaurant_list = db.restaurant.ToList(),
};
model.comment_page = model.comment.ToPagedList(currentPage, pageSize);
return(PartialView(model));
}
