public JsonResult Add_imei(int idphieu, int idkho, int idimei, int dg, tb_WMS_ChiTietPhieuXuat chitiet)
{
if (dg != 0 && idphieu != 0 && idkho != 0 && idimei != 0)
{
var phieu = (from N in _context.tb_WMS_PhieuXuat
where N.ID == idphieu
select N).FirstOrDefault();
phieu.SoLuong += 1;
phieu.TongTien += dg;
var idend = (from u in _context.tb_WMS_ChiTietPhieuXuat
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
var imei = (from N in _context.tb_WMS_IMEI
where N.ID == idimei
select N).FirstOrDefault();
imei.IDXuat = idphieu;
imei.GiaXuat = dg;
imei.TrangThai = 1;
chitiet.ID = idend + 1;
chitiet.IDPBSP = imei.IDSPPB;
chitiet.GiaBan = dg;
chitiet.IDPhieuXuat = idphieu;
chitiet.Imei = idimei;
chitiet.TraHang = false;
_context.tb_WMS_ChiTietPhieuXuat.Add(chitiet);
_context.SaveChanges();
return(Json("hello"));
}
return(Json(""));
}
public JsonResult Save(string c, tb_WMS_PhieuXuat phieuXuat, tb_WMS_ChiTietPhieuXuat ChiTiet, tb_WMS_IMEI Imeis)
{
if (c != "[]")
{
var idend = (from u in _context.tb_WMS_PhieuXuat
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
var idnv = int.Parse(@User.FindFirst("IdNV").Value);
JArray jsonArray = JArray.Parse(c);
var jsonObjects = jsonArray.OfType <JObject>().ToList();
var kho = int.Parse(jsonObjects[0]["kho"].ToString());
var khach = int.Parse(jsonObjects[0]["khach"].ToString());
var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", ""));
var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString());
var ghichu = jsonObjects[0]["ghichu"].ToString();
phieuXuat.IDKho = kho;
phieuXuat.IDKhach = khach;
phieuXuat.SoLuong = tongsoluong;
phieuXuat.TongTien = tongtien;
DateTime date = DateTime.Now;
phieuXuat.NgayLap = date;
phieuXuat.MaPhieuXuat = "EC" + (idend + 1);
phieuXuat.ID = idend + 1;
phieuXuat.TrangThai = 0;
phieuXuat.IDNV = idnv;
phieuXuat.GhiChu = ghichu;
phieuXuat.TraHang = false;
_context.tb_WMS_PhieuXuat.Add(phieuXuat);
_context.SaveChanges();
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var dg = int.Parse(jsonObjects[h]["dongia"].ToString().Replace(",", ""));
var idpbsp = int.Parse(jsonObjects[h]["idpbsp"].ToString());
var idimei = int.Parse(jsonObjects[h]["idimei"].ToString());
var idpx = idend + 1;
var idend_chitiet = (from u in _context.tb_WMS_ChiTietPhieuXuat
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
if (idimei != 0)
{
ChiTiet.Imei = idimei;
ChiTiet.IDPhieuXuat = idpx;
ChiTiet.IDPBSP = idpbsp;
ChiTiet.GiaBan = dg;
ChiTiet.ID = idend_chitiet + 1;
ChiTiet.TraHang = false;
_context.tb_WMS_ChiTietPhieuXuat.Add(ChiTiet);
var imeiX = (from N in _context.tb_WMS_IMEI
where N.ID == idimei
select N).FirstOrDefault();
imeiX.IDXuat = idpx;
imeiX.TrangThai = 1;
imeiX.GiaXuat = dg;
_context.Update(imeiX);
_context.SaveChanges();
}
}
return(Json(idend + 1));
}
else
{
return(Json(""));
}
}
