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