public async Task <IActionResult> SuaLoaiSanPham(int id, [Bind("ID,MaLoai,TenLoai")] tb_WMS_LoaiSanPham tb_WMS_LoaiSanPham)
{
if (id != tb_WMS_LoaiSanPham.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tb_WMS_LoaiSanPham);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tb_WMS_LoaiSanPhamExists(tb_WMS_LoaiSanPham.ID))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["success"] = "success";
return(RedirectToAction(nameof(LoaiSanPham)));
}
return(View(tb_WMS_LoaiSanPham));
}
public async Task <IActionResult> Edit(int id, tb_WMS_NhanVien tb_WMS_NhanVien, IFormFile HinhAnh)
{
if (HinhAnh != null)
{
var filePath = Path.Combine("wwwroot\\img\\User", HinhAnh.FileName);
using (var stream = new FileStream(filePath, FileMode.Create))
{
await HinhAnh.CopyToAsync(stream);
}
tb_WMS_NhanVien.HinhAnh = HinhAnh.FileName;
}
else
{
var img = (from N in _context.tb_WMS_NhanVien
where N.ID == id
select N.HinhAnh).FirstOrDefault();
tb_WMS_NhanVien.HinhAnh = img;
}
var kho = (from N in _context.tb_WMS_NhanVien
where N.ID == id
select N.Kho).FirstOrDefault();;
var quyen = (from N in _context.tb_WMS_NhanVien
where N.ID == id
select N.Quyen).FirstOrDefault();;
tb_WMS_NhanVien.Kho = kho;
tb_WMS_NhanVien.Quyen = quyen;
tb_WMS_NhanVien.TrangThai = true;
_context.Update(tb_WMS_NhanVien);
await _context.SaveChangesAsync();
TempData["ok"] = "ok";
return(Redirect("/CaNhan/thong-tin-00" + id + "00"));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MaNhaKho,TenNhaKho,DiaChi,SoDienThoai,TrangThai")] tb_WMS_NhaKho tb_WMS_NhaKho)
{
if (id != tb_WMS_NhaKho.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tb_WMS_NhaKho);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tb_WMS_NhaKhoExists(tb_WMS_NhaKho.ID))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["success"] = "success";
return(RedirectToAction(nameof(Index)));
}
return(View(tb_WMS_NhaKho));
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MaKhachHang,TenKhachHang,NgaySing,GioiTinh,DiaChi,SoDienThoai,MaSoThue,Email,SoFax")] tb_WMS_KhachHang tb_WMS_KhachHang)
{
if (id != tb_WMS_KhachHang.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tb_WMS_KhachHang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tb_WMS_KhachHangExists(tb_WMS_KhachHang.ID))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["success"] = "success";
return(RedirectToAction(nameof(Index)));
}
return(View(tb_WMS_KhachHang));
}
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(""));
}
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MaNhanVien,TenNhanVien,TenDangNhap,MatKhau,GioiTinh,NgaySinh,Email,SoDienthoai,HinhAnh,Kho,Quyen,TrangThai")] tb_WMS_NhanVien tb_WMS_NhanVien, IFormFile HinhAnh)
{
if (HinhAnh != null)
{
var filePath = Path.Combine("wwwroot\\img\\User", HinhAnh.FileName);
using (var stream = new FileStream(filePath, FileMode.Create))
{
await HinhAnh.CopyToAsync(stream);
}
tb_WMS_NhanVien.HinhAnh = HinhAnh.FileName;
}
else
{
var img = (from N in _context.tb_WMS_NhanVien
where N.ID == id
select N.HinhAnh).FirstOrDefault();
tb_WMS_NhanVien.HinhAnh = img;
}
if (id != tb_WMS_NhanVien.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tb_WMS_NhanVien);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tb_WMS_NhanVienExists(tb_WMS_NhanVien.ID))
{
return(NotFound());
}
else
{
throw;
}
}
TempData["success"] = "success";
return(RedirectToAction(nameof(Index)));
}
return(View(tb_WMS_NhanVien));
}
public JsonResult Edit_dg(int dg, int id)
{
if (dg != 0 && id != 0)
{
var chitiet = (from N in _context.tb_WMS_ChiTietPhieuXuat
where N.ID == id
select N).FirstOrDefault();
var imei = chitiet.Imei;
var dg_old = chitiet.GiaBan;
var idxuat = chitiet.IDPhieuXuat;
var imeis = (from S in _context.tb_WMS_IMEI
where S.ID == imei
select S).FirstOrDefault();
imeis.GiaXuat = dg;
chitiet.GiaBan = dg;
_context.Update(imeis);
_context.Update(chitiet);
var phieuxuat = (from N in _context.tb_WMS_PhieuXuat
where N.ID == idxuat
select N).FirstOrDefault();
phieuxuat.TongTien = phieuxuat.TongTien - dg_old + dg;
_context.Update(phieuxuat);
_context.SaveChanges();
return(Json("hello"));
}
return(Json(""));
}
public JsonResult save(string c, tb_WMS_ChiTietKhachTraHang ChiTiet)
{
if (c != "[]")
{
JArray jsonArray = JArray.Parse(c);
var jsonObjects = jsonArray.OfType <JObject>().ToList();
var idtra = int.Parse(jsonObjects[0]["idphieutra"].ToString());
var idxuat = int.Parse(jsonObjects[0]["idphieuxuat"].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_KhachTraHang
where N.ID == idtra
select N).FirstOrDefault();
phieutra.SoLuong = tongsoluong;
phieutra.Tien = tongtien;
phieutra.GhiChu = ghichu;
_context.tb_WMS_KhachTraHang.Update(phieutra);
_context.SaveChanges();
var chitiet = (from N in _context.tb_WMS_ChiTietKhachTraHang
where N.IDTraHang == idtra
select N).ToList();
foreach (var a in chitiet)
{
var imei = a.Imei;
var ctiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat
where N.Imei == imei && N.IDPhieuXuat == idxuat
select N).FirstOrDefault();
ctiet_xuat.TraHang = false;
_context.tb_WMS_ChiTietPhieuXuat.Update(ctiet_xuat);
_context.SaveChanges();
}
foreach (var i in chitiet)
{
_context.tb_WMS_ChiTietKhachTraHang.Remove(i);
_context.SaveChanges();
}
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var idchitiet = int.Parse(jsonObjects[h]["idchitiet"].ToString());
var idend_chitiet = (from u in _context.tb_WMS_ChiTietKhachTraHang
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
if (idchitiet != 0)
{
var chitiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat
where N.ID == idchitiet
select N).FirstOrDefault();
chitiet_xuat.TraHang = true;
_context.Update(chitiet_xuat);
var imei = chitiet_xuat.Imei;
var gia = chitiet_xuat.GiaBan;
var idpbsp = chitiet_xuat.IDPBSP;
ChiTiet.IDPBSP = idpbsp;
ChiTiet.Imei = imei;
ChiTiet.DonGia = gia;
ChiTiet.IDTraHang = idtra;
ChiTiet.ID = idend_chitiet + 1;
_context.tb_WMS_ChiTietKhachTraHang.Add(ChiTiet);
_context.SaveChanges();
}
}
return(Json("hello"));
}
else
{
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 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 TraHang(int id)
{
if (id != 0)
{
var phieutra = (from N in _context.tb_WMS_TraNhaCungCap
where N.ID == id
select N).FirstOrDefault();
var idnhap = phieutra.IDNhap;
phieutra.TrangThai = 1;
var phieunhap = (from N in _context.tb_WMS_PhieuNhap
where N.ID == idnhap
select N).FirstOrDefault();
_context.tb_WMS_TraNhaCungCap.Update(phieutra);
var chitiet_tra = (from N in _context.tb_WMS_ChiTietTraNhaCungCap
where N.IDTraHang == id
select N).ToList();
foreach (var i in chitiet_tra)
{
var imei = i.Imei;
var gia = i.DonGia;
var idpbsp = i.IDPBSP;
var imei_kho = (from N in _context.tb_WMS_IMEI
where N.Imei == imei
select N).FirstOrDefault();
_context.tb_WMS_IMEI.Remove(imei_kho);
phieunhap.TraHang = false;
phieunhap.SoLuong -= 1;
phieunhap.TongTien -= gia;
_context.tb_WMS_PhieuNhap.Update(phieunhap);
var chitiet_nhap = (from N in _context.tb_WMS_ChiTietPhieuNhap
where N.IDPN == idnhap && N.IDPBSP == idpbsp
select N).FirstOrDefault();
var imei_nhap = chitiet_nhap.Imei;
var imei_thaydoi = "";
var item = imei_nhap.Split(';');
for (var h = 0; h < item.Length; h++)
{
if (item[h] != "")
{
if (!imei.Contains(item[h]))
{
imei_thaydoi += item[h] + ";";
}
}
}
if (imei_thaydoi != "")
{
chitiet_nhap.SoLuong -= 1;
chitiet_nhap.ThanhTien -= gia;
chitiet_nhap.Imei = imei_thaydoi;
_context.tb_WMS_ChiTietPhieuNhap.Update(chitiet_nhap);
}
else
{
_context.tb_WMS_ChiTietPhieuNhap.Remove(chitiet_nhap);
}
_context.SaveChanges();
}
var soluong_phieunhap = phieunhap.SoLuong;
if (soluong_phieunhap == 0)
{
phieunhap.TrangThai = 2;
phieunhap.GhiChu = "Trả lại hết hàng cho nhà cung cấp";
_context.Update(phieunhap);
_context.SaveChanges();
}
TempData["success"] = "success";
return(Json("OK"));
}
else
{
return(Json(""));
}
}
public JsonResult Save(string c, tb_WMS_KhachTraHang KhachTraHang, tb_WMS_ChiTietKhachTraHang ChiTiet)
{
if (c != "[]")
{
var idend = (from u in _context.tb_WMS_KhachTraHang
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 idxuat = 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();
KhachTraHang.IDXuat = idxuat;
KhachTraHang.SoLuong = tongsoluong;
KhachTraHang.Tien = tongtien;
DateTime date = DateTime.Now;
KhachTraHang.NgayLap = date;
KhachTraHang.MaTraHang = "CR" + (idend + 1);
KhachTraHang.ID = idend + 1;
KhachTraHang.TrangThai = 0;
KhachTraHang.IDNhanVien = nhanvien;
KhachTraHang.GhiChu = ghichu;
_context.tb_WMS_KhachTraHang.Add(KhachTraHang);
_context.SaveChanges();
var phieuxuat = (from N in _context.tb_WMS_PhieuXuat
where N.ID == idxuat
select N).FirstOrDefault();
phieuxuat.TraHang = true;
_context.Update(phieuxuat);
var q = jsonObjects.Count();
for (var h = 0; h < q; h++)
{
var idchitiet = int.Parse(jsonObjects[h]["idchitiet"].ToString());
var idtrahang = idend + 1;
var idend_chitiet = (from u in _context.tb_WMS_ChiTietKhachTraHang
orderby u.ID descending
select u.ID).Take(1).FirstOrDefault();
if (idchitiet != 0)
{
var chitiet_xuat = (from N in _context.tb_WMS_ChiTietPhieuXuat
where N.ID == idchitiet
select N).FirstOrDefault();
chitiet_xuat.TraHang = true;
_context.Update(chitiet_xuat);
var imei = chitiet_xuat.Imei;
var gia = chitiet_xuat.GiaBan;
var idpbsp = chitiet_xuat.IDPBSP;
ChiTiet.IDPBSP = idpbsp;
ChiTiet.Imei = imei;
ChiTiet.DonGia = gia;
ChiTiet.IDTraHang = idtrahang;
ChiTiet.ID = idend_chitiet + 1;
_context.tb_WMS_ChiTietKhachTraHang.Add(ChiTiet);
_context.SaveChanges();
}
}
//var soluong_phieuxuat = phieuxuat.SoLuong;
//if () { }
return(Json(idend + 1));
}
else
{
return(Json(""));
}
}