public ActionResult Create(tbl_SanPham sanPham, HttpPostedFileBase hinhAnh) { bool result = false; if (hinhAnh == null) { sanPham.hinhanh = "SanPham.png"; } else { sanPham.hinhanh = GetImage(hinhAnh, sanPham.tensanpham); } sanPham.tinhtrang = true; sanPham.ngaytao = DatetimeLocation.GetDate(); using (HutechMartDbContext db = new HutechMartDbContext()) { using (var trans = db.Database.BeginTransaction()) { try { db.tbl_SanPham.Add(sanPham); db.SaveChanges(); trans.Commit(); result = true; } catch { trans.Rollback(); } } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public bool Update(tbl_SanPham entity) { try { var sanpham = db.tbl_SanPham.Find(entity.ID); sanpham.sTenSanPham = entity.sTenSanPham; if (string.IsNullOrEmpty(sanpham.sTenSanPhamMeta)) { sanpham.sTenSanPhamMeta = StringHelper.ToUnsignString(entity.sTenSanPham); } sanpham.sImages = entity.sImages; sanpham.dGiaBan = entity.dGiaBan; sanpham.IDDanhMuc = entity.IDDanhMuc; sanpham.sMaSanPham = sanpham.IDDanhMuc + " " + sanpham.ID; sanpham.dGiaKhuyenMai = entity.dGiaKhuyenMai; sanpham.bStatus = entity.bStatus; sanpham.dNgaySua = DateTime.Now; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public IHttpActionResult Puttbl_SanPham(long id, tbl_SanPham tbl_SanPham) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_SanPham.ID) { return(BadRequest()); } db.Entry(tbl_SanPham).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_SanPhamExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Gettbl_SanPham(long id) { tbl_SanPham tbl_SanPham = db.tbl_SanPham.Find(id); if (tbl_SanPham == null) { return(NotFound()); } return(Ok(tbl_SanPham)); }
public ActionResult Create(tbl_SanPham model) { if (ModelState.IsValid) { var session = (UserLogin)Session[CommonConstants.USER_SESSION]; model.sNguoiTao = session.UserName; new SanPhamDAO().Create(model); return(RedirectToAction("Index")); } setViewBag(); return(View()); }
public IHttpActionResult Posttbl_SanPham(tbl_SanPham tbl_SanPham) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_SanPham.Add(tbl_SanPham); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tbl_SanPham.ID }, tbl_SanPham)); }
public IHttpActionResult Deletetbl_SanPham(long id) { tbl_SanPham tbl_SanPham = db.tbl_SanPham.Find(id); if (tbl_SanPham == null) { return(NotFound()); } db.tbl_SanPham.Remove(tbl_SanPham); db.SaveChanges(); return(Ok(tbl_SanPham)); }
public long Create(tbl_SanPham sanpham) { if (string.IsNullOrEmpty(sanpham.sTenSanPhamMeta)) { sanpham.sTenSanPhamMeta = StringHelper.ToUnsignString(sanpham.sTenSanPham); } //sanpham.sImages = "http://192.168.0.107:7500" + sanpham.sImages; sanpham.sMaSanPham = sanpham.IDDanhMuc + " " + sanpham.ID; sanpham.dNgayTao = DateTime.Now; sanpham.iViewCount = 0; db.tbl_SanPham.Add(sanpham); db.SaveChanges(); return(sanpham.ID); }
public ActionResult Update(tbl_SanPham sanPham, HttpPostedFileBase hinhAnh) { bool result = false; using (HutechMartDbContext db = new HutechMartDbContext()) { var _sanPham = db.tbl_SanPham.FirstOrDefault(x => x.id == sanPham.id); if (hinhAnh != null) { Random rd = new Random(); var thayAnh = sanPham.tensanpham + rd.Next(1, 10); sanPham.hinhanh = GetImage(hinhAnh, thayAnh); } else { sanPham.hinhanh = _sanPham.hinhanh; } using (var trans = db.Database.BeginTransaction()) { try { _sanPham.hinhanh = sanPham.hinhanh; _sanPham.id_phanloai = sanPham.id_phanloai; _sanPham.id_xuatxu = sanPham.id_xuatxu; _sanPham.id_donvitinh = sanPham.id_donvitinh; _sanPham.id_khuyenmai = sanPham.id_khuyenmai; _sanPham.tensanpham = sanPham.tensanpham; _sanPham.soluong = sanPham.soluong; _sanPham.giaban = sanPham.giaban; _sanPham.gianhap = sanPham.gianhap; _sanPham.id_nguoicapnhat = sanPham.id_nguoicapnhat; _sanPham.ngaycapnhat = DatetimeLocation.GetDate(); _sanPham.ghichu = sanPham.ghichu; db.SaveChanges(); trans.Commit(); result = true; } catch { trans.Rollback(); } } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(tbl_SanPham model) { if (ModelState.IsValid) { //var dao = new SanPhamDAO(); var session = (UserLogin)Session[CommonConstants.USER_SESSION]; model.sNguoiSua = session.UserName; //var result = dao.Edit(model); new SanPhamDAO().Update(model); return(RedirectToAction("Index")); } setViewBag(model.IDDanhMuc); return(View()); }
//chi tiet san pham public ActionResult ChiTietSP(string ma) { tbl_SanPham sp = mk.tbl_SanPhams.FirstOrDefault(x => x.MaSanPham == ma); return(View(sp)); }