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());
}
