public List<Proposal> SelectProposals(ProposalFilter filter, PagingOption option) { List<Proposal> list = new List<Proposal>(); string sql = "SELECT * FROM dbo.Proposal WHERE 1 = 1" + filter.GetFilterString(); string orderBy = ""; var table = ExecuteDataTable(sql, option, orderBy); foreach (DataRow row in table.Rows) { list.Add(DataRowToProposal(row)); } return list; }
public ActionResult ProposalsList(ProposalFilter filter, int page = 1) { PagingOption option = GetPagingOption15(page); var model = new ProposalsViewModel { Proposals = bll.ProposalManager.SelectProposals(filter, option), PagingOption = new WebPagingOption { CurrentPage = page, ItemsPerPage = PageSize15, TotalItems = option.RecordCount } }; return PartialView(model); }
public List<Proposal> SelectProposals(ProposalFilter filter, PagingOption option) { return _dal.ProposalRepository.SelectProposals(filter, option); }
public ActionResult Proposals(ProposalFilter filter) { var model = new ProposalsViewModel { Filter = filter }; return View(model); }