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