public ActionResult Delete(int id) { using (DBNoiThat db = new DBNoiThat()) { try { SanPhamViewModel sp = (from s in db.SanPhams join d in db.DanhMucSanPhams on s.IDDanhMucSP equals d.ID join nh in db.NhomSanPhams on d.IDNhomSP equals nh.ID where (s.ID == id) select new SanPhamViewModel { PathImg = "~/storage/" + nh.Ten_slug + "/" + d.Ten_slug + "/" + s.Ten_img }).FirstOrDefault(); //Xóa file ảnh System.IO.File.Delete(Server.MapPath(sp.PathImg)); SanPham ss = db.SanPhams.Where(p => p.ID == id).FirstOrDefault(); db.SanPhams.Remove(ss); db.SaveChanges(); return(Json(new { success = true, message = "Xóa dữ liệu thành công!" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { success = false, message = "Xóa dữ liệu thất bại!" }, JsonRequestBehavior.AllowGet)); } } }
public IHttpActionResult GetListSanPhamByMaHoaDon(int maHoaDon) { using (var db = new QuanLyTraSuaEntities()) { var maLuaChon = db.HoaDonChiTiets.SingleOrDefault(v => v.MaHoaDon == maHoaDon).MaLuaChon; var maSanPham = db.LuaChons.Where(v => v.MaLuaChon == maLuaChon).ToList(); var result = new List <SanPhamViewModel>(); maSanPham.ForEach(v => { var temp = db.SanPhams.Single(n => n.MaSanPham == v.MaSanPham); var resultItem = new SanPhamViewModel() { MaSanPham = temp.MaSanPham, TenSanPham = temp.TenSanPham, KichCo = temp.KichCo, DonGia = temp.DonGia, HinhAnh = temp.HinhAnh, MaChuDe = temp.MaChuDe }; result.Add(resultItem); }); return(Ok(result.ToList())); } }
public bool ThemMoi(SanPhamViewModel _sanPham, string fileAnh) { bool result = false; SanPham sanPham = new SanPham(); using (var db = new MinistopDbContext()) { using (var trans = db.Database.BeginTransaction()) { try { sanPham.TenSanPham = _sanPham.TenSanPham; sanPham.LoaiSanPhamID = _sanPham.LoaiSanPhamID; sanPham.ThuongHieu = _sanPham.ThuongHieu; sanPham.HinhAnh = fileAnh; sanPham.GiaBan = _sanPham.GiaBan; sanPham.GiaNhap = _sanPham.GiaNhap; sanPham.SoLuong = _sanPham.SoLuong; sanPham.NgayThem = DateTime.Now; sanPham.GhiChu = _sanPham.GhiChu; sanPham.TinhTrang = true; db.SanPhams.Add(sanPham); db.SaveChanges(); trans.Commit(); result = true; } catch (Exception) { trans.Rollback(); } } } return(result); }
public IHttpActionResult GetSanPhamById(int id) { SanPhamViewModel sanpham = null; using (var ctx = new BANHANGONLINEEntities5()) { sanpham = ctx.SANPHAMs.Where(s => s.MASP == id) .Select(s => new SanPhamViewModel() { MASP = s.MASP, TENSP = s.TENSP, CHITIET = s.CHITIET, IMAGES = s.IMAGES, TRANGTHAI = s.TRANGTHAI, GIA = s.GIA, GIAMGIA = s.GIAMGIA, SL = s.SL, MASX = s.MASX, MALOAI = s.MALOAI }).FirstOrDefault <SanPhamViewModel>(); } if (sanpham == null) { return(NotFound()); } return(Ok(sanpham)); }
public bool CapNhat(SanPhamViewModel _sanPham) { bool result = false; using (var db = new MinistopDbContext()) { var sanPham = db.SanPhams.Find(_sanPham.ID); using (var trans = db.Database.BeginTransaction()) { try { sanPham.TenSanPham = _sanPham.TenSanPham; sanPham.LoaiSanPhamID = _sanPham.LoaiSanPhamID; sanPham.ThuongHieu = _sanPham.ThuongHieu; sanPham.GiaBan = _sanPham.GiaBan; sanPham.GiaNhap = _sanPham.GiaNhap; sanPham.SoLuong = _sanPham.SoLuong; sanPham.NgayCapNhat = DateTime.Now; sanPham.GhiChu = _sanPham.GhiChu; sanPham.TinhTrang = true; db.SaveChanges(); trans.Commit(); result = true; } catch (Exception) { trans.Rollback(); } } return(result); } }
// GET: api/SanPhams public IHttpActionResult GetSanPhams() { var sanPham = db.SanPhams; var sanPhamList = new List <SanPhamViewModel>(); if (sanPham != null) { sanPham.ToList().ForEach(v => { var tmp = new SanPhamViewModel() { MaSanPham = v.MaSanPham, TenSanPham = v.TenSanPham, KichCo = v.KichCo, DonGia = v.DonGia, HinhAnh = ImageTask.GetImage(v.HinhAnh), MaChuDe = v.MaChuDe }; sanPhamList.Add(tmp); }); return(Ok(sanPhamList.ToList())); } else { return(BadRequest()); } }
public JsonResult Save(string SanPham, HttpPostedFileBase file) { SanPhamViewModel sp = JsonConvert.DeserializeObject <SanPhamViewModel>(SanPham); if (file != null) { sp.HinhAnh = ImageHelper.saveImage(file); } var kiemtra = false; if (sp.ID == 0) { kiemtra = spDAO.insert(sp); //thêm sản phẩm } else { kiemtra = spDAO.update(sp); //cập nhật sản phẩm } return(Json(new { status = kiemtra })); }
public ActionResult Create(SanPhamViewModel collection) { try { // TODO: Add insert logic here if (ModelState.IsValid) { var result = sanPhamService.Add(collection); if (result > 0) { return(Json(new { Id = result }, JsonRequestBehavior.AllowGet)); } return(View(collection)); } var loaiSP = loaiSPService.ListAll(); SelectList listloaiSP = new SelectList(loaiSP, "MaLoai", "TenLoai"); ViewBag.listloaiSP = listloaiSP; return(View(collection)); } catch { return(View()); } }
public ActionResult SearchResult(string keyword) { ViewBag.Key = keyword; var model = new SanPhamViewModel().Search(keyword); ViewBag.KeyWord = keyword; return(View(model)); }
public JsonResult ListName(string keyword) { var data = new SanPhamViewModel().ListNameProduct(keyword); return(Json(new { data = data, status = true }, JsonRequestBehavior.AllowGet)); }
public IActionResult ChinhSua( SanPhamViewModel model, IFormFile AnhDaiDien, IFormCollection fc, IFormFile productImages1, IFormFile productImages2, IFormFile productImages3) { model.MaSp = fc["MaSp"]; SanPhamViewModel a = _spService.GetById(fc["MaSp"]); if (AnhDaiDien == null) { model.AnhDaiDien = a.AnhDaiDien; } else { model.AnhDaiDien = FileHelper.UploadedFile(AnhDaiDien, "ProductAvatar"); } if (ModelState.IsValid) { model.Ishot = Convert.ToBoolean(fc["isHot"].ToString().Split(',')[0]); model.Isnew = Convert.ToBoolean(fc["isNew"].ToString().Split(',')[0]); model.Status = fc["status"].ToString().Contains("on") ? 1 : 0; _spService.Update(model, fc["MaSp"]); AnhSanPhamViewModel pic = _aspService.GetByIdSp(model.MaSp); if (productImages1 != null) { pic.Anh1 = FileHelper.UploadedFile(productImages1, "ProductImages"); } if (productImages2 != null) { pic.Anh2 = FileHelper.UploadedFile(productImages2, "ProductImages"); } if (productImages3 != null) { pic.Anh3 = FileHelper.UploadedFile(productImages3, "ProductImages"); } _aspService.UpdateAnhSP(pic); foreach (var tskt in _tsktService.GetThongSoKiThuat(model.MaSp)) { tskt.GiaTri = fc[tskt.ThongSo]; _tsktService.UpdateTSKT(tskt); } _spService.SaveChange(); return(RedirectToAction("QuanLy", "Admin", new { id = model.LoaiSp }).WithSuccess("Thành công", "Sản phẩm đã được sửa. ID: " + model.MaSp)); } else { return(View(model)); } }
public SanPhamViewModel Details(int?id) { var SanPham = context.SANPHAMs .Include(t => t.HINHs) .Include(t => t.GIASANPHAMs) .OrderByDescending(t => t.KHUYENMAI.NgayBatDau) .FirstOrDefault(t => t.TrangThai != false && t.Id_SanPham == id /*&& t.KHUYENMAI.NgayKetThuc >= DateTime.Now && t.KHUYENMAI.NgayBatDau <= DateTime.Now*/); if (SanPham == null) { return(null); } var result = new SanPhamViewModel(); if (SanPham.KHUYENMAI?.NgayBatDau <= DateTime.Now && SanPham.KHUYENMAI?.NgayKetThuc >= DateTime.Now) { result.GiaTriKhuyenMai = SanPham.KHUYENMAI.GiaTriKhuyenMai; result.TenKhuyenMai = SanPham.KHUYENMAI.TenKhuyenMai; } result.MaSanPham = SanPham.Id_SanPham; result.MaLoai = SanPham.Id_LoaiSanPham; result.TenSanPham = SanPham.TenSanPham; result.GiaSP = SanPham.GIASANPHAMs.Where(t => t.TrangThai != false).OrderByDescending(t => t.NgayLap).Select(t => t.GiaBan).FirstOrDefault(); result.DVT = SanPham.DonViTinh; result.MauSac = SanPham.MauSac; result.VatLieu = SanPham.VatLieu; result.SoLuongTon = SanPham.SoLuongTon; result.KichThuoc = SanPham.KichThuoc; result.XuatXu = SanPham.XuatXu; result.TenLoai = SanPham.LOAISANPHAM.TenLoai; result.HinhAnh = SanPham.HinhAnh ?? string.Empty; result.BaoHanh = SanPham.BaoHanh; result.MoTa = SanPham.Mota; if (!string.IsNullOrEmpty(SanPham.HinhAnh)) { result.HinhAnhs.Add(new HinhAnhViewModel() { Link = SanPham.HinhAnh }); } if (SanPham.HINHs?.Count > 0) { result.HinhAnhs.AddRange(SanPham.HINHs.Select(t => new HinhAnhViewModel() { Link = t.Link, })); } return(result); }
public SanPhamController(ApplicationDbContext db, HostingEnvironment hostingEnvironment) { _db = db; _hostingEnvironment = hostingEnvironment; sanPhamVM = new SanPhamViewModel() { MatHangs = _db.MatHangs.ToList(), Tags = _db.Tags.ToList(), NhaCungCaps = _db.NhaCungCaps.ToList(), SanPham = new Models.SanPham() }; }
public IActionResult Them(SanPhamViewModel model, IFormFile AnhDaiDien, IFormCollection fc, IFormFile productImages1, IFormFile productImages2, IFormFile productImages3 ) { if (ModelState.IsValid) { model.AnhDaiDien = FileHelper.UploadedFile(AnhDaiDien, "ProductAvatar"); model.SoLuotXemSp = 0; model.Ishot = Convert.ToBoolean(fc["isHot"].ToString().Split(',')[0]); model.Isnew = Convert.ToBoolean(fc["isNew"].ToString().Split(',')[0]); _spService.Add(model); AnhSanPhamViewModel pic = new AnhSanPhamViewModel() { MaSp = model.MaSp, Anh1 = productImages1 != null?FileHelper.UploadedFile(productImages1, "ProductImages") : null, Anh2 = productImages2 != null?FileHelper.UploadedFile(productImages2, "ProductImages") : null, Anh3 = productImages3 != null?FileHelper.UploadedFile(productImages3, "ProductImages") : null, }; _aspService.Add(pic); ThongSoKiThuatViewModel tskt; List <ThongSoViewModel> listTS = _tsService.GetThongSo(model.LoaiSp).ToList(); for (int i = 0; i < listTS.Count(); i++) { tskt = new ThongSoKiThuatViewModel() { MaSp = model.MaSp, ThongSo = listTS[i].MaThongSo, GiaTri = fc[listTS[i].MaThongSo], }; //context.ThongSoKiThuat.AddAsync(tskt); //context.SaveChanges(); _tsktService.AddTSKT(tskt); tskt = null; } _spService.SaveChange(); return(RedirectToAction("QuanLy", "Admin", new { id = model.LoaiSp }).WithSuccess("Thành công", "Sản phẩm đã được thêm. ID:" + model.MaSp)); } else { ModelState.AddModelError("", "aaa"); ViewData["MaLoai"] = model.LoaiSp; return(View(model)); } }
// public IHttpActionResult PostNewSanPham(SanPhamViewModel sanpham) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } using (var ctx = new BANHANGONLINEEntities5()) { ctx.sp_ThemSanPham(sanpham.TENSP, sanpham.GIA, sanpham.CHITIET, sanpham.IMAGES, sanpham.TRANGTHAI, sanpham.GIAMGIA, sanpham.SL, sanpham.MASX, sanpham.MALOAI); ctx.SaveChanges(); } return(Ok()); }
public PartialViewResult ListProductByCategory(int id, int?Page) { var sanpham = new SanPhamViewModel().ListProductByCategory(id); int pageSize = 12; //Tao bien so trang int pageNum = (Page ?? 1); if (sanpham == null) { ViewBag.sanpham = "Không có sản phẩm nào"; } //Lấy top 5 Album bán chạy nhất return(PartialView(sanpham.ToPagedList(pageNum, pageSize))); }
public ActionResult ThemMoi(SanPhamViewModel _sanPham, HttpPostedFileBase HinhAnh) { string path = ""; if (HinhAnh != null && HinhAnh.ContentLength > 0) { string extension = Path.GetExtension(HinhAnh.FileName); if (extension.Equals(".jpg") || extension.Equals(".png") || extension.Equals(".jpeg")) { path = Path.Combine(Server.MapPath("~/Img/SanPham/"), HinhAnh.FileName); HinhAnh.SaveAs(path); bool result = sanPham.ThemMoi(_sanPham, HinhAnh.FileName); } } return(RedirectToAction("Index")); }
//tim kiem san pham public ActionResult TimKiem(string keyword, int?page) { int pageNumber = (page ?? 1); //keyword = RejectMarks(keyword); IList <Menu> sanPhams = _menuRepository.TimKiemByTenAndBarcode(keyword.Trim().ToLower()); SanPhamViewModel timkiem = new SanPhamViewModel() { Menus = sanPhams.ToPagedList(pageNumber, pageSize), soluongtimduoc = sanPhams.Count(), }; ViewData["key"] = keyword; return(View(timkiem)); }
public ActionResult Edit(SanPhamViewModel sanpham) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:53017/api/nhanvien"); //HTTP POST var putTask = client.PutAsJsonAsync <SanPhamViewModel>("sanpham", sanpham); putTask.Wait(); var result = putTask.Result; if (result.IsSuccessStatusCode) { return(RedirectToAction("Index")); } } return(View(sanpham)); }
public IActionResult ChinhSua(string Id) { //SanPham sp = context.SanPham.Find(Id); ViewBag.NhaSanXuat = _nsxService.GetNhaSanXuats(); ViewBag.NhaCungCap = _nccService.GetNhaCungCaps(); //ViewBag.ThongSo = _spRepository.GetThongSo(id); var listTS = _tsService.GetThongSo(Id); foreach (var item in listTS) { item.MaLoai = _tsktService.GetTen(_spService.GetById(Id).MaSp, item.MaThongSo); } ViewBag.ThongSo = listTS; ViewBag.AnhSP = _aspService.GetByIdSp(Id); SanPhamViewModel sp = _spService.GetById(Id); return(View(sp)); }
// GET: Admin/SanPham public async Task <IActionResult> Index(string searchString) { IQueryable <string> genreQuery = from m in _context.SanPhamModel select m.TenSP; var sanphams = from m in _context.SanPhamModel select m; if (!string.IsNullOrEmpty(searchString)) { sanphams = sanphams.Where(s => s.TenSP.Contains(searchString)); } var SanPhamViewModel = new SanPhamViewModel { SPs = new SelectList(await genreQuery.Distinct().ToListAsync()), SanPhams = await sanphams.ToListAsync() }; return(View(SanPhamViewModel)); }
// GET: SanPhamView public ActionResult Index(int itemId = 0) { if (itemId == 0) { return(RedirectToAction("Index", "HomeView")); } SanPhamViewModel model = new SanPhamViewModel(); model.SanPhams = db.SanPhams.SingleOrDefault(e => e.MaSP == "itemId"); if (model.SanPhams == null) { return(RedirectToAction("Index", "HomeView")); } db.SaveChanges(); // model.SanPhams.HinhSP = db.HinhSP.Where(e => e.MaLoai == "itemId").ToList(); model.related = db.SanPhams.Where(e => e.MaSP == model.SanPhams.MaSP && e.MaSP != model.SanPhams.MaSP).Take(4).OrderBy(e => Guid.NewGuid()).ToList(); return(View(model)); }
public ActionResult create(SanPhamViewModel sanpham, HttpPostedFileBase fileUpload) { if (fileUpload == null) { ViewBag.ThongBao = "Chon Anh"; return(View()); } var fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/Images"), fileName); if (System.IO.File.Exists(path)) { ViewBag.ThongBao = "Images exists"; } else { fileUpload.SaveAs(path); } sanpham.IMAGES = fileUpload.FileName; using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:53017/api/sanpham"); // HTTP POST var postTask = client.PostAsJsonAsync <SanPhamViewModel>("sanpham", sanpham); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { return(RedirectToAction("Index", "sanpham")); } } ModelState.AddModelError(string.Empty, "Server error. Please contact administractor"); return(View(sanpham)); }
public ActionResult BeginEdit(int id) { using (DBNoiThat db = new DBNoiThat()) { SanPhamViewModel sp = (from s in db.SanPhams join n in db.NhaCungCaps on s.IDNCC equals n.ID join d in db.DanhMucSanPhams on s.IDDanhMucSP equals d.ID join nh in db.NhomSanPhams on d.IDNhomSP equals nh.ID where (s.ID == id) select new SanPhamViewModel { ID = s.ID, Ten = s.Ten, IDNCC = s.IDNCC, IDDM = s.IDDanhMucSP, Gia = s.Gia, Mota = s.MoTa }).FirstOrDefault(); return(Json(sp, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(SanPhamViewModel collection) { try { if (ModelState.IsValid) { // TODO: Add update logic here var result = sanPhamService.Update(collection); if (result == false) { return(HttpNotFound()); } return(Json("success")); } return(View(collection)); } catch { return(View()); } }
public int Add(SanPhamViewModel model) { var sanPham = new SANPHAM { TenSanPham = model.TenSanPham, SoLuongTon = 0, XuatXu = model.XuatXu, VatLieu = model.VatLieu, Mota = model.MoTa, MauSac = model.MauSac, Id_LoaiSanPham = model.MaLoai, KichThuoc = model.KichThuoc, CREATED_DATE = DateTime.Now, CREATED_BY = HttpContext.Current.User.Identity.Name }; //sanPham.HinhAnh = model.HinhAnh; context.SANPHAMs.Add(sanPham); context.SaveChanges(); return(sanPham.Id_SanPham); }
public IHttpActionResult GetSanPhams(int id) { var sanPham = db.SanPhams.SingleOrDefault(v => v.MaSanPham == id); if (sanPham == null) { return(NotFound()); } else { var sanPhamViewModel = new SanPhamViewModel() { MaSanPham = sanPham.MaSanPham, TenSanPham = sanPham.TenSanPham, KichCo = sanPham.KichCo, DonGia = sanPham.DonGia, HinhAnh = ImageTask.GetImage(sanPham.HinhAnh), MaChuDe = sanPham.MaChuDe }; return(Ok(sanPhamViewModel)); } }
public bool Update(SanPhamViewModel model) { SANPHAM sanPham = context.SANPHAMs.FirstOrDefault(t => t.TrangThai != false && t.Id_SanPham == model.MaSanPham); if (sanPham == null) { return(false); } sanPham.TenSanPham = model.TenSanPham; sanPham.SoLuongTon = model.SoLuongTon; sanPham.XuatXu = model.XuatXu; sanPham.VatLieu = model.VatLieu; sanPham.Mota = model.MoTa; sanPham.MauSac = model.MauSac; sanPham.Id_LoaiSanPham = model.MaLoai; sanPham.KichThuoc = model.KichThuoc; sanPham.HinhAnh = model.HinhAnh; sanPham.DonViTinh = model.DVT; sanPham.UPDATED_BY = HttpContext.Current.User.Identity.Name; sanPham.UPDATED_DATE = DateTime.Now; context.SaveChanges(); return(true); }
public ActionResult Edit(int id) { SanPhamViewModel sanpham = null; using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:53017/api/"); // HTTP GET var responseTask = client.GetAsync("sanpham?id=" + id.ToString()); responseTask.Wait(); var result = responseTask.Result; if (result.IsSuccessStatusCode) { var readTask = result.Content.ReadAsAsync <SanPhamViewModel>(); readTask.Wait(); sanpham = readTask.Result; } } return(View(sanpham)); }
// PUT: // PUT public IHttpActionResult PutSaanPham(SanPhamViewModel sanpham) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } using (var ctx = new BANHANGONLINEEntities5()) { var existingSanPham = ctx.SANPHAMs.Where(s => s.MASP == sanpham.MASP).FirstOrDefault <SANPHAM>(); if (existingSanPham != null) { ctx.sp_SuaSanPham(sanpham.TENSP, sanpham.GIA, sanpham.CHITIET, sanpham.IMAGES, sanpham.TRANGTHAI, sanpham.GIAMGIA, sanpham.SL, sanpham.MALOAI, sanpham.MASP); ctx.SaveChanges(); } else { return(NotFound()); } } return(Ok()); }