public IHttpActionResult kiemTraYeuThich(int idSanPham, int IdKhachHang)
{
try
{
if (IdKhachHang == 0)
{
return(StatusCode(HttpStatusCode.NoContent));
}
SanPhamYeuThich sp = db.SanPhamYeuThiches.FirstOrDefault(e => e.id_san_pham == idSanPham && e.id_khach_hang == IdKhachHang);
if (sp == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
var spYT = new
{
id_yeu_thich = sp.id_yeu_thich,
id_san_pham = sp.id_san_pham,
id_khach_hang = sp.id_khach_hang
};
return(Ok(spYT));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult insertNewSanPhamYeuThich([FromBody] SanPhamYeuThich sanPhamYeuThich)
{
try
{
SanPhamYeuThich sp = db.SanPhamYeuThiches.FirstOrDefault(x => x.id_san_pham == sanPhamYeuThich.id_san_pham &&
x.id_khach_hang == sanPhamYeuThich.id_khach_hang);
if (sp != null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
db.SanPhamYeuThiches.InsertOnSubmit(sanPhamYeuThich);
db.SubmitChanges();
var tam = new
{
id_yeu_thich = sanPhamYeuThich.id_yeu_thich,
id_san_pham = sanPhamYeuThich.id_san_pham,
id_khach_hang = sanPhamYeuThich.id_khach_hang,
};
return(Ok(tam));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult ThongTinSanPham(int?id, bool?over)
{
if (over == true)
{
ViewBag.message = Convert.ToString("Số lượng mua vượt quá số lượng tồn");
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Album album = db.Albums.Find(id);
if (album == null)
{
return(HttpNotFound());
}
var SanPhamYeuThich = db.SanPhamYeuThiches.Where(x => x.AlbumID == album.AlbumID).FirstOrDefault();
Session["AlbumID"] = album.AlbumID;
if (SanPhamYeuThich == null)
{
ViewBag.sanphamyeuthich = true;
}
else
{
if (Session["userName"] == null)
{
ViewBag.sanphamyeuthich = true;
}
else
{
SanPhamYeuThich sanpham = db.SanPhamYeuThiches.Find(SanPhamYeuThich.SanPhamYeuThichID);
if (sanpham.TrangThai == 0)
{
ViewBag.sanphamyeuthich = true;
}
else
{
ViewBag.sanphamyeuthich = false;
}
}
}
var albums = db.Albums.Include(a => a.TacGia).Include(a => a.TheLoai);
var AlbumList = albums.Where(x => x.AlbumID != album.AlbumID).Take(4);
var BinhLuanList = db.BinhLuans.Where(x => x.AlbumID == id);
AlbumDetailAndListAlbum all = new AlbumDetailAndListAlbum
{
Album = album,
ListAlbum = AlbumList.ToList(),
BinhLuan = BinhLuanList.ToList()
};
return(View(all));
}
public IHttpActionResult deleteSanPhamYeuThich(int id)
{
try
{
SanPhamYeuThich sp = db.SanPhamYeuThiches.FirstOrDefault(x => x.id_yeu_thich == id);
if (sp == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
db.SanPhamYeuThiches.DeleteOnSubmit(sp);
db.SubmitChanges();
return(Ok());
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public ActionResult ThemVaoYeuThich(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Album album = db.Albums.Find(id);
if (album == null)
{
return(HttpNotFound());
}
if (Session["userName"] == null)
{
return(RedirectToAction("DangNhap"));
}
var SanPhamYeuThich = db.SanPhamYeuThiches.Where(x => x.AlbumID == album.AlbumID).FirstOrDefault();
SanPhamYeuThich sanphamyeuthich = new SanPhamYeuThich();
sanphamyeuthich.AlbumID = album.AlbumID;
sanphamyeuthich.KhachHangID = Convert.ToInt32(Session["KhachHangID"]);
if (SanPhamYeuThich == null)
{
sanphamyeuthich.TrangThai = 1;
db.SanPhamYeuThiches.Add(sanphamyeuthich);
db.SaveChanges();
}
else
{
SanPhamYeuThich sanpham = db.SanPhamYeuThiches.Find(SanPhamYeuThich.SanPhamYeuThichID);
if (sanpham.TrangThai == 0)
{
sanpham.TrangThai = 1;
}
else
{
sanpham.TrangThai = 0;
}
db.Entry(sanpham).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("ThongTinSanPham", "Home", new { id = album.AlbumID }));
}
public IHttpActionResult SanPham(int idSanPham, int idKhachHang)
{
try
{
SanPham sp = db.SanPhams.FirstOrDefault(x => x.id_san_pham == idSanPham && x.trang_thai == true);
SanPham tam = new SanPham();
SanPhamYeuThich spyt = db.SanPhamYeuThiches.FirstOrDefault(e => e.id_san_pham == idSanPham && e.id_khach_hang == idKhachHang);
int idlove = 0;
if (spyt != null)
{
idlove = spyt.id_yeu_thich;
}
if (sp == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
tam.id_san_pham = sp.id_san_pham;
tam.id_danh_muc = sp.id_danh_muc;
tam.ten_sp = sp.ten_sp;
tam.so_luong = sp.so_luong;
tam.url_hinh_chinh = "http://www.3anhem.somee.com" + sp.url_hinh_chinh;
tam.mo_ta = sp.mo_ta;
tam.phan_tram_km = sp.phan_tram_km;
tam.gia_sp = sp.gia_sp;
tam.gia_km = sp.gia_km;
var sanPham = new
{
SanPham = tam,
idYeuThich = idlove
};
return(Ok(sanPham));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
/// <summary>
/// There are no comments for SanPhamYeuThich in the schema.
/// </summary>
public void AddToSanPhamYeuThich(SanPhamYeuThich sanPhamYeuThich)
{
base.AddObject("SanPhamYeuThich", sanPhamYeuThich);
}
/// <summary>
/// Create a new SanPhamYeuThich object.
/// </summary>
/// <param name="sPYT_ID">Initial value of SPYT_ID.</param>
public static SanPhamYeuThich CreateSanPhamYeuThich(int sPYT_ID)
{
SanPhamYeuThich sanPhamYeuThich = new SanPhamYeuThich();
sanPhamYeuThich.SPYT_ID = sPYT_ID;
return sanPhamYeuThich;
}
