public JsonResult XacNhan(int id, tb_WMS_IMEI Imei_item)
{
if (id != 0)
{
var phieunhap = (from N in _context.tb_WMS_PhieuNhap
where N.ID == id
select N).FirstOrDefault();
phieunhap.TrangThai = 1;
_context.SaveChanges();
var chitiet = (from N in _context.tb_WMS_ChiTietPhieuNhap
where N.IDPN == id
select N).ToArray();
var idkho = phieunhap.IDKho;
for (var a = 0; a < chitiet.Count(); a++)
{
var imeis = chitiet[a].Imei;
var idpbsp = chitiet[a].IDPBSP;
var gianhap = chitiet[a].DonGia;
var item = imeis.Split(';');
for (var i = 0; i < item.Length; i++)
{
var idend_imei = (from u in _context.tb_WMS_IMEI
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
var new_item = item[i];
if (new_item != "")
{
Imei_item.ID = idend_imei + 1;
Imei_item.IDKho = idkho;
Imei_item.Imei = new_item;
Imei_item.TrangThai = 3;
Imei_item.IDSPPB = idpbsp;
Imei_item.GiaNhap = gianhap;
Imei_item.IDNhap = id;
_context.tb_WMS_IMEI.Add(Imei_item);
_context.SaveChanges();
}
}
}
TempData["success"] = "success";
return(Json("ok"));
}
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(""));
}
}
public JsonResult Edit(string c, tb_WMS_PhieuNhap PhieuNhap, tb_WMS_ChiTietPhieuNhap ChiTiet, tb_WMS_IMEI Imeis)
{
if (c != "[]")
{
JArray jsonArray = JArray.Parse(c);
var jsonObjects = jsonArray.OfType <JObject>().ToList();
var idphieu = 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();
var phieunhap = (from N in _context.tb_WMS_PhieuNhap
where N.ID == idphieu
select N).FirstOrDefault();
phieunhap.TongTien = tongtien;
phieunhap.SoLuong = tongsoluong;
phieunhap.GhiChu = ghichu;
_context.Update(phieunhap);
_context.SaveChanges();
var chitiet = (from N in _context.tb_WMS_ChiTietPhieuNhap
where N.IDPN == idphieu
select N).ToArray();
foreach (var item in chitiet)
{
_context.Remove(item);
_context.SaveChanges();
}
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var idend_chitiet = (from u in _context.tb_WMS_ChiTietPhieuNhap
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
var dg = int.Parse(jsonObjects[h]["dongia"].ToString().Replace(",", ""));
var ma = int.Parse(jsonObjects[h]["ma"].ToString());
var soluong = int.Parse(jsonObjects[h]["soluong"].ToString());
var thanhtien = int.Parse(jsonObjects[h]["thanhtien"].ToString().Replace(",", ""));
var idpn = idphieu;
var imeis = jsonObjects[h]["imei"].ToString();
ChiTiet.Imei = imeis;
ChiTiet.IDPN = idpn;
ChiTiet.IDPBSP = ma;
ChiTiet.SoLuong = soluong;
ChiTiet.ThanhTien = thanhtien;
ChiTiet.DonGia = dg;
ChiTiet.ID = idend_chitiet + 1;
_context.tb_WMS_ChiTietPhieuNhap.Add(ChiTiet);
_context.SaveChanges();
}
return(Json(idphieu));
}
else
{
return(Json(""));
}
}
