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