public ActionResult approbationManagement(string SearchText, int?page) { Database db = new Database(); RequisitionDAO rqDAO = new RequisitionDAO(db); List <RequisitionModel> rqModel = rqDAO.FindAll(); db.Close(); ViewBag.Total = rqModel.Count; var data = from a in rqModel select a; if (!String.IsNullOrEmpty(SearchText)) { if (SearchText.Contains("อนุมัติแล้ว")) { SearchText = "allow"; } else if (SearchText.Contains("รออนุมัติ")) { SearchText = "wait"; } else if (SearchText.Contains("ไม่อนุมัติ")) { SearchText = "not"; } data = data.Where( a => a.REPAIR_NO.DAMAGE.Contains(SearchText) || a.STOCK_NO.PART.BRAND.PART_BRAND_NAME.Contains(SearchText) || a.STOCK_NO.PART.TYPE.PART_TYPE_NAME.Contains(SearchText) || a.STOCK_NO.STOCK_INFO.Contains(SearchText) || a.APROVE.Contains(SearchText) ); } var numPage = page ?? 1; ViewBag.Approbation = data.ToPagedList(numPage, 20); return(View()); }