Example #1
0
        //
        // GET: /Case/

        public ViewResult Index(int page = 1, string sort = "CaseTitle", string sortDir = "ASC")
        {
            // Clear search keyword for case
            Session["CaseKeyword"] = "";

            int         totalRows = 0;
            int         pageSize  = 10;
            List <Case> cases     = new List <Case>();

            totalRows = db.Cases.Count();
            cases     = (db.Cases.OrderBy(m => m.CaseDescription).Skip((page - 1) * pageSize).Take(pageSize)).ToList();

            PruneLongDescriptions(cases);
            PagedCases pCases = new PagedCases(cases, pageSize, page, totalRows);

            return(View(pCases));
        }
Example #2
0
        public ViewResult Search(int page = 1, string keyword = "")
        {
            string savedKeyword = (string)Session["CaseKeyword"];

            if (!String.IsNullOrEmpty(savedKeyword))
            {
                keyword = savedKeyword;
            }

            int         totalRows = 0;
            int         pageSize  = 10;
            List <Case> cases     = new List <Case>();

            if (keyword == "")
            {
                totalRows = db.Cases.Count();
                cases     = (db.Cases.OrderBy(m => m.ID).Skip((page - 1) * pageSize).Take(pageSize)).ToList();
            }
            else
            {
                totalRows = db.Cases
                            .Where(m => m.CaseTitle.Contains(keyword) || m.CaseDescription.Contains(keyword))
                            .Count();
                cases = (db.Cases
                         .Where(m => m.CaseTitle.Contains(keyword) || m.CaseDescription.Contains(keyword))
                         .OrderBy(m => m.ID)
                         .Skip((page - 1) * pageSize)
                         .Take(pageSize)).ToList();
            }

            Session["keyword"] = keyword;
            PruneLongDescriptions(cases);
            PagedCases pCases = new PagedCases(cases, pageSize, page, totalRows);

            return(View(pCases));
        }