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