//
// GET: /Stock/
public ActionResult Index(string SearchText, int?page)
{
Database db = new Database();
StockDAO stkDAO = new StockDAO(db);
List <StockModel> stkModel = stkDAO.FindAll();
var data = from d in stkModel select d;
// ค้นหา
if (!String.IsNullOrEmpty(SearchText))
{
//ค้นหา
data = data.Where(
d => d.STOCK_ID.ToString().Contains(SearchText) ||
d.PART.TYPE.PART_TYPE_NAME.Contains(SearchText) || d.PART.TYPE.PART_TYPE_NAME.Contains(SearchText.ToUpper()) || d.PART.TYPE.PART_TYPE_NAME.Contains(SearchText.ToLower()) ||
d.PART.BRAND.PART_BRAND_NAME.Contains(SearchText) || d.PART.BRAND.PART_BRAND_NAME.Contains(SearchText.ToLower()) || d.PART.BRAND.PART_BRAND_NAME.Contains(SearchText.ToUpper()) ||
d.PRICE.ToString().Contains(SearchText) ||
d.STOCK_INFO.Contains(SearchText.ToUpper()) || d.STOCK_INFO.Contains(SearchText.ToLower()) || d.STOCK_INFO.Contains(SearchText)
).ToList();
}
var numPage = page ?? 1;
ViewBag.Stock = data.ToPagedList(numPage, 20);
db.Close();
return(View());
}
