public ActionResult ListDish(string search, string filter) { ViewBag.notExistDish = ""; DishTypeTableAdapter dishTypeAdapter = new DishTypeTableAdapter(); DataTable dishTypeDT = dishTypeAdapter.GetData(); List<SelectListItem> items = new List<SelectListItem>(); items.Add(new SelectListItem { Text = "Tất Cả", Value = "" }); foreach (DataRow row in dishTypeDT.Rows) { items.Add(new SelectListItem { Text = row["TypeName"].ToString(), Value = row["DishTypeID"].ToString() }); } ViewData["DishType"] = items; DishInfoDetailTableAdapter adapter = new DishInfoDetailTableAdapter(); try { dishDT = adapter.GetData(); } catch (Exception ex) { Log.ErrorLog(ex.Message); } if (!(string.IsNullOrEmpty(search) && string.IsNullOrEmpty(filter))) { int type = -1; int.TryParse(filter, out type); string name = search; if (name == null) { name = String.Empty; } var result = from row in dishDT.AsEnumerable() where (name == String.Empty ? true : StringExtensions.ContainsInsensitive(row.Field<string>("Name"), name)) && (type < 1 ? true : row.Field<int>("DishTypeID") == type) select row; try { return View(result.CopyToDataTable()); } catch (Exception ex) { if (string.IsNullOrEmpty(search)) { ViewBag.notExistDish = "Không tìm thấy kết quả nào"; } else { ViewBag.notExistDish = "Không tìm thấy kết quả nào với từ khóa: " + search; } Log.ErrorLog(ex.Message); } } return View(dishDT); }
public ActionResult AddMealSetDish(string mealSetID, string search, string filter) { ViewBag.notExistMealSet = ""; DishTypeTableAdapter dishTypeAdapter = new DishTypeTableAdapter(); DataTable dishTypeDT = dishTypeAdapter.GetData(); List<SelectListItem> items = new List<SelectListItem>(); items.Add(new SelectListItem { Text = "Tất Cả", Value = "" }); foreach (DataRow row in dishTypeDT.Rows) { items.Add(new SelectListItem { Text = row["TypeName"].ToString(), Value = row["DishTypeID"].ToString() }); } ViewData["DishType"] = items; DataTable dishDT = new DataTable(); DishInfoDetailTableAdapter adapter = new DishInfoDetailTableAdapter(); try { dishDT = adapter.GetData(); } catch (Exception ex) { Log.ErrorLog(ex.Message); } if (!(string.IsNullOrEmpty(search) && string.IsNullOrEmpty(filter))) { int type = -1; int.TryParse(filter, out type); string name = search; if (name == null) { name = String.Empty; } var result = from row in dishDT.AsEnumerable() where (name == String.Empty ? true : StringExtensions.ContainsInsensitive(row.Field<string>("Name"), name)) && (type < 1 ? true : row.Field<int>("DishTypeID") == type) select row; try { dishDT = 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); } } ViewData["listDish"] = dishDT; try { int id = int.Parse(mealSetID); MealSetDishInfoTableAdapter mealSetDishInfoAdapter = new MealSetDishInfoTableAdapter(); ViewData["listMealSetDish"] = mealSetDishInfoAdapter.GetDataByMealSetID(id); MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter(); EditMealSetModel model = new EditMealSetModel(); DataTable mealSetDT = mealSetAdapter.GetDataByMealSetID(id); model.MealSetID = id; model.MealSetName = mealSetDT.Rows[0]["Name"].ToString(); model.Description = mealSetDT.Rows[0]["Description"].ToString(); model.Image = mealSetDT.Rows[0]["Image"].ToString(); model.CanEatMore = (bool)mealSetDT.Rows[0]["CanEatMore"]; return View(model); } catch (Exception ex) { Log.ErrorLog(ex.Message); return RedirectToAction("Error", "Error"); } }
public ActionResult DetailDish(string dishID) { try { int id = int.Parse(dishID); DetailDishModel model = new DetailDishModel(); DishInfoDetailTableAdapter dishAdapter = new DishInfoDetailTableAdapter(); DataTable dishDT = dishAdapter.GetDataByDishID(id); model.DishID = id; model.Dishname = dishDT.Rows[0]["Name"].ToString(); model.DishTypeName = dishDT.Rows[0]["TypeName"].ToString(); model.Description = dishDT.Rows[0]["Description"].ToString(); model.Image = dishDT.Rows[0]["Image"].ToString(); return View(model); } catch (Exception ex) { Log.ErrorLog(ex.Message); return RedirectToAction("Error", "Error"); } }