public PartialViewResult Add(string mealSetID, string dishID)
{
int dish = int.Parse(dishID);
int mealset = int.Parse(mealSetID);
MealSetDishModel model = new MealSetDishModel();
Session["maxMealsetDish"] = "";
Session["existMealsetDish"] = "";
try
{
MealSetDishDetailTableAdapter mealSetDishAdapter = new MealSetDishDetailTableAdapter();
DataTable mealSetDishDT = new DataTable();
mealSetDishDT = mealSetDishAdapter.GetDataByMealSetID(mealset);
int test = mealSetDishDT.Rows.Count;
if (mealSetDishDT.Rows.Count >= 6)
{
Session["maxMealsetDish"] = "Số lượng món ăn trong suất ăn đã đầy. Bỏ món ăn ko cần để có thể thêm món mới!";
return PartialView("_MealSetDish", model);
}
mealSetDishDT = mealSetDishAdapter.GetDataByMealsetDish(mealset, dish);
if (mealSetDishDT.Rows.Count != 0)
{
Session["existMealsetDish"] = "Món ăn đã được thêm trước đó. Vui lòng chọn món ăn khác!";
return PartialView("_MealSetDish", model);
}
mealSetDishAdapter.InsertMealSetDish(mealset,dish);
Log.ActivityLog("Insert into MealSetDishDetail table: MealsetID = " + mealSetID + ", DishID = " + dishID);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
}
MealSetDishInfoTableAdapter mealSetDishInfoAdapter = new MealSetDishInfoTableAdapter();
DataTable mealSetDishInfoDT = mealSetDishInfoAdapter.GetDataByMealSetIDDishID(mealset, dish);
model.DishID = dish;
model.MealSetID = mealset;
model.Dishname = mealSetDishInfoDT.Rows[0]["DishName"].ToString();
model.DishTypeID = (int)mealSetDishInfoDT.Rows[0]["DishTypeID"];
model.DishDescription = mealSetDishInfoDT.Rows[0]["DishDescription"].ToString();
model.DishImage = mealSetDishInfoDT.Rows[0]["DishImage"].ToString();
return PartialView("_MealSetDish", model);
}
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 DetailMealSet(string mealSetID)
{
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 GetMealSetModal(string MealSetID)
{
int mealSetID;
if (String.IsNullOrWhiteSpace(MealSetID) || !int.TryParse(MealSetID, out mealSetID))
{
return RedirectToAction("Schedule", "Schedule");
}
MealSetDishDetailModel model = new MealSetDishDetailModel();
DataTable dt = new MealSetDishInfoTableAdapter().GetDataByMealSetID(mealSetID);
if (dt.Rows.Count > 0)
{
model.MealSetName = dt.Rows[0].Field<string>("MealSetName");
model.MealSetImage = ".." + dt.Rows[0].Field<string>("MealSetImage");
model.DishNameImage = new List<KeyValuePair<string, string>>();
foreach (DataRow row in dt.Rows)
{
string dishImage = row.Field<string>("DishImage");
if (dishImage == null)
{
dishImage = AppDomain.CurrentDomain.BaseDirectory + "..\\Images\\no-image.jpg";
}
else
{
dishImage = ".." + dishImage;
}
model.DishNameImage.Add(new KeyValuePair<string, string>(row.Field<string>("DishName"),
dishImage));
}
}
return PartialView(model);
}
