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