[HELP] How to add WHERE clause in MVC Action Method

Question

Hi, how do i make the page will only show data that show specific bank code? For eg, bankcode = 123

public virtual ActionResult SearchResultPage(FormCollection collection)
{

ViewBag.SearchResult = pageConfigDao.getResultListFromDatabaseView(new PageSqlConfig(TaskIdsICS.LargeAmount.INDEX,
"View_LargeAmountLimit", null, "", new[] { new SqlParameter("@fldBankCode", CurrentUser.Account.BankCode)}), collection);

return View();
}

Answer 1

https://stackoverflow.com/questions/10213097/how-to-use-a-where-clause-in-mvc-ef
Hope this might help you