public ActionResult SaveEditPopupMaVach(BarcodeSubmitModel model) { return(RedirectToAction("Index")); }
public JsonResult SaveBarcode(BarcodeSubmitModel model) { //them moi ma vach MenuOption menuOption = new MenuOption(); if (model.Id == 0) { int somavach = _menuRepository.ChekBarcode(model.Barcode); if (somavach == 0) { //ma vach khong ton tai return(Json(new { ok = false, message = "Mã vạch này không đúng" }, JsonRequestBehavior.AllowGet)); } else { //ma vach bi trung var menu = _menuOptionRepository.Get(o => o.Barcode.Equals(model.Barcode)); if (menu != null) { return(Json(new { ok = false, message = "Mã vạch này đã tồn tại!" }, JsonRequestBehavior.AllowGet)); } } if (model.Flag == 0) { //khong co gi //xoa du lieu trong bang voi Idmenu using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand("delete from MenuOption where MenuOption.IdMenu={0}", model.IdMenu); context.Database.ExecuteSqlCommand("update Menu set Menu.HasValue='False' where Menu.id_={0}", model.IdMenu); } menuOption = new MenuOption() { Barcode = model.Barcode, Flag = model.Flag, Img = "", TenLoai = "Không có gì", SDate = DateTime.Now, sDateOk = DateTime.Now, IdMenu = model.IdMenu }; _menuOptionRepository.Add(menuOption); using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand("update Menu set Menu.HasValue='True' where Menu.id_={0}", model.IdMenu); context.Database.ExecuteSqlCommand("update Menu set Menu.BarcodeType={0} where Menu.id_={1}", model.Flag, model.IdMenu); } } else { // co mau hoac co mui menuOption = new MenuOption() { Barcode = model.Barcode, Flag = model.Flag, Img = model.Hinh.Replace("/files/", ""), TenLoai = model.TenLoai, SDate = DateTime.Now, sDateOk = DateTime.Now, IdMenu = model.IdMenu }; _menuOptionRepository.Add(menuOption); } //_menuOptionRepository.Add(menuOption); //sau khi them moi xong update lai barcodetype trong bang menu using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand("update Menu set Menu.HasValue='True' where Menu.id_={0}", model.IdMenu); context.Database.ExecuteSqlCommand("update Menu set Menu.BarcodeType={0} where Menu.id_={1}", model.Flag, model.IdMenu); } } _unitOfWork.Commit(); //update xong kiem tra san pham do con hang hay het hang roi update lai int tonkho = _menuRepository.CheckOnhand(model.Barcode); int idsanpham = _menuOptionRepository.GetIdSanPhamByBarCode(model.Barcode); if (tonkho <= 0) { using (var context = new ShopDataContex()) { context.Database.ExecuteSqlCommand("update Menu set HasOnHand='false' where id_ ={0}", idsanpham); } } return(Json(new { ok = true, message = "Cập nhật mã vạch thành công!" }, JsonRequestBehavior.AllowGet)); }