public ActionResult FinalChoose(string actClassId, int?ageRestrict, int?gender, int?maxNumPeople, int?maxBudget, int?paymentTerm, int?actCounty) { GetSelectList(); if (ageRestrict == 1) { ageRestrict = null; } if (gender == 1) { gender = null; } if (maxBudget == 1) { maxBudget = null; } //var vwActivities = fc1.vwActList.Where(m => m.keepAct == true).ToList(); var vwActivities = db.vw_Activities.Where(m => m.keepAct == true).ToList(); if (actClassId != null) { vwActivities = vwActivities.Where(m => m.actClassId == actClassId).ToList(); } if (ageRestrict != null) { vwActivities = vwActivities.Where(m => m.ageRestrict == ageRestrict).ToList(); } if (gender != null) { vwActivities = vwActivities.Where(m => m.genderSerial == gender).ToList(); } if (maxNumPeople != null) { vwActivities = vwActivities.Where(m => m.peoSerial == maxNumPeople).ToList(); } if (maxBudget != null) { vwActivities = vwActivities.Where(m => m.BudgetNo == maxBudget).ToList(); } if (paymentTerm != null) { vwActivities = vwActivities.Where(m => m.paymentSerial == paymentTerm).ToList(); } if (actCounty != null) { vwActivities = vwActivities.Where(m => m.CountyNo == actCounty).ToList(); } Finalchoose fc1 = new Finalchoose() { vwActList = vwActivities.ToList(), joinfunlist = db.Join_Fun_Activities.ToList(), post = db.Post.Where(m => m.ShowInCarousel == true).OrderByDescending(m => m.postSerial).Take(1).ToList() }; return(View(fc1)); }
//關鍵字搜尋 public ActionResult Search(string keyword) { GetSelectList(); if (keyword == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var searchkeep = db.vw_Activities.Where(m => m.keepAct == true); var searchResult = searchkeep.Where((m => m.actTopic.Contains(keyword) || m.actDescription.Contains(keyword) || m.CountyName.Contains(keyword) || m.DistrictName.Contains(keyword) || m.actRoad.Contains(keyword) || m.hashTag.Contains(keyword) || m.memNick.Contains(keyword))).ToList(); Finalchoose fc2 = new Finalchoose() { vwActList = searchResult.ToList(), joinfunlist = db.Join_Fun_Activities.ToList(), post = db.Post.Where(m => m.ShowInCarousel == true).OrderByDescending(m => m.postSerial).Take(1).ToList() }; return(View(fc2)); }
public ActionResult Index() { sendTimeAct(); if (Session["memid"] == null) { Session["memid"] = ""; } ViewBag.age = db.Age_Restriction.ToList(); DropAct(); //ViewBag.joinTime = db.Activity_Details.Where(m => m.actId == actId && m.appvStatus == true).Count(); Finalchoose fc = new Finalchoose() { vwActList = db.vw_Activities.Where(m => m.keepAct == true).OrderByDescending(m => m.clickTimes).ToList(), joinfunlist = db.Join_Fun_Activities.OrderByDescending(m => m.clickTimes).ToList(), post = db.Post.Where(m => m.ShowInCarousel == true).OrderByDescending(m => m.postSerial).Take(1).ToList() }; GetSelectList(); //var vwAct = fc; return(View(fc)); }