Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
 public List<Proposal> SelectProposals(ProposalFilter filter, PagingOption option)
 {
     return _dal.ProposalRepository.SelectProposals(filter, option);
 }
Ejemplo n.º 4
0
 public ActionResult Proposals(ProposalFilter filter)
 {
     var model = new ProposalsViewModel
     {
         Filter = filter
     };
     return View(model);
 }