public JsonResult DeleteBarcode(int id, int IdMenu) { //khi xoa ma vach chia ra 2 TH //1. neu ma vach do co 1 dong: tuc la khong co gi thi cap nhat lai trang thai ben bang Menu //2. neu ma vach co nhieu dong: tuc la mau hoac mui thi khi nao xoa het tat ca cac dong moi cap nhat trang thai hasvalue ben bang Menu var idxoa = _menuOptionRepository.GetById(id); //kiem tra san pham do co bao nhieu dong int sodongtrongSP = _menuOptionRepository.LaySoLuongBarcodeInMenuOption(IdMenu); _menuOptionRepository.Delete(idxoa); _unitOfWork.Commit(); if (sodongtrongSP == 1) //tuc la ma vach khong co gi { //update san pham do thanh san pham chua co ma vach using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand("update Menu set HasValue='False' where id_ ={0}", IdMenu); } } return(Json(new { ok = true, message = "Xóa mã vạch thành công!" }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteKhongCoGi(int id) { var idxoa = _menuOptionRepository.GetById(id); _menuOptionRepository.Delete(idxoa); //khi xoa ma vach thi update lai hasvalue //b1: get idmenu tu id cua menuoption using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand( "update Menu set HasValue='false' where id_ = (select IdMenu from MenuOption where id_={0})", id); } _unitOfWork.Commit(); return(RedirectToAction("KhongCoGi")); }
public async Task <MenuOption> GetMenuOption(string id) { var menuOption = await _repository.GetById(id); return(menuOption); }