public static IEnumerable <V_GioHang> ListProductCart(string maTaiKhoan)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
return(db.Query <V_GioHang>("select * from V_GioHang where MaTaiKhoan=@0", maTaiKhoan));
}
}
public static string GetTenNhaSanXuat(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaNhaSanXuat from SanPham where MaSanPham = @0", id).MaNhaSanXuat;
return(db.SingleOrDefault <NhaSanXuat>("select TenNhaSanXuat from NhaSanXuat where MaNhaSanXuat = @0", Ma).TenNhaSanXuat);
}
public static string GetTenNhaCungCap(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaNhacungCap from SanPham where MaSanPham = @0", id).MaNhaCungCap;
return(db.SingleOrDefault <NhaCungCap>("select TenNhaCungCap from NhaCungCap where MaNhaCungCap = @0", Ma).TenNhaCungCap);
}
public static IEnumerable <LoaiSanPham> ListProductType()
{
using (var db = new ASP_OnlineShopConnectionDB())
{
return(db.Query <LoaiSanPham>("select * from LoaiSanPham where DaXoa=0"));
}
}
public static IEnumerable <NhaSanXuat> ListProducer()
{
using (var db = new ASP_OnlineShopConnectionDB())
{
return(db.Query <NhaSanXuat>("select * from NhaSanXuat where DaXoa=0"));
}
}
public static void Delete(int id)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
db.Execute("delete GioHang where Id=@0", id);
}
}
public static IEnumerable <BinhLuan> DanhSach(int MaSanPham)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
return(db.Query <BinhLuan>("select * from BinhLuan where MaSanPham = @0 order by Ngay desc", MaSanPham));
}
}
public static void UpdatePlus(int id, int soLuong)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
db.Execute("update GioHang set [SoLuong] = @0 where Id=@1", soLuong + 1, id);
}
}
public static string GetTenLoaiSanPham(int id)
{
var db = new ASP_OnlineShopConnectionDB();
var Ma = db.SingleOrDefault <SanPham>("select MaLoaiSanPham from SanPham where MaSanPham = @0", id).MaLoaiSanPham;
return(db.SingleOrDefault <LoaiSanPham>("select TenLoaiSanPham from LoaiSanPham where MaLoaiSanPham = @0", Ma).TenLoaiSanPham);
}
public static IEnumerable <HinhAnh> listHinhAnh(int id)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
return(db.Query <HinhAnh>("Select * from HinhAnh where MaSanPham = @0", id));
}
}
public static void BuyNow(string mataikhoan)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
db.Execute("EXEC usp_InsertChiTietDonHang @@mataikhoan = @0", mataikhoan);
//db.Fetch<dynamic>("EXEC usp_InsertChiTietDonHang @0", mataikhoan);
}
}
public ActionResult Edit(int id, SanPham sp)
{
// TODO: Add update logic here
using (var db = new ASP_OnlineShopConnectionDB())
{
db.Update <SanPham>("SET TenSanPham=@0, GiaBan=@1, SoLuong=@2, NgayNhap=@3, HinhUrl=@4, MoTa=@5, DaXoa=@6 WHERE MaSanPham=@7", sp.TenSanPham, sp.GiaBan, sp.SoLuong, sp.NgayNhap, sp.HinhUrl, sp.MoTa, sp.DaXoa, id);
}
return(RedirectToAction("Index"));
}
public ActionResult Create(SanPham sp, HinhAnh ha)
{
try
{
// TODO: Add update logic here
using (var db = new ASP_OnlineShopConnectionDB())
{
if (HttpContext.Request.Files.Count > 0)
{
if (HttpContext.Request.Files.Count != 3)
{
return(Content("<script language='javascript' type='text/javascript'>alert('Vui lòng chọn 3 hình sp!');</script>"));
}
else
{
var hpf = HttpContext.Request.Files[0];
if (hpf.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string nameImage = fileName + ".jpg";
string fullPathWithFileName = "/images/product/" + nameImage;
hpf.SaveAs(Server.MapPath(fullPathWithFileName));
sp.HinhUrl = nameImage;
}
db.Insert(sp);
var query = db.Query <SanPham>("SELECT * FROM SanPham ORDER BY MaSanPham DESC");
var id = query.First().MaSanPham;
for (int i = 0; i < 3; i++)
{
var hpf2 = HttpContext.Request.Files[i];
if (hpf2.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string nameImage = fileName + ".jpg";
string fullPathWithFileName = "/images/products/" + nameImage;
hpf2.SaveAs(Server.MapPath(fullPathWithFileName));
ha.TenHinhAnh = nameImage;
ha.MaSanPham = id;
db.Insert(ha);
}
}
}
}
//db.Update<SanPham>("SET TenSanPham=@0, GiaBan=@1, SoLuong=@2 WHERE MaSanPham=@3", sp.TenSanPham, sp.GiaBan, sp.SoLuong, id);
}
//Content("<script language='javascript' type='text/javascript'>alert('Thêm thành công!');</script>");
return(RedirectToAction("Index"));
}
catch
{
//Content("<script language='javascript' type='text/javascript'>alert('Xảy ra lỗi!');</script>");
return(View()); //đây
}
}
public static void Them(string NoiDungBinhLuan, int?MaSanPham, string MaTaiKhoan, string TenTaiKhoan)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
//BinhLuan bl = new BinhLuan();
//bl.MaSanPham = MaSanPham;
//bl.MaTaiKhoan = MaTaiKhoan;
//bl.NoiDungBinhLuan = NoiDung;
//bl.MaThanhVien = 2;
db.Execute("INSERT INTO [dbo].[BinhLuan] ([NoiDungBinhLuan], [MaSanPham],[MaTaiKhoan],[TenTaiKhoan]) VALUES(@0,@1,@2,@3)", NoiDungBinhLuan, MaSanPham, MaTaiKhoan, TenTaiKhoan);
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here
using (var db = new ASP_OnlineShopConnectionDB())
{
//db.Delete("SanPham", id.ToString(), sp);
db.Update <SanPham>("SET DaXoa=1 WHERE MaSanPham=@0", id);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static void AddToCart(int maSanPham, string maTaiKhoan)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
var rs = db.Query <GioHang>("select * from GioHang where MaSanPham=@0", maSanPham);
if (rs.Count() == 0)
{
GioHang gh = new GioHang()
{
MaSanPham = maSanPham,
MaTaiKhoan = maTaiKhoan,
SoLuong = 1
};
db.Insert(gh);
}
else
{
foreach (var item in rs)
{
UpdatePlus(item.Id, item.SoLuong);
}
}
}
}
public static IEnumerable <NhaCungCap> GetListSupplier()
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Query <NhaCungCap>("Select * FROM NhaCungCap"));
}
public static IEnumerable <NhaSanXuat> GetListManufacturer()
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Query <NhaSanXuat>("Select * FROM NhaSanXuat"));
}
public static IEnumerable <LoaiSanPham> GetListCategogy()
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Query <LoaiSanPham>("Select * FROM LoaiSanPham"));
}
public static Page <SanPham> ListProduct(int pageNumber, int itemPerPage)
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Page <SanPham>(pageNumber, itemPerPage, "SELECT * FROM SanPham"));
}
public static Page <SanPham> ListProducer(int pageNumber, int itemPerPage, int id)
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Page <SanPham>(pageNumber, itemPerPage, "SELECT * FROM SanPham WHERE MaNhaSanXuat=" + id));
}
public static IEnumerable <SanPham> List()
{
var db = new ASP_OnlineShopConnectionDB();
return(db.Query <SanPham>("SELECT * FROM SanPham"));
}
public static SanPham ProductDetail(int id)
{
var db = new ASP_OnlineShopConnectionDB();
return(db.SingleOrDefault <SanPham>("select * from SanPham where MaSanPham = @0", id));
}
