public ActionResult ListMealSet(string search, string filter) { ViewBag.successMessage = ""; ViewBag.notExistMealSet = ""; MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter(); try { mealSetDT = mealSetAdapter.GetData(); } catch (Exception ex) { Log.ErrorLog(ex.Message); } if (!(string.IsNullOrEmpty(search) && string.IsNullOrEmpty(filter))) { int type = -1; if (!string.IsNullOrEmpty(filter)) { int.TryParse(filter, out type); } string name = search; if (name == null) { name = String.Empty; } bool type_ = false; if (type == 1) { type_ = true; } var result = from row in mealSetDT.AsEnumerable() where (name == String.Empty ? true : StringExtensions.ContainsInsensitive(row.Field<string>("Name"), name)) && (type < 0 ? true : row.Field<bool>("CanEatMore") == type_) select row; try { return View(result.CopyToDataTable()); } catch (Exception ex) { if (string.IsNullOrEmpty(search)) { ViewBag.notExistMealSet = "Không tìm thấy kết quả nào"; } else { ViewBag.notExistMealSet = "Không tìm thấy kết quả nào với từ khóa: " + search; } Log.ErrorLog(ex.Message); } } return View(mealSetDT); }
public JsonResult GetMeatSetForDDL() { try { MealSetTableAdapter mealSetTA = new MealSetTableAdapter(); DataTable mealSetDT = mealSetTA.GetData(); IList<MeatSetForDDLJsonModel> mealSet = new List<MeatSetForDDLJsonModel>(); foreach (DataRow row in mealSetDT.Rows) { MeatSetForDDLJsonModel model = new MeatSetForDDLJsonModel(); model.MealSetID = row.Field<int>("MealSetID"); model.Name = row.Field<string>("Name"); mealSet.Add(model); } return Json(new { mealSet = mealSet }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { Log.ErrorLog(ex.Message); return Json("error", JsonRequestBehavior.AllowGet); } }