public JsonResult Save(string c, tb_WMS_TraNhaCungCap TraNhaCungCap, tb_WMS_ChiTietTraNhaCungCap ChiTiet)
{
if (c != "[]")
{
var idend = (from u in _context.tb_WMS_TraNhaCungCap
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
var nhanvien = int.Parse(@User.FindFirst("IdNV").Value);
JArray jsonArray = JArray.Parse(c);
var jsonObjects = jsonArray.OfType <JObject>().ToList();
var idnhap = int.Parse(jsonObjects[0]["idphieu"].ToString());
var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", ""));
var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString());
var ghichu = jsonObjects[0]["ghichu"].ToString();
TraNhaCungCap.IDNhap = idnhap;
TraNhaCungCap.SoLuong = tongsoluong;
TraNhaCungCap.Tien = tongtien;
DateTime date = DateTime.Now;
TraNhaCungCap.NgayLap = date;
TraNhaCungCap.MaTraHang = "SR" + (idend + 1);
TraNhaCungCap.ID = idend + 1;
TraNhaCungCap.TrangThai = 0;
TraNhaCungCap.IDNhanVien = nhanvien;
TraNhaCungCap.GhiChu = ghichu;
_context.tb_WMS_TraNhaCungCap.Add(TraNhaCungCap);
_context.SaveChanges();
var phieunhap = (from N in _context.tb_WMS_PhieuNhap
where N.ID == idnhap
select N).FirstOrDefault();
phieunhap.TraHang = true;
_context.Update(phieunhap);
var idtra = idend + 1;
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var idchitiet = int.Parse(jsonObjects[h]["chitiet"].ToString());
var imei = jsonObjects[h]["imei"].ToString();
var data_imei = (from N in _context.tb_WMS_IMEI
where N.Imei == imei
select N).FirstOrDefault();
var idpbsp = data_imei.IDSPPB;
var gia = data_imei.GiaNhap;
var idend_chitiet = (from u in _context.tb_WMS_ChiTietTraNhaCungCap
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
ChiTiet.ID = idend_chitiet + 1;
ChiTiet.IDTraHang = idtra;
ChiTiet.IDPBSP = idpbsp;
ChiTiet.Imei = imei;
ChiTiet.DonGia = gia;
_context.tb_WMS_ChiTietTraNhaCungCap.Add(ChiTiet);
data_imei.TrangThai = 7;
_context.tb_WMS_IMEI.Update(data_imei);
_context.SaveChanges();
}
return(Json(idend + 1));
}
else
{
return(Json(""));
}
}
public JsonResult save(string c, tb_WMS_ChiTietTraNhaCungCap ChiTiet)
{
if (c != "[]")
{
JArray jsonArray = JArray.Parse(c);
var jsonObjects = jsonArray.OfType <JObject>().ToList();
var idtra = int.Parse(jsonObjects[0]["idphieutra"].ToString());
//var idnhap = int.Parse(jsonObjects[0]["idphieunhap"].ToString());
var tongtien = int.Parse(jsonObjects[0]["tongtien"].ToString().Replace(",", ""));
var tongsoluong = int.Parse(jsonObjects[0]["tongsoluong"].ToString());
var ghichu = jsonObjects[0]["ghichu"].ToString();
var phieutra = (from N in _context.tb_WMS_TraNhaCungCap
where N.ID == idtra
select N).FirstOrDefault();
phieutra.SoLuong = tongsoluong;
phieutra.Tien = tongtien;
phieutra.GhiChu = ghichu;
_context.tb_WMS_TraNhaCungCap.Update(phieutra);
_context.SaveChanges();
var chitiet_remove = (from N in _context.tb_WMS_ChiTietTraNhaCungCap
where N.IDTraHang == idtra
select N).ToList();
foreach (var item in chitiet_remove)
{
_context.tb_WMS_ChiTietTraNhaCungCap.Remove(item);
_context.SaveChanges();
}
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var imei_tra = jsonObjects[h]["imei"].ToString();
var idend_chitiet = (from u in _context.tb_WMS_ChiTietTraNhaCungCap
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
if (imei_tra != "")
{
var tt_imei_tra = (from N in _context.tb_WMS_IMEI
where N.Imei == imei_tra
select N).FirstOrDefault();
var idpb = tt_imei_tra.IDSPPB;
var dongia = tt_imei_tra.GiaNhap;
ChiTiet.IDPBSP = idpb;
ChiTiet.Imei = imei_tra;
ChiTiet.DonGia = dongia;
ChiTiet.IDTraHang = idtra;
ChiTiet.ID = idend_chitiet + 1;
_context.tb_WMS_ChiTietTraNhaCungCap.Add(ChiTiet);
_context.SaveChanges();
}
}
return(Json("hello"));
}
else
{
return(Json(""));
}
}
