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