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);
}
